[PHP, JS] GET ressources insuffisantes
S
Bonjour à tous,
Je débute dans le développement web et je me trouve face à un problème que je n'arrive pas à résoudre.
Sur une de mes pages, j'ai deux "modal" qui récupèrent différentes informations de ma base de données selon le modal que je souhaite ouvrir. Voici le code de ma page où se situe l'appel des "modal" :
<?php
session_start();
require '../admin/database.php';
if(!empty($_SESSION["id"]))
{
$id = $_SESSION["id"];
$db = Database::connect();
$statement = $db->prepare("SELECT * FROM login WHERE id = ?" );
$statement->execute(array($id));
$item = $statement->fetch();
$mail = $item['mail'];
$lastname = $item['lastname'];
$firstname = $item['firstname'];
$password = $item['password'];
$administrator = $item['administrator'];
Database::disconnect();
}
else
{
header("location:../logout.php");
}
if(!empty($_GET['id_affair']))
{
$id_affair = checkInput($_GET['id_affair']);
$db = Database::connect();
$statement = $db->prepare("SELECT * FROM affair WHERE id = ?" );
$statement->execute(array($id_affair));
$item = $statement->fetch();
$affair_name = $item['name'];
$customer = $item['customer'];
$number = $item['number'];
$state = $item['state'];
$statement = $db->prepare("SELECT * FROM users_task WHERE user = ?" );
$statement->execute(array($_SESSION["id"]));
while($item = $statement->fetch())
{
$logout = true;
$affair = $item['affair'];
if($affair==$id_affair)
{
$logout = false;
break;
}
}
if($logout==true)
{
header("location:../logout.php");
}
Database::disconnect();
$_SESSION["affair_id"] = $id_affair;
$_SESSION["affair_name"] = $affair_name;
$_SESSION["affair_customer"] = $customer;
$_SESSION["affair_number"] = $number;
$_SESSION["affair_state"] = $state;
}
else
{
header("location:../logout.php");
}
function checkInput($data)
{
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
?>
<!DOCTYPE html>
<html>
<head>
<?php echo "<title>Team Project - " . $affair_name . "</title>"; ?>
<meta charset="utf-8"/>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" >
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.3.1/css/all.css">
<script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>
<link href="https://fonts.googleapis.com/css?family=Lato" rel="stylesheet">
<link rel="stylesheet" href="../css/style copy 11.css">
</head>
<body data-spy="scroll" data-target=".navbar" data-offset="60">
<header>
<div class="menu_gauche">
<?php include "../affair/header/header_left.php" ?>
</div>
<?php echo "<h1>" . $affair_name . "</h1>"; ?>
<div class="menu_droit">
<?php include "../affair/header/header_right.php" ?>
</div>
</header>
<img class="img_affair" id="openusers" src="../images/profil.png">
<?php echo '<input id="id" name="id" type="hidden" value="' . $id_affair . '"></input>'; ?>
<div class="modal fade" id="myModal" role="dialog">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Utilisateurs de l'affaire <?php echo $affair_name; ?></h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<div class="modal-body">
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Fermer</button>
</div>
</div>
</div>
</div>
<img class="img_affair" id="openSettings" src="../images/parametres.png">
<div class="modal fade" id="settingsModal" role="dialog">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Paramètres de l'affaire <?php echo $affair_name; ?></h4>
<button type="button" class="close" data-dismiss="modal">×</button>
</div>
<div class="modal-body">
</div>
<div class="modal-footer">
<button type="button" class="btn btn-secondary" data-dismiss="modal">Fermer</button>
</div>
</div>
</div>
</div>
<script>
$('#openusers').on('click',function(){
$('.modal-body').load('users.php',function(){
$('#myModal').modal({show:true});
});
});
$('#openSettings').on('click',function(){
$('.modal-body').load('settings.php',function(){
$('#settingsModal').modal({show:true});
});
});
</script>
<div class="container" >
<div class="row">
<section id="taches" class="col-xl-12">
<?php echo "<h2>" . $firstname . ", voici les tâches et sous-tâches de l'affaire :</h2>"; ?>
</section>
</div>
</div>
</html>Ensuite, dans ces "modal", je peux modifier les données de ma base. Je fais cela avec ajax. Voici le code d'un de mes "modal" :
<meta charset="utf-8"/>
<?php
session_start();
require '../admin/database.php';
$id = $_SESSION['affair_id'];
?>
<div id="users_affair" class="container" >
<?php
$db = Database::connect();
$statement = $db->prepare("SELECT * FROM users_task INNER JOIN login ON users_task.user = login.id WHERE affair = ?" );
$statement->execute(array($id));
$result = $statement->fetchAll();
Database::disconnect();
foreach ($result as $item)
{
?>
<div class="row_user row">
<button type="button" style="outline:none;" name="<?php echo '' . $item['id_user'] ?>" class="close" >×</button>
<span class="user_firstname" ><?php echo '' . $item['firstname'] ?></span>
<span class="user_lastname" ><?php echo '' . $item['lastname'] ?></span>
<span class="user_mail" ><?php echo '' . $item['mail'] ?></span>
<input class = "user_initials" name="<?php echo '' . $item['id_user'] ?>" type="text" value="<?php echo '' . $item['initials'] ?>" placeholder="Initiales">
</div>
<?php
}
?>
</div>
<div style="margin-top: 10px" class="form-group">
<input class="searchBarUser" class="form-control" type="text" value="" placeholder="Ajouter un utilisateur">
</div>
<div style="margin-top: 10px">
<ul id="result"></ul>
</div>
<script>
$(document).ready(function(){
$('#result').html('');
$('.searchBarUser').keyup(async function(){
await sleep(250);
$('#result').html('');
let user = $(this).val();
if(user != ""){
$.ajax({
type: 'GET',
url: 'search_user.php',
data: 'user=' + encodeURIComponent(user),
success: function(data){
if(data!="")
{
$('#result').append(data);
}
else
{
document.getElementById('result').innerHTML = "<div>Aucun utilisateur trouvé</div>"
}
}
})
}
});
$('.user_initials').keyup(async function(){
await sleep(1000);
let id_user = $(this).attr('name');
let initials = $(this).val();
if(initials != ""){
$.ajax({
type: 'GET',
url: 'update_initials.php',
data: 'initials=' + encodeURIComponent(initials) + '&id_user=' + encodeURIComponent(id_user),
success: function(data){
if(data!="")
{
$('.modal-body').load('users.php');
}
}
})
}
});
$('.close').click(function(){
let id_user = $(this).attr('name');
if(id_user != ""){
$.ajax({
type: 'GET',
url: 'delete_user.php',
data: 'id_user=' + encodeURIComponent(id_user),
success: function(data){
if(data!="")
{
$('.modal-body').load('users.php')
}
}
})
}
});
});
function sleep(ms)
{
return new Promise(resolve => setTimeout(resolve, ms));
}
</script>Mon soucis, c'est qu'à force de les ouvrir fermer, la page plante et quand je fais F12 sur mon navigateur, je vois des messages de ressources insuffisantes comme dans l'image en pièce jointe.
Faut-il que je rafraîchisse ma page lors de la fermeture des "modal" où y'a t'il un autre souci avec mon code ?
J'espère être assez clair. Hésitez pas à me demander plus d'informations si nécessaire.
Merci d'avance pour ceux qui prendront du temps pour mon cas.
Sam
