<?php
require_once('include/config.php');
$db = new Database();
//delete about page multiple
if(isset($_GET['type']) && $_GET['type'] == "multiple_delete_aboutus")
{
$ids = $_POST['id']; foreach ($ids as $id)
{
$del_query = "DELETE FROM queryabout WHERE a_id = '$id'";
$db->execute($del_query);
}
return 0;
}
//delete about page single
if(isset($_GET['type']) && $_GET['type'] == 'singledelete_aboutus')
{
$id = $_GET['id'];
$query = "DELETE FROM queryabout WHERE a_id = '$id'";
if($db->execute($query))
return 0;
else
return 1;
}
//delete Services page multiple
if(isset($_GET['type']) && $_GET['type'] == "delete_car_details")
{
$ids = $_POST['id']; foreach ($ids as $id)
{
$del_query = "DELETE FROM our_car WHERE car_id = '$id'";
$db->execute($del_query);
}
return 0;
}
//delete page single
if(isset($_GET['type']) && $_GET['type'] == 'singal_delete_car_d')
{
$id = $_GET['id'];
$query = "DELETE FROM our_car WHERE car_id = '$id'";
if($db->execute($query))
return 0;
else
return 1;
}
?>
SQL
ALTER
Using Alter Statement we Can Modify column name Add column and Change Data Types
ADD Statement
ALTER TABLE QueryPanel_Employees ADD COLUMN shift VARCHAR(255);
MODIFY Statement
ALTER TABLE QueryPanel_employees MODIFY COLUMN shift char(25);
CHANGE NAME
ALTER TABLE QueryPanel_employees CHANGE COLUMN shift shift_time varchar(225);
DROP COLUMN
ALTER TABLE QueryPanel_employees DROP COLUMN Shift_time;
MULTIPLE COLUMN ADD
ALTER TABLE QueryPanel_employees ADD COLUMN Shift VARCHAR(255),ADD COLUMN Timing DATETIME(6);