Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
Massage_v3_debug
/
datatable
/
01
:
fetch_records.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?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); ?>