Re: Re: No data?

On 7/27/2012 11:03 AM, Brad wrote:
> Even though my permissions are 777 in my /tmp I am trying to send the file
> to a tmp directory in my webroot and if I can even get it to create the file
> it has the wrong name of 'Array', and then it still does not update my
> database.
>
>
>
>
> <?php
> var_dump($_FILES);
> //db connection
> require 'dbConnect.php';
> //session file
> require_once('../auth.php');
> function uploadList(){
>          $target_path = "/home/nyctelecomm.com/www/mail/upload/";
>          //$_FILE function, grab files
>          $inFile = $_FILES["file"];
>          //Get file name
>          $filename = $inFile["name"];
>          //strip the file extension
>          $filename = preg_replace('/\.[^.]+$/','',$filename);
>          var_dump($_FILES);
>          //grab sessionID which is memberID
>          $memberID = $_SESSION["SESS_MEMBER_ID"];
>          //identify cvs, tested with MS excel in csv format
>          if ($inFile["type"] == "application/octet-stream")
>                  {
>                  if ($inFile["error"] > 0)
>                          {
>                          echo "Return Code: " . $inFile['error'] . "<br />";
>                  }
>                  else
>                          {
>                          dbConnect();
>                          //move_uploaded_file($_FILES["file"],$target_path);
>                          move_uploaded_file($inFile["file"]["tmp_name"],
> $target_path .'/'.$inFile);
>                          //chmod ($filename['file'], 0777);
>                          mysql_select_db('mailList') or die(mysql_error());
>                          //assign temporary name to variable
>                          //for insert since tmp_file is the real file
>                          //$tmp_name =  $inFile["file"];
>                          $presql = "CREATE TABLE IF NOT EXISTS `{$memberID}`
> (id MEDIUMINT AUTO_INCREMENT PRIMARY KEY UNIQUE)";
>                          $midsql = "ALTER TABLE `{$memberID}` ADD
> `{$filename}` VARCHAR(60)";
>                          $sql = <<<EOF
>                          LOAD DATA LOCAL INFILE '{$inFile}'
>                          INTO TABLE `{$memberID}`
>                          FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY
> '\\''
>                          LINES TERMINATED BY "\\r\\n
>                          IGNORE 1 LINES ($filename)"
> EOF;
>                          var_dump($sql);
>                          echo '$sql';
>                          mysql_query($presql) or die(mysql_error());
>                          mysql_query($midsql) or die(mysql_error());
>                          mysql_query($sql) or die(mysql_error());
>                          var_dump($sql);
>                          echo '$sql';
>                          if(mysql_error())
>                                  {
>                                  echo(mysql_error());
>                          }
>                          else
>                                  {
>                                  print('Import of campaign emails sucessfull
> into mysql table.');
>                          }
>                  }
>          }
>          else
>                  {
>                  print('Invalid file type. Please make sure it is a text
> file.');
>          }
> }
>
> //var_dump($_FILES);
> uploadList();
> ?>
>
>
> ****************************************************************************
> *
>
>
>
> array(1) { ["file"]=> array(5) { ["name"]=> string(13) "testBook1.csv"
> ["type"]=> string(24) "application/octet-stream" ["tmp_name"]=> string(14)
> "/tmp/phpZVJWhW" ["error"]=> int(0) ["size"]=> int(102) } } array(1) {
> ["file"]=> array(5) { ["name"]=> string(13) "testBook1.csv" ["type"]=>
> string(24) "application/octet-stream" ["tmp_name"]=> string(14)
> "/tmp/phpZVJWhW" ["error"]=> int(0) ["size"]=> int(102) } }
> Notice: Undefined index: file in /home/nyctelecomm.com/www/mail/import.php
> on line 29
> string(169) "	 LOAD DATA LOCAL INFILE 'Array' INTO TABLE `3` FIELDS
> TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\'' LINES TERMINATED BY "\r\n
> IGNORE 1 LINES (testBook1)"" $sqlFile 'Array' not found (Errcode: 2)
>
>
>
> -----Original Message-----
> From: Tamara Temple [mailto:[email protected]]
> Sent: Friday, July 27, 2012 10:46 AM
> To: Brad
> Cc: 'tamouse mailing lists'; [email protected]
> Subject: Re: [PHP-DB] Re: No data?
>
> Brad <[email protected]> wrote:
>
>> Wow, this is unbeileivable. Your test script fails with the attached csv
> where column `a` in blank too!
>
> No, with your attached file, it works:
>
> array(2) {
>    [0]=>
>    string(15) "[email protected]"
>    [1]=>
>    string(1) "1"
> }
> array(2) {
>    [0]=>
>    string(15) "[email protected]"
>    [1]=>
>    string(1) "2"
> }
> array(2) {
>    [0]=>
>    string(15) "[email protected]"
>    [1]=>
>    string(1) "3"
> }
> array(2) {
>    [0]=>
>    string(15) "[email protected]"
>    [1]=>
>    string(1) "4"
> }
> array(2) {
>    [0]=>
>    string(15) "[email protected]"
>    [1]=>
>    string(1) "5"
> }
> array(2) {
>    [0]=>
>    string(15) "[email protected]"
>    [1]=>
>    string(1) "6"
> }
>
You seem to be very stubborn in your attempts to handle this problem. 
All the suggestions we have provided you seem to be ignoring.  Dont' 
understand your mentality and I surely hope you are not exhausting your 
employer's resources on this effort.

Once again - upload the file and move it and name it.  Then never 
reference $_FILES again.

In particular - in your latest posting here you appear to have misused 
the $infile var in your DATA LOAD  statement.  See how confusing you 
make this for yourself?

Leave me off any future emails.  I have lost interest.  :(

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php