le 16/03/2012 à 17:55
Liste déroulante + %ysql
Oui, tu fais comme ceci, mais attention, adapte et protège avec ce qu'il faut...
<?php
$hostname = 'localhost';
$username = 'username';
$password = 'password';
$dbname = 'base';
try {
$dbh = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = ('SELECT login FROM membres ORDER BY ASC');
foreach ($dbh->query($sql) as $row)
{
?>
<select name="Liste des Membres" onchange='document.location.href=this.options[this.selectedIndex].value;'>
<option value="">Select</option>
<option value="index.php"><?php print .$row['login']. ?></option>
</select>
<?php
}
}
catch(PDOException $e)
{
echo $e->getMessage();
}
?>
Jack Bocar
<?php
$hostname = 'localhost';
$username = 'username';
$password = 'password';
$dbname = 'base';
try {
$dbh = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = ('SELECT login FROM membres ORDER BY ASC');
foreach ($dbh->query($sql) as $row)
{
?>
<select name="Liste des Membres" onchange='document.location.href=this.options[this.selectedIndex].value;'>
<option value="">Select</option>
<option value="index.php"><?php print .$row['login']. ?></option>
</select>
<?php
}
}
catch(PDOException $e)
{
echo $e->getMessage();
}
?>
Jack Bocar