i insert to 3

rahaiffi

i have a date text field..for example user insert value '26/09/2005'.. i want that data insert in 3 field in table..26 insert in field day, 09 insert in field month and 2005 insert in field year.. How to to this??

rahaiffi

thorpe

bad idea, but...

<?php
  $inputdate = '26/09/2005';
  $splitdate = explode('/',$inputdate);
  // connect to database
  $query = "INSERT INTO tbl (day,month,year) VALUES ('{$splitdate[0]}','{$splitdate[1]}','{$splitdate[2]}');";
?>

matto

split the data: $fields = explode('/', $date);
(1.a - recommended but optional: validate the date useing the checkdate() function)
now create insert statement and do the query:
$sql = "insert into tablename (day,month,year) values(".$fields[0].",".$fields[1].",".$fields[2].")";

rahaiffi

i try this coding but failed insert into the database...

$tarikhprj = explode('/', $date); 
			$sql = "INSERT INTO mohon (hari,bulan,tahun) 
			values(".$tarikhprj[0].",".$tarikhprj[1].",".$tarikhprj[2].")";



		$query = "INSERT INTO mohon VALUES ('','$idpengguna','Belum Disahkan','$nama','$bahagian','$masa','$tarikh','$day','$month','$year','$namapengguna','$bil','$tujuan',
		'','','','$destinasi','$jam','$minit','$waktu','$jam2','$minit2','$waktu2')";
		$result = mysql_db_query($dbname,$query);




				if($result) {
							header("Location:papar2.php?idpengguna=$idpengguna");
							}

matto

hi!

before all the yadda, I just realized you forgot to perform the first "insert into mohon" query: $result = mysql_db_query($dbname, $sql);

but inserting the day-month-year values and the rest which belongs into the "mohon" table should not be done in two steps - the information would not be related!

some details on how the table should be structured:

$sql = "INSERT INTO mohon (hari,bulan,tahun) ...

here I implied that "mohon" is a table with a structure somewhat like this:

TABLE mohon:
FIELD "id" integer, primary key, auto-increment
FIELD "hari" integer
FIELD "bulan" integer
FIELD "tahun" integer
[plus additional fields if you like, which however may be NULL]

under this circumstances you could execute a query like the one I suggested:

$sql = "INSERT INTO mohon (hari,bulan,tahun)
values(".$tarikhprj[0].",".$tarikhprj[1].",".$tarikhprj[2].")";
// don't forget to PERFORM it:
$result = mysql_db_query($dbname, $sql);

thorpe

have another look at my example. notice the {} around the arrays... you need that. you also need to surround them with single quotes, as per my example.