How to build a search code using php? please advise me.

mamn85

hello everybody,

i feel very tension because i still can't develop search page using php. i dont have any idea how to develop search page via php. Please anyone help me. I've just built this code to search my database through web base. Please advise me...

<?php

include 'conn.php';

$query = "SELECT * FROM sesi WHERE semester='$semester' AND bulan='$bulan' AND tahun='$tahun' LIKE '" . $cari . "'";

?>
<html>
<h1>Carian</h1>
<form action="cari_sesi.php" method="GET">
Sem : <select name="semester">
<option value="SATU">SATU</option>
<option value="DUA">DUA</option>
<option value="TIGA">TIGA</option>
<option value="EMPAT">EMPAT</option>
</select>
Bulan : <select name="bulan">
<option value="JANUARI">JANUARI</option>
<option value="JUN">JUN</option>
</select>
Tahun : <input type="text" name="tahun">
<input type="submit" name="cari" value="GO !">
</form>
</html>

i dont how to solve this problem. please anyone help me. 😕

intenz

SELECT * FROM table WHERE foo LIKE '%$foo%' AND bar LIKE '%$bar%' AND foobar LIKE '%$foobar%'

mamn85

what is 'foo' ? is it a php syntax? 😕

dagon

The terms foobar, foo, bar, and baz are common placeholder names (also referred to as metasyntactic variables) used in computer programming or computer-related documentation.

http://en.wikipedia.org/wiki/FOo

intenz

mamn85;10953927 wrote:
what is 'foo' ? is it a php syntax? 😕

No just to demonstrate how an actual search query would look like. You just replace foo/bar/foobar with your MySQL field names and variables.