transparencia Posted November 17, 2009 Share Posted November 17, 2009 This is my table: id titles 1 TitleA 2 TitleB 3 TitleC I want to show the title text for the URL of a page. Something like: www.website.com/titleA.html Also, within that page, www.website.com/titleA.html, I want to add a link to the next page, www.website.com/titleB.html. How can I do this? Quote Link to comment https://forums.phpfreaks.com/topic/181887-solved-url-php-and-databases/ Share on other sites More sharing options...
JustLikeIcarus Posted November 17, 2009 Share Posted November 17, 2009 Look into Apache mod_rewrite. I think its the direction you will need to go. Quote Link to comment https://forums.phpfreaks.com/topic/181887-solved-url-php-and-databases/#findComment-959306 Share on other sites More sharing options...
JonnoTheDev Posted November 17, 2009 Share Posted November 17, 2009 You use the primary key to identify the page i.e <a href="page.php?id=1">A</a> <a href="page.php?id=2">B</a> <a href="page.php?id=3">C</a> When a user lands on page.php you get the database record to display i.e // page.php $result = mysql_query("SELECT * FROM tablename WHERE id='".mysql_real_escape_string($_GET['id'])."'"); $row = mysql_fetch_assoc($result); print "You are on page: ".$row['title']; To display the links select the records from the database and loop through them Quote Link to comment https://forums.phpfreaks.com/topic/181887-solved-url-php-and-databases/#findComment-959308 Share on other sites More sharing options...
JonnoTheDev Posted November 17, 2009 Share Posted November 17, 2009 If you want to use friendly urls you could structure like /page/titlea/1 /page/titleb/2 /page/titlec/3 as stated mod_rewrite is used for this Quote Link to comment https://forums.phpfreaks.com/topic/181887-solved-url-php-and-databases/#findComment-959314 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.