PHP variables in mysql queries

Question

Hi.

Im using mysql with PHP, I was just wondering if this query,

$query = "UPDATE tblName SET field='$fieldValue' WHERE field2='$fieldValue2'"

would cause an Out of Memory Error in mysql. Will this query,

$query = "UPDATE tblName SET field='".$fieldValue."' WHERE field2='".$fieldValue2."'"

consume less memory than the previous one?

Im getting this error: Out of memory (Needed nnnnnnn bytes) and its pointing to the query with the same format as the first one above.

Thanks.

Answer 1

As far as MySQL is concerned, the two strings are the same.

How big are these values in $fieldValue and $fieldValue2? If they're multiple megabytes, attempting to allocate space for the $query variable may be exceeding your PHP memory limit - perhaps you need to up it if you're working with large data.

Answer 2

Both strings are the same, one uses inline interpolation, the other uses string concatenation. I think your problem has to be found somewhere else.

Answer 3

If you code like that, this will happen. Don´t code like that, please.

Answer 4

Well the out of memory error is probably caused by the fact that the values in those variables are simply too long. If that is the case you should look into prepared statements as those can handle MUCH bigger values than simple queries.