How To Update Data into Database

www.technaitra.com

1.Make a File config.php
<?php
error_reporting(0);
$con = mysql_connect("localhost","root","");
mysql_select_db("table");
?>

2.Create a file fetchdata.php

<?php
include("config.php");
$select = mysql_query("select * from student");
?>
<table border="2">
<tr>
<td>name</td>
<td>class</td>
<td>rollno</td>
<td colspan="2">Operation</td>
</tr>
<?php
while($row=mysql_fetch_array($select))
{
?>
<tr> <td> <?php echo $row['name']."<br>"; ?> </td>
<td> <?php echo $row['class']."<br>"; ?> </td>
<td> <?php echo $row['rollno']."<br>"; ?> </td>

<td> <a href="edit.php?id=<?php echo $row['id']?>&name=<?php echo $row['name']?>&class=<?php echo $row['class']?>&rollno=<?php echo $row['rollno']?>">Edit </a> </td>
</tr>
<?php
}
?>

3.Create a File edit.php

<?php
$id=$_REQUEST['id'];
$name=$_REQUEST['name'];
$class=$_REQUEST['class'];
$rollno=$_REQUEST['rollno'];
?>

<form action="update.php" method="get">
<table border="2">
<tr><td>name</td>
<td>class</td>
<td>rollno</td>

</tr>

<tr>
<input type="hidden" name="id" value="<?php echo $id; ?>" >
<td><input type="text" name="name" value="<?php echo $name; ?>" ></td>
<td><input type="text" name="class" value="<?php echo $class; ?>" ></td>
<td><input type="text" name="rollno" value="<?php echo $rollno; ?>" ></td>
</tr>

<tr>
<td colspan="3" align="center"><input type="submit" ></td>
</tr>

</table>
</form>

4. Create a File update.php
<?php
include("config.php");

$id=$_GET['id'];
$name=$_GET['name'];
$class=$_GET['class'];
$rollno=$_GET['rollno'];

if(!empty($name))
{
$update=mysql_query("update student set name='$name' where id='$id'");
}

if(!empty($class))
{
$update=mysql_query("update student set class='$class' where id='$id'");
}

if(!empty($rollno))
{
$update=mysql_query("update student set rollno='$rollno' where id='$id'");
}

header("location:fetchdata.php");

?>

5. Create Database in Server:

Database name: table
table name : student
column name:id,name,class,rollno