<?
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 = "";
/*************************************************
= INSERTUPDATEDELETE
**************************************************/
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;
}
?>
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 = "";
/*************************************************
= INSERTUPDATEDELETE
**************************************************/
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;
}
?>
回复Comments
作者:
{commentrecontent}