使用session傳遞資料

啟動session
session_start();

釋放所有變數
session_unset();
session_destroy();

//方法一：直接指定
$_SESSION['data'] = "true";

//方法二：使用陣列變數
$_SESSION['phone'] = array();

while( $i = mysql_fetch_assoc($result) )
{
  $_SESSION['phone'][] = $i['unit'].",".$i['name'].",".$i['ext'];
}

//讀取陣列變數的方法
foreach($_SESSION['phone'] as $value)
{
  $ar = explode(",",$value);
  echo $ar[0].$ar[1].$ar[2];
}

從csv檔讀進資料庫

程式碼：
$db = mysql_connect("ip","account","password");
$db_selected = mysql_select_db("mydb",$db);
mysql_query("SET NAMES 'utf8'");
$file = fopen("mycsv.csv","rb");
while(!feof($file))
{
  $line = fgets($file);
  $line = iconv("big5","utf-8",$line);
  $tmp = explode(",",$line);
  $sql = "INSERT INTO data (data1,data2,data3) VALUES ('$tmp[0]','$tmp[1]','$tmp[2]')";
  mysql_query($sql,$db);
}
mysql_close($db);

csv檔由xls檔另存新檔成csv(逗號分隔)，即可直接匯入。