insert // url string // how do i do it? - PHPBuilder Forums

insert // url string // how do i do it?

cyber_d

Hi there,

can anyone help i seem to be a little stuck.

i wish to use a url eg) http://url/insert.php?insert_text=xxxxxxx
to update an entry in my MySQL dbase WHERE nws_id = 2.

ie) whatever the value in the string // insert_text=xxxxxx will be entered into my table

any suggestions?

thnks a lot
Dave (za)
"former asp bunny"

Kudose

please dont cross post threads

jdwmk

The xxxxxx value will be held in the $_GET array provided to insert.php, so just use

$insVal = $_GET[insert_text];

then something like :
mysql_query("UPDATE tablename SET fieldname = '$insVal' where nws_id = 2");

But, be warned, you could be opening yourself up to sql injection attacks if you do not validate the insert_text value before. Do a search for htmlentities on php.net.

This should get you started anywayz.

Jeff

Kudose

http://www.phpbuilder.com/board/showthread.php?t=10312464

cyber_d

my bad ...