I am trying to insert a row into a mysql table within the Zend framework. When I use (example A) the script just dies with no errors when the query is larger than certain size. (example B) will insert the data no issue with any size query. Seems like anything over 2.6K will cause the issue. Any ideas to allow larger queries(Im storing XML)??
Thanks,
Roger
Example A:
$db->beginTransaction();
try {
// Attempt to execute one or more queries:
$db->query($statement);
$db->commit();
}
// Roll Back Changes If Errors
catch (Exception $e) {
$db->rollBack();
// * FIX * SEND TO ERROR LOG NOT SCREEN
echo $e->getMessage();
}
Example B:
$db = mysql_connect("localhost","root","*****");
mysql_select_db("****",$db);
mysql_query($statement);