doodnom

Hi Guys,

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_passw ord)) {
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);
?>

__________________
Spain Hotels
asian cooking

pelinga

you can use
$lines = file('http://www.example.com/');
see more at
http://www.php.net/file

__________________

jumpenjuhosaphat

Do you mean that you want to write an HTML file base off of the results of a MySQL query? As in writing a physical file called example.html?

__________________
Storage Sheds
Lost Forum

_torero_

can somebody BAN this spammer is like the 3rd time he posts the same

__________________
Free Link Exchange - Los Optimizadores - Posicionamiento Web
diseño Web - Web Design Templates

_torero_

yes you can just write plain HTML or whatever you like into any file in the system so long you have write priviledges. you can just use fwrite, or even a temp file for temporary storage.

Once you have your strings ready, just use:

<?php
$filename = 'test.txt';
$somecontent = "Add this to the file\n";

// Let's make sure the file exists and is writable first.
if (is_writable($filename)) {

// In our example we're opening $filename in append mode.
// The file pointer is at the bottom of the file hence
// that's where $somecontent will go when we fwrite() it.
if (!$handle = fopen($filename, 'a')) {
echo "Cannot open file ($filename)";
exit;
}

// Write $somecontent to our opened file.
if (fwrite($handle, $somecontent) === FALSE) {
echo "Cannot write to file ($filename)";
exit;
}

echo "Success, wrote ($somecontent) to file ($filename)";

fclose($handle);

} else {
echo "The file $filename is not writable";
}
?>

cheers

__________________
Free Link Exchange - Los Optimizadores - Posicionamiento Web
diseño Web - Web Design Templates

4e4en

i dont understand anything

you can try to $rows=explode($str,"\r\n");