nuBuilder Forum

Code: Select all

<?php
	// open the file to read
	$handle = fopen("/path/to/your/file.csv", "r");

	// attention: on windows system may be different (see http://it2.php.net/manual/it/function.fopen.php)
	$handle = fopen("c:\\data\\info.txt", "r");

	// Connect to database
	require 'config.php';  // <-- here are your configuration parameters
	$DB = new mysqli($DBHost, $DBUser, $DBPassword, $DBName);
	if ($DB->connect_errno) {
			$msg = 'Connection error (' . $DB->connect_errno . ') '
				. $DB->connect_error;
	}

	// read rows one by one
	while (($row = fgetcsv($handle, 1000, ",")) !== FALSE) {
		// build the sql
		$sql = "INSERT INTO table (
			table_id, 
			table_first_field, 
			table_second_field, 
			...
		) VALUES (
			`" . uniqid(1) ."`, 
			`" . $row[0] . `,
			`" . $row[1] . `,
			...
		); ";

		// this is not necessary
		echo "<br>".$sql;

		// execute the sql
		$res = $DB->query($sql);
		if ($res != TRUE) {
			echo "<br>error on inserting data: $sql";
		}

	}

	/* Free result set and close connection */
	$res->close();
	$DB->close();

	//close the file csv
	fclose($handle);
?>

Code: Select all

<?php

// This script is used to read a CSV file and load a table that has a primary key

// open csv file to read (windows format for path)
      
	$handle = fopen("C:/path/to/file/csv_file.csv", "r");

// connect to MySQL

   $con = mysql_connect("localhost", "<user>", "<password>");
   if (!$con)
   {
   die('Could not connect: ' . mysql_error());
   }

// select database
   
	mysql_select_db("<table name>", $con);
 
// read rows one by one

	while (($row = fgetcsv($handle, 1000, ",")) !== FALSE) {
// build the sql

   $str = ("INSERT INTO <table name> (
         table_id, 
         table_first_field, 
		 table_second_field,
         ....        
   ) VALUES (
         '" . uniqid() . "', 	/* creates the primary key value - do not change */
         '$row[0]' ,			/* create 1 row for each field in addition to primary key */
         '$row[1]' ,
         ...  
         );");

// The following statement is used to display data to be inserted
// into the table - useful for debugging
		 
    echo "<br>".$str;			
	echo "<br>";				/* forces a new line */
	
// execute the sql	
     $res = mysql_query($str);
     if ($res != TRUE) {
        echo "<br>error on inserting data: $str";
		}
	}
			 
// Free result set and close connection to 

	mysql_close($res); 
	mysql_close($con);

//close the csv file
   fclose($handle);	  
?>

Code: Select all

    // This script is used to read a CSV file and load a table that has a primary key

    // open csv file to read (windows format for path)
         
       $handle = fopen("C:/test/file.csv", "r");

    // read rows one by one

       while (($row = fgetcsv($handle, 1000, ",")) !== FALSE) {
    // build the sql

       $str = "INSERT INTO aaa (
			aaa_id,
			tra_number,
			tra_date,
			tra_type,
			cus_name
       ) VALUES (
			'" . uniqid() . "',
			'$row[0]' ,
			'$row[1]' ,
			'$row[2]' ,
			'$row[3]' 
		);";

    // The following statement is used to display data to be inserted
    // into the table - useful for debugging
          
        echo "<br>".$str;         
       echo "<br>";            /* forces a new line */
       
    // execute the sql   
         $res = nuRunQuery($str);
         if ($res != TRUE) {
            echo "<br>error on inserting data: $str";
          }
       }

    //close the csv file
       fclose($handle);