Guest User

Untitled

a guest
Jun 12th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. <?php
  2. // Connection
  3. $db='10.0.0.x:/var/lib/firebird/2.5/data/mysql2firebird.fdb';
  4. $dbuser = 'SYSDBA';
  5. $dbpass = '*******';
  6. $res = ibase_connect($db,$dbuser,$dbpass) or die("<br>" . ibase_errmsg());
  7.  
  8.  
  9. $row = 1;
  10. $handle = fopen("mysqltable_dump.csv", "r");
  11. while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
  12. $num = count($data);
  13. // echo "<p> $num fields in line $row: <br /></p>\n";
  14. $row++;
  15. for ($c=0; $c < $num; $c++) {
  16. if ($data[$c]=="") {$data[$c]="null";}
  17. // echo $data[$c] . "<br />\n";
  18. }
  19. $query="insert into firebird_table_name(firestcolumn_id,second_column,third_column) values (".$data[0].",".$data[1].','.$data[2].");";
  20. echo "$query\n";
  21. $result=ibase_query($res,$query);
  22. ibase_commit($res);
  23.  
  24. if (!$result) {
  25. echo "Error. Can't insert the record with the query: $query!";
  26. exit;
  27. }
  28. }
  29. fclose($handle);
  30. ?>
Add Comment
Please, Sign In to add comment