Gegevens uit database halen lukt niet

Door Lars Mennen op 29-09-2009 21:29

1.143 views

Hallo,

Ik wil bij iedere pagina de content uit een database halen.
Toch laat hij bij iedere pagina de content van "Home" (de eerste pagina) zien.

Dit is het stuk PHP:

<?php
						if (isset($_GET['p']) == 'Home'){
                            $output = mysql_query("SELECT * FROM music_posts WHERE post_title='Home' AND post_type='page'");
							$tekst = mysql_fetch_array($output);
						
							echo $tekst['post_content'];
							}
						elseif (isset($_GET['p']) == 'Agenda'){
							$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Agenda' AND post_type='page'");
							$tekst = mysql_fetch_array($output);
						
							echo $tekst['post_content'];
							}
						elseif (isset($_GET['p']) == 'Biografie'){
							$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Biografie' AND post_type='page'");
							$tekst = mysql_fetch_array($output);
						
							echo $tekst['post_content'];
							}
						elseif (isset($_GET['p']) == 'Fotos'){
							$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Fotos' AND post_type='page'");
							$tekst = mysql_fetch_array($output);
						
							echo $tekst['post_content'];
							}
						elseif (isset($_GET['p']) == 'Repertoire'){
							$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Repertoire' AND post_type='page'");
							$tekst = mysql_fetch_array($output);
						
							echo $tekst['post_content'];
							}
						elseif (isset($_GET['p']) == 'Gastenboek'){
							$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Gastenboek' AND post_type='page'");
							$tekst = mysql_fetch_array($output);
						
							echo $tekst['post_content'];
							}
						elseif (isset($_GET['p']) == 'Links'){
							$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Links' AND post_type='page'");
							$tekst = mysql_fetch_array($output);
						
							echo $tekst['post_content'];
							}
						elseif (isset($_GET['p']) == 'Contact'){
							$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Contact' AND post_type='page'");
							$tekst = mysql_fetch_array($output);
						
							echo $tekst['post_content'];
							}
						else {
							$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Home' AND post_type='page'");
							$tekst = mysql_fetch_array($output);
						
							echo $tekst['post_content'];
							}
							
					?>

En dit het menu:

            	<ul class="Uitgeklapt">
                
					<li><a href="#" class="Inklappen"><img id="PijlRechts" src="images/PijlRechts.png" alt="Pijl naar rechts" /></a></li>
            		<li class="cufon"><a href="index.php?p=Home">Home</a></li>
            		<li class="cufon"><a href="index.php?p=Agenda">Agenda</a></li>
            		<li class="cufon"><a href="index.php?p=Biografie">Biografie</a></li>
            		<li class="cufon"><a href="index.php?p=Fotos">Foto’s</a></li>
            		<li class="cufon"><a href="index.php?p=Repertoire">Repertoire</a></li>
            		<li class="cufon"><a href="index.php?p=Gastenboek">Gastenboek</a></li>
            		<li class="cufon"><a href="index.php?p=Links">Links</a></li>
            		<li class="cufon"><a href="index.php?p=Contact">Contact</a></li>
            	</ul>

Ziet iemand het probleem of weet iemand de oplossing?
Bij voorbaat dank!

Larsm.

- SanThe -

29-09-2009 22:09

if (isset($_GET['p']) == 'Home'){

Hier staat eigenlijk dit al naar gelang of de GET is geset.

if(true == 'home'){ of if(false == 'home'){

Je bedoelt waarschijnlijk dit:
if (isset($_GET['p']) and $_GET['p'] == 'Home'){

Yearupie Achternaamloos

29-09-2009 22:19

Het is onzin om 10x te kijken of $_GET['p'] bestaat...


<?php
if (isset($_GET['p'])){
	if ($_GET['p'] == 'Home'){
		$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Home' AND post_type='page'");
		$tekst = mysql_fetch_array($output);
		
		echo $tekst['post_content'];
	}
	elseif ($_GET['p'] == 'Agenda'){
		$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Agenda' AND post_type='page'");
		$tekst = mysql_fetch_array($output);
		
		echo $tekst['post_content'];
	}
	elseif ($_GET['p'] == 'Biografie'){
		$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Biografie' AND post_type='page'");
		$tekst = mysql_fetch_array($output);
		
		echo $tekst['post_content'];
	}
	elseif ($_GET['p'] == 'Fotos'){
		$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Fotos' AND post_type='page'");
		$tekst = mysql_fetch_array($output);
		
		echo $tekst['post_content'];
	}
	elseif ($_GET['p'] == 'Repertoire'){
		$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Repertoire' AND post_type='page'");
		$tekst = mysql_fetch_array($output);
		
		echo $tekst['post_content'];
	}
	elseif ($_GET['p'] == 'Gastenboek'){
		$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Gastenboek' AND post_type='page'");
		$tekst = mysql_fetch_array($output);
		
		echo $tekst['post_content'];
	}
	elseif ($_GET['p'] == 'Links'){
		$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Links' AND post_type='page'");
		$tekst = mysql_fetch_array($output);
		
		echo $tekst['post_content'];
	}
	elseif ($_GET['p'] == 'Contact'){
		$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Contact' AND post_type='page'");
		$tekst = mysql_fetch_array($output);
		
		echo $tekst['post_content'];
	}
	else {
		$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Home' AND post_type='page'");
		$tekst = mysql_fetch_array($output);
		
		echo $tekst['post_content'];
	}
}
else {
	$output = mysql_query("SELECT * FROM music_posts WHERE post_title='Home' AND post_type='page'");
	$tekst = mysql_fetch_array($output);
	
	echo $tekst['post_content'];
}
?>

- SanThe -

29-09-2009 22:30

Een switch() is nog netter. En dan alleen de sql in een variabele zetten. Na de switch pas de query uitvoeren inclusief foutafhandeling en dan als laatste de echo.

J Jan Willem van der Veer

30-09-2009 09:09

Waarom niet gewoon zo:
<?php
$aPossiblePages = Array('Links', 'Biografie', 'Agenda', 'Fotos', 'Repetoire', 'Gastenboek', 'Contact');
$sPage = 'Home';

if(isset($_GET['p']) && in_array($_GET['p'], $aPossiblePages)) $sPage = $_GET['p'];

if(($rMusicPost = mysql_query('SELECT * FROM music_posts WHERE (post_title=\''.$sPage.'\') AND (post_type=\'page\')')) && (mysql_num_rows($rMusicPost) == 1)){
$aTekst = mysql_fetch_array($rMusicPost);
echo $aTekst['post_content'];
}
?>

Een heel stuk korter... Daarnaast is die switch ook gewoon geen goed idee..

Reageren

Inloggen om te reageren