Index.php :
<html>
<body>
<center>
<form name="myform" action="" method="get">
Name : <input type="text" name="name" /><br />
Mobile : <input type="text" name="mbi" /><br />
Qulification (Mulitiple Selection) <select name="quli[]" multiple="multiple"> <br />
<option>select</option>
<option>Mca</option>
<option>Bsc</option>
<option>Bcom</option>
<option>M</option>
</select><br />
Gender <input type="radio" name="gr" value="male"/> Male <input type="radio" name="gr" value="female"/> Female<br />
<input type="submit" name="submit" value="Insert" />
</form>
</center>
</body>
</html>
<?php if(isset($_REQUEST['submit'])) {?>
<?php include_once('values_store.php');?>
<?php }?>
Insert:
values_store.php
<?php
$con = mysql_connect("localhost","root","admin123");
if(!$con)
{
die("Error");
}
mysql_select_db("test");
$name = $_REQUEST['name'];
$mob = $_REQUEST['mbi'];
$quli = $_REQUEST['quli'];
$gende =$_REQUEST['gr'];
//echo count($quli);
if(is_array($_REQUEST['quli']))
{
$a = serialize($_REQUEST['quli']);
$sql = "insert into addressbook values('','$name','$mob','$a','$gende')";
}
$result = mysql_query($sql);
if($result)
{
//echo "ok ";
}else {die("Error".mysql_error());}
include_once('resultsvalues.php');
Result:
resultsvalues.php’
<?php
$con = mysql_connect("localhost","root","admin123");
if(!$con)
{
die("error");
}
mysql_select_db("test");
echo "<center>";
echo "<table border='1'>";
$sql = "select * from addressbook";
$results = mysql_query($sql);
while($row = mysql_fetch_array($results))
{
echo "<tr><td>";$id = $row['id']; echo $id; echo "</td>";
echo "<td>";echo $row['name'];echo "</td>";
echo "<td>";echo $row['mobilenum'];echo "</td>";
echo "<td>";$qulif = $row['qulifications'];
$myquls = unserialize($qulif);
for($i=0; $i < count($myquls); $i++){
echo $myquls[$i].',';
}
echo "</td>";
echo "<td>";echo $row['gender'];echo "</td>";
echo "<td>"; echo "<a href='Update_front.php?id=$id'>";echo "Edit";echo "</td>";
echo "<td>"; echo "<a href='Delete.php?did=$id'>";echo "Delete";echo "</td></tr>";
}
echo "</table>";
echo "</center>";
Update(Edit) :
Update_front.php
<?php
$con = mysql_connect("localhost","root","admin123");
if(!$con)
{
die("error");
}
mysql_select_db("test");
$id = $_REQUEST['id'];
$sql = "select * from addressbook where id='$id'";
$res = mysql_query($sql);
echo "<form name='upd' action='update.php' method='get'>";
while($row = mysql_fetch_array($res))
{
?>
<center>
Name : <input type="text" name="name" value="<?php echo $row['name'];?>" /><br />
mobile : <input type="text" name="mbi" value="<?php echo $row['mobilenum'];?>"/><br />
Qulification <select name="quli[]" multiple="multiple"> <br />
<option>select</option>
<?php
$qulif = $row['qulifications'];
$myquls = unserialize($qulif);
for($i=0; $i < count($myquls); $i++){
echo $myquls[$i].',';
?>
<?php if($myquls[$i] == "Mca") {?><option selected>Mca</option> <?php }?>
<?php if($myquls[$i] == "Bsc") {?><option selected>Bsc</option> <?php }?>
<option>Bcom</option>
<option>M</option>
<?php }?>
</select><br />
Gender <?php if($row['gender']=='male'){?><input type="radio" name="gr" value="male" checked/> Male <input type="radio" name="gr" value="female"/> Female<br /> <?php } else {?><input type="radio" name="gr" value="male" checked/> Male <input type="radio" name="gr" value="female" checked/> Female<?php }?>
<input type="hidden" name="id" value="<?php echo $id;?>">
<input type="submit" name="submit" value="update" />
</form>
</center>
<?php
}
Update.php
<?php $con = mysql_connect("localhost","root","admin123");
if(!$con)
{
die("error");
}
mysql_select_db("test");
$name = $_REQUEST['name'];
$mob = $_REQUEST['mbi'];
$quli = $_REQUEST['quli'];
$gende =$_REQUEST['gr'];
$ids = $_REQUEST['id'];
if(is_array($quli)){
$b = serialize($quli);
$sql = "update addressbook set name='$name', mobilenum = '$mob', qulifications ='$b', gender = '$gende' where id='$ids' ";
}
$upd = mysql_query($sql);
if($upd){
include_once('resultsvalues.php');
} else { die("erro".mysql_error());}
Delete:
Delete.php
<?php $con = mysql_connect(“localhost”,”root”,”admin123″);
if(!$con)
{
die(“error”);
}
mysql_select_db(“test”);
$did = $_REQUEST[‘did’];
$sql = “delete from addressbook where id = ‘$did'”;
$delte = mysql_query($sql);
if($delte)
{
include_once('resultsvalues.php');
}else {echo “error in delete”;}