PHP/MySql insert

Expand Post »

Hey,

I am having trouble with some code I am using. I have used this same code on a different site but it doesnt seem to work now on this site.
I am trying to insert something into my database. however I keep getting this error:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc, story, cost, rrp, wt, size, top, fashion, active, lifestyle, sale) VALUES ' at line 1

My Code is below (sorry there is a bit of it, but I don't know what part is giving me issues, as line 1 isn't reffering to my code?)

PHP Syntax (Toggle Plain Text)
 
	$OK = false;
	$done = false;
 
if (array_key_exists('publish', $_POST)) {
 
	try {
		$id = NULL;
		$stock = $_POST['stock'];
		$brand = $_POST['brand'];
		$name = $_POST['name'];
		$code = $_POST['code'];
		$desc = $_POST['desc'];
		$story = $_POST['story'];
		$rrp = $_POST['rrp'];
		$cost = $_POST['cost'];
		$weight = $_POST['wt'];
		$size = $_POST['size'];
		$top = $_POST['top'];
		$fashion = $_POST['fashion'];
		$active = $_POST['active'];
		$lifestyle = $_POST['lifestyle'];
		$sale = $_POST['sale'];
 
		/*** connect to db ***/
		$conn = dbConnect('admin');
		/*** set the error mode ***/
		$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
 
		/*** our sql query ***/
		$done = $conn->prepare("INSERT INTO product_info (id, stock, brand, name, code, desc, story, cost, rrp, wt, size, top, fashion, active, lifestyle, sale) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
 
		/*** bind the params ***/
		$done->bindParam(1, $id);
		$done->bindParam(2, $stock);
		$done->bindParam(3, $brand);
		$done->bindParam(4, $name);
		$done->bindParam(5, $code);
		$done->bindParam(6, $desc);
		$done->bindParam(7, $story);
		$done->bindParam(8, $rrp);
		$done->bindParam(9, $cost);
		$done->bindParam(10, $weight);
		$done->bindParam(11, $size);
		$done->bindParam(12, $top);
		$done->bindParam(13, $fashion);
		$done->bindParam(14, $active);
		$done->bindParam(15, $lifestyle);
		$done->bindParam(16, $sale);
 
		/*** execute the query ***/
		$done->execute();
	}
    catch(Exception $e) {
        echo '<h4>'.$e->getMessage().'</h4>';
    }
}
	if ($done) {
		header ("refresh:10;url=index.php");
		echo 'Sending...........................<br />';	
		exit;
	}
	// display error message if query fails
	if (isset($update) && !$OK && !$done) {
//			$message[] = "There was a problem updating the team, please try again or contact Q Web Development";
			$error = $update->errorInfo();
			if (isset($error[2])) {
				echo $error[2];
			}
	}
	$OK = false;
	$done = false;

if (array_key_exists('publish', $_POST)) {

	try {
		$id = NULL;
		$stock = $_POST['stock'];
		$brand = $_POST['brand'];
		$name = $_POST['name'];
		$code = $_POST['code'];
		$desc = $_POST['desc'];
		$story = $_POST['story'];
		$rrp = $_POST['rrp'];
		$cost = $_POST['cost'];
		$weight = $_POST['wt'];
		$size = $_POST['size'];
		$top = $_POST['top'];
		$fashion = $_POST['fashion'];
		$active = $_POST['active'];
		$lifestyle = $_POST['lifestyle'];
		$sale = $_POST['sale'];
		
		/*** connect to db ***/
		$conn = dbConnect('admin');
		/*** set the error mode ***/
		$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

		/*** our sql query ***/
		$done = $conn->prepare("INSERT INTO product_info (id, stock, brand, name, code, desc, story, cost, rrp, wt, size, top, fashion, active, lifestyle, sale) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
 
		/*** bind the params ***/
		$done->bindParam(1, $id);
		$done->bindParam(2, $stock);
		$done->bindParam(3, $brand);
		$done->bindParam(4, $name);
		$done->bindParam(5, $code);
		$done->bindParam(6, $desc);
		$done->bindParam(7, $story);
		$done->bindParam(8, $rrp);
		$done->bindParam(9, $cost);
		$done->bindParam(10, $weight);
		$done->bindParam(11, $size);
		$done->bindParam(12, $top);
		$done->bindParam(13, $fashion);
		$done->bindParam(14, $active);
		$done->bindParam(15, $lifestyle);
		$done->bindParam(16, $sale);

		/*** execute the query ***/
		$done->execute();
	}
    catch(Exception $e) {
        echo '<h4>'.$e->getMessage().'</h4>';
    }
}
	if ($done) {
		header ("refresh:10;url=index.php");
		echo 'Sending...........................<br />';	
		exit;
	}
	// display error message if query fails
	if (isset($update) && !$OK && !$done) {
//			$message[] = "There was a problem updating the team, please try again or contact Q Web Development";
			$error = $update->errorInfo();
			if (isset($error[2])) {
				echo $error[2];
			}
	}

If your able to point out what I've done wrong, or how I can fix it, I would greatly appreciate it.

Cheers,

Qwaz

QWaz

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

62 posts
since Apr 2010

Permalink

Jun 25th, 2010

Re: PHP/MySql insert

Try replacing line 31 with the following.

PHP Syntax (Toggle Plain Text)
$done = $conn->prepare("INSERT INTO product_info (id, stock, brand, name, code, desc, story, cost, rrp, wt, size, top, fashion, active, lifestyle, sale) VALUES ('?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?')");
$done = $conn->prepare("INSERT INTO product_info (id, stock, brand, name, code, desc, story, cost, rrp, wt, size, top, fashion, active, lifestyle, sale) VALUES ('?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?')");

That is assuming all of the columns are strings. If any of the column types are integers then replace the value of the column with the number 0 and no quotes for integer columns. (By the way integer==number).

cwarn23

Sponsor

Featured Poster

Reputation Points: 410

Solved Threads: 258

Occupation: Genius

Offline

3,003 posts
since Sep 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Multiple Columns in PHP results

Next Thread in PHP Forum Timeline: exchange rates

DaniWeb Message

Cancel Changes

User Name
Password