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

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

[PHP-DB] Insert query error

2011-08-05 Thread Chris Stinemetz 
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