Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!-- Connect to database -->
- <?php
- $dbhost = "localhost";
- $dbuser = "root";
- $dbpass = "";
- $dbname = "lobster";
- $db = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
- if(mysqli_connect_errno()) {
- die("Database connection failed: " .
- mysqli_connect_error() .
- " (" . mysqli_connect_errno() . ")"
- );
- }
- ?>
- <!-- Perform database query -->
- <?php
- $query = "SELECT * FROM me_business";
- $result = mysqli_query($db, $query);
- // Test for query error
- if (!$result) {
- die("failure!");
- }
- ?>
- <!-- Output Data -->
- <?php
- while($row = mysqli_fetch_assoc($result)) {
- $businiess_JSON = json_encode($row);
- echo $businiess_JSON;
- }
- ?>
- <!-- Release Data & Close connection to database -->
- <?php
- mysqli_free_result($result);
- mysqli_close($db);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement