Rabu, 29 Januari 2014

MEMBUAT APLIKASI DATA DENGAN PHP DAN MYSQL

SCRIPT FORM

<!DOCTYPE html>
<html>
<head> <title> x </title></head>
<body>
<form action="inputformulir.php" method="POST">
<table>
<tr>
<td> NIM </td>
<td><input type="text" name="nim" value="nim"></td>
</tr>
<tr>
<td> NAMA </td>
<td><input type="text" name="nama" value="nama"></td>
</tr>
<tr>
<td>FAKULTAS </td>
<td><input type="text" name="fakultas" value="fakultas"></td>
<tr>
<td> KELAS </td>
<td><input type="text" name="kelas" value="kelas"></td>
</tr>
<tr>
<td> ALAMAT </td>
<td><input type="text" name="alamat" value="alamat"></td>
</tr>
<tr>
<td> <input type="submit" value="kirim"> </td>
<td> <input type="reset" value="reset"></td>
</tr>
</table>
</form>
</body>
</html>

SCRIPT KONEKSI.PHP  

<?php
$host = "localhost";
$user = "root";
$pass = "";
$db = "jaya";
$conect = mysql_connect($host, $user, $pass) or die ('koneksi gagal');
mysql_select_db($db);
?>

SCRIPT PENGIRIM DATA DARI FORM KE DATABASE 

<?php
include "koneksi.php";
$nim=$_POST['nim'];
$nama=$_POST['nama'];
$fakultas=$_POST['fakultas'];
$kelas=$_POST['kelas'];
$alamat=$_POST['alamat'];
$kirim="INSERT INTO heru (nim, nama, fakultas, kelas, alamat) VALUES ('$nim','$nama','$fakultas','$kelas','$alamat')";
mysql_query($kirim);
echo "<script> alert (' Data Telah Dikirim')</script>";
    echo" <meta http-equiv='refresh' content='0;url=dataform.php' />";
?>

Tidak ada komentar:

Posting Komentar