i have excel file gets data webquery , want read data, insert mysql database. unable write mysql database using following code. ideas?
<?php $db_host = "localhost";$db_user = "root";$db_pass = "";$db_name ="report";$db_table = "test"; require '/phpexcel/classes/phpexcel.php'; require_once '/phpexcel/classes/phpexcel/iofactory.php'; $objphpexcel = phpexcel_iofactory::load('refreshables.xlsx'); foreach ($objphpexcel->getworksheetiterator() $worksheet) { $worksheettitle = $worksheet->gettitle(); $highestrow = $worksheet->gethighestrow(); // e.g. 10 $highestcolumn = $worksheet->gethighestcolumn(); // e.g 'f' $highestcolumnindex = phpexcel_cell::columnindexfromstring($highestcolumn); $nrcolumns = ord($highestcolumn) - 64; $link = mysql_connect($db_host,$db_user,$db_pass); if(!$link) die ('could not connect database: '.mysql_error()); mysql_select_db($db_name,$link); ($row = 2; $row <= $highestrow; ++ $row) { $val=array(); ($col = 0; $col < $highestcolumnindex; ++ $col) { $cell = $worksheet->getcellbycolumnandrow($col, $row); $val[] = $cell->getvalue(); } $sql = "insert 'test' (appname, device_full_name, app_type, carrier, language, version, status, platform, project_type, base_device, build_type, project_id) values('".$val[0]."', '".$val[1]."', '".$val[2]."','".$val[3]."', '".$val[4]."', '".$val[5]."','".$val[6]."', '".$val[7]."', '".$val[8]."','".$val[9]."', '".$val[10]."', '".$val[11]."')"; mysql_query($sql); } } mysql_close($link); ?>
change
$sql = "insert 'test' (appname,... ^ ^ don't use quotes in table or column names to
$sql = "insert `test` (appname,... or without ticks
$sql = "insert test (appname,... 
Comments
Post a Comment