sql update error using php

Question

I keep getting

Server error The website encountered an error while retrieving ~~https://www.website.com/update.php?FName=asdd&PHONE=4444444444~~. It may be down for maintenance or configured incorrectly.

<?php

    $FName = $_POST['FName'];
    $LName = $_POST['LName'];
    $PHON = $_POST['PHON'];

    //connect
    $dbh=mysql_connect ("localhost", "username", "password") or die ('ERROR!');
    mysql_select_db ("user_Client"); 

    $query = "INSERT INTO ClientTable (ID, FName, LName, PHON) VALUES 
                ('NULL','".$FName."','".$LName."','".$PHON."')";

    mysql_query($query) or die ('Error updating Daatabase');
    echo "Database Update with:" .$FName. " " .$LName. " " .$PHON. ;
?>

I don't know what's the problem here. I followed instructions from here http://teamtutorials.com/web-development-tutorials/php-tutorials/inserting-data-into-a-mysql-database-using-php#.UEiSQY3iajk If it helps - I'm using cPanel from Josthost.

Here is the form:

<html>
        <head>
                <title></title>
        </head>

        <body>
                <form method="post" action="update.php">
                        First Name:<br/>
                        <input type="text" name="FName" size="30" /><br/>
                        Last Name:<br/>
                        <input type="text" name="LName" size="30" /><br/>
                        Phone:<br/>
                        <input type="text" name="PHON" size="12" /><br/>
                        <input type="submit" value="Update Database"/>
                </form>
        </body>
</html>

Please, don't use mysql_* functions for new code. They are no longer maintained and the community has begun the deprecation process. See the red box? Instead you should learn about prepared statements and use either PDO or MySQLi. If you can't decide, try this article. If you care to learn, here is good PDO tutorial. — Mihai Iorga
– Mihai Iorga, Commented Sep 6, 2012 at 12:42
I'm sorry but I can't understand what does SQL has to do with a 404? — user745235
– user745235, Commented Sep 6, 2012 at 12:44
@Mihai Iorga: Don't assume that he/she has access to latest and greatest PHP. It may be that they are working on a legacy system. — Andrew Sledge
– Andrew Sledge, Commented Sep 6, 2012 at 12:44
Probably not the cause of your error, but you're setting $FNLame and trying to use $LName other places. Lots of other errors too though... — Aaron W.
– Aaron W., Commented Sep 6, 2012 at 12:44

Mihai Iorga · Accepted Answer · 2012-09-06 12:45:40Z

2

Please use PDO because mysql_* functions are deprecated ..

For your problem, you use $_GET and not $_POST, also you misspelled your variables ($FNLame):

$db = new PDO('mysql:host=localhost;dbname=user_Client;charset=UTF-8', 'username', 'password', array(PDO::ATTR_EMULATE_PREPARES => false, PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION));

$FName = $_GET['FName'];
$LName = $_GET['LName'];
$PHON = $_GET['PHON'];

$stmt = $db->prepare("INSERT INTO `ClientTable`(ID, FName, LName, PHON) VALUES (0,:FName,:LName,:PHON)");
$stmt->execute(array(':FName' => $FName, ':LName' => $LName, ':PHON' => $PHON));

echo "Database Update with:" .$FName. " " .$LName. " " .$PHON;

answered Sep 6, 2012 at 12:45

Mihai Iorga

39.8k17 gold badges109 silver badges109 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Link Over a year ago

Server error The website encountered an error while retrieving website.co/update.php. It may be down for maintenance or configured incorrectly.

Bart Friederichs · Accepted Answer · 2012-09-06 12:43:34Z

1

Your last statement is wrong:

echo "Database Update with:" .$FName. " " .$LName. " " .$PHON. ;

Should be (without the last dot):

echo "Database Update with:" .$FName. " " .$LName. " " .$PHON ;

If you look in the error log of your webserver, you'll be able to see the error. Another idea could be to turn on errors in PHP in either php.ini or with ini_set("display_errors", 1);. Make sure you only do that on your development system though.

answered Sep 6, 2012 at 12:43

Bart Friederichs

33.8k16 gold badges112 silver badges219 bronze badges

2 Comments

Bart Friederichs Over a year ago

See the other answers for that. Use $_REQUEST['PHONE'] instead of $_POST['PHON']

Bart Friederichs Over a year ago

Also, don't write 'NULL' in the ID field. If it is auto-increment, just don't refer to it: $query = "INSERT INTO ClientTable (FName, LName, PHON) VALUES ('".$FName."','".$LName."','".$PHON."')";

Muhammad Ummar · Accepted Answer · 2012-09-06 12:44:20Z

1

you are checking $_POST['PHON'], while in Query string you are passing

https://www.website.com/update.php?FName=asdd&PHONE=4444444444.

Please correct PHONE first. then check

and get it like

$_GET['PHONE']

or

$_REQUEST['PHONE']

answered Sep 6, 2012 at 12:44

Muhammad Ummar

3,6316 gold badges43 silver badges72 bronze badges

1 Comment

Dennis Hackethal Over a year ago

Also, it should be get, not post.

Emil Sierżęga · Accepted Answer · 2013-05-22 20:06:36Z

1

May be sql error due to quotes (' or ""). To avoid this, you can use something like

    $FName = mysql_real_escape_string($_POST['FName']);
    $FNLame = mysql_real_escape_string($_POST['FLame']);
    $PHON = $_POST['PHON'];

edited May 22, 2013 at 20:06

Emil Sierżęga

2,1373 gold badges35 silver badges41 bronze badges

answered Sep 6, 2012 at 12:49

jeeva

1,6032 gold badges16 silver badges25 bronze badges

Comments

Wibberley1991 · Accepted Answer · 2012-09-06 12:47:15Z

0

is your username and password correct? default for the majority of localhost is root and no password

answered Sep 6, 2012 at 12:47

Wibberley1991

2710 bronze badges

Collectives™ on Stack Overflow

sql update error using php

5 Answers 5

1 Comment

2 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

2 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related