How to query using a variable

#1 · September 26, 2021, 7:21 am

Hi everybody

I need to query my db and I need to filter it (WHERE) by a variable from my application [mytextfield]

As the string below the query is not filtering because of variable (i think is not the right way to write the variable)

$sqlQuerys[15]="SELECT materia_prima FROM materia_prima_fm WHERE id_formula_maestra = [mytextfield]";

Any help on how to right format the query?

Thanks

#2 · September 26, 2021, 9:51 am

@xojo if the SQL is in the PHP config file then you need to use a ? in place of the variables. Then in the neophpexecutesql you pass the variables as the parameters separated by a :

Regards

Andy

#3 · September 26, 2021, 11:34 am

$sqlQuerys[15]="SELECT materia_prima FROM materia_prima_fm WHERE id_formula_maestra = ?";

@xojo please take a look a the database video tutorials series.

javadrajabihakami has reacted to this post.

How to query using a variable - Forum

How to query using a variable