Jump to content


Photo

HTML form not posting to mysql db


  • Please log in to reply
1 reply to this topic

#1 Aesop

Aesop
  • Members
  • PipPip
  • Member
  • 10 posts
  • LocationPortland Oregon

Posted 27 January 2005 - 10:10 PM

Hello! This is my first real attempt at writing php to work with mysql and I am a DW user. Now when i test this page on apache, the form accepts all the data input, press submit, and I recieve no errors on screen. I check the db, and theres nothing there. Below I will supply the form and then the php file thats used for action:

the form:


<form name="updatebldg" method="post" action="bldgupdate.php">
          <table width="105%"  border="1" bordercolor="#FFFFFF" bgcolor="#FFFFFF">
            <tr>
              <td colspan="5" bordercolor="#990000" bgcolor="#FFFFFF"><div align="center"><strong>Update Building Record </strong></div></td>
              </tr>
            <tr>
              <td width="18%" bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">TMK:</div></td>
              <td width="31%" bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                <input name="tmk" type="text" value="" size="20" maxlength="20">
              </div></td>
              <td width="2%" bgcolor="#FFFFFF">&nbsp;</td>
              <td width="24%" bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">Owner:</div></td>
              <td width="25%" bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                <input name="owner" type="text" id="owner" value="" size="20" maxlength="10">
              </div></td>
            </tr>
            <tr>
              <td bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">Address:</div></td>
              <td width="31%" bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                <input name="address" type="text" id="strnum4" size="20" maxlength="8">
              </div></td>
              <td bgcolor="#FFFFFF">&nbsp;</td>
              <td bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">Land Area: </div></td>
              <td width="25%" bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                <input name="landarea" type="text" id="landarea" value="" size="20" maxlength="10">
              </div></td>
            </tr>
            <tr>
              <td bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">Property:</div></td>
              <td width="31%" bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                <input name="propname" type="text" id="propname" size="20" maxlength="20">
              </div></td>
              <td bgcolor="#FFFFFF">&nbsp;</td>
              <td bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">Living Area: </div></td>
              <td width="25%" bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                <input name="bldgarea" type="text" id="bldgarea" value="" size="20" maxlength="10">
              </div></td>
            </tr>
            <tr>
              <td bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">Neighborhood:</div></td>
              <td width="31%" bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                <input name="neighborhood" type="text" id="neigh6" size="20" maxlength="20">
              </div></td>
              <td bgcolor="#FFFFFF">&nbsp;</td>
              <td bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">Assessed Land Value: </div></td>
              <td width="25%" bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                <input name="landvalue" type="text" id="landvalue" value="" size="20" maxlength="10">
              </div></td>
            </tr>
            <tr>
              <td bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">City:</div></td>
              <td width="31%" bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                <input name="city" type="text" id="city" size="20" maxlength="20">
</div></td>
              <td bgcolor="#FFFFFF">&nbsp;</td>
              <td bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">Assessed Building Value:</div></td>
              <td width="25%" bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                <input name="bldgvalue" type="text" id="bldgvalue" value="" size="20" maxlength="10">
              </div></td>
            </tr>
            <tr>
              <td bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">Zip Code: </div></td>
              <td width="31%" bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                <input name="zip" type="text" id="zip" size="20" maxlength="20">
</div></td>
              <td bgcolor="#FFFFFF">&nbsp;</td>
              <td bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">Number of Bldgs on Prop. </div></td>
              <td width="25%" bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                <input name="bldgsonprop" type="text" id="bldgsonprop" value="" size="20" maxlength="10">
              </div></td>
            </tr>
            <tr>
              <td bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">Tenure:</div></td>
              <td bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                  <input name="tenure" type="text" value="" size="20" maxlength="10">
              </div></td>
              <td bgcolor="#FFFFFF">&nbsp;</td>
              <td bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">Pitt:</div></td>
              <td width="25%" bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                <input name="pitt" type="text" id="pitt2" size="20" maxlength="20">
              </div></td>
            </tr>
            <tr>
              <td bordercolor="#990000" bgcolor="#FFF7E6"><div align="right">Zoning:</div></td>
              <td bordercolor="#CCCCCC" bgcolor="#FFF7E6"><div align="left">
                  <input name="zoning" type="text" id="zoning2" size="20" maxlength="20">
              </div></td>
              <td bgcolor="#FFFFFF">&nbsp;</td>
              <td bordercolor="#FF0000" bgcolor="#FFF7E6"><div align="right"><strong>UPDATED DATE: </strong></div></td>
              <td bordercolor="#FF0000"><div align="left">
                  <input name="date" type="text" id="zoning3" size="20" maxlength="20">
              </div></td>
            </tr>
            <tr>
              <td height="15" colspan="5"><div align="center"><input type="Submit" value="Update Record"></div></td>
              </tr>
          </table>
    </form>

Now for the php file that supplies the action:

[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--]<html>
<body>
[span style=\"color:#0000BB\"]<?php
mysql_connect [/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"localhost\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#DD0000\"]\"*****\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#DD0000\"]\"*****\"[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]mysql_select_db [/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"chaneybrooks\"[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]mysql_query [/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"INSERT INTO bldgs (tmk, owner, address, landarea, propname, bldgarea, neighborhood, landvalue, city, bldgvalue, zip, bldgsonprop, pitt, tenure, zoning, date)
VALUES (\'{$_POST[\'tmk\']}\', \'{$_POST[\'owner\']}\', \'{$_POST[\'address\']}\', \'{$_POST[\'landarea\']}\', \'{$_POST[\'propname\']}\', \'{$_POST[\'bldgarea\']}\', \'{$_POST[\'neighborhood\']}\', \'{$_POST[\'landvalue\']}\', \'{$_POST[\'city\']}\', \'{$_POST[\'bldgvalue\']}\', \'{$_POST[\'zip\']}\', \'{$_POST[\'bldgsonprop\']}\', \'{$_POST[\'pitt\']}\', \'{$_POST[\'tenure\']}\', \'{$_POST[\'zoning\']}\', \'{$_POST[\'date\']}\'\"[/span][span style=\"color:#007700\"]);

print ([/span][span style=\"color:#DD0000\"]\"Building record updated.\"[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]?>
[/span]</body>
</html>
[/span][!--PHP-Foot--][/div][!--PHP-EFoot--]



#2 cx409

cx409
  • Members
  • Pip
  • Newbie
  • 8 posts

Posted 01 February 2005 - 11:03 AM

try inputting your mysql_connect(); as a variable and use it after both the after database selection and insert strings.

if all else fails, use the die(mysql_error()); or simply mysql_error(); functions to find out what's wrong...however, these errors are usually impossible to understand, but you can always post back here!
PROUD OWNER OF A CPAV ACCOUNT: cx409[br][br]View my CPAV profile[br][br]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users