带有ajax的mysql [关闭]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

                </div>
            </div>
        </div>
                <hr class="my12 outline-none baw0 bb bc-powder-2">
            <div class="grid fw-nowrap fc-black-600">
                    <div class="grid--cell mr8">
                        <svg aria-hidden="true" class="svg-icon iconLightbulb" width="18" height="18" viewbox="0 0 18 18"><path d="M9.5.5a.5.5 0 0 0-1 0v.25a.5.5 0 0 0 1 0V.5zm5.6 2.1a.5.5 0 0 0-.7-.7l-.25.25a.5.5 0 0 0 .7.7l.25-.25zM1 7.5c0-.28.22-.5.5-.5H2a.5.5 0 0 1 0 1h-.5a.5.5 0 0 1-.5-.5zm14.5 0c0-.28.22-.5.5-.5h.5a.5.5 0 0 1 0 1H16a.5.5 0 0 1-.5-.5zM2.9 1.9c.2-.2.5-.2.7 0l.25.25a.5.5 0 1 1-.7.7L2.9 2.6a.5.5 0 0 1 0-.7z" fill-opacity=".4"></path><path opacity=".4" d="M7 16h4v1a1 1 0 0 1-1 1H8a1 1 0 0 1-1-1v-1z" fill="#3F3F3F"></path><path d="M15 8a6 6 0 0 1-3.5 5.46V14a1 1 0 0 1-1 1h-3a1 1 0 0 1-1-1v-.54A6 6 0 1 1 15 8zm-4.15-3.85a.5.5 0 0 0-.7.7l2 2a.5.5 0 0 0 .7-.7l-2-2z" fill="#FFC166"></path></svg>
                    </div>
                <div class="grid--cell lh-md">
                    <p class="mb0">
                        <b>Want to improve this question?</b> Add details and clarify the problem by <a href="/posts/37599548/edit">editing this post</a>.
                    </p>
                    <p class="mb0 mt6">Closed <span title="2016-06-03 06:26:24Z" class="relativetime">3 years ago</span>.</p>
                </div>
            </div>
    </aside>

Here is my code that I'm using.

ajax

$.ajax({
    type: "GET",
    url: "process.php",
    dataType: "html",
    success: function(data){
        $(".content").html(data);
    }
});

$("#submit").click(function(){
    $.ajax({
        type: "POST",
        url: "post.php",
        dataType: "html",
        success: function(data1){
            $(".content").html(data1);
        }
    });
});

process.php

<?php
$db = mysqli_connect("localhost","root","","webcap");
$query = mysqli_query($db,"SELECT * FROM test");
while($row = mysqli_fetch_assoc($query)){
    echo $row['num'];
}

post.php

<?php
$db = mysqli_connect("localhost","root","","webcap");
$num_query = mysqli_query($db,"SELECT * FROM test");
$num_row = mysqli_fetch_assoc($num_query);
$number = $num_row['num'];

$new_number = $number + 1;
$query2 = mysqli_query($db,"UPDATE test SET num='$new_number'");
echo $new_number;

The idea is when i click button it add plus one to my database and i can see it without refreshing but others don't.

I want that everyone in my website see it in real time without refreshing

</div>

Answer 1

If your ajax is only called in the javascript once, it won't update without refreshing. You need to put the ajax into setInterval and pick a refresh rate (ms):

Interval = setInterval(function () {
$.ajax({
    type: "GET",
    url: "process.php",
    dataType: "html",
    success: function(data){
        $(".content").html(data);
    }
});
}, 3000);