create/read/update/delete data using PHP & MYSQL.

Table of Content

• Create Database
• Insert Record with image upload
• Show Record
• Edit Record
• Delete Record  

1. Creating a sample Database table 

CREATE TABLE IF NOT EXISTS `tbl_customer` (

  `id` int(11) NOT NULL AUTO_INCREMENT,

  `name` varchar(100) NOT NULL,

  `image` varchar(250) NOT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1

2.Connecting to Database   

$server = 'localhost';

$user = 'root';

$pass = '';

$connect = mysql_connect($server,$user,$pass)

or die(mysql_error());

$selectdb = mysql_select_db('mydb')

or die(mysql_error());

3. Insert & edit Record

ob_start();

include('connect.php');

if(isset($_GET['id']))

{

 $qry = "SELECT * FROM tbl_customer where id=".$_GET['id'];

 $result = mysql_query($qry);

 $row = mysql_fetch_array($result);

 if($_SERVER["REQUEST_METHOD"] == "POST")

 {

   $name = $_POST["name"];

   IF($_FILES['file']['name']!='')

   {

     $file='uploads/'.$row['image'];

     @unlink($file);

     $tmp_name = $_FILES["file"]["tmp_name"];

     $namefile = $_FILES["file"]["name"];

     $ext = end(explode(".", $namefile));

     $image_name=time().".".$ext;

     $fileUpload = move_uploaded_file($tmp_name,

     "uploads/".$image_name);

    }

    else

    {

     $image_name=$row['image'];

    }

     $sqlAdd ="update  tbl_customer set name='".$name."',

     image='".$image_name."'

     where  id=".$_GET['id'];

     mysql_query($sqlAdd);

     header("Location:add.php?id=".@$_GET['id']."&msg=success");

     exit;

    } 

}

else

{

  if($_SERVER["REQUEST_METHOD"] == "POST")

  {

    $name = $_POST["name"];

    IF($_FILES['file']['name']!='')

    {

     $tmp_name = $_FILES["file"]["tmp_name"];

     $namefile = $_FILES["file"]["name"];

     $ext = end(explode(".", $namefile));

     $image_name=time().".".$ext;

     $fileUpload = move_uploaded_file($tmp_name,

     "uploads/".$image_name);

    }

     $sqlAdd = mysql_query("insert into tbl_customer(name,image)

     VALUES('$name','$image_name')");

     header("Location:index.php?msg=success");

     exit;

   }

}

   ob_end_flush();

?>

 4.Show Record

  $allRecords = mysql_query('select * from tbl_customer ORDER BY

  id DESC limit 5');

  if(is_resource($allRecords))

  {

    while($row = mysql_fetch_assoc($allRecords))

    {

    ?>

    

     

    
class="checkbox">"checkbox"

    value=""

    name="ids[]" class="case"   />

    echo $row['name']; ?>

    echo $row['image'];

    ?>" height="30" width="30"

    />

                    

    
class="action"-->    echo $row['id']; ?>"-->

    Edit

    

    

    }

  }

?> 

5. Delete Record

if($_SERVER["REQUEST_METHOD"] == "POST")

 {

    if($_POST['action'] == "delete")

    {

          $ids = @implode(", ", $_POST['ids']);

          $qry = "SELECT * FROM  tbl_customer where id IN(".$ids.")";

          $result = mysql_query($qry);

          while($row = mysql_fetch_array($result))

          {

             $file='uploads/'.$row['image'];

             @unlink($file);

          }

          $sqlAdd ="delete from tbl_customer where id IN(".$ids.")";

          mysql_query($sqlAdd);

          header("Location:index.php?msg=success");

          exit;

    }

 }