从excel表中自动将产品图像和描述包含在MySQL数据库中

Question

I am trying to build an ecommerce site with PHP and MySQL, but I have over 9000 products which I have to add. Is there any way I could do this automatically? I mean I have an excel spreadsheet from the supplier with price, description and a code for each product. Is there any way the images would be uploaded based on that code, without download them in the images folder manually one by one? And to get the description in the same way? OScommerce has something like this? Because if it does I will swith to it. Thank you so much for all your answers!

Answer 1

You can convert the .xls(x) file to a .csv and then use the php function fgetcsv (http://php.net/manual/en/function.fgetcsv.php) to read through the file line-by-line. As you read each row, dump that row's data into the database table. As far as the images, I don't know exactly what you mean. Perhaps you could shed some more light on that aspect.

Example taken from php.net:

<?php
$row = 1;
if (($handle = fopen("test.csv", "r")) !== FALSE) {
    while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
        $num = count($data);
        echo "<p> $num fields in line $row: <br /></p>
";
        $row++;
        for ($c=0; $c < $num; $c++) {
            echo $data[$c] . "<br />
";
        }
    }
    fclose($handle);
}
?>