Menu
Community /Pin to ProfileBookmark
@NogDogJul 04.2008 — #The page is dynamically generated each time it is requested by querying the DB for the necessary data. For example, the content you see displayed on this page right now does not exist anywhere as a file. All that exists is the "showthread.php" file. Each time that file is called, based on the various input paramters it receives in the URL, it queries the database and generates the output "on the fly". @NogDogJul 04.2008 — #Here's a simple example. It looks for a "page" value in the url query string, e.g. "http://example.com/showpage.php?page=3 ". It's obviously very bare-bones with minimal error-handling. (And I'm sure there's at least one typo in there somewhere.)
@NogDogJul 04.2008 — #Because that's how the $_GET super-global array works: each [b]name=value[/b] pair in the URL query string is assigned to an element of that array. So the URL "http://example.com/sample.php?user=123&page=5&style=2 " would populate the $_GET array as if you had programmed it as:
It's the same as if you had submitted a HTML form using [b]method="get"[/b]. (When you submit a form using [b]method="post[/b] then the same thing happens, except the values are stored in $_POST instead of $_GET.)
See[url=http://www.php.net/manual/en/language.variables.external.php]Variables From External Sources[/url] in the manual for more info.@NogDogJul 04.2008 — #
The "URL query string" is the (optional) part of a URI which follows a "?" and precedes any "#". So in this URI...
@NogDogJul 04.2008 — #Note that my sample code was assuming a hypothetical content database named "db_name" with a table named "table_name" with (at least) 3 fields: "page" (an integer and the primary key), "title", and "description".
If it's still all Greek to you (no offense intended to any Greek members, it's just an expression ? ), it's time to buy a book, perhaps, so that you can follow the process step by step.
Generating HTML Pages With Database Content
How exactly do you generate a new HTML page with database content when your database is updated?
Sign in
to post a comment19 Comments(s) ↴
0
@NogDogJul 04.2008 — #0
@NogDogJul 04.2008 — #Here's a simple example. It looks for a "page" value in the url query string, e.g. "[code=php]
<html><head><title>Test</title></head><body>
<h1>This title always prints</h1>
<?php
if(!empty($_GET['page']))
{
mysql_connect('localhost', 'user', 'password') or die(mysql_error());
mysql_select_db('db_name') or die(mysql_error());
$sql = "SELECT * FROM table_name WHERE page = " . (int)$_GET['page'];
$result = mysql_query($sql) or die(mysql_error());
if(($row = mysql_fetch_assoc($result)) !== false)
{
echo "<h2>" . htmlentities($row['title']) . "</h2>n";
echo "<p>" nl2br(htmlentities($row['content'])) . "</p>n";
}
else
{
echo "<p class='error'>Invalid page specified.</p>n";
}
}
else
{
?>
<p>This only gets displayed if no page was specified in URL.</p>
<?php
}
?>
</body>
</html>
[/code]0
@NogDogJul 04.2008 — #Because that's how the $_GET super-global array works: each [b]name=value[/b] pair in the URL query string is assigned to an element of that array. So the URL "[code=php]
$_GET = array(
'user' => 123,
'page' => 5,
'style' => 2
);
[/code]It's the same as if you had submitted a HTML form using [b]method="get"[/b]. (When you submit a form using [b]method="post[/b] then the same thing happens, except the values are stored in $_POST instead of $_GET.)
See
0
@NogDogJul 04.2008 — #What exactly do you mean by "URL query?"[/QUOTE]
The "URL query string" is the (optional) part of a URI which follows a "?" and precedes any "#". So in this URI...
<i>
</i>http://www.example.com/directory/page.php?[color=red]var1=one&var2=two[/color]#part2
0
@NogDogJul 04.2008 — #Note that my sample code was assuming a hypothetical content database named "db_name" with a table named "table_name" with (at least) 3 fields: "page" (an integer and the primary key), "title", and "description".If it's still all Greek to you (no offense intended to any Greek members, it's just an expression ? ), it's time to buy a book, perhaps, so that you can follow the process step by step.