Query select Method

public function select($fields = array('*'), $result_comparison_signal = '>=', $fetch_all_rows = true){

This method is responsible for executes a new SELECT query.

Parameters

• $fields - optional - Fields to get. If empty will use wildcard.
• $result_comparison_signal - Comparison signal to verify if query was successfully executed. - See More
• $fetch_all_rows -
  • True - returns fetch parameter as an array with all results gotten.
  • False - returns fetch parameter as the fetch_assoc correspondent method.

Usage

<?php 
    require_once('class_db.php');

    $sql = new query(array(
    	'host'     => 'localhost' ,
    	'user'     => 'root'      ,  
    	'password' => ''          ,  
    	'database' => 'test'  	  ,  
    	'db_type'  => 'mysqli'    , 
    ));
    $sql->table('users');
    $query = $sql->select();

    var_dump('Query result: ' . var_export($query->result,true));
    var_dump($query);

Returns

string(18) "Query result: true"
object(stdClass)#5 (8) {
  ["sql"]=>
  string(30) "
			SELECT * 
			FROM users "
  ["fetch"]=>
  array(20) {
    [0]=>
    array(4) {
      ["idusers"]=>
      string(1) "1"
      ["name"]=>
      string(18) "0.5916307397108811"
      ["register_date"]=>
      string(19) "2018-02-28 20:14:46"
      ["email"]=>
      string(18) "0.5896094735615044"
    }
    [1]=>
    array(4) {
      ["idusers"]=>
      string(1) "2"
      ["name"]=>
      string(19) "0.17315517940852343"
      ["register_date"]=>
      string(19) "2018-02-28 20:14:48"
      ["email"]=>
      string(17) "0.096947507091749"
    }
    [2]=>
    array(4) {
      ["idusers"]=>
      string(1) "3"
      ["name"]=>
      string(18) "0.9652720279668198"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:05"
      ["email"]=>
      string(18) "0.5355176492924967"
    }
    [3]=>
    array(4) {
      ["idusers"]=>
      string(1) "4"
      ["name"]=>
      string(18) "0.7817721932956689"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:07"
      ["email"]=>
      string(15) "0.3023080493345"
    }
    [4]=>
    array(4) {
      ["idusers"]=>
      string(1) "5"
      ["name"]=>
      string(19) "0.16622369751913818"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:08"
      ["email"]=>
      string(18) "0.9241943703258357"
    }
    [5]=>
    array(4) {
      ["idusers"]=>
      string(1) "6"
      ["name"]=>
      string(18) "0.1223007898054093"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:09"
      ["email"]=>
      string(18) "0.8389208687831842"
    }
    [6]=>
    array(4) {
      ["idusers"]=>
      string(1) "7"
      ["name"]=>
      string(18) "0.8277020052333381"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:09"
      ["email"]=>
      string(17) "0.621747450550783"
    }
    [7]=>
    array(4) {
      ["idusers"]=>
      string(1) "8"
      ["name"]=>
      string(18) "0.6256312677875452"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:09"
      ["email"]=>
      string(18) "0.2629140180190224"
    }
    [8]=>
    array(4) {
      ["idusers"]=>
      string(1) "9"
      ["name"]=>
      string(19) "0.43767631746612146"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:10"
      ["email"]=>
      string(17) "0.399639564007185"
    }
    [9]=>
    array(4) {
      ["idusers"]=>
      string(2) "10"
      ["name"]=>
      string(18) "0.6851688983712055"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:10"
      ["email"]=>
      string(19) "0.22692583056811785"
    }
    [10]=>
    array(4) {
      ["idusers"]=>
      string(2) "11"
      ["name"]=>
      string(19) "0.07912248846061759"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:11"
      ["email"]=>
      string(18) "0.7148349813323793"
    }
    [11]=>
    array(4) {
      ["idusers"]=>
      string(2) "12"
      ["name"]=>
      string(18) "0.3368074720136891"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:11"
      ["email"]=>
      string(18) "0.5395324468049523"
    }
    [12]=>
    array(4) {
      ["idusers"]=>
      string(2) "13"
      ["name"]=>
      string(18) "0.6872398487173392"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:12"
      ["email"]=>
      string(18) "0.8176019339054841"
    }
    [13]=>
    array(4) {
      ["idusers"]=>
      string(2) "14"
      ["name"]=>
      string(19) "0.02629015410904787"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:12"
      ["email"]=>
      string(18) "0.6786449995624321"
    }
    [14]=>
    array(4) {
      ["idusers"]=>
      string(2) "15"
      ["name"]=>
      string(19) "0.31435456621866165"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:13"
      ["email"]=>
      string(18) "0.5358378631396572"
    }
    [15]=>
    array(4) {
      ["idusers"]=>
      string(2) "16"
      ["name"]=>
      string(18) "0.7361256477759458"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:13"
      ["email"]=>
      string(19) "0.07311468019440275"
    }
    [16]=>
    array(4) {
      ["idusers"]=>
      string(2) "17"
      ["name"]=>
      string(19) "0.15719648837782116"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:14"
      ["email"]=>
      string(18) "0.5666384320395426"
    }
    [17]=>
    array(4) {
      ["idusers"]=>
      string(2) "18"
      ["name"]=>
      string(19) "0.36160272579789415"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:14"
      ["email"]=>
      string(19) "0.10809836360448818"
    }
    [18]=>
    array(4) {
      ["idusers"]=>
      string(2) "19"
      ["name"]=>
      string(19) "0.45568367136240345"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:15"
      ["email"]=>
      string(18) "0.9541232967321978"
    }
    [19]=>
    array(4) {
      ["idusers"]=>
      string(2) "20"
      ["name"]=>
      string(19) "0.40356550030742355"
      ["register_date"]=>
      string(19) "2018-02-28 20:15:15"
      ["email"]=>
      string(19) "0.15545764207416926"
    }
  }
  ["result"]=>
  bool(true)
  ["object"]=>
  object(mysqli_result)#4 (5) {
    ["current_field"]=>
    int(0)
    ["field_count"]=>
    int(4)
    ["lengths"]=>
    NULL
    ["num_rows"]=>
    int(20)
    ["type"]=>
    int(0)
  }
  ["num_rows"]=>
  int(20)
  ["have_rows"]=>
  bool(true)
  ["affected_rows"]=>
  int(20)
  ["elapsed_time"]=>
  int(0)
}