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. 
0 Comments