PHP and MYSQL
If you r a professional web egineer, its a essential ability that you can master proficient
PHP and mysql programming.
Before I learned some ASP web programming,so learning PHP programming will be easy.
To output CDR data from mysql database to CSV format,So I got some php functions.
Such as:
＄db = mysql_connect(”localhost”, ”root”,”password”);
mysql_select_db(”mydb”,＄db);
if (＄id) {
// 查询数据库
＄sql = ”SELECT * FROM employees WHERE id=＄id”;
＄result = mysql_query(＄sql);
＄myrow = mysql_fetch_array(＄result);
}
The following is my program about CDR collecting:
＄dfname=”cdr_csv.csv”;
＄db = mysql_connect(”219.103.134.210″,”vlinms”, ”nmsadmin”);
mysql_select_db(”cdrdb”,＄db);
＄sql=”select * from galg001 where lTimeRing > 1148256000 and
((szSource > 000357840000 and szSource t > 000357840000 and szDest
＄result = mysql_query(＄sql,＄db);
＄i = 0;
＄j= 1;
header(”Content-disposition: filename=＄dfname”);
header(”Content-type: unknown/unknown”);
while(＄cdrrow = mysql_fetch_row(＄result))
{
if(＄cdrrow[9]){ ＄cdrrow[9] = date(”Y-m-d h:i:s”,”＄cdrrow[9]“);};
if(＄cdrrow[10]){ ＄cdrrow[10] = date(”Y-m-d h:i:s”,”＄cdrrow[10]“);};
if(＄cdrrow[11]){＄cdrrow[11] = date(”Y-m-d h:i:s”,”＄cdrrow[11]“);};
if(＄i {
＄cdrrow[＄i]=str_replace(”\”",”\”\”",＄cdrrow[＄i]);
＄i++;
}
echo base64_decode(”DQo=”.”\”＄cdrrow[5]\”,\”＄cdrrow[7]\”,\”＄cdrrow[9]\”,\”＄cdrrow[10]\”,\”＄cdrrow[11]\”,\”＄cdrrow[1
3]\”,\”＄cdrrow[2]\”";
＄j++;
＄i=0;
}
?>
Tags: mysql, PHP