Tuesday, October 30, 2018

Menampilkan Database dari List Menu

Buat koneksi ke database

<?php

$h = "localhost";
$u = "root";
$p = "";
$d = "pegawai";
$connect = mysqli_connect($h,$u,$p,$d);
$query = "SELECT * from test";
$result1 = mysqli_query($connect,$query);
?>


 Buat file index.php


<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
</head>
<body>

<form action = "" method="POST">
<select name="taskOption">
<option value "Pilihen dewe" selected> Pilihen Dewe </option>
<?php include 'config.php';?>
<?php while($row1 = mysqli_fetch_array($result1)):;?>
<option value="<?php echo $row1[0];?>"><?php echo $row1[1];?></option>
<?php endwhile;?>

</select> <input type="submit" name="submit" value="Go" />
<table style="border: none;font-size: 12px;color: #5b5b5b;width: 100%;margin: 10px 0 10px 0;">
 <tr>
 <td bgcolor="#A6D44D" style="border: none;padding: 4px;"><b>NIP</b></td>
 <td bgcolor="#A6D44D" style="border: none;padding: 4px;"><b>Nama</b></td>
 <td bgcolor="#A6D44D" style="border: none;padding: 4px;"><b>Jenis Kelamin</b></td>

 </tr>
 <tr>
 <td>
<?php
$option = $_POST['taskOption'];
switch ($option)
{
default;
display($option);
}
?>

<?php
function display($value)
{
include 'config.php';
while($row = $result1->fetch_assoc())
{
if ( $value==$row["id"] )
echo "<td>" .$row["StdName"]. "</td><td>".$row["Sex"]. "";

}
}
?>

</td>

</table>



</form>




</body>
</html>



NIP Nama Jenis Kelamin
fetch_assoc()) { if ( $value==$row["id"] ) echo "" .$row["StdName"]. "".$row["Sex"]. ""; } } ?>
Demikian ....