Guest User

Untitled

a guest
Sep 16th, 2016
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.63 KB | None | 0 0
  1. <?php
  2. $host = "localhost";
  3. $dbname = "ajax_test";
  4. $user = "root";
  5. $pass = "";
  6. $db = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
  7. if ($db) {
  8.     echo "all is ok";
  9. }
  10. $query_result = $db->query('SELECT cc_desks.* '
  11.         . 'FROM cc_desks'
  12.         . 'LEFT JOIN cc_callcenters'
  13.         . 'ON cc_desks.id_callcenter = cc_callcenters.id'
  14.         . 'WHERE cc_callcenters.id = ' . 1);
  15. var_dump($query_result);
  16. if ($query_result) {
  17.     foreach ($query_result->fetchAll() as $row_number => $row) {
  18.         $results[] = $row['name'];
  19.     }
  20.  
  21.     $db = NULL;
  22.     echo json_encode($results);
  23. } else {
  24.     echo "U LOSE";
  25. }
Add Comment
Please, Sign In to add comment