Expert Help Pls

i have been trying to find an small sample to use a small PHP code and just update 1 field, coudl any of you pls postit?

just run small SQL

UPDATE sometable FIELD01=‘1’ where NAME=‘ZZ’

btu cant find a porper sample with simepl code like htis.

[quote=“pemtium”]i have been trying to find an small sample to use a small PHP code and just update 1 field, coudl any of you pls postit?

just run small SQL

UPDATE sometable FIELD01=‘1’ where NAME=‘ZZ’

btu cant find a porper sample with simepl code like htis.[/quote]

If you’re doing it in freepbx, you can use:

[code:1]
sql(“UPDATE foo SET FIELD01=‘1’ where NAME=‘ZZ’”);
[/code:1]

…as the connection to the database is already done for you. Otherwise, there’s plenty of php/mysql documentation on the net.

–Rob

[quote=“xrobau”][quote=“pemtium”]i have been trying to find an small sample to use a small PHP code and just update 1 field, coudl any of you pls postit?

just run small SQL

UPDATE sometable FIELD01=‘1’ where NAME=‘ZZ’

btu cant find a porper sample with simepl code like htis.[/quote]

If you’re doing it in freepbx, you can use:

[code:1]
sql(“UPDATE foo SET FIELD01=‘1’ where NAME=‘ZZ’”);
[/code:1]

…as the connection to the database is already done for you. Otherwise, there’s plenty of php/mysql documentation on the net.

–Rob[/quote]

Thank xrobau.

if i ask you to do the same using Php what you will do?
Do i have to open the connection too?

Can anyone replicate the same using a php program?

Thank for your help