searching for mysql to html converter

maxywaxy · Jan 8, 2009

I'm looking for a tool/script that creates .html pages for mysql database rows.

So like when you have a database called Food:

england_food is a table which includes:
foodname: foodprice:
1 patatoes 5euro
2 tomates 10 euro
3 bananas 15 euro

The tool or script should create 3 pages automatically with the 3 rows information on each page.

So when I've got like a list of most important citys and countrys i can put those lists in Mysql and the tool/script will create a page for each country with the city for me. And ofcourse this will make unique content this way. Sometimes people have "20.000 pages that I have to upload" I think theyre made this way.

The one that posts the best information gets 2 PR7 backlinks from me if he wants to.

Greetings,

Maxywaxy

Arthas · Jan 8, 2009

here is a rough draft for you:

PHP:

<?php
  $sqlserver = "";
  $sqluser = "";
  $sqlpassword = "";
  $sqldatabase = "";
  $dblink = mysql_connect($sqlserver, $sqluser, $sqlpassword);
  mysql_select_db($sqldatabase) or die(mysql_error() );
  
  $tabledata = mysql_query('SELECT * FROM england_food');
  
  $num = mysql_numrows($tabledata);
if(isset($_REQUEST["next"]) ) {
$i = $_REQUEST["next"];
} else{ $i=0; }
if ($i < $num) {

  $foodname = mysql_result($tabledata,$i,"foodname");
  $foodprice = mysql_result($tabledata,$i,"foodprice");
  echo "$i - $foodname - $foodprice";
  $i++;
  echo "<a href=\"index.php?next=$i\">page$i</a>";
}
  
 ?>

internetNinja · Jan 9, 2009

maxywaxy said:
I'm looking for a tool/script that creates .html pages for mysql database rows.

The tool, my friend is called PHP

Arthas · Jan 9, 2009

lol no wonder i thought my post got deleted above with the code in it. Theres 2 different threads. I made a second script for him and posted it in http://www.blackhatworld.com/blackhat-seo/black-hat-seo/46834-need-sql-html-converter.html

searching for mysql to html converter

maxywaxy

Registered Member

Arthas

BANNED

internetNinja

Junior Member

Arthas

BANNED

Main Menu

Marketplace

Making Money

BlackHat World