PHWinfo - Afficher un message - INSERT query runs in mysql client, but not in PHP.

26/04/2006, 21h32

Bill Karwin wrote:
> Often, mismatched quotes and
> other errors introduced by the variables become obvious if you look at
> the SQL that is actually executed.

For example, can the value of any of these variables contain
single-quotes or apostrophe characters?

$title = $_POST['title'];
$intro = $_POST['intro'];
$full = $_POST['full];

Read http://www.php.net/manual/en/functio...ape-string.php
for an explanation, and examples of fixing the problem.

Regards,
Bill K.

26/04/2006, 21h32	#5
Bill Karwin Messages: n/a Hébergeur:	Re: INSERT query runs in mysql client, but not in PHP. Bill Karwin wrote: > Often, mismatched quotes and > other errors introduced by the variables become obvious if you look at > the SQL that is actually executed. For example, can the value of any of these variables contain single-quotes or apostrophe characters? $title = $_POST['title']; $intro = $_POST['intro']; $full = $_POST['full]; Read http://www.php.net/manual/en/functio...ape-string.php for an explanation, and examples of fixing the problem. Regards, Bill K.