Link_ID ) {
$this->Link_ID=mysql_connect($this->Host, $this->User, $this->Password);
if (!$this->Link_ID) {
$this->halt("Link-ID == false, connect failed");
}
if (!mysql_query(sprintf("use %s",$this->Database),$this->Link_ID)) {
$this->halt("cannot use database ".$this->Database);
}
}
}
function query($Query_String) {
$this->connect();
$this->Query_ID = mysql_query($Query_String,$this->Link_ID);
$this->Row = 0;
# $this->Errno = mysql_errno();
$this->Error = $this->Database;
#mysql_error();
if (!$this->Query_ID) {
$this->halt("Invalid SQL: ".$Query_String);
}
return $this->Query_ID;
}
function next_record() {
$this->Record = mysql_fetch_array($this->Query_ID);
$this->Row += 1;
# $this->Errno = mysql_errno();
# $this->Error = mysql_error();
$stat = is_array($this->Record);
if (!$stat && $this->Auto_free) {
mysql_free_result($this->Query_ID);
$this->Query_ID = 0;
}
return $stat;
}
function seek($pos) {
$status = mysql_data_seek($this->Query_ID, $pos);
if ($status)
$this->Row = $pos;
return;
}
function metadata($table) {
$count = 0;
$id = 0;
$res = array();
$this->connect();
$id = @mysql_list_fields($this->Database, $table);
if ($id < 0) {
# $this->Errno = mysql_errno();
# $this->Error = mysql_error();
$this->halt("Metadata query failed.");
}
$count = mysql_num_fields($id);
for ($i=0; $i<$count; $i++) {
$res[$i]["table"] = mysql_field_table ($id, $i);
$res[$i]["name"] = mysql_field_name ($id, $i);
$res[$i]["type"] = mysql_field_type ($id, $i);
$res[$i]["len"] = mysql_field_len ($id, $i);
$res[$i]["flags"] = mysql_field_flags ($id, $i);
$res["meta"][$res[$i]["name"]] = $i;
$res["num_fields"]= $count;
}
mysql_free_result($id);
return $res;
}
function affected_rows() {
return mysql_affected_rows($this->Link_ID);
}
function num_rows() {
return mysql_num_rows($this->Query_ID);
}
function num_fields() {
return mysql_num_fields($this->Query_ID);
}
function nf() {
return $this->num_rows();
}
function np() {
print $this->num_rows();
}
function f($Name) {
return $this->Record[$Name];
}
function p($Name) {
print $this->Record[$Name];
}
function pos(){
return $this->Row;
}
function instid() {
return mysql_insert_id($this->Link_ID);
}
# function errorno() {
# return mysql_errno($this->Link_ID);
# }
function halt($msg) {
printf("資料庫暫時連接故障，請再試一次: %s
\n", $msg);
printf("資料庫暫時連接故障，請再試一次:: %s (%s)
\n",
$this->Errno,
$this->Error);
die("Session halted.");
}
}
class SHARP_SQL extends DBbase_Sql {
var $Host = "localhost";
var $Database = "auto";
var $User = "auto_f";
var $Password = "a5r6a7w3";
function free_result() {
return @mysql_free_result($this->Query_ID);
}
function rollback() {
return 1;
}
function commit() {
return 1;
}
function autocommit($onezero) {
return 1;
}
function insert_id($col="",$tbl="",$qual="") {
return mysql_insert_id($this->Query_ID);
}
function discount($listprice,$discount){
$actprice=ture;
if($discount=="0"){
$actprice=$listprice;
}else{
$discount=$discount/100;
$actprice=$listprice-($listprice*$discount);
}
return $actprice;
}
function tax($actprice,$taxrate){
$taxadded=ture;
if($taxrate=="0"){
$taxadded=$actprice;
}else{
$taxrate=$taxrate/100;
$taxadded=$actprice+($actprice*$taxrate);
}
return $taxadded;
}
}
function prevlink($linkpage,$prevobj,$lcolor,$currentpage,$totalnum,$pagenum){
$plink="";
if($currentpage>1){
$ppage=$currentpage-1;
if($lcolor==""){
$plink="$prevobj";
}
else{
$plink="$prevobj";
}
}
return $plink;
}
function nextlink($linkpage,$nextobj,$lcolor,$currentpage,$totalnum,$pagenum){
$nlink="";
$npage=$currentpage+1;
if($totalnum>$currentpage*$pagenum){
if($lcolor==""){
$nlink="$nextobj";
}
else{
$nlink="$nextobj";
}
}
return $nlink;
}
function sendback($reson){
echo "";
exit;
}
?>