listtop.php

开源的 库存管理系统 www.minierp.cn php+ mysql

<?php
	$xtpl=new XTemplate ("../accounts/listtop.html");

	$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
    $sSql ="SELECT * FROM `accounts` order by AUTOID DESC  LIMIT 0 , 5";

	$rs  = phpmkr_query($sSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);


    while ($row = mysql_fetch_array($rs, MYSQL_ASSOC)) {
		$xtpl->assign("DATA",$row);		/* assign array data */
		$xtpl->parse("toptable.table.row");			/* parse a row */
	}
	
	$xtpl->parse("toptable.table");					/* parse the table */
	
	$xtpl->parse("toptable");
	$xtpl->out("toptable");

?>