Script de cautare

Scris de **Luky.** Sam Iun 19, 2010 1:18 pm

Cod:: Cod: <?php $_mysql_host="localhost"; // Host baza de date $_mysql_db="site"; // Baza de date $_mysql_user="username"; // User baza de date $_mysql_password="password"; // Parola baza de date $conexiune = mysql_connect($_mysql_host,$_mysql_user,$_mysql_password) or die("<center>Nu ma pot conecta la MySQL!</center>"); mysql_select_db($_mysql_db, $conexiune) or die("Nu gasesc baza de date".mysql_error()); echo "<br /> <form method='post' action=''>"; echo "<center>Cauta: <input type='text' size='25' name='search' /> <input type='submit' name='submit' value='Cauta' /></center>"; echo "</form> <br />"; $search = $_POST['search']; $search = strtoupper($search); $search = strip_tags($search); $search = trim ($search); if($_POST['submit'] == "Cauta") { $sql = "SELECT * FROM `tabel` WHERE LIKE'%$search%'"; $result = mysql_query($sql) or die("Nu am putut executa scriptul :( . Eroare: ".mysql_error()); $data = mysql_num_rows($result); if($data == "0") { echo "<center><b>Cuvantul introdus nu se potriveste cu nimic din baza de date</b></center>"; } else { if($_POST['search'] == "") { echo "<center><b>Nu ai completat tot</b></center>"; } else { // aici pui scriptu pe care o sa afiseze cand o sa ai rezultatele cautarii } ?>