Soumettre des données vers une datatables sans recharger/rafraichir la page

**emilie93** · 28/04/2022, 02h14

Bonjour tout le monde,

je veux que mon code xx.php envoi les données vers une datatables se situant sur index.php mais sans que cette dernière (page) sois recharger/rafraichi ou actualisée

par contre la datatables prend les dernières modifications

mon fichier index.php

Code php :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
<table id="example1" class="table table-bordered">
                    <thead>
                        <tr>
						<td>Nom</td>
						<td>ID</td>
						<td>Entrer</td>
						<td>Sortie</td>
						<td>Date</td>
                        </tr>
                    </thead>
                    <tbody>
                        <?php
                        $server = "localhost";
                        $username="root";
                        $password="";
                        $dbname="qrcodedb";
                        $conn = new mysqli($server,$username,$password,$dbname);
						$date = date('d/m/Y');
                        if($conn->connect_error){
                            die("Connection failed" .$conn->connect_error);
                        }
                           $sql ="SELECT * FROM attendance LEFT JOIN student ON attendance.STUDENTID=student.STUDENTID WHERE LOGDATE='$date'";
                           $query = $conn->query($sql);
                           while ($row = $query->fetch_assoc()){
                        ?>
                            <tr>
                                <td><?php echo $row['FIRSTNAME'].' '.$row['LASTNAME'];?></td>
                                <td><?php echo $row['STUDENTID'];?></td>
                                <td><?php echo $row['TIMEIN'];?></td>
                                <td><?php echo $row['TIMEOUT'];?></td>
                                <td><?php echo $row['LOGDATE'];?></td>
                            </tr>

Mon fichier xxx.php

Code php :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
<?php
    session_start();
    $server = "localhost";
    $username="root";
    $password="";
    $dbname="qrcodedb";
 
    $conn = new mysqli($server,$username,$password,$dbname);
 
    if($conn->connect_error){
        die("Connection failed" .$conn->connect_error);
    }
 
    if(isset($_POST['studentID'])){
 
        $studentID =$_POST['studentID'];
		$date = date('d/m/Y');
		$time = date('H:i:s ');
 
		$sql = "SELECT * FROM student WHERE STUDENTID = '$studentID'";
		$query = $conn->query($sql);
 
		if($query->num_rows < 1){
			$_SESSION['error'] = 'Cannot find QRCode number '.$studentID;
		}else{
				$row = $query->fetch_assoc();
				$id = $row['STUDENTID'];
				$sql ="SELECT * FROM attendance WHERE STUDENTID='$id' AND LOGDATE='$date' AND STATUS='0'";
				$query=$conn->query($sql);
				if($query->num_rows>0){
				$sql = "UPDATE attendance SET TIMEOUT='$time', STATUS='1' WHERE STUDENTID='$studentID' AND LOGDATE='$date'";
				$query=$conn->query($sql);
				$_SESSION['success'] = 'Successfuly Time Out: '.$row['FIRSTNAME'].' '.$row['LASTNAME'];
			}else{
					$sql = "INSERT INTO attendance(STUDENTID,TIMEIN,LOGDATE,STATUS) VALUES('$studentID','$time','$date','0')";
					if($conn->query($sql) ===TRUE){
					 $_SESSION['success'] = 'Successfuly Time In: '.$row['FIRSTNAME'].' '.$row['LASTNAME'];
			 }else{
			  $_SESSION['error'] = $conn->error;
		   }	
		}
	}
 
	}else{
		$_SESSION['error'] = 'Please scan your QR Code number';
}
header("location: index.php");
 
$conn->close();
?>