DB = Oracle 10.2.0.1
WEBSERV = Apache 2.0.55
LANG = PHP5
I have created (or more accurately, copied) a php script to insert data into one of my database tables when I press submit. The code is as follows (my connect string works fine and its included in the dbutils.php file):
<?php
if($submit == "submit"){
include "dbutils.php";
$query = "insert into users values (seq_user_usr_id.NEXTVAL, '$usr_name')";
$cursor = OCIParse ($db_conn, $query);
if ($cursor == false){
echo OCIError($cursor)."<BR>";
exit;
}
$result = OCIExecute ($cursor);
if ($result == false){
echo OCIError($cursor)."<BR>";
exit;
}
OCICommit ($db_conn);
OCILogoff ($db_conn);
}
else{
echo '
<html><body>
<form method="post" action="index.php">
<table width="400" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>Please enter a username:</td>
<td><input type="text" name="usr_name"></input><br></td>
</tr>
<tr>
<td><input type="submit" name="button" value="Submit"></input></td>
</tr>
</table>
</form>
</body></html>
';
}
?></p>
I am getting the following error regarding an undefined variable:
[Fri Jan 20 13:11:22 2006] [error] [client 127.0.0.1] PHP Notice: Undefined variable: submit in C:\\Program Files\\Apache Group\\Apache2\\htdocs\\mywebsite\\test.php on line 3
Where would I declare this variable? It is just a check to see if the submit button is pressed as far as I can see. Any help would be greatfully appreciated.
W8