Bon, je viens de regarder mais mon problème reste entier alors je vais vous mettre mon code (ATTENTION!!! C'EST LE BORDEL!!!!).
Première page
<?php
#CONFIG
include 'config.php';
#DATAS
$oQuerySelect = $oBDD -> query('SELECT DISTINCT Nom_edition as name, id_edition as id FROM tbl_edition');
?>
<h3>liste des éditions</h3>
<form action="tableau de base.php" method="post">
<p>
<select name="nom">
<?php foreach( $oQuerySelect as $aRow )
if( !empty($aRow['name']) )
echo ' <option value="', $aRow['id'], '">', $aRow['name'], '</option>';
?>
</select>
</p>
<input type="submit" value="Choisissez votre édition">
</form>
Deuxième page
<html>
<head>
<title>Catalogue de cartes magic</title>
</head>
<body>
<?php
$user="root";
$host="localhost";
$password="";
$database="db_magic";
$connexion = mysql_connect($host,$user,$password)
or die ("Connexion au serveur impossible");
$db=mysql_select_db($database,$connexion)
or die ("Connexion base impossible");
foreach ($_POST as $valeur)
{
}
$rq = "SELECT * FROM tbl_cartes WHERE id_edition = '$valeur' ORDER BY numero";
$result = mysql_query($rq)
or die ("problème sur le requête");
$rq1 = "SELECT Nom_edition FROM tbl_edition WHERE id_edition = '$valeur'";
$result1 = mysql_query($rq1)
or die ("probleme sur la deuxieme requête");
while ($ligne1 = mysql_fetch_array($result1))
{extract ($ligne1);
echo "<h1>Edition $Nom_edition</h1>";
}
echo "<table cellspacing='5'>";
echo "<tr><td colspan='10'><hr></td></tr>";
while ($ligne = mysql_fetch_array($result))
{extract ($ligne);
echo "<tr>\n";
echo "<td>$numero</td>\n";
echo "<td>$Nom_carte</td>\n";
echo "<td>$diffusion</td>\n";
echo "<td>$couleur</td>\n";
echo "<td>$Type</td>\n";
echo "<td><input type='submit' value='-' name='-collection'></td>\n";
echo "<td style='text-align: center'><input type='text'
name='collecion' value='$collection' size='1'></td>\n";
echo "<td><input type='submit' value='+' name='+collection'></td>\n";
echo "<td><input type='submit' value='-' name='-jeu'></td>\n";
echo "<td style='text-align: center'><input type='text'
name='jeu' value='$jeu' size='1'></td>\n";
echo "<td><input type='submit' value='+' name='+jeu'></td>\n";
echo "<td><input type='checkbox'
name='foil' value='$_POST ['Foil']'></td>\n";
echo "</tr>\n";
echo "<tr><td colspan='10'><hr></td></tr>\n";
}
echo "</table>\n";
echo "<form action='newdepart.php' method='post'>";
Echo "<input type='submit' value='retour'>";
echo "<SCRIPT LANGUAGE='JavaScript'>";
echo "<input type='button' value='-' onclick='$('#button-1').val( $('#button-1').val()*1-1 );' />";
echo "<input type='text' name='' id='button-1' value='0' />";
echo "<input type='button' value='+' onclick='$('#button-1').val( $('#button-1').val()*1+1 );' />";
echo "</SCRIPT>" ;
?>
</body>
</html>
Bonne chance à ceux qui veulent y jeter un coup d'oeil. Et merci à tous
Bon, je viens de regarder mais mon problème reste entier alors je vais vous mettre mon code (ATTENTION!!! C'EST LE BORDEL!!!!).
Première page
[php]
<?php
#CONFIG
include 'config.php';
#DATAS
$oQuerySelect = $oBDD -> query('SELECT DISTINCT Nom_edition as name, id_edition as id FROM tbl_edition');
?>
<h3>liste des éditions</h3>
<form action="tableau de base.php" method="post">
<p>
<select name="nom">
<?php foreach( $oQuerySelect as $aRow )
if( !empty($aRow['name']) )
echo ' <option value="', $aRow['id'], '">', $aRow['name'], '</option>';
?>
</select>
</p>
<input type="submit" value="Choisissez votre édition">
</form>
[/php]
Deuxième page
[php]
<html>
<head>
<title>Catalogue de cartes magic</title>
</head>
<body>
<?php
$user="root";
$host="localhost";
$password="";
$database="db_magic";
$connexion = mysql_connect($host,$user,$password)
or die ("Connexion au serveur impossible");
$db=mysql_select_db($database,$connexion)
or die ("Connexion base impossible");
foreach ($_POST as $valeur)
{
}
$rq = "SELECT * FROM tbl_cartes WHERE id_edition = '$valeur' ORDER BY numero";
$result = mysql_query($rq)
or die ("problème sur le requête");
$rq1 = "SELECT Nom_edition FROM tbl_edition WHERE id_edition = '$valeur'";
$result1 = mysql_query($rq1)
or die ("probleme sur la deuxieme requête");
while ($ligne1 = mysql_fetch_array($result1))
{extract ($ligne1);
echo "<h1>Edition $Nom_edition</h1>";
}
echo "<table cellspacing='5'>";
echo "<tr><td colspan='10'><hr></td></tr>";
while ($ligne = mysql_fetch_array($result))
{extract ($ligne);
echo "<tr>\n";
echo "<td>$numero</td>\n";
echo "<td>$Nom_carte</td>\n";
echo "<td>$diffusion</td>\n";
echo "<td>$couleur</td>\n";
echo "<td>$Type</td>\n";
echo "<td><input type='submit' value='-' name='-collection'></td>\n";
echo "<td style='text-align: center'><input type='text'
name='collecion' value='$collection' size='1'></td>\n";
echo "<td><input type='submit' value='+' name='+collection'></td>\n";
echo "<td><input type='submit' value='-' name='-jeu'></td>\n";
echo "<td style='text-align: center'><input type='text'
name='jeu' value='$jeu' size='1'></td>\n";
echo "<td><input type='submit' value='+' name='+jeu'></td>\n";
echo "<td><input type='checkbox'
name='foil' value='$_POST ['Foil']'></td>\n";
echo "</tr>\n";
echo "<tr><td colspan='10'><hr></td></tr>\n";
}
echo "</table>\n";
echo "<form action='newdepart.php' method='post'>";
Echo "<input type='submit' value='retour'>";
echo "<SCRIPT LANGUAGE='JavaScript'>";
echo "<input type='button' value='-' onclick='$('#button-1').val( $('#button-1').val()*1-1 );' />";
echo "<input type='text' name='' id='button-1' value='0' />";
echo "<input type='button' value='+' onclick='$('#button-1').val( $('#button-1').val()*1+1 );' />";
echo "</SCRIPT>" ;
?>
</body>
</html>
[/php]
Bonne chance à ceux qui veulent y jeter un coup d'oeil. Et merci à tous
