How to use Oracle Database in PHP (3) _php Basics

Using ORA to enter data into the datasheet ' Email_info '

When the user browses this script, displays a form that consists of a name, an email input field, and when the user adds a good data click Submit, the script will save the name and email to the ' email_info ' datasheet.

Related PHP Code:


if ($submit = = "click") {
The Submit button was clicked!
Get the input for fullname and email then store it in the database.
PUTENV ("Oracle_sid=orasid");

$connection = Ora_logon ("username", "password");
if ($connection = = False) {
echo Ora_errorcode ($connection). ":". Ora_error ($connection). "
";
Exit
}

$cursor = Ora_open ($connection);
if ($cursor = = False) {
echo Ora_errorcode ($connection). ":". Ora_error ($connection). "
";
Exit
}

$query = "INSERT into email_info values (' $fullname ', ' $email ')";
$result = Ora_parse ($cursor, $query);
if ($result = = False) {
echo Ora_errorcode ($cursor). ":". Ora_error ($cursor). "
";
Exit
}

$result = Ora_exec ($cursor);
if ($result = = False) {
echo Ora_errorcode ($cursor). ":". Ora_error ($cursor). "
";
Exit
}

Ora_commit ($connection);
Ora_close ($cursor);
Ora_logoff ($connection);
}
else{
Echo '


<form action=insert.php method=post>

Please enter your name
<input name=fullname> </INPUT>

Please enter your email address
<input name=email> </INPUT>

<input name=submit type=submit value=click> </INPUT>

</FORM>


';
}

?>


Yes, this script must be saved as insert.php because the insert.php is specified as the form handler in the calling page