2. Buat file kuliah5.php
<?php
mysql_connect("localhost","root","");
mysql_select_db("kuliah");
//$query="insert into mahasiswa values('1400018135', 'syahrul afrizal', 'joga', 'afrizalsyahrul@gmail.com')";
$query="select * from mahasiswa";
$hasil=mysql_query($query);
/*if ($hasil) {
echo "Input data berhasil";
}else{
echo "Input data gagal";
}*/
$i=1;
while ($data=mysql_fetch_array($hasil)) {
echo $data['NIM'];
echo $data['Nama'];
echo $data['Alamat'];
echo $data['email'];
$i++;
}
?>
3. Buat file classkul5.php
<?php
class kuliah5{
private $host;
private $user;
private $password;
private $db;
function __construct($a, $b, $c, $d) {
$this->host = $a;
$this->user = $a;
$this->password = $a;
$this->db = $a;
}
function sambung(){
mysql_connect($this->host, $this->user, $this->password);
mysql_select_db($this->db);
}
function tambahdata($nim, $nama, $alamat, $email){
$query="insert into mahasiswa values('$nim', '$nama', '$alamat', '$email')";
$hasil=mysql_query($query);
if ($hasil) {
echo "berhasil";
}
else {
echo "gagal";
}
}
function tampildata(){
$query="select * from mahasiswa";
$hasil=mysql_query($query);
//$i=1;
while ($data=mysql_fetch_array($hasil)) {
/*echo "data ke-",. $i. "<br/>";
echo $data['NIM']. "<br/>";
echo $data['Nama']. "<br/>";
echo $data['Alamat']. "<br/>";
echo $data['email']. "<br/>";*/
$data[]=$d;
//$i++;
}
return($data);
}
}
?>
4. Buat file pemanggil.php
<?
include 'classkul5.php';
$host="localhost";
$user="root";
$password="";
$db="kuliah";
$vardb=new database($host, $user, $password, $db);
$vardb->sambung();
$aksi=$_GET['aksi'];
if ($aksi=='tambahdata'){
$vardb->tambahdata($_POST['nim'],$_POST['nama'],$_POST['alamat'])
}
$vardb->tambahdata('1400018136', 'rahman', 'warungboto', 'rdrahman96@gmail.com');
$vardb->tampildata();
?>
5. Buat setting.php
<html>
<head></head>
<?
include "pemanggil.php"
<body>
<form>
<table>
($vardb->tampildata()as $x){
<tr>
<td><? echo $no++; ?></td>
<td><? echo $x['nim']; ?></td>
<td><? echo $x['nama']; ?></td>
<td><? echo $x['alamat']; ?></td>
<td><? echo $x['email']; ?></td>
</tr>
<td><a href="edit.php?nim=<?php echo $x['nim']; ?> &aksi=edit">EDIT</a>
<a href="delete.php?nim=<?php echo $x['nim']; ?> &aksi=delete">DELETE</a>
</td>
</table>
</form>
</body>
</html>
0 komentar:
Posting Komentar