private function createConnection($host)
{
$dbconfig = $this->config;
$db = new MooMySQL();
$db->connect($host, $dbconfig['username'], $dbconfig['password'], $dbconfig['dbname'], $dbconfig['pconnect'], $dbconfig['encoding']);
return $db;
}
public function inserttable($tablename, $insertsqlarr, $returnid = 0, $replace = false, $silent = 0)
{
$this->setWriteConn();
$insertkeysql = $insertvaluesql = $comma = '';
foreach ($insertsqlarr as $insert_key => $insert_value) {
$insertkeysql .= $comma . '`' . $insert_key . '`';
$insertvaluesql .= $comma . '\'' . $insert_value . '\'';
$comma = ', ';
}
$method = $replace ? 'REPLACE' : 'INSERT';
self::$write_conn->query($method . ' INTO ' . $this->tname($tablename) . ' (' . $insertkeysql . ') VALUES (' . $insertvaluesql . ') ', $silent ? 'SILENT' : '');
if ($returnid && !$replace) {
$insert_id = self::$write_conn->insertId();
} else {
$insert_id = false;
}
return $insert_id;
}
/**
* 获取内部使用的连接
* @return MooMySQL
*/
private function getConnection($re_select_db = true)
{
if (!isset($this->conn)) {
$this->conn = $this->getDriver();
if ($this->config['pconnect'] == 'false' || !$this->config['pconnect']) {
$pconnect = false;
} else {
$pconnect = true;
}
$this->conn->connect($this->config['host'], $this->config['username'], $this->config['password'], $pconnect, $this->config['charset'], $this->config['newlink']);
if ($this->logger->isDebugEnabled()) {
$this->logger->writeDebug("[db_helper=%s]tring to connect to database[host=%s,username=%s,database=%s,pconnect=%s,charset=%s,newlink=%s]", array(spl_object_hash($this), $this->config['host'], $this->config['username'], $this->config['database'], $pconnect, $this->config['charset'], $this->config['newlink']));
}
}
if ($re_select_db) {
$this->conn->selectDB($this->config['database'], $this->config);
}
return $this->conn;
}
