File "fetch_records.php"

Full Path: /home/analogde/www/MDPH/01/fetch_records.php
File size: 857 bytes
MIME-type: text/x-php
Charset: utf-8

<?php
// db settings
$hostname = 'analogdepat.mysql.db';
$username = 'analogdepat';
$password = 'Un92pac007';
$database = 'analogdepat';

//$_SESSION['hostdb']= "analogdepat.mysql.db"; 
//$_SESSION['userdb']= "analogdepat"; 
//$_SESSION['passdb']= "Un92pac007";
//$_SESSION['namedb']= "analogdepat";   

// db connection
$con = mysqli_connect($hostname, $username, $password, $database) or die("Error " . mysqli_error($con));

// fetch records
$sql = "select id, name, email from data_users";
$result = mysqli_query($con, $sql);

while($row = mysqli_fetch_assoc($result)) {
    $array[] = $row;
}

$dataset = array(
    "echo" => 1,
    "totalrecords" => count($array),
    "totaldisplayrecords" => count($array),
    "data" => $array
);

/*
$dataset = array
(
    "data" => $array
);
*/

echo json_encode($dataset);
?>