Merci de ton aide, mon code fonctionne par contre je n'arrive pas afficher les résultat dans ma modal
[code]<?php
include("Connexion/connexion.php"); // Connextion à la base de données
?>
<!-- Modal -->
<div class="modal fade" id="ajout" role="dialog">
<div class="modal-dialog">
<!-- Modal content-->
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Ajout inventaire</h4>
</div>
<div class="modal-body">
<form id="add_inventory">
<!-- Pour recherche dans l'active directory -->
<label for="Prenom et nom">Prenom et nom</label>
<input id="search_ad" >
<div class="form-group">
<label for="hostname_add" class="form-control-label">Hostname:</label>
<input id="hostname_add" list="hostname_add_list" name="hostname" class="form-control" required>
<datalist id="hostname_add_list">
<?php
$sql = "SELECT DISTINCT hostname FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['hostname'].">".$value['hostname']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="prenom_add" class="form-control-label">Prenom:</label>
<input id="prenom_add" list="prenom_add_list" class="form-control" name="prenom_add" required>
<datalist id="prenom_add_list">
<?php
$sql = "SELECT DISTINCT prenom FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['prenom'].">".$value['prenom']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="nom_add" class="form-control-label">nom:</label>
<input id="nom_add" list="nom_add_list" class="form-control" name="nom_add" required>
<datalist id="nom_add_list">
<?php
$sql = "SELECT DISTINCT nom FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['nom'].">".$value['nom']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="login_add" class="form-control-label">Login:</label>
<input id="login_add" list="login_add_list" class="form-control" name="login" required>
<datalist id="login_add_list">
<?php
$sql = "SELECT DISTINCT login FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['login'].">".$value['login']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="service_add" class="form-control-label">Service:</label>
<input id="service_add" list="service_add_list" class="form-control" name="service_add" required>
<datalist id="service_add_list">
<?php
$sql = "SELECT DISTINCT service FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['service'].">".$value['service']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="localisation_add" class="form-control-label">Localisation:</label>
<input id="localisation_add" list="localisation_add_list" class="form-control" name="localisation_add" required>
<datalist id="localisation_add_list">
<?php
$sql = "SELECT DISTINCT localisation FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['localisation'].">".$value['localisation']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="costcenter_add" class="form-control-label">Costcenter:</label>
<input id="costcenter_add" list="costcenter_add_list" class="form-control" name="costcenter_add" required>
<datalist id="costcenter_add_list">
<?php
$sql = "SELECT DISTINCT costcenter FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['costcenter'].">".$value['costcenter']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="statut_add" class="form-control-label">Statut:</label>
<input id="statut_add" list="statut_add_list" class="form-control" name="statut_add" required>
<datalist id="statut_add_list">
<?php
$sql = "SELECT DISTINCT statut FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['statut'].">".$value['statut']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="type_add" class="form-control-label">Type:</label>
<input id="type_add" list="type_add_list" class="form-control" name="type_add" required>
<datalist id="type_add_list">
<?php
$sql = "SELECT DISTINCT type FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['type'].">".$value['type']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="marque_add" class="form-control-label">Marque:</label>
<input id="marque_add" list="marque_add_list" class="form-control" name="marque_add" required>
<datalist id="marque_add_list">
<?php
$sql = "SELECT DISTINCT marque FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['marque'].">".$value['marque']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="num_serie_add" class="form-control-label">N° Serie:</label>
<input id="num_serie_add" list="num_serie_add_list" class="form-control" name="num_serie_add" required>
<datalist id="num_serie_add_list">
<?php
$sql = "SELECT DISTINCT num_serie FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['num_serie'].">".$value['num_serie']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="num_sbe_add" class="form-control-label">N° Sbe:</label>
<input id="num_sbe_add" list="num_sbe_add_list" class="form-control" name="num_sbe_add" required>
<datalist id="num_sbe_add_list">
<?php
$sql = "SELECT DISTINCT num_sbe FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['num_sbe'].">".$value['num_sbe']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="type_disque_add" class="form-control-label">Type_disque:</label>
<input id="type_disque_add" list="type_disque_add_list" class="form-control" name="type_disque_add" required>
<datalist id="type_disque_add_list">
<?php
$sql = "SELECT DISTINCT type_disque FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['type_disque'].">".$value['type_disque']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="imei_add" class="form-control-label">IMEI:</label>
<input id="imei_add" list="imei_add_list" class="form-control" name="imei_add" required>
<datalist id="imei_add_list">
<?php
$sql = "SELECT DISTINCT imei FROM Inventaire";
foreach ($bdd->query($sql) as $value) {
echo "<option value=".$value['imei'].">".$value['imei']."</option>";
}
?>
</datalist>
</div>
<div class="form-group">
<label for="date_livraison_add" class="form-control-label">Date livraison:</label>
<input type="date" class="form-control" id="date_livraison_add" min="<?php echo date("d-m-Y") ?>" name="date_livraison_add" value="<?php echo date("Y-m-d") ?>" required>
</div>
<div class="form-group">
<label for="fin_garantie_add" class="form-control-label">fin garantie:</label>
<input type="date" class="form-control" id="fin_garantie_add" min="<?php echo date("d-m-Y") ?>" name="fin_garantie_add" value="<?php echo date("Y-m-d") ?>" required>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-danger" data-dismiss="modal">Fermer</button>
<button type="submit" name="submit" id="add_row_tab" class="btn btn-success">OK</button>
</div>
</form>
</div>
</div>
</div>
</div>[/code]
[code] $(document).ready(function(){
// Lors de l'ajout d'une ligne d'inventaire on récupère les informations utilisateur sur l'active directory
$('#search_ad').autocomplete({
source: function (request, response) {
$.getJSON("Controller/ldap/search_ldap.php?term=" + request.term, function (data) {
response($.map(data.info, function (value) {
return value.prenom_nom;
}));
});
},
minLength: 1,
select: function( event, ui ) {alert(ui.item.label );
return false;
}
});
});[/code]
Le code fonctionne mais affiche la liste seulement pour un input no n contenu dans une modal.
