[program-l] Re: Generating Multiple Webpages in one Webpage with PHP
- From: "Homme, James" <james.homme@xxxxxxxxxxxx>
- To: "program-l@xxxxxxxxxxxxx" <program-l@xxxxxxxxxxxxx>
- Date: Mon, 29 Oct 2012 13:42:29 +0000
Hi Edgar,
You need another else at the bottom of your if statement. In other words, if
none of the conditions are true ...
Jim
-----Original Message-----
From: program-l-bounce@xxxxxxxxxxxxx [mailto:program-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Edgar Lozano
Sent: Monday, October 29, 2012 7:59 AM
To: program-l@xxxxxxxxxxxxx
Subject: [program-l] Generating Multiple Webpages in one Webpage with PHP
Hi,
I believe that I've inquired about this topic once, but I have not revisited
the specific script to modify it.
But if someone could please answer this e-mail again, I would greatly
appreciate it.
Anyway, my main goal is to ccreate a PHP page that will generate different
webpages according to ID entries in a MySQL database.
I've completed the majority of the script, but my main issue is displaying the
title for the main page itself!
For example, when generating webpages for existing entries in a MySQL table,
the script successfully displays a title for its corresponding ID, but for some
reason, it won't display a title for the main page itself, as I tried to do
with conditional statements.
Code is as follows:
<?php
$servername = "server";
$serveruser = "user";
$serverpassword = "password";
$connect = mysql_connect($servername, $serveruser, $serverpassword); $db =
mysql_select_db("database", $connect); ?> <!DOCTYPE HTML> <html lang='en-US'>
<head> <?php $query = mysql_query("SELECT * FROM table WHERE ID='$_GET[id]'");
while($row = mysql_fetch_array($query)) {
if(!isset($_GET['id']))
{
echo "<title>Archives</title>";
}
else
{
if($_GET['id'] == $row['ID'])
{
echo "<title>".$row['title']." - RealRandomRadio Archives</title>"; } } } ?>
<link rel='stylesheet' type='text/css' href='css.css' /> </head> <body> <div
id='wrapper'> <?php include("header.php"); ?> <div id='main_section'> <aside
id='main_aside'> <p> Content for main page goes here.
</p>
<?php
$query = mysql_query("SELECT * FROM table WHERE ID='$_GET[id]'"); while($row =
mysql_fetch_array($query)) { if($_GET['id'] == $row['ID']) { $sql = "UPDATE
table SET `listeners` = `listeners`+1 WHERE ID='" . $row['ID'] . "'";
mysql_query($sql); echo "
<p>
You are currently listening to ".$row['title'].".<br> A short description is as
follows:<br> ".$row['description']."<br> We hope you enjoy this episode.<br> So
far, ".$row['listeners']." have listened to this episode.
</p>
<script type='text/javascript' src='playsound.js' /> </script> <embed src='" .
$row['url'] . "' autostart=true enablejavascript=true id='mc1' /> "; } } $query
= mysql_query("SELECT * FROM table while($row = mysql_fetch_array($query)) {
$id = $row['ID']; $title = $row['title']; $description = $row['description'];
$date = $row['date']; $url = $row['url']; $listeners = $row['listeners']; echo "
<h2><a
href='http://www.realrandomradio.com/archives/index.php?id=".$id.";'>".$title."</a></h2>
<p>
".$date."<br>
".$description."</p>
";
}
?>
</div>
<?php include("footer.php"); ?>
</div>
</body>
</html>
That is my entire code for an archives page that I'm creating for my website.
I believe someone mentioned me using MySQLI instead of MySQL, but I want to
find out the issue with this script first, and then I'll switch to better
programming practices.
I really appreciate all the help that I get.
--
Thanks for reading.
Have a good day.
If you ever get the chance, go to http://www.realrandomradio.com and check us
out.
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
________________________________
This e-mail and any attachments to it are confidential and are intended solely
for use of the individual or entity to whom they are addressed. If you have
received this e-mail in error, please notify the sender immediately and then
delete it. If you are not the intended recipient, you must not keep, use,
disclose, copy or distribute this e-mail without the author's prior permission.
The views expressed in this e-mail message do not necessarily represent the
views of Highmark Inc., its subsidiaries, or affiliates.
Nï^jïïïïbïï%ïï(ïï^ïiïv&ïz\ïïYhï)ïï)äïïïkï
ÚZÞçïïzXïïï+ïËïï-
Other related posts:
