How to Delete/Remove Data & Image from MySql Database using Php

<!doctype html>
 <?php     
   /*-----------------------------------CONNECTIVITY CODE---------------------------------*/
     error_reporting(E_ERROR | E_PARSE);      //optional,to remove warning messages.

     $conn=mysqli_connect("localhost","root","","codershelpline");
        if ($conn)
          {
           echo "database connected successfully","<br>";
          }
        else
          {
           die("Connection Aborted:" . mysqli_connect_error());
          }
    
     mysqli_close($conn);      //optional,to close the connection properly.
   
     $TxtEmail1=$_REQUEST['TxtEmail'];	
	
    /*-------------------------------------DELETE CODE------------------------------------*/
    if(isset($_REQUEST['BtnDelete']))
    {  
      $qry="select TxtEmail4 from chlsave where TxtEmail4 ='$TxtEmail1'";
      $result=mysqli_query($conn,$qry);			
      $x=0;
      while($row1=mysqli_fetch_array($result))
      {    
	$em=$row1['TxtEmail4 '];				
	if($em)
	 {
	   $value="delete from chlsave where TxtEmail4='$TxtEmail1'";
	   if($conn->query($value)===TRUE) 
            {
              echo "Record Removed ";
            }					
	   $x=$x+1;
	 }
      }			
      if($x===0)
	{
	   echo "Record Not Found & hence not Removed" . $conn->error;
	}
    }
?>    
  <!--------------------------------HTML DESIGN CODE------------------------------------->    
<html>
   <head>
      <title>Codershelpline Code for display html value</title>
   </head>
   <body>
      <form name="form1" id="form2" action="#" method="post" >
	 <center>
	    <fieldset style="width: 600px">				
		<legend>Create New Student Account</legend>
		   <table>
		      <tr>
			  <td>Serial No.</td>
			  <td>:</td>
			  <td><input type="text" name="TxtSlno"></td>
		      </tr>
		      <tr>
			  <td>Student Name</td>
			  <td>:</td>
			  <td><input type="text" name="TxtSname"></td>
		      </tr>
		      <tr>
			  <td>Address</td>
			  <td>:</td>
			  <td>
			     <textarea cols="35" rows="5" name="TxaAddr"></textarea>							
			  </td>
		       </tr>
		       <tr>
			  <td>Sex</td>
			  <td>:</td>
		          <td>
			<input type="radio" name="Rdbsex" id="RdbMale" value="Male">Male
			<input type="radio" name="Rdbsex" id="RdbFemale" value="Female">Female
			<input type="radio" name="Rdbsex" id="RdbOther" value="Other">Other
		          </td>
		       </tr>						
		       <tr>
			  <td>User Name</td>
			  <td>:</td>
			  <td><input type="text" name="TxtUname"></td>
		       </tr>
		       <tr>
			  <td>Password</td>
			  <td>:</td>
			  <td><input type="password" name="TxtPassword"></td>
		       </tr>
		       <tr>
			  <td>Confirm Password</td>
			  <td>:</td>
			  <td><input type="password" name="TxtCpassword"></td>
		       </tr>
		       <tr>
		          <td>DOB</td>
			  <td>:</td>
			  <td><input type="date" name="DtpDob"></td>
		       </tr>
		       <tr>
			  <td>Mobile No.</td>
			  <td>:</td>
			  <td><input type="Number" name="TxtMobno"></td>
		       </tr>
		       <tr>
			  <td>Email</td>
			  <td>:</td>
			  <td><input type="text" name="TxtEmail"></td>
		       </tr>					
		       <tr>
			  <td>Security Questions</td>
			  <td>:</td>
			  <td>
   <select name="CmbSecQues">
       <option value="Choose One">Choose One</option>
       <option value="What is Your Favourite Book">What is Your Favourite Book</option>
       <option value="What is Your Favourite Teacher">What is Your Favourite Teacher</option>
       <option value="What is Your Favourate Place">What is Your Favourate Place</option> 
       <option value="What is Your Favourate Pets">What is Your Favourate Pets</option>
   </select>
			  </td>
		     </tr>
		     <tr>
			<td>Security Answer</td>
			<td>:</td>
			<td><input type="text" name="TxtSecAns"></td>
		     </tr>
		     <tr>
			<td>Hobbies</td>
			<td>:</td>
			<td>
			   <input type="checkbox" name="ChkCricket" value="Cricket">Cricket
			   <input type="checkbox" name="ChkDance" value="Dance">Dance
			   <input type="checkbox" name="ChkMusic" value="Music">Music			   
			</td>
		     </tr>
		     <tr>
			<td>Remarks</td>
			<td>:</td>
			<td><input type="text" name="TxtRem" value="N/A"></td>
		     </tr>
		     <tr>
			<td></td>
			<td></td>
			<td>
                             <input type="submit" name="BtnSave" value="Save">
			     <input type="reset" name="BtnReset" value="Reset">
                             <input type="submit" name="BtnDelete" value="Delete">
			</td>
		     </tr>

		  </table>
	      </fieldset>
            </center>
	  </form>
        </body>
     </html>

NB: Run the program and enter the correct email (as primary key) value then press delete button to remove the data/record from the database.

 391 total views,  1 views today

Categories: Php

0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.