class sqldb {
var $username;
var $dbname;
var $Password;
var $socket;
var $result;
var $host;
var $connected;
var $curr_result;
// SETTARE QUI I PARAMETRI DI CONNESSIONE
Function sqldb() {
$this->connected = 0;
$this->curr_result = 0;
//$this->SetParameters("localhost","orsadata","orsa_dbpw33","orsadata_it_-_1");
$this->SetParameters("localhost","socialso_usr1","DudedAlertFinnerTaunt86","socialso_db1");
}
Function Connect()
{
if (!$this->socket = mysql_connect($this->host,$this->username,$this->Password))
return (FALSE);
if (! mysql_select_db($this->dbname))
return (FALSE);
$this->connected = 1;
return(TRUE);
}
Function SetParameters($hst,$user,$pwd,$db) {
$this->host = $hst;
$this->dbname=$db;
$this->Password=$pwd;
$this->username=$user;
}
// usare per le query di tipo select
Function Exec($query)
{
if (!$this->connected)
die ("Not Connected");
$this->result[$this->curr_result]=mysql_query($query,$this->socket);
return (mysql_num_rows($this->result[$this->curr_result]));
}
// usare per le query di tipo update o delete
Function Command($query)
{
if (!$this->connected)
die ("Not Connected");
mysql_query($query,$this->socket);
}
// usare per le query di tipo insert
Function Command_insert($query)
{
if (!$this->connected)
die ("Not Connected");
$result = mysql_db_query ($this->dbname,$query,$this->socket);
}
// restituisce la riga $num del risultato con campoi $campo (campo intero o
// stringa
Function Result ($num,$campo)
{
if (!$this->connected)
die ("Not Connected");
$res=mysql_result($this->result[$this->curr_result],$num,$campo);
return($res);
}
Function Num()
{
if (!$this->connected)
die ("Not Connected");
$num=mysql_num_rows($this->result[$this->curr_result]);
return($num);
}
Function FetchRow()
{
if (!$this->connected)
die ("Not Connected");
$riga = mysql_fetch_row($this->result[$this->curr_result]);
return($riga);
}
Function FetchArray() // restituisce un array anche associativo
{
if (!$this->connected)
die ("Not Connected");
$riga = mysql_fetch_array($this->result[$this->curr_result]);
return($riga);
}
Function NumFields() {
if (!$this->connected)
die ("Not Connected");
return mysql_num_fields($this->result[$this->curr_result]);
}
Function FieldName($num){
if (!$this->connected)
die ("Not Connected");
return mysql_field_name($this->result[$this->curr_result], $num);
}
Function Seek ($i) {
if (!$this->connected)
die ("Not Connected");
return mysql_data_seek($this->result[$this->curr_result],$i);
}
Function Disconnect()
{ mysql_close($this->socket);
}
Function NewResult() {
$this->curr_result++;
}
Function BackResult() {
$this->curr_result--;
}
Function SetResult($i) {
if ($i>count($result))
return(FALSE);
else {
$this->curr_result=$i;
RETURN(TRUE);
}
}
}
?>