Arrays from exploded data.

chrislead

Ok,

I have got this data:

"000000000000952019","000000952019","DESC",1.00,1,0
"00000000000246157","000001579","DESC2",1.00,1,0

It's source is a text file stored on the server, so I have used fopen and read to grab the data. I have also used "explode(",", $contents);" to seperate the strings into variables.

I need a way of probably getting this data into an array so I can use a foreach loop to the INSERT the records into a table using SQL.

Cheers all.

devinemke

$file = file('/path/to/file.txt');

foreach ($file as $value)
{
	$sql = 'INSERT INTO table VALUES (' . trim($value) . ')';
	echo $sql . '<br>';	
}

assuming that is the correct field order

AstroTeg

Have you thought about using [man]fgetcsv[/man] as you read the data in?

The advantage is you only read one line in at a time (versus tossing the entire file into RAM memory which for a small file is ok, not ok for big files), it does an ok job handling carriage returns in strings, and may be a bit easier to work with if the column count changes in the file.

chrislead

Wow! when I run that it brings up exaclty what I am looking to do. Cheers.

However, I have now implemented it to actually insert them values, code below:

$file = file('/test_upload.txt'); 

foreach ($file as $value) 
{ 
	$insertNew = mysql_query("INSERT INTO stock VALUES ('" . trim($value) . "')");
}

$select = mysql_query("SELECT * FROM stock");
	while($row = mysql_fetch_array($select)){

echo "<br>";
echo "<br>";

echo $row['plu'];
echo "<br>";
echo $row['description'];
echo "<br>";
echo $row['price'];
}

I have also added a little extra to show what is in the database after the insert, and I just get a blank screen.

Any suggestions??

Thanks.

devinemke

<?php
mysql_connect('host', 'user', 'password') or exit(mysql_error());
mysql_select_db('dbname') or exit(mysql_error());

$file = file('/test_upload.txt'); 

foreach ($file as $value) 
{ 
    mysql_query('INSERT INTO stock VALUES (' . trim($value) . ')') or exit(mysql_error());
} 

$result = mysql_query('SELECT * FROM stock') or exit(mysql_error());
while ($row = mysql_fetch_assoc($select))
{
	echo $row['plu'] . '<br>' . $row['description'] . '<br>' . $row['price'] . '<br><br>'; 
}
?>

chrislead

I get the message:

Column count doesn't match value count at row 1

Which I presume means that I don't have that many columns in the table, which is correct! I only created 3 for testing purposes.

In light of this, I will ammend my table accordingly.

On another quick note, I am wanting to also use this exact method to update existing stock. Would I be correct in thinking that this syntax would be ok?

UPDATE table_name
SET column_name = new_value
WHERE column_name = some_value

or if you can suggest the precise syntax then that would be awsome.

Many thanks for your time.