Mode 1 selected. | Click here to continue. |
Mode 2 selected. | Click here to continue. |
Mode 3 selected.
Please select location below. | Click here to continue. |
query($sql);
$states = array();
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
//echo "STATE: " . $row["state"]. " ";
//RETRIEVE ALL STATES
$sql_states = "SELECT state, city, county FROM locations";
$result = $link->query($sql_states);
$newdata = array (
);
$x=0;
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
//echo "STATE: " . $row["state"]. " - LOCATION: " . $row["city"]. ""; array_push($states, $row["state"]); } } else { echo "0 results"; } $result = array_unique($states); $result_select = array_unique($states); //print_r($result); //var_dump($result); $size = count($result); echo "
"; $newdata[$x]['state'] = $row['state']; $newdata[$x]['city'] = $row['city']; $newdata[$x]['county'] = $row['county']; $x++; } } else { echo "0 results"; } //var_dump($newdata); //echo $jsonformat=json_encode($newdata); mysqli_close($link); ?> |
Student Profile Graduation Predictability Report
Geographic Comparison Mode
(Close Window)