public static function GetListEx($arOrder = array("MIN_NUM_POSTS" => "ASC"), $arFilter = array()) { global $DB; $arSqlSearch = array(); $arSqlOrder = array(); $strSqlSearch = ""; $strSqlOrder = ""; $arFilter = is_array($arFilter) ? $arFilter : array(); foreach ($arFilter as $key => $val) { $key_res = CForumNew::GetFilterOperation($key); $key = strtoupper($key_res["FIELD"]); $strNegative = $key_res["NEGATIVE"]; $strOperation = $key_res["OPERATION"]; switch ($key) { case "ID": case "MIN_NUM_POSTS": if (intVal($val) <= 0) { $arSqlSearch[] = ($strNegative == "Y" ? "NOT" : "") . "(FR." . $key . " IS NULL OR FR." . $key . "<=0)"; } else { $arSqlSearch[] = ($strNegative == "Y" ? " FR." . $key . " IS NULL OR NOT " : "") . "(FR." . $key . " " . $strOperation . " " . intVal($val) . " )"; } break; case "LID": if (strLen($val) <= 0) { $arSqlSearch[] = ($strNegative == "Y" ? "NOT" : "") . "(FRL.LID IS NULL OR " . ($DB->type == "MSSQL" ? "LEN" : "LENGTH") . "(FRL.LID)<=0)"; } else { $arSqlSearch[] = ($strNegative == "Y" ? " FRL.LID IS NULL OR NOT " : "") . "(FRL.LID " . $strOperation . " '" . $DB->ForSql($val) . "' )"; } break; } } if (count($arSqlSearch) > 0) { $strSqlSearch = " AND (" . imlode(" ) AND (", $arSqlSearch) . ") "; } foreach ($arOrder as $by => $order) { $by = strtoupper($by); $order = strtoupper($order); if ($order != "ASC") { $order = "DESC"; } if ($by == "ID") { $arSqlOrder[] = " FR.ID " . $order . " "; } elseif ($by == "LID") { $arSqlOrder[] = " FRL.LID " . $order . " "; } elseif ($by == "NAME") { $arSqlOrder[] = " FRL.NAME " . $order . " "; } else { $arSqlOrder[] = " FR.MIN_NUM_POSTS " . $order . " "; $by = "MIN_NUM_POSTS"; } } DelDuplicateSort($arSqlOrder); if (count($arSqlOrder) > 0) { $strSqlOrder = " ORDER BY " . implode(", ", $arSqlOrder); } $strSql = "\n\t\t\tSELECT FR.ID, FR.MIN_NUM_POSTS, FRL.LID, FRL.NAME\n\t\t\tFROM b_forum_rank FR\n\t\t\t\tLEFT JOIN b_forum_rank_lang FRL ON FR.ID = FRL.RANK_ID\n\t\t\tWHERE 1 = 1\n\t\t\t" . $strSqlSearch . "\n\t\t\t" . $strSqlOrder; $db_res = $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__); return $db_res; }
include '../menu.php'; include '../mysql.php'; //var_dump($_GET); //var_dump($_POST); mysql_connect($dbip, $dbuser, $dbpas) or die("Не могу подключиться к базе данных"); mysql_select_db($dbname) or die(mysql_error()); $query = "SELECT id, type, number, air_number FROM {$dbt_h}"; $res = mysql_query($query) or die(mysql_error()); echo "<div name='hel_list'>"; echo "<div class='title'>Удалить</div>"; //echo "<table>"; while ($row = mysql_fetch_array($res)) { echo "<li>" . $row['type'] . " " . $row['number'] . " " . $row['air_number'] . " " . "<input type='checkbox' name='delete_h'value='" . $row['id'] . "'>" . "</li>"; //echo "<tr>\n"; // echo "<td>".$row['id']."</td>\n"; // echo "<td>".$row['type']."</td>\n"; // echo "<td>".$row['number']."</td>\n"; // echo "<td>".$row['air_number']."</td>\n"; // echo "<td>".'<input type="checkbox" name="delete_h" value='.$row['id'].'>'."</td>\n"; // echo "</tr>\n"; } //echo "</table>"; echo '<input type="submit" name="del_hel" value="Delete">'; echo '<button class="btn btn-warning" type="submit" name="del_hel" value="Delete">Удалить</button>'; if (isset($_GET['delete_h'])) { $id_s = imlode(',', $_POST['delete_h']); $query = 'DELTET FROM $dbt_h WHERE (id="$id_s")'; mysql_query($query) or die(mysql_error()); } mysql_close(); include '../end.php';