mysql - Autoreconnect class for database in php -

-

i developing class database access , query. if database accessible working correctly, problem comes when somehow database restarted.

below code library , users code. able reconnect database, unable select database. have tried 2,5 retry attempts select_from_db function. throwing error unable select database test mysql server has gone away. using windows machine , in sleep time executing below command restarting mysql.

net stop wampmysqld net start wampmysqld

please let me know suggestion , answers, can improve on it.

<?php      class database {         private $host;         private $user;         private $pswd;         private $name;         private $db_handle;         private $error_msg;          function __construct($db_host, $db_user, $db_pswd, $db_name=null){             $this->host = $db_host;             $this->user = $db_user;             $this->pswd = $db_pswd;             $this->name = $db_name;             $this->db_handle = null;             $this->error_msg = null;         }          function connect(){             if(!is_null($this->db_handle)){                 return true;             }             echo "trying connection..\n";             $this->db_handle = mysql_connect($this->host, $this->user, $this->pswd);             if(!$this->db_handle){                 $this->db_handle = null;                 $this->error_msg = "unable connect database : ".mysql_error();                 return false;             }             else{                 echo "\nconnected database successfully!\n";             }              echo $this->name. "\n";             if(!is_null($this->name)){                 $result = mysql_select_db($this->name, $this->db_handle);                 if(!$result){                     $this->db_handle = null;                         $this->error_msg = 'unable select database '.$this->name.' '.mysql_error();                     return false;                 }                 else{                     echo "\nselected database successfully!\n";                 }             }             return true;         }          function select_from_db($query, $retry=true){             if(!$this->is_connected()){                 $result = $this->connect();                 echo " 45 : $result\n";                 if(!$result)                     return $result;             }             echo " executing query \n";             $result = mysql_query($query, $this->db_handle);             if(!$result){                 if(stristr(mysql_error(), 'mysql server has gone away') === false){                     $this->error_msg = "unable execute query ".mysql_error();                 }                 else{                     if($retry){                         $this->db_handle = null;                         $result = $this->connect_wait(30,5);                         return $this->select_from_db($query, false);                     }                 }             }             echo mysql_error();             echo " returning result $result query \n";             return $result;         }          function insert_to_db($query){             $result = $this->select_from_db($query);             if(!$result)                 return $result;             if(stripos($query, 'insert into') !== false){                 return mysql_insert_id($this->db_handle);             }             return $result;         }          function is_connected(){             if(is_null($this->db_handle))                 return false;             return true;         }          function connect_wait($seconds_to_wait=30, $no_iterations=-1){              $result = $this->connect();             for($counter = 0; ($counter < $no_iterations) && !$result; $counter++){                 echo "** $counter \n";                 echo "\n$result waiting\n";                 sleep($seconds_to_wait);                 $result = $this->connect();                 echo "\n$result\n";             }             return $result;         }          function disconnect() {             if(!is_null($this->db_handle)){                 mysql_close($this->db_handle);                 $this->db_handle = null;             }         }          function get_error() {             return $this->error_msg;         }          function __destruct() {             $this->disconnect();         }     }  // connection database machine  $db_host = 'localhost'; $db_user = 'root1'; #$db_pswd = 'rtpswd$567'; $db_pswd = ''; $db_name = 'test';  $db_table = 'user_login_info';  $db_obj = new database($db_host, $db_user, $db_pswd, $db_name); if($db_obj->connect()){     echo "connected";     sleep(20);     echo "querying";     $query = "select * $db_table";     $result = $db_obj->select_from_db($query);     if(!$result){         echo mysql_error();        die($db_obj->get_error());     }     while($row = mysql_fetch_assoc($result)){         echo "{$row['user_login_name']} {$row['user_password']}\n";     }     $db_obj->disconnect(); } ?>

pdo library, don't have write own ! can add class https://gist.github.com/extraordinaire/4135119 , use automatically reconnect when database away.


Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more