buy.php

这个版本只是修正了一些BUG

<?php
/**********************************************
	buy.php

	Version  : 1.0.0
	Author   : Tracemouse ([e-mail])
	Copyright:
	Writed   : 2003/08/07
	Modified : 2003/03/18
***********************************************/

function buy($productid,$username)
{
	global $db,$table_basket,$table_products;
  	$sqlstr="select count(*) from $table_basket where username = '$username' and productid = $productid and oid='picking'";
  	$query=$db->query($sqlstr);
  	$recnum=$db->result($query,0);
  	if($recnum > 0) return 1;
  	$query=$db->query("select * from $table_products where productid=$productid");
  	if($dbq_rec = $db->fetch_array($query))
  	{
   		$price=$dbq_rec['ourprice'];
   	}
  	else
  	{
  	 	return 2;
  	}
  	$sqlstr="INSERT INTO $table_basket(username,productid,amount,price,oid) VALUES('$username',$productid,1,$price,'picking')";
  	echo $sqlstr;
  	if($query=$db->query($sqlstr)) return 0;
  	else return 3;
}


?>