View previous topic :: View next topic |
Author |
Message |
jojo
Joined: 27 Jan 2005 Posts: 1591 Location: insula aurea
|
Posted: 20.12.2005 14:09 Post subject: format datuma |
|
|
pokušavam svakako al nikako da mi promijeni format datuma, redak ide ovako nekako
INSERT INTO tablica (datum,nešto,nešto) VALUES (now(),'".$nešto."','".nl2br($nešto)."')
usput da pitam i koja je funkcija koja uzima iz polja u tablici u kojem je textualni zapis prvih X riječi? |
_________________ deviant / malomorgen / videoholik / cimer fraj |
|
Back to top |
|
|
Granda
Joined: 11 Aug 2005 Posts: 51
|
Posted: 20.12.2005 15:06 Post subject: |
|
|
mislim da je funkcija koju tražiš za insert datuma : curdate()
insert into tablica1 set
date = curdate(),
date2 = curdate();
Druga funkcija koju tražiš je trim()
potraži na PHP site-u. |
|
|
Back to top |
|
|
jojo
Joined: 27 Jan 2005 Posts: 1591 Location: insula aurea
|
Posted: 20.12.2005 15:12 Post subject: |
|
|
nisam baš to htjela nego čisto mijenjati format prikaza datuma i vremena u custom, recimo
u d.m.y. hh:mm
ono drugo što sam tražila je ovo:
$words=split ('[ ]+', $text);
if (sizeof($words) > 50) {
$words = array_slice($words, 0, 50);
}
$novi=implode($words, ' '); |
_________________ deviant / malomorgen / videoholik / cimer fraj |
|
Back to top |
|
|
Granda
Joined: 11 Aug 2005 Posts: 51
|
Posted: 20.12.2005 15:34 Post subject: |
|
|
function dateconvert($date,$func) {
if ($func == 1){ //insert conversion
list($day, $month, $year) = split('[/.-]', $date);
$date = "$year-$month-$day";
return $date;
}
if ($func == 2){ //output conversion
list($year, $month, $day) = split('[-.]', $date);
$date = "$day/$month/$year";
return $date;
} |
|
|
Back to top |
|
|
smasher
Joined: 10 Jan 2004 Posts: 229 Location: Zaprešić
|
Posted: 20.12.2005 15:42 Post subject: |
|
|
jojo wrote: | nisam baš to htjela nego čisto mijenjati format prikaza datuma i vremena u custom, recimo
u d.m.y. hh:mm
|
jel možda misliš ovo?
Code: | $your_date = date("d.m.Y. H:i", time()); |
a možda sam krivo shvatio...
Last edited by smasher on 20.12.2005 15:45; edited 1 time in total |
_________________ http://3DHR.net - Srce hrvatskih 3d artista
http://www.Rhino3DHelp.com |
|
Back to top |
|
|
jojo
Joined: 27 Jan 2005 Posts: 1591 Location: insula aurea
|
|
Back to top |
|
|
|