GLOBAL $dbh, $page_size;
function db_init(){
GLOBAL $dbh, $page_size;
$username = "root";
$password = "";
$hostname = "localhost";
$dbname = "web";
$page_size = 30;
$dbh = mysql_connect($hostname, $username, $password) ;
$selected = mysql_select_db($dbname,$dbh) ;
}
function db_close(){
GLOBAL $dbh;
mysql_close($dbh);
}
function getRecord($id){
if ($id == '0')
return array($id,'','','','');
GLOBAL $dbh;
$query = "SELECT * FROM `phones` where id=$id;";
$result = mysql_query($query);
$ar = mysql_fetch_row($result);
return $ar;
}
function NumRecords(){
$query = "SELECT count(*) FROM `phones` where 1;";
$result = mysql_query($query);
$count = mysql_fetch_row($result);
}
function show($query='', $page=1){
GLOBAL $phones, $page_size;
$phones = array();
$count = NumRecords();
if (isset($_GET['page']))
$page= $_GET['page'];
if (isset($_POST['page']))
$page= $_POST['page'];
$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;
}
?>
Phone Book
no | Name | no | created at | Operations |
foreach ($phones as $ph):
$id = $ph['id'];
$fname = $ph['fname'];
$lname = $ph['lname'];
$date = $ph['created_at'];
$number = $ph['number'];
?>
echo $id;?> |
echo $fname.' '.$lname;?> |
echo $number;?> |
echo $date;?> |
Delete
Update
|
endforeach;?>
for($i=1;;$i++){
if ($i == $page)
echo " $i ";
else
echo "$i ";
if (($i+1) * $page_size > $count)
break;
}
?>
}
function Insert($fname, $lname, $no){
$query = "INSERT INTO `phones` (`fname` ,`lname` ,`number`) VALUES ('$fname', '$lname', '$no');";
$result = mysql_query($query);
//redirect('index.php');
//show();
//header("Location:index.php");
}
function Delete($id){
$query = "DELETE FROM `phones` WHERE id=$id";
$result = mysql_query($query);
show();
}
function Search($query){
show($query);
}
function UpdateOrInsert($id, $fname, $lname, $number){
if ($id == '0')
$query = "INSERT INTO `phones` (`fname` ,`lname` ,`number`) VALUES ('$fname', '$lname', '$number');";
else
$query = "UPDATE `web`.`phones` SET `fname` = '$fname',`lname` = '$lname',`number` = '$number' WHERE `phones`.`id` =$id LIMIT 1 ;";
$result = mysql_query($query);
}
function UpdateOrInsert_control(){
db_init();
$id = $_POST['id'];
if (isset($id)){ //process submitted form
UpdateOrInsert($_POST['id'], $_POST['fname'], $_POST['lname'], $_POST['number']);
header('Location: index.php');
};
$id = $_GET['id'];
return getRecord($id);
}
function control(){
db_init();
$op = $_POST['op'];
if (!isset($op))
$op = $_GET['op'];
switch ($op){
case 'insert':
Insert($_POST['fname'], $_POST['lname'], $_POST['no']);
break;
case 'update':
update_control();
break;
case 'search':
Search($_POST['query']);
break;
case 'delete':
Delete($_GET['id']);
break;
default:
show();
}
db_close();
}
?>