OOPS PHP delete.php

<?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;
 }


?>

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);