Forwarding data to dbinput script

Mr_Hmmm

Hi there... newbee and confused here 😕
I am making my first steps in PHP/SQL by creating a low-tech guestbook (wow, that's something new! :o)
So far I have created these two files... The first to get some info, the next to put it in the 'guestbook' table..
Somehow the vars don't get passed on to the next file, I get the error:
Notice: Undefined variable: naam in /home/didact/nvon/public_html/natkunde/vs/create_entry.php on line 9 (and the same for 'lokatie')
How am i supposed to get them to the next file???
Who can help me out here??
Thanx in advance!!

<B>Naam</B>
<input type=text size=40 name=naam>
<BR>
<B>Lokatie</B>
<input type=text size=40 name=lokatie>
<BR>
<input type=submit name=submit value="Sign!">
<input type=reset name=reset value="Start Over">

(the 'create_entry file....)

<?PHP
include("connectdb.php");

$query = "insert into guestbook
(naam,lokatie) values
('$naam', '$lokatie')"
;

mysql_query($query) or die (mysql_error());
?>

bastien

<?PHP
include("connectdb.php");

$query = "insert into guestbook
(naam,lokatie) values
('$naam', '$lokatie')"
;

mysql_query($query) or die (mysql_error());
?>

bastien

The new methods use $POST and $GET to obtain the data from the form...........

<?PHP
include("connectdb.php");

$query = "insert into guestbook
(naam,lokatie) values
('$POST['naam']', '$POST['lokatie']')"
;

mysql_query($query) or die (mysql_error());
?>

PS If you're not dutch, you're not much😃

Mr_Hmmm

Wow, i finally thought i had the sollution here but...

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/didact/etc/etc/etc/create_entry.php on line 9
(that is the line you altered)

I am Dutch, but it still ain't much 😃

Can you help me out one more time?? plzplzplz

examancer

calling array element values inside strings can sometimes have unexpected results, so maybe if you remove them from the string like this, it might work:

include("connectdb.php"); 

$query = "insert into guestbook (naam,lokatie) values ('" . 
$_POST['naam'] . "', '" . $_POST['lokatie'] . "')"; 

mysql_query($query) or die (mysql_error());

I'm not good at reading php errors, so maybe thats not the problem, but i think its cleaner anyways.