Forum Moderators: coopster
Please find PHP code below, I want to create HTML file from Mysql result one row to one HTML file ( below only display ), anyone please recommend how can i do
Thank you
<?php
$mysql_host = 'localhost';
$mysql_user='root';
$mysql_password=;
$mysql_db='account';
if (!$link = mysql_connect($mysql_host,$mysql_user,$mysql_password)) {
echo 'Could not connect to mysql';
exit;
}
if (!mysql_select_db($mysql_db, $link)) {
echo 'Could not select database';
exit;
}
$sql = 'SELECT * FROM account WHERE id = 1001';
$result = mysql_query($sql, $link);
if (!$result) {
echo "DB Error, could not query the database\n";
echo 'MySQL Error: ' . mysql_error();
exit;
}
while ($row = mysql_fetch_assoc($result)) {
echo $row['id'];
echo "<br>";
echo $row['category'];
echo "<br>";
echo $row['employ'];
echo "<br>";
echo "<b>".$row['title']."</b";
echo "<br>";
echo $row['keywords'];
echo "<br>";
echo $row['account'];
}
mysql_free_result($result);
?>
