searching php dan mysql

cara mengunakan php untuk pencarian data dari database seperti berikut silakan mencoba
pertama tulis code seperti berikut
<form metod="post" >
 <input type="search" name="cari" placeholder="cari data">
</form>
kedua buat data didatabase

-- Table structure for table `album`--

CREATE TABLE IF NOT EXISTS `album` (
  `id_album` int(5) NOT NULL AUTO_INCREMENT,
  `jdl_album` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `album_seo` varchar(100) COLLATE latin1_general_ci NOT NULL,
    PRIMARY KEY (`id_album`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=25 ;

--
-- Dumping data for table `album`
--

INSERT INTO `album` (`id_album`, `jdl_album`, `album_seo`) VALUES
(21, 'Kartun', 'kartun'),
(20, 'Pernikahan', 'pernikahan'),
(18, 'Bayi', 'bayi'),
(12, 'Ilustrator', 'ilustrator'),
(19, 'Binatang', 'binatang'),
(17, 'Arsitektur', 'arsitektur');

-- ----------------------------------------------------

ketiga buat code php

$data=mysql_connect("localhost","root","") or die("Koneksi Ke Server Database Gagal");
mysql_select_db("Nama_database",$data) or die ("Koneksi ke Database Gagal");

$proses = (isset($_POST['proses'])) ? $_POST['proses'] : "";
$cari = (isset($_POST['cari'])) ? $_POST['cari'] : "";

if($proses=='Tampilkan'){

$ad=mysql_query("SELECT* from album where jdl_album LIKE '$cari'");
$sa = mysql_num_rows($ad);
if($sata == '0'){
echo "Maaf Data Yang anda cari tidak ada";
}
   while($cek = mysql_fetch_array($ad)){
   echo $cek['jdl_album'];
   }
}



selamat mencoba semoga berhasil