|
MySQL.RU - Webboard
 Вернуться
 Запутался с запросом PHP для MySql (v_OK) 09/04/2007 - 11:53:14
 Re: Запутался с запросом PHP для MySql (v_OK) 09/04/2007 - 13:17:34
From: v_OK - 09/04/2007 - 11:53:14
Subject:Запутался с запросом PHP для MySql
-----------------
Есть таблица subtype с категориями товаров (создание, редактирование, удаление)
// ----table subtype ----
<?php
$lang = "ru";
include("adminlib.inc.php");
include("sys/datepicker.lib.php");
include("../sys/lib/magic_quotes.inc.php");
include("../sys/lib/str.lib.php");
include("../sys/wares/wares.def.php");
checkAdminLogin();
dbConnect();
// --- GET VARS ---
$action = @$HTTP_GET_VARS['action']; if(!$action) $action = "index";
$id = @$HTTP_GET_VARS['id'];
$id_type = @$HTTP_GET_VARS['id_type']; if(!$id_type) $id_type = "1";
// --- POST VARS ---
$title_ru = trim(@$HTTP_POST_VARS['title_ru']); if(!$title_ru) $title_ru = "-";
$prev = @$HTTP_POST_VARS['prev']; $prev_file = @$HTTP_POST_FILES['prev_file']['tmp_name'];
$title_lv = trim(@$HTTP_POST_VARS['title_lv']); if(!$title_lv) $title_lv = "-";
//$title_en = trim(@$HTTP_POST_VARS['title_en']); if(!$title_en) $title_en = "-";
$title = $title_ru . "##" . $title_lv . "##" . $title_en;
$ord = @$HTTP_POST_VARS['ord'];
// ------------------------------ DELETE RECORD ------------------------------
if($action == "delete" && $id) {
$result = deleteRecord("subtypes", $id);
if($result == "ok") {
$query = "DELETE FROM wares WHERE id_subtype='$id'";
mysql_query($query);
}
$action = "index";
unset($id);
}
// ------------------------------ ADD NEW RECORD ------------------------------
elseif($action == "add") {
// kodiruem dannie
$title = convHEX2Letters($title);
$variables = array("title");
magic_quotes_encode();
$query = "INSERT INTO subtypes SET id_type='$id_type', title='$title', ord='$ord'";
if(!mysql_query($query)) printMySqlError();
else header("Location: ?lang=$lang&id_type=$id_type&PHPSESSID=$PHPSESSID");
exit;
}
// ------------------------------ UPDATE RECORD ---------------------------------------------------
elseif($action == "update" && $id) {
// kodiruem dannie
$title = convHEX2Letters($title);
$variables = array("title");
magic_quotes_encode();
$query = "UPDATE subtypes SET title='$title', ord='$ord' WHERE id='$id'";
if(!mysql_query($query)) printMySqlError();
else header("Location: ?lang=$lang&id_type=$id_type&PHPSESSID=$PHPSESSID");
exit;
}
// ------------------------------ NEW/EDIT FORM ------------------------------
if($action == "new" || ($action == "edit" && $id)) {
if($action == "new") {
$title_ru = "-";
$title_lv = "-";
$title_en = "-";
$ord = 0;
}
if($action == "edit") {
$query = "SELECT title, ord FROM subtypes WHERE id='$id'";
if(!($result = mysql_query($query))) {
displayAdminError(mysql_errno() . ": " . mysql_error());
}
else {
list($title, $ord) = mysql_fetch_row($result);
// dekodiruem dannie
$variables = array("title");
magic_quotes_decode();
list($title_ru, $title_lv, $title_en) = explode("##", $title);
}
}
displayAdminHeader(strtoupper($action) . " - CATEGORY IN " . $DEF['WARES_TYPES'][$id_type]);
displayMenu();
if($action == "new") $cAction = "add"; else $cAction = "update";
echo "<form method=\"post\" action=\"?lang=$lang&action=$cAction&id_type=$id_type&id=$id\">\n";
echo "<table width=\"95%\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" class=gr_br>\n";
insertText("Title (Russian)", "title_ru", 80, 80);
insertText("Title (Latvian)", "title_lv", 80, 80);
//insertText("Title (English)", "title_en", 80, 80);
insertText("Order Tag", "ord", 6, 6);
insertButtons($action);
echo "</table>\n";
echo "</form>\n";
displayMenu();
displayAdminFooter();
}
// ------------------------------ INDEX -----------------------------------------------------
if($action == "index") {
$orderby = @$HTTP_GET_VARS['orderby'];
if($orderby) $q_ord = "ORDER BY $orderby";
else $q_ord = "ORDER BY ord";
$query = "SELECT id, title, ord FROM subtypes WHERE id_type='$id_type' $q_ord";
if(!($result = mysql_query($query))) {
displayAdminError(mysql_error());
}
else {
displayAdminHeader("LIST OF CATEGORIES IN " . $DEF['WARES_TYPES'][$id_type]);
displayMenu();
$nAffected = mysql_affected_rows();
if(!$nAffected) {
printLN();
echo "<h4>No records in <b>SUBTYPES</b> FOR " . $DEF['WARES_TYPES'][$id_type] . "</h4>\n";
printLN();
}
else {
echo "<h1>Total: <font color=#FF6666>$nAffected</font> records in table</h1>";
echo "<div align=center><table cellpadding=3 cellspacing=1 width=95% class=gr_br>\n";
printTableHdr();
for($i = 1; $i <= $nAffected; $i++) {
list($id, $title, $ord) = mysql_fetch_row($result);
// dekodiruem dannie
$variables = array("title");
magic_quotes_decode();
list($title_ru, $title_lv, $title_en) = explode("##", $title);
$cl_data = $i % 2 == 0 ? "gray" : "dgray";
echo "<tr>\n";
echo "<td class=$cl_data>" . $id . "</td>\n";
echo "<td class=ops align=center><a href=\"?lang=$lang&action=edit&id_type=$id_type&id=$id\"><img src=\"img/btn_edit.gif\" width=12 height=12 border=0 alt=Edit></a> | <a href=\"?lang=$lang&action=delete&id_type=$id_type&id=$id\"><img src=\"img/btn_tbin.gif\" width=12 height=12 border=0 alt=Delete></a></td>\n";
echo "<td class=\"$cl_data\">" . $title_ru . "</td>\n";
echo "<td class=\"$cl_data\">" . $title_lv . "</td>\n";
echo "<td class=\"$cl_data\">" . $title_en . "</td>\n";
echo "<td class=\"$cl_data\">" . $ord . "</td>\n";
echo "</tr>\n";
}
printTableHdr();
echo "</table><br><br></div>\n";
}
}
displayMenu();
displayAdminFooter();
}
// --------------------------------- MENU --------------------------------------------------
function displayMenu()
{
global $lang, $id_type;
echo "<table width=100% border=0 cellspacing=0 cellpadding=0>\n";
echo "<tr>\n";
echo "<td bgcolor=\"#EEEEEE\" align=\"right\" height=\"24\" class=gr_tb_br>\n";
echo "<a href=\"?lang=$lang&id_type=$id_type&action=new\"><img src=\"img/btn_new.gif\" border=0 align=absmiddle>New Record</a> |\n";
echo "<a href=\"?lang=$lang&id_type=$id_type\"><img src=\"img/btn_list.gif\" border=0 align=absmiddle> List of Records</a> |\n";
echo "<a href=\"admin.php\"><img src=\"img/btn_admpnl.gif\" border=0 align=absmiddle> Admin Panel</a> </td>\n";
echo "</tr>\n";
echo "</table>\n";
}
function printTableHdr()
{
global $lang, $id_type, $DEF;
echo "<tr>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&orderby=id>ID</a></td>\n";
echo " <td class=head>Ops</td>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&orderby=title>TITLE (RUSSIAN)</a></td>\n";
echo " <td class=head>TITLE (LATVIAN)</td>\n";
//echo " <td class=head>TITLE (ENGLISH)</td>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&orderby=ord>ORDER</a></td>\n";
echo "</tr>\n";
}
?>
// ----end table subtype ----
есть таблица wares для добавления в выбранную категорию товаров (создание, редактирование, удаление)
// ----start table wares ----
<?php
include("adminlib.inc.php");
include("sys/datepicker.lib.php");
include("../sys/lib/magic_quotes.inc.php");
include("../sys/lib/str.lib.php");
include("../sys/wares/wares.def.php");
include("../sys/foto/foto.def.php");
include("sys/htmlarea/htmlarea.lib.php");
checkAdminLogin();
dbConnect();
// --- GET VARS ---
$action = @$HTTP_GET_VARS['action']; if(!$action) $action = "index";
$id = @$HTTP_GET_VARS['id'];
$id_type = @$HTTP_GET_VARS['id_type']; if(!$id_type) $id_type = "1";
$id_subtype = @$HTTP_GET_VARS['id_subtype'];
$id_foto = @$HTTP_GET_VARS['id_foto'];
$DEF_PATH = "res/wares";
// --- POST VARS ---
$title = trim(@$HTTP_POST_VARS['title']);
$spopup = @$HTTP_POST_VARS['spopup']; $spopup_file = @$HTTP_POST_FILES['spopup_file']['tmp_name'];
$prev1 = @$HTTP_POST_VARS['prev1']; $prev1_file = @$HTTP_POST_FILES['prev1_file']['tmp_name'];
$popup1 = @$HTTP_POST_VARS['popup1']; $popup1_file = @$HTTP_POST_FILES['popup1_file']['tmp_name'];
$prev2 = @$HTTP_POST_VARS['prev2']; $prev2_file = @$HTTP_POST_FILES['prev2_file']['tmp_name'];
$popup2 = @$HTTP_POST_VARS['popup2']; $popup2_file = @$HTTP_POST_FILES['popup2_file']['tmp_name'];
$prev3 = @$HTTP_POST_VARS['prev3']; $prev3_file = @$HTTP_POST_FILES['prev3_file']['tmp_name'];
$popup3 = @$HTTP_POST_VARS['popup3']; $popup3_file = @$HTTP_POST_FILES['popup3_file']['tmp_name'];
$prev4 = @$HTTP_POST_VARS['prev4']; $prev4_file = @$HTTP_POST_FILES['prev4_file']['tmp_name'];
$popup4 = @$HTTP_POST_VARS['popup4']; $popup4_file = @$HTTP_POST_FILES['popup4_file']['tmp_name'];
$prev5 = @$HTTP_POST_VARS['prev5']; $prev5_file = @$HTTP_POST_FILES['prev5_file']['tmp_name'];
$popup5 = @$HTTP_POST_VARS['popup5']; $popup5_file = @$HTTP_POST_FILES['popup5_file']['tmp_name'];
$prev6 = @$HTTP_POST_VARS['prev6']; $prev6_file = @$HTTP_POST_FILES['prev6_file']['tmp_name'];
$popup6 = @$HTTP_POST_VARS['popup6']; $popup6_file = @$HTTP_POST_FILES['popup6_file']['tmp_name'];
$prev7 = @$HTTP_POST_VARS['prev7']; $prev7_file = @$HTTP_POST_FILES['prev7_file']['tmp_name'];
$popup7 = @$HTTP_POST_VARS['popup7']; $popup7_file = @$HTTP_POST_FILES['popup7_file']['tmp_name'];
$prev8 = @$HTTP_POST_VARS['prev8']; $prev8_file = @$HTTP_POST_FILES['prev8_file']['tmp_name'];
$popup8 = @$HTTP_POST_VARS['popup8']; $popup8_file = @$HTTP_POST_FILES['popup8_file']['tmp_name'];
$prev9 = @$HTTP_POST_VARS['prev9']; $prev9_file = @$HTTP_POST_FILES['prev9_file']['tmp_name'];
$popup9 = @$HTTP_POST_VARS['popup9']; $popup9_file = @$HTTP_POST_FILES['popup9_file']['tmp_name'];
$prev10 = @$HTTP_POST_VARS['prev10']; $prev10_file = @$HTTP_POST_FILES['prev10_file']['tmp_name'];
$popup10 = @$HTTP_POST_VARS['popup10']; $popup10_file = @$HTTP_POST_FILES['popup10_file']['tmp_name'];
$prev11 = @$HTTP_POST_VARS['prev11']; $prev11_file = @$HTTP_POST_FILES['prev11_file']['tmp_name'];
$popup11 = @$HTTP_POST_VARS['popup11']; $popup11_file = @$HTTP_POST_FILES['popup11_file']['tmp_name'];
$prev_foto = @$HTTP_POST_VARS['prev_foto']; $prev_foto_file = @$HTTP_POST_FILES['prev_foto_file']['tmp_name'];
$popup_foto = @$HTTP_POST_VARS['popup_foto']; $popup_foto_file = @$HTTP_POST_FILES['popup_foto_file']['tmp_name'];
$descr = trim(@$HTTP_POST_VARS['descr']);
$price = @$HTTP_POST_VARS['price'];
$made = @$HTTP_POST_VARS['made'];
$price2 = @$HTTP_POST_VARS['price2'];
$size = @$HTTP_POST_VARS['size'];
$date = getDateFromPicker("d", @$HTTP_POST_VARS['date']);
$ord = @$HTTP_POST_VARS['ord'];
// ------------------------------ UPLOADING PICTURES -------------------------
$spopup = moveUploadedFile($spopup_file, $DEF_PATH, "spopup_file", $spopup); if($spopup == $DEF_PATH . "/") $spopup = "";
$prev1 = moveUploadedFile($prev1_file, $DEF_PATH, "prev1_file", $prev1); if($prev1 == $DEF_PATH . "/") $prev1 = "";
$popup1 = moveUploadedFile($popup1_file, $DEF_PATH, "popup1_file", $popup1); if($popup1 == $DEF_PATH . "/") $popup1 = "";
$prev2 = moveUploadedFile($prev2_file, $DEF_PATH, "prev2_file", $prev2); if($prev2 == $DEF_PATH . "/") $prev2 = "";
$popup2 = moveUploadedFile($popup2_file, $DEF_PATH, "popup2_file", $popup2); if($popup2 == $DEF_PATH . "/") $popup2 = "";
$prev3 = moveUploadedFile($prev3_file, $DEF_PATH, "prev3_file", $prev3); if($prev3 == $DEF_PATH . "/") $prev3 = "";
$popup3 = moveUploadedFile($popup3_file, $DEF_PATH, "popup3_file", $popup3); if($popup3 == $DEF_PATH . "/") $popup3 = "";
$prev4 = moveUploadedFile($prev4_file, $DEF_PATH, "prev4_file", $prev4); if($prev4 == $DEF_PATH . "/") $prev4 = "";
$popup4 = moveUploadedFile($popup4_file, $DEF_PATH, "popup4_file", $popup4); if($popup4 == $DEF_PATH . "/") $popup4 = "";
$prev5 = moveUploadedFile($prev5_file, $DEF_PATH, "prev5_file", $prev5); if($prev5 == $DEF_PATH . "/") $prev5 = "";
$popup5 = moveUploadedFile($popup5_file, $DEF_PATH, "popup5_file", $popup5); if($popup5 == $DEF_PATH . "/") $popup5 = "";
$prev6 = moveUploadedFile($prev6_file, $DEF_PATH, "prev6_file", $prev6); if($prev6 == $DEF_PATH . "/") $prev6 = "";
$popup6 = moveUploadedFile($popup6_file, $DEF_PATH, "popup6_file", $popup6); if($popup6 == $DEF_PATH . "/") $popup6 = "";
$prev7 = moveUploadedFile($prev7_file, $DEF_PATH, "prev7_file", $prev7); if($prev7 == $DEF_PATH . "/") $prev7 = "";
$popup7 = moveUploadedFile($popup7_file, $DEF_PATH, "popup7_file", $popup7); if($popup7 == $DEF_PATH . "/") $popup7 = "";
$prev8 = moveUploadedFile($prev8_file, $DEF_PATH, "prev8_file", $prev8); if($prev8 == $DEF_PATH . "/") $prev8 = "";
$popup8 = moveUploadedFile($popup8_file, $DEF_PATH, "popup8_file", $popup8); if($popup8 == $DEF_PATH . "/") $popup8 = "";
$prev9 = moveUploadedFile($prev9_file, $DEF_PATH, "prev9_file", $prev9); if($prev9 == $DEF_PATH . "/") $prev9 = "";
$popup9 = moveUploadedFile($popup9_file, $DEF_PATH, "popup9_file", $popup9); if($popup9 == $DEF_PATH . "/") $popup9 = "";
$prev10 = moveUploadedFile($prev10_file, $DEF_PATH, "prev10_file", $prev10);if($prev10 == $DEF_PATH . "/") $prev10 = "";
$popup10 = moveUploadedFile($popup10_file, $DEF_PATH, "popup10_file", $popup10); if($popup10 == $DEF_PATH . "/") $popup10 = "";
$prev11 = moveUploadedFile($prev11_file, $DEF_PATH, "prev11_file", $prev11);if($prev11 == $DEF_PATH . "/") $prev11 = "";
$popup11 = moveUploadedFile($popup11_file, $DEF_PATH, "popup11_file", $popup11); if($popup11 == $DEF_PATH . "/") $popup11 = "";
$prev_foto = moveUploadedFile($prev_foto_file, $DEF_PATH, "prev_foto_file", $prev_foto);if($prev_foto == $DEF_PATH . "/") $prev_foto = "";
$popup_foto = moveUploadedFile($popup_foto_file, $DEF_PATH, "popup_foto_file", $popup_foto); if($popup_foto == $DEF_PATH . "/") $popup_foto = "";
// ------------------------------ DELETE RECORD ------------------------------
if($action == "delete" && $id) {
deleteRecord("wares", $id);
$action = "index";
unset($id);
}
// ------------------------------ ADD NEW RECORD ------------------------------
elseif($action == "add") {
// kodiruem dannie
$variables = array("title", "descr");
magic_quotes_encode();
$query = "INSERT INTO wares SET lang='$lang', id_type='$id_type', id_subtype='$id_subtype', id_foto='$id_foto', title='$title', prev1='$prev1', spopup='$spopup', popup1='$popup1', prev2='$prev2', popup2='$popup2', prev3='$prev3', popup3='$popup3', prev4='$prev4', popup4='$popup4', prev5='$prev5', popup5='$popup5', prev6='$prev6', popup6='$popup6', prev7='$prev7', popup7='$popup7', prev8='$prev8', popup8='$popup8', prev9='$prev9', popup9='$popup9', prev10='$prev10', popup10='$popup10', prev11='$prev11', popup11='$popup11', descr='$descr', pdf='$pdf', price='$price', made='$made', price2='$price2', size='$size', date='$date', ord='$ord'";
if(!mysql_query($query)) printMySqlError();
else header("Location: ?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&PHPSESSID=$PHPSESSID");
exit;
}
// ------------------------------ UPDATE RECORD ---------------------------------------------------
elseif($action == "update" && $id) {
// kodiruem dannie
$variables = array("title", "descr");
magic_quotes_encode();
$query = "UPDATE wares SET lang='$lang', id_type='$id_type', id_subtype='$id_subtype', title='$title', prev1='$prev1', spopup='$spopup', popup1='$popup1', prev2='$prev2', popup2='$popup2', prev3='$prev3', popup3='$popup3', prev4='$prev4', popup4='$popup4', prev5='$prev5', popup5='$popup5', prev6='$prev6', popup6='$popup6', prev7='$prev7', popup7='$popup7', prev8='$prev8', popup8='$popup8', prev9='$prev9', popup9='$popup9', prev10='$prev10', popup10='$popup10', prev11='$prev11', popup11='$popup11', descr='$descr', pdf='$pdf', price='$price', made='$made', price2='$price2', size='$size', date='$date', ord='$ord' WHERE id='$id'";
if(!mysql_query($query)) printMySqlError();
else header("Location: ?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&PHPSESSID=$PHPSESSID");
exit;
}
// ------------------------------ NEW/EDIT FORM ------------------------------
if($action == "new" || ($action == "edit" && $id)) {
if($action == "new") {
$spopup = $DEF_PATH . "/";
$prev1 = $DEF_PATH . "/";
$popup1 = $DEF_PATH . "/";
$prev2 = $DEF_PATH . "/";
$popup2 = $DEF_PATH . "/";
$prev3 = $DEF_PATH . "/";
$popup3 = $DEF_PATH . "/";
$prev4 = $DEF_PATH . "/";
$popup4 = $DEF_PATH . "/";
$prev5 = $DEF_PATH . "/";
$popup5 = $DEF_PATH . "/";
$prev6 = $DEF_PATH . "/";
$popup6 = $DEF_PATH . "/";
$prev7 = $DEF_PATH . "/";
$popup7 = $DEF_PATH . "/";
$prev8 = $DEF_PATH . "/";
$popup8 = $DEF_PATH . "/";
$prev9 = $DEF_PATH . "/";
$popup9 = $DEF_PATH . "/";
$prev10 = $DEF_PATH . "/";
$popup10 = $DEF_PATH . "/";
$prev11 = $DEF_PATH . "/";
$popup11 = $DEF_PATH . "/";
$prev_foto = $DEF_PATH . "/prev/";
$popup_foto = $DEF_PATH . "/";
//$pdf = $DEF_PATH . "/";
$date = date("Y-m-d");
$ord = 0;
}
if($action == "edit") {
$query = "SELECT title, title_foto, prev1, spopup, popup1, prev2, popup2, prev3, popup3, prev4, popup4, prev5, popup5, prev6, popup6, prev7, popup7, prev8, popup8, prev9, popup9, prev10, popup10, prev11, popup11, prev_foto, popup_foto, descr, pdf, price, made, price2, size, date, ord FROM wares WHERE id='$id'";
if(!($result = mysql_query($query))) {
displayAdminError(mysql_errno() . ": " . mysql_error());
}
else {
list($title, $title_foto, $prev1, $spopup, $popup1, $prev2, $popup2, $prev3, $popup3, $prev4, $popup4, $prev5, $popup5, $prev6, $popup6, $prev7, $popup7, $prev8, $popup8, $prev9, $popup9, $prev10, $popup10, $prev11, $popup11, $prev_foto, $popup_foto, $descr, $pdf, $price, $made, $price2, $size, $date, $ord) = mysql_fetch_row($result);
// dekodiruem dannie
$variables = array("title", "descr");
magic_quotes_decode();
}
}
displayAdminHeader(strtoupper($action) . " - WARE IN " . $DEF['WARES_TYPES'][$id_type]);
displayMenu();
if($action == "new") $cAction = "add"; else $cAction = "update";
echo "<form method=\"post\" action=\"?lang=$lang&action=$cAction&id_type=$id_type&id_subtype=$id_subtype&id=$id\" enctype=\"multipart/form-data\">\n";
echo "<table width=\"95%\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" class=gr_br>\n";
insertButtons($action);
insertText("Title", "title", 255, 100);
insertFile("Главная картинка (" . $DEF['WARE_PREV_W'] . "x" . $DEF['WARE_PREV_H'] . ")", "prev1", 180);
insertFile("Средняя картинка (450 х 312)", "spopup", 100);
insertHTMLArea("Description", "descr", "800", 200);
insertFile("Картинка мал. 1 - 125x74 ", "prev2", 100);
insertFile("Картинка бол. 1 - 800x600", "popup2", 100);
insertFile("Картинка мал. 2 - 125x74 ", "prev3", 100);
insertFile("Картинка бол. 2 - 800x600", "popup3", 100);
insertFile("Картинка мал. 3 - 125x74 ", "prev4", 100);
insertFile("Картинка бол. 3 - 800x600", "popup4", 100);
insertFile("Картинка мал. 4 - 125x74 ", "prev5", 100);
insertFile("Картинка бол. 4 - 800x600", "popup5", 100);
insertFile("Картинка мал. 5 - 125x74 ", "prev6", 100);
insertFile("Картинка бол. 5 - 800x600", "popup6", 100);
insertFile("Картинка мал. 6 - 125x74 ", "prev7", 100);
insertFile("Картинка бол. 6 - 800x600", "popup7", 100);
insertFile("Картинка мал. 7 - 125x74 ", "prev8", 100);
insertFile("Картинка бол. 7 - 800x600", "popup8", 100);
insertFile("Картинка мал. 8 - 125x74 ", "prev9", 100);
insertFile("Картинка бол. 8 - 800x600", "popup9", 100);
insertFile("Картинка мал. 9 - 125x74 ", "prev10", 100);
insertFile("Картинка бол. 9 - 800x600", "popup10", 100);
insertFile("Картинка мал. 10 - 125x74 ", "prev11", 100);
insertFile("Картинка бол. 10 - 800x600", "popup11", 100);
insertText("Производитель", "made", 50, 50);
insertText("Цена", "price", 50, 50);
insertText("Название элемента", "title_foto", 255, 100);
insertFile("Картинка мал. (" . $LNG['FOTO_PREV_W'] . "x" . $LNG['FOTO_PREV_H'] . ")", "prev_foto", 100);
insertFile("Картинка бол.", "popup_foto", 100);
insertText("Размеры", "size", 50, 50);
insertText("Цена элемента", "price2", 50, 50);
insertDate("Date", "d", $date);
insertText("Order Tag", "ord", 6, 6);
insertButtons($action);
echo "</table>\n";
echo "</form>\n";
displayMenu();
displayAdminFooter();
}
// ------------------------------ INDEX -----------------------------------------------------
if($action == "index") {
displayAdminHeader("LIST OF WARES IN " . $DEF['WARES_TYPES'][$id_type]);
displayMenu();
echo "<table width=100% border=0 cellpadding=5 cellspacing=0>\n";
echo "<tr>\n";
echo "<td bgcolor=#EEEEEE valign=top style='border-right: 1px solid #CCCCCC'>\n";
$query = "SELECT id, title FROM subtypes WHERE id_type='$id_type' ORDER BY ord";
if( ($r = mysql_query($query)) && ($iAff = mysql_affected_rows()) ) {
for($i = 0; $i < $iAff; $i++) {
list($id, $title) = mysql_fetch_row($r);
$variables = array("title");
magic_quotes_decode();
$title = splitTextIntoLang($title, "##", $lang);
if($id == $id_subtype) {
echo "<li><b>" . $title . "</b>";
}
else {
echo "<li><a href=?lang=$lang&id_type=$id_type&id_subtype=$id>" . $title . "</a>";
// echo "<li><a href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id=$id>" . $title . "</a>";
}
}
}
echo "</td>\n";
echo "<td valign=top>\n";
$orderby = @$HTTP_GET_VARS['orderby'];
if($orderby) $q_ord = "ORDER BY $orderby";
else $q_ord = "ORDER BY ord";
$query = "SELECT id, title, title_foto, spopup, prev1, popup1, prev2, popup2, prev3, popup3, prev4, popup4, prev5, popup5, prev6, popup6, prev7, popup7, prev8, popup8, prev9, popup9, prev10, popup10, prev11, popup11, prev_foto, popup_foto, MID(descr, 1, 32), price, made, price2, size, DATE_FORMAT(date, '%d.%m.%Y'), ord FROM wares WHERE lang='$lang' && id_type='$id_type' && id_subtype='$id_subtype' && id_foto='$id_foto' $q_ord";
if(!($result = mysql_query($query))) {
displayAdminError(mysql_error());
}
else {
$nAffected = mysql_affected_rows();
if(!$nAffected) {
printLN();
//echo "<h4>No records in <b>WARES</b> FOR " . $DEF['WARES_TYPES'][$id_type] . "</h4>\n";
printLN();
}
else {
echo "<h1>Total: <font color=#FF6666>$nAffected</font> records in table</h1>";
echo "<div align=center><table cellpadding=3 cellspacing=1 width=95% class=gr_br>\n";
printTableHdr();
for($i = 1; $i <= $nAffected; $i++) {
list($id, $title, $spopup, $prev1, $popup1, $prev2, $popup2, $prev3, $popup3, $prev4, $popup4, $prev5, $popup5, $prev6, $popup6, $prev7, $popup7, $prev8, $popup8, $prev9, $popup9, $prev10, $popup10, $prev11, $popup11, $elemprev, $elempopup, $descr, $pdf, $price, $price2, $size, $date, $ord) = mysql_fetch_row($result);
// dekodiruem dannie
$variables = array("title", "descr");
magic_quotes_decode();
$prev1 = (file_exists("../$prev1") && $prev1 ? "<img src=\"../" . $prev1 . "\" border=1 width=" . $DEF['WARE_PREV_W'] . " height=" . $DEF['WARE_PREV_H'] . " alt=''>" : "x<br>$prev1");
$prev2 = (file_exists("../$prev2") && $prev2 ? "<img src=\"../" . $prev2 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev2");
$prev3 = (file_exists("../$prev3") && $prev3 ? "<img src=\"../" . $prev3 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev3");
$prev4 = (file_exists("../$prev4") && $prev4 ? "<img src=\"../" . $prev4 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev4");
$prev5 = (file_exists("../$prev5") && $prev5 ? "<img src=\"../" . $prev5 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev5");
$prev6 = (file_exists("../$prev6") && $prev6 ? "<img src=\"../" . $prev6 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev6");
$prev7 = (file_exists("../$prev7") && $prev7 ? "<img src=\"../" . $prev7 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev7");
$prev8 = (file_exists("../$prev8") && $prev8 ? "<img src=\"../" . $prev8 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev8");
$prev9 = (file_exists("../$prev9") && $prev9 ? "<img src=\"../" . $prev9 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev9");
$prev10 = (file_exists("../$prev10") && $prev10 ? "<img src=\"../" . $prev10 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev10");
$prev11 = (file_exists("../$prev11") && $prev11 ? "<img src=\"../" . $prev11 . "\" border=1 width=\"100\"\"80\" alt=''>" : "x<br>$prev11");
//$elemprev = (file_exists("../$elemprev") && $elemprev && substr($elemprev, -1) != "/" ? "<img src=\"../" . $elemprev . "\" border=1 width=40 height=30 alt=''>" : "x<br>$elemprev");
//$pdf = (file_exists("../$pdf") && $pdf && substr($pdf, -1) != "/" ? "<a href='../$pdf' target=_blank>$pdf</a>" : "<font color=red>Bad file link</font><br>$pdf");
$cl_data = $i % 2 == 0 ? "gray" : "dgray";
echo "<tr>\n";
echo "<td class=$cl_data>" . $id . "</td>\n";
echo "<td class=\"ops\" align=\"center\"><a href=\"?lang=$lang&action=edit&id_type=$id_type&id_subtype=$id_subtype&id=$id\"><img src=\"img/btn_edit.gif\" width=12 height=12 border=0 alt=Edit></a> | <a href=\"?lang=$lang&action=delete&id_type=$id_type&id_subtype=$id_subtype&id=$id\"><img src=\"img/btn_tbin.gif\" width=12 height=12 border=0 alt=Delete></a></td>\n";
//echo "<td class=\"ops\" align=\"center\"><a href=\"?lang=$lang&action=edit_foto&id_type=$id_type&id_subtype=$id_subtype&id=$id\"><img src=\"img/btn_edit.gif\" width=12 height=12 border=0 alt=Edit Foto></a> | <a href=\"?lang=$lang&action=delete_foto&id_type=$id_type&id_subtype=$id_subtype&id=$id\"><img src=\"img/btn_tbin.gif\" width=12 height=12 border=0 alt=Delete Foto></a></td>\n";
echo "<td class=\"$cl_data\">" . $title . "</td>\n";
echo "<td class=\"$cl_data\" align=center>" . $prev1 . "</td>\n";
//echo "<td class=\"$cl_data\"><a href='../" . $spopup . "' target=_blank>" . $spopup . "</a><br><a href='../" . $popup1 . "' target=_blank>" . $popup1 . "</a><br><a href='../" . $popup2 . "' target=_blank>" . $popup2 . "</a><br><a href='../" . $popup3 . "' target=_blank>" . $popup3 . "</a><br><a href='../" . $popup4 . "' target=_blank>" . $popup4 . "</a><br><a href='../" . $popup5 . "' target=_blank>" . $popup5 . "</a><br><a href='../" . $popup6 . "' target=_blank>" . $popup6 . "</a><br><a href='../" . $popup7 . "' target=_blank>" . $popup7 . "</a><br><a href='../" . $popup8 . "' target=_blank>" . $popup8 . "</a><br><a href='../" . $popup9 . "' target=_blank>" . $popup9 . "</a><br><a href='../" . $popup10 . "' target=_blank>" . $popup10 . "</a></td>\n";
echo "<td class=\"$cl_data\">" . strip_tags($descr) . "...</td>\n";
echo "<td class=\"$cl_data\">" . $price . "</td>\n";
//echo "<td class=\"$cl_data\">" . $made . "</td>\n";
echo "<td class=\"$cl_data\">" . $date . "</td>\n";
echo "<td class=\"$cl_data\">" . $ord . "</td>\n";
echo "</tr>\n";
}
printTableHdr();
echo "</table><br><br></div>\n";
}
}
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
displayMenu();
displayAdminFooter();
}
// --------------------------------- MENU --------------------------------------------------
function displayMenu()
{
global $lang, $id_type, $id_subtype;
echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
echo "<tr>\n";
echo "<td bgcolor=\"#EEEEEE\" align=\"right\" height=\"24\" class=gr_tb_br>\n";
echo ($lang == "ru" ? "<b>Russian</b>" : "<a href=?lang=ru&id_type=$id_type&id_subtype=$id_subtype>RU</a>") . " | \n";
echo ($lang == "lv" ? "<b>Latvian</b>" : "<a href=?lang=lv&id_type=$id_type&id_subtype=$id_subtype>LV</a>") . " | \n";
if($id_subtype) echo "<a href=\"?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&action=new\"><img src=\"img/btn_new.gif\" border=0 align=absmiddle>New Record</a> |\n";
// if($id_subtype) echo "<a href=\"?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id=$id&action=new_foto\"><img src=\"img/btn_new.gif\" border=0 align=absmiddle>New Elements</a> |\n";
if($id_subtype) echo "<a href=\"?lang=$lang&id_type=$id_type&id_subtype=$id_subtype\"><img src=\"img/btn_list.gif\" border=0 align=absmiddle> List of Records</a> |\n";
echo "<a href=\"admin.php\"><img src=\"img/btn_admpnl.gif\" border=0 align=absmiddle> Admin Panel</a> </td>\n";
echo "</tr>\n";
echo "</table>\n";
}
function printTableHdr()
{
global $lang, $id_type, $id_subtype, $DEF;
echo "<tr>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=id>ID</a></td>\n";
echo " <td class=head>Ops</td>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=title>TITLE</a></td>\n";
echo " <td class=head>FOTO</td>\n";
echo " <td class=head>POPUPS</td>\n";
//echo " <td class=head>MADE</td>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=descr>DESCR</a></td>\n";
//echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=pdf>MADE</a></td>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=price>PRICE</a></td>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=date>DATE</a></td>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&orderby=ord>ORDER</a></td>\n";
echo "</tr>\n";
}
//start foto
//end foto
?>
// ----end table wares ----
есть таблица wares2 для добавления в выбранную категорию дополнительного ассортимента товаров
//----table wares2-----
<?php
include("adminlib.inc.php");
include("sys/datepicker.lib.php");
include("../sys/lib/magic_quotes.inc.php");
include("../sys/lib/str.lib.php");
include("../sys/wares/wares.def.php");
include("../sys/foto/foto.def.php");
include("sys/htmlarea/htmlarea.lib.php");
checkAdminLogin();
dbConnect();
// --- GET VARS ---
$action = @$HTTP_GET_VARS['action']; if(!$action) $action = "index";
$id = @$HTTP_GET_VARS['id'];
$id_type = @$HTTP_GET_VARS['id_type']; if(!$id_type) $id_type = "1";
$id_subtype = @$HTTP_GET_VARS['id_subtype'];
$id_foto = @$HTTP_GET_VARS['id_foto'];
$DEF_PATH = "res/wares2";
// --- POST VARS ---
$title = trim(@$HTTP_POST_VARS['title']);
$prev_foto = @$HTTP_POST_VARS['prev_foto']; $prev_foto_file = @$HTTP_POST_FILES['prev_foto_file']['tmp_name'];
$popup_foto = @$HTTP_POST_VARS['popup_foto']; $popup_foto_file = @$HTTP_POST_FILES['popup_foto_file']['tmp_name'];
$descr = trim(@$HTTP_POST_VARS['descr']);
$price = @$HTTP_POST_VARS['price'];
$made = @$HTTP_POST_VARS['made'];
$price2 = @$HTTP_POST_VARS['price2'];
$size = @$HTTP_POST_VARS['size'];
$date = getDateFromPicker("d", @$HTTP_POST_VARS['date']);
$ord = @$HTTP_POST_VARS['ord'];
// ------------------------------ UPLOADING PICTURES -------------------------
$prev_foto = moveUploadedFile($prev_foto_file, $DEF_PATH, "prev_foto_file", $prev_foto);if($prev_foto == $DEF_PATH . "/") $prev_foto = "";
$popup_foto = moveUploadedFile($popup_foto_file, $DEF_PATH, "popup_foto_file", $popup_foto); if($popup_foto == $DEF_PATH . "/") $popup_foto = "";
// ------------------------------ DELETE RECORD ------------------------------
if($action == "delete" && $id) {
deleteRecord("wares2", $id);
$action = "index";
unset($id);
}
// ------------------------------ ADD NEW RECORD ------------------------------
elseif($action == "add") {
// kodiruem dannie
$variables = array("title", "descr");
magic_quotes_encode();
$query = "INSERT INTO wares2 SET lang='$lang', id='$id', id_type='$id_type', id_subtype='$id_subtype', id_foto='$id_foto', title='$title', prev_foto='$prev_foto', popup_foto='$popup_foto', descr='$descr', price='$price', made='$made', price2='$price2', size='$size', date='$date', ord='$ord'";
if(!mysql_query($query)) printMySqlError();
else header("Location: ?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&PHPSESSID=$PHPSESSID");
exit;
}
// ------------------------------ UPDATE RECORD ---------------------------------------------------
elseif($action == "update" && $id) {
// kodiruem dannie
$variables = array("title", "descr");
magic_quotes_encode();
$query = "UPDATE wares2 SET lang='$lang', id='$id', id_type='$id_type', id_subtype='$id_subtype', id_foto='$id_foto', title='$title', prev_foto='$prev_foto', popup_foto='$popup_foto', descr='$descr', price='$price', made='$made', price2='$price2', size='$size', date='$date', ord='$ord' WHERE id='$id'";
if(!mysql_query($query)) printMySqlError();
else header("Location: ?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&PHPSESSID=$PHPSESSID");
exit;
}
// ------------------------------ NEW/EDIT FORM ------------------------------
if($action == "new" || ($action == "edit" && $id )) {
if($action == "new") {
$spopup = $DEF_PATH . "/";
$prev1 = $DEF_PATH . "/";
$popup1 = $DEF_PATH . "/";
$prev_foto = $DEF_PATH . "/prev/";
$popup_foto = $DEF_PATH . "/";
//$pdf = $DEF_PATH . "/";
$date = date("Y-m-d");
$ord = 0;
}
if($action == "edit") {
$query = "SELECT title, title_foto, prev_foto, popup_foto, descr, price, made, price2, size, date, ord FROM wares2 WHERE id='$id'";
if(!($result = mysql_query($query))) {
displayAdminError(mysql_errno() . ": " . mysql_error());
}
else {
list($title, $title_foto, $prev_foto, $popup_foto, $descr, $price, $made, $price2, $size, $date, $ord) = mysql_fetch_row($result);
// dekodiruem dannie
$variables = array("title", "descr");
magic_quotes_decode();
}
}
displayAdminHeader(strtoupper($action) . " - WARE IN " . $DEF['WARES_TYPES'][$id_type]);
displayMenu();
if($action == "new") $cAction = "add"; else $cAction = "update";
echo "<form method=\"post\" action=\"?lang=$lang&action=$cAction&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto\" enctype=\"multipart/form-data\">\n";
echo "<table width=\"95%\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\" class=gr_br>\n";
insertButtons($action);
//insertText("Title", "title", 255, 100);
//insertText("Производитель", "made", 50, 50);
//insertText("Цена", "price", 50, 50);
insertText("Название элемента", "title", 255, 100);
insertFile("Картинка мал. (" . $LNG['FOTO_PREV_W'] . "x" . $LNG['FOTO_PREV_H'] . ")", "prev_foto", 100);
insertFile("Картинка бол.", "popup_foto", 100);
insertText("Размеры", "size", 50, 50);
insertText("Цена элемента", "price2", 50, 50);
insertDate("Date", "d", $date);
insertText("Order Tag", "ord", 6, 6);
insertButtons($action);
echo "</table>\n";
echo "</form>\n";
displayMenu();
displayAdminFooter();
}
// ------------------------------ INDEX -----------------------------------------------------
if($action == "index") {
displayAdminHeader("LIST OF wares2 IN " . $DEF['WARES_TYPES'][$id_type]);
displayMenu();
echo "<table width=100% border=0 cellpadding=5 cellspacing=0>\n";
echo "<tr>\n";
echo "<td bgcolor=#EEEEEE valign=top style='border-right: 1px solid #CCCCCC'>\n";
$query = "SELECT id, id_subtype, id_foto, title FROM wares WHERE id_type='$id_type' ORDER BY ord";
if( ($r = mysql_query($query)) && ($iAff = mysql_affected_rows()) ) {
for($i = 0; $i < $iAff; $i++) {
list($id, $id_subtype, $id_foto, $title) = mysql_fetch_row($r);
$variables = array("title");
magic_quotes_decode();
$title = splitTextIntoLang($title, "##", $lang);
if($id == $id_subtype ) {
echo "<li><b>" . $title . "</b>";
}
else {
echo "<li><a href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id>" . $title . "</a>";
//echo "<li><a href=?lang=$lang&id_type=$id_type&id_subtype=$id>" . $title . "</a>";
// echo "<li><a href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id=$id>" . $title . "</a>";
}
}
}
echo "</td>\n";
echo "<td valign=top>\n";
$orderby = @$HTTP_GET_VARS['orderby'];
if($orderby) $q_ord = "ORDER BY $orderby";
else $q_ord = "ORDER BY ord";
$query = "SELECT id, title, title_foto, prev_foto, popup_foto, MID(descr, 1, 32), price, made, price2, size, DATE_FORMAT(date, '%d.%m.%Y'), ord FROM wares2 WHERE lang='$lang' && id='$id' && id_type='$id_type' && id_subtype='$id_subtype' && id_foto='$id_foto' $q_ord";
if(!($result = mysql_query($query))) {
displayAdminError(mysql_error());
}
else {
$nAffected = mysql_affected_rows();
if(!$nAffected) {
printLN();
//echo "<h4>No records in <b>WARES</b> FOR " . $DEF['WARES_TYPES'][$id_type] . "</h4>\n";
printLN();
}
else {
echo "<h1>Total: <font color=#FF6666>$nAffected</font> records in table</h1>";
echo "<div align=center><table cellpadding=3 cellspacing=1 width=95% class=gr_br>\n";
printTableHdr();
for($i = 1; $i <= $nAffected; $i++) {
list($id, $title, $prev_foto, $popup_foto, $descr, $price, $price2, $size, $date, $ord) = mysql_fetch_row($result);
// dekodiruem dannie
$variables = array("title", "descr");
magic_quotes_decode();
$prev_foto = (file_exists("../$prev_foto") && $prev_foto ? "<img src=\"../" . $prev_foto . "\" border=1 width=" . $DEF['WARE_PREV_W'] . " height=" . $DEF['WARE_PREV_H'] . " alt=''>" : "x<br>$prev_foto");
$cl_data = $i % 2 == 0 ? "gray" : "dgray";
echo "<tr>\n";
echo "<td class=$cl_data>" . $id . "</td>\n";
echo "<td class=\"ops\" align=\"center\"><a href=\"?lang=$lang&action=edit&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto\"><img src=\"img/btn_edit.gif\" width=12 height=12 border=0 alt=Edit></a> | <a href=\"?lang=$lang&action=delete&id_type=$id_type&id_subtype=$id_subtype&id=$id\"><img src=\"img/btn_tbin.gif\" width=12 height=12 border=0 alt=Delete></a></td>\n";
echo "<td class=\"$cl_data\">" . $title . "</td>\n";
echo "<td class=\"$cl_data\" align=center>" . $prev_foto . "</td>\n";
echo "<td class=\"$cl_data\">" . strip_tags($descr) . "...</td>\n";
echo "<td class=\"$cl_data\">" . $price . "</td>\n";
echo "<td class=\"$cl_data\">" . $date . "</td>\n";
echo "<td class=\"$cl_data\">" . $ord . "</td>\n";
echo "</tr>\n";
}
printTableHdr();
echo "</table><br><br></div>\n";
}
}
echo "</td>\n";
echo "</tr>\n";
echo "</table>\n";
displayMenu();
displayAdminFooter();
}
// --------------------------------- MENU --------------------------------------------------
function displayMenu()
{
global $lang, $id, $id_type, $id_subtype, $id_foto;
echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
echo "<tr>\n";
echo "<td bgcolor=\"#EEEEEE\" align=\"right\" height=\"24\" class=gr_tb_br>\n";
echo ($lang == "ru" ? "<b>Russian</b>" : "<a href=?lang=ru&id_type=$id_type&id_subtype=$id_subtype>RU</a>") . " | \n";
echo ($lang == "lv" ? "<b>Latvian</b>" : "<a href=?lang=lv&id_type=$id_type&id_subtype=$id_subtype>LV</a>") . " | \n";
if($id_subtype) echo "<a href=\"?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&action=new\"><img src=\"img/btn_new.gif\" border=0 align=absmiddle>New Record</a> |\n";
// if($id_subtype) echo "<a href=\"?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id=$id&action=new_foto\"><img src=\"img/btn_new.gif\" border=0 align=absmiddle>New Elements</a> |\n";
if($id_subtype) echo "<a href=\"?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id=$id&id_foto=$id_foto\"><img src=\"img/btn_list.gif\" border=0 align=absmiddle> List of Records</a> |\n";
echo "<a href=\"admin.php\"><img src=\"img/btn_admpnl.gif\" border=0 align=absmiddle> Admin Panel</a> </td>\n";
echo "</tr>\n";
echo "</table>\n";
}
function printTableHdr()
{
global $lang, $id, $id_type, $id_subtype, $id_foto, $DEF;
echo "<tr>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=id>ID</a></td>\n";
echo " <td class=head>Ops</td>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=title>TITLE</a></td>\n";
//echo " <td class=head>FOTO</td>\n";
echo " <td class=head>POPUPS</td>\n";
//echo " <td class=head>MADE</td>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=descr>DESCR</a></td>\n";
//echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=pdf>MADE</a></td>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=price>PRICE</a></td>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=date>DATE</a></td>\n";
echo " <td class=head><a class=dark href=?lang=$lang&id_type=$id_type&id_subtype=$id_subtype&id_foto=$id_foto&orderby=ord>ORDER</a></td>\n";
echo "</tr>\n";
}
?>
//----end table wares2-----
не могу создать запрос с выводом дополнительного ассортимента товаров
//----страница вывода запросов-----
<?php
$id = @$HTTP_GET_VARS['id']; if(!$id) return;
$query = "SELECT wares.id, wares.id_subtype, wares.title, wares.title_foto, wares.prev1, wares.spopup, wares.popup1, wares.prev2, wares.popup2, wares.prev3, wares.popup3, wares.prev4, wares.popup4, wares.prev5, wares.popup5, wares.prev6, wares.popup6, wares.prev7, wares.popup7, wares.prev8, wares.popup8, wares.prev9, wares.popup9, wares.prev10, wares.popup10, wares.prev11, wares.popup11, wares.prev_foto, wares.popup_foto, wares.descr, wares.price, wares.size, wares.price2, subtypes.title, DATE_FORMAT(wares.date, '%d.%m.%Y') " .
"FROM wares, subtypes " .
"WHERE wares.lang='$lang' && wares.id='$id' && wares.id_subtype=subtypes.id ";
if( ($r = mysql_query($query)) && ($iAff = mysql_affected_rows()) ) {
list($id, $id_subtype, $title, $stitle, $prev1, $spopup, $popup1, $prev2, $popup2, $prev3, $popup3, $prev4, $popup4, $prev5, $popup5, $prev6, $popup6, $prev7, $popup7, $prev8, $popup8, $prev9, $popup9, $prev10, $popup10, $prev11, $popup11, $prev_foto, $popup_foto, $descr, $pdf, $price, $price2, $size, $stitle, $date) = mysql_fetch_row($r);
$variables = array("title", "stitle", "descr");
magic_quotes_decode();
$stitle = splitTextIntoLang($stitle, "##", $lang);
if(fileExists($prev1)) {
$prev1 = "<img src='" . $prev1 . "' border=1 width=" . $DEF['WARE_PREV_W'] . " height=" . $DEF['WARE_PREV_H'] . " alt=''>";
}
else {
$prev1 = "";
}
if(fileExists($prev2)) {
$prev2 = "<img src='" . $prev2 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev2 = "";
}
if(fileExists($prev3)) {
$prev3 = "<img src='" . $prev3 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev3 = "";
}
if(fileExists($prev4)) {
$prev4 = "<img src='" . $prev4 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev4 = "";
}
if(fileExists($prev5)) {
$prev5 = "<img src='" . $prev5 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev5 = "";
}
if(fileExists($prev6)) {
$prev6 = "<img src='" . $prev6 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev6 = "";
}
if(fileExists($prev7)) {
$prev7 = "<img src='" . $prev7 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev7 = "";
}
if(fileExists($prev8)) {
$prev8 = "<img src='" . $prev8 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev8 = "";
}
if(fileExists($prev9)) {
$prev9 = "<img src='" . $prev9 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev9 = "";
}
if(fileExists($prev10)) {
$prev10 = "<img src='" . $prev10 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev10 = "";
}
if(fileExists($prev11)) {
$prev11 = "<img src='" . $prev11 . "' border=1 width=\"125\" height=\"74\" alt=''>";
}
else {
$prev11 = "";
}
if(fileExists($prev_foto)) {
$prev_foto = "<img src='" . $prev_foto . "' border=1 width=\"100\" height=\"80\" alt=''>";
}
else {
$prev_foto = "";
}
//start new
echo " <br>\n";
echo " <tr>\n";
echo " <td class=\"producttitle\" colspan=\"3\"><span class=\"featureYourPrice\"> " . $LNG['WARES_TYPES'][$id_type] . " / <a href=index.php?lang=$lang&p=$p&id_type=$id_type&id_subtype=$id_subtype>" . $LNG['WARES_BACK'] . "</a></span><br /></td>\n";
echo " </tr>\n";
echo "<table cellspacing=\"0\" cellpadding=\"0\" width=\"760\" border=\"0\" align=center>\n";
echo " <tbody>\n";
echo "<p><br></p>\n";
echo " <div class=\"producttitle\" colspan=\"3\" align=center><span class=\"ch\">$title\n";
if($price > 0) {
echo "<div style=''>\n";
echo $LNG['WARES_PRICE'] . " : Ls " . sprintf("%0.2f", $price) . "</b>";
echo "</div>\n";
echo " </span></div>\n";
}
echo " <tr>\n";
echo " <td valign=\"center\" colspan=2 height=328 align=top><p align=\"center\"><span style=\"FONT-WEIGHT: 100\">\n";
echo " <img height=\"312\"\n";
echo " src=$spopup\n";
echo " width=\"450\" border=\"0\" /></a></span></p></td>\n";
echo " <td width=\"289\" height=\"454\" rowspan=\"2\" valign=\"top\"><table id=\"AutoNumber2\"\n";
echo " style=\"BORDER-COLLAPSE: collapse\"\n";
echo " bordercolor=\"#111111\" cellspacing=\"3\" cellpadding=\"5\"\n";
echo " width=\"100%\" border=\"0\">\n";
echo " <tbody>\n";
echo " <tr>\n";
//pic1
echo "<p><br></p>\n";
echo " <TD vAlign=top align=top>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev2) {
if(fileExists($popup2)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup2) . "','450','312','0');\">";
$prev2 = $sLink . $prev2 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
}
}
if($prev2) {
echo "<div style='margin-bottom: 2px;'>\n";
echo $prev2;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 2px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}
echo " </TBODY></TABLE></TD>\n";
//pic2
echo " <TD vAlign=top align=top>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev3) {
if(fileExists($popup3)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup3) . "','450','350','0');\">";
$prev3 = $sLink . $prev3 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
}
}
if($prev3) {
echo "<div style='margin-bottom: 2px;'>\n";
echo $prev3;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 2px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}
echo " </TBODY></TABLE></TD>\n";
// end pic2
echo " </tr>\n";
echo " <tr>\n";
//pic3
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev4) {
if(fileExists($popup4)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup4) . "','450','350','0');\">";
$prev4 = $sLink . $prev4 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
}
}
if($prev4) {
echo "<div style='margin-bottom: 2px;'>\n";
echo $prev4;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 2px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}
echo " </TBODY></TABLE></TD>\n";
//end pic3
//pic4
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev5) {
if(fileExists($popup5)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup5) . "','450','350','0');\">";
$prev5 = $sLink . $prev5 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
}
}
if($prev5) {
echo "<div style='margin-bottom: 2px;'>\n";
echo $prev5;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 2px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}
echo " </TBODY></TABLE></TD>\n";
//end pic4
echo " </tr>\n";
echo " <tr>\n";
//pic5
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev6) {
if(fileExists($popup6)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup6) . "','450','350','0');\">";
$prev6 = $sLink . $prev6 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
}
}
if($prev6) {
echo "<div style='margin-bottom: 5px;'>\n";
echo $prev6;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 5px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}
echo " </TBODY></TABLE></TD>\n";
//end pic5
//pic6
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev7) {
if(fileExists($popup7)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup7) . "','450','350','0');\">";
$prev7 = $sLink . $prev7 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
}
}
if($prev7) {
echo "<div style='margin-bottom: 5px;'>\n";
echo $prev7;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 5px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}
echo " </TBODY></TABLE></TD>\n";
//end pic6
echo " </tr>\n";
echo " <tr>\n";
//pic7
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev8) {
if(fileExists($popup8)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup8) . "','450','350','0');\">";
$prev8 = $sLink . $prev8 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
}
}
if($prev8) {
echo "<div style='margin-bottom: 5px;'>\n";
echo $prev8;
echo "</div>\n";
}
else {
echo "<div style='margin-bottom: 5px;'>\n";
//echo "<img class=imgbrd src=img/des/nopic.gif border=0 width=125 height=74 alt='no photo' align=center>";
echo "</div>\n";
}
echo " </TBODY></TABLE></TD>\n";
//end pic7
//pic8
echo " <TD vAlign=top align=middle>\n";
echo " <TABLE cellSpacing=0 cellPadding=0 width=125 height=74 \n";
echo " border=0>\n";
echo " <TBODY>\n";
echo " <TR>\n";
echo " <td nowrap=\"nowrap\" align=\"middle\"><div align=\"center\"><br />\n";
if($prev9) {
if(fileExists($popup9)) {
$sLink = "<a href=#null onclick=\"javscript:openwin('img.php?lang=$lang&i=" . rawurlencode($popup9) . "','450','350','0');\">";
$prev9 = $sLink . $prev9 . "</a>";
//$prev2 .= "<div class=sm>" . $sLink . $LNG['WARES_ENLARGE'] . "</a></div>";
}
}
i
[Это сообщение - спам!]
Последние сообщения из форума
Уважаемые посетители форума MySQL.RU!
Убедительная просьба, прежде чем задавать свой вопрос в этом форуме, обратите внимание на разделы:
- ответы на наиболее часто задаваемые вопросы - FAQ
- раздел документация
- раздел поиск по сообщениям форума и документации
Также, старайтесь наиболее подробно указывать свою ситуацию (версию операционной системы, версию MySQL,
версию программного обеспечения, по которому возникает вопрос, текст возникающих ошибок, и др.)
Помните, чем конкретнее Вы опишете ситуацию, тем больше шансов получить реальную помощь.
31249
|
|
