<?php
define('DB_SERVER','localhost');
define('DB_USER','');
define('DB_CHARSET','utf8');
define('DB_PASS','');
define('DB_NAME','');
error_reporting(E_ALL);
ini_set('display_errors', 'On');

$link = mysql_connect(DB_SERVER, DB_USER, DB_PASS)
    or die('Не удалось соединиться: ' . mysql_error());
#mysql_close($link);
mysql_select_db('');
mysql_set_charset(DB_CHARSET);

$query="SELECT *
FROM `ps_product` , `ps_product_lang`
WHERE ps_product.id_product = ps_product_lang.id_product
ORDER BY ps_product.id_product";
#$query2="SELECT * FROM `ps_product` WHERE id_product in (".$row['id_product'].")";
$result=mysql_query("$query",$link);
$fp = fopen('file.csv', 'w');
fputcsv($fp, explode(';', 'Название;Закупочная цена;Цена продажи;Прибыль'));
while($row = mysql_fetch_array($result))
{
    $price = $row['price'];
    $wholesale_price = $row['wholesale_price'];
    $profit = $price - $wholesale_price;
    $name = $row['name']. ";";
    echo '<form method="post">';
    echo '<input name="'.$row['id_product'].'" type="checkbox" value="'.$row['id_product'].'">';
    echo "ID: ".$row['id_product']." ";
    echo "Имя: ".$row['name']."<br>";
    echo "Цена закупочная: ".$row['wholesale_price']."<br>";
    echo "Цена продажи: ".$row['price']."<br>";
    echo "Прибыль: ".$profit."<br><br>";
    echo '</form>';

    #$list = array ("тест;", $price, $wholesale_price, $profit);
    $list[] = array ($name.$wholesale_price.';'.$price.';'.$profit);

}

$query2="SELECT *
FROM `ps_stock`
ORDER BY ps_stock.id_product";
#$query2="SELECT * FROM `ps_product` WHERE id_product in (".$row['id_product'].")";
$result=mysql_query("$query2",$link);
while($row2 = mysql_fetch_array($result))
{
    $stock = $row2['physical_quantity'];
    $list[] = array ($stock);
}
foreach ($list as $line) {
        fputcsv($fp, explode(';', $line));
    }
mysql_close($link);
?>