โค้ด: เลือกทั้งหมด
<?php
$host = "localhost";
$user = "root";
$passwd = "reetreet";
$dbname = "register";
$tbl_name="members"
mysql_connect($host,$user,$passwd) or die("ติดต่อ Host ไม่ได้");
mysql_select_db($dbname) or die("ติดต่อฐานข้อมูลไม่ได้");
$sql = "insert into `userinfo` ( `logname` , `pw` , `name` , `address` , `age` , `gender` , `ads`, `hobby` , `hobby2` , `hobby3` , `hobby4` , `email` )
values ('$logname', '$psswd', '$name', '$address', '$age', '$gender', '$Uknow', '$hobby1', '$hobby2', '$hobby3', '$hobby4', '$email' )";
mysql_query("set NAMES tis620");
$sqlquery=mysql_db_query($dbname, $sql);
$checkadd = "select * from `userinfo` where logname='$logname' ";
$result = mysql_db_query($dbname, $checkadd);
$num=mysql_num_rows($result);
if ($num==1)
{
print"<br>เพิ่มข้อมูลผู้ใช้ลงในฐานข้อมูลเรียบร้อยแล้ว ";
}elseif($num>=1)
{
print"<br>ชื่อผู้ใช้งานซ้ำ กรุณาใช้ชื่ออื่น ";
}else
{
print"ระบบขัดข้อง หรือ มีข้อผิดพลาด !!!";
};
mysql_close();
?>
พอตอน run
Notice: Undefined variable: logname in C:\xampp\htdocs\ProjectPHP\AddData.php on line 9
Notice: Undefined variable: psswd in C:\xampp\htdocs\ProjectPHP\AddData.php on line 9
Notice: Undefined variable: name in C:\xampp\htdocs\ProjectPHP\AddData.php on line 9
Notice: Undefined variable: address in C:\xampp\htdocs\ProjectPHP\AddData.php on line 9
Notice: Undefined variable: age in C:\xampp\htdocs\ProjectPHP\AddData.php on line 9
Notice: Undefined variable: gender in C:\xampp\htdocs\ProjectPHP\AddData.php on line 9
Notice: Undefined variable: Uknow in C:\xampp\htdocs\ProjectPHP\AddData.php on line 9
Notice: Undefined variable: hobby1 in C:\xampp\htdocs\ProjectPHP\AddData.php on line 9
Notice: Undefined variable: hobby2 in C:\xampp\htdocs\ProjectPHP\AddData.php on line 9
Notice: Undefined variable: hobby3 in C:\xampp\htdocs\ProjectPHP\AddData.php on line 9
Notice: Undefined variable: hobby4 in C:\xampp\htdocs\ProjectPHP\AddData.php on line 9
Notice: Undefined variable: email in C:\xampp\htdocs\ProjectPHP\AddData.php on line 9
Deprecated: Function mysql_db_query() is deprecated in C:\xampp\htdocs\ProjectPHP\AddData.php on line 11
Deprecated: mysql_db_query() [function.mysql-db-query]: This function is deprecated; use mysql_query() instead in C:\xampp\htdocs\ProjectPHP\AddData.php on line 11
Notice: Undefined variable: logname in C:\xampp\htdocs\ProjectPHP\AddData.php on line 12
Deprecated: Function mysql_db_query() is deprecated in C:\xampp\htdocs\ProjectPHP\AddData.php on line 13
Deprecated: mysql_db_query() [function.mysql-db-query]: This function is deprecated; use mysql_query() instead in C:\xampp\htdocs\ProjectPHP\AddData.php on line 13
ระบบขัดข้อง หรือ มีข้อผิดพลาด !!!