I am making a function that uploads a txt file in csv format and the grabs
uploaded file name and the memberID from the sessions login and names the
new table memberID_filename.
The program error on line 24 @ 'name'.
I have tried '{$_FILES[file][name]}' '{$_FILES[file]['name']}'
You need to use te tmp_name ... The plain text file is in path indicated by
The string...
Regards,
El martes, 24 de julio de 2012, Brad escribió:
I am making a function that uploads a txt file in csv format and the grabs
uploaded file name and the memberID from the sessions login and names
Pelase, print The SQL var and show here The result.
El martes, 24 de julio de 2012, Roberto Carlos Garcia Luis escribió:
You need to use te tmp_name ... The plain text file is in path indicated
by The string...
Regards,
El martes, 24 de julio de 2012, Brad escribió:
I am making a
The tmp_file is just gibberish. I truly do not want that as the table
name.
From: Roberto Carlos Garcia Luis [mailto:legnakar...@gmail.com]
Sent: Tuesday, July 24, 2012 4:26 AM
To: Brad
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Stuck trying to upload and grab file name
array(1) { [file]= array(5) { [name]= string(14) emailsTest.txt
[type]= string(10) text/plain [tmp_name]= string(14)
/tmp/php98AolN [error]= int(0) [size]= int(61) } } array(5) {
[name]= string(14) emailsTest.txt [type]= string(10) text/plain
[tmp_name]= string(14) /tmp/php98AolN [error]= int(0)
In the
LOAD DATA LOCAL INFILE '{$_FILES['file']['name']}'
You need use The tmp_name to load The file contents.
And The SQL var result as a string diferent of The SQL that you insert in
console
El martes, 24 de julio de 2012, Brad escribió:
The tmp_file is just gibberish. I ‘truly’ do not want
?php
var_dump($_FILES);
//db connection
require 'dbConnect.php';
//session file
require_once('../auth.php');
function uploadList(){
//var_dump($_FILES['file']);
if ($_FILES[file][type] == text/plain)
{
if ($_FILES[file][error] 0)
Use
$_FILES[file][tmp_name]
El martes, 24 de julio de 2012, Brad escribió:
?php
var_dump($_FILES);
//db connection
require 'dbConnect.php';
//session file
require_once('../auth.php');
function uploadList(){
//var_dump($_FILES['file']);
array(1) { [file]= array(5) { [name]= string(14) emailsTest.txt
[type]= string(10) text/plain [tmp_name]= string(14)
/tmp/php8Tx8es [error]= int(0) [size]= int(61) } } $sqlYou have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to
At the risk of being unable to understand all the posts that are here
already, here is some std. code that I use when I'm uploading a file.
First - i capture the input field in a local var and all of its
components in other local vars to make my coding easier later on.
$inputfield =
Here is where everything stands.. L
http://pastie.org/4317155
From: Roberto Carlos Garcia Luis [mailto:legnakar...@gmail.com]
Sent: Tuesday, July 24, 2012 5:23 AM
To: Brad
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Stuck trying to upload and grab file name
Use
Thank you very much my friend.
The significant difference between your code and mine is that my file
contents are going into a MySQL database and it is this db function that is
crapping out. The SQL (with variables replaced with static values) runs
clean - http://pastie.org/4302489
But as soon
Does the problem have anything to do with this:
[tmp_name]= string(14) /tmp/phpcLtE6W
So this:
$file = $_FILES[file][tmp_name];
Would make $file == /tmp/phpcLtE6W
I'm not sure if that's what you want. Seems more likely that you'd want it
to be:
$file = $_FILES[file][name];
Useful?
On
On 7/24/2012 12:05 PM, Graham H. wrote:
Does the problem have anything to do with this:
[tmp_name]= string(14) /tmp/phpcLtE6W
So this:
$file = $_FILES[file][tmp_name];
Would make $file == /tmp/phpcLtE6W
I'm not sure if that's what you want. Seems more likely that you'd want it
to be:
If by the line you mean: [tmp_name]= string(14) /tmp/phpcLtE6W
That is from the bottom of this Pastie link: http://pastie.org/4317155
On Tue, Jul 24, 2012 at 10:29 AM, Jim Giner jim.gi...@albanyhandball.comwrote:
On 7/24/2012 12:05 PM, Graham H. wrote:
Does the problem have anything to do
On 7/24/2012 4:16 AM, Brad wrote:
$file = $_FILES['file']['name'];
//$presql = CREATE TABLE IF NOT EXISTS
(`$_SESSION[SESS_MEMBER_ID]_$file`);
$presql = CREATE TABLE IF NOT EXISTS
`$_SESSION[SESS_MEMBER_ID]_$file`;
On 7/24/2012 12:40 PM, Graham H. wrote:
If by the line you mean: [tmp_name]= string(14) /tmp/phpcLtE6W
That is from the bottom of this Pastie link: http://pastie.org/4317155
$file = $_FILES[file][tmp_name];
I meant the above line.
--
PHP Database Mailing List (http://www.php.net/)
To
Okay.
That line is also in the Pastie code :) Though it isn't in the OP. Hence my
(and your) confusion now. Line 20 from here: http://pastie.org/4317155 also
line 24.
On Tue, Jul 24, 2012 at 10:44 AM, Jim Giner jim.gi...@albanyhandball.comwrote:
On 7/24/2012 12:40 PM, Graham H. wrote:
If by
Wtf, whts happening here??? Getting freakin hundreds of emails, if you got
stuckup, you need to resolve it by urself, dont email for silly doubts..
Sent from my smart phone
-Original message-
From: Graham H.
Sent: 24/07/2012, 10:16 pm
To: jim.gi...@albanyhandball.com
Cc:
I wanted to start off by saying thank you to the list for your warm support.
I was working with jonez from irc.oftc.net #php and we were able to far
enough into the issue for me to realize I'm an idiot.
I am creating a new table like I wanted but should be creating new field due
to a little
20 matches
Mail list logo
