PHP script reloading

Question

I have a file which is of php type. And I have a combination of HTML elements, javascript functions and some PHP scripts as well. I want to rerun the php script say some part of the script again and again. lets take this example:

<html>
    <?php
        $connection = mysql_connect('localhost','root','root');
        $db = mysql_select_db('messenger');
        if ($db == null)
        {
            echo "hello";
        }

        $messagecheck = "select * from Messages where destination = '$user' && status = 'ACTIVE'";
        $result = mysql_query($messagecheck);
        $no_rows = mysql_num_rows($result);
        ............
    ?>
    <body>
        ........
        <form>
            <input type="submit">
            .......
        </form>
    </body>
</html>

I want to run the above php script continuously for every 1 min from the same file. When I make use of location.reload() I find that complete document gets reloaded. I just want the affect the part of the page which php script accesses and not the whole doc.

How can I do that? Please help.

off-topic, but please be aware that the mysql_xx() functions are considered obsolete and are being deprecated. It is recommended to switch to the mysqli_xx() functions or the PDO library, both of which are more secure, more up-to-date, and have more functionality. See also stackoverflow.com/questions/12859942/… — SDC
– SDC, Commented Nov 13, 2012 at 11:23
I didn't know that. I m a newbie to php, mysql stuff. Thanks anyways man... — m4n1c
– m4n1c, Commented Nov 13, 2012 at 11:27
no worries; I guess it's good to find out now when you're just getting started rather than later when you've got a whole stack of code already written. The old mysql_xx() funcs have been around forever, so there are a ton of old tutorials that use them which haven't been updated. But it's good to learn from tutorials that teach current best-practices. You might like to see phptherightway.com - worth a read, although it can be a bit heavy going in places for a complete newbie. — SDC
– SDC, Commented Nov 13, 2012 at 11:49

blue112 · Accepted Answer · 2012-11-13 11:03:03Z

4

You can't do that out of the box, since php is called when the page is loaded.

You should take a look at Ajax or frameworks like JQuery, that embed Ajax.

answered Nov 13, 2012 at 11:03

blue112

57.3k3 gold badges52 silver badges58 bronze badges

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

Comments

Abu Romaïssae · Accepted Answer · 2012-11-13 11:08:53Z

1

As previously said by blue112 you need to use Ajax in order to get what you want.

If I did understand well what you need, a simple solution is using an iframe where you point to a file with only the php code you want to execute, and reload it every time you want.

I hope this helps

answered Nov 13, 2012 at 11:08

Abu Romaïssae

3,8915 gold badges40 silver badges60 bronze badges

Collectives™ on Stack Overflow

PHP script reloading

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related