Problem with neophp mysql query

#1 · January 21, 2025, 4:17 pm

Hi,

I make an application and notice that when we pass variables with neoPhpExecSql there is limitation to 10 variables on one query if you try to add more the query don't work .I solve this problem when split on 2 queries so now is ok.

Now again I can not make queries and I want to ask you if there is any limitation on how many queries (sql alias) we can have?

I have 19 queries and the last is not working

//Load Service Id
$sqlAlias[19]="loadserviceid";
$sqlQuerys[19]="SELECT * FROM `services` WHERE `id`=?";
$sqlMaxUserLevel[19]=-1;

the neoPhpExecSql is

neoPhpExecSql "db1" "loadserviceid" "[serviceid]" "loadserviceid"

and loadserviceid routine is

CreateEmptyObject [miobj]
SetVar [miobj] [resp]
ArrayLen [miobj] [totalRows]

SetVar [servicestatus11] [miobj(0)('status')]
SetVar [servicenextdate11] [miobj(0)('next_service_date')]
SetVar [servicearrangedate11] [miobj(0)('arrange_service_date')]
SetVar [servicearrangetime11] [miobj(0)('arrange_service_time')]
SetVar [servicenotes11] [miobj(0)('notes')]
SetVar [serviceprice11] [miobj(0)('price')]

Uploaded files:

You need to login to have access to uploads.

#2 · January 21, 2025, 4:32 pm

hi @ecotip

I have an application with 32 queries inside config.php and I do not have any problem

#3 · January 21, 2025, 11:27 pm

@ecotip that's quite strange, there are not hard limits.
Note that php.ini controls the maximum allowed information you can send in a single request, but neoPhp default limits are quite high (200Mb).
No idea why you are facing those limitations.

#4 · January 22, 2025, 8:14 am

I don't know why but when I change object name from miobj to miobj1 everything working.

So the problem is solved.

Thank you for help😁

Problem with neophp mysql query - Forum

Problem with neophp mysql query