PHP Simple Update using PDO in Bootstrap Tutorial

Furqan Aziz | 08 Dec 2013 | Tutorials

PHP Simple Update using PDO in Bootstrap Tutorial
Update Statement is very common and used to update or edit existing records in database. PHP Simple Update using PDO in Bootstrap is a tutorial in which we will learn how to update data in database using PDO (PHP Data Objects) prepared statements while using Bootstrap CSS Framework. We will create table fist and then insert some records in it, then we will create a form for update. Then we will use Post method in form to send values to another page and then we will get values, bind them and use them in prepare statements. Finally we will show the success message if everything updated successfully. This tutorial contains demo and source in which you can test INSERT, DELETE and SELECT options at one place. We will learn

Source Code Folder contains many files and folders, below is the explanation of each files and folders.

  1. We will create sample table in our database using sql.txt file which contains following table create queries and sample data for demo and test.
    • fruitsratelist table contains fields like Fruitname and its Rate.
    • CREATE TABLE IF NOT EXISTS `fruitsratelist` (
        `Fruitname` varchar(15) NOT NULL,
        `Rate` double NOT NULL
      ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    • INSERT INTO `fruitsratelist` (`Fruitname`, `Rate`) VALUES
      ('Apple', 70),
      ('Apple', 90),
      ('Mango', 60),
      ('Banana', 70),
      ('Strawberry', 80),
      ('Apple', 40),
      ('Lemon', 70),
      ('Kiwi', 80);
  2. We will create a button for UPDATE inside option side nav in AdminIndex.php page with id updateit and set data-toggle as modal for showing reference DIV in a modal. We set button class as warning button.
    • <a href="#updateit" data-toggle="modal" class="btn btn-warning">Update</a>
      
  3. Modal will be open when Update Button pressed which will display below form for Update of Fruit rates. Form code is in footer.php page which is included in AdminIndex.php. This form contains fruit names in drop down select option for update. When we press Change Fruit Name Button it will send values as POST method to FruitUMy.php.
    • <div id="updateit" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
      	<div class="modal-header">
      <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
      <h3 id="myModalLabel">Update Fruit Name</h3>
      </div>
      <div class="modal-body">
      <form class="form-horizontal" method="post" action="FruitUMy.php">
      
      <div class="control-group">
      <label class="control-label" for="Fruitname1">Fruit Name</label>
      <div class="controls">
      <select name="Fruitname1" id="Fruitname1"  required="required">
      <option value="">Current Fruit Name</option>
      <?php
      include("configPDO.php");
      // We Will prepare SQL Query
          $STM = $dbh->prepare("SELECT DISTINCT  Fruitname FROM fruitsratelist");
      // bind parameters , Named parameters  always start with colon(:)
          $STM->execute();
      // we will fetch records like this and use foreach loop to show multiple Results
          $STMrecords = $STM->fetchAll();
          foreach($STMrecords as $row)
              {
      		   echo"<option value='$row[0]'>$row[0]</option>";	
      		}        
      		?> 
                  </select>           
      </div>
      </div>
      <div class="control-group">
      <label class="control-label" for="Fruitname2">Fruit Name</label>
      	<div class="controls">
                <select name="Fruitname2" id="Fruitname2"  required="required">
                    <option value="">New Fruit Name</option>
                    <option value="Banana">Banana</option>
                    <option value="Pear">Pear</option>
                    <option value="Orange">Orange</option>
                    <option value="Kiwi">Kiwi</option>
                    <option value="Mango">Mango</option>       
                    <option value="Lemon">Lemon</option>
                    <option value="Peach">Peach</option>
                    <option value="Cherry">Cherry</option>
                    <option value="Strawberry">Strawberry</option>
                    <option value="Apricot">Apricot</option>
                    <option value="Apple">Apple</option>
                </select>          
      	</div>
      </div>
      <div class="control-group">
      	<div class="controls">
                      <input type="submit" name="submit" id="submit" class="btn btn-warning" value="Change Fruit Name">
      	</div>
      </div>
      </form>
      
      	</div>
      </div> 
  4. configPDO.php file use a PDO (PHP Data Objects) for connecting MySQL Database.
    • <?php
      // mysql hostname
      $hostname = 'localhost';
      // mysql username
      $username = 'root';
      // mysql password
      $password = '';
      // Database Connection using PDO
      try {
      $dbh = new PDO("mysql:host=$hostname;dbname=YourDatabaseName", $username, $password);
          }
      catch(PDOException $e)
          {
          echo $e->getMessage();
          }
      ?>
  5. Now we will discuss our FruitUMy.php which is used for getting values from form and then Update these in database using PDO query.
    • <?php
      // We will include connection file first
      include('configPDO.php');
      // check if variable is set and Change Fruit Name Button pressed.
      if(isset($_POST["submit"])=="Change Fruit Name")
      {
      // Define Variables and getting values.
      $Fruitname1			= 	$_POST[Fruitname1];   		//Fruitname1
      $Fruitname2			= 	$_POST[Fruitname2];   		//Fruitname2
      
      // We Will prepare SQL Query
          $STM = $dbh->prepare("UPDATE fruitsratelist SET Fruitname=:Fruitname2 WHERE Fruitname=:Fruitname1");
      // bind parameters, Named parameters always start with colon(:)
          $STM->bindParam(':Fruitname1', $Fruitname1);
      	$STM->bindParam(':Fruitname2', $Fruitname2);
      // For Executing prepared statement we will use below function
          $STM->execute();
      // We use header here for redirecting it to other page where we will show success message.
      header( "location:AdminIndex.php?FruitstatsUpdated=77083368");       			   
      }
      ?>

    There are three various methods to write PDO queries.

    • In this Demo we used named parameters key with prepared statement. Binding parameter is must before execution using this method.
      • $STM = $dbh->prepare("UPDATE fruitsratelist SET Fruitname=:Fruitname2 WHERE Fruitname=:Fruitname1");
        $STM->bindParam(':Fruitname1', $Fruitname1);
        $STM->bindParam(':Fruitname2', $Fruitname2);
        $STM->execute();
        
      OR
    • Other method is to use unnamed parameters with question mark (?)
      • $STM = $dbh->prepare("UPDATE fruitsratelist SET Fruitname=? WHERE Fruitname=?");
        $STM->bindParam(1, $Fruitname1);
        $STM->bindParam(2, $Fruitname2);
        $STM->execute();
        
      OR
    • Below method is without binding and it can make code ripe for SQL Injections.
      • $STM = $dbh->prepare("UPDATE fruitsratelist SET Fruitname=$Fruitname1 WHERE Fruitname=$Fruitname2");
        $STM->execute();
        
    • For Getting how many records Updated we can use rowcount() function.
      • $Records_Updated= $STM->rowCount();
        
  6. After data Updated We will redirected to Adminindex.php page where we will show success message using codes return from FruitUMy.php
    • if($_GET["FruitstatsUpdated"]==77083368)  
      {
      echo "<div class='alert alert-success'>"; 
      echo "<button type='button' class='close' data-dismiss='alert'>×</button>"; 
      echo "<h4>Updated.</h4>"; 
      echo "Fruit Name updated in this Demo System."; 
      echo "</div>";
      }

    We used following tools and technologies for developing PHP Simple Update using PDO in Bootstrap Tutorial.

    • PHP as Server Side Scripting Language
    • MySQL as a Database.
    • Bootstrap as CSS Framework.
    • JQuery as a service.
    • jqBootstrapValidation for validating sign-in form.
    • phpMyAdmin for creating database and tables.
    • Sublime Text 2+ as a code editor.
    • XAMPP as a package for Apache web server, PHP and MySQL.
    • Google Chrome as a browser for testing.

    Thanks for reading. Enjoy and share with friends.

We hope you will like PHP Simple Update using PDO in Bootstrap Tutorial and find it easy. We used latest PDO (PHP Data Objects) Prepared statements in this tutorial with Bootstrap CSS Framework for making this quickly. For any query/suggestions please send message on our Facebook Page.

Social Box

LATEST TUTORIALS
PHP MySQL Simple Delete using PDO in Bootstrap Tutorial
Convert Simple Text To 3D Text using Adobe Fireworks CS6 Tutorial
PHP Simple Update using PDO in Bootstrap Tutorial
PHP Simple Insert using PDO in Bootstrap Tutorial
PHP MySQL Easy CSV Data Insertion in Bootstrap using PDO Tutorial
PHP Easy Sign-in Using PDO Prepared Statement Tutorial
Easy PHP Email With Attachments using Swift Mailer Tutorial
Easy Pagination with PDO in PHP plus Export to Excel Tutorial
PHP PDO to Connect MySQL Database Tutorial
Best CSS Frameworks Collection For Rapid Web Development
PHP-MySQL Ajax Jquery-UI Autocomplete in Bootstrap Tutorial
PHP Simple Sign-in Tutorials
Jquery Raty Usage via PHP
PHP Dynamic Select options Via Ajax
CSV Importer in MySQL
PHP File Load Via Jquery into DIV
PHP Simple Delete using PDO in Bootstrap Tutorial Convert Simple Text To 3D Text using Adobe Fireworks CS6 Tutorial PHP Simple Update using PDO in Bootstrap Tutorial PHP Simple Insert using PDO in Bootstrap Tutorial PHP MySQL Easy CSV Data Insertion in Bootstrap using PDO Tutorial PHP Easy Sign-in Using PDO Prepared Statement Tutorial Easy PHP Email With Attachments using Swift Mailer Tutorial Easy Pagination with PDO in PHP plus Export to Excel Tutorial PHP PDO to Connect MySQL Database Tutorial Best CSS Frameworks Collection For Rapid Web Development PHP-MySQL Ajax Jquery-UI Autocomplete in Bootstrap Tutorial PHP Simple Sign-in Tutorials Jquery Raty Usage via PHP PHP Dynamic Select options Via Ajax CSV Importer in MySQL PHP File Load Via Jquery into DIV Query plus Grant Privileges Tutorial PHP Easy Installation Tutorial PHP Simple Mail Form Tutorial 15 Best Fireworks Tutorials CSS Layout Basic Tutorial PHP Ajax Live Search Tutorial
© 2014 CreWow Network - All Rights Reserved.