01.<?
02.$hostname = "localhost";
03.$user = "nbrregiste_user";
04.$password = "5504015933";
05.$dbname = "nbrregiste_nbrwatpondb";
06.$tblname = "students";
07.$field_search = "student_studentid";
08.mysql_connect($hostname, $user, $password) or die("µÔ´µèÍ°Ò¹¢éÍÁÙÅäÁèä´é");
09.mysql_select_db($dbname) or die("àÅ×Í¡°Ò¹¢éÍÁÙÅäÁèä´é");
10.$sql = "select * from students where student_idcard like '%$search%'";
11.$dbquery = mysql_db_query($dbname, $sql);
12.$num_rows = mysql_num_rows($dbquery);
13.$i=0;
14.while ($i < $num_rows)
15.{
16.$result = mysql_fetch_array($dbquery);
17.$id = $result[student_idcard];
18.$name = $result[student_name];
19.$grade = $result[student_oldschool];
20.echo "ÃËÑÊ : $id - ª×èÍ : $name - à¡Ã´ : $grade <BR>";
21.$i++;
22.}
23.mysql_close();
24.?>
