<script src="ajax_framework.js" language="javascript"></script>
    
<script language="javascript" type="text/javascript">
function getXMLHTTP() {
        var xmlhttp=false;  
        try{
            xmlhttp=new XMLHttpRequest();
        }
        catch(e)    {       
            try{            
                xmlhttp= new ActiveXObject("Microsoft.XMLHTTP");
            }
            catch(e){
                try{
                xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
                }
                catch(e1){
                    xmlhttp=false;
                }
            }
        }
            
        return xmlhttp;
    }
    
    function getDirection(trainerId) {      
        
        var strURL="findState.php?trainer="+trainerId;
        var req = getXMLHTTP();
        
        if (req) {
            
            req.onreadystatechange = function() {
                if (req.readyState == 4) {
                    // only if "OK"
                    if (req.status == 200) {                        
                        document.getElementById('statediv').innerHTML=req.responseText;
                        document.getElementById('citydiv').innerHTML='<select name="full_date">'+'<option>Выберите дату занятия</option>'+'</select>';                      
                    } else {
                        alert("Problem while using XMLHTTP:\n" + req.statusText);
                    }
                }               
            }           
            req.open("GET", strURL, true);
            req.send(null);
        }       
    }
    function getSchedule(trainerId,directionId) {       
        var strURL="/findCity.php?trainer="+trainerId+"&direction="+directionId;
        var req = getXMLHTTP();
        
        if (req) {
            
            req.onreadystatechange = function() {
                if (req.readyState == 4) {
                    // only if "OK"
                    if (req.status == 200) {                        
                        document.getElementById('citydiv').innerHTML=req.responseText;                      
                    } else {
                        alert("Problem while using XMLHTTP:\n" + req.statusText);
                    }
                }               
            }           
            req.open("GET", strURL, true);
            req.send(null);
        }
                
    }
    
    </script>
 <script src="ajax_framework.js" language="javascript"></script>
 <div id="insert_response"></div>
<form action="javascript:insert()" method="post">
 
 
<center>
<table width="45%"  cellspacing="0" cellpadding="0">
  <tr>
    <td width="75">Ваш тренер</td>
     <td width="50">:</td>
    <td  width="150"><select name="trainer" onChange="getDirection(this.value)">
    <option value="">Выберите тренера</option>
    <?php while ($row=$result->fetch_array(MYSQLI_ASSOC)) { ?>
    <option value=<?php echo $row['id_trainer']?>><?php echo $row['trainer']?></option>
    <?php } ?>
    </select></td>
  </tr>
  <tr style="">
    <td>Направление</td>
    <td width="50">:</td>
    <td ><div id="statediv"><select name="direction" >
    <option>Выберите направление</option>
        </select></div></td>
  </tr>
 
 
 <tr style="">
    <td>Выберите дату проведения занятия</td>
    <td width="50">:</td>
    <td ><div id="citydiv" name="citydiv">
    <select name="full_date" id="full_date">
    <option>Дата</option>
        </select></div></td>
    
 
 
<tr style="">
    <td><label for="id_subscription">Номер вашего абонемента:</label><br/></td>
    <td width="50">:</td>
<td ><input type="text" name="id_subscription" id="id_subscription" size="30" value=""/><br/></td>
 
   
    
<tr style=""> <td> <td> <td>
<input type="submit" name="Submit" value="Insert"/></td></tr>
</table>
</center>
</form>
</head>
 
</html>

<meta charset="utf-8">
 
<?php 
require 'dbConfig.php';
//require_once("header.php");
$id_subscription = trim($_REQUEST['id_subscription']);
$citydiv = trim($_REQUEST['full_date']);
 
 
 
$insert_sql = "INSERT INTO Attendance (`id_subscription`, `id_schedule`) VALUES (".$id_subscription.",".$citydiv.")";
$result=$con->query($insert_sql);
//var_dump($result);
 
if ($result == true)
{
echo "<p>Вы записались на занятие, если хотите записаться еще на одно занятие, то вернитесь на страницу назад</p>";}
else {
echo "<p>ошибка</p>";
}
die;
?>

function createObject() {
var request_type;
var browser = navigator.appName;
if(browser == "Microsoft Internet Explorer"){
request_type = new ActiveXObject("Microsoft.XMLHTTP");
}else{
request_type = new XMLHttpRequest();
}
return request_type;
}
var http = createObject();
 
 
 
var nocache = 0;
 
function insert() {
 document.getElementById('insert_response').innerHTML = "Just a second..."
 var req = getXMLHTTP();
var id_subscription= encodeURI(document.getElementById('id_subscription').value);
var full_date = encodeURI(document.getElementById('full_date').value);
 
nocache = Math.random();
http.open('get', 'form.php?id_subscription='+id_subscription+'&full_date=' +full_date+'&nocache = '+nocache);
http.onreadystatechange = insertReply;
http.send(null);
}
 
function insertReply() {
if(http.readyState == 4){ 
var response = http.responseText;
document.getElementById('insert_response').innerHTML = 'Site added:'+response;
 }
 }