editview.php

来自「开源的 库存管理系统 www.minierp.cn php+ mysql」· PHP 代码 · 共 21 行

<?php
 include ("../inc/db.php");
 include ("../inc/phpmkrfn.php");
 include ('../inc/xtpl.php');

 $t_AUTOID=$_GET['AUTOID'];
 if (empty($t_AUTOID)){$t_AUTOID=0;};
 $xtpl=new XTemplate ("editview.html");

	$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
    $sSql ="select accdelt.*,accounts.ACC01 from accdelt LEFT JOIN accounts ON accdelt.accid = accounts.id  where accdelt.AUTOID='$t_AUTOID'";
	$rs  = phpmkr_query($sSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);

    $row = mysql_fetch_array($rs, MYSQL_ASSOC);
		$deltid=$row[SHMID];   //閫佽揣鏄庣粏缂栧彿
		$xtpl->assign("DATA",$row);		/* assign array data */
	
	$xtpl->parse("main");
	$xtpl->out("main");

?>