$i = 0;
while (($data[] = fgetcsv($fp, 1000, $separator)) !== FALSE) {
$i++;
}
fclose($fp);
if ($data[0][0] === 'groups_id') {
$gid_col = 0;
$gname_col = 1;
} else {
$gname_col = 0;
$gid_col = 1;
}
for ($t = 1; $t < $i; $t++) {
$gid = $data[$t][$gid_col];
$gname = $data[$t][$gname_col];
verwerk($gid, $gname);
}
function verwerk($id, $naam)
{
if ($id != 0) {
// checken of klantengroep bestaat (op id))
$id_query = tep_db_query("select groups_id from " . TABLE_GROUPS . " where groups_id = '" . $id . "'");
$row = mysql_fetch_array($id_query);
if ($row != '') {
update($id, $naam);
} else {
echo "Fout! Id " . $id . " bestaat niet!";
}
} else {
maak($naam);
}
$i = 0;
while (($data[] = fgetcsv($fp, 1000, $separator)) !== FALSE) {
$i++;
}
fclose($fp);
if ($data[0][0] === 'products_id') {
$id_col = 0;
$quant_col = 1;
} else {
$quant_col = 0;
$id_col = 1;
}
for ($t = 1; $t < $i; $t++) {
$id = $data[$t][$id_col];
$quant = $data[$t][$quant_col];
verwerk($id, $quant);
}
function verwerk($id, $quant)
{
// checken of product-id bestaat
$id_query = tep_db_query("select * from " . TABLE_PRODUCTS . " where products_id = " . $id);
$row = mysql_fetch_array($id_query);
if ($row != '') {
update($id, $quant);
}
}
function update($id, $quant)
{
tep_db_query("update " . TABLE_PRODUCTS . " set products_quantity = " . $quant . " where products_id = " . $id);
}
require DIR_WS_INCLUDES . 'application_bottom.php';
