fetch mysql data and create its page

Question

Please see this code, this code is sending every data that has been entered in the field and then fetching it and showing it on the screen.

i want it to create a new page for every data it fetch,

for example,

suppose a code fetch a text 'ABC' from mysql , i want my code to create a new page for this page called 'ABC.html' and show the link on the screen, this should be done with every fetched data.

example -> http://FBlykes.com

here is my code,

<?php
$name=$_POST['name'];
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("quotes") or die(mysql_error());
?>

<form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="text" name="name">
<input type="submit" value="GO" name="submit">
</form>

<?php
if(isset($_POST['submit'])) 
{
  mysql_query ("INSERT INTO example (name) VALUES('$name')") or die(mysql_error());
}
//Fetching
$query = "SELECT * FROM example ORDER BY id DESC"; 
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
  echo "<li>";
  echo $row['name'];
  echo "</li>";
}
?>

how do i format my code

ajreal
– ajreal

2010-12-26 18:44:13 +00:00
Commented Dec 26, 2010 at 18:44 — ajreal
– ajreal, Commented Dec 26, 2010 at 18:44

Dejan Marjanović · Accepted Answer · 2010-12-26 18:54:09Z

2

Sanitize database input with htmlspecialchars at least. You must use mod_rewrite, in order to generate pages like ABC.html, ABC is in fact a parameter that you pass to PHP script eg page.php?name=ABC...

RewriteRule ^(.*).html$ page.php?name=$1

You should use this rule as last rule if you have other .html pages. PHP script should then fetch "ABC" (whatever it is) from database and print it as HTML page.

answered Dec 26, 2010 at 18:54

Dejan Marjanović

19.4k7 gold badges54 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

fetch mysql data and create its page

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related