ociparse(): OCIParse: ORA-01756: quoted string not properly terminated
I would appreciate any help I could get with this. I have been trying to figure this out for way too long.
Here is my code:
Code: Select all
<?php
$Title = $_POST["Title"];
$FNAME = $_POST["FNAME"];
$LNAME = $_POST["LNAME"];
$SUID = $_POST["SUID"];
$EMAIL = $_POST["EMAIL"];
$DEPT = $_POST["DEPT"];
$PHONE = $_POST["PHONE"];
$ADDRESS = $_POST["ADDRESS"];
$FIRSTYR = $_POST["FIRSTYR"];
$SSIZE = $_POST["SSIZE"];
$STYPE = $_POST["STYPE"];
$PARTICIPATE = $_POST["PARTICIPATE"];
$ATTEND = $_POST["ATTEND"];
$GUESTS = $_POST["GUESTS"];
$session = $_POST["session"];
$toaddress = "123@abc";
$subject = $Title;
$mailcontent .= " Name: $FNAME $LNAME\n";
$mailcontent .= " SUID: $SUID\n";
$mailcontent .= " Email: $EMAIL\n";
$mailcontent .= " Dept: $DEPT\n";
$mailcontent .= " Phone: $PHONE\n";
$mailcontent .= " Campus Address: $ADDRESS\n\n";
$mailcontent .= " Frist Year: $FIRSTYR\n\n";
$mailcontent .= " Shirt Size: $SSIZE\n";
$mailcontent .= " Shirt Type: $STYPE\n\n";
$mailcontent .= " How Particptating: $PARTICIPATE\n\n";
$mailcontent .= " Attend Supper: $ATTEND\n";
$mailcontent .= " No. Guests: $GUESTS\n";
$fromaddress = "From: " . $EMAIL;
mail($toaddress, $subject, $mailcontent, $fromaddress);
$user = "xxx";
$pass = "xxx";
$db = "xxx";
$dt = date("Y-m-d");
$conn = ocilogon($user, $pass, $db);
$sql = "INSERT INTO MAINEVENT (FNAME, LNAME, SUID, EMAIL, DEPT, PHONE, ADDRESS, FIRSTYR, SSIZE, STYPE, PARTICIPATE, ATTEND, GUESTS) VALUES ('$FNAME', '$LNAME', '$SUID', '$EMAIL', '$DEPT', '$PHONE', '$ADDRESS', '$FIRSTYR', '$SSIZE', '$STYPE', '$PARTICIPATE', '$ATTEND', '$GUESTS')";
$stmt = ociparse($conn, $sql);
ociexecute($stmt)or die("Unable to execute query\n");
?>