note 106778 added to function.fgetcsv
| From: | supaman at firedub dot com | Date: | Tue, 06 Dec 2011 07:27:31 +0000 |
| Subject: | note 106778 added to function.fgetcsv | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-184924@lists.php.net to get a copy of this message | ||
This is my source code. Write by http://www.firedub.com/
header( "content-type: text/html; charset=UTF-8" ); //set language to utf-8
$FILE = fopen( "record.csv", "r"); //open file and read
$data = fgetcsv( $FILE , 1024 );
$i=1;
do {
if ($i == 1){ //unread first row
$data = fgetcsv( $FILE , 1024 );
$i++;
} else{
include "connect.php"; //file connect DB.
$sql="INSERT INTO employee(record_id,employee_id,employee_name) VALUES ('$data[0]',
'$data[1]', '$data[2]');";
$dbquery=mysql_db_query($dbname,$sql);
mysql_close();
$data = fgetcsv( $FILE , 1024 );
$i++;
}
}while ( !feof( $FILE ) );
Thank you. I am a php programmer beginner.
----
Server IP: 69.147.83.197
Probable Submitter: 110.77.137.90
----
Manual Page -- http://www.php.net/manual/en/function.fgetcsv.php
Edit -- https://master.php.net/note/edit/106778
Del: integrated -- https://master.php.net/note/delete/106778/integrated
Del: useless -- https://master.php.net/note/delete/106778/useless
Del: bad code -- https://master.php.net/note/delete/106778/bad+code
Del: spam -- https://master.php.net/note/delete/106778/spam
Del: non-english -- https://master.php.net/note/delete/106778/non-english
Del: in docs -- https://master.php.net/note/delete/106778/in+docs
Del: other reasons-- https://master.php.net/note/delete/106778
Reject -- https://master.php.net/note/reject/106778
Search -- https://master.php.net/manage/user-notes.php