PHP mysql_where_str Examples

Example #1

File: deck_form_result.php Project: jjjj222/hsinfo

function print_deck_select_table($table, $attributes, $constraints)
{
    array_push($attributes, "id");
    #array_push($attributes, "delete");
    #var_dump($constraints);
    $attr_list_str = implode(', ', $attributes);
    $query = "SELECT {$attr_list_str} FROM {$table}";
    if (!empty($constraints)) {
        $cons_str = mysql_where_str($constraints);
        $query .= " WHERE {$cons_str}";
    }
    #$query .= ";";
    $query .= " ORDER BY name;";
    #print_msg($query);
    $result = mysql_query($query);
    $num = @mysql_numrows($result);
    print_msg("total = {$num}");
    if ($num == 0) {
        return;
    }
    echo "<table>";
    echo "<tr>";
    array_push($attributes, "delete");
    foreach ($attributes as $attr) {
        if ($attr != "id") {
            echo "<th>";
            echo $attr;
            echo "</th>";
        }
    }
    echo "</tr>";
    $i = 0;
    while ($i < $num) {
        $id = mysql_result($result, $i, "id");
        echo "<tr id=\"{$id}\">";
        foreach ($attributes as $attr) {
            if ($attr == "delete") {
                echo "<td>";
                echo "<button name=\"{$id}\">delete</button>";
                echo "</td>";
            } else {
                if ($attr != "id") {
                    $value = mysql_result($result, $i, $attr);
                    echo "<td>";
                    if ($attr == "link") {
                        echo "<a href=\"{$value}\">";
                        echo $value;
                        echo "</a>";
                    } else {
                        echo mysql_result($result, $i, $attr);
                    }
                    echo "</td>";
                }
            }
        }
        echo "</tr>";
        $i++;
    }
    echo "</table>";
}

Example #2

File: card_form_result.php Project: jjjj222/hsinfo

function print_card_select_table($table, $attributes, $constraints)
{
    #var_dump($constraints);
    $attr_list_str = implode(', ', $attributes);
    $query = "SELECT {$attr_list_str} FROM {$table}";
    if (!empty($constraints)) {
        $cons_str = mysql_where_str($constraints);
        $query .= " WHERE {$cons_str}";
    }
    $query .= ";";
    #print_msg($query);
    $result = mysql_query($query);
    $num = @mysql_numrows($result);
    print_msg("total = {$num}");
    if ($num == 0) {
        return;
    }
    echo "<table>";
    echo "<tr>";
    foreach ($attributes as $attr) {
        echo "<th>";
        echo $attr;
        echo "</th>";
    }
    echo "</tr>";
    $i = 0;
    while ($i < $num) {
        echo "<tr>";
        foreach ($attributes as $attr) {
            echo "<td>";
            echo mysql_result($result, $i, $attr);
            echo "</td>";
        }
        echo "</tr>";
        $i++;
    }
    echo "</table>";
}