Guest User

Untitled

a guest
Sep 13th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.51 KB | None | 0 0
  1. <?php
  2. $dbhost = 'localhost';
  3. $dbuser = 'root';
  4. $dbpass = '';
  5.  
  6. $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
  7. $dbname = 'javascript_test';
  8. mysql_select_db($dbname);
  9.  
  10. switch ($_POST['action']) {
  11.     case 'getUser':
  12.         $query  = "SELECT name FROM `user`";
  13.         break;
  14.     case 'getTickets':
  15.         $query  = "SELECT * FROM `tickets`";
  16.         break;
  17.     default:
  18.         break;
  19. }
  20. mysql_close($conn);
  21. $result = mysql_query($query);
  22. return json_encode($result);
  23. ?>
Add Comment
Please, Sign In to add comment