Won't query to database?
Posted: Fri Nov 11, 2005 1:39 pm
I am trying to run a query, getting the info from a form. The code below is the actually query.
This is the form code
I echoed out the $insertQuery and got:
INSERT INTO info (raname,floater,weekendstart,weekendend) VALUES ('test', 'test', test, 'test')
I didn't know if it was my tables in my database so i took a screenshot and i posted it here:
http://sweetopc.com/Image.bmp
Does anyone have any idea? any help will be appreciated.
Code: Select all
<?php
// Get the PHP file containing the DbConnector class
require_once('../includes/DbConnector.php');
// Check whether a form has been submitted. If so, carry on
if ($_POST){
// Create an instance of DbConnector
$connector = new DbConnector();
// IMPORTANT!! ADD FORM VALIDATION CODE HERE - SEE THE NEXT ARTICLE
// Create an SQL query (MySQL version)
$insertQuery = "INSERT INTO info (raname,floater,weekendstart,weekendend) VALUES (".
"'".$_POST['raname']."', ".
"'".$_POST['floater']."', ".
$_POST['weekendstart'].", ".
"'".$_POST['weekendend']."')";
// Save the form data into the database
if ($result = $connector->query($insertQuery)){
// It worked, give confirmation
echo '<center><b>Article added to the database</b></center><br>';
}else{
// It hasn't worked so stop. Better error handling code would be good here!
exit('<center>Sorry, there was an error saving to the database</center>');
}
}
?>Code: Select all
<form action="newArticle.php" method="POST">
<p>Resident Assistant's Name:
<input type="text" name="raname" />
</p>
<p>If Floater Enter Date:
<input type="text" name="floater"/>
</p>
<p>If Weekend: From
<input type="text" name="weekendstart"/>
to
<input type="text" name="weekendend"/>
</p>
<p> <input type="submit" />
</p>
</form>INSERT INTO info (raname,floater,weekendstart,weekendend) VALUES ('test', 'test', test, 'test')
I didn't know if it was my tables in my database so i took a screenshot and i posted it here:
http://sweetopc.com/Image.bmp
Does anyone have any idea? any help will be appreciated.