artist.php

<?php
include("db.php");
include("functions.php");

$file = fopen("comics/artist.csv","r");
$mysql = fopen("artist.sql", "w"); // write into this sql to import 


/*
website id ->> mettre dans table website -> remettre foreign key
year -> date
*/

$min = 0;
$max = 100000000000;
$i = 0;

/*
  0 => string 'id' (length=2)
  1 => string 'code' (length=4)
  2 => string 'name' (length=4)

  @TODO unknown ?
*/

  while(! feof($file)){
    $i++;
    $val = fgetcsv($file);

    if($i > $min){

      $id = getInt($val[0]);
      $name = parseDoubleQuote($val[1]);

      $query = 'INSERT INTO artist(id,name) VALUES(
      '.$id.','.$name.'
      );';

    //var_dump($query);

      //print_r($query);
      fwrite($mysql,$query);

      $s1 = $con->query($query);
      /*var_dump($s1);*/

      if($i==$max){
        break;
      }
    }
    
  }
//var_dump($s1->fetchAll(PDO::FETCH_ASSOC));

  /*$s = $con->query("SELECT * FROM indicia_publisher ORDER BY id DESC LIMIT 10");
  $result = $s->fetchAll(PDO::FETCH_ASSOC);
  var_dump($result);*/

  fclose($file);
  ?>