Monday, December 1, 2008

Insert data ke dalam database MySQL

Setelah memilih dan membuka database, selanjutnya kita memasukkan data.

<?php
include 'config.php';

mysql_select_db($dbname);
$query = "INSERT INTO user (nama, alamat) VALUES ('James Bond', '3rd Avenue')";
mysql_query($query) or die('Error, insert query failed');

?>
Dan pada aplikasinya, data dimasukkan melalui form dengan $_POST :
<html>
<head>
<title>Add New  User</title>
</head>
<body>

<?php
if(isset($_POST['add']))
{
include 'config.php';

$username = $_POST['nama'];
$password  = $_POST['alamat'];

$query = "INSERT INTO user  (nama, alamat) VALUES ('$nama', '$alamat')";
mysql_query($query) or die('Error, insert query failed');

echo "New user added";
}
else
{
?>
<form  method="post">
<table border="0"  cellspacing="1" cellpadding="2">
<tr>
<td width="100">Nama</td>
<td><input  name="nama" type="text"  id="nama"></td>
</tr>
<tr>
<td  width="100">Alamat</td>
<td><input  name="alamat" type="text"  id="alamat"></td>
</tr>
<tr>
<td width="100">&nbsp;</td>
<td><input  name="add" type="submit" id="add"  value="Add New User"></td>
</tr>
</table>
</form>
<?php
}
?>
</body>
</html>

Label: