Jump to content

DropDown select insert date into database


ManInBlack

Recommended Posts

Hi.

I'm try put select datetime into mysql dbtable ... put it came everytime '1969-12-31 17:00:00'

 

// artal = year // manudur = month // dagur = day // klst = hour // minutur = minutes // sekundur = Sek //

 

$timar="$artal-$manudur-$dagur $klst:$minutur:$sekundur";

$timasetning = date('Y-m-d H:i:s', strtotime($timar)) ;

 

if( $_GET['adgerd'] == 'senda' ) {

			$flokkur = $_POST['flokkur'];
			$tengill = $_POST['tengill'];
			$lysing = $_POST['lysing'];
			$dagur = $_POST['dagur'];
			$manudaur = $_POST['manudur'];
			$klst = $_POST['klst'];
			$minutur = $_POST['minutur'];
			$sekundur = '00';
			$artal = '2009';
			$sent_af = '';
			$timar="$artal-$manudur-$dagur $klst:$minutur:$sekundur";	
			$timasetning = date('Y-m-d H:i:s', strtotime($timar)) ;


				$sql="INSERT INTO tenglar (flokkur,url,texti,dagstimi)
VALUES
('$flokkur','$tengill','$lysing','$timasetning')";

if (!mysql_db_query('hittis_tenglasafn',$sql,$tengja))die('villa kom upp: ' . mysql_error());
  {
  echo 'Ég er ánægður með þig  Tókst að bæta við tengli!';
  
  } 
  
  }

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.