Show data using ID

**queerfm** · 03-14-2008, 01:58 PM

Hi i have a database called funny the table is called jokes
in there i have a list of jokes all done by ID

i need a way to fetch them like
joke number 1

i would it to show in the address bar something like this
http://www.mywebsite.com/joke.php?ID=1

or
http://www.mywebsite.com/TitleOfJoke

and i need to figger out how to show that joke on the page

Thanks

**NXArmada** · 03-14-2008, 03:42 PM

http://www.php-mysql-tutorial.com/

Has alot of good MySQL and PHP tutorials. I suggest you check them out. If you still have problems post back here.

Remember Google is your friend.

Code:

$id = $_GET["id"];

Code:

$sql = "SELECT * FROM jokes WHERE id = $id";

**Nile** · 03-14-2008, 03:45 PM

Correction to your code...

Code:

$sql = "SELECT * FROM jokes WHERE id = $id" limit 0,1";

**queerfm** · 03-15-2008, 05:50 AM

Thank you for the help, however it seems not to be working?

This is my PHP code

Code:

<?php
include 'include/config.php';
include 'include/opendb.php';

$id = $_GET["id"];
$sql = "SELECT * FROM podcast WHERE id = $id";
$result = mysql_query($query);

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
    echo "Name :{$row['ID']} <br>" .
         "Subject : {$row['podcastname']} <br>" .
         "Message : {$row['xmllink']} <br><br>";
} 

include 'include/closedb.php';

?>

**queerfm** · 03-16-2008, 02:15 PM

I found this code but its not working PLZ help

Code:

<HTML>
<?php
$db = mysql_connect("localhost", "USERNAME", "PASSWORD");
mysql_select_db("twitoo",$db);
$result = mysql_query("SELECT * FROM podcast WHERE id=$id",$db);
$myrow = mysql_fetch_array($result);
echo "First Name: ".$myrow["firstname"];
echo "<br>Last Name: ".$myrow["lastname"];
echo "<br>Nick Name: ".$myrow["nick"];
echo "<br>Email address: ".$myrow["email"];
echo "<br>Salary: ".$myrow["salary"];
?>
</HTML>

Edit: Mod Edit: Took out db username and password. Please do not post this information in future posts.

**queerfm** · 03-16-2008, 02:20 PM

Got It Working

**Nile** · 03-16-2008, 02:21 PM

Try this:

Code:

<HTML>
<?php
$db = mysql_connect("localhost", "USERNAME", "PASSWORD");
mysql_select_db("twitoo",$db);
$result = mysql_query("SELECT * FROM podcast WHERE id=$id")or die(mysql_error());
$myrow = mysql_fetch_array($result);
echo "First Name: $myrow['firstname']";
echo "<br>Last Name:$myrow['lastname']";
echo "<br>Nick Name: $myrow['nick']";
echo "<br>Email address: $myrow['email']";
echo "<br>Salary: $myrow['salary']";
?>
</HTML>

**queerfm** · 03-16-2008, 02:54 PM

Hey i need some more help Sorry

I have this code that use to fetch the xml file from a URL however now that i have everything in the MySQL i need to make it also have the ?id=1 fuction

Code:

<?php

/*
You can use this script to pass-through a playlist from an external server to the players. 
Just insert the url to external playlist below and copy this file to your server.
You can use the flashvar "file=external_feed.php" in your HTML feed this script to the player.
*/


// build file headers
header("content-type:text/xml;charset=utf-8");
// refer to file
readfile("http://www.abc.net.au/tv/enoughrope/podcast.xml");
// that's all
exit();


?>

If you can help Thank you so much

**Nile** · 03-16-2008, 03:26 PM

I don't get what you want. o¿o

**queerfm** · 03-16-2008, 03:36 PM

I would like to replace http://www.abc.net.au/tv/enoughrope/podcast.xml with what every the xml URL is in the MySQL

so it would look like something like this
http://www.mysite.com/xml.php?id=1

Code:

<?php

/*
You can use this script to pass-through a playlist from an external server to the players. 
Just insert the url to external playlist below and copy this file to your server.
You can use the flashvar "file=external_feed.php" in your HTML feed this script to the player.
*/


// build file headers
header("content-type:text/xml;charset=utf-8");
// refer to file
readfile("{$row['xmlURL']}");
// that's all
exit();


?>

Thanks

Thread: Show data using ID

Thread Tools

Search Thread

Show data using ID

The Following User Says Thank You to Nile For This Useful Post:

Bookmarks

Bookmarks

Posting Permissions