Cannot insert into Mysql Database (Form and Formhandler on same file)

Audioslaved

Hello,
I am trying to do something very simple, why this will not work is totally beyond me, many of the other threads I have read deal with external form handlers, I would like to have it consolidated into one. Here is my code, please help! Thanks in advance.

The below code should submit the "title" into the database, for some reason, no matter how much I change it around or what I try, It keeps giving me the error message.

Thank you for your time, and if you have any questions you can ICQ me at 173671871

-Bill

<?php
//Form
function defaultDisplay() {
    include ('../header.php');
    echo "<form action=\"$SERVER['PHP_SELF']\" method=\"post\">"
        ."<b>AOR</b> "
        ."<input type=\"text\" name=\"title\" size=\"50\" maxlength=\"80\"><br>";
    echo "<br><br><input type=\"submit\" name=\"op\" value=\"Submit\">"
	."<br>(Submit)</form>";
    include ('../footer.php');
}

//Add Title to DB
function SubmitStory() {
//Connect to DB 
mysql_connect("localhost", "********", "*******") or die("Sorry buddy that failed!"); //The stars were done on purpose
mysql_select_db("audiosla_arc"); 

$title = mysql_escape_string($_POST['title']);
//Insert Into DB
$query = "INSERT INTO arc_aor (aorid, aortitle) VALUES (NULL, '$title')";
$result = mysql_query($query);
    if(!$result) {
    	echo "There was some sort of error, nice try ass!<br>";
     	exit();
    }
    include ('../header.php');
    $query = "SELECT * from arc_aor";
    $result = mysql_query($query);
    $waiting = sql_num_rows($result);
    echo "<center><br>You just submitted $waiting To the Database. Thank you!</center>";
    include ('../footer.php');
}
//Onsubmit go from one function to the next
switch($op) {

case "Submit":
SubmitStory();
break;

default:
defaultDisplay();
break;

}

?>

tsinka

Hi,

post the error message you get.

I modified your code a bit:

 <?php 
//Form 
function defaultDisplay() { 
    include ('../header.php'); 
    ercho <<< EOHTML
    <form action="<?=$_SERVER['PHP_SELF'] ?>" method="post">
        <b>AOR</b>
        <input type="text" name="title" size="50" maxlength="80"><br>
       <br><br><input type="submit" name="op" value="Submit">
       <br>(Submit)
    </form> 
EOHTML;
    include ('../footer.php'); 
} 

//Add Title to DB 
function SubmitStory() { 
    //Connect to DB 
    mysql_connect("localhost", "********", "*******") or die("Sorry buddy that failed! ".mysql_error()); //The stars were done on purpose 
    mysql_select_db("audiosla_arc") or die("Selection of database failed: ".mysql_error());  

$title = mysql_escape_string($_POST['title'])
//Insert Into DB 
$query = "INSERT INTO arc_aor (aortitle) VALUES ('$title')";
$result = mysql_query($query) or die("Error in SQL query: ".mysql_error()); 
include ('../header.php'); 
$query = "SELECT count(*) from arc_aor"; 
$result = mysql_query($query) or die("Error in SQL query:".mysql_error()); 
if ($row = mysql_fetch_row($result)) {
    $rowcount = $row[0];
    echo "<center><br>You just submitted $rowcount To the Database. Thank you!</center>";
} else {
    echo "<center><br>No records in database</center>";
}
include ('../footer.php'); 
} 
    //Onsubmit go from one function to the next 
    if (isset($_POST['op'])) {
        SubmitStory();
    } else {
        defaultDisplay(); 
    }
} 
?>

What did you want to do with the SELECT * ? Get the total number of records in the database and tell the user that he e.g. submitted the e.g. fourth Text ?

Audioslaved

The error message I get is the
"There was some sort of error, nice try ass!"
I am able to see the page, fill in the form, press submit, then the error occures, for some reason it is having problems writing the information to the database, I will go ahead and try what you put, thanks for the help. I will let you know what happens with your code.

-Bill

tsinka

Hi,

modify your mysql_??? function and add a mysql_error() call to them. This will give you a human readable description of the error 🙂

Audioslaved

With your script I am getting parse errors. Right around here,

<?php  

//Form 
function defaultDisplay() {  

    include ('../header.php');  

    ercho <<< EOHTML 
    <form action="<?=$_SERVER['PHP_SELF'] ?>" method="post"> 

//I thought you werent able to use the autoglobals inside of
//heradic code, dont you have to declare it outside, for example

$thisfile = $_SERVER['PHP_SELF'];
THEN INSIDE OF HERADIC ENTER
$ercho = <<< EOHTML  //I think this is how it is supposed to be
<FORM ACTION="$thisfile" METHOD="post">

Thanks again for the help, really appreciate it, I am stumped.

tsinka

Hi,

sorry for that ... I had some more errors in my script 🙂
Hope this one works 🙂

<?php  

function defaultDisplay() 
{
    include "../header.php";
?>
    <form action="<?=$_SERVER['PHP_SELF'] ?>" method="post"> 
        <b>AOR</b> 
        <input type="text" name="title" size="50" maxlength="80"><br> 
       <br><br><input type="submit" name="op" value="Submit"> 
       <br>(Submit) 
    </form>
<?PHP

include "../footer.php";  
}  


//Add Title to DB 
function SubmitStory() {  

    //Connect to DB 
    mysql_connect("localhost", "********", "*******") or die("Sorry buddy that failed! ".mysql_error());
    mysql_select_db("audiosla_arc") or die("Selection of database failed: ".mysql_error());   

$title = mysql_escape_string($_POST['title']);
//Insert Into DB 
$query = "INSERT INTO arc_aor (aortitle) VALUES ('$title')"; 
$result = mysql_query($query) or die("Error in SQL query: ".mysql_error());  
include "../header.php'";  
$query = "SELECT count(*) from arc_aor";  
$result = mysql_query($query) or die("Error in SQL query:".mysql_error());  
if ($row = mysql_fetch_row($result)) { 
    $rowcount = $row[0]; 
    echo "<center><br>You just submitted $rowcount To the Database. Thank you!</center>"; 
} else { 
    echo "<center><br>No records in database</center>"; 
} 
include "../footer.php";  
}  

    //Onsubmit go from one function to the next 
if (isset($_POST['op'])) { 
    SubmitStory(); 
} else { 
    defaultDisplay();  

} 
?>