Display image in server side datatable in php/mysqli and ajax

Question

I am trying with server side script datatable where I need to add images inside the table. The image path is stored inside the database. I need to display the images in my page. How can I add images in the page. Here is the code.I want the images to be displayed using mysqli and ajax.

<?php
    //include connection file 
    include_once("connection.php");

    // initilize all variable
    $params = $columns = $totalRecords = $data = array();

    $params = $_REQUEST;

    //define index of column
    $columns = array( 
        0 =>'id',
        1 =>'name', 
        2=>'images',
        3 => 'year',
        4 => 'rank'
    );

    $where = $sqlTot = $sqlRec = "";

    // check search value exist
    if( !empty($params['search']['value']) ) {   
        $where .=" WHERE ";
        $where .=" (name LIKE '".$params['search']['value']."%' ";    
        $where .=" OR year LIKE '".$params['search']['value']."%' ";
        $where .=" OR id LIKE '".$params['search']['value']."%' ";
        $where .=" OR rank LIKE '".$params['search']['value']."%' )";
    }

    // getting total number records without any search
    $sql = "SELECT * FROM `search` ";
    $sqlTot .= $sql;
    $sqlRec .= $sql;
    //concatenate search sql if value exist
    if(isset($where) && $where != '') {

        $sqlTot .= $where;
        $sqlRec .= $where;
    }


    $sqlRec .=  " ORDER BY ". $columns[$params['order'][0]['column']]."   ".$params['order'][0]['dir']."  LIMIT ".$params['start']." ,".$params['length']." ";

    $queryTot = mysqli_query($conn, $sqlTot) or die("database error:". mysqli_error($conn));


    $totalRecords = mysqli_num_rows($queryTot);

    $queryRecords = mysqli_query($conn, $sqlRec) or die("error to fetch rank holders");

    //iterate on results row and create new index array of data
    while( $row = mysqli_fetch_row($queryRecords) ) { 
    $data[] = $row;
$data[] = "<img src =images/".$data[2].">";


    $json_data = array(
            "draw"            => intval( $params['draw'] ),   
            "recordsTotal"    => intval( $totalRecords ),  
            "recordsFiltered" => intval($totalRecords),
            "data"            => $data   // total data array
            );

    echo json_encode($json_data);  // send data as json format
?>

less fo a json/jquery question, php/mysql part is answered here: http://stackoverflow.com/questions/1636877/how-can-i-store-and-retrieve-images-from-a-mysql-database-using-php — Najzero, Jun 17 '16 at 06:12

score -1 · Answer 1 · answered Jun 17 '16 at 06:29

-1

Because you store the pic in the DB, you can send in ajax the base64 encoding of the pic you want to display.

answered Jun 17 '16 at 06:29

Killan

321
1
6
14

http://stackoverflow.com/questions/3967515/how-to-convert-image-to-base64-encoding – Killan Jun 17 '16 at 06:33

Display image in server side datatable in php/mysqli and ajax

1 Answers1