Guest User

Untitled

a guest
Nov 23rd, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. function convert($string)
  2. {
  3. return htmlspecialchars($string,ENT_QUOTES);
  4. }
  5.  
  6. $columnArray = array();
  7. $dataArray = array();
  8. $firstRule = true;
  9.  
  10. while ($data = fgetcsv ($source, 1000, ","))
  11. {
  12. if($firstRule)
  13. {
  14. foreach($data as $columnName)
  15. {
  16. $columnArray[] = $columnName;
  17. }
  18.  
  19. $firstRule = false;
  20. }
  21. else
  22. {
  23. $rule = array();
  24. for($i = 0; $i < count($data) ; $i++)
  25. {
  26. $rule[$columnArray[$i]] = $data[$i];
  27. }
  28. $dataArray[] = $rule;
  29. }
  30. }
  31.  
  32. foreach($dataArray as $data)
  33. {
  34.  
  35. $query = "INSERT INTO `tran_detail` (".implode('`,`', array_keys($data))."`) VALUES('".implode('','', array_map("convert",array_values($data)))."')";
  36.  
  37. mysql_query($query) or mysql_error();
  38.  
  39. }
  40.  
  41. fclose($source);
Add Comment
Please, Sign In to add comment