PHP inside JS - Not working 4 me - Any help much appreciated

[Nephi]

I need to update mysql after an onclick without leaving the page and am using this JS, php code combination, believing it should work. The queries run perfectly if independantly applied to mysql.

[script language="javas cript"]

function delimg() {

[PHP]

$updtspec = "update tspec set img='' where object ='$object' and suffix='$suffix '";
$upd1= mysql_query($up dtspec);
$updtimg = "update timg set img='' where object ='$object' and suffix='$suffix '";
$upd1= mysql_query($up dtimg);

[/PHP]

}
[/script]

Awesome forum !

[Atli]

If Im understanding this correctly, your are putting php code inside Javascript functions?

If so you must understand, php is server side code. It is executed server side and what is returend to the browser is, in your case, nothing. So your Javascript function is most likely empty when it reaches the browser.

To do this in PHP you will have to refresh the page.

Best solution is probbly to use AJAX, tho I have no experience with that.

[Nephi]

Thanks, I'm still hazy on this. My page is suffixed .php and has JS tags for JS.

Are you saying that the PHP (which is server-side) won't be execute?

It matters not if I get something back, only is the mysql is updated.

If Im understanding this correctly, your are putting php code inside Javascript functions?

If so you must understand, php is server side code. It is executed server side and what is returend to the browser is, in your case, nothing. So your Javascript function is most likely empty when it reaches the browser.

To do this in PHP you will have to refresh the page.

Best solution is probbly to use AJAX, tho I have no experience with that.

[Atli]

Anything within <?php ... ?> tags will be executed server side, and the results, if any, will be sent to the client browser.
Even tho the page is .php the only thing your browser gets is HTML tags.

So when the page is loaded, you cant execute php scripts without reloading the page.

[Nephi]

Much obliged,

Back to the drawing board. :) after a swim. Stinking hot in Johannesburg, South Africa.

Anything within <?php ... ?> tags will be executed server side, and the results, if any, will be sent to the client browser.
Even tho the page is .php the only thing your browser gets is HTML tags.

So when the page is loaded, you cant execute php scripts without reloading the page.