Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = "localhost";
- $dbname = "ajax_test";
- $user = "root";
- $pass = "";
- $db = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
- if ($db) {
- echo "all is ok";
- }
- $query_result = $db->query('SELECT cc_desks.* '
- . 'FROM cc_desks'
- . 'LEFT JOIN cc_callcenters'
- . 'ON cc_desks.id_callcenter = cc_callcenters.id'
- . 'WHERE cc_callcenters.id = ' . 1);
- var_dump($query_result);
- if ($query_result) {
- foreach ($query_result->fetchAll() as $row_number => $row) {
- $results[] = $row['name'];
- }
- $db = NULL;
- echo json_encode($results);
- } else {
- echo "U LOSE";
- }
Add Comment
Please, Sign In to add comment