Re: [PHP-DB] Insert query error

2011-08-06 Thread Gavin Chalkley 

Chris,

Why not escape, and extract the data prior to Insert string?

On 06/08/2011 05:41, Chris Stinemetz wrote:

I am getting the following error trying to run the below query. Any
suggestions on what I am doing wrong?

Thank you,

Something went wrong while inserting your store visitCannot add or
update a child row: a foreign key constraint fails (`store`.`posts`,
CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`post_store`) REFERENCES
`stores` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE)

$sql = INSERT INTO
posts(market, type, post_store, post_tptest, post_content, post_by, post_date)
VALUES(' . mysql_real_escape_string($_POST['market']) . ',
' . mysql_real_escape_string($_POST['type']) . ',
' . mysql_real_escape_string($_POST['post_store']) . ',   
  
' . sha1($_POST['post_tptest']) . ',
' . mysql_real_escape_string($_POST['post_content']) . ',
   . $_SESSION['user_id'] . ,
  NOW());



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] RE: 47951 by: Chris Stinemetz

2011-08-06 Thread Geoffrey Pitman 
I hope this isn't condescending, but you have a foreign key constraint that
is failing. I would probably echo the output of $_POST['post_store'] to see
what value, if any, is being written. If the output seems proper, I'd check
your other table and make sure that the data exists in that table. And,
finally if all of that checks out, I'd check your SQL and see if you have
appropriate data types, etc.

I hope that may help.

Geoff

From: Chris Stinemetz chrisstinem...@gmail.com
To: php-db@lists.php.net
Date: Fri, 5 Aug 2011 23:41:06 -0500
Subject: Insert query error
I am getting the following error trying to run the below query. Any
suggestions on what I am doing wrong?

Thank you,

Something went wrong while inserting your store visitCannot add or
update a child row: a foreign key constraint fails (`store`.`posts`,
CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`post_store`) REFERENCES
`stores` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE)

$sql = INSERT INTO
posts(market, type, post_store, post_tptest, post_content, post_by,
post_date)
VALUES(' . mysql_real_escape_string($_
POST['market']) . ',
' . mysql_real_escape_string($_POST['type']) . ',
' . mysql_real_escape_string($_POST['post_store']) . ',
' . sha1($_POST['post_tptest']) . ',
' . mysql_real_escape_string($_POST['post_content']) . ',
  . $_SESSION['user_id'] . ,
NOW());

Re: [PHP-DB] Insert query error

2011-08-06 Thread Amit Tandon 
Chris

The error is indicated by the keywords a foreign key constraint fails, This
implies that some value in store table is missing which u are trying to
insert in posts. So check for the value u are trying to input in post
table. U have to check for the values of post_store field from the input
list in store table's store_id field

regds
amit

The difference between fiction and reality? Fiction has to make sense.


On Sat, Aug 6, 2011 at 10:11 AM, Chris Stinemetz
chrisstinem...@gmail.comwrote:

 I am getting the following error trying to run the below query. Any
 suggestions on what I am doing wrong?

 Thank you,

 Something went wrong while inserting your store visitCannot add or
 update a child row: a foreign key constraint fails (`store`.`posts`,
 CONSTRAINT `posts_ibfk_1` FOREIGN KEY (`post_store`) REFERENCES
 `stores` (`store_id`) ON DELETE CASCADE ON UPDATE CASCADE)

 $sql = INSERT INTO
 posts(market, type, post_store, post_tptest, post_content, post_by,
 post_date)
 VALUES(' . mysql_real_escape_string($_POST['market']) . ',
 ' . mysql_real_escape_string($_POST['type']) . ',
 ' . mysql_real_escape_string($_POST['post_store']) . ',
 ' . sha1($_POST['post_tptest']) . ',
 ' . mysql_real_escape_string($_POST['post_content']) . ',
   . $_SESSION['user_id'] . ,
 NOW());

 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php