Updating MySQL using PHP - a problem!
Posted: Thu Jun 19, 2008 2:18 am
Folks.
I have managed to build a page which contains a form. The form populates from existing data in the MySQL database and allows the user to amend any data he / she wishes. They then click SAVE CHANGES which sends the data to the following file:
When I try to amend an existing record it reports that it was done successfully.
HOWEVER - no changes are being made to my database.
Any idea why?
Thanks in advance.
Kris.
I have managed to build a page which contains a form. The form populates from existing data in the MySQL database and allows the user to amend any data he / she wishes. They then click SAVE CHANGES which sends the data to the following file:
Code: Select all
<?php
/* Program name: amend.php
* Description: Amends data in database.
*/
?>
<html>
<head><title>Success!</title></head>
<body>
<?php
include_once("../*******.inc.php");
$cxn = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
mysql_select_db($database);
$query = "UPDATE tree SET urn='$_POST[urn]',surname='$_POST[surname]',forename='$_POST[forename]',middlenames='$_POST[middlenames]',dateofbirth='$_POST[dateofbirth]',placeofbirth='$_POST[placeofbirth]',mother='$_POST[mother]',father='$_POST[father]',sibling1='$_POST[sibling1]',sibling2='$_POST[sibling2]',sibling3='$_POST[sibling3]',sibling4='$_POST[sibling4]',sibling5='$_POST[sibling5]',sibling6='$_POST[sibling6]',sibling7='$_POST[sibling7]',sibling8='$_POST[sibling8]',sibling9='$_POST[sibling9]',sibling10='$_POST[sibling10]',christeningdate='$_POST[christeningdate]',christeningplace='$_POST[christeningplace]',spouse1='$_POST[spouse1]',spouse1marriagedate='$_POST[spouse1marriagedate]',spouse1marriageplace='$_POST[spouse1marriageplace]',spouse1child1='$_POST[spouse1child1]',spouse1child2='$_POST[spouse1child2]',spouse1child3='$_POST[spouse1child3]',spouse1child4='$_POST[spouse1child4]',spouse1child5='$_POST[spouse1child5]',spouse1child6='$_POST[spouse1child6]',spouse1child7='$_POST[spouse1child7]',spouse1child8='$_POST[spouse1child8]',spouse1child9='$_POST[spouse1child9]',spouse1child10='$_POST[spouse1child10]',spouse2='$_POST[spouse2]',spouse2marriagedate='$_POST[spouse2marriagedate]',spouse2marriageplace='$_POST[spouse2marriageplace]',spouse2child1='$_POST[spouse2child1]',spouse2child2='$_POST[spouse2child2]',spouse2child3='$_POST[spouse2child3]',spouse2child4='$_POST[spouse2child4]',spouse2child5='$_POST[spouse2child5]',spouse2child6='$_POST[spouse2child6]',spouse2child7='$_POST[spouse2child7]',spouse2child8='$_POST[spouse2child8]',spouse2child9='$_POST[spouse2child9]',spouse2child10='$_POST[spouse2child10]',occupation='$_POST[occupation]',dateofdeath='$_POST[dateofdeath]',placeofdeath='$_POST[placeofdeath]',causeofdeath='$_POST[causeofdeath]',notes='$_POST[notes]',photographs='$_POST[photographs]',census='$_POST[census]',scrapbook='$_POST[scrapbook]',certificates='$_POST[certificates]',motherurn='$_POST[motherurn]',fatherurn='$_POST[fatherurn]',sibling1urn='$_POST[sibling1urn]',sibling2urn='$_POST[sibling2urn]',sibling3urn='$_POST[sibling3urn]',sibling4urn='$_POST[sibling4urn]',sibling5urn='$_POST[sibling5urn]',sibling6urn='$_POST[sibling6urn]',sibling7urn='$_POST[sibling7urn]',sibling8urn='$_POST[sibling8urn]',sibling9urn='$_POST[sibling9urn]',sibling10urn='$_POST[sibling10urn]',spouse1urn='$_POST[spouse1urn]',spouse1child1urn='$_POST[spouse1child1urn]',spouse1child2urn='$_POST[spouse1child2urn]',spouse1child3urn='$_POST[spouse1child3urn]',spouse1child4urn='$_POST[spouse1child4urn]',spouse1child5urn='$_POST[spouse1child5urn]',spouse1child6urn='$_POST[spouse1child6urn]',spouse1child7urn='$_POST[spouse1child7urn]',spouse1child8urn='$_POST[spouse1child8urn]',spouse1child9urn='$_POST[spouse1child9urn]',spouse1child10urn='$_POST[spouse1child10urn]',spouse2urn='$_POST[spouse2urn]',spouse2child1urn='$_POST[spouse2child1urn]',spouse2child2urn='$_POST[spouse2child2urn]',spouse2child3urn='$_POST[spouse2child3urn]',spouse2child4urn='$_POST[spouse2child4urn]',spouse2child5urn='$_POST[spouse2child5urn]',spouse2child6urn='$_POST[spouse2child6urn]',spouse2child7urn='$_POST[spouse2child7urn]',spouse2child8urn='$_POST[spouse2child8urn]',spouse2child9urn='$_POST[spouse2child9urn]',spouse2child10urn='$_POST[spouse2child10urn]',yearofbirth='$_POST[yearofbirth]',photo1urn='$_POST[photo1urn]',photo1description='$_POST[photo1description]',photo2urn='$_POST[photo2urn]',photo2description='$_POST[photo2description]',photo3urn='$_POST[photo3urn]',photo3description='$_POST[photo3description]',photo4urn='$_POST[photo4urn]',photo4description='$_POST[photo4description]',photo5urn='$_POST[photo5urn]',photo5description='$_POST[photo5description]',photo6urn='$_POST[photo6urn]',photo6description='$_POST[photo6description]',photo7urn='$_POST[photo7urn]',photo7description='$_POST[photo7description]',photo8urn='$_POST[photo8urn]',photo8description='$_POST[photo8description]',photo9urn='$_POST[photo9urn]',photo9description='$_POST[photo9description]',photo10urn='$_POST[photo10urn]',photo10description='$_POST[photo10description]',cert1urn='$_POST[cert1urn]',cert1description='$_POST[cert1description]',cert2urn='$_POST[cert2urn]',cert2description='$_POST[cert2description]',cert3urn='$_POST[cert3urn]',cert3description='$_POST[cert3description]',cert4urn='$_POST[cert4urn]',cert4description='$_POST[cert4description]',cert5urn='$_POST[cert5urn]',cert5description='$_POST[cert5description]',stories1urn='$_POST[stories1urn]',stories1description='$_POST[stories1description]',stories2urn='$_POST[stories2urn]',stories2description='$_POST[stories2description]',stories3urn='$_POST[stories3urn]',stories3description='$_POST[stories3description]',stories4urn='$_POST[stories4urn]',stories4description='$_POST[stories4description]',stories5urn='$_POST[stories5urn]',stories5description='$_POST[stories5description]',stories6urn='$_POST[stories6urn]',stories6description='$_POST[stories6description]',stories7urn='$_POST[stories7urn]',stories7description='$_POST[stories7description]',stories8urn='$_POST[stories8urn]',stories8description='$_POST[stories8description]',stories9urn='$_POST[stories9urn]',stories9description='$_POST[stories9description]',stories10urn='$_POST[stories10urn]',stories10description='$_POST[stories10description]',sibling11='$_POST[sibling11]',sibling11urn='$_POST[sibling11urn]',sibling12='$_POST[sibling12]',sibling12urn='$_POST[sibling12urn]',spouse1child11='$_POST[spouse1child11]',spouse1child11urn='$_POST[spouse1child11urn]',spouse1child12='$_POST[spouse1child12]',spouse1child12urn='$_POST[spouse1child12urn]',spouse2child11='$_POST[spouse2child11]',spouse2child11urn='$_POST[spouse2child11urn]',spouse2child12='$_POST[spouse2child12]',spouse2child12urn='$_POST[spouse2child12urn]',cert1fn='$_POST[cert1fn]',cert2fn='$_POST[cert2fn]',cert3fn='$_POST[cert3fn]',cert4fn='$_POST[cert4fn]',cert5fn='$_POST[cert5fn]',relative='$_POST[relative]' WHERE urn='$POST[urn]'";
$result = mysql_query($query)
or die ("Couldn't execute query.");
echo "<p align='center'><h4>Record amended successfully!</h4><br><font face='Arial' size='2' color='#000000'>Click <a target='_top' style='font-family: Arial; font-size: 10pt; color: #000000; text-decoration: none' href='newrecord.htm'>HERE</a> to add new record</font>";
?>
</body></html>
HOWEVER - no changes are being made to my database.
Any idea why?
Thanks in advance.
Kris.