Display content from database on HTML page via Ajax and PHP

Question

I'd like to post some content from a database on an html page. I'm not sure what the best way to do this is but my guess would be something that resembles the code below. Please let me know if there is a better way.

HTML:

$(document).ready(function(){
     $.ajax({
        type : "POST",
        url : 'tablepageload.php',
        data : 'test',
        success: function(data) {
            $('#echobox').html(data);
        }
     });
});

PHP:

if (isset($_POST['test'])) {
    $sendtable = "SELECT `timein` FROM `timestamp` WHERE id='" . $latestrow . "' LIMIT 1"; 
    $result = mysqli_query($link, $sendtable);
    $row = mysqli_fetch_array($result);

    echo $row['timein'];
};

This is a 5th grader question but any ways the flow would be to "Send the data to the server(PHP) via Ajax, PHP gets the required Data via MySQL query and process it further(If Required) and send the response back." It is simple enough but you have to explore more. — Osama Yawar Khawaja
– Osama Yawar Khawaja, Commented Nov 23, 2015 at 20:18
@Osama So how does my code fail to accomplish that? Your response wasn't very helpful. — kybak
– kybak, Commented Nov 23, 2015 at 20:21
Did you try to print_r($_POST)? What do you get when you do that because i believe you are not even getting anything at server side. — Osama Yawar Khawaja
– Osama Yawar Khawaja, Commented Nov 23, 2015 at 20:23
Is the personal attack on his question necessary? Just answer it or don't — Chris Trudeau
– Chris Trudeau, Commented Nov 23, 2015 at 20:27

JParkinson1991 · Accepted Answer · 2015-11-23 20:26:51Z

Your workflow seems fine to me.

In essence, as already mentioned the work flow for what you're trying to achieve is:

Make request (your initial ajax call)
Process the request send response (your php script)
Handle the reponse (your 'success' callback)

Looking at your code i have some pointers.

Considering using the jquery .load() function. If your ajax call is to do nothing more than populate a div you may aswell use this.

In terms of your sql query, i would recommend looking at:

Prepared statements (http://php.net/manual/en/mysqli.quickstart.prepared-statements.php)
PDO (http://php.net/manual/en/book.pdo.php)
And if you want your latest row, order by 'id' DESC LIMIT 1.

Hope this proves helpful

EDIT: Also noticed a problem with your ajax call:

$.ajax({
    type : "POST",
    url : 'tablepageload.php',
    //data : 'test',
    //$_POST['test'] = "some_value",
    //$_POST['another'] = "test"
    data : {test:'some_value', another:'test'}, 
    success: function(data) {
             $('#echobox').html(data);
             }
 });

Collectives™ on Stack Overflow

Display content from database on HTML page via Ajax and PHP

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related