PHP学习13：Smarty入门的简单范例 - 达人(gmail)

2007/12/11 | PHP学习13：Smarty入门的简单范例
类别(网络工程师) | 评论(0) | 阅读(57) | 发表于 21:24: <?

include("sql.php");

include("parser.php");

$ sql="SELECT * FROM `record` ";

$ data=sql_b($ sql);

$ array['{user_name}'] =$ data[0][0];

$ array['{user_age}'] =$ data[0][1];

$ array['{user_int}'] =$ data[0][2];

$ array['{user_drm}'] =$ data[0][3];

$ output=read_and_parser("page.html",$ array);

echo $ output;

?>

其中("parser.php");：
<?

function read_and_parser($ filename,$ parser_array)
{
    $ handle = fopen ($ filename, "r");
    $ buffer = fread ($ handle, filesize ($ filename));
    fclose ($ handle);

    while(list($ key,$ value)=each($ parser_array))
    {
        $ buffer = str_replace($ key,$ value,$ buffer);
    }

    return $ buffer;
}
?>

另外 sql.php：
<?


    $ host = "localhost";
       $ user = "root";
       $ pass = "";
       $ database = "";

/*************************************************
= INSERTUPDATEDELETE

**************************************************/
function sql_a($ query)
{
    global $ host,$ user,$ pass,$ database;

       $ conn=@mysql_connect( $ host, $ user, $ pass);
    @mysql_select_db($ database,$ conn);
    $ result = @mysql_query($ query);
    @mysql_close($ conn);

    return $ result;
}

/*************************************************

**************************************************/
function sql_b($ query)
{
    global $ host,$ user,$ pass,$ database;

    $ conn=@mysql_connect( $ host, $ user, $ pass );
    $ result=@mysql_db_query( $ database, $ query, $ conn);
    @mysql_data_seek($ result,0);
    while($ row=@mysql_fetch_row($ result))
    {
            $ output[] = $ row;
    }
    @mysql_free_result($ result);
    @mysql_close($ conn);

    return $ output;
}

/*************************************************

**************************************************/
function sql_i($ query)
{
    global $ host,$ user,$ pass,$ database;

       $ conn=@mysql_connect( $ host, $ user, $ pass);
    @mysql_select_db($ database,$ conn);
    $ result = @mysql_query($ query);
    $ result = @mysql_insert_id();
    @mysql_close($ conn);

    return $ result;
}

?>; 0

http://gmail.5d.cn/

评论Comments