Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $servername = "140.118.70.162";
- $username = "kevin";
- $password = "password";
- // Create connection
- $conn = new mysqli($servername, $username, $password, "kevin");
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $sth = mysqli_query($conn, "SELECT * FROM trash_data WHERE id IN
- (
- SELECT MAX(id) AS id
- FROM trash_data
- GROUP BY chip_id
- )ORDER BY chip_id ASC");
- $rows = array();
- while($r = mysqli_fetch_assoc($sth)) {
- $rows['results'][] = $r;
- }
- print json_encode($rows);
- mysqli_close($conn);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement