[{
"Index1": "*value1",
"Index3": "value2",
"Index3": "value3"
}]
*/
require_once 'Jengine.php';
$servername = "";
//localhost
$username = "";
//root
$password = "";
$dbname = "";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM somedb ";
$result = $conn->query($sql);
echo "<b> Using template loaded from data source</b>";
echo '</br></br>';
echo '</br></br>';
$template = Jengine::json_mysqli_result($result);
echo $template;
$conn->close();
?>
</body>
</html>
<!DOCTYPE html>
<html>
<body>
<?php
require_once 'Jengine.php';
$servername = "localhost";
$username = "******";
$password = "";
$dbname = "hotel_reservations";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM room";
$result = $conn->query($sql);
$check2 = Jengine::json_mysqli_result($result);
echo $check2;
var_dump($result);
// Aresult Object is returned
$conn->close();
?>
</body>
</html>
