No, it did not work.
mysql> show tables;
+--------------------+
| Tables_in_mailList |
+--------------------+
| testBook1csv |
+--------------------+
1 row in set (0.00 sec)
mysql> select * from `testBook1csv`;
+----+--------+
| id | field0 |
+----+--------+
| 1 | NULL |
| 2 | NULL |
| 3 | NULL |
| 4 | NULL |
| 5 | NULL |
| 6 | NULL |
+----+--------+
6 rows in set (0.00 sec)
file upload example
$_FILES
array(1) {
["userfile"]=>
array(5) {
["name"]=>
string(13) "testBook1.csv"
["type"]=>
string(24) "application/octet-stream"
["tmp_name"]=>
string(14) "/tmp/phpiaW23p"
["error"]=>
int(0)
["size"]=>
int(102)
}
}
ls -l /tmp/phpiaW23p
-rw------- 1 apache apache 102 Jul 27 00:02 /tmp/phpiaW23p
$sql for create table
string(110) "create table if not exists `testBook1csv` (id integer not null
auto_increment primary key, field0 varchar(50))"
$sql for load data
string(142) "load data local infile '/tmp/phpiaW23p' into table `testBook1csv`
fields terminated by ',' optionally enclosed by '"' lines terminated by '\n'"
Verify data contents
Table testBook1csv
string(28) "select * from `testBook1csv`"
$sql=
data
array(2) {
[0]=>
string(1) "1"
[1]=>
NULL
}
array(2) {
[0]=>
string(1) "2"
[1]=>
NULL
}
array(2) {
[0]=>
string(1) "3"
[1]=>
NULL
}
array(2) {
[0]=>
string(1) "4"
[1]=>
NULL
}
array(2) {
[0]=>
string(1) "5"
[1]=>
NULL
}
array(2) {
[0]=>
string(1) "6"
[1]=>
NULL
}
-----Original Message-----
From: tamouse mailing lists [mailto:[email protected]]
Sent: Thursday, July 26, 2012 11:20 PM
To: Brad
Cc: [email protected]; [email protected]
Subject: Re: [PHP-DB] Re: No data?
Brad, do take a look at http://pastie.org/4340383 It does work.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
