Untitled

<html>
    <head>
        <meta charset="UTF-8">
    </head>
        <title></title>
    <body>
            <label>Select period</label>
            <select class="dropdownX">
                <option>Select</option>
                <?php
                if($stmt=$conn->query("SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA='$dbname' ORDER BY create_time DESC"))
                {
                    while($r=$stmt->fetch_array(MYSQLI_ASSOC))
                    {
                 ?>
                <option value="<?php echo $r['TABLE_NAME'] ?>"><?php echo $r['TABLE_NAME'] ?></option>

                <?php  }  }   ?>

            </select>
    </body>
</html>
<script>
<html>
    <head>
        <meta charset="UTF-8">
    </head>
        <title></title>
    <body>
$(".dropdownX").on("change", function() {
window.location.href = "?period=" + this.value;
});
</script>