<?php

    $db = new PDO(
        "mysql:host=localhost;dbname=class_example",
        "class_user",
        "class_password"
    );

    $get_terms = $db->prepare("
        SELECT * FROM `keywords`
        WHERE `keyword` LIKE :terms
        LIMIT 5
    ");
    
    $get_terms->execute(array(
        ':terms' => $_GET['terms'] . '%'
    ));

    $results = $get_terms->fetchAll(PDO::FETCH_ASSOC);

    $keywords = array();
    foreach ($results as $row)
    {
        array_push($keywords, $row['keyword']);
    }

    print_r(json_encode($keywords));


?>