Basic insert, view, edit, delete and update using PHP and Mysql | 2my4edge

11 December 2014

Basic insert, view, edit, delete and update using PHP and Mysql

Hi readers, today i going to post one of old topic in php and  mysql, here i'm going to post Insert data through form, and fetch / view the data from database, and also Edit, Delete and Update with detailed explanation.  i know mysql is depreciated, even most of the people are using mysql so now i'm going to use mysql and i'll update with mysqli and pdo later, now i'm going to explain the basics of php mysql functions, how to insert, fetch, delete, update like all operations. New with Codeigniter insert edit view update delete


DOWNLOAD                     LIVE DEMO

FILES
  • db.php
  • index.php
  • insert.php
  • view.php
  • edit.php
These are the files needed to execute the basic insert fetch edit delete operation, let see what the file contains. i already posted how to create database and insert code and AJAX insert without refresh the page. 

DB.PHP
first we have to connect the db file.
<?php
ob_start();
define('DB_SERVER', 'localhost');
define('DB_USERNAME', 'root');
define('DB_PASSWORD', '');
define('DB_DATABASE', '2my4edge');
$connection = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die(mysql_error());
$database = mysql_select_db(DB_DATABASE) or die(mysql_error());
?>

i believe you can get clear idea from the color variation, RED all database fields, and the other all separated one with other same.

DATABASE NAME --> 2my4edge
TABLE NAME --> sample
TABLE FIELDS --> id(int, primary key, auto increment), username(varchar), emailid(varchar), mobileno(varchar), created(timestamp)

INDEX.PHP
<!DOCTYPE>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Insert form</title>
<link type="text/css" media="all" rel="stylesheet" href="style.css">
</head>

<body>
<div class="display">
<form action="insert.php" method="post" name="insertform">
<p>
  <label for="name" id="preinput"> USER NAME : </label>
  <input type="text" name="username" required placeholder="Enter your name" id="inputid"/>
</p>
<p>
  <label  for="email" id="preinput"> EMAIL ID : </label>
  <input type="email" name="usermail" required placeholder="Enter your Email" id="inputid" />
</p>
<p>
  <label for="mobile" id="preinput"> MOBILE NUMBER : </label>
  <input type="text" name="usermobile" required placeholder="Enter your mobile number" 
                                                           id="inputid" />
</p>
<p>
  <input type="submit" name="send" value="Submit" id="inputid1"  />
</p>
</form>
</div>
<?php include('view.php'); ?>
</body>
</html>
here i'm just viewing the view.php file below the form but you can make that separate page for that. the action will be on insert.php page. method is post.

INSERT.PHP
the index.php page form is run in the insert.php.
<?php
 ob_start();
  include("db.php");
  if(isset($_POST['send'])!="")
  {
  $username=mysql_real_escape_string($_POST['username']);
  $usermail=mysql_real_escape_string($_POST['usermail']);
  $usermobile=mysql_real_escape_string($_POST['usermobile']);
  $update=mysql_query("INSERT INTO sample(username,emailid,mobileno,created)VALUES
                                      ('$username','$usermail','$usermobile',now())");
  
  if($update)
  {
      $msg="Successfully Updated!!";
      echo "<script type='text/javascript'>alert('$msg');</script>";
      header('Location:index.php');
  }
  else
  {
     $errormsg="Something went wrong, Try again";
      echo "<script type='text/javascript'>alert('$errormsg');</script>";
  }
  }
 ob_end_flush();
?>
if the data is successfully registered, the header location will be to index.php

VIEW.PHP
<?php
 include('db.php');
  $select=mysql_query("SELECT * FROM sample order by id desc");
  $i=1;
  while($userrow=mysql_fetch_array($select))
  {
  $id=$userrow['id'];
  $username=$userrow['username'];
  $usermail=$userrow['emailid'];
  $usermobile=$userrow['mobileno'];
  $created=$userrow['created']
?>

<div class="display">
  <p> USER NAME : <span><?php echo $username; ?></span>
    <a href="delete.php?id=<?php echo $id; ?>" 
    onclick="return confirm('Are you sure you wish to delete this Record?');">
            <span class="delete" title="Delete"> X </span></a>
  </p>
  <br />
  <p> EMAIL ID : <span><?php echo $usermail; ?></span>
    <a href="edit.php?id=<?php echo $id; ?>"><span class="edit" title="Edit"> E </span></a>
  </p>
  <br />
  <p> MOBILE NO : <span><?php echo $usermobile; ?></span>
  </p>
  <br />
  <p> CREATED ON : <span><?php echo $created; ?></span>
  </p>
  <br />
</div>
<?php } ?>


View page contains edit and delete link in the while loop, here we are passing the values though id for edit and delete, like

<a href="delete.php?id=<?php echo $id; ?>" 
    onclick="return confirm('Are you sure you wish to delete this Record?');"> X </a>
<a href="edit.php?id=<?php echo $id; ?>"> E </a>
 we have to give this link before the while loop ends,

DELETE.PHP
<?php
  ob_start();
  include("db.php");
  if(isset($_GET['id'])!="")
  {
  $delete=$_GET['id'];
  $delete=mysql_query("DELETE FROM sample WHERE id='$delete'");
  if($delete)
  {
      header("Location:index.php");
  }
  else
  {
      echo mysql_error();
  }
  }
  ob_end_flush();
?>
the delete.php is deleting the data what are the data is there in the ID. if successfully deleted the page will goes to index.php page.



EDIT.PHP
this edit page contains both edit form and also update code.
<?php 
ob_start();
include('db.php');
if(isset($_GET['id']))
{
  $id=$_GET['id'];
  if(isset($_POST['update']))
  {
  $eusername=$_POST['eusername'];
  $eusermail=$_POST['eusermail'];
  $emobile=$_POST['eusermobile'];
  $updated=mysql_query("UPDATE sample SET 
        username='$eusername', emailid='$eusermail', mobileno='$emobile' WHERE id='$id'")
or die();
  if($updated)
  {
  $msg="Successfully Updated!!";
  header('Location:index.php');
  }
}
}  //update ends here
ob_end_flush();
?>
<!DOCTYPE>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Edit form</title>
<link type="text/css" media="all" rel="stylesheet" href="style.css">
</head>

<body>
<?php 
  if(isset($_GET['id']))
  {
  $id=$_GET['id'];
  $getselect=mysql_query("SELECT * FROM sample WHERE id='$id'");
  while($profile=mysql_fetch_array($getselect))
  {
    $username=$profile['username'];
    $usermail=$profile['emailid'];
    $usermobile=$profile['mobileno'];
?>
<div class="display">
  <form action="" method="post" name="insertform">
    <p>
      <label for="name"  id="preinput"> USER NAME : </label>
      <input type="text" name="eusername" required placeholder="Enter your name" 
      value="<?php echo $username; ?>" id="inputid" />
    </p>
    <p>
      <label  for="email"  id="preinput"> EMAIL ID : </label>
      <input type="email" name="eusermail" required placeholder="Enter your Email" 
      value="<?php echo $usermail; ?>" id="inputid" />
    </p>
    <p>
      <label for="mobile" id="preinput"> MOBILE NUMBER : </label>
      <input type="text" name="eusermobile" required placeholder="Enter your mobile number" 
      value="<?php echo $usermobile; ?>" id="inputid" />
    </p>
    <p>
      <input type="submit" name="update" value="Update" id="inputid1" />
    </p>
  </form>
</div>
<?php } } ?>
</body>
</html>



REALATED POSTS :










79 comments:

  1. Anonymous12/18/2014 4:41 PM

    I am beginner for php. tutorial was helped me lot. thank u .

    ReplyDelete
  2. Anonymous2/28/2015 2:05 PM

    thank for coding

    ReplyDelete
  3. Anonymous3/24/2015 5:33 PM

    Good script, this can be the beginning of something great

    ReplyDelete
  4. kunalghosh5/01/2015 12:57 AM

    wow !!!!!

    really too much useful and helpful too

    thanx Arunkumar Maha for these work

    ReplyDelete
  5. Anonymous5/06/2015 12:44 PM

    notbad

    ReplyDelete
  6. Anonymous6/09/2015 2:26 PM

    your site is too much loading when it was open...................

    ReplyDelete
  7. krunal sapra6/24/2015 3:23 PM

    thank you your site is very useful

    ReplyDelete
  8. Anonymous7/11/2015 1:21 PM

    when will you release the codes for pdo? mysql is already depreciated. thanks!

    ReplyDelete
  9. belajarhebat8/06/2015 7:52 AM

    thanks for information and the artikel is not bad

    ReplyDelete
  10. Anonymous8/13/2015 5:30 PM

    Thanks for the nice documentation. Its really helpful for the beginner.......

    ReplyDelete
  11. Anonymous8/21/2015 1:59 PM

    Hi, i'm a newbie in PHP coding. May I ask which part does the form validation located?

    ReplyDelete
  12. Anonymous9/01/2015 12:20 PM

    Thanks for the nice documentation. Its really helpful for the beginner....... thanks very muchhhh

    ReplyDelete
  13. V V Ramanareddy9/09/2015 11:50 PM

    Thank Q so much. these examples are very useful.

    ReplyDelete
  14. Anonymous9/11/2015 6:29 PM

    wow thanks for this tutorial. this the best tutorial that i see in the web so far.

    ReplyDelete
  15. Unknown10/02/2015 8:06 PM

    do you know what is panel manager in vb.net because i think that is the best way to create a tabulated form using panel and a button hide or unhide, that panel is too good to use than using tabcontrol in a 1 form in vb.net

    ReplyDelete
  16. Unknown10/02/2015 8:07 PM

    hey guys

    ReplyDelete
  17. RJ10/17/2015 10:04 PM

    I'm a first year computer science student and it's help me a lot.
    Thank you.

    ReplyDelete
    Replies
    1. Anonymous8/20/2016 2:20 PM

      Aww To Easy for me you Know That

      Delete
  18. Unknown10/29/2015 2:42 PM

    THANKS FOR THE USEFUL CODES

    ReplyDelete
  19. SPAC Starch India10/30/2015 1:28 PM

    Thanks for the useful post.

    ReplyDelete
  20. Anand10/31/2015 7:02 PM

    Thanks for the post. Keep it up guys.

    ReplyDelete
  21. Unknown11/20/2015 10:05 AM

    Thank You so much. I'm a beginner, it helped me a lot..

    ReplyDelete
  22. Unknown11/30/2015 6:42 PM

    i am really appreciated with your academic help. PS

    ReplyDelete
  23. Unknown12/04/2015 10:59 AM

    How to view the data from db and modify the data then update data?

    ReplyDelete
  24. Anonymous12/06/2015 9:04 PM

    this example is helped me a lot.......

    ReplyDelete
  25. monraj12/26/2015 1:08 AM

    Its Clear ...good job and Thanks

    ReplyDelete
  26. Anonymous12/26/2015 5:51 PM

    really this is help for beginners...
    thank you!!!!

    ReplyDelete
  27. Unknown1/20/2016 7:55 AM

    I have a problem I cannot figure out. I used the above scripts, I can add but I cannot edit, I get a blank screen. I have found other examples on the net and have the same issue. I would think it is permissions but I can add and I get the response back after adding. Any idea's?

    ReplyDelete
  28. Rational Technologies2/05/2016 7:10 PM

    Thanks For sharing

    www.rationaltechnologies.com

    ReplyDelete
  29. Unknown2/07/2016 12:29 AM

    i am not able to insert data. it display nothing.

    ReplyDelete
    Replies
    1. shashi.websoft6/30/2016 5:21 PM

      BHAI PLS CHECK THE TABLE NMBR IS WRONG ON EDIT PAGE, PLS CHECK IN THESE 2 Vriables
      1- $updated
      2-$getselect

      Delete
    2. finesms1/21/2017 11:38 PM

      Please give me solution of this Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Final\edit.php on line 37

      Delete
    3. finesms1/21/2017 11:38 PM

      Please give me solution of this Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Final\edit.php on line 37

      Delete
    4. Unknown4/24/2017 5:11 PM

      I experience this warning.Please chech your select query,Data is get or not

      Delete
  30. Webslesson2/15/2016 5:36 PM

    Nice tutorials for beginner, thanks for sharing this tutorial.

    ReplyDelete
  31. Unknown2/24/2016 1:05 PM

    Thanks so much..this tutorial.

    All the Best.





    juber khan

    ReplyDelete
  32. Unknown2/24/2016 1:17 PM

    Thanks !
    All the Best


    Juber khan

    ReplyDelete
  33. Unknown3/03/2016 2:39 PM

    its a very good code program i help fully ..

    ReplyDelete
  34. Unknown3/07/2016 2:37 PM

    Thanks a lot. Your code is really helpful.

    All the best.

    ReplyDelete
  35. sumwonlost3/14/2016 8:00 AM

    Thanks for your coding, very helpful, I do however have 1 question. Can these 4 files (view, add, edit, delete) be combined in 1 file?

    ReplyDelete
  36. sumwonlost3/14/2016 8:09 AM

    Thanks for your coding, very helpful, I do however have 1 question. Can these 4 files (view, add, edit, delete) be combined in 1 file?

    ReplyDelete
  37. Unknown3/28/2016 1:24 PM

    thank u so much...really helpful this tutorial

    ReplyDelete
  38. Unknown4/21/2016 2:26 PM

    Nice Code

    ReplyDelete
  39. Anonymous4/22/2016 8:01 AM

    Wow Thank you so much. This is just what i was looking for. And it worked on my first try! Thanks again

    ReplyDelete
  40. Anonymous4/27/2016 3:21 PM

    simple example in insert delete in php

    ReplyDelete
  41. Unknown5/13/2016 11:58 AM

    sir....i did like this
    but edit form is completely white....help me

    ReplyDelete
  42. Unknown7/13/2016 6:27 PM

    Very help full INFORMATION,,,,SIR

    ReplyDelete
  43. Unknown7/15/2016 11:15 AM

    style.css file is needed.

    ReplyDelete
  44. Unknown8/03/2016 8:41 PM

    Your tutorials inspired me to start a blog.
    Insert Update Delete in PHP

    ReplyDelete
  45. Anonymous8/13/2016 5:47 AM

    Thanks for the tutorial.

    Ahmad
    Miri, Sarawak, Malaysia.

    ReplyDelete
  46. African largest suppliers of gold and rough diamond8/18/2016 11:20 AM

    You are a gifted programmer and a good teacher. Thanks a lot.

    ReplyDelete
  47. Anonymous8/20/2016 12:04 AM

    action=""
    In edit.php what action we need to give

    ReplyDelete
  48. Anonymous8/20/2016 2:20 PM

    this is piece of shit

    ReplyDelete
  49. Anonymous9/08/2016 3:15 PM

    how to get single record of table in database by using login page(php)

    ReplyDelete
  50. Anonymous9/09/2016 1:01 PM

    what is the table called iedu

    ReplyDelete
  51. Unknown9/24/2016 2:53 PM

    Fatal error: Call to undefined function mysql_connect() in C:\xampp\htdocs\database\db.php on line 7

    ReplyDelete
  52. Anonymous9/26/2016 10:13 PM

    Hi i am newbie this is my problem
    ( ! ) Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\gelo\EDIT.PHP on line 37
    Call Stack
    # Time Memory Function Location
    1 0.0010 145560 {main}( ) ..\EDIT.PHP:0
    2 0.0410 169096 mysql_fetch_array ( ) ..\EDIT.PHP:37
    can you help me please? thank you

    ReplyDelete
  53. Unknown10/26/2016 6:27 PM

    thank u so much.

    ReplyDelete
  54. Anonymous12/13/2016 5:19 PM

    thank u for sharing this

    ReplyDelete
  55. Unknown12/26/2016 9:56 AM

    Edit.php is not workig

    ReplyDelete
  56. Unknown1/02/2017 10:10 AM

    thank you so much

    ReplyDelete
  57. Unknown1/02/2017 10:10 AM

    thank you so much

    ReplyDelete
  58. Unknown1/02/2017 11:48 AM

    can u do this in MVC ?

    ReplyDelete
  59. Unknown2/02/2017 7:02 PM

    Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\edit\edit.php on line 37

    ReplyDelete
  60. Anonymous2/18/2017 12:24 PM

    how to view data in edit page for editing

    ReplyDelete
  61. Unknown3/04/2017 4:30 PM

    Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ..Best PHP Training in Chennai|PHP Training in Chennai

    ReplyDelete
  62. Unknown3/31/2017 3:44 PM

    A lot of many many thank to u sir because i have many problem in crud function .so i learned all crud function......

    ReplyDelete
  63. Unknown4/07/2017 5:11 AM

    please in the edit.php i want to know what the iedu stands for

    ReplyDelete
    Replies
    1. As of now4/07/2017 8:16 AM

      Sorry @T-Rex xx, That is actually table name, i have changed now. that `sample`. table name.

      Delete
  64. Samila4/12/2017 1:27 PM

    What is the function ob_start(); for ?

    ReplyDelete
  65. Unknown5/18/2017 10:23 AM

    Its really good documentation for both fresher and experience also
    Great work....!

    ReplyDelete
  66. Unknown6/06/2017 3:49 PM

    Thank mr this cod is vre useful

    ReplyDelete
  67. Unknown6/06/2017 3:55 PM

    Thank you This cod is very useful

    ReplyDelete
  68. Unknown9/23/2017 10:58 AM

    thank you so much ... really it's very easy and simple code .....very very useful... thanks again

    ReplyDelete

Subscribe to: Post Comments (Atom)
^