Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dbhost = "localhost";
- $dbuser = "dbuser";
- $dbpass = "dbpass";
- $dbname = "dbname";
- $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sql = "SELECT * FROM customer";
- $return_arr = array();
- if ($result = mysqli_query( $conn, $sql )){
- while ($row = mysqli_fetch_assoc($result)) {
- $row_array['id'] = $row['id'];
- $row_array['username'] = $row['username'];
- $row_array['email'] = $row['email'];
- array_push($return_arr,$row_array);
- }
- }
- mysqli_close($conn);
- echo json_encode($return_arr);
- ?>
Add Comment
Please, Sign In to add comment