บทความ > PHP

[PHP] Form POST many varaible more 1000 fields Turn Back

เมื่อ 2018-07-06 15:32:38

Set config php.ini

max_input_vars = 1000

*Default at 1000 fields

 

If you want to define many IN condition with sql command  (MySQL)

If you want to POST these values (very many fields) to the sql statement via IN condition.
You need to make sure that this configuration is supported. (my.ini)
 
max_allowed_packet
You can check by commnd
SELECT @@max_allowed_packet
More for group query.
If you want to group of many rows at once query.
You can use the GROUP_CONCAT command with separate by comma.
But make sure the default length are enough.
 
SELECT @@group_concat_max_len
 
You can increase more 1024 char.
 
Enjoy :)
 
 
 
Turn Back

Automotive ดูทั้งหมด

IT Update ดูทั้งหมด