Hi everyone,
I'm developing a page in which we can add new data, update and delete an existing data. I've written the code for inserting new data, but i'm having problems with where and how do i write the code for the other two.
My program creates a form which has three submit buttons.
Here's my code....
Please read the submit as view in here and the update as inserting new data.
I've an idea that i'll have two use 2 more hidden values as i have mentioned in my code....but i'm not able to find out how to use them.
Anyone's help in this will be appreciated.
<?php
include('dbconn.php');
if(!empty($POST['mode1Var']))
{
$mode1Var = $POST['mode1Var'];
//we were in view mode, now we're in edit mode
if( $mode1Var == "submit" )
{
$mode1Var = "update";
//insert/update query goes here
$sql="INSERT INTO properties (address,area,rent,water,sewer,garbage,br,bath,shower,tub,familyrm,fireplace,stove,refrigerator,dishwasher,disposal,type,deposit,available,terms,heat,sqft,carpetting,garage,hookups,yard,fenced,pet,washer,dryer,comments)
VALUES
('$POST[address]','$POST[area]','$POST[rent]','$POST[water]','$POST[sewer]','$POST[garbage]','$POST[br]','$POST[bath]','$POST[shower]','$POST[tub]','$POST[familyrm]','$POST[fireplace]','$POST[stove]','$POST[refrigerator]','$POST[dishwasher]','$POST[disposal]','$POST[type]','$POST[deposit]','$POST[available]','$POST[terms]','$POST[heat]','$POST[sqft]','$POST[carpetting]','$POST[garage]','$POST[hookups]','$POST[yard]','$POST[fenced]','$POST[pet]','$POST[washer]','$POST[dryer]','$_POST[comments]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
echo "<br />";
}
//we were in edit mode, now we're in view mode
else
{ $mode1Var = "submit"; }
}
else
//we just started
{ $mode1Var = "submit"; }
if(!empty($POST['address']))
{ $addressVar = $POST['address']; }
else
{ $addressVar = ""; }
if(!empty($POST['area']))
{ $areaVar = $POST['area']; }
else
{ $areaVar = ""; }
if(!empty($POST['rent']))
{ $rentVar = $POST['rent']; }
else
{ $rentVar = ""; }
if(!empty($POST['water']))
{ $waterVar = $POST['water']; }
else
{ $waterVar = ""; }
if(!empty($POST['sewer']))
{ $sewerVar = $POST['sewer']; }
else
{ $sewerVar = ""; }
if(!empty($POST['garbage']))
{ $garbageVar = $POST['garbage']; }
else
{ $garbageVar = ""; }
if(!empty($POST['br']))
{ $brVar = $POST['br']; }
else
{ $brVar = ""; }
if(!empty($POST['bath']))
{ $bathVar = $POST['bath']; }
else
{ $bathVar = ""; }
if(!empty($POST['shower']))
{ $showerVar = $POST['shower']; }
else
{ $showerVar = ""; }
if(!empty($POST['tub']))
{ $tubVar = $POST['tub']; }
else
{ $tubVar = ""; }
if(!empty($POST['familyrm']))
{ $familyrmVar = $POST['familyrm']; }
else
{ $familyrmVar = ""; }
if(!empty($POST['fireplace']))
{ $fireplaceVar = $POST['fireplace']; }
else
{ $fireplaceVar = ""; }
if(!empty($POST['stove']))
{ $stoveVar = $POST['stove']; }
else
{ $stoveVar = ""; }
if(!empty($POST['refrigerator']))
{ $refrigeratorVar = $POST['refrigerator']; }
else
{ $refrigeratorVar = ""; }
if(!empty($POST['dishwasher']))
{ $dishwasherVar = $POST['dishwasher']; }
else
{ $dishwasherVar = ""; }
if(!empty($POST['disposal']))
{ $disposalVar = $POST['disposal']; }
else
{ $disposalVar = ""; }
if(!empty($POST['type']))
{ $typeVar = $POST['type']; }
else
{ $typeVar = ""; }
if(!empty($POST['deposit']))
{ $depositVar = $POST['deposit']; }
else
{ $depositVar = ""; }
if(!empty($POST['available']))
{ $availableVar = $POST['available']; }
else
{ $availableVar = ""; }
if(!empty($POST['terms']))
{ $termsVar = $POST['terms']; }
else
{ $termsVar = ""; }
if(!empty($POST['heat']))
{ $heatVar = $POST['heat']; }
else
{ $heatVar = ""; }
if(!empty($POST['sqft']))
{ $sqftVar = $POST['sqft']; }
else
{ $sqftVar = ""; }
if(!empty($POST['carpetting']))
{ $carpettingVar = $POST['carpetting']; }
else
{ $carpettingVar = ""; }
if(!empty($POST['garage']))
{ $garageVar = $POST['garage']; }
else
{ $garageVar = ""; }
if(!empty($POST['hookups']))
{ $hookupsVar = $POST['hookups']; }
else
{ $hookupsVar = ""; }
if(!empty($POST['yard']))
{ $yardVar = $POST['yard']; }
else
{ $yardVar = ""; }
if(!empty($POST['fenced']))
{ $fencedVar = $POST['fenced']; }
else
{ $fencedVar = ""; }
if(!empty($POST['pet']))
{ $petVar = $POST['pet']; }
else
{ $petVar = ""; }
if(!empty($POST['washer']))
{ $washerVar = $POST['washer']; }
else
{ $washerVar = ""; }
if(!empty($POST['dryer']))
{ $dryerVar = $POST['dryer']; }
else
{ $dryerVar = ""; }
if(!empty($POST['comments']))
{ $commentsVar = $POST['comments']; }
else
{ $commentsVar = ""; }
?>
<html>
<head>
</head>
<body>
<form action="method.php" method="post">
Address: <br>
<input type="text" name="address" value="<?php print($addressVar);?>" />
<br>
<br>
<table border="0" width="100%" cellpadding="10">
<tr>
<td width="30%">
Area:
<input type="text" name="area" value="<?php print($areaVar); ?>" />
</td>
<td width="30%">
Rent:
<input type="text" name="rent" value="<?php print($rentVar);?>" />
</td>
<td width="40%">
Water:
<input type="text" name="water" value="<?php print($waterVar);?>" />
</td>
</tr>
<tr>
<td width="30%">
Sewer:
<input type="text" name="sewer" value="<?php print($sewerVar);?>" />
</td>
<td width="30%">
Garbage:
<input type="text" name="garbage" value="<?php print($garbageVar);?>" />
</td>
<td width="30%">
Bed-Room:
<input type="text" name="br" value="<?php print($brVar);?>" />
</td>
</tr>
<tr>
<td width="30%">
Bath:
<input type="text" name="bath" value="<?php print($bathVar);?>" />
</td>
<td width="30%">
Shower:
<input type="text" name="shower" value="<?php print($showerVar);?>" />
</td>
<td width="40%">
Tub:
<input type="text" name="tub" value="<?php print($tubVar);?>" />
</td>
</tr>
<tr>
<td width="30%">
Family Room:
<input type="text" name="familyrm" value="<?php print($familyrmVar);?>" />
</td>
<td width="30%">
Fireplace:
<input type="text" name="fireplace" value="<?php print($fireplaceVar);?>" />
</td>
<td width="40%">
Stove:
<input type="text" name="stove" value="<?php print($stoveVar);?>" />
</td>
</tr>
<tr>
<td width="30%">
Refrigerator:
<input type="text" name="refrigerator" value="<?php print($refrigeratorVar);?>" />
</td>
<td width="30%">
Dishwasher:
<input type="text" name="dishwasher" value="<?php print($dishwasherVar);?>" />
</td>
<td width="40%">
Disposal:
<input type="text" name="disposal" value="<?php print($disposalVar);?>" />
</td>
</tr>
<tr>
<td width="30%">
Type:
<input type="text" name="type" value="<?php print($typeVar);?>" />
</td>
<td width="30%">
Deposit:
<input type="text" name="deposit" value="<?php print($depositVar);?>" />
</td>
<td width="40%">
Available:
<input type="text" name="available" value="<?php print($availableVar);?>" />
</td>
</tr>
<tr>
<td width="30%">
Terms:
<input type="text" name="terms" value="<?php print($termsVar);?>" />
</td>
<td width="30%">
Heat:
<input type="text" name="heat" value="<?php print($heatVar);?>" />
</td>
<td width="40%">
Square Feet:
<input type="text" name="sqft" value="<?php print($sqftVar);?>" />
</td>
</tr>
<tr>
<td width="30%">
Carpetting:
<input type="text" name="carpetting" value="<?php print($carpettingVar);?>" />
</td>
<td width="30%">
Garage:
<input type="text" name="garage" value="<?php print($garageVar);?>" />
</td>
<td width="40%">
Hook-Ups:
<input type="text" name="hookups" value="<?php print($hookupsVar);?>" />
</td>
</tr>
<tr>
<td width="30%">
Yard:
<input type="text" name="yard" value="<?php print($yardVar);?>" />
</td>
<td width="30%">
Fenced:
<input type="text" name="fenced" value="<?php print($fencedVar);?>" />
</td>
<td width="40%">
Pet:
<input type="text" name="pet" value="<?php print($petVar);?>" />
</td>
</tr>
<tr>
<td width="30%">
Washer:
<input type="text" name="washer" value="<?php print($washerVar);?>" />
</td>
<td width="30%">
Dryer:
<input type="text" name="dryer" value="<?php print($dryerVar);?>" />
</td>
</tr>
</table>
Comments:<br>
<input type="text" name="comments" value="<?php print($commentsVar);?>" />
<br>
<br>
<input type="submit" value="Submit" id="submit" name="submit" />
<input type="submit" value="Update" id="update" name="submit" />
<input type="submit" value="Delete" id="delete" name="submit" />
<input type="hidden" name="mode1Var" value="<?php print($mode1Var); ?>" />
<input type="hidden" name="mode2Var" value="<?php print($mode2Var); ?>" />
<input type="hidden" name="mode3Var" value="<?php print($mode3Var); ?>" />
</form>
</body>
</html>
