PHP imlode Examples

Example #1

File: user.php Project: rasuldev/torino

 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;
 }

Example #2

File: hel_del.php Project: byryndyk/helly

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';