prepare($query);
//$sth->bindValue(':id', $GOODS_PID, PDO::PARAM_STR);
$sth->execute();
$rows = $sth->fetchAll(PDO::FETCH_ASSOC);
if (sizeof($rows) > 0) {
foreach ($rows as $loc_key => $row) {
$rub_id = $row["id"];
$rub_name = $row["name"];
$PICS_ARR = array();
$P_LIST = "";
$query = "SELECT $MY_GOODS_PICS.id, $MY_GOODS_PICS.pic FROM $MY_GOODS_PICS, $MY_GOODS WHERE $MY_GOODS.pid=:pid AND $MY_GOODS_PICS.pid = $MY_GOODS.id AND $MY_GOODS.vis = '1'";
$sth = $dbh->prepare($query);
$sth->bindValue(':pid', $rub_id, PDO::PARAM_STR);
$sth->execute();
$rows2 = $sth->fetchAll(PDO::FETCH_ASSOC);
if (sizeof($rows2) > 0) {
$i = 0;
foreach ($rows2 as $loc_key2 => $row2) {
$loc_pic = $row2["pic"];
$P_LIST .= "$loc_pic
";
$PICS_ARR[$i] = $loc_pic;
//print "$i - $loc_pic
";
$i++;
}
}
$rnd = rand(0, $i-1);
//print "rubid=$rub_id rnd = $rnd
";
$filename_pic = "";
if (isset($PICS_ARR[$rnd])) {
$filename_pic = $PICS_ARR[$rnd];
}
/* $RUBS_CONTENT .= <<
$P_LIST
ENDOF;*/
$RUB_PIC = "
";
if (!empty($filename_pic)) {
$RUB_PIC = <<
ENDOF;
}
$SELECTED = "";
if ($rub_id == $PID) {
$SELECTED = " rubs_item_selected";
}
$RUBS_CONTENT .= <<
ENDOF;
}
}
$IS_GOODS = 0;
$PICS_ARR = array();
$ADD = "";
if (!empty($PID)) {
$ADD = " AND pid=:pid";
}
$GOODS_ADD = "";
$query = "SELECT id, pid, name, articul FROM $MY_GOODS WHERE vis=1" . "$ADD" . " LIMIT 50";
$sth = $dbh->prepare($query);
if (!empty($PID)) {
$sth->bindValue(':pid', $PID, PDO::PARAM_STR);
}
$sth->execute();
$rows = $sth->fetchAll(PDO::FETCH_ASSOC);
if (sizeof($rows) > 0) {
foreach ($rows as $loc_key => $row) {
$loc_id = $row["id"];
if (!empty($GOODS_ADD)) {
$GOODS_ADD .= " OR ";
}
$GOODS_ADD .= "pid='$loc_id'";
$IS_GOODS = 1;
}
}
if ($IS_GOODS) {
if (!empty($GOODS_ADD)) {
$GOODS_ADD = " WHERE $GOODS_ADD";
}
$query = "SELECT pid, pic FROM $MY_GOODS_PICS$GOODS_ADD";
$sth = $dbh->prepare($query);
if (!empty($PID)) {
$sth->bindValue(':pid', $PID, PDO::PARAM_STR);
}
$sth->execute();
$rows2 = $sth->fetchAll(PDO::FETCH_ASSOC);
if (sizeof($rows2) > 0) {
foreach ($rows2 as $loc_key2 => $row2) {
$loc_pid = $row2["pid"];
$loc_pic = $row2["pic"];
$PICS_ARR[$loc_pid] = $loc_pic;
//print "$loc_pid - $loc_pic
";
}
}
$query = "SELECT id, pid, name, articul FROM $MY_GOODS WHERE vis=1" . "$ADD" . " LIMIT 50";
$sth = $dbh->prepare($query);
if (!empty($PID)) {
$sth->bindValue(':pid', $PID, PDO::PARAM_STR);
}
$sth->execute();
$rows = $sth->fetchAll(PDO::FETCH_ASSOC);
if (sizeof($rows) > 0) {
foreach ($rows as $loc_key => $row) {
$loc_id = $row["id"];
$loc_pid = $row["pid"];
$loc_name = $row["name"];
$loc_articul = $row["articul"];
$loc_name_lat = trans($loc_name);
$link = "/catalog/$loc_pid/$loc_id" . "-" . "$loc_name_lat";
$THIS_PIC = "/images/pic_list_default.jpg";
if (isset($PICS_ARR[$loc_id]) && !empty($PICS_ARR[$loc_id])) {
$filename_pic = $PICS_ARR[$loc_id];
$THIS_PIC = "/images/p/$filename_pic";
}
$CONTENT .= <<
$loc_name
Артикул: $loc_articul
ENDOF;
}
}
} else {
$CONTENT = <<Товаров не найдено. Попробуйте выбрать другую рубрику каталога.
ENDOF;
}
} else {
// print "$ID $PID";
//exit;
$IS_FOUND = 0;
$query = "SELECT pid, name, articul, descr, content FROM $MY_GOODS WHERE id=:id";
$sth = $dbh->prepare($query);
$sth->bindValue(':id', $ID, PDO::PARAM_STR);
$sth->execute();
$rows = $sth->fetchAll(PDO::FETCH_ASSOC);
if (sizeof($rows) > 0) {
foreach ($rows as $loc_key => $row) {
$GOODS_PID = $row["pid"];
$GOODS_NAME = $row["name"];
$GOODS_ARTICUL = $row["articul"];
$GOODS_DESCR = $row["descr"];
$GOODS_CONTENT = $row["content"];
$IS_FOUND = 1;
}
}
if ($IS_FOUND) {
$query = "SELECT pid, name, content_title, content, pic FROM $MY_RUBS WHERE id=:id";
$sth = $dbh->prepare($query);
$sth->bindValue(':id', $GOODS_PID, PDO::PARAM_STR);
$sth->execute();
$rows = $sth->fetchAll(PDO::FETCH_ASSOC);
if (sizeof($rows) > 0) {
foreach ($rows as $loc_key => $row) {
$RUB_PID = $row["pid"];
$RUB_NAME = $row["name"];
$RUB_CONTENT_TITLE = $row["content_title"];
$RUB_CONTENT = $row["content"];
$RUB_PIC = $row["pic"];
}
}
if ($RUB_PID != $GOODS_PID) {
$query = "SELECT pid, name FROM $MY_RUBS WHERE id=:id";
$sth = $dbh->prepare($query);
$sth->bindValue(':id', $RUB_PID, PDO::PARAM_STR);
$sth->execute();
$rows = $sth->fetchAll(PDO::FETCH_ASSOC);
if (sizeof($rows) > 0) {
foreach ($rows as $loc_key => $row) {
$PARENT_RUB_ID = $RUB_PID;
$PARENT_RUB_NAME = $row["name"];
}
}
}
$IS_STORAGE_FOUND = 0;
$query = "SELECT id, name, timestamp FROM $MY_GOODS_STORAGE WHERE pid=:id LIMIT 1";
$sth = $dbh->prepare($query);
$sth->bindValue(':id', $ID, PDO::PARAM_STR);
$sth->execute();
$rows = $sth->fetchAll(PDO::FETCH_ASSOC);
if (sizeof($rows) > 0) {
foreach ($rows as $loc_key => $row) {
$loc_id = $row["id"];
$loc_name = $row["name"];
$loc_tim = $row["timestamp"];
$IS_STORAGE_FOUND = 1;
}
}
$STORAGE_CONTENT = "";
if ($IS_STORAGE_FOUND) {
$STORAGE_FILENAME = $GOODS_STORAGE_FOLDER . $loc_name . "?$loc_tim";
$STORAGE_CONTENT = <<Скачать документацию
ENDOF;
}
$IS_PIC_FOUND = 0;
$query = "SELECT id, pic, ts FROM $MY_GOODS_PICS WHERE pid=:id LIMIT 1";
$sth = $dbh->prepare($query);
$sth->bindValue(':id', $ID, PDO::PARAM_STR);
$sth->execute();
$rows = $sth->fetchAll(PDO::FETCH_ASSOC);
if (sizeof($rows) > 0) {
foreach ($rows as $loc_key => $row) {
$loc_id = $row["id"];
$loc_pic = $row["pic"];
$loc_ts = $row["ts"];
$IS_PIC_FOUND = 1;
}
}
$PICS_CONTENT = "";
if ($IS_PIC_FOUND) {
$PICS_CONTENT = <<
ENDOF;
} else {
$PICS_CONTENT = <<