Jump to content

[SOLVED] Can't locate the problem


Ghettobusta

Recommended Posts

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

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?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.