Run php code in a script function when the function is called

Question

I have a file named a.php which has a html button with a script function within the same page.Code is given bellow

    //a.php

    <input name="wpost" type="button" value="Publish" onClick="wall_publish()"/>

    <script type="text/javascript">
    function wall_publish(){
    //some codes here..
    //php database part  
        <?php       
            $host = 'localhost';
            $username = 'root';
            $password = '';
            $database = 'uploader';

            $con = mysql_connect($host,$username,$password);
            if (!$con){
               die('Could not connect: ' . mysql_error());
            }
            mysql_select_db($database, $con);   
                mysql_query("UPDATE  image_uploader SET Tag_Count = '$tag_count', Tag_List = '$tag_list' WHERE Image_Link = '$source'");
                mysql_close($con);
        ?>
    }
    </script>

I want to execute the php database part when the user click the "Publish" button(Not when the page is loaded).,
Is there a way to do this?
Just placing this php code inside the script function doesn't work.It is executed when the page is loaded.

:D You are mixing client side (JavaScript) with server side (PHP) languages. — Shef
– Shef, Commented Aug 8, 2011 at 6:17
User ajax....it is used to call server side script using javascript — Sumair Zafar
– Sumair Zafar, Commented Aug 8, 2011 at 9:34

Pelshoff · Accepted Answer · 2011-08-08 06:18:53Z

3

If you want to call PHP code from javascript, the short answer is: you can't. PHP is server side code, and javascript is client side code. They run on different computers.

What you can do, however, is using javascript to send a HTTP request to the server - AJAX. You can then execute the code with the information the javascript has sent with the HTTP request.

Here is a short ajax tutorial from tizag that might get you started:

http://www.tizag.com/ajaxTutorial/

answered Aug 8, 2011 at 6:18

Pelshoff

1,47410 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Daniel Baulig · Accepted Answer · 2011-08-08 06:19:04Z

2

You will have to put the PHP code into a seperate file and make the form action point to that script. Then, when the user clicks the button it will fetch the file and execute the script on the server. If you do not want a page replacement to happen, instead of making a traditional post form, you can run an ajax request upon clicking the button. This will prevent a page replacement.

answered Aug 8, 2011 at 6:19

Daniel Baulig

11.1k7 gold badges47 silver badges45 bronze badges

Comments

Luchian Grigore · Accepted Answer · 2011-08-08 06:19:26Z

1

First you should read some tutorials on PHP and JavaScript, and not just the programming part, but rather the theory part. JavaScript is executed on the client, PHP on the server.

The solution is for JS to make an AJAX request to the server.

answered Aug 8, 2011 at 6:19

Luchian Grigore

260k68 gold badges465 silver badges634 bronze badges

Comments

sjngm · Accepted Answer · 2011-08-09 07:03:05Z

1

<input name="wpost" type="button"id="my_button" value="Publish" />

put this javascript into the head section of your a.php file.

<script type="text/javascript">
$("#my_button").click(function() {
  $.post("page.php");
});
</script>

don't forget to include jquery library file as I jquery is used for the solution.

in page.php u should write:

    <?php       
        $host = 'localhost';
        $username = 'root';
        $password = '';
        $database = 'uploader';

        $con = mysql_connect($host,$username,$password);
        if (!$con){
           die('Could not connect: ' . mysql_error());
        }
        mysql_select_db($database, $con);   
            mysql_query("UPDATE  image_uploader SET Tag_Count = '$tag_count', Tag_List = '$tag_list' WHERE Image_Link = '$source'");
            mysql_close($con);
    ?>

notice you did not assign values for $tag_count, $tag_list.

Don't u want to show any success or failure message after the sql query operation?

edited Aug 9, 2011 at 7:03

sjngm

13k16 gold badges90 silver badges118 bronze badges

answered Aug 8, 2011 at 7:14

sof_user

7192 gold badges7 silver badges18 bronze badges

1 Comment

ARH Over a year ago

how to pass some argument to pagep.php ?

Collectives™ on Stack Overflow

Run php code in a script function when the function is called

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related