Using form to pass a file to be processed...

[Jim R]

I'll be having .txt files uploaded via a form.  Upon submission, it will be passed to another .php file to have the data entered into the database.  

It's not uploading the file to the folder, and while the trigger echoes what's set up to echo, it's loading the data into the database.  

 

Here is the form:

	 echo '<form action="/wp-content/plugins/csi_stats/csi_process.php" method="post" enctype="multipart/form-data">
	  Select Boxscore to upload:
	  <input type="file" name="fileToUpload" id="fileToUpload">
	  <input type="submit" value="Upload" name="submit">
	</form>';
	
 }

 Here is csi_process.php

$filename = $_FILES['fileToUpload']['name'];


$target_dir = "/wp-content/uploads/csi_boxscores/21/";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
$uploadOk = 1;
$imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));


// Check if image file is a actual image or fake image
if(isset($_POST["submit"])) {
 // $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
 
    echo $target_file . ' Boxscore Sent';
    echo '<br>' .$filename;
    $uploadOk = 0;
  
}

$query = "
    LOAD DATA INFILE '$fileName'
     INTO TABLE a_stats
     FIELDS TERMINATED BY '|' 
     LINES TERMINATED BY '\r\n'
     IGNORE 2 Lines
    (jersey,points,2pm,2pa,3pm,3pa,ftm,fta,oreb,dreb,treb,ast,blk,stl,deflect,turn,charge,pf,tf)
    SET team = 426";

"team" will ultimately be a variable, and I'll have "game" in there too.  

 

 

 

Here is the data:

235a5d12-be10-43af-abba-e45456d9d8da
Jersey|Points|TwoPointsMade|TwoPointAttempts|ThreePointsMade|ThreePointAttempts|FreeThrowsMade|FreeThrowAttempts|OffensiveRebounds|DefensiveRebounds|Rebounds|Assists|BlockedShots|Steals|Deflections|Turnovers|Charges|PersonalFouls|TechnicalFouls
10|8|1|2|2|6|0|0|0|4|4|1|1|1|0|1|0|0|0
12|3|0|5|0|3|3|4|1|2|3|0|1|1|0|0|0|2|0
20|8|4|6|0|0|0|0|1|1|2|0|1|1|0|2|0|0|0
22|3|0|1|1|1|0|0|1|2|3|1|0|0|0|2|0|2|0
24|18|4|7|1|3|7|10|0|2|2|1|0|1|0|3|0|3|0
32|1|0|2|0|3|1|2|2|1|3|0|0|1|0|0|0|2|0
41|8|0|0|2|3|2|2|0|0|0|0|0|1|0|0|0|1|0
43|11|5|7|0|0|1|2|0|6|6|1|0|4|0|2|0|3|0
52|3|1|6|0|0|1|1|4|3|7|0|0|1|0|1|0|4|0

 

Edited November 14, 2020 by Jim R

[gw1500se]

You have to move_uploaded_file to get it to the desired folder. However, unless I don't understand what you want to do, there is no need to move it at all. Process the file into the database as you are.

[Jim R]

That's fair, and I wondered if I needed to store the file at all, but I kind of want to keep the files.  I guess there isn't a need.  

 

So I tried it with just this...

 

$filename = $_FILES['fileToUpload']['name'];


$query = "
    LOAD DATA INFILE '$fileName'
     INTO TABLE a_stats
     FIELDS TERMINATED BY '|' 
     LINES TERMINATED BY '\r\n'
     IGNORE 2 Lines
    (jersey,points,2pm,2pa,3pm,3pa,ftm,fta,oreb,dreb,treb,ast,blk,stl,deflect,turn,charge,pf,tf)
    SET team = 426";

 

It still didn't input the data.  

[Barand]

If you aren't storing the file you need to load it from the tmp_file.

Make sure you have the privileges required to run a LOAD DATA query.

[Jim R]

2 minutes ago, Barand said:

If you aren't storing the file you need to load it from the tmp_file.

Make sure you have the privileges required to run a LOAD DATA query.

Where would I check the privileges?  I know I had checked whether or not I could write to the folder.  

 

I can store the file, but it wasn't uploading the file.  

[Barand]

The user privileges defined in the mysql database for whichever username you are connecting with.

Quote

Non-LOCAL load operations read text files located on the server. For security reasons, such operations require that you have the FILE privilege.

 

[gw1500se]

Log in to MySQL from the command line using the same credentials as your PHP script (usually 'apache' in Linux). Then enter the following commands:

USE DATABASE <your database name>;

SHOW PRIVILEGES;

As Barand says, you need to see the FILE privilege. If it is not there, you will need to log in as root (or have your sys admin do it) and GRANT that privilege for that database and user.

[Jim R]

I'm the admin (reseller account) so I should have all available privileges.  I'm talking to Host Gator now to find out if there is something else.  

[gw1500se]

But the user running the script may not. Did you check as I suggested?

[Jim R]

7 minutes ago, gw1500se said:

But the user running the script may not. Did you check as I suggested?

I'm the user running the script.  

 

Which command line are you referring to?  I checked through cPanel through my host.  

[gw1500se]

Are you on Linux? If so 'apache' is running the script, not you. I am referring to 'mysql' from command line.

[Jim R]

I'm not on Linux.  I'm accessing my mysql database permissions via my cPanel / phpMyAdmin.  

[Jim R]

I have the necessary permissions, according to the tech support, and I know I have file_uploads enabled in php.ini.  

 

 

[gw1500se]

Where you are running it as a client is irrelevant. Is the MySQL server on Windows or Linux? Is the httpd server Windows or Linux? Are they the same server?

[Jim R]

Looks like Linux.  

[Jim R]

I don't have a command line.

[Jim R]

Hold on...checking for more information. 

Edited November 14, 2020 by Jim R

[gw1500se]

If you have PHPAdmin with admin rights then you need to check GRANTs for user 'apache'. That is likely the crux of your problem.

[Jim R]

I'm working on that.  They're telling me I have permission, but I don't.  

 

And when you (and my tech) ask me if I have permissions, csi_username has ALL permissions.  However, the error shows csi@localhost.  Not sure where to check/change csi@localhost.

[gw1500se]

Read up on GRANT.

[Jim R]

OK, but where do I do that?  

 

 

[Jim R]

There is nowhere to type the GRANT 

[gw1500se]

You need to open a terminal session on the MySQL server and run it from the command line.

[Jim R]

14 minutes ago, gw1500se said:

You need to open a terminal session on the MySQL server and run it from the command line.

I don't have access to that.  

I'm talking with someone now.  They don't see why I don't have permission to use Load Data.  I'll report back.  

 

Does the query, however, look good?

[Jim R]

I have all of Host Gator stumped. They don't know why I'm getting an access denied error.