covert text file to MySql Database

covert text file to MySql Database
COntoh Kode dari MySQL Code 1:
1) ‘Codemaster’|’Mohd Izzairi’|’Xyiry’|’Yamin’|’Xyiry Technologies’|’CakePHP’
2) ‘Codemaster’,’Mohd Izzairi’,’Xyiry’,’Yamin’,’Xyiry Technologies’,’CakePHP’
1) baca text file
$file = “/convert/xyiry.txt”; //lokasi file di folder convert
$fp = fopen($file, “r”);
$data = fread($fp, filesize($file));
fclose($fp);
(2) trus pencarian lokasi TAB untuk carakter ( “|” atau “,”)
$output = str_replace(“\t|\t”, “|”, $data);
(3) Penggunaan  function explode utk memecah setiap line break
$output [...]

TEX FILE FROM MYSQL

contoh Function Write TXT from MySQL
function write_txt()
{  $sql = “SELECT aircraf_id,aircraf_registration
FROM tgfis_aircraf “;
$dbc = dbQuery($sql);
if (mysql_num_rows($dbc) >= 1) {
while ($row = mysql_fetch_array($dbc)) {
$reg_id=$row['aircraf_id'];
$reg_reg=$row['aircraf_registration'];
$fp = fopen(“convert/agus.txt”, “a”);
//untuk penggunaan table
fputs($fp, “<table border=0 width=450><tr><td width=130><font face=verdana size=1><b>ID:</b></font></td><td width=320><font face=verdana size=1>”.$reg_id.”</font></td></tr>”);
fputs($fp, “<tr><td><font face=verdana size=1><b>Email:</b></font></td><td><font face=verdana size=1>”.$reg_reg . “</font></td></tr>”);
fputs($fp, “</table><br>”);
//untuk menggunakan tanda ‘|’ or ‘,’
$linebrake   =”ID flight : $reg_id | [...]