error

[ben1981]

can anyone see anything wrong with this code???

 

<?php
require_once('DbConnector.php');
if ($HTTP_POST_VARS){
$connector = new DbConnector();
$insertQuery = "INSERT INTO customers 
(firstname,lastname,address) 
VALUES 
("."'".$HTTP_POST_VARS['firstname']."', "."'".$HTTP_POST_VARS['lastname']."', 
".$HTTP_POST_VARS['address']."')";
if ($result = $connector->query($insertQuery)){
echo '<center><b>Article added to the database</b></center><br>';
}else{
exit('<center>Sorry, there was an error saving to the database</center>');
}
}
?>

I keep getting the Sorry... message

[artacus]

Well it would be easier to debug if you had included it in code tags, indented it and included the error message

[ben1981]

is that better, sorry i'm new to this

[artacus]

Getting there. What is the error message? Is it from MySQL or from PHP?

[ben1981]

well i get the message after the "else" command in the code

 

which seems to say that there was a problem adding a record - but how do i find out what the problem was???

 

i must admit i'm using a free hosting service but it comes with php mysql so i'm wondering if they have disabled certain features

 

hope you can help

[papaface]

change:

$insertQuery = "INSERT INTO customers 
(firstname,lastname,address) 
VALUES 
("."'".$HTTP_POST_VARS['firstname']."', "."'".$HTTP_POST_VARS['lastname']."', 
".$HTTP_POST_VARS['address']."')";

to

$insertQuery = "INSERT INTO customers (firstname,lastname,address) VALUES ('".$HTTP_POST_VARS['firstname']."','".$HTTP_POST_VARS['lastname']."','".$HTTP_POST_VARS['address']."')";

[artacus]

I'm not familiar with the db abstraction class you are using. But there should be a way to get it to die and return the sql error message when you run a query.

[ben1981]

Fantastic - it now works - thanks for your quick reply and solution!!

[ben1981]

I think there is a way to get a MYSQL error report but I am so new to PHP that I dont know how to do it.

 

must have been my code which was wrong as editing the data fixed the problem

[papaface]

In the future try adding

error_reporting(E_ALL);
ini_set('display_errors', '1');

to the top of your pages inside the <?php and see if you get any errors first.

[ben1981]

thanks i have added those lines to my code.

 

well now i can add a record. i need to find out how to edit/delete existing records.

 

in my database will be the content of the website. things like latest news, department pages, and so on. so the customer can edit the site themselves.

 

would it be easy for the customer to upload word docs to the site?  and images?

 

 

[ben1981]

hi this code, shows me the last 5 records from my database listed with the title of each

 

<b> WHAT'S NEW: </b><br>
<?php
// Require the database class
require_once('includes/DbConnector.php');

// Create an object (instance) of the DbConnector
$connector = new DbConnector();

// Execute the query to retrieve articles
$result = $connector->query('SELECT ID,title FROM cmsarticles ORDER BY ID DESC LIMIT 0,5');

// Get an array containing the results.
// Loop for each item in that array
while ($row = $connector->fetchArray($result)){

echo '<p> <a href="viewArticle.php?id='.$row['ID'].'">';
echo $row['title'];
echo '</a> </p>';

}
?>

 

how can i change it so it lists every database record?

[artacus]

Remove "LIMIT 0,5" from your query.

[ben1981]

thanks artacus as you can probably tell i am new to php.. but finding it very interesting