[PHP] Undefined index ???

[Traxsung]

Cosa significa questo messaggio di errore datomi dal Browser provando uno script php in localo con Easyphp ??

Se può essere utile riporto il listato:

Codice PHP:

if ($_GET["day"]!="" || $_GET["month"]!="" || $_GET["year"]!=""){

            if ($_GET["day"]!=""){
                $day = $_GET["day"];
            } else {
                $day = "";
            }

            if ($_GET["month"]!=""){
                $month = $_GET["month"];
            } else {
                $month = $date_today["mon"];
            }

            if ($_GET["year"]!=""){
                $year = $_GET["year"];
            } else {
                $year = $date_today["year"];
            } 


L'errore me lo da per day, month e year

[Traxsung]

mmm.... hai ragione, così non si capisce un granchè.
Ecco l'intero codice:

Codice PHP:

*/

// database functions


function show_error()
{
    die("Error " . mysql_errno() . " : " . mysql_error());
}



function sql_quote($input)
{
    return "'".$input."'";
}



function db_connect()
{

    global $db_server;
    global $db_username;
    global $db_password;
    global $db_name;

    $con = mysql_connect($db_server,$db_username,$db_password);
    if (!(mysql_select_db($db_name,$con)))
    {
        show_error();
    }

    return $con;
}



function db_disconnect($con)
{
    close($con);
}


function db_prepare(){

    global $viewmode;
    
    global $day;
    global $month;
    global $year;
    
    global $list_rows;
    global $view_rows;
    global $view_comment_rows;

    global $viewcomments;

    // connect to the database
    $con = db_connect();
    $blogid="";
    $date_today = getdate();

    // work out what to show based on URL parameters
    ;
    if ($_POST["blogid"]!="") {

        $blogid = $_GET["blogid"];

        // get the blog entry from the database to find out what month it was (for the list and view sql)
        $sql_findmonth = "SELECT *,MONTH(dEntryDate) AS month,YEAR(dEntryDate) AS year FROM blog WHERE nIdCode=".$blogid;
        $result = mysql_query($sql_findmonth,$con);
        if ($result!=false) {
            $row = mysql_fetch_array($result);
            $month = $row["month"];
            $year = $row["year"];
        } else {
            // revert to nothing sent
            $blogid="";
        }

        $sql_list = "SELECT * FROM blog WHERE MONTH(dEntryDate)=".$month." ORDER BY dEntryDate DESC;";
        if ($viewmode=="single"){
            $sql_view = "SELECT * FROM blog WHERE nIdCode=".$_GET["blogid"].";";
        } else {
            $sql_view = "SELECT * FROM blog WHERE MONTH(dEntryDate)=".$month." ORDER BY dEntryDate DESC;";
        }

    }

    if ($blogid=="") {

        // Figure out what parts of the date we have got

        if ($_GET['day']!="" || $_GET['month']!="" || $_GET['year']!=""){

            if ($_GET['day']!=""){
                $day = $_GET['day'];
            } else {
                $day = "";
            }

            if ($_GET["month"]!=""){
                $month = $_GET["month"];
            } else {
                $month = $date_today["mon"];
            }

            if ($_GET["year"]!=""){
                $year = $_GET["year"];
            } else {
                $year = $date_today["year"];
            }

        } else {

            $day = "";
            $month = $date_today["mon"];
            $year = $date_today["year"];

        }

        // Build the SQL statements

        if ($day!=""){

            $sql_list = "SELECT * FROM blog WHERE MONTH(dEntryDate)=".$month." AND YEAR(dEntryDate)=".$year." AND DAYOFMONTH(dEntryDate)=".$day." ORDER BY nIdCode DESC;";
            if ($viewmode == "single"){
                $sql_view = "SELECT * FROM blog WHERE MONTH(dEntryDate)=".$month." AND YEAR(dEntryDate)=".$year." AND DAYOFMONTH(dEntryDate)=".$day." ORDER BY nIdCode DESC;";
            } else {
                $sql_view = "SELECT * FROM blog WHERE MONTH(dEntryDate)=".$month." AND YEAR(dEntryDate)=".$year." ORDER BY nIdCode DESC;";
            }

        } else {

            $sql_list = "SELECT * FROM blog WHERE MONTH(dEntryDate)=".$month." AND YEAR(dEntryDate)=".$year." ORDER BY nIdCode DESC;";
            if ($viewmode == "single"){
                $sql_view = "SELECT * FROM blog WHERE MONTH(dEntryDate)=".$month." AND YEAR(dEntryDate)=".$year." ORDER BY nIdCode DESC LIMIT 1;";
            } else {
                $sql_view = "SELECT * FROM blog WHERE MONTH(dEntryDate)=".$month." AND YEAR(dEntryDate)=".$year." ORDER BY nIdCode DESC;";
            }
        }
    }


    // Get data from the database (store in arrays)

    $list_result = mysql_query($sql_list,$con);
    $view_result = mysql_query($sql_view,$con);

    // Build List Array
    if ($list_result!=false) {
        $i=0;
        while ($list_row =@ mysql_fetch_array($list_result)){
            $i++;
            $list_rows[$i] = $list_row;
        }
    } else {
        $problem = "1";
    }

    // Build View Array
    if ($view_result!=false) {
        $i=0;
        while ($view_row =@ mysql_fetch_array($view_result)){
            $i++;
            $view_rows[$i] = $view_row;

            // build view_comments array
            if ($viewcomments=="yes") {
                $sql = "SELECT * FROM blog_comments WHERE nBlogId=".$view_row["nIdCode"]." ORDER BY nIdCode DESC";
                $result = mysql_query($sql,$con);
                if ($result!=false){
                    $j=0;
                    while ($comment_row =@ mysql_fetch_array($result)){
                        $j++;
                        $view_comment_rows[$i][$j] = $comment_row;
                    }
                }
            }
        }
    } else {
        $problem = "2";
    }

    // increment view counter for either the single blog being shown
    // or ALL blogs being shown
    if ($view_rows[1]["nIdCode"]!=""){
        if ($viewmode=="single"){
            $blogid = $view_rows[1]["nIdCode"];
            $sql = "UPDATE blog SET nViews=nViews+1 WHERE nIdCode=".$blogid;
        } else {
            for ($i=1;$i<=count($view_rows);$i++){
                $blog_array[$i] = $view_rows[$i]["nIdCode"];
            }
            $blogids = implode(",",$blog_array);
            $sql = "UPDATE blog SET nViews=nViews+1 WHERE nIdCode IN (".$blogids.")";
        }
        $result = mysql_query($sql,$con);
        if ($result==false){
            print "<li>Problem with SQL<br>[".$sql."]</li>\n";
        }
    }
}

function db_hitcount(){
    $con = db_connect();
    $sql = "SELECT SUM(nViews) AS nTotal FROM blog";
    $result = mysql_query($sql,$con);
    if ($result!=false){
        $row = mysql_fetch_array($result);
        $total = $row["nTotal"];
    } else {
        $total = 0;
    }
    return $total;
}

?> 


Ah... ti ricordo che lo sto testando in locale

[Traxsung]

dai ragazzi.... ho bisogno urgentemente di un'aiuto