Hi everyone i have just started learning php and is still quite new and unfamiliar with it. I have written 2 files after learning from some tutorial but i have some problem with it. When i submit the form, it gives me this error.
Furthermore, when i opened up my database, i saw blank entry being entered in.
These are my codes.
(My form, maillist.html)
<html>
<body>
<form method="post" action="http://localhost/data.php">
Email: <input name="email" type="text" /><br />
<input type="submit" value="Subscribe" />
</form>
</body>
</html>
This is my PHP code.
<html>
<body>
<?php
$_REQUEST = array();
$email = $_REQUEST['email'];
function Database_Entries($msg) {
echo $msg;
}
function Output_Entries() {
$cnx = odbc_connect( 'subcriber' , 'root', '' );
if (!$cnx) {
Error_handler( "Error in odbc_connect" , $cnx );
}
$cur= odbc_exec( $cnx, "select email from People" );
if (!$cur) {
Error_handler( "Error in odbc_exec( no cursor returned ) " , $cnx );
}
echo "<table><tr><th>email</th>".
"</tr>\n";
$nbrow=0;
while( odbc_fetch_row( $cur ) ) {
$nbrow++;
$email= odbc_result( $cur, 1 ); // get the field "email"
echo "<tr><td>$email</td>".
"</tr>\n";
}
echo "<tr><td colspan=2>$nbrow entries </td></tr></table>";
odbc_close( $cnx);
}
function Error_Handler( $msg, $cnx ) {
echo "$msg \n";
odbc_close( $cnx);
exit();
}
function Enter_New_Entry($email) {
$cnx = odbc_connect( 'subcriber' , 'root', '' );
if (!$cnx) {
Error_handler( "Error in odbc_connect" , $cnx );
}
$SQL_Exec_String = "Insert Into People (email)
Values ('$email')";
$cur= odbc_exec( $cnx, $SQL_Exec_String );
if (!$cur) {
Error_handler( "Error in odbc_exec( no cursor returned ) " , $cnx );
}
odbc_close( $cnx);
echo "Thank you for subscribing!";
}
Output_Entries();
Enter_New_Entry($email);
Output_Entries();
?>
</body>
</html>
Pls help me thx. Help is appreciated much.
