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); } } } ?>