updating column leaves it blank.

thereaper87

Hello there, just joined this forum hoping to find some light to this problem. I am very new at php and trying my best to learn it.

Here is my current problem. I have a form that updates one column in a table named 'title'. But when I submit the form, it leaves it blank. Here is the php.

session_start();
require_once 'database.php';
if(isset($_SESSION['user']))
 {
 $userid = $_SESSION['user'];
 $sql=mysql_query("SELECT * FROM user WHERE username='$userid'");
 $data=mysql_fetch_assoc($sql);
 if(isset($_GET['action']) && strcasecmp($_GET['action'], "submit") == 0)
 {
 if (function_exists('get_magic_quotes_gpc') && get_magic_quotes_gpc()) 
 { 
    $_POST['title'] = stripslashes($_POST['title']);
    $userid2 = stripslashes($userid); 
 } 
 $title = mysql_real_escape_string($_POST['title']);
 $userid3 = mysql_real_escape_string($userid);
 $update="UPDATE user SET title='$title' WHERE `username`='$userid3'";
 $update2=mysql_query($update) or die("Error Updating Account");
 if (!$update2)
 {
 die('Failed');
 }else{
 echo 'Successful!';
 }

And here is the form.

<form name="edit_account" method="post" action="?page=account&action=submit">
 <tr><td width="100">Title:</td><td width="200"><input type="text" name="title" value="<?php echo $data['title']; ?>"></td></tr>\
 <tr><td width="100"></td><td width="200"><input type="submit" value="Submit Changes"></td></tr>
 </table>
 </form>

It says successful, and no mysql errors, but it always leaves the column 'title' blank.

Any ideas?

vampiricdust

Try putting all column, table, and database names in the `` marks. Some of these names have other uses in databases and may cause issues in your queries.

Otherwise, I'd say it's probably not matching the user properly. You use $userid2 in the magic quotes if statement but then revert to $userid when you do the escaping. If magic quotes is on, it's probably giving you a bad $userid and not matching your username.

thereaper87

Thank you for replying.

I have added the `` and changed the $userid's to $userid. Still nothing. Could this be a server configuration problem? Contact the host?

vampiricdust

Well, do:

die($update)

before the query and then manually check the query to see if there's not a problem with the information getting to the query.

If you can't manually run the query on the database, then the problem is the query. If you can, then you have something wrong with the connection. However, you should be getting an error or the trigger of the die statement if something was wrong with the connecting stuff.