PHP is inserting blanks into MYSQL database! 2

[VitoCorleone]

Hi,

I have the following script that inserts data into my SQL database. its a simple insert query to check if it works! but when i search my database, a new rowhasbeen added but it is blank.

I have looked at my code but cant find anything, can you?

<?php
global $strstaff;
// Database connection variables
$dbServer = "localhost";
$dbDatabase = "dreamhome";
$dbUser = "root";
$dbPass = "harry";

$sConn = mysql_connect($dbServer, $dbUser, $dbPass)
or die("Couldn't connect to database server");
$dConn = mysql_select_db($dbDatabase, $sConn)
or die("Couldn't connect to database $dbDatabase");

$dbQuery = "INSERT INTO staff2 (staff_no) VALUES ";
$dbQuery .= "('$strstaff')";
mysql_query($dbQuery) or die("Couldn't add file to database");

echo "<h1>File Uploaded</h1>"
?>

This is a 2 page insert method. the first page has a simple form which in the form header has

<form enctype="multipart/form-data" name="frmUploadFile" action="grabfile.php" method="post">

and the textbox is called strstaff, hence $strstaff in the PHP code above.

and my database only consists of one column staff_no.

 

[kenrbnsn]

If $strstaff is coming from the form, use $_POST['strstaff'] to get the value.

The php.ini variable register_globals is now off by default.

If you had echoed your query before doing the database call, you would have seen the problem.

Ken

 

[VitoCorleone]

i changed the query too

$dbQuery = "INSERT INTO staff2 (staff_no) VALUES ";
$dbQuery .= "('$_POST['strstaff']')";
mysql_query($dbQuery) or die("Couldn't add file to database");

Im now getting the error message

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in f:\wamp\

http://www\grabfile.php

on line 22


and on that line is $dbQuery .= "('$_POST['strstaff']')";

 

[sleipnir214]

Try that second $dbQuery line as:

$dbQuery .= "('" . $_POST['strstaff'] . "')";

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[VitoCorleone]

Thats great, thanks for all the input guys.

 

[sleipnir214]

I also recommend that you take a look at the FAQ in this forum, titled "Debugging PHP": faq434-2999

Want the best answers? Ask the best questions!

TANSTAAFL!!