PHP file vs CGI

netrepsa

Could any one give me help to create a php file that will update my record in table admin with information captured in a form.

I have tried every possible code to update in one file whithout success.

SARAH this might be in your expert field?

PHP

if (isset($submit)) {

$mysql = "UPDATE admin SET yourname='$yourname', youraddress='$youraddress', yourcity='$yourcity', yourpcode='$yourpcode', yourtel='$yourtel', youremail='$youremail', yourcontact='$yourcontact', yourbank='$yourbank', yourbranch='$yourbranch', yourbranchcode='$yourbranchcode', youraccount='$youraccount', farmname='$farmname', hunttype='$hunttype', subtitle='$subtitle', theme='$theme' WHERE ID=$id";

// run SQL against the DB

if (mysql_affected_rows() != 1) echo "An update problem";
echo " ";
if(!($result)) die(mysql_error());
echo " ";

}

diego25

if(!($result)) die(mysql_error());

What's $result? I don't see if defined anywhere...Maybe that's why !$result is always returning true and your script dies.

Diego

matt_4013

You aren't actually running the query in there. $mysql = "UPDATE ... is just putting your sql query into a variable. What you'll need to do, is get your script to connect to the database, then run the query.


// Connect To the Server
$db = mysql_connect("servername","userid","password") or die(mysql_error());

// Select the Database to use
mysql_select_db("databasename", $db) or die(mysql_error());

// Define the SQL and run the query
$mysql = "UPDATE blah SET fieldname=value";
$result = mysql_query($mysql) or die(mysql_error());

// Now use your mysql_ functions on $result

netrepsa

<?php

// Connect To the Server
$db = mysql_connect("servername","userid","password") or die(mysql_error());

// Select the Database to use
mysql_select_db("databasename", $db) or die(mysql_error());

// Define the SQL and run the query
$mysql = "UPDATE admin SET yourname='$yourname', youraddress='$youraddress', yourcity='$yourcity', yourpcode='$yourpcode', yourtel='$yourtel', youremail='$youremail', yourcontact='$yourcontact', yourbank='$yourbank', yourbranch='$yourbranch', yourbranchcode='$yourbranchcode', youraccount='$youraccount', farmname='$farmname', hunttype='$hunttype', subtitle='$subtitle', theme='$theme' WHERE user='$name";

$result = mysql_query($mysql) or die(mysql_error());

// Now use your mysql_ functions on $result

// run SQL against the DB

if (mysql_affected_rows() != 1) echo "An update problem";
echo " ";
if(!($result)) die(mysql_error());
echo " ";

diego25

if (mysql_affected_rows() != 1) echo "An update problem";
echo " ";
if(!($result)) die(mysql_error());

I would reverse those 2 if statements. First you should check that no MySQL errors occured, and then you should check YOUR errors.

Diego

matt_4013

if(!($result)) die(mysql_error());

You wont need that statement at all. Exactly the same thing is achieved by adding the or die(mysql_error()) to the end of the mysql_query function.

RedDragon

dont forget that all vars in a query have to be enclosed by
single quotes

ahundiak

RedDragon,
Integer column variables do not get enclosed in single quotes. The sql statement will fail if they are.

RedDragon

i mean when putting the query into a variable,
$var should be set into single quotes, e.g.:

$x = "UPDATE table SET name='$name' WHERE (city='$city')";

or even

$x = "UPDATE table SET name=".$name." WHERE (city=".$city.")";

it doesnt matter if $name = "Tom" or $name = 1