Form.php
<html>
<body>
<h1> Registration Form : </h1>
<form name="form1" action="register.php" method="post" />
Name :
<input type="text" name="name" value=""/>
Address :
<input type="text" name="address" value=""/>
<input type="submit" name="submit" value="Register"/>
</form>
</body>
</html>
<html>
<body>
<h1> Registration Form : </h1>
<form name="form1" action="register.php" method="post" />
Name :
<input type="text" name="name" value=""/>
Address :
<input type="text" name="address" value=""/>
<input type="submit" name="submit" value="Register"/>
</form>
</body>
</html>
register.php
<?php
include("cls.php");
$obj= new connect();
$obj->abcconnect();
$varname=$_POST['name'];
$varaddress=$_POST['address'];
$sqlinsert= "insert into reg(name,address)values('$varname','$varaddress')";
if(!mysql_query($sqlinsert))
{
echo "errro in querry".mysql_error();
}
else
{
echo"registration complete";
}
?>
cls.php
<?php
class connect
{
function abcconnect()
{
$con = mysql_connect('localhost','root','');
if(!$con)
{
die("Error in database connection");
}
$sdb=mysql_select_db('db',$con);
if(!$sdb)
{
die("Erroe in database selection");
}
}
}
?>
updateform.php
<?php
include("cls.php");
$obj = new connect();
$obj->abcconnect();
$varid = $_GET["id"];
$sqlselect=mysql_query("select * from reg where id = $varid");
while($row=mysql_fetch_array($sqlselect))
{
$varid=$row["id"];
$varname=$row["name"];
$varaddress=$row["address"];
}
?>
<html>
<body>
<h1> Registration Form : </h1>
<form name="form1" action="update.php?id=<?php echo $varid; ?>" method="post" />
Name :
<input type="text" name="name" value="<?php echo $varname; ?>"/>
Address :
<input type="text" name="address" value="<?php echo $varaddress; ?>"/>
<input type="submit" name="submit" value="Update"/>
</form>
</body>
</html>
update.php
<?php
include("cls.php");
$obj = new connect();
$obj->abcconnect();
$varid = $_GET["id"];
$varname=$_POST['name'];
$varaddress=$_POST['address'];
//echo $varid;
//$sql = "delete from reg where id =$varid";
$sql = "update reg set name='$varname',address='$varaddress' where id = $varid";
if(!mysql_query($sql))
{
echo "Query does not execute";
}
else
{
echo "Record have been updated";
}
?>
delete.php
<?php
include("cls.php");
$obj = new connect();
$obj->abcconnect();
$varid = $_GET["id"];
echo $varid;
$sql = "delete from reg where id =$varid";
if(!mysql_query($sql))
{
echo "Query does not execute";
}
else
{
echo "Record have been deleted";
}
?>
regdesplay1.php
<?php
include("cls.php");
$obj=new connect();
$obj->abcconnect();
$sqlselect=mysql_query("select * from reg");
?>
<table>
<tr>
<td>Id</td>
<td>Name</td>
<td>Address</td>
<td>Delete</td>
<td>Update</td>
</tr>
<?php
while($row=mysql_fetch_array($sqlselect))
{
$varid=$row["id"];
$varname=$row["name"];
$varaddress=$row["address"];
?>
<tr>
<td><?php echo "$varid"; ?></td>
<td><?php echo "$varname"; ?></td>
<td><?php echo "$varaddress";?></td>
<td><a href="delete.php?id=<?php echo "$varid"; ?>">Delete</a></td>
<td><a href="updateform.php?id=<?php echo "$varid"; ?>">Update</a></td>
</tr>
<?php
}
?>
</table>
This comment has been removed by the author.
ReplyDelete