[function.file]: failed to open stream: No such file or directory

Posted on 16th Feb 2014 07:03 pm by admin

Okay I wrote this little script to upload a csv file that is located on my webhosts server to a mysql database. Something is wrong because I am getting the following error:

Warning: file(./html/beer/uploads/filename.csv) [function.file]: failed to open stream: No such file or directory in /home/content/d/l/a/dlanden/html/beer/uploads/upload_csv_mysql.php on line 12
insert into sunocoimport values ('')
Column count doesn't match value count at row 1

I did a syntax check and everything checked out. Here is the code:

$fcontents = file ('./html/beer/uploads/filename.csv');
# expects the csv file to be in the same dir as this script

for($i=0; $i<sizeof($fcontents); $i++) {
$line = trim($fcontents[$i]);
$arr = explode(",", $line);
#if your data is comma separated
# instead of tab separated,
# change the 't' above to ','

$sql = "insert into sunocoimport values ('".
implode("','", $arr) ."')";
mysql_query($sql);
echo $sql ."
n";
if(mysql_error()) {
echo mysql_error() ."
n";
}
}
?>

I am a newbie so any advice would be appreciated!

Your Answer:

Login to answer

Other forums

GET vs SUBMIT Button to show sections on one index.php page?
Just curious if one of these ways is better (i.e. more efficient) than the other.

I have a

simple ping code
been searchin the site/web and found code thats simple but doesnt work.

I have a personal we

Backflush
I am looking for a report in SAP that would give me a list of all parts that are populated with a ba

form submit at godaddy?
Trying to test form submission at GoDaddy and it does not seem to work. Here's the page...

h

Need help with basic sql
Hi,

I am using oracle 10g, and having some small doubts related to sql , here goes the si

pagination numbering pattern
Hello,

I have following code which works great for pagination. but i have small issue now.

UL and LI Add Form
The idea I want here is when the user click on a character name from the drop down select bar at the

very easy question about SQL info
Hello,
I think that I have a very easy question.
I know how to create a form using php SQL and

Run function every 5 mins ??
I have a function PostMessage()

How can I run it every 5 mins ??

Retrieving Data from Two Different Databases
Hello All,

Ran into another problem and would appreciate some help! I have two datab