editoper.php

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

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

 $t_AUTOID=$_GET['AUTOID'];
 if (empty($t_AUTOID)){$t_AUTOID=-1;};
 $t_KUCID=$_GET['KUCID'];

 $xtpl=new XTemplate ("editoper.html");

	$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);

    $sSql ="select kuchen.*,ID,PROD01,PROD04,PROD05 from kuchen LEFT JOIN products ON kuchen.KUC01 = products.ID  where kuchen.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);
	   $o_Num=$row[KUC02];

$xtpl->assign("AUTOID",$t_AUTOID);

for ($i =1;$i<=$o_Num;++$i ){
	$xtpl->assign("ROWID",$i);			/* assign array data */
    $xtpl->assign("mDATA",$row);		/* assign array data */
	$xtpl->parse("main.row");

  }
	$xtpl->parse("main");
	$xtpl->out("main");
?>