<?php



    $db_connection=null;

    //PREDEFINED QUERIES

    $ADD_NEW_FILE_QUERY="INSERT INTO orario (post_date,data,author,digest) VALUES (:date,':data',':author',':digest')";

    $UPDATE_FILE_BY_ID_QUERY="UPDATE orario SET post_date=:date, data=':data', author=':author', digest=':digest' WHERE id = :id";

    $GET_LAST_FILE_ID_QUERY="SELECT id FROM orario WHERE post_date = (SELECT MAX(post_date) FROM orario)";

    $GET_FILE_CONTENT_BY_ID_QUERY="SELECT data FROM orario WHERE id = :id";

    $GET_FILE_DIGEST_BY_ID_QUERY="SELECT digest FROM orario WHERE id = :id";

    $GET_FILES_ID_QUERY="SELECT id FROM orario";

    $COUNT_FILES_QUERY="SELECT COUNT(*) FROM orario";

    //PREDEFINED QUERIES



    function db_connect(){

        $host="localhost";

        $db_name="my_orarioospedale";

        $username="orarioospedale";

        $password="sektenufku31";



        global $db_connection;

        $db_connection=mysql_connect($host,$username,$password,$db_name);



        if(!$db_connection){

            return false;

        }

        mysql_select_db($db_name);

        return true;

    }



    function db_disconnect(){

        global $db_connection;

        mysql_close($db_connection);

    }



    function db_add_new_file($filename,$author="Anonimo"){

        global $ADD_NEW_FILE_QUERY;



        $fileHandle = fopen($filename, "r");



        $fileContent = fread($fileHandle,filesize($filename));

        $md5=md5($fileContent);

        $fileContent = addslashes($fileContent);

        $query_str=str_replace(array(":date",":author",":data",":digest"),array("NOW()",$author,$fileContent,$md5),$ADD_NEW_FILE_QUERY);



        mysql_query($query_str);



        return true;

    }



    function db_update_current_file($filename,$author="Anonimo"){

        global $UPDATE_FILE_BY_ID_QUERY,$GET_LAST_FILE_ID_QUERY;

        $fileHandle = fopen($filename, "r");



        $fileContent = fread($fileHandle,filesize($filename));

        $md5=md5($fileContent);

        $fileContent = addslashes($fileContent);



        $result=mysql_query($GET_LAST_FILE_ID_QUERY);



        if(!$result){

            return false;

        }



        $row=mysql_fetch_row($result);



        $last_id=$row[0];



        $query_str=str_replace(array(":date",":author",":data",":id",":digest"),array("NOW()",$author,$fileContent,$last_id,$md5),$UPDATE_FILE_BY_ID_QUERY);

        $result=mysql_query($query_str);

        if(!$result){

            return false;

        }



        return true;

    }



    function db_get_number_of_files(){

        global $COUNT_FILES_QUERY;

        $result = mysql_query($COUNT_FILES_QUERY);

        if(!$result)

            return false;



        $row = mysql_fetch_row($result);

        return $row[0];

    }



    function db_get_last_file_content(){

        global $GET_LAST_FILE_ID_QUERY;



        $result = mysql_query($GET_LAST_FILE_ID_QUERY);

        if(!$result)

            return false;



        $row = mysql_fetch_row($result);

        return db_get_file_content_by_id($row[0]);

    }



    function db_get_file_digest_by_id($id){

        global $GET_FILE_DIGEST_BY_ID_QUERY;



        $query_str=str_replace(array(":id"),array($id),$GET_FILE_DIGEST_BY_ID_QUERY);



        $result = mysql_query($query_str);

        if(!$result)

            return false;



        $row=mysql_fetch_row($result);

        return $row[0];

    }



    function db_get_last_file_digest(){

        global $GET_LAST_FILE_ID_QUERY;



        $result = mysql_query($GET_LAST_FILE_ID_QUERY);

        if(!$result)

            return false;



        $row = mysql_fetch_row($result);

        return db_get_file_digest_by_id($row[0]);

    }



    function db_get_files_id(){

        global $GET_FILES_ID_QUERY;



        $result = mysql_query($GET_FILES_ID_QUERY);

        if(!$result)

            return false;

        $ids=array();



        while($row=mysql_fetch_row($result)){

            $ids[]=$row[0];

        }

        return $ids;

    }



    function db_get_file_content_by_id($id){

        global $GET_FILE_CONTENT_BY_ID_QUERY;



        $query_str=str_replace(array(":id"),array($id),$GET_FILE_CONTENT_BY_ID_QUERY);



        $result = mysql_query($query_str);

        if(!$result)

            return false;



        $row=mysql_fetch_row($result);

        return $row[0];

    }

?>