HOME       >>       Programming



Okay, I have a php question. After I SELECT from a mysql table, how to I put that data into a new section of a php file, that hasn't been written yet. Like, ?page=3 and 4 gets made when row four gets entered into the table. Please help if you understand. Thanks,Tim


I'm sorry but I can't understand.

A php file is not divided in section like 'page=1 page=2 etc'
It's simply a way to create more pages by one.
You can put a switch on $_GET['page'] and do something like that:

switch($_GET['page']){case 1:echo 'page 1';break;case 2:echo 'page 2';break;case 3:echo 'page 3';//Here you can put your mysql query and retrieve resultsbreak;}


i would do it some what like this:

<?php//MYSQL Settings$db = mysql_connect("localhost", "username", "password");mysql_select_db("database_name", $db) or die("Could not connect to the database." . mysql_error());$page= $_GET['page'];if(!isset($page)){// You can put a custom error message here, // or you can place some default content that your members will see // if they dont put a page id in the url.}$query = "SELECT * FROM data WHERE id = '$page'";$result = mysql_query($query);echo "<html><head><title>Your Page Title Here</title></head><body><table width='100%'><tr><td>$result</td></tr></table></body></html>";};?>

the code will look different depending on your database structre, you will need to add the right info for your database login and the database name, and you will need to change the table data in the mysql query to match you table. and you can change the layout of the page by editing the html code in the post, you will just have to make sure that $result is in there some where so that it will display what is pulled from the database. If you need any help just let me know


Xisto.com offers Free Web Hosting to its Members for their participation in this Community. We moderate all content posted here but we cannot warrant full correctness of all content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 2001-2019 by Xisto Corporation. All Rights Reserved.