few day's ago i ve been writing application web based for TORTOISE..
since PHP 5 support to use stored procedure in mysql, i try to use it, using mysqli (mysql improved) library function. but i have some problem in development process..
i want that my php script can show page like google pagging, in this mysql query code i ve used stored procedure with dynamic query, for accept WHERE statement for filter name, and of course use LIMIT, all this variable has sent from parameter in stored procedure.
In PHP script like usualy for accessing store procedure using prepared statement. This method it's little different for use query select standart. For sent parameter variable into stored procedure using mysqli_bind_param function and get varible from mysql using mysqli_bind_result.
So when execute this script firefox has taken 5-6 second.., and show error windows.. after that page just blank white. Try many time still same. For information i use apache 2.2.4 and php 5.2.1 with mysql 5.0.37,
after trace one-one i know it cause by mysqli_bind_result, actualy i don't know how work this function, but i guess looks like this function calling some function and never stop..., coz apache has write error log. That say's
"Error in my_thread_global_end(): 252 threads didn't exit" and finally this process has exit with force.
After search in google i don't never get good solution. coz i use php ver 5.2.1 i think i need upgrade the lates version 5.2.5, but i still have the same problem. i don't know how fix this problem in my php script, at least i must change my query sql for not using stored procedure.
and after change sql query it's work now, but i still need brainstorming to display arabic character in web...
later i will post again.. with solution in mysql stored procedure if i found this solution.... :)
GBU
since PHP 5 support to use stored procedure in mysql, i try to use it, using mysqli (mysql improved) library function. but i have some problem in development process..
i want that my php script can show page like google pagging, in this mysql query code i ve used stored procedure with dynamic query, for accept WHERE statement for filter name, and of course use LIMIT, all this variable has sent from parameter in stored procedure.
In PHP script like usualy for accessing store procedure using prepared statement. This method it's little different for use query select standart. For sent parameter variable into stored procedure using mysqli_bind_param function and get varible from mysql using mysqli_bind_result.
So when execute this script firefox has taken 5-6 second.., and show error windows.. after that page just blank white. Try many time still same. For information i use apache 2.2.4 and php 5.2.1 with mysql 5.0.37,
after trace one-one i know it cause by mysqli_bind_result, actualy i don't know how work this function, but i guess looks like this function calling some function and never stop..., coz apache has write error log. That say's
"Error in my_thread_global_end(): 252 threads didn't exit" and finally this process has exit with force.
After search in google i don't never get good solution. coz i use php ver 5.2.1 i think i need upgrade the lates version 5.2.5, but i still have the same problem. i don't know how fix this problem in my php script, at least i must change my query sql for not using stored procedure.
and after change sql query it's work now, but i still need brainstorming to display arabic character in web...
later i will post again.. with solution in mysql stored procedure if i found this solution.... :)
GBU
i want that my php script can show page like google pagging, in this mysql query code i ve used stored procedure with dynamic query, for accept WHERE statement for filter name, and of course use LIMIT, all this variable has sent from parameter in stored procedure. Biro Jasa Perijinan jogja
ReplyDelete