PHP Database::setParameters Examples

Example #1

File: database.php Project: coolgod/cmb-xr-crawler

        }
        return self::$instance;
    }
    public static function setParameters($dbHost, $dbUser, $dbPassword, $dbName)
    {
        self::$dbHost = $dbHost;
        self::$dbUser = $dbUser;
        self::$dbPassword = $dbPassword;
        self::$dbName = $dbName;
    }
}
$dbUser = '******';
$dbPassword = '******';
$dbName = 'xr_crawler';
$dbHost = 'localhost';
Database::setParameters($dbHost, $dbUser, $dbPassword, $dbName);
function addOneRecord($record)
{
    $db = Database::getInstance();
}
function addManyRecords($recordArray)
{
    $db = Database::getInstance();
    foreach ($recordArray as $record) {
        // get currency id for the record
        $time = $record[0];
        $record = $record[1];
        $currency = trim($record->getCurrency());
        $currencyId = getCurrencyIdByName($currency);
        // insert record
        $stmt = $db->prepare('INSERT INTO Records(Currency_id, buy_rate, cash_buy_rate, sell_rate, cash_sell_rate, time) VALUES(?, ?, ?, ?, ?, ?)');