Simple jQuery Add, Update, Delete with PHP and MySQL

On 12/14/2015 By Pradeep Khodke

In this tutorial we will cover a simple Insert, Update and Delete using jQuery, PHP and MySQL with PDO, well we have lot's of CRUD tutorials on this blog but we haven't jQuery CRUD tutorial yet, and few email requests i received from readers regarding jQuery Insert, Update, Delete with PHP MySQL, so here in this tutorial we will do it, using jQuery to perform such operations become easy and for the better user interface bootstrap is here i have used, let's start.

Simple jQuery Insert, Update, Delete with PHP & MySQL

Download Script

Database & Table

i have created employees table here in "jquery_crud" database, just create "jquery_crud" database in your PHPMyAdmin and paste following SQL code it will create the table.


CREATE TABLE IF NOT EXISTS `tbl_employees` (
  `emp_id` int(11) NOT NULL AUTO_INCREMENT,
  `emp_name` varchar(25) NOT NULL,
  `emp_dept` varchar(50) NOT NULL,
  `emp_salary` varchar(7) NOT NULL,
  PRIMARY KEY (`emp_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

dbconfig.php

as usual simple database configuration file with PDO extension.

<?php

 $db_host = "localhost";
 $db_name = "jquery_crud";
 $db_user = "root";
 $db_pass = "";
 
 try{
  
  $db_con = new PDO("mysql:host={$db_host};dbname={$db_name}",$db_user,$db_pass);
  $db_con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 }
 catch(PDOException $e){
  echo $e->getMessage();
 }

?>

index.php

i know it looks little lengthy but to use bootstrap design and jquery functions we have to add, contains code which displays MySQL employee records from the table, little jQuery i have used here it will used to load insert, update form directly without page refresh, MySQL records will be displayed within jQuery Datatable.


<!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=utf-8" />
<title>Insert, Update, Delete using jQuery, PHP and MySQL</title>
<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet" media="screen">
<link href="bootstrap/css/bootstrap-theme.min.css" rel="stylesheet" media="screen"> 
<link href="assets/datatables.min.css" rel="stylesheet" type="text/css">

<script type="text/javascript" src="assets/jquery-1.11.3-jquery.min.js"></script>

<script type="text/javascript">
$(document).ready(function(){
 
 $("#btn-view").hide();
 
 $("#btn-add").click(function(){
  $(".content-loader").fadeOut('slow', function()
  {
   $(".content-loader").fadeIn('slow');
   $(".content-loader").load('add_form.php');
   $("#btn-add").hide();
   $("#btn-view").show();
  });
 });
 
 $("#btn-view").click(function(){
  
  $("body").fadeOut('slow', function()
  {
   $("body").load('index.php');
   $("body").fadeIn('slow');
   window.location.href="index.php";
  });
 });
 
});
</script>

</head>

<body>
    

 <div class="container">
      
        <h2 class="form-signin-heading">Employee Records.</h2><hr />
        <button class="btn btn-info" type="button" id="btn-add"> <span class="glyphicon glyphicon-pencil"></span> &nbsp; Add Employee</button>
        <button class="btn btn-info" type="button" id="btn-view"> <span class="glyphicon glyphicon-eye-open"></span> &nbsp; View Employee</button>
        <hr />
        
        <div class="content-loader">
        
        <table cellspacing="0" width="100%" id="example" class="table table-striped table-hover table-responsive">
        <thead>
        <tr>
        <th>Emp ID</th>
        <th>Emp Name</th>
        <th>department</th>
        <th>salary</th>
        <th>edit</th>
        <th>delete</th>
        </tr>
        </thead>
        <tbody>
        <?php
        require_once 'dbconfig.php';
        
        $stmt = $db_con->prepare("SELECT * FROM tbl_employees ORDER BY emp_id DESC");
        $stmt->execute();
  while($row=$stmt->fetch(PDO::FETCH_ASSOC))
  {
   ?>
   <tr>
   <td><?php echo $row['emp_id']; ?></td>
   <td><?php echo $row['emp_name']; ?></td>
   <td><?php echo $row['emp_dept']; ?></td>
   <td><?php echo $row['emp_salary']; ?></td>
   <td align="center">
   <a id="<?php echo $row['emp_id']; ?>" class="edit-link" href="#" title="Edit">
   <img src="edit.png" width="20px" />
            </a></td>
   <td align="center"><a id="<?php echo $row['emp_id']; ?>" class="delete-link" href="#" title="Delete">
   <img src="delete.png" width="20px" />
            </a></td>
   </tr>
   <?php
  }
  ?>
        </tbody>
        </table>
        
        </div>

    </div>
    
<script src="bootstrap/js/bootstrap.min.js"></script>
<script type="text/javascript" src="assets/datatables.min.js"></script>
<script type="text/javascript" src="crud.js"></script>

<script type="text/javascript" charset="utf-8">
$(document).ready(function() {
 $('#example').DataTable();

 $('#example')
 .removeClass( 'display' )
 .addClass('table table-bordered');
});
</script>
</body>
</html>

add_form.php

simple html form to insert employee records contains three text box to enter employee name, department and salary, it will be loaded within "index.php" by clicking "add employee" button.


<style type="text/css">
#display{
 display:none;
}
</style>
    
    <div id="display">
    <!-- here message will be displayed -->
 </div>
        
  
  <form method='post' id='emp-SaveForm' action="#">
 
    <table class='table table-bordered'>
 
        <tr>
            <td>Employee Name</td>
            <td><input type='text' name='emp_name' class='form-control' placeholder='EX : john doe' required /></td>
        </tr>
 
        <tr>
            <td>Employee Department</td>
            <td><input type='text' name='emp_dept' class='form-control' placeholder='EX : Web Design, App Design' required></td>
        </tr>
 
        <tr>
            <td>Employee Salary</td>
            <td><input type='text' name='emp_salary' class='form-control' placeholder='EX : 180000' required></td>
        </tr>
 
        <tr>
            <td colspan="2">
            <button type="submit" class="btn btn-primary" name="btn-save" id="btn-save">
      <span class="glyphicon glyphicon-plus"></span> Save this Record
   </button>  
            </td>
        </tr>
 
    </table>
</form>

create.php

this will insert a new record using jQuery into tbl_employees, on submit button click #emp-SaveForm form will be submitted using jQuery.


<?php
require_once 'dbconfig.php';
 
 if($_POST)
 {
  $emp_name = $_POST['emp_name'];
  $emp_dept = $_POST['emp_dept'];
  $emp_salary = $_POST['emp_salary'];
  
  try{
   
   $stmt = $db_con->prepare("INSERT INTO tbl_employees(emp_name,emp_dept,emp_salary) VALUES(:ename, :edept, :esalary)");
   $stmt->bindParam(":ename", $emp_name);
   $stmt->bindParam(":edept", $emp_dept);
   $stmt->bindParam(":esalary", $emp_salary);
   
   if($stmt->execute())
   {
    echo "Successfully Added";
   }
   else{
    echo "Query Problem";
   } 
  }
  catch(PDOException $e){
   echo $e->getMessage();
  }
 }
?>

edit_form.php

to fetch editable data from index.php and the data will be set within the following text box to update, this will loaded too within index.php file in #container div, this jquery code will set QueryString to edit_form.php : $(".content-loader").load('edit_form.php?edit_id='+edit_id);


<?php
include_once 'dbconfig.php';

if($_GET['edit_id'])
{
 $id = $_GET['edit_id']; 
 $stmt=$db_con->prepare("SELECT * FROM tbl_employees WHERE emp_id=:id");
 $stmt->execute(array(':id'=>$id)); 
 $row=$stmt->fetch(PDO::FETCH_ASSOC);
}

?>
<style type="text/css">
#dis{
 display:none;
}
</style>
    
    <div id="dis">
    
 </div>
         
  <form method='post' id='emp-UpdateForm' action='#'>
 
    <table class='table table-bordered'>
   <input type='hidden' name='id' value='<?php echo $row['emp_id']; ?>' />
        <tr>
            <td>Employee Name</td>
            <td><input type='text' name='emp_name' class='form-control' value='<?php echo $row['emp_name']; ?>' required></td>
        </tr>
 
        <tr>
            <td>Employee Department</td>
            <td><input type='text' name='emp_dept' class='form-control' value='<?php echo $row['emp_dept']; ?>' required></td>
        </tr>
 
        <tr>
            <td>Employee Salary</td>
            <td><input type='text' name='emp_salary' class='form-control' value='<?php echo $row['emp_salary']; ?>' required></td>
        </tr>
 
        <tr>
            <td colspan="2">
            <button type="submit" class="btn btn-primary" name="btn-update" id="btn-update">
      <span class="glyphicon glyphicon-plus"></span> Save Updates
   </button>
            </td>
        </tr>
 
    </table>
</form>

update.php

simple file which will update the selected row from the "edit_form.php" and this will be loaded too via a jQuery on submit function.


<?php
require_once 'dbconfig.php';
 
 if($_POST)
 {
  $id = $_POST['id'];
  $emp_name = $_POST['emp_name'];
  $emp_dept = $_POST['emp_dept'];
  $emp_salary = $_POST['emp_salary'];
  
  $stmt = $db_con->prepare("UPDATE tbl_employees SET emp_name=:en, emp_dept=:ed, emp_salary=:es WHERE emp_id=:id");
  $stmt->bindParam(":en", $emp_name);
  $stmt->bindParam(":ed", $emp_dept);
  $stmt->bindParam(":es", $emp_salary);
  $stmt->bindParam(":id", $id);
  
  if($stmt->execute())
  {
   echo "Successfully updated";
  }
  else{
   echo "Query Problem";
  }
 }
?>

delete.php

this file will delete rows from mysql - a simple code loaded via jQuery and delete rows from mysql without page refresh. id will be get through this function : $.post('delete.php', {'del_id':del_id}


<?php
include_once 'dbconfig.php';

if($_POST['del_id'])
{
 $id = $_POST['del_id']; 
 $stmt=$db_con->prepare("DELETE FROM tbl_employees WHERE emp_id=:id");
 $stmt->execute(array(':id'=>$id)); 
}
?>

crud.js

finally here is the complete jQuery file which will responsible to perform Insert, Update and Delete contains only jQuery/JavaScript code.


// JavaScript Document

$(document).ready(function(){
 
 /* Data Insert Starts Here */
 $(document).on('submit', '#emp-SaveForm', function() {
   
    $.post("create.php", $(this).serialize())
        .done(function(data){
   $("#dis").fadeOut();
   $("#dis").fadeIn('slow', function(){
     $("#dis").html('<div class="alert alert-info">'+data+'</div>');
        $("#emp-SaveForm")[0].reset();
       }); 
   });   
      return false;
    });
 /* Data Insert Ends Here */
 
 
 /* Data Delete Starts Here */
 $(".delete-link").click(function()
 {
  var id = $(this).attr("id");
  var del_id = id;
  var parent = $(this).parent("td").parent("tr");
  if(confirm('Sure to Delete ID no = ' +del_id))
  {
   $.post('delete.php', {'del_id':del_id}, function(data)
   {
    parent.fadeOut('slow');
   }); 
  }
  return false;
 });
 /* Data Delete Ends Here */
 
 /* Get Edit ID  */
 $(".edit-link").click(function()
 {
  var id = $(this).attr("id");
  var edit_id = id;
  if(confirm('Sure to Edit ID no = ' +edit_id))
  {
   $(".content-loader").fadeOut('slow', function()
    {
    $(".content-loader").fadeIn('slow');
    $(".content-loader").load('edit_form.php?edit_id='+edit_id);
    $("#btn-add").hide();
    $("#btn-view").show();
   });
  }
  return false;
 });
 /* Get Edit ID  */
 
 /* Update Record  */
 $(document).on('submit', '#emp-UpdateForm', function() {
  
    $.post("update.php", $(this).serialize())
        .done(function(data){
   $("#dis").fadeOut();
   $("#dis").fadeIn('slow', function(){
        $("#dis").html('<div class="alert alert-info">'+data+'</div>');
        $("#emp-UpdateForm")[0].reset();
     $("body").fadeOut('slow', function()
     {
     $("body").fadeOut('slow');
     window.location.href="index.php";
     });     
       }); 
  });   
     return false;
    });
 /* Update Record  */
});

if you have any query regarding this tutorial fill free to contact me, download this jQuery Add, Update, Delete tutorial and try it, that's it isn't it simple :)

Hi Sovrn

52 comments:

Ayobami12/20/2015 6:49 PM
Thanks for this wonderful tutorial, can i modify this to include the job cadre? Also, can one use jquery CRUD method to design billing system? thanks again and again
ReplyDelete
Replies
Jayanthi m1/01/2016 11:51 PM
Its not downloading.please helo me
ReplyDelete
Replies
DOVESPRING CONSULTING1/03/2016 8:05 AM
Thanks for you blog, it has really helped me in learning fast. I followed this tutorial. i tweak it a little for the inventory project that i am doing but i have this error. Please can you help me? I often have this error message:

Notice: Undefined index: stock_status in C:\xampp\htdocs\stock\create.php on line 14

Notice: Undefined index: date_supplied in C:\xampp\htdocs\stock\create.php on line 15
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'stock_descr' cannot be null

I have this table
CREATE TABLE IF NOT EXISTS `stock` (
`stock_id` tinyint(5) NOT NULL AUTO_INCREMENT,
`stock_name` varchar(20) NOT NULL,
`stock_categ` varchar(20) NOT NULL,
`stock_descr` varchar(50) NOT NULL,
`stock_comp` varchar(20) NOT NULL,
`stock_supp` varchar(20) NOT NULL,
`stock_quan` int(11) NOT NULL,
`cost` int(11) NOT NULL,
`stock_status` enum('Available','Inavailable') NOT NULL,
`date_supplied` date NOT NULL,
PRIMARY KEY (`stock_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

The create.php scrpt is
prepare("INSERT INTO stock(stock_name,stock_categ,stock_descr,stock_comp,stock_supp,stock_quan,cost,stock_status,date_supplied) VALUES(:sname, :scateg, :sdescr,:scomp, :ssupp, :squan,:scost, :sstatus, :ssupplied)");
$stmt->bindParam(":sname", $stock_name);
$stmt->bindParam(":scateg", $stock_categ);
$stmt->bindParam(":sdescr", $$stock_descr);
$stmt->bindParam(":scomp", $stock_comp);
$stmt->bindParam(":ssupp", $stock_supp);
$stmt->bindParam(":squan", $stock_quan);
$stmt->bindParam(":scost", $cost);
$stmt->bindParam(":sstatus", $stock_status);
$stmt->bindParam(":ssupplied", $date_supplied);

if($stmt->execute())
{
echo "Successfully Added";
}
else{
echo "Query Problem";
}
}
catch(PDOException $e){
echo $e->getMessage();
}
}

?>
The update.php code is
prepare("UPDATE stock SET stock_name=:sn, stock_categ=:sc, stock_descr=:sd,stock_comp=:sc,stock_supp=:ss,stock_quan=:sq,cost=:c,stock_status=:ss,date_supplied=:ds WHERE emp_id=:id");
$stmt->bindParam(":sn", $stock_name);
$stmt->bindParam(":sc", $stock_categ;
$stmt->bindParam(":sd", $stock_descr);
$stmt->bindParam(":sc", $stock_comp);
$stmt->bindParam(":ss", $stock_supp);
$stmt->bindParam(":sq", $stock_quan);
$stmt->bindParam(":c", $cost);
$stmt->bindParam(":ss", $stock_status;
$stmt->bindParam(":ds", $date_supplied);
$stmt->bindParam(":id", $id);

if($stmt->execute())
{
echo "Successfully updated";
}
else{
echo "Query Problem";
}
}

?>
Your reply will be highly valued and appreciated. Thanks in advance.
ReplyDelete
Replies
Unknown1/05/2016 11:39 AM
Hi, I'm a totally beginner to php and really thank you for these wonderful tutorials, i learn a lot from here! I've tried combining this tutorial along with registration and login tutorial you posted previously and i'm able to develop a system with registration, login and updating profile. It's working perfectly in terms of functionality, however, it can be easily be hacked. For example, the data of user A can be changed by userB, is there anyway i can strengthen the security?
ReplyDelete
Unknown1/05/2016 11:40 AM
Hi, I'm a totally beginner to php and really thank you for these wonderful tutorials, i learn a lot from here! I've tried combining this tutorial along with registration and login tutorial you posted previously and i'm able to develop a system with registration, login and updating profile. It's working perfectly in terms of functionality, however, it can be easily be hacked. For example, the data of user A can be changed by userB, is there anyway i can strengthen the security?
ReplyDelete
Michael1/05/2016 11:43 AM
Hi, first of all, really thank you for all these wonderful tutorials. I'm a total beginner in php and i learn a lot from here! I've tried modify and combine this tutorial with registration and login tutorials you shared previously and it works! However, while it works perfectly in terms of functionality, it seems kinda vulnerable to hack, for example, data of userA can be easily altered by userB, is there any way to strengthen the security?
ReplyDelete
MNCE921/05/2016 2:02 PM
Good day, may i know what is the function of this following line?

$(".content-loader").load('edit_form.php?edit_id='+edit_id);

especially the content in .load(), dont quite understand there. Would really appreciate if you can clarify to me :)
ReplyDelete
Oh Ji Ho1/06/2016 9:27 AM
Great Tutorial! but i notice there's only client side validation, none on the server side, or did I mislooked something?
ReplyDelete
lily kb1/10/2016 9:16 AM
Delete code is not working :(
ReplyDelete
Weston Thomas1/12/2016 7:25 AM
I want something like this, I am just learning php, want to create admin panel that can insert,update, delete employee profile. Where every employer has a unique user name and password that opens up their profile containing their name, passport, position, address, country etc. I have been studying to see how i can create it then I saw your miracle website. Can you show me how to go from here? thanks
ReplyDelete
Jose Luis Clavijo1/21/2016 4:03 AM
Thanks for this excellent tutorial; Just a question, how or where do you put the searh box on the code, sorry for my ignorant.
ReplyDelete
yudaBego2/07/2016 12:31 PM
Hello pradeep, im a "mongkey" in scripting, any way, how can i use this combine with logon script which i got from here, thanks in advance
ReplyDelete
Replies
Ed Lentz2/22/2016 2:20 AM
Thanks for a great tutorial. I have just one issue left before I go live with it. I have a problem with the update function. When I get to the edit page I have the correct record. I can change the entries but when I click the Save Updates button nothing happens, no success of failure. I do not know what I have done wrong. Can you look at my update.php and tell me what is wrong?
if($_POST)
{
$id = $_POST['id'];
$dealer_name = $_POST['dealer_name'];
$pi_name = $_POST['pi_name'];
$pi_id = $_POST['pi_id'];
$pi_key = $_POST['pi_key'];
$sip_server = $_POST['sip_server'];
$sip_user = $_POST['sip_user'];
$sip_pass = $_POST['sip_pass'];
$digits = $_POST['digits'];
$schedule = $_POST['schedule'];
$next = $_POST['next'];
$interval = $_POST['interval'];

$stmt = $db_con->prepare("UPDATE pi_config SET dealer_name=:en, pi_name=:ed, pi_id=:es , pi_key=:pk, sip_server=:ss, sip_user=:su, sip_pass=:sp, digits=:di, schedule=:sc, next=:ne, interval=:in WHERE id=:id");
$stmt->bindParam(":en", $dealer_name);
$stmt->bindParam(":ed", $pi_name);
$stmt->bindParam(":es", $pi_id);
$stmt->bindParam(":pk", $pi_key);
$stmt->bindParam(":ss", $sip_server);
$stmt->bindParam(":su", $sip_user);
$stmt->bindParam(":sp", $sip_pass);
$stmt->bindParam(":di", $digits);
$stmt->bindParam(":sc", $schedule);
$stmt->bindParam(":ne", $next);
$stmt->bindParam(":in", $interval);
$stmt->bindParam(":id", $id);

if($stmt->execute())
{
echo "Successfully updated";
}
else{
echo "Query Problem";
}
}

Thank you so much!!

ReplyDelete
Jon Van Deurzen2/26/2016 1:50 AM
Any reason why this wouldn't work in Chrome? I can't click on the Edit or Delete.
ReplyDelete
Replies
Vinicyus Anchieta4/12/2016 6:43 PM
Hi, I want to know if something like this can work with Phonegap.
My idea is to put the PHP at a web server and work with JS at the client side.
Sorry about my bad english.
ReplyDelete
Muh Yusuf Natsir4/18/2016 8:30 PM
Hello bro,
could you make tutorial how to display data from more table and edit them in one page??
thanks..
ReplyDelete
consolidacionacademicaeinternacionalizacion4/20/2016 12:56 AM
Muy buen post, solo falta agregar la opción o las configuraciones de internacionalización bajo el siguiente codigo:

language: {
processing: "Procesando...",
search: "Buscar :",
lengthMenu: "Paginación _MENU_ elementos",
info: "Página _START_ de _END_ de _TOTAL_ elementos",
infoEmpty: "0 Registros",
infoFiltered: "(filtré de _MAX_ éléments au total)",
infoPostFix: "",
loadingRecords: "Cargando...",
zeroRecords: "No se encontraron registros",
//emptyTable: "No se Enc",
paginate: {
first: "Primero",
previous: "Anterior",
next: "Siguiente",
last: "Último"
},
aria: {
sortAscending: ": activer pour trier la colonne par ordre croissant",
sortDescending: ": activer pour trier la colonne par ordre décroissant"
}
}
ReplyDelete
thekhairiahmad4/21/2016 3:15 PM
Thanks for this wonderful tutorial,how can i prevent duplicate entry and show message "This data already exist".
ReplyDelete
Replies
Dedy Dantry4/23/2016 6:12 PM
thanks for your tutorial....
ReplyDelete
Replies
Rathina Kumar4/30/2016 12:08 PM
in localhost working fine. Some problem in live that is unable to add,delete,update in live
ReplyDelete
Dong Nam A5/07/2016 9:01 AM
If client uses link directly: mydomain.com/delete.php?del_id=123. What will happen?
ReplyDelete
Unknown5/09/2016 2:07 AM
How to upload image with this code? Can you help me?
ReplyDelete
Timb$ony!!!5/23/2016 2:05 PM
How are you Sir thanx for good tutorial. I have created a view more link but its not working.I don't know how to go about it. Thank you sir
ReplyDelete
WMaple YMaple5/24/2016 8:28 PM
Thanks.
I have a question to ask you.
MySQL >> Set Collation : utf8_unicode_ci (before latin1_swedish_ci)
dbconfig.php >> Add mysql_query("SET NAMES UTF8");
Add Data >> language Thailand but Database Incorrect language (à¸ªà¸§à ...)
Thankyou .help me
ReplyDelete
gezachew wondesen6/17/2016 6:41 PM
hi i am realy wanna thank you so much for this tutorial but i need to insert option value which will be echoed by selecting table how can i perform this in my form please help me
ReplyDelete
Arslanali -6/27/2016 4:22 PM
Hi. Thank you for your example.
My sql:
$stmt = $db_con->prepare("SELECT _id,
date_publication,
chanel_title,
title,
link,
img,
status
FROM RSS_DATA
ORDER BY date_publication DESC;");

but the data in the table are not sorted by date.
ReplyDelete
Replies
Ken6/28/2016 12:57 PM
how to add more Image column with upload image function, pls help me
ReplyDelete
manoj7/15/2016 5:07 PM
Hi Pradeep,
Please tell me how to add datepicker by bootstrap in above form, I will helpful for us to select date by datepicker.

Thanks in advance,
ReplyDelete
Zaira8/02/2016 5:02 PM
Hi..i got some issue pertaining this code. I already email to you..kindly assist. Anyway good titorial. Tq..
ReplyDelete
Nightmare00888/08/2016 1:30 PM
sir, how to search id ?
ReplyDelete
Ugochukwu Kelech8/09/2016 3:20 PM
Sir thanks for the code it is a good one.
But i need your help to make it display users registration details with users image upload. it will also display like this one in table format with the users image or passport, edit page and update too.

Thanks
ReplyDelete
shashank vadyala8/12/2016 10:40 AM
hi
i tam try to run but there is a error in index 71 line
Parse error: parse error, expecting `'('' in /
ReplyDelete
Elías8/29/2016 5:58 AM
thank you very much for your tutorial'm very happy, greetings from Equador
ReplyDelete
aslam8/29/2016 6:52 PM
Thanks for tutorial. for me update not working.

prepare("UPDATE tbl_employees SET emp_name=:en, emp_company=:ec, emp_email=:em, emp_phone=:ep WHERE emp_id=:id");

$stmt->bindParam(":en", $emp_name);
$stmt->bindParam(":ec", $emp_company);
$stmt->bindParam(":em", $emp_email);
$stmt->bindParam(":ep", $emp_phone);
$stmt->bindParam(":id", $id);

if($stmt->execute())
{
echo "Successfully updated";
}
else{
echo "Query Problem";
}
}

?>

any error in this page? could you help me?
ReplyDelete
EZiNDAGI INFOSOFT9/16/2016 8:31 PM
Great Best Tutorial and Great Work i have visit lots of websites but this one works for me
ReplyDelete
Ed Lentz9/18/2016 7:07 PM
Is there a limit on the number of fields that we can add? I have an need for a form that will need about 60 - 70 fields. Will this script handle that many? Thanks
ReplyDelete
Unknown10/16/2016 1:50 AM
Many thanks for this useful script. It helps me solve very complicated part in my web site.
ReplyDelete
prize prite11/15/2016 3:04 PM
Hello , I want to send id to Add_form.Php, please help me
ReplyDelete
prize prite11/15/2016 3:05 PM
Hello, I want to send id to Add_form.php, Pls help me
ReplyDelete
Deepak Chaurasia2/02/2017 1:38 AM
hii coder.. can we also have its JSP version. thanks
ReplyDelete
Emprogest3/18/2017 6:53 AM
No me funciona el update.php

prepare("UPDATE rastros
SET rastro_ct=:rct ,
rastro_funciona=:rf,
rastro_tipo=:rt,
rastro_marca=:rm,
rastro_feccol=:rfc,
rastro_fecrep=:rfr
WHERE rastro_id=:id");

$stmt->bindParam(":rct",$rastro_ct);
$stmt->bindParam(":rf",$rastro_funciona);
$stmt->bindParam(":rt",$rastro_tipo);
$stmt->bindParam(":rm",$rastro_marca);
$stmt->bindParam(":rfc",$rastro_feccol);
$stmt->bindParam(":rfr",$rastro_fecrep);
$stmt->bindParam(":id",$id);

if($stmt->execute())
{
echo "Actualizado exitosamente";
}
else
{
echo "Los Datos NO HAN SIDO ACTUALIZADO";
}
}

?>
ReplyDelete
Emprogest3/24/2017 12:27 AM
The update does not work ... could tell me where the error is
ReplyDelete
Emprogest3/24/2017 12:27 AM

The update does not work ... could tell me where the error is
ReplyDelete