javascript

[slimjim]

Ok does anyone know how to update a table using javascript ?
Here is what I have so far.

<SCRIPT LANGUAGE="JavaScript">
function urlreport() {

if(confirm("Yes ? - Press OK.  Or No ? - Press Cancel")) {
}
else {
		$query="update url set status='0' where id='$urlid'";
		mysql_query($query) or die( "ERROR: " . mysql_error() . "\n");
}
}
</SCRIPT>

Only if someone clicks cancel then i want it to update database.

[planetsim]

use a redirect to that page. If required redirect back other than that Javascript cant do it from within the language. However there is a library that can help make it feel seemless not sure on the link though.

[slimjim]

I think i can get it to work by passing variables thru url to another page. But it seems people can change cariables in url and update differnet rows.
IS ther a way to pass variables to other page without using url ?

[planetsim]

You can look for the XHTTPServer project not sure on exact name however I believe it has been mentioned before Javascript Library to actually to it behind the scenes. However this library wont work on all browsers as well javascript can be turned off.

What are you trying to achieve?

[slimjim]

Well after fighting this all dang day, I am going to work on this another day. Drove me nuts.
Thank You for helping me out. I always chose to do things that seem tough.

[Roger_Ramjet]

Strange mixture of javascript and php!??!
Javascript is client-side and cannot update your db. PHP is server-side and cannot be scripted on the client.

Use a Form and Post the data to your php update script, Post does not display the data in the url, so it looks much neater and is harder for the user to tamper with the data.

If you want a confirmation before sending then use 'onsubmit="return urlreport();"' in the form tag to call your javascript function and return true or false. False will stop the post.