ambildata.php

<?php
$host = "localhost";
$user = "root";
$pass = "";
$name = "rental_mobil_refisi";

$koneksi = mysql_connect($host, $user, $pass) or die("Koneksi ke database gagal!");
           mysql_select_db($name, $koneksi) or die("Tidak ada database yang dipilih!");

$action=$_POST["action"];
if($action=="showroom"){
    $query = "SELECT * FROM pelanggan";
    $show  = mysql_query($koneksi, $query) or die ("error");

echo "<table>
          <tr>
          <td> No KTP </td>
          <td> Nama Pelanggan</td>
          <td> Alamat Pelanggan</td>
          <td> Telepon Pelanggan</td>
          </tr>";
    while ($row = mysql_fetch_array($query)) {
            echo "<tr>";
            echo "<td align=center>$row[noktp]</td>";
            echo "<td align=center>$row[nmpel]</td>";
            echo "<td align=center>$row[alamatpel]</td>";
            echo "<td align=center>$row[telpel]</td>";
            echo "</tr>";
          }
    echo"</table>";
} else {
    $query = "SELECT * FROM pelanggan WHERE nmpel='$action'";
    $show  = mysql_query($koneksi, $query) or die ("error");

    echo "<table>
          <tr>
          <td> No KTP </td>
          <td> Nama Pelanggan</td>
          <td> Alamat Pelanggan</td>
          <td> Telepon Pelanggan</td>
          </tr>";
    while ($row = mysql_fetch_array($show)) {
    echo" <tr>
          <td> " .$row['noktp']. "</td>
          <td> " .$row['nmpel']. "</td>
          <td> " .$row['alamatpel']. "</td>
          <td> " .$row['telpel']. "</td>
          </tr>":
          }
    echo"</table>";
}
?>