//——DBFunction———————-
function connectdb()
{
global $db_p;
//die(“connect db”);
//$host=’localhost’;
$host=’127.0.0.1′;
$user=’root’;
$pass=”;
@$db_p=mysql_pconnect($host,$user,$pass) or
die(“could not connect to server”);
mysql_select_db(‘baseball’, $db_p)
or die(“Could not select database”);
}
function insert($tableName,$valueArray)
{
//die(‘-‘.$tableName);
//die(print_r($valueArray));
global $db_p;
list($key,$val) = each($valueArray);
$fields=$key;
$values=”‘”.mysql_real_escape_string($val).”‘”;
while(list($key,$val)=each($valueArray))
{
$values .= “,'”.mysql_real_escape_string($val).”‘”;
$fields .= “,”.$key;
}
$sql=”insert into “.$tableName.” (“.$fields.”) “.”values(“.$values.”)”;
//die($sql);
mysql_query($sql);
//die(mysql_errno($db_p) . “: ” . mysql_error($db_p) . “\n”);
$numAffectedRows=mysql_affected_rows();
return $numAffectedRows;
}
function search($tableName,$fields,$condition)
{
//die(‘inside dbfunc’);
$sql=”select “.$fields.” from “.$tableName.” “.$condition;
$rs=mysql_query($sql);
$nrows=mysql_num_rows($rs);
for($i=0;$i<$nrows;$i++)
{
$row=mysql_fetch_array($rs);
while(list($key,$value)=each($row))
{
$searchArray[$i][$key]=$value;
}
}
return $searchArray;
}
function searchBySQL($sql)
{
//$sql="select ".$fields." from ".$tableName." ".$condition;
$rs=mysql_query($sql);
$nrows=mysql_num_rows($rs);
for($i=0;$i<$nrows;$i++)
{
$row=mysql_fetch_array($rs);
while(list($key,$value)=each($row))
{
$searchArray[$i][$key]=$value;
}
}
return $searchArray;
}
function update($tableName,$updateFields,$condition)
{
$sql="update ".$tableName." set ".$updateFields." ".$condition;
mysql_query($sql);
$numAffectedRows=mysql_affected_rows();
return $numAffectedRows;
}
function deletion($tableName,$condition)
{
$sql="delete from ".$tableName." ".$condition;
mysql_query($sql);
$numAffectedRows=mysql_affected_rows();
return $numAffectedRows;
}
function isExist($tableName,$fields,$condition)
{
$sql="select ".$fields." from ".$tableName." ".$condition;
//die($sql);
$rs=mysql_query($sql);
$nrows=mysql_num_rows($rs);
//die('nrow='.$nrows);
$exist = "";
if($nrows>0){
//echo ‘if’;
$exist=true;
}
elseif($nrows==0){
//echo ‘else’;
$exist=false;
}
//echo ‘?=’.$exist;
return $exist;
}
function getNumOfRows($tableName,$fields,$condition)
{
$sql=”select “.$fields.” from “.$tableName.” “.$condition;
$rs=mysql_query($sql);
$nrows=mysql_num_rows($rs);
return $nrows;
}
function getLastInsertID()
{
$lastID=mysql_insert_id();
return $lastID;
}
/*function getFieldOfLastRow($tableName,$field)
{
$sql=”select “.$field.” from “.$tableName;
$rs=mysql_query($sql);
$nrows=mysql_num_rows($rs);
if($nrows>0){
mysql_data_seek($rs,$nrows-1);
$row=mysql_fetch_array($rs);
}
return $row[$field];
}*/
function updateByArray($tableName,$updateArray,$condition)
{
list($key,$val)=each($updateArray);
$updateStr=$key.”='”.mysql_real_escape_string($val).”‘”;
while(list($key,$val)=each($updateArray))
{
$updateStr .= “,”.$key.”='”.mysql_real_escape_string($val).”‘”;
}
$sql=”update “.$tableName.” set “.$updateStr.” “.$condition;
mysql_query($sql);
$numAffectedRows=mysql_affected_rows();
return $numAffectedRows;
}
function getLastAutoNumber($tableName,$field)
{
$sql=”select “.$field.” from “.$tableName.” order by “.$field;
$rs=mysql_query($sql);
$nrows=mysql_num_rows($rs);
if($nrows>0){
mysql_data_seek($rs,$nrows-1);
$row=mysql_fetch_array($rs);
}
return $row[$field];
}
//—————————————-end dbfunction———————-