Source Code:
(back to article)
<?php // Initialize variable for database credentials $dbhost = 'hostname'; $dbuser = 'username'; $dbpass = 'password'; $dbname = 'sakila'; //Create database connection $dblink = new mysqli($dbhost, $dbuser, $dbpass, $dbname); //Check connection was successful if ($dblink->connect_errno) { printf("Failed to connect to database"); exit(); } //Fetch 3 rows from actor table $result = $dblink->query("SELECT * FROM actor LIMIT 3"); //Initialize array variable $dbdata = []; //Fetch into associative array while ($row = $result->fetch_assoc()) { $dbdata[] = $row; } //Print array in JSON format echo json_encode($dbdata); ?>
Result:
Report an issue