1. Home
  2. Forums Index
  3. Server Side / PHP Server Side Scripting 10:44 am May 1, 2026

Forum Moderators: coopster

Message Too Old, No Replies

Display and update MySQL fields

         

MrFahad

6:44 pm on Dec 14, 2008 (gmt 0)

10+ Year Member



Hello, I'm writing a code to display fields and update them
here is my code:http://www.webmasterworld.com/postv4.cgi?action=new&forum=88
amend_property.php: 

<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/session.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php confirm_logged_in(); ?>
<?php include("includes/header.php"); ?>
<td id="page">
<h2>Amend Property</h2>
      <form method="POST" action="update_property.php">
<table>
<col span="1" align="right">
<tr>
<td>Property ID to Update:</td>
<td><input type="text" name="Propertyid" size=10></td>
</tr>
<tr>
<td><input type="submit" value="Submit"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<?php require("includes/footer.php"); ?>

update_property.php: 

<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php include("includes/header.php"); ?>
 <td id="page">
<h2>Update Record</h2>
      <?php 
$Propertyid = $_POST['Propertyid'];
foreach($HTTP_POST_VARS as $varname => $value)
$formVars[$varname]=$value;
$formVars[$varname]=$value;
$query="SELECT * FROM properties WHERE Propertyid = $Propertyid";
$result= mysql_query($query);
$row=mysql_fetch_array($result);
$formVars = array();
$formVars["Propertyid"]=$row["Propertyid"];
$formVars["PropertyType"]=$row["PropertyType"];
$formVars["PropertyAddress"]=$row["PropertyAddress"];
$formVars["No_bedroom"]=$row["No_bedroom"];
$formVars["ListingDate"]=$row["ListingDate"];
$formVars["ListedPrice"]=$row["ListedPrice"];
$formVars["DateBuild"]=$row["DateBuild"];
$formVars["Area"]=$row["Area"];
$formVars["Description"]=$row["Description"];
?>

  
<p>&nbsp;</p>
      <form method="post" action="postupdate_property.php">
      Property ID:
      
      <input name="Propertyid" type="text" value="<? echo $Propertyid; ?>" id="Propertyid" />
      
      Property Type: 
<select name="PropertyType">
        <?php if ( $formVars["PropertyType"] == 1 ) {
  echo
        <option value="1">Aapartment</option>
  ;} else { 
<option value="2">Villa</option> ;}
?>
        
        </select>
</p>
 <p>&nbsp;</p>
<p>Property Address: 
         <input name="PropertyAddress" type="text" value="<? echo $formVars["PropertyAddress"]; ?>" id="PropertyAddress"/>
</p>
 <p>&nbsp;</p>
 <p>Area: 
       <input name="Area" type="text" value="<? echo $formVars["Area"]; ?>" id="Area" /> *only numbers allowed, use meter sequire</p>
 <p>&nbsp;</p>
        <p> Listing Price:
       <input name="ListedPrice" type="text" value="<? echo $formVars["ListedPrice"]?>" id="ListedPrice"/>
       </p>
        <p>&nbsp;</p>
 <p>Number of bed rooms:
  <select name="No_bedroom">
        <? 
if ( $formVars["No_bedroom"] == 1 )
{ echo 
        <option value="1">1</option>;}
elseif ( $formVars["No_bedroom"] == 2 ) 
{ echo
        <option value="2">2</option>;}
elseif ( $formVars["No_bedroom"] == 3 )
{ echo 
        <option value="3">3</option>;}
else 
{
echo
        <option value="4">4</option>;}
?>
    </select>
 </p>
 <p>&nbsp;</p>
       <p>Listing Date:
       
<select name="lmonth">
          
    <option value='01'>January</option>
          <option value='02'>February</option>
          <option value='03'>March</option>
          <option value='04'>April</option>
          <option value='05'>May</option>
          <option value='06'>June</option>
          <option value='07'>July</option>
          <option value='08'>August</option>
          <option value='09'>September</option>
          <option value='10'>October</option>
          <option value='11'>November</option>
          <option value='12'>December</option>
         </select> 
        
        Month
        <select name="ldate" >
         <option value='01'>01</option>
         <option value='02'>02</option>
         <option value='03'>03</option>
         <option value='04'>04</option>
         <option value='05'>05</option>
         <option value='06'>06</option>
         <option value='07'>07</option>
         <option value='08'>08</option>
         <option value='09'>09</option>
         <option value='10'>10</option>
         <option value='11'>11</option>
         <option value='12'>12</option>
         <option value='13'>13</option>
         <option value='14'>14</option>
         <option value='15'>15</option>
         <option value='16'>16</option>
         <option value='17'>17</option>
         <option value='18'>18</option>
         <option value='19'>19</option>
         <option value='20'>20</option>
         <option value='21'>21</option>
         <option value='22'>22</option>
         <option value='23'>23</option>
         <option value='24'>24</option>
         <option value='25'>25</option>
         <option value='26'>26</option>
         <option value='27'>27</option>
         <option value='28'>28</option>
         <option value='29'>29</option>
         <option value='30'>30</option>
         <option value='31'>31</option>
        </select>
        Date
        <input name="lyear" type="text" size="4" />
       Year(yyyy)</p>
       <p>&nbsp;</p>
      <p>Date build: 
      <select name="month">
          
    <option value='01'>January</option>
          <option value='02'>February</option>
          <option value='03'>March</option>
          <option value='04'>April</option>
          <option value='05'>May</option>
          <option value='06'>June</option>
          <option value='07'>July</option>
          <option value='08'>August</option>
          <option value='09'>September</option>
          <option value='10'>October</option>
          <option value='11'>November</option>
          <option value='12'>December</option>
         </select>
        
        Month
        <select name="date" >
         <option value='01'>01</option>
         <option value='02'>02</option>
         <option value='03'>03</option>
         <option value='04'>04</option>
         <option value='05'>05</option>
         <option value='06'>06</option>
         <option value='07'>07</option>
         <option value='08'>08</option>
         <option value='09'>09</option>
         <option value='10'>10</option>
         <option value='11'>11</option>
         <option value='12'>12</option>
         <option value='13'>13</option>
         <option value='14'>14</option>
         <option value='15'>15</option>
         <option value='16'>16</option>
         <option value='17'>17</option>
         <option value='18'>18</option>
         <option value='19'>19</option>
         <option value='20'>20</option>
         <option value='21'>21</option>
         <option value='22'>22</option>
         <option value='23'>23</option>
         <option value='24'>24</option>
         <option value='25'>25</option>
         <option value='26'>26</option>
         <option value='27'>27</option>
         <option value='28'>28</option>
         <option value='29'>29</option>
         <option value='30'>30</option>
         <option value='31'>31</option>
        </select>
        Date
        <input name="year" type="text" size="4" />
       Year(yyyy)</p>
      <p>Description:</p>
       <p>
        <textarea name="Description" cols="100" rows="5" value="" id="Description"></textarea>
 
        
        <input type="submit" value="Submit">
       </p>
     </form>
</td>
</tr>
</table>
<?php require("includes/footer.php"); ?>

postupdate_property.php: 

<?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?>
<?php include("includes/header.php"); ?>
<td id="page">
<h2>Welcome to Coordination Real Estate</h2>
<?php
$datebuild = $_POST['year'] . - $_POST['month'] . - $_POST['date'];
$listingdate = $_POST['lyear'] . - $_POST['lmonth'] . - $_POST['ldate'];
foreach($HTTP_POST_VARS as $varname => $value)
$formVars[$varname]=$value;
$query="UPDATE properties SET 
PropertyType = '$formVars[PropertyType]',
PropertyAddress = '$formVars[PropertyAddress]',
No_bedroom = '$formVars[No_bedroom]',
ListingDate = '$listingdate',
DateBuild = '$datebuild',
Description = '$formVars[Description]' WHERE `properties`.`Propertyid` = '$formVars[Propertyid]' LIMIT 1 ";
mysql_query($query);
if ($query) {
// Success!
echo "Record updated<br><a href=\"amend_property.php\">click here</a> to update another record<br>";
} else {
// Display error message.
echo "<p> Record Updating Failed.</p>";
echo "<p>" . mysql_error() . "</p>";
}
?>
</td>
</tr>
</table>
<?php require("includes/footer.php"); ?>

Please tell me what's wrong code how to fix it thanks

andrewsmd

8:18 pm on Dec 16, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Your code is poorly structured and hard to read. Can you clean it up a little bit. Just off hand I see update_property.php: which isn't in <?php tags and does not have a ; unless that is supposed to be html. You also have <?php require_once("includes/connection.php"); ?>
<?php require_once("includes/functions.php"); ?> twice. One last thing don't put each one in <?php tags it makes it difficult to read. Make it look something more like this.
<?php
require_once("includes/connection.php");
require_once("includes/session.php");
require_once("includes/functions.php");
confirm_logged_in();
include("includes/header.php");
?>
The best way to debug php is to turn on you error messages in the PHP.ini file. If you dont have access to that then comment everything out until you get html returned and then start going in chuncks to locate the line where the problem is.

eelixduppy

10:26 pm on Dec 16, 2008 (gmt 0)



You are definitely going to need to be more descriptive as to 1) What is not working and 2) What errors, if any, you are getting.

[edited by: eelixduppy at 7:00 am (utc) on Dec. 17, 2008]

Mahabub

6:51 am on Dec 17, 2008 (gmt 0)

10+ Year Member



MrFahad,

Your code is hard to read. please clean it and post only this part which we need to understand and debug your bugs. I just take a look om your code and find syntax error in below codes, after then I stop to see your codes.

<?php if ( $formVars["PropertyType"] == 1 ) {
echo
<option value="1">Aapartment</option>
;} else {
<option value="2">Villa</option> ;}
?>

Thanks
Mahabub

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

  1. Home
  2. Forums Index
  3. Server Side / PHP Server Side Scripting 10:44 am May 1, 2026