edit .php
update.php
tampil.php
Koneksi Mysql1 / maria db ke php
Koneksi.php
<?php
$koneksi = mysqli_connect("localhost","root","","akademik");
// Check connection
if (mysqli_connect_errno()){
echo "Koneksi database gagal : " . mysqli_connect_error();
}
?>
tampil data.php
<!DOCTYPE html>
<html>
<head>
<title>CRUD PHP dan MySQLi - WWW.MALASNGODING.COM</title>
</head>
<body>
<h2>CRUD DATA MAHASISWA - WWW.MALASNGODING.COM</h2>
<br/>
<a href="tambah.php">+ TAMBAH MAHASISWA</a>
<br/>
<br/>
<table border="1">
<tr>
<th>NO</th>
<th>Nama</th>
<th>NIM</th>
<th>Alamat</th>
<th>OPSI</th>
</tr>
<?php
include 'koneksi.php';
$no = 1;
$data = mysqli_query($koneksi,"select * from mahasiswa");
while($d = mysqli_fetch_array($data)){
?>
<tr>
<td><?php echo $no++; ?></td>
<td><?php echo $d['nama']; ?></td>
<td><?php echo $d['nim']; ?></td>
<td><?php echo $d['alamat']; ?></td>
<td>
<a href="edit.php?id=<?php echo $d['id']; ?>">EDIT</a>
<a href="hapus.php?id=<?php echo $d['id']; ?>">HAPUS</a>
</td>
</tr>
<?php
}
?>
</table>
</body>
</html>
<?php
$koneksi = mysqli_connect("localhost","root","","akademik");
// Check connection
if (mysqli_connect_errno()){
echo "Koneksi database gagal : " . mysqli_connect_error();
}
?>
tampil data.php
<!DOCTYPE html>
<html>
<head>
<title>CRUD PHP dan MySQLi - WWW.MALASNGODING.COM</title>
</head>
<body>
<h2>CRUD DATA MAHASISWA - WWW.MALASNGODING.COM</h2>
<br/>
<a href="tambah.php">+ TAMBAH MAHASISWA</a>
<br/>
<br/>
<table border="1">
<tr>
<th>NO</th>
<th>Nama</th>
<th>NIM</th>
<th>Alamat</th>
<th>OPSI</th>
</tr>
<?php
include 'koneksi.php';
$no = 1;
$data = mysqli_query($koneksi,"select * from mahasiswa");
while($d = mysqli_fetch_array($data)){
?>
<tr>
<td><?php echo $no++; ?></td>
<td><?php echo $d['nama']; ?></td>
<td><?php echo $d['nim']; ?></td>
<td><?php echo $d['alamat']; ?></td>
<td>
<a href="edit.php?id=<?php echo $d['id']; ?>">EDIT</a>
<a href="hapus.php?id=<?php echo $d['id']; ?>">HAPUS</a>
</td>
</tr>
<?php
}
?>
</table>
</body>
</html>
Langganan:
Postingan (Atom)