Tuesday, February 15, 2011

insert,delet,update oops

includes folder

dbconnect.php

<?php
error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);


  $con = mysql_connect("localhost","root","") or die("fail to connect".mysql_error());
  mysql_select_db("base",$con) or die(mysql_error());
?>
main.php

<?
class operations{

  
   public $cid;
   public $cname;
   public $cfather;
   public $caddress;
  
   public function insert(){
     $sql = "INSERT INTO customer(custname,custfather,address)
              VALUES('".$this->cname."', '".$this->cfather."', '".$this->caddress."')";
     mysql_query($sql) or die("insert:".mysql_error());
   
   }
  
   //delete record
   public function delete(){
  
     $sql = "DELETE FROM customer WHERE custid=".$this->cid;
     mysql_query($sql) or die("delete".mysql_error());
    }
   
    //updating the records
   public function update(){
   
     $sql = "UPDATE customer SET custname = '".$this->cname."',
                                custfather = '".$this->cfather."',
                               address    = '".$this->caddress."'
           WHERE custid ='".$this->cid."'";
     mysql_query($sql) or die("update:".mysql_error());
    }
  
   // Display the records 
   public function display(){
     $temp_arr = array();
     $res = mysql_query("SELECT * FROM customer") or die(mysql_error());       
     $count=mysql_num_rows($res);
   
    while($row = mysql_fetch_array($res)) {
         $temp_arr[] =$row;
     }
     return $temp_arr; 
     }
     }
 ?>

.................................................
change.php

<?php
  require('includes/dbconnect.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
  <?php
    $cno=$_GET['cno'];
    $res=mysql_query("select * from customer where custid=$cno") or die(mysql_error()) ;
    $row=mysql_fetch_array($res);
  ?>
  <form action="index.php" method="post">
   <input type="hidden" name="cid" value="<?php echo $cno?>"  />
   <table><tr><td>Customer Name</td><td><input type='text' name='custname' value="<?php echo $row['custname']?>" /></td></tr>
        <tr><td>Father Name</td><td><input type='text' name='cfather' value="<?php echo $row['custfather'] ?>" /></td></tr>
        <tr><td>address</td><td><input type='text' name='caddress' value="<?php echo $row['address'] ?>" /></td></tr>
        <tr><td colspan='3'><input type='submit' name='update' value='submit' /></td></tr>
  </table>
  </form>       
 
</body>


index.php


<?php
 require_once('includes/dbconnect.php');
 require_once('includes/main.php');

 //object creation

  $obj = new operations();

 if(isset($_POST['submit'])){
     $obj->cname = $_POST['custname'];
     $obj->cfather = $_POST['cfather'];
     $obj->caddress  = $_POST['caddress'];   
     if($obj->cname=="" || $obj->cfather=="" || $obj->caddress==""){
        echo "please insert all the fields <br>";
     }
     //insert
     else{
   
     $obj->insert();
     header("Location:index.php");
     exit;
     }
  }
 
  if(isset($_POST['update'])){
   
    $obj->cid = $_POST["cid"];
    $obj->cname = $_POST['custname'];
    $obj->cfather = $_POST['cfather'];
    $obj->caddress  = $_POST['caddress'];
    if($obj->cname=="" || $obj->cfather=="" || $obj->caddress==""){
        echo "please insert all the fields";
     }
     else{
    $obj->update();
     header("Location:index.php");
     exit;
     }
  }
 
  if (isset($_GET["cno"])){
     
    $obj->cid = $_GET["cno"];
    $obj->delete();
    header("Location:index.php");
    exit;
 }


 //first displayay

?>

<input type='button' name='add' value='add' onclick=javascript:location.href='insert.php' />
<table border='1'>
<tr>
  <th>custid</th>
  <th>custname</th>
  <th>custfather</th>
  <th>address</th>
  <th>actions</th>
</tr>
<? $data = $obj->display(); ?>

<? $i = 0;
foreach( $data as $eachrecord ) {
  $i++;
 ?>

<tr>
  <td><? echo $i; ?> </td>
  <td><? echo $eachrecord ['custname']; ?></td>
   <td><? echo $eachrecord ['custfather']; ?></td>
    <td><? echo $eachrecord ['address']; ?></td>
  <td>
      <a href="index.php?cno=<? echo $eachrecord['custid']; ?>" >delete</a> |
      <a href="change.php?cno=<? echo $eachrecord['custid']; ?>">update</a>
  </td>
</tr>
<? } ?>
</table>


insert.php
<form action="index.php" method="post" >
  <table>
    <tr>
      <td>Customer Name</td>
      <td><input type='text' name='custname' id="custname" /></td>
    </tr>
    <tr>
      <td>Father Name</td>
      <td><input type='text' name='cfather' id="cfather" /></td>
    </tr>
    <tr>
      <td>address</td>
      <td><input type='text' name='caddress' id="caddress"/></td>
    </tr>
    <tr>
      <td colspan='3'><input type='submit' name='submit' value='submit'  /></td>
    </tr>
  </table>
</form>
Posted by at

27 comments:

  1. UnknownJanuary 18, 2012 at 1:54 AM

    Thanks a lot very nice and very simple is very easy to understand

    ReplyDelete
  2. janshaMay 23, 2012 at 4:52 AM

    Its nice

    ReplyDelete
  3. UnknownAugust 24, 2013 at 11:53 PM

    yes its very nice

    ReplyDelete
  4. UnknownOctober 16, 2013 at 11:54 PM

    It is Realyy Goodone.

    ReplyDelete
  5. UnknownOctober 16, 2013 at 11:56 PM

    Please add more Tutorails for OOP PHP.

    ReplyDelete
  6. UnknownOctober 19, 2013 at 2:15 AM

    warring in while($row = mysql_fetch_array($res)) {
    $temp_arr[] =$row;
    Description Resource Path Location Type
    Assignment in condition main.php /edit_delete_insert line 24 DLTK Problem

    ReplyDelete
  7. Inamullah BukshNovember 19, 2013 at 5:25 AM

    very noce

    ReplyDelete
  8. UnknownNovember 26, 2013 at 9:41 PM

    thanks for sharing such oop tuts

    ReplyDelete
  9. UnknownDecember 28, 2013 at 1:26 AM

    Thanks for sharing this concept of oops. it really nice

    ReplyDelete
    Replies
    1. UnknownSeptember 4, 2015 at 12:12 AM

      <?php
      define('DB_SERVER','localhost');
      define('DB_USER','root');
      define('DB_PASS' ,'');
      define('DB_NAME', 'dbtuts');

      class DB_con
      {
      function __construct()
      {
      $conn = mysql_connect(DB_SERVER,DB_USER,DB_PASS) or die('localhost connection problem'.mysql_error());
      mysql_select_db(DB_NAME, $conn);
      }

      public function select()
      {
      $res=mysql_query("SELECT * FROM users");
      return $res;
      }


      public function insert($fname,$lname,$city)
      {
      $res=mysql_query("insert into users (first_name,last_name,user_city) VALUES ('$fname','$lname','$city')");
      return $res;
      }

      public function delete($table,$id)
      {
      $res = mysql_query("DELETE FROM $table WHERE user_id=".$id);
      return $res;
      }

      public function update($table,$id,$fname,$lname,$city)
      {
      $res = mysql_query("UPDATE $table SET first_name='$fname', last_name='$lname', user_city='$city' WHERE user_id=".$id);
      return $res;
      }
      }

      ?>

      Delete
  10. UnknownJanuary 23, 2014 at 5:10 AM

    very nice also easy to understand....

    ReplyDelete
  11. Arshad HussainFebruary 18, 2014 at 1:26 AM

    very nice tutorial, will u help me to create project in core php using oops?

    ReplyDelete
  12. UnknownApril 7, 2014 at 12:42 PM

    is very useful for me. Thanks.

    ReplyDelete
  13. qatar shoppyJune 6, 2014 at 3:38 AM

    very nice tutorial, will u help me to create project in core php using oops?

    ReplyDelete
  14. UnknownJune 17, 2014 at 4:19 AM

    Thank u very much . A very nice and simple tutorial.. stay Blessed

    ReplyDelete
  15. M'ariseJuly 12, 2014 at 1:32 AM

    Nice nice nice*10000

    ReplyDelete
  16. UnknownJuly 19, 2014 at 12:04 AM

    very nice and simple steps to understand ooops concepts in php..................
    thanks a lllllllllllllllllllll
    ...................................
    ----------------------------
    --------------------
    -----------

    ReplyDelete
  17. ImdadulNovember 18, 2014 at 7:26 AM

    Very nice. Thanks.

    ReplyDelete
  18. ODecember 16, 2014 at 9:18 AM

    thanx for the post...
    it's helpful...

    ReplyDelete
  19. AnonymousJanuary 20, 2015 at 2:55 AM

    here not updating i'm confused

    ReplyDelete
  20. AnonymousJanuary 20, 2015 at 2:57 AM

    updating is not working here

    ReplyDelete
  21. UnknownFebruary 19, 2015 at 2:25 AM

    Nice ... Thanks For Post...

    ReplyDelete
  22. AnonymousMay 27, 2015 at 1:24 AM

    update not working here....

    ReplyDelete
  23. UnknownSeptember 4, 2015 at 1:50 AM

    update not working here

    ReplyDelete
  24. UnknownMay 19, 2016 at 1:31 AM

    here not working

    ReplyDelete
  25. UnknownSeptember 3, 2016 at 5:08 AM

    How to insert the data using ajax

    ReplyDelete
  26. UnknownSeptember 26, 2017 at 8:07 AM

    thanks

    ReplyDelete

Subscribe to: Post Comments (Atom)