"SET NAMES utf8")); //$dbh = new PDO($dsn, $user, $pass, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); $dbh = new PDO($dsn, $user, $pass); $dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, TRUE); $dbh->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION); // Escape the value of $author with quote() //$sql = 'SELECT * FROM vsaqtns WHERE sbj = '. $dbh->quote($sbj) && 'qnatr ='. $dbh->quote($qnatr); $sql="SELECT * FROM vsaqtns WHERE sbj='$sbj' && qnatr ='$qnatr' && yr ='$yr' && dt ='$dt'"; //qnatr; //$sql="SELECT * FROM vsaqtns WHERE pos BETWEEN 24428 AND 24446"; //$data = $_db->query("SELECT * FROM countries")->fetchAll(PDO::FETCH_ASSOC); // Execute the statement and echo the results $results = $dbh->query($sql)->fetchAll(PDO::FETCH_ASSOC); //---------------- echo json_encode($results); //$dbh = null; } catch (PDOException $e) { print "Error!: " . $e->getMessage() . "
"; die(); } ?>