Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function convert($string)
- {
- return htmlspecialchars($string,ENT_QUOTES);
- }
- $columnArray = array();
- $dataArray = array();
- $firstRule = true;
- while ($data = fgetcsv ($source, 1000, ","))
- {
- if($firstRule)
- {
- foreach($data as $columnName)
- {
- $columnArray[] = $columnName;
- }
- $firstRule = false;
- }
- else
- {
- $rule = array();
- for($i = 0; $i < count($data) ; $i++)
- {
- $rule[$columnArray[$i]] = $data[$i];
- }
- $dataArray[] = $rule;
- }
- }
- foreach($dataArray as $data)
- {
- $query = "INSERT INTO `tran_detail` (".implode('`,`', array_keys($data))."`) VALUES('".implode('','', array_map("convert",array_values($data)))."')";
- mysql_query($query) or mysql_error();
- }
- fclose($source);
Add Comment
Please, Sign In to add comment