GLOBAL $dbh, $page_size; function db_init(){ GLOBAL $dbh, $page_size; $username = "root"; $password = ""; $hostname = "localhost"; $dbname = "web"; $page_size = 20; $dbh = mysql_connect($hostname, $username, $password) ; $selected = mysql_select_db($dbname,$dbh) ; } function db_close(){ GLOBAL $dbh; mysql_close($dbh); } function show($query='', $page=1){ GLOBAL $phones, $page_size; $phones = array(); $limit = ''; $offset = ($page-1)*$page_size; $limit = " LIMIT $offset, $page_size"; $condition = '1'; if ($query != ''){ $condition = " (id = '$query') || (fname LIKE '%$query%') || (lname LIKE '%$query%') || (number LIKE '%$query%')"; }; $query = "SELECT * FROM `phones` where $condition $limit;"; $result = mysql_query($query); while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) { $phones[] = $row; } ?>
no | Name | no | created at | Operations |
echo $id;?> | echo $fname.' '.$lname;?> | echo $number;?> | echo $date;?> | Delete Update |