sql problems...

[Sobbs]

$con = mysql_connect("xxxxxxxxxxx","xxxxxxxx","xxxxxxxxxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }else{
echo "Connected to DB";
}


$sql = "INSERT INTO `b33_3176976_lunadb`.`DB_Guides` (`gid`, `uname`, `gname`, `icon`, `desc`, `cat`, `body`, `score`) VALUES (NULL, \'$_POST['name']\', \'$_POST['guidename']\', \'$_POST['icon']\', \'$_POST['description']\', \'$_POST['cat']\', \'$_POST['body']\', \'0\');";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con);

This is supposed to add the info requested from a form but for somereason non of the info ever gets put into the database. The code doesnt even seem to work since it should say I was connected to the database but I always get a blank screen. Whats going wrong?

[revraz]

Blank screens usually indicate a syntax error.  Turn on error display and error reporting and see if any errors are returned.

[Sobbs]

How would I turn it on?

[Maq]

You don't need to escape all of those single quotes in your values.

[irkevin]

ive noticed an extra semicolumn after the insert query

 

"INSERT INTO `b33_3176976_lunadb`.`DB_Guides` (`gid`, `uname`, `gname`, `icon`, `desc`, `cat`, `body`, `score`) VALUES (NULL, \'$_POST['name']\', \'$_POST['guidename']\', \'$_POST['icon']\', \'$_POST['description']\', \'$_POST['cat']\', \'$_POST['body']\', \'0\');";

 

try this

 

$con = mysql_connect("xxxxxxxxxxx","xxxxxxxx","xxxxxxxxxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }else{
echo "Connected to DB";
}


$sql = "INSERT INTO `b33_3176976_lunadb`.`DB_Guides` (`gid`, `uname`, `gname`, `icon`, `desc`, `cat`, `body`, `score`) VALUES (NULL, \'$_POST['name']\', \'$_POST['guidename']\', \'$_POST['icon']\', \'$_POST['description']\', \'$_POST['cat']\', \'$_POST['body']\', \'0\')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con);

 

[revraz]

That's not really a extra semi colon, its a SQL ending semi colon, which is just fine.

 

ive noticed an extra semicolumn after the insert query

 

[Sobbs]

Nope, no luck.

[revraz]

With what?  Did you enable error reporting?

 

ini_set ("display_errors", "1");

error_reporting(E_ALL);

 

Nope, no luck.

[revraz]

Also, remove the gid and the NULL from your insert statement, you don't need it if it's set to auto increment.

[Sobbs]

Im unable to enable error reporting for some reason.  And it was in response to irkevin's attempt.

[revraz]

Post the entire code.

[Sobbs]

That pretty much is the entire code. There isn't much to it. Its simply ment to add info from a form into a database

[irkevin]

well. i dont see

 

mysql_select_db() in your code. do you have it or not?

[Sobbs]

I added that and its still not enetering anything into the database.

Ive re written the code without any post data.

<?php
ini_set ("display_errors", "1");
error_reporting(E_ALL);

$con = mysql_connect("--","--","--");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }else{
echo "Connected to DB";
}

$db = mysql_select_db("b33_3176976_lunadb", $con);
if (!$db)
  {
  die('Could not connect: ' . mysql_error());
  }else{
echo "DB selected";
}

mysql_query("INSERT INTO DB_Guide (uname, gname, icon, desc, cat, body, score) 
VALUES ('test', 'test', 'test', 'test', 'test', '0')");



?>

It still doesn apear to work.

[trq]

desc is a reserved word, either change the field identifier (recommended) or surround it with `backticks`.

 

if (!mysql_query("INSERT INTO DB_Guide (uname, gname, icon, `desc`, cat, body, score) VALUES ('test', 'test', 'test', 'test', 'test', '0')")) {
  echo mysql_error();
}

[Sobbs]

Its still not working.

if (!mysql_query("INSERT INTO DB_Guide (uname, gname, icon, dsc, cat, body, score) VALUES ('test', 'test', 'test', '1', 'test', '0')")) {
  echo mysql_error();
}
?>

[trq]

What does mysql_error() produce?

[Sobbs]

Im not getting any errors showing up. It apears to be running properly, but nothing is added into the database.

[trq]

That makes little sense. Try this....

 

if (!mysql_query("INSERT INTO DB_Guide (uname, gname, icon, dsc, cat, body, score) VALUES ('test', 'test', 'test', '1', 'test', '0')")) {
  echo mysql_error();
} else {
  echo "success";
}

 

Do you get any output?

[Ninjakreborn]

Values != fieldnames.

uname, gname, icon, dsc, cat, body, score (7)

test, test, test, 1, test, 0 (6)

You need as many values as you need fields.

[Sobbs]

That makes little sense. Try this....

 

if (!mysql_query("INSERT INTO DB_Guide (uname, gname, icon, dsc, cat, body, score) VALUES ('test', 'test', 'test', '1', 'test', '0')")) {
  echo mysql_error();
} else {
  echo "success";
}

 

Do you get any output?

None.

if (!mysql_query("INSERT INTO DB_Guide (uname, gname, icon, dsc, cat, body, score) VALUES ('test', 'test', 'test', 'test', '1', 'test', '0')")) {
  echo mysql_error();
} else {
  echo "success";
}

[Ninjakreborn]

I have just told you what one of the problems where.

The number of fields you have does not equal the number of values you are trying to put in.

You listed 7 fields and you are only filling out 6 values. It will not allow that to go through. You need to

put down one more value to match the number of fields you are entering or drop off one of the fields (either one).

[Sobbs]

I have just told you what one of the problems where.

The number of fields you have does not equal the number of values you are trying to put in.

You listed 7 fields and you are only filling out 6 values. It will not allow that to go through. You need to

put down one more value to match the number of fields you are entering or drop off one of the fields (either one).

If you looked at my updated code, I did change it.

[Ninjakreborn]

It sounds like your server/ini have error reporting and outputing disabled.

Use the following url: http://us.php.net/error_reporting and cut on the error reporting temporarily (at the top of your code).

 

Afterwards verify the Database name in your code is the same as your database name on the server.

 

Also your connection information...make sure it's the same as your web host. Not all hosts allow you to connect using "localhost" what webhost are you using right now?

[Maq]

There's something before the SQL block causing a blank page.

 

Put this at the top of your script:

 

ini_set ("display_errors", "1");
error_reporting(E_ALL);