Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • update data using get method

    • 0
    • 0
    • 0
    • 1
    • 0
    • 0
    • 0
    • 108
    Answer it

    update and delete using get method
    i have this code to update data from my database
    i have no error reporting but he's not updating  any data
    can you help me with that  


    my database and my code

    -- ----------------------------------------------------------
    --

    Table structure for table `examinee`
    --
    
    CREATE TABLE `examinee` (
      `examinee_id` int(10) UNSIGNED NOT NULL,
      `user_name` varchar(30) NOT NULL,
      `password` varchar(40) NOT NULL,
      `date_of_registration` datetime NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    --
    -- Dumping data for table `examinee`
    --
    
    INSERT INTO `examinee` (`examinee_id`, `user_name`, `password`, `date_of_registration`) VALUES
    (1, 'khalidswaisi', 'swaisi2016', '2016-03-23 00:00:00'),
    (2, 'user', 'user', '2016-04-10 16:38:00'),
    (3, 'mohammed', 'nasyia', '0000-00-00 00:00:00');
    
    -- --------------------------------------------------------
    
    
    display page
    
    <?php include ("connection.php"); ?>
    
          <center><h2>Examinee List</h2></center>
    <table border="1" cellpadding = "0" cellspacing = "0" width = "700" align = "center">
    <thead>
    <th> </th>
    <th> </th>
    <th> </th>
    <th> </th>
    </thead>
    <?php
       $sql = mysqli_query ($link,"SELECT * FROM `examinee`") or die ();
        while ( $row = mysqli_fetch_assoc($sql)) {
            echo "<tr>
                 <td>".$row['examinee_id']."</td>
                 <td>".$row['user_name']."</td>
                <td>".$row['password']."</td>
                 <td>".$row['date_of_registration']."</td>
                 <td align = 'center'>
                 <a href = 'examinee_Edit.php?examinee_id=$row[examinee_id]'>Update</a>
                 <a href = 'examinee_Delete.php?examinee_id=$row[examinee_id]'> Delete</a>
                 </td>
            </tr>";
        
        }
    
    ?>
    </table>
    
    </body>
    
    
    </html>
    
    </body>
    </html>

     

    update page

    <?php include ("connection.php"); ?>
    <?php
       $msg = "";
       if (isset($_POST['update'])) {
           if(is_numeric($_POST['examinee_id'])){
               
              $examinee_id = mysqli_real_escape_string($link,htmlspecialchars($_POST['examinee_id']));
              $user_name = $_POST['user_name'];
              $password = $_POST['password'];
              $date_of_registration = $_POST['date_of_registration'];
             
     
               $sql = mysqli_query ($link,"UPDATE `examinee` SET
                `user_name`=[$user_name],
                `password`=[$password],
                `date_of_registration`=[$date_of_registration]
                 WHERE `examinee_id` =   $examinee_id ")
               ;             
          
                 header ("location : index.php");
            }
        
        }
        else
        {    
            if(isset($_GET['examinee_id']) && is_numeric($_GET['examinee_id']) && $_GET['examinee_id'] > 0 ){
                    
                    $examinee_id=$_GET['examinee_id'] ;
    
                 $sql = mysqli_query ($link,"SELECT * FROM `examinee` WHERE  `examinee_id`=$examinee_id ") ;
                  while( $row = mysqli_fetch_assoc ($sql) ){
                  $examinee_id = $row ['examinee_id'];
                  $user_name = $row['user_name'];
                  $password = $row['password'];
                  $date_of_registration = $row['date_of_registration'];
              
                }
            }    
    
        }
    ?>
    <html dir="rtl">
    <head>
    <title>  </title>
    <meta http-equiv ="content-type" content="text/html"; charset = utf8" />
    <meta http-equiv="refresh" content="30">
        <center><h3>Update</h3></center>
        <center><h3><a href="examinee_Search.php">   </a></h3></center>
    
    </head>
    
    <body>
    
                  <form method= "POST" action = "" >
         
                    <table  width = "400" align = "center" >
                     
                      <tr>
                              <td> </td>
                            <td><input type="text" name = "examinee_id" value="<?php echo $examinee_id ;?>" /></td>
                            
                      </tr>
                       <tr>
                             <td> </td>
                            <td><input type="text" name = "user_name" value="<?php echo $user_name ;?>" /></td>
                      </tr>
                       <tr>
                            <td> </td>
                            <td><input type="text" name = "password" value="<?php echo $password ;?>" /></td>
                      </tr>
                       <tr>
                            <td> </td>
                            <td><input type="text" name = "date_of_registration" value="<?php echo $date_of_registration ;?>" /></td>
                      </tr>
                       <tr>
                            
                            <td><input type="submit" name = "update" value=" "  /></td>
                      </tr>
                       <tr>
                            
                            <td><input type="hidden" name = "examinee_id" value="<?php echo $_GET['examinee_id']; ?>" /></td>
                      </tr>
    
                    </table>
    
                  </form>
    </body>
    </html>

     

 1 Answer(s)

  • please try this code

    $sql = mysqli_query ($link,"UPDATE examinee SET user_name='".$user_name."', password='".$password."', date_of_registration='".$date_of_registration."' WHERE examinee_id = $examinee_id ");

    Explanation:you are using varchar datatype for stroing username, password, and date of registration in database. so the value should be in string format like 'username'.

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: