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.
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