<?php

$mysqli = new mysqli('localhost', 'test', 'test', 'test');

if($mysqli->connect_errno)
    exit("Connect failed: %s\n". $mysqli->connect_error);

$stmt = $mysqli->prepare("SELECT name FROM states WHERE name LIKE ?");

if($stmt) {
    $search = '%'. $_GET['search'] .'%';
    $stmt->bind_param('s', $search);
    $stmt->execute();
    $stmt->bind_result($state);
    
    while ($stmt->fetch()) {
        $result[] = $state;
    }
    $stmt->close();
}
else {
    exit("Error:". $mysql->error);
}

$mysqli->close();

// Gör om PHP arrays till en textsträng som javascript kan konvertera tillbaka till en array
// Exempel:
// json_encode(array('a', 'b', 'c', 'osv')) => "['a', 'b', 'c', 'osv']"
exit(json_encode($result));

?>