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
| <?php
$db_server = 'localhost'; // Adresse du serveur MySQL
$db_user_login = 'root'; // Nom de l'utilisateur
$db_user_pass = ''; // Mot de passe de l'utilisateur
$db_name = 'infos'; // Nom de la base de données
// Ouvre une connexion au serveur MySQL
$conn_base = mysqli_connect($db_server,$db_user_login, $db_user_pass, $db_name);
$req_base= "SHOW DATABASES WHERE not (`Database` LIKE '%schema%' or `Database` LIKE 'mysql%' or `Database` LIKE 'sys%' or `Database` LIKE 'crea%')";
$result_base=$conn_base->query($req_base);
@$text=$_POST['envoi'];
if(isset($_POST['envoi'])){
$nombase=$text=$_POST['table'];
$_SESSION["db_name"]=$nombase;
}
echo "<label>Selectionnez la base</label>";
echo '<form name="form" id="form" action="#" method="post">';
echo '<SELECT name=table multiple="multiple" id="d_base" onchange="document.getElementById("id_champ").value=this.options[selectedIndex].value">'; while ($ligne=mysqli_fetch_array($result_base)){
echo "<option value='".$ligne[0]."'>".$ligne[0]."</option>";
}
$default =@$nombase;
if(@$nombase == $default){
echo "<option selected=\"selected\">". $nombase ."</option>";
}
else{
echo "<option>". $nombase ."</option>";
}
echo "</SELECT>";
echo '<input name="envoi" type="submit" id="id_champ" value="">';
echo '</form>';
$db_name = @$nombase;
?>
<script>
var select = document.getElementById('d_base');
select.size = select.length;
</script> |
Partager