Selasa, 30 November 2010

Link Database ke MySql

<html>
<head>
<body>
<title>Staterkom</title>
<form name="form1" method="post"action="staterkom.php">
<p>Masukkan Nama
     <input name="bil1"type="text">
     </p>
<p>Masukkan Alamat
      <input name="bil2"type="text">
      </p>
<p>Masukan Email
      <input name="bil3"type="text">
      </p>
      <p><br>

<p><input type="submit" name="submit" value="hasil"></p>
<?php
$bil1 = $_POST["bil1"];
$bil2 = $_POST["bil2"];
$bil3 = $_POST["bil3"];

$server="localhost";
$username = "root";
$password = "";
$database = "staterkom";
$tabel = "biodata";
$koneksi = mysql_connect($server,$username,$password)or die("gagal konek ke mysql".mysql_error());
$bukadb = mysql_select_db($database)or die("gagal membuka database $database".mysql_error());
$sql = "INSERT INTO $tabel (nama,alamat,email) VALUES ('$bil1','$bil2','$bil3')";
mysql_query($sql,$koneksi)
or die ("memasukkan data gagal".mysql_error());

echo "Nama&nbsp&nbsp&nbsp    :$bil1<br>";
echo "Alamat&nbsp&nbsp&nbsp  : $bil2<br>";
echo "Email&nbsp&nbsp&nbsp   : $bil3<br>";
?>
</html>
</head>
</body>