Advertisement
Guest User

Update.php

a guest
Oct 17th, 2014
226
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.94 KB | None | 0 0
  1. <?php
  2. if (!empty($_GET['id']) && !empty($_GET['value'])) {
  3.    
  4.     $id = $_GET['id'];
  5.     $value = $_GET['value'];
  6.    
  7.     try {
  8.        
  9.         $objDb = new PDO('mysql:host=localhost;dbname=cars', 'root', 'janix93');
  10.         $objDb->exec('SET CHARACTER SET utf8');
  11.        
  12.         $sql = "SELECT *
  13.                 FROM `categories`
  14.                 WHERE `master` = ".$value;
  15.         $statement = $objDb->prepare($sql);
  16.         $statement->execute(array($value));
  17.         $list = $statement->fetchAll(PDO::FETCH_ASSOC);
  18.        
  19.         if (!empty($list)) {
  20.            
  21.             $out = array('<option value="">Select one</option>');
  22.            
  23.             foreach($list as $row) {
  24.                 $out[] = '<option value="'.$row['id'].'">'.$row['name'].'</option>';
  25.             }
  26.            
  27.             echo json_encode(array('error' => false, 'list' => implode('', $out)));
  28.            
  29.         } else {
  30.             echo json_encode(array('error' => true));
  31.         }
  32.        
  33.     } catch(PDOException $e) {
  34.         echo json_encode(array('error' => true));
  35.     }
  36.    
  37. } else {
  38.     echo json_encode(array('error' => true));
  39. }
  40.  
  41. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement