PHP Mysql

Sedikit sharing program aplikasi php  untuk database. Cukup menyenangkan juga ya berkutat dalam dunia database. Yah meskipun terkadang agak gila rasanya liat coding mulu..


Simpan Data
<?php
       $conn=mysql_connect("localhost","root","")
       or die ("Data tidak dapat diakses");
       mysql_select_db("Onlineshopphp",$conn);
       $Nama = $_POST["Nama"];
       $Email = $_POST["Email"];
       $Comment = $_POST["Comment"];
       echo "Nama             : $Nama";
       echo "<br>";
       echo "Email           : $Email";
       echo "<br>";
       echo "Comment          : $Comment";
       echo "<br>";
       $hasil=mysql_query ("insert into bukutamu VALUES ('$Nama','$Email','$Comment')",$conn);
       echo "<br>";
       if ($hasil) echo "Input data sukses";
       else echo "Input data gagal";
?>

View Data 

<?php
              $conn = mysql_connect("localhost","root","");
              mysql_select_db("onlineshopphp",$conn);
              $hasil = mysql_query("select * from bukutamu",$conn);
              $jumlah = mysql_num_rows($hasil);
              echo "Jumlah pengunjung : $jumlah";
              echo "<br>"; echo "<br>";
              $a=1;
              echo("<table width=70% cellspacing=1 cellpadding=2 border=1  bgcolor=#000000 align=center>");
              echo("<tr><td bgcolor=#CCCCCC><center><strong>Nama</strong></center></td>
              <td bgcolor=#CCCCCC><center><strong>Email</strong></center></td>
              <td bgcolor=#CCCCCC><center><strong>Comment</strong></center></td>
              </tr>");
              // ------ ambil isi masing-masing record
              while ($row = mysql_fetch_object ($hasil))
              {
              // ----- mengambil isi setiap kolom
              $Nama=$row->Nama;
              $Email=$row->Email;
              $Comment=$row->Comment;
              // ------ menampilkan di layar browser
              echo("<tr><td bgcolor=#FFFFFF> $Nama</td>
              <td bgcolor=#FFFFFF> $Email</td>
              <td bgcolor=#FFFFFF> $Comment</td>
              </tr>");$a++;
              }
              echo("</table>");
              ?>

Query Data 

<? 
if($_GET["Nama"] != "") 
{ 
$objConnect = mysql_connect("localhost","root","") or die(mysql_error()); 
$objDB = mysql_select_db("onlineshopphp"); 
// Search By Name or Email 
$strSQL = "SELECT * FROM bukutamu WHERE (Nama LIKE '%".$_GET["Nama"]."%' )"; 
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]"); 
?> 
<table width="600" border="1"> 
<tr> 
<th width="91"> <div align="center">Nama</div></th> 
<th width="98"> <div align="center">Email</div></th> 
<th width="198"> <div align="center">Comment </div></th> 
</tr> 
<?  
while($objResult = mysql_fetch_array($objQuery)) 
{ 
?> 
<tr> 
<td><?=$objResult["Nama"];?></div></td> 
<td><?=$objResult["Email"];?></td> 
<td><?=$objResult["Comment"];?></td> 
</tr> 
<? 
} 
?> 
</table>  

Hapus Data 

<?php
       // misalkan data source namenya 'dbbudaya', password dan username kosong
       $conn=mysql_connect("localhost","root","")
       or die ("Data tidak dapat diakses");
       mysql_select_db("onlineshopphp",$conn);
       $Nama = $_POST["Nama"];
       $hasil=mysql_query ("DELETE FROM bukutamu WHERE Nama='$Nama'",$conn);
       if ($hasil) echo "Delete data sukses";
       else echo "Delete data gagal";
?>