<?php
//connect ke database
  mysql_connect("localhost","root","");
  mysql_select_db("db_siswa");
//harus selalu gunakan variabel term saat memakai autocomplete,
//jika variable term tidak bisa, gunakan variabel q
$term = trim(strip_tags($_GET['term']));
  
$qstring = "SELECT * FROM tb_siswa WHERE nama LIKE '".$term."%'";
//query database untuk mengecek tabel anime
$result = mysql_query($qstring);
  
while ($row = mysql_fetch_array($result))
{
    $row['value']=htmlentities(stripslashes($row['nama']));
    $row['id']=(int)$row['id'];
//buat array yang nantinya akan di konversi ke json
    $row_set[] = $row;
}
//data hasil query yang dikirim kembali dalam format json
echo json_encode($row_set);
?>

<!doctype html>
   
<html lang="en">
<head>
    <meta charset="utf-8" />
    <title>Autocomplete dari database dengan jQuery dan PHP | Cuma Coder</title>
 <link rel="stylesheet" href="style.css" />
    <link rel="stylesheet"
    href="js/jquery-ui.css" />
    <script src="js/jquery-1.8.3.js"></script>
    <script src="js/jquery-ui.js"></script>
  
    <script>
/*autocomplete muncul setelah user mengetikan minimal2 karakter */
    $(function() { 
        $( "#siswa" ).autocomplete({
         source: "data.php", 
           minLength:1,
        });
    });
    </script>
</head>
<body>
<div class="wrap">
 <h1>Data Siswa Sekolah Cuma Coder</h1>
    <h1>Autocomplete dari database dengan jQuery dan PHP</h1>
 <div class="ui-widget">
  <label for="siswa">Nama Siswa : </label>
  <input id="siswa"  />
 </div>
 <p class='copy'>Copyright &copy <a href="http://www.cumacoder.blogspot.com">Cuma Coder</a> 2016</p>
</div>
</body>
</html>

// init app with app id and secret
FacebookSession::setDefaultApplication( 'Your APP ID','Your APP Secret' );
// login helper with redirect_uri
    $helper = new FacebookRedirectLoginHelper('http://www.cumacoder.com/fbconfig.php' );

<?php
session_start();
// added in v4.0.0
require_once 'autoload.php';
use Facebook\FacebookSession;
use Facebook\FacebookRedirectLoginHelper;
use Facebook\FacebookRequest;
use Facebook\FacebookResponse;
use Facebook\FacebookSDKException;
use Facebook\FacebookRequestException;
use Facebook\FacebookAuthorizationException;
use Facebook\GraphObject;
use Facebook\Entities\AccessToken;
use Facebook\HttpClients\FacebookCurlHttpClient;
use Facebook\HttpClients\FacebookHttpable;
// init app with app id and secret
FacebookSession::setDefaultApplication( 'Your APP ID','Your APP Secret' );
// login helper with redirect_uri
    $helper = new FacebookRedirectLoginHelper('http://www.cumacoder.com/fbconfig.php' );
try {
  $session = $helper->getSessionFromRedirect();
} catch( FacebookRequestException $ex ) {
  // When Facebook returns an error
} catch( Exception $ex ) {
  // When validation fails or other local issues
}
// see if we have a session
if ( isset( $session ) ) {
  // graph api request for user data
  $request = new FacebookRequest( $session, 'GET', '/me' );
  $response = $request->execute();
  // get response
  $graphObject = $response->getGraphObject();
      $fbid = $graphObject->getProperty('id');              // To Get Facebook ID
      $fbfullname = $graphObject->getProperty('name'); // To Get Facebook full name
     $femail = $graphObject->getProperty('email');    // To Get Facebook email ID
 /* ---- Session Variables -----*/
     $_SESSION['FBID'] = $fbid;           
        $_SESSION['FULLNAME'] = $fbfullname;
     $_SESSION['EMAIL'] =  $femail;
    /* ---- header location after session ----*/
  header("Location: index.php");
} else {
  $loginUrl = $helper->getLoginUrl();
 header("Location: ".$loginUrl);
}
?>

<?php 
session_start();
session_unset();
    $_SESSION['FBID'] = NULL;
    $_SESSION['FULLNAME'] = NULL;
    $_SESSION['EMAIL'] =  NULL;
header("Location: index.php");        // you can enter home page here ( Eg : header("Location: " ."http://www.cumacoder.com"); 
?>

• DOWNLOAD DATABASE
• DOWNLOAD SOURCE CODE

CREATE TABLE `pageview` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `page` text NOT NULL,
 `userip` text NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

CREATE TABLE `totalview` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `page` text NOT NULL,
 `totalvisit` text NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1

<?php
$mysqli = new mysqli("localhost", "root", "", "db_statistik");
 
  /* check connection */
if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
    exit();
}
 
  // ambul ip address user
  $user_ip=$_SERVER['REMOTE_ADDR'];
 
 //cek apakah sudah dikunjungi oleh ip address diatas
  $check_ip = $mysqli->query("select userip from pageview where page='yourpage' and userip='$user_ip'");
  if($check_ip->num_rows>=1)
  { 
  }
  else
  {
    //jika belum dikunjungi oleh ip address user diatas akan melakukan perhitungan
    $mysqli->query("insert into pageview values('','yourpage','$user_ip')");
   $mysqli->query("update totalview set totalvisit = totalvisit+1 where page='yourpage' ");
  }
?>
 
<html>
<head>
</head>
 
<body>
  <?php
    //menampilkan statistik pengunjung
    $stmt = $mysqli->query("select totalvisit from totalview where page='yourpage' ");
  ?>
 
    <p>Ip Address Anda <?php echo $user_ip=$_SERVER['REMOTE_ADDR'];;?></p>

  <p>Halaman ini telah dikunjungi sebangak <?php echo $stmt->num_rows;?> kali.</p>
 
</body>
</html>

1. index.php
2. insert.php
3. update.php
4. delete.php

CREATE DATABASE db_mahasiswa;

CREATE TABLE mahasiswa (
   id INT(6) AUTO_INCREMENT NOT NULL,
   nim VARCHAR(10) NOT NULL,
   nama VARCHAR(30) NOT NULL,
   jk VARCHAR(1) NOT NULL,
   alamat TEXT,
   PRIMARY KEY(id)
);

<?php
$mysqli = new mysqli("localhost", "root", "", "db_mahasiswa");

/* check connection */
if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
    exit();
}

?>

<h2>Tambah Data Mahasiswa</h2>
<form action="insert.php" method="post" name="insertform">
<table>
 <tr> 
  <td>NIM</td>
  <td>:</td>
  <td><input type="number" name="nim" required placeholder="NIM"></td>
 </tr>
 <tr> 
  <td>Nama</td>
  <td>:</td>
  <td><input type="text" name="nama" required placeholder="Nama"></td>
 </tr>
  <tr> 
  <td>L/P</td>
  <td>:</td>
  <td>
   <input type="radio" name="jk" value="L">L
    <input type="radio" name="jk" value="P">P
   </td>
 </tr>
 <tr> 
  <td>Alamat</td>
  <td>:</td>
  <td><input type="text" name="alamat" required placeholder="Alamat"></td>
 </tr>
</table>
  <input type="submit" name="send" value="Submit"/>
</p>
</form>

<?php 
if ($data = $mysqli->query("SELECT * FROM mahasiswa")) {
  echo "<table border=1>";
     echo "<tr>";
     echo "<td>Nim</td>";
     echo "<td>Nama</td>";
     echo "<td>L/P</td>";
     echo "<td>Alamat</td>";
     echo "<td colspan=2>Aksi</td>";
     echo "</tr>";

 foreach ($data as $hasil) {
  echo "<tr>";
  echo "<td>".$hasil['nim']."</td>";
  echo "<td>".$hasil['nama']."</td>";
  echo "<td>".$hasil['jk']."</td>";
  echo "<td>".$hasil['alamat']."</td>";
  echo "<td><a href='update.php?id=".$hasil['id']."'>Edit</a></td>";
  echo "<td><a href='delete.php?id=".$hasil['id']."'>Hapus</a></td>";
  echo "</tr>";
 }
 echo "</table>";

    /* free result set */
    $data->close();
}

$mysqli->close();
?>

<?php
$mysqli = new mysqli("localhost", "root", "", "db_mahasiswa");

/* check connection */
if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
    exit();
}

if(isset($_POST['send'])!="")
  {
  $nim=$_POST['nim'];
  $nama=$_POST['nama'];
  $jk=$_POST['jk'];
  $alamat=$_POST['alamat'];
  $insert= $mysqli->query("INSERT INTO mahasiswa (nim,nama,jk,alamat)VALUES ('$nim','$nama','$jk','$alamat') ");
  
  if($insert)
  {
      $msg="Tambah Data Berhasil";
      echo "<script type='text/javascript'>alert('$msg');</script>";
      header('Location:index.php');
  }
  }
  else
  {
     $errormsg="Tambah Data Gagal !!! Coba Lagi !!";
      echo "<script type='text/javascript'>alert('$errormsg');</script>";
      header('Location:index.php');
  }

$mysqli->close();
?>

<?php 
$mysqli = new mysqli("localhost", "root", "", "db_mahasiswa");
if(isset($_GET['id']))
{
  $id=$_GET['id'];
  if(isset($_POST['update']))
  {
  $nim=$_POST['nim'];
  $nama=$_POST['nama'];
  $jk=$_POST['jk'];
  $alamat=$_POST['alamat'];
  $update= $mysqli->query("UPDATE mahasiswa SET nim='$nim', nama='$nama', jk='$jk', alamat='$alamat' WHERE id='$id'");
  if($update)
  {
  $msg="Berhasil Di Update";
  header('Location:index.php');
  }
}
}
?>
<?php 
  if(isset($_GET['id']))
  {
  $id=$_GET['id'];
  $ambildata = $mysqli->query("SELECT * from mahasiswa WHERE id='$id'");
  while($data=$ambildata->fetch_array(MYSQLI_BOTH))
  {
    $nim=$data['nim'];
    $nama=$data['nama'];
    $jk=$data['jk'];
    $alamat=$data['alamat'];
?>
<h2>Edit Data Mahasiswa</h2>
<form action="" method="post" name="insertform">
<table>
 <tr> 
  <td>NIM</td>
  <td>:</td>
  <td><input type="number" name="nim" required placeholder="NIM" value="<?php echo $nim;?>"></td>
 </tr>
 <tr> 
  <td>Nama</td>
  <td>:</td>
  <td><input type="text" name="nama" required placeholder="Nama" value="<?php echo $nama;?>"></td>
 </tr>
  <tr> 
  <td>L/P</td>
  <td>:</td>
  <td>
   <input type="radio" name="jk" value="L">L
    <input type="radio" name="jk" value="P">P
   </td>
 </tr>
 <tr> 
  <td>Alamat</td>
  <td>:</td>
  <td><input type="text" name="alamat" required placeholder="Alamat" value="<?php echo $alamat;?>"></td>
 </tr>
</table>
  <input type="submit" name="update" value="Simpan Update"/>
</p>
</form>
<?php } } ?> 

<?php
$mysqli = new mysqli("localhost", "root", "", "db_mahasiswa");

/* check connection */
if ($mysqli->connect_errno) {
    printf("Connect failed: %s\n", $mysqli->connect_error);
    exit();
}

if(isset($_GET['id'])!="")
  {
   $id=$_GET['id'];
   $hapus=$mysqli->query("DELETE FROM mahasiswa WHERE id='$id'");
   if($hapus)
   {
       header("Location:index.php");
   }
   else
   {
       echo mysql_error();
   }
}

$mysqli->close();
?>