cara membuat data mahasiswa melaluin PHP:
<?php
$host="localhost";$user="root";
$pass="";
$db="data_Mahasiswa";
$sambung=mysql_connect($host,$user,$pass);
Mysql_select_db($db.$sambung);
?>
<html>
<head>
<title>Daftar Mahasiswa</title>
</head>
<body>
<?php
$sambung=mysql_connect("localhost","root","")or die("gagal konek ke server.");
msql_select_db("data_siswa")or die("gagal membuka database.)";
?>
<table border="5">
<tr>
<th>NIM</th>
<th>Nama Mahasiswa</th>
<th>ALAMAT</th>
<th>AGAMA</th>
<th>NO_tlpn</th>
<th colspan="3">Aksi</th>
</tr>
<?php
$query="select*from mhs";
$result = mysql_query($query.$sambung);
//$no = 0;
While ($buff = mysql_fetch_array($result)){
//$no++;
?>
<tr>
<td><?php echo $buff['nim']; ?></td>
<td><?php echo $buff['nama']; ?></td>
<td><?php echo $buff['alamat']; ?></td>
<td><?php echo $buff['agama']; ?></td>
<td><?php echo $buff['notlpn']; ?></td>
<td><a href="edit.php?nim=<? phpecho $buff['nim']; ?>">edit</a>|
<td><a href="hapus.php?nim=<?php echo $buff['nim']; ?>">hapus</a>
</tr>
<?php
};
mysql_close($sambung);
?>
</table>
<p align="left"><a href="tambah.html">Tambah Data</a></p>
</body>
</html>
<?php
include("koneksi.php");
$nim=$_POST['nim'];
$nama=$_POST['nama'];
$alamat=$_POST['alamat'];
$agama=$_POST['agama'];
$notlpn=$_POST['notlpn'];
$query = mysql_query("insert into mhs values ('$nim','$nama','$alamat','$agama','$agama','$notlpn')");
echo "data telah disimpan<br>
<a href=\"index.php\">kembali</a>";
?>
<html>
<head>title>Tambah data</title></head>
<body>
<h3><p aign="left">tambahan data mahasiswa</p></h3>
<form name="form1"method="post"action="entry.php">
<table>
<tr><td>NIM</td><td><input type="text" name="nim" size="12"></td></tr>
<tr><td>Nama</td><td><input type="text" name="nama" size="30"></td></tr>
<tr><td>Alamat</td><td><input type="text" name="alamat" size="50"></td></tr>
<tr><td>Agama</td><td><input type="text" name="agama" size="10"></td></tr>
<tr><td>No. Tlpn</td><td><input type="text" name="notlpn" size="15"></td></tr>
<tr><td><input value="simpan" name="submit"type="submit"/></td></tr>
<tr><td><input value="ulangi"type="reset"/></td></tr>
<tr><td><input value="kembali"type="button" onClick="self.history.back()"></td></tr>
</table>
</from>
</body>
</html>
<?php
include("koneksi.php");
$nim = $_POST['nim'];
$nama = $_POST['nama'];
$alamat = $_POST['alamat'];
$agama = $_POST['agama'];
$notlpn = $_POST['notlpn'];
$query = mysql_query("update mhs set nama='$nama', alamat='$alamat',
agama='$agama', notlpn='$notlpn'where nim='$nim"');
echo "Data telah diupdate<br>
<a href=\index.php\">kembali</a>";
?>
<?php
$sambung = mysql_connet("localhost", "root","")or die("gagal konek ke server.");
mysql_select_db("data_siswa")or die("gagal membuka database.");
//$edit=mysql_query("SELECT * FROM mhs WHERE nim='$_GET[nim]"');
//$r_edit=mysql_fetch_array($edit);
$nim = $_GET['nim'];
$query = "select * from mhs where nim='$nim"';
$result = mysql_query($query,$sambung)or die("gagal melakukan query");
$buff=mysql_fecth_array($result);
mysql_close($sambung);
?>
<html>
<head><title>Edit Data</title></head>
<body>
<from name="form1"method="post"action="update.php">
<table>
<tr>
<td>Nim</td></td><input type="text"name="nim" value="<?php echo $buff['nim'];?>"></td></tr>
<td>Nama</td></td><input type="text"name="nama" value="<?php echo $buff['nama'];
?>"></td></tr>
<td>Alamat</td></td><input type="text"name="alamat" value="<?php echo $buff['alamat'];
?>"></td></tr>
<td>Agama</td></td><input type="text"name="agama" value="<?php echo $buff['agama'];
?>"></td></tr>
<td>No. tlpn</td></td><input type="text"name="notlpn" value="<?php echo $buff['notlpn'];
?>"></td></tr>
<tr>
<input value="simpan"type="submit"name="submit"/>
<input type="button"value="kembali"onClik="self.history.back()"></td></tr>
</table>
</from>
</body>
</html>
dan ini cara membuat kalkulator melaluin PHP:
<?php
$host="localhost";$user="root";
$pass="";
$db="data_Mahasiswa";
$sambung=mysql_connect($host,$user,$pass);
Mysql_select_db($db.$sambung);
?>
<html>
<head>
<title>Daftar Mahasiswa</title>
</head>
<body>
<?php
$sambung=mysql_connect("localhost","root","")or die("gagal konek ke server.");
msql_select_db("data_siswa")or die("gagal membuka database.)";
?>
<table border="5">
<tr>
<th>NIM</th>
<th>Nama Mahasiswa</th>
<th>ALAMAT</th>
<th>AGAMA</th>
<th>NO_tlpn</th>
<th colspan="3">Aksi</th>
</tr>
<?php
$query="select*from mhs";
$result = mysql_query($query.$sambung);
//$no = 0;
While ($buff = mysql_fetch_array($result)){
//$no++;
?>
<tr>
<td><?php echo $buff['nim']; ?></td>
<td><?php echo $buff['nama']; ?></td>
<td><?php echo $buff['alamat']; ?></td>
<td><?php echo $buff['agama']; ?></td>
<td><?php echo $buff['notlpn']; ?></td>
<td><a href="edit.php?nim=<? phpecho $buff['nim']; ?>">edit</a>|
<td><a href="hapus.php?nim=<?php echo $buff['nim']; ?>">hapus</a>
</tr>
<?php
};
mysql_close($sambung);
?>
</table>
<p align="left"><a href="tambah.html">Tambah Data</a></p>
</body>
</html>
<?php
include("koneksi.php");
$nim=$_POST['nim'];
$nama=$_POST['nama'];
$alamat=$_POST['alamat'];
$agama=$_POST['agama'];
$notlpn=$_POST['notlpn'];
$query = mysql_query("insert into mhs values ('$nim','$nama','$alamat','$agama','$agama','$notlpn')");
echo "data telah disimpan<br>
<a href=\"index.php\">kembali</a>";
?>
<html>
<head>title>Tambah data</title></head>
<body>
<h3><p aign="left">tambahan data mahasiswa</p></h3>
<form name="form1"method="post"action="entry.php">
<table>
<tr><td>NIM</td><td><input type="text" name="nim" size="12"></td></tr>
<tr><td>Nama</td><td><input type="text" name="nama" size="30"></td></tr>
<tr><td>Alamat</td><td><input type="text" name="alamat" size="50"></td></tr>
<tr><td>Agama</td><td><input type="text" name="agama" size="10"></td></tr>
<tr><td>No. Tlpn</td><td><input type="text" name="notlpn" size="15"></td></tr>
<tr><td><input value="simpan" name="submit"type="submit"/></td></tr>
<tr><td><input value="ulangi"type="reset"/></td></tr>
<tr><td><input value="kembali"type="button" onClick="self.history.back()"></td></tr>
</table>
</from>
</body>
</html>
<?php
include("koneksi.php");
$nim = $_POST['nim'];
$nama = $_POST['nama'];
$alamat = $_POST['alamat'];
$agama = $_POST['agama'];
$notlpn = $_POST['notlpn'];
$query = mysql_query("update mhs set nama='$nama', alamat='$alamat',
agama='$agama', notlpn='$notlpn'where nim='$nim"');
echo "Data telah diupdate<br>
<a href=\index.php\">kembali</a>";
?>
<?php
$sambung = mysql_connet("localhost", "root","")or die("gagal konek ke server.");
mysql_select_db("data_siswa")or die("gagal membuka database.");
//$edit=mysql_query("SELECT * FROM mhs WHERE nim='$_GET[nim]"');
//$r_edit=mysql_fetch_array($edit);
$nim = $_GET['nim'];
$query = "select * from mhs where nim='$nim"';
$result = mysql_query($query,$sambung)or die("gagal melakukan query");
$buff=mysql_fecth_array($result);
mysql_close($sambung);
?>
<html>
<head><title>Edit Data</title></head>
<body>
<from name="form1"method="post"action="update.php">
<table>
<tr>
<td>Nim</td></td><input type="text"name="nim" value="<?php echo $buff['nim'];?>"></td></tr>
<td>Nama</td></td><input type="text"name="nama" value="<?php echo $buff['nama'];
?>"></td></tr>
<td>Alamat</td></td><input type="text"name="alamat" value="<?php echo $buff['alamat'];
?>"></td></tr>
<td>Agama</td></td><input type="text"name="agama" value="<?php echo $buff['agama'];
?>"></td></tr>
<td>No. tlpn</td></td><input type="text"name="notlpn" value="<?php echo $buff['notlpn'];
?>"></td></tr>
<tr>
<input value="simpan"type="submit"name="submit"/>
<input type="button"value="kembali"onClik="self.history.back()"></td></tr>
</table>
</from>
</body>
</html>
