source: trunk/www/db_po/get_keys.php@ 11977

<?php
{
    ini_set("display_errors", "On");
    ini_set("mysql.trace_mode", "On");

    if (empty($_GET["fProgram"]))
    {
        echo "Please select a program.<br>";
        return;
    }
    if (empty($_GET["fKey"]))
        $_GET["fKey"]="";
    if (empty($_GET["fSelectSize"]))
        $_GET["fSelectSize"]="10";
    if (empty($_GET["fMode"]))
        $_GET["fMode"]="view";

    include("db.php");
    $db_id = mysql_pconnect($host, $user, $pw);
    if ($db_id==FALSE)
    {
        printf("mysql_connect returned the following error: %s\n", mysql_error());
        die("");
    }
    mysql_select_db($db);

    $query1 = "SELECT Max(fCounter) FROM History";
    $result1=mysql_query($query1, $db_id);
    $row1 = mysql_fetch_row($result1);
    $maxcounter=$row1[0];
    mysql_free_result($result1);

    $query0="SELECT Concat(fKey1, fKey2) as ourkeys from ProgramOption ";
    $query0.="WHERE fCounter=".$maxcounter." ";
    if ($_GET["fProgram"]!="all")
        $query0.="AND fProgram='".$_GET["fProgram"]."' ";
    $query0.="GROUP BY ourkeys";

    $result0=mysql_query($query0, $db_id);

    if (strcmp($_GET["fMode"], "edit")==0)
        printf("select key: <br>\n");
//    else
//        printf("select key: \n");

    if (strcmp($_GET["fMode"], "view")==0)//reload tables in case of mode 'view'
        printf("<select style='width:200px' id='key' size='%s' onchange='get_values(1,\"%s\",this.value,\"%s\");get_values(2,\"all\",\"all\");get_values(3,\"all\",\"all\");CompareValues();' class='Width'>\n",
               $_GET["fSelectSize"], $_GET["fProgram"], $_GET["fMode"]);
    else
        printf("<select style='width:200px' id='key' size='%s' onchange=\"get_values(1,'%s',this.value,'%s')\" class='Width'>\n",
               $_GET["fSelectSize"], $_GET["fProgram"], $_GET["fMode"]);

    if (!empty($_GET["fKey"]) && strcmp("all", $_GET["fKey"])==0)
        printf("<option value='all' selected> --- all keys --- </option>\n");
    else
        printf("<option value='all'> --- all keys --- </option>\n");
    while ($row0 = mysql_fetch_row($result0))
        if (!empty($_GET["fKey"]) && strcmp($row0[0], $_GET["fKey"])==0)
            printf("<option value='%s' selected>%s </option>\n", $row0[0], $row0[0]);
        else
            printf("<option value='%s'>%s </option>\n", $row0[0], $row0[0]);
    printf("</select>\n");
    if (strcmp($_GET["fMode"], "edit")==0)
        printf("<br>\n<button onClick='addRow(2,\"%s\",\"\",\"\",\"\",\"\",\"\",\"\");' id='addrowkey' style='display:inline'>Add Key</button>\n", $_GET["fProgram"]);
    mysql_free_result($result0);

    mysql_close($db_id);

    ini_set("display_errors", "Off");
    ini_set("mysql.trace_mode", "Off");
}
?>