PHP get_all_get_valuesの例

コード例 #1

ファイル: card_section.php プロジェクト: jjjj222/hsinfo

function print_form()
{
    echo "<a href=\"card_section.php\">reset</a>";
    global $CARD_TABLE_NAME, $CARD_TABLE_SELECT_ATTR, $CARD_TABLE_SHOW_ATTR, $CARD_TABLE_TYPE_ATTR;
    echo "<form action=\"card_section.php\">";
    #print_form_select("type", $values, get_current_get_value("type"));
    print_all_form_select($CARD_TABLE_NAME, $CARD_TABLE_SELECT_ATTR);
    echo_br();
    #$name_value = get_current_get_value("name");
    #echo "name: <input type=\"text\" name=\"name\" value=\"$value\">";
    print_all_form_input($CARD_TABLE_TYPE_ATTR);
    #print_form_input("name", get_current_get_value("name"));
    echo "<br><br>";
    echo "<input type=\"submit\" value=\"search\">";
    echo "</form>";
    $constraints = get_all_get_values($CARD_TABLE_SHOW_ATTR);
    print_card_select_table($CARD_TABLE_NAME, $CARD_TABLE_SHOW_ATTR, $constraints);
}

コード例 #2

ファイル: card_form_result.php プロジェクト: jjjj222/hsinfo

<?php

include_once "html.php";
include_once "mysql_query.php";
?>

<?php 
$link = @mysql_connect("{$servername}", "{$username}", "{$password}");
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
@mysql_select_db($database) or die("Unable to select database");
$constraints = get_all_get_values($CARD_TABLE_SHOW_ATTR);
print_card_select_table($CARD_TABLE_NAME, $CARD_TABLE_SHOW_ATTR, $constraints);
mysql_close($link);
?>

<?php 
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);

コード例 #3

ファイル: deck_form_result.php プロジェクト: jjjj222/hsinfo

<?php

include_once "html.php";
include_once "mysql_query.php";
?>

<?php 
$link = @mysql_connect("{$servername}", "{$username}", "{$password}");
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
@mysql_select_db($database) or die("Unable to select database");
echo "<aside id=\"deck_table_side\"></aside>";
$constraints = get_all_get_values($DECK_TABLE_SHOW_ATTR);
print_deck_select_table($DECK_TABLE_NAME, $DECK_TABLE_SHOW_ATTR, $constraints);
mysql_close($link);
?>

<?php 
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 .= ";";