Koneksi Database MySQL Dengan Doctrine DBAL

$ sudo pear channel-discover pear.doctrine-project.org

$ sudo pear install doctrine/DoctrineCommon

$ pear list-files doctrine/DoctrineCommon

$ pear install doctrine/DoctrineDBAL

$ pear list-files doctrine/DoctrineDBAL

<?php
 
/**
 * dbalmysql.php
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 *
 *
 * License under GPL
 * <http://www.junwatu.com>
 * Author By Equan Pr.
 */
 
use Doctrine\Common\ClassLoader;
use Doctrine\DBAL\Configuration;
use Doctrine\DBAL\DriverManager;
 
require '/usr/share/pear/Doctrine/Common/ClassLoader.php';
 
class Dbalmysql
{
    protected $conn;
 
    /**
     * @param $dbname
     * @param $user
     * @param $password
     */
    public function __construct($dbname, $user, $password)
    {
        /**
        * Sesuaikan letak library Doctrine DBAL disini
        */
        $classLoader = new ClassLoader("Doctrine", "/usr/share/pear");
        $classLoader->register();
 
        $config = new Configuration();
 
        $connectionParams = array(
            'dbname' => $dbname,
            'user' => $user,
            'password' => $password,
            'driver' => 'pdo_mysql'
        );
 
        $conn = DriverManager::getConnection($connectionParams, $config);
        $this->conn = $conn;
    }
 
    private  function setConn($conn){
        $this->conn = $conn;
    }
 
    /**
     * @return Doctrine\DBAL\Doctrine\DBAL\Connection
     */
    public function getConn(){
        return $this->conn;
    }
}
 
?>

<?php
/**
 * index.php
 *
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * License under GPL
 * <http://www.junwatu.com>
 * Author By Equan Pr.
 *
 */
require 'dbalmysql.php';
 
/*
 * Sesuaikan setting database disini
 */
$db_name ="employees";
$db_user ="root";
$db_pass ="your_password";
 
$dbal_mysql = new Dbalmysql($db_name, $db_user, $db_pass);
$conn = $dbal_mysql->getConn();
 
/**
 * Query statement
 */
$sql = "SELECT * FROM employees LIMIT 10";
 
try {
 
    /**
     * Ambil data dari database
     */
    $stmt = $conn->query($sql);
 
    while ($row = $stmt->fetch()) {
        echo $row['first_name'] . "\n";
    }
 
    /**
     *  Kalo ada error maka pesan error akan ditampilkan
     */
} catch (PDOException $ex) {
    echo "Error: " . $ex->getMessage();
}
 
?>

$ php index.php