<script src="http://code.jquery.com/jquery-1.10.1.min.js"></script>

<script type="text/javascript">
    function StartScript(script) {
        jQuery.getScript('Invoer.php?script=' + escape(script));
    }
    $(document).ready( function () {
        alert("Hello, world")
    });
    $("option").Click(function() {
        alert($(this).val());
    });
</script>

<?php
/**
 * Created by PhpStorm.
 * User: Karl
 * Date: 9/03/2016
 * Time: 14:03
 */


$user = 'student';
$password = 'student123';
$pdo = null;
try {

    // connectie maken met databank noelvaes
    $pdo = new PDO('mysql:host=noelvaes.eu;dbname=StudentDB', $user, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $stmt = $pdo->query('SHOW DATABASES');
    $stmt->setFetchMode(PDO::FETCH_ASSOC);
    if ($stmt->rowCount() > 0) {
        $columnNames = array();
        for ($i = 0; $i < $stmt->columnCount(); $i++) {
            $col = $stmt->getColumnMeta($i);
            $columnNames[] = $col['name'];
        }


        //table

       /* print("<table>");
        print('<tr><th>' . implode('</th><th>', $columnNames) .
            '</th></tr>');
        while ($row = $stmt->fetch()) {
            print('<tr><td>' . implode('</td><td>', $row) .
                '</td></tr>');
        }
        print("</table>");*/

        //Option

        print("<select name=\"form\" id=\"form\">");
        print('<option selected="selected">Choose one</option>');

        while ($row = $stmt->fetch()) {
            // print('<option name="Black" >Black</option>');
             //print('option name="' . $row . '" >' . $row . '</option>');
            print('<option value="' . implode('', $row) .
                '" >' . implode('', $row) . '</option>');
        }
        print("</select>");
        print("<br>");
        $value = $_POST['make'];
        print("<INPUT  TYPE = \"Text\" VALUE =\"command\" NAME = \"command\">");
        print ("<input id=\"other\" type=\"submit\" value=\"Submit\">");

    }

} catch (PDOException $e) {
    print 'Exception!: ' . $e->getMessage();
}
// connectie sluiten
$pdo = null;