- Sat Jun 23, 2018 3:32 am
#814889
Hi,
I've written a trigger with the following content:
<?php
$query = 'UPDATE `my_table` SET `search`=\'a:2:{i:0;a:6:{s:5:"field";s:10:"APP_NUMBER";s:5:"label";s:10:"APP NUMBER";s:9:"data_type";s:4:"Text";s:8:"required";s:0:"";s:8:"operator";s:2:"EQ";s:4:"type";s:3:"AND";}i:1;a:6:{s:5:"field";s:9:"APP_TITLE";s:5:"label";s:9:"APP TITLE";s:9:"data_type";s:4:"Text";s:8:"required";s:0:"";s:8:"operator";s:2:"EQ";s:4:"type";s:3:"AND";}}\' WHERE `id`=\'1\';';
executeQuery($query);
?>
When I run it, my apache server stops!
I check executeQuery function and I found the problem is for PHPSQLParser class.
What is the problem?!
Thanks
I've written a trigger with the following content:
<?php
$query = 'UPDATE `my_table` SET `search`=\'a:2:{i:0;a:6:{s:5:"field";s:10:"APP_NUMBER";s:5:"label";s:10:"APP NUMBER";s:9:"data_type";s:4:"Text";s:8:"required";s:0:"";s:8:"operator";s:2:"EQ";s:4:"type";s:3:"AND";}i:1;a:6:{s:5:"field";s:9:"APP_TITLE";s:5:"label";s:9:"APP TITLE";s:9:"data_type";s:4:"Text";s:8:"required";s:0:"";s:8:"operator";s:2:"EQ";s:4:"type";s:3:"AND";}}\' WHERE `id`=\'1\';';
executeQuery($query);
?>
When I run it, my apache server stops!
I check executeQuery function and I found the problem is for PHPSQLParser class.
What is the problem?!
Thanks