• PHP Training
    •  
  • Login/Register

    • Home >>MySQL Tutorial >Select Insert Update Delete in Php

    Select Insert Update Delete in Php

    « Previous Next »

    CRUD On Same Page PHP MySQL

    We basically want crud operation(create,read,update,delete) on the same page .ieto create a table we use create query , as we enter the data in the table, that data will be displayed in tabular form on the same pageShowing the available options such as edit ,delete in front of them.If we click on the delete button, the entries can be deleted To change any field we click on the edit button

    Crate database, select database, Create Table

    <?php

//connectivity code$con=mysql_connect("localhost","root","") or die(mysql_error());

//create database
mysql_query("create database test");
//select database
mysql_select_db("test");
//create table stuinfo
$que="CREATE TABLE stuinfo 
(
stu_id INT AUTO_INCREMENT PRIMARY KEY ,

email VARCHAR( 50 ) NOT NULL ,

password VARCHAR( 50 ) NOT NULL ,

mobile BIGINT NOT NULL ,

address TEXT NOT NULL ,

gender ENUM( 'm', 'f' ) NOT NULL ,

hobbies VARCHAR( 100 ) NOT NULL ,

image VARCHAR( 200 ) NOT NULL ,

dob DATE NOT NULL ,

INDEX ( `gender` , `dob` ) ,

UNIQUE (`email` ,`mobile`)

);

//Execute query using query analyzer function
mysql_query($que);

?>

    PHP Script Retrieve values From HTML Form

    <?php
// error_reporting(1) function hides all errors Mostly Notice Error

error_reporting(1);

//retrieve email id entered by user and store in $eid. and so on for other values

$eid=$_POST['eid'];
$p=$_POST['pass'];
$m=$_POST['mob'];
$add=$_POST['add'];
$gen=$_POST['g'];
$hobb=$_POST['chlist'];
$h=implode(",",$hobb);
$img=$_FILES["file"]["name"];
$yy=$_POST['yy'];
$mm=$_POST['mm'];
$dd=$_POST['dd'];
$dob=$yy."-".$mm."-".$dd;

//checked whether user clicked on INSERT button

if(isset($_POST['ins']))
{
$sql="INSERT INTO stuinfo values('','$eid','$p','$m','$add','$gen','$h','$img','$dob')";

mysql_query($sql);
move_uploaded_file($_FILES["file"]["tmp_name"], "userDetails/" . $_FILES["file"]["name"]);
echo "data saved";
}

//checked whether user clicked on display button

if(isset($_POST['disp']))
{
$res=mysql_query("SELECT * FROM stuinfo");
echo "<table border='1'>";
echo "<tr><th>SutId</th><th>Email</th><th>Password</th><th>Mobile</th><th>Address</th><th>Gender</th>    </tr>"; 

while(list($a,$b,$c,$d,$e,$f)=mysql_fetch_array($res))
{

echo "<tr>";    echo "<td>".$a."</td>";

echo "<td>".$b."</td>";

echo "<td>".$c."</td>";

echo "<td>".$d."</td>";

echo "<td>".$e."</td>";

echo "<td>".$f."</td>";

echo "<td><a href='db.php?chk=$b'>Edit</a>    <a href='db.php?chkid=$a'>Delete</a></td>";

echo "</tr>";    

}

echo "</table>";
}

// receive  value(value sent  using query string )

@$v=$_GET['chkid'];
@$email=$_GET['chk'];
if(isset($v))
{
mysql_query("delete from stuinfo where stu_id='$v'");
echo "records deleted";
}

if(isset($_POST['upd']))
{
$p=$_POST['p'];
$m=$_POST['mob'];
$add=$_POST['add'];
echo $email;

$upd="update stuinfo set pass='$p',mobile='$m',address='$add' where email='$email'";

mysql_query($upd);

echo "updated";

}

if(isset($_GET['chk']))
{
$sql="SELECT * FROM stuinfo where email='$email'";

$res=mysql_query($sql);

list($a,$b,$c,$d,$e,$f)=mysql_fetch_array($res);

echo "<table border='1'>";

echo "<form method='post'>";

echo "<tr>";

echo "<td>Password</td>";

echo "<td><input type='password' name='p' value='$c' /></td></tr>";

echo "<tr>";

echo "<td>Mobile</td>";

echo "<td><input type='text' name='mob' value='$d' /></td></tr>";

echo "<tr>";

echo "<td>Address</td>";

echo "<td><textarea name='add'>$e</textarea></td></tr>";

echo "<tr>";

echo "<td colspan='2' align='center'><input type='submit' value='Update infor' name='upd' /></td></tr>";

echo "</form>";

echo "</table>";
}

?>

    HTML Form

    <body>

<form  method="post" enctype="multipart/form-data">

<table width="419" border="1"> 
 <tr>    
<td width="173">Enter your email </td>
  <td width="230"><input type="email"  name="eid"/>

</td>  </tr>  <tr> 

   <td>Password</td>  

<td><input type="password"  name="pass"/></td> 

</tr>  <tr>    <td>Mobile</td> 

   <td><input type="text"  name="mob"/></td>

  </tr> 

 <tr>   
 <td>Address</td> 
  
 <td><textarea name="add"></textarea></td> 

 </tr> 
 <tr>  
  <td>Gender</td> 
   <td>
    
Male<input type="radio" value="m" name="g"/>
Female<input type="radio" value="f" name="g"/>
	
</td>
 
 </tr>
 
 <tr>
 
   <td>Hobbies</td>
    <td>	cricket<input type="checkbox" name="chlist[]" value="cricket"/>
singing<input type="checkbox" name="chlist[]" value="singing"/>

reading<input type="checkbox" name="chlist[]" value="reading"/>
	
</td>

  </tr>

  <tr>

    <td>Image</td> 

   <td><input type="file" name="file" id="file" />

 </td>
  </tr>

  <tr> 

   <td>DOB</td> 

   <td>
	<select name="yy">
	<option value="" disabled="disabled" selected="selected">	Year</option>
	<?php
	for($i=1900;$i<=2013;$i++)
	{
	echo "<option value='$i'>$i</option>";
 	}
	?>
			
</select><select name="mm">

<option value="" disabled="disabled" selected="selected">	Month	</option>

	<?php	
	for($i=1;$i<=12;$i++)
		{
		echo "<option value='$i'>$i</option>";
 		}
		?>

	</select>

	<select name="dd">		

<option value="" disabled="disabled" selected="selected">	Date</option>

		<?php
		for($i=1;$i<=31;$i++)
		{
		echo "<option value='$i'>$i</option>";
 		}
		?>
		
</select>	</td>

  </tr>

  	<tr> 
 		<td colspan="2" align="center">	<input type="submit" name="ins" value="Insert"/>			

<input type="submit" name="disp" value="show"/>	

</tr>

</table>

</form>

</body>

</html>

    In the given example:User enters the value inside the field, and click on Insert button.data is stored inside the database table.Second button is to display the value when user click on show button all information will display and with all rows a delete and edit link also displayed. whenever user want to update he has to click on edit link or can click on delete link to delete the information.

    Total Downloads : 782

    Login / Register To Download
    « Previous Next »

    MySQL Tutorial SQL Introduction MySQL Constraints MySQL Common Queries PHP MySQL Connectivity PHP Mysqli Database Connectivity PHP MySQL Create Database PHP Create MySQLi Database PHP MySQL Insert PHP MySQL Update PHP MySQL Delete PHP MySQL Select Mysqli Fetch Array Mysqli Fetch Assoc Mysqli fetch row Mysqli fetch object MySQL Where Clause MySQL Order By Select Insert Update Delete in Php How to create foreign key MySQL auto increment PHP MySQL Secure Registration Page PHP MySQL Secure Login Page MySQL Predefined Function MySQL Joins How to Export MySQL to CSV How to import csv into mysql How to edit radio button in PHP MySQL PHP MySQL Pagination Upload and Display Video in PHP Building a bar chart How to update Radio button, Checkbox and dropdown Create Registration form PHP MySQL How to insert data from textarea to database PHP PHP PDO
    No Sidebar ads