xlc mysql_excel表数据导入到mysql数据库中(自己做的练习保留)

//header("Content-Type:text/html;charset=gb2312");

include_once 'libs/database.class.php';

include_once 'libs/bb.model.php';

class Excel extends Base_Model

{

public function __construct()

{

parent::__construct();

//$this->run();

//链接数据库,普通数据库链接

/*$connect = mysql_connect('localhost','root','');

mysql_select_db('xlc_webgame',$connect);*/

}

public function run()

{

header("Content-Type:text/html;charset=gb2312");

$handle=fopen("caixia.csv","r");

$bigArr = array();

$row=0;

$sqltotal;

while($res=fgetcsv($handle,1000,","))

{

$use = array();

$effect = array();

$hparr = array();

$mparr = array();

$condition = array();

//$res = explode(',',$val);

//$res[4] = trim(mb_convert_encoding($res[4], 'utf-8', 'gbk'));

//$res[1] = trim(mb_convert_encoding($res[1], 'utf-8', 'gbk'));*/

for($i = 0; $i < 4; $i++)

{

if(empty($res[$i]))

{

$res[$i] = 0;

}

}

if(empty($res[8])){

$res[8] = 0;

}

if(empty($res[12])){

$res[12] = 0;

}

if(empty($res[13])){

$res[13] = 0;

}

if($res[9]){

$use['MP'] = $res[9];

}

if($res[10]){

$use['EG'] = $res[10];

}

if($res[11]){

$use['HP'] = $res[11];

}

if($use){

$s_use = serialize($use);

}else{

$s_use = '';

}

//作用

if($res[21]){

$effect['m_sb'] = $res[21];

}

if($res[22]){

$effect['m_sp'] = $res[22];

}

if($res[23]){

$effect['m_wf'] = $res[23];

}

if($res[24]){

$effect['m_mf'] = $res[24];

}

if($res[25]){

$effect['m_wg'] = $res[25];

}

if($res[26]){

$hparr['s'] = $res[26];

}

if($res[27]){

$hparr['b'] = $res[27];

}

if($hparr){

$effect['m_hp'] = $hparr;

}

if($res[28]){

$mparr['s'] = $res[28];

}

if($res[29]){

$mparr['b'] = $res[29];

}

if($mparr){

$effect['m_mp'] = $mparr;

}

if($res[30]){

$effect['DEF'] = $res[30];

}

if($res[31]){

$effect['ATK'] = $res[31];

}

if($res[32]){

$effect['MAT'] = $res[32];

}

if($res[33]){

$effect['MDF'] = $res[33];

}

if($res[34]){

$effect['SPD'] = $res[34];

}

if($res[35]){

$effect['success'] = $res[35];

}

if($res[36]){

$effect['round'] = $res[36];

}

if($effect){

$s_effect = serialize($effect);

}else{

$s_effect = '';

}

if($res[14]){

$condition['CON'] = $res[14];

}

if($res[15]){

$condition['STR'] = $res[15];

}

if($res[16]){

$condition['INT'] = $res[16];

}

if($res[17]){

$condition['WIN'] = $res[17];

}

if($res[18]){

$condition['DEX'] = $res[18];

}

if($res[19]){

$condition['LEVEL'] = $res[19];

}

if($condition){

$s_condition = serialize($condition);

}else{

$s_condition = '';

}

$s_detail = '';

if($res[7]){

$s_detail = $res[7];

}

if($res[5]){

$s_detail .= $res[5];

}

if($row > 0)

{

mysql_query("set names 'gbk'"); //解决汉字乱码问题

$bigArr[$row] = $res;

$sql = "INSERT INTO `xlc_webgame`.`wg_skill`

(`s_p_id`,`s_type`,`s_type2`,`s_d_q`,`s_name`,`name_detail`,`s_url`,`s_profession_id`,`s_use`,`s_effect`,`s_hurt_min`,`s_hurt_max`,`s_condition`,`s_detail`)

VALUES

($res[0],$res[1],$res[2],$res[3],'".$res[4]."','".$res[5]."','".$res[20]."',$res[8],'".$s_use."','".$s_effect."',$res[12],$res[13],'".$s_condition."','".$s_detail."')";

$t = $this->db->query($sql);

//mysql_query($sql);

//$sqltotal .= $sql."
";

}

$row++;

}

echo '成功插入数据库';

}

}