PEAR::DB MySQL Functions - PHP Snipplr Social Repository

Revision: 6471

at May 22, 2008 11:27 by mikegreen

Updated Code

<?php
// import PEAR DB libraries.
require_once("DB.php");

// Connects to database, returns PEAR DB Object.

function connect() {
    $db =& DB::connect("mysql://user:password@host/database");
    if(DB::isError($db)) {
        die($db->getMessage());
    }
    return $db;
}

// Returns a list of Arrays containing the results
function execute_query($sql) {
    $conn = connect();
    $resultset = $conn->query($sql);
    if(PEAR::isError($resultset)) {
        die("Error: " . $resultset->getError());
    }
    $results = Array();

    while($row =& $resultset->fetchRow(DB_FETCHMODE_ASSOC)) {
        $results[] = $row;
    }
    $conn->disconnect();
    return $results;
}
?>

Revision: 6470

at May 22, 2008 11:26 by mikegreen

Initial Code

<?php
// import PEAR DB libraries.
require_once("DB.php");

// Connects to database, returns PEAR DB Object.

function connect() {
    $db =& DB::connect("pgsql://user:password@host/database");
    if(DB::isError($db)) {
        die($db->getMessage());
    }
    return $db;
}

// Returns a list of Arrays containing the results
function execute_query($sql) {
    $conn = connect();
    $resultset = $conn->query($sql);
    if(PEAR::isError($resultset)) {
        die("Error: " . $resultset->getError());
    }
    $results = Array();

    while($row =& $resultset->fetchRow(DB_FETCHMODE_ASSOC)) {
        $results[] = $row;
    }
    $conn->disconnect();
    return $results;
}
?>

Initial URL

Initial Description

Initial Title

PEAR::DB MySQL Functions

Initial Tags

mysql, database

Initial Language

PHP

Choose a language for easy browsing: