Ghettobusta Posted April 16, 2007 Share Posted April 16, 2007 This is the website: http://cogito.labos.polymtl.ca/~ti317/TS2/ But the list is suppose to show topics like this website: http://cogito.labos.polymtl.ca/~ti309/TS2/ I don't know why it's not working... This is my index.php code: <form action="consulter.php" method="POST"> <p id="text"> <select name="sujet"> <?php //------------------------------ // Connexion à la base de donnée $adresse_serveur='localhost'; $compte_mysql='tixxx'; $mot_de_passe_mysql='MEC1310'; $lien_bd=mysql_connect($adresse_serveur, $compte_mysql, $mot_de_passe_mysql); if (!$lien_bd) {print("<strong>Impossible de se connecter au serveur MySQL: </strong>" . mysql_error()); exit();} //------------------------------ // Sélection de la base de donnée $nom_bd='TS2_H07'; if (!mysql_select_db($nom_bd, $lien_bd)) {print("<strong>Impossible d'utiliser la base de données $nom_bd : </strong>" . mysql_error()); exit();} //------------------------------ // Exécution de la requête sur une base de donnée précise $requete='SELECT Sujets.texte, CONCAT(Sujets.id,". ",Sujets.texte) AS Sujet FROM Sujets ORDER BY Sujets.date DESC'; $resultat=mysql_query($requete, $lien_bd); if (!$resultat) {print("<strong>Erreur lors du traitement de la requête : </strong>" . mysql_error()); exit();} //------------------------------ // Récupération des données if (mysql_num_rows($resultat) > 0) { while ($enregistrement = mysql_fetch_array($resultat)) {print "<option>.$enregistrement['Sujets.texte'].</option>\n";}}?> </select><br> <input type="submit" value="Envoyer"/> </p> </form> And this is my consulter.php (which probably contains multiple bugs): <?php //------------------------------ // Connexion à la base de donnée $adresse_serveur=localhost'; $compte_mysql='tixxx'; $mot_de_passe_mysql='MEC1310'; $lien_bd = mysql_connect($adresse_serveur, $compte_mysql, $mot_de_passe_mysql); if (!$lien_bd) {print("<strong>Impossible de se connecter au serveur MySQL: </strong>" . mysql_error()); exit();} //------------------------------ // Sélection de la base de donnée $nom_bd='H2007'; if (!mysql_select_db($nom_bd, $lien_bd)) {print("<strong>Impossible d'utiliser la base de données $nom_bd : </strong>" . mysql_error()); exit();} //------------------------------ // Exécution de la requête sur une base de donnée précise $requete='SELECT Commentaires.texte, Usagers.nom, Commentaires.date FROM Sujets, Commentaires, Usagers WHERE CONCAT(Sujets.id,". ",Sujets.texte)="'.$_POST[sujet].'" AND Sujets.id=Commentaires.id AND Usagers.id=Sujets.id'; $resultat=mysql_query($requete, $lien_bd); if (!$resultat) {print("<strong>Erreur lors du traitement de la requête : </strong>" . mysql_error()); exit();} print "<table>\n"; print "<tr><td><h1>".$_POST[sujet]."</h1></td></tr>"; print "</table>\n"; //------------------------------ // Récupération des données if (mysql_num_rows($resultat) == 0) {print "<tr><td><em>Aucun enregistrement...</em><br />\n</td></tr>";} else {print "<table>\n"; print "<tr>"; print "<th>Commentaires</th>"; print "<th>Utilisateur</th>"; print "<th>Date</th>"; print "</tr>\n"; print "<tr>"; while ($enregistrement = mysql_fetch_array($resultat)) {print "<td>".$enregistrement['Commentaires.texte']."</td>"; print "<td>".$enregistrement['Usagers.nom']."</td>"; print "<td>".$enregistrement['Commentaires.date']."</td>"; print "</tr>\n";} print "</table>\n";}?> I need help!!! Thx in advance! Link to comment https://forums.phpfreaks.com/topic/47293-solved-cant-locate-the-problem/ Share on other sites More sharing options...
Barand Posted April 16, 2007 Share Posted April 16, 2007 It's your first post so I don't want to be too harsh but put yourself in our position. We see code that we can't run ourselves, as that needs your database, and the only clue we have is that is doesn't work. So could you please define "not working". What isn't it doing that it should do? What is it doing that it shouldn't do? Link to comment https://forums.phpfreaks.com/topic/47293-solved-cant-locate-the-problem/#findComment-230792 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.