Advertisement
Guest User

Untitled

a guest
Dec 1st, 2019
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.58 KB | None | 0 0
  1. $dbName = "peoples";
  2. $tableName = "peoples";
  3. $idColumn = "id";
  4. $firstnameColumn = "name";
  5. $lastnameColumn = "lastname";
  6.  
  7. $conn1 = new mysqli("localhost", "root", "my_password", $dbName);
  8.  
  9. /* проверка соединения */
  10. if ($mysqli->connect_errno) {
  11. printf("Не удалось подключиться: %s\n", $conn1->connect_error);
  12. exit();
  13. }
  14.  
  15. $query = "select * from ".$tableName." where ".$idColumn."='".$id."'";
  16. $result = $conn1->query($query);
  17. while($row2 = mysqli_fetch_assoc($result))
  18. {
  19. $record[]=$row2;
  20. }
  21. print_r(json_encode($record));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement