View ajax.php
<?php // Load items into a HTML select box via PHP & Ajax | |
$firstbox = $_POST['firstbox']; | |
$query = "SELECT * FROM mytable WHERE id_firstbox = '$firstbox';"; | |
$result = pg_query($query) or die('Query failed: ' . pg_last_error()); | |
$secondbox_arr = array(); | |
if (pg_num_rows($result) > 0) { | |
while ($row = pg_fetch_array($result, NULL, PGSQL_ASSOC)) { | |
$secondbox_arr[] = array("id" => $row['id_secondbox'], "name" => $row['testo_secondbox']); | |
} |