Untitled

## CATATAN QUERY MYSQLI
Karena rata2 sekarang xampp udah pake PHP versi >= 5.4 jadi fungsi/sintaks
mysql diganti jadi mysqli. Jadi ganti aja sintak yang berawalan mysql misal: mysql_connect, dst.
Beberapa contoh sintaks mysqli tinggal disesuain aja sama field2 di databasenya.

#Koneksi
$con = mysqli_connect('namahost', 'username', 'password', 'namadatabse') or die('Koneksi gagal! Cek kembali konfigurasi database');
kalo udah pake sintaks diatas gak usah pake mysql_select_db lagi...

#Query tambah data
$sql = "insert into $tablename (nama, kelas, alamat) values ('imam', '3ka05', 'depok')";
mysqli_query($con, $sql) or die(mysqli_error());

#Query hapus data
$id = $_GET['id'];
$sql = "delete from $tablename where id = $id";
mysqli_query($con, $sql) or die(mysqli_error());

#Query update data
$id = $_GET['id'];
$sql = "update $tablename set nama='$nama', kelas='$kelas', alamat='$alamat' where id = $id";
mysqli_query($con, $sql) or die(mysqli_error());


------------------------------------------------------------------
## CONFIG.PHP
<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$dbname = 'penjualan_ikan';
$tablename = 'pemesanan';
$connect = mysql_connect($host, $user, $pass) or die(mysql_error());
$dbselect = mysql_select_db($dbname);
?>

------------------------------------------------------------------
##ADMIN.PHP
<?php include('koneksi.php') ?>
<h1>Admin</h1>
<form action="" method="POST">
Username:<input type="text" name="admin" size="20" maxlenght="9" class="form-control">

Password:<input type="password" name="password" size="20" class="form-control">
<br><input type="submit" name="submit" class="btn btn-primary">
<input type="reset" name="cancel" class="btn btn-primary">
</form>
</div><!-- container -->
</body>
</html>

<?php if (isset($_POST['submit']))
{
	if (!empty($_POST['admin']) && !empty($_POST['password'])) {
		if ($_POST['admin']=="admin" && $_POST['password']=="123"){
			header('location:viewadmin.php');
		}
	} else {
		echo 'login gagal';
	}
}

------------------------------------------------------------------
##KONEKSI.PHP
<?php
 $host = "localhost";
 $user = "root";
 $pass = "";
 $db   = "penjualan_ikan";
 $koneksi = mysqli_connect($host, $user, $pass, $db);
 if(mysqli_connect_errno()){
  echo "Gagal Terhubung ".mysqli_connect_error();
 }
 ?>

------------------------------------------------------------------
## VIEWADMIN.PHP
<?php include('config.php') ?>
<!DOCTYPE html>
<html>
<body>
<?php
	include('tips.php');
?>

<?php
	include('tabeldaya.php');
?>

</body>
</html>

------------------------------------------------------------------
## DELETE.PHP
<?php
include('config.php');

$id = $_GET['id'];

$query = mysql_query("delete from $tablename where id_pemesanan=$id") or die(mysql_error());

if ($query) {
    header('location:viewadmin.php');
}
?>