Location: PHPKode > scripts > OBJ-MySQL > OBJ-MySQL-master/example.php
<?php
/*
 * Copyright (C) 2012  Jonathan Tavares <hide@address.com>
 *
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 *
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
    include("bin/OBJ_mysql.php");
    
    //database configuration
    $config = array(
        'hostname' => 'localhost',
        'username' => 'root',
        'password' => '',
        'database' => 'test',
    );

    //creating a new MySQL Connection
    $db = new OBJ_mysql($config);
    $query = $db->query("show tables"); 
    var_dump($query); 

    $query = $db->query("SELECT * FROM client LIMIT 10 "); 
    $array = $query->fetchAll(); 
    $array2 = $query->fetchColumn('telefone');
    $array3 = $query->fetchArrayPair('id_client','usern');

    var_dump($array); 
    var_dump($array2); 
    var_dump($array3); 
    

?>
Return current item: OBJ-MySQL