php onclick

Richardtagger

i want to execute some php on click, now on a basic page that worked fine.

i have this code

$query = mysql_query("UPDATE hits SET hits='23' WHERE id='1'");
$Text = "<a href=$Location onClick='$query'>$Title</a>";

now it does work, however, because i have this query, its naturally executing it. So how can i do it so that the query is executed onclick?

Thanx

Pig

PHP is server side, not client side. onClick events are client side.

Richardtagger

erm WTF? i understand what youre saying but it works its just JS you know..

thorpe

it doesnt work. php is server side. it has no idea what is going on in a users browser.

dalecosp

Originally posted by Richardtagger
i want to execute some php on click, now on a basic page that worked fine.

i have this code
$query = mysql_query("UPDATE hits SET hits='23' WHERE id='1'");
$Text = "<a href=$Location onClick='$query'>$Title</a>";
now it does work, however, because i have this query, its naturally executing it. So how can i do it so that the query is executed onclick?

Thanx [/B]

Make $Location a PHP handler script that submits the query, then click on it?

A trick question, perhaps?

What they are saying is entirely true :bemused:

Richardtagger

im not doubting what they say is true. It did look like it works.

Richardtagger

all i want is for every time some clicks a link, it adds to a counter.

SumitGupta

Hi..

Yes your code is working because when your code execute on web server it send something like

...
<a href=$Location onClick='UPDATE hits SET hits='23' WHERE id='1''>SomeTitle</a>
...

See the Html source in your browser???

Now how it is possible that your client will execute your SQL query from his computer and access your database... if so Hacking is easy for me and u...

Now your problem has solution in some client side scripting just use Java script you can do

1) save temprorly in cookie and than update when form is submitted
2) Make your page refresh on each click updatign value in DB
3)Popup a small window with Update query that closes it self when it finish executing your query....

Hope it will help

Richardtagger

thanx guys i read your comments but i figured it out another way.