01.
<?php
02.
03.
$host
=
"localhost"
;
04.
$username
=
"root"
;
05.
$password
=
"root"
;
06.
$db_name
=
"libedb"
;
07.
$tbl_name
=
"test_mysql_in"
;
08.
$now
=
date
(
"Y-m-d h:i:s"
);
09.
10.
11.
mysql_connect(
"$host"
,
"$username"
,
"$password"
)
or
die
(
"cannot connect"
);
12.
mysql_select_db(
"$db_name"
)
or
die
(
"cannot select DB"
);
13.
14.
15.
$user_id_card
=
$_POST
[
'name'
];
16.
17.
$sql
=
"INSERT INTO $tbl_name(user_id_card,datenow)VALUES('$user_id_card',now())"
;
18.
$result
=mysql_query(
$sql
);
19.
if
(
$result
){
20.
include
"head.php"
;
21.
echo
"<center><font face='Angsana New' size='5' color='#000000'><b><br>** เพิ่มข้อมูลเรียบร้อยแล้ว **<br><br><br><br><br><br><br><br></b><font><br>"
;
22.
echo
"<meta http-equiv=\"refresh\" content=\"2; url=in1.php\" />"
;
23.
include
"footer.php"
;
24.
}
else
{
25.
include
"head.php"
;
26.
echo
"<center><font face='Angsana New' size='5' color='#000000'><b><br>ไม่สามารถเพิ่มข้อมูลได้ !<br><br><br><br><br><br><br><br></b><font><br>"
;
27.
echo
"<meta http-equiv=\"refresh\" content=\"2; url=in1.php\" />"
;
28.
include
"footer.php"
;
29.
}
30.
?>
31.
32.
<?php
33.
mysql_close();
34.
?>