Hi,
I try to insert data in mysql. Both variable same as in db. But i keep getting "Input data fail". Please assist me. This is my code.
insert.html
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<form method="post" action="success.php">
<table width="400" border="0" cellspacing="1" cellpadding="1">
<tr>
<td width="100">ndp</td>
<td width="250">:<input type="text" name="ndp" size="40" maxlength="100"></td>
</tr>
<tr>
<td>nama</td>
<td>:<input type="text" name="nama_pelajar" size="40" maxlength="100"></td>
</tr>
<tr>
<td>kad pengenalan</td>
<td>:<input type="text" name="kp_pelajar" size="13" maxlength="12"></td>
</tr>
</table>
<input type="submit" name="submit" value="Hantar"/>
</form>
</body>
</html>
success.php
<html>
<head>
<title>In Progress</title>
</head>
<body>
<?php
$host="localhost"; // Host name
$userid="root"; // Mysql username
$password="pmo123"; // Mysql password
$db_name="system"; // Database name
$tbl_name="test"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$userid", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$ndp=$_POST['ndp'];
$nama_pelajar=$_POST['nama_pelajar'];
$kp_pelajar=$_POST['kp_pelajar'];
//inserting data order
$order = "INSERT INTO test
(ndp, nama_pelajar, kp_pelajar)
VALUES
('$ndp', '$nama_pelajar', $kp_pelajar')";
//declare in the order variable
$result = mysql_query($order); //order executes
if($result){
echo("<br>Input data is succeed");
} else{
echo("<br>Input data is fail");
}
?>
</body>
</html>
Thanks/.
