1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85
|
include_once('sgbd.class.php5');
include_once('error.class.php5');
class MySQL extends SGBD
{
function __construct($Host = 'localhost', $Login = 'root', $Password = '', $Base = '')
{
parent::__construct($Host, $Login, $Password, $Base);
}
public function Connect()
{
if( $this->m_rConnectionId = @mysql_connect($this->m_sHost, $this->m_sLogin, $this->m_sPassword) )
{
if( @mysql_select_db($this->m_sBase, $this->m_rConnectionId) )
return $this->m_rConnectionId;
}
return false;
}
public function SendQuery($Query)
{
if( $this->m_rResultId = @mysql_query($Query, $this->m_rConnectionId) )
{
$this->m_sQuery = trim($Query);
return $this->m_rResultId;
}
return false;
}
public function GetNumRows()
{
if( isset($this->m_ResultId) )
{
if( preg_match('`^select`i', $this->m_sQuery) )
return @mysql_num_rows($this->m_rResultId);
if( preg_match('`^(insert|update|delete)`i', $this->m_sQuery) )
return @mysql_affected_rows($this->m_rResultId);
}
return -1;
}
public function FreeResult($ConnectionId)
{
return @mysql_free_result($this->m_rConnectionId);
}
public function Error()
{
return new Error(@mysql_error($this->m_rConnectionId), @mysql_errno($this->m_rConnectionId));
}
function LastInsertId()
{
return @mysql_insert_id($this->m_rConnectionId);
}
function FetchObject($Query)
{
return @mysql_fetch_object($Query);
}
function FetchArray($Query, $Mode = 'ASSOC')
{
if( $Mode == 'NUMERIC' )
return @mysql_fetch_array($query, MYSQL_NUM);
if( $Mode == 'BOTH' )
return @mysql_fetch_array($query, MYSQL_BOTH);
return @mysql_fetch_assoc($query);
}
public function Deconnect()
{
@mysql_close($this->m_rConnectionId);
}
} |
Partager