casebanklist.php

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

<?php
//echo getuserlist('aa',"hong") ;
function getcasebanklist($fname,$sel)  {
 
 //include ("../inc/db.php");
 //include ("../inc/phpmkrfn.php");

$tempstr="<select name='$fname'>";

	$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
    $sSql ="select * from casebank ";
	$rs  = phpmkr_query($sSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);

	while ($row = mysql_fetch_array($rs, MYSQL_ASSOC)) {
		if ($row[UID]==$sel){ $tempstr .= "<option value='$row[CAB01]' selected='selected' > $row[CAB02] </option>";} 
			else{$tempstr .= "<option value='$row[CAB01]' > $row[CAB02] </option>";};
	};

$tempstr .= "</select>";

return  $tempstr;
}

function getcasebankname($uid)  {
 
	$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
    $sSql ="select * from casebank where CAB01= '$uid' ";
	$rs  = phpmkr_query($sSql,$conn) or die("Failed to execute query: " . phpmkr_error() . '<br>SQL: ' . $sSql);

	$row = mysql_fetch_array($rs, MYSQL_ASSOC);
		$tempstr =$row[CAB02];

return  $tempstr;
}

?>