fupaylist.php

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

<?php
//echo getfupaylist('aa',"01") ;
//echo getfupayname("02") ;

function getfupaylist($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 fupay ";
	$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[FUP01]==$sel){ $tempstr .= "<option value='$row[FUP01]' selected='selected' > $row[FUP02] </option>";} 
			else{$tempstr .= "<option value='$row[FUP01]' > $row[FUP02] </option>";};
	};

$tempstr .= "</select>";

return  $tempstr;
}

function getfupayname($uid)  {
 
	$conn = phpmkr_db_connect(HOST, USER, PASS, DB, PORT);
    $sSql ="select * from fupay where FUP01= '$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[FUP02];

return  $tempstr;
}

?>