note 101119 deleted from function.mysql-query by danbrown
| From: | danbrown@php.net | Date: | Sat, 27 Nov 2010 16:28:17 +0000 |
| Subject: | note 101119 deleted from function.mysql-query by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-174396@lists.php.net to get a copy of this message | ||
Note Submitter: salvatorepragliola at hotmail dot it
----
<?
class db{
var $dbhost = 'localhost';
var $dbname = 'my_db';
var $dbuser = 'db';
var $dbpassword = 'password';
var $die_error = true;
public function speed_sendRequest($request){
$this->speed_cnt = mysql_connect($this->dbhost,$this->dbuser,$this->dbpassword); //
Gestisco la prima connessione al database mysql
if(!$this->speed_cnt) {
if($this->die_error){
die("Connection problems, try again! | Problemi di connessione, riprova!".mysql_error());
}
return false;
}
$this->speed_dbselect = mysql_select_db($this->dbname, $this->speed_cnt); // Seleziono il
database
if(!$this->speed_dbselect) {
if($this->die_error){
die("Problems during database selection! | Problemi durante la selezione del
database!".mysql_error());
}
return false;
}
$this->speed_result = mysql_query($request, $this->speed_cnt);
if(!$this->speed_result) {
if($this->die_error){
die("Problems during query execution! | Problemi durante l'esecuzione della
richiesta!".mysql_error());
}
return false;
}
else {
return $this->speed_result;
}
}
}
$database = new db();
$x = $database->speed_sendRequest("Select * from reg_users");
while ($row = mysql_fetch_array($x)) {
echo $row['UserName'];
}
?>