note 74437 added to ref.mysql
| From: | admin at mihalism dot com | Date: | Wed, 11 Apr 2007 14:48:06 +0000 |
| Subject: | note 74437 added to ref.mysql | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-125296@lists.php.net to get a copy of this message | ||
Heres a easy to use MySQL class for any website
<?php
class mysql_db{
//+======================================================+
function sql_connect($sqlserver, $sqluser, $sqlpassword, $database){
$this->connect_id = mysql_connect($sqlserver, $sqluser, $sqlpassword);
if($this->connect_id){
if (mysql_select_db($database)){
return $this->connect_id;
}else{
return $this->error();
}
}else{
return $this->error();
}
}
//+======================================================+
function error(){
if(mysql_error() != ''){
echo '<b>MySQL Error</b>: '.mysql_error().'<br/>';
}
}
//+======================================================+
function query($query){
if ($query != NULL){
$this->query_result = mysql_query($query, $this->connect_id);
if(!$this->query_result){
return $this->error();
}else{
return $this->query_result;
}
}else{
return '<b>MySQL Error</b>: Empty Query!';
}
}
//+======================================================+
function get_num_rows($query_id = ""){
if($query_id == NULL){
$return = mysql_num_rows($this->query_result);
}else{
$return = mysql_num_rows($query_id);
}
if(!$return){
$this->error();
}else{
return $return;
}
}
//+======================================================+
function fetch_row($query_id = ""){
if($query_id == NULL){
$return = mysql_fetch_array($this->query_result);
}else{
$return = mysql_fetch_array($query_id);
}
if(!$return){
$this->error();
}else{
return $return;
}
}
//+======================================================+
function get_affected_rows($query_id = ""){
if($query_id == NULL){
$return = mysql_affected_rows($this->query_result);
}else{
$return = mysql_affected_rows($query_id);
}
if(!$return){
$this->error();
}else{
return $return;
}
}
//+======================================================+
function sql_close(){
if($this->connect_id){
return mysql_close($this->connect_id);
}
}
//+======================================================+
}
/* Example */
$DB = new mysql_db();
$DB->sql_connect('sql_host', 'sql_user', 'sql_password',
'sql_database_name');
$DB->query("SELECT * FROM
members");
$DB->sql_close();
?>
----
Server IP: 64.71.164.2
Probable Submitter: 68.230.192.26
----
Manual Page -- http://www.php.net/manual/en/ref.mysql.php
Edit -- https://master.php.net/note/edit/74437
Del: integrated -- https://master.php.net/note/delete/74437/integrated
Del: useless -- https://master.php.net/note/delete/74437/useless
Del: bad code -- https://master.php.net/note/delete/74437/bad+code
Del: spam -- https://master.php.net/note/delete/74437/spam
Del: non-english -- https://master.php.net/note/delete/74437/non-english
Del: in docs -- https://master.php.net/note/delete/74437/in+docs
Del: other reasons-- https://master.php.net/note/delete/74437
Reject -- https://master.php.net/note/reject/74437
Search -- https://master.php.net/manage/user-notes.php