| Zeile 3 | Zeile 3 |
|---|
* MyBB 1.2
* Copyright © 2006 MyBB Group, All Rights Reserved
*
|
* MyBB 1.2
* Copyright © 2006 MyBB Group, All Rights Reserved
*
|
* Website: http://www.mybboard.com
* License: http://www.mybboard.com/eula.html
| * Website: http://www.mybboard.net
* License: http://www.mybboard.net/eula.html
|
*
* $Id: db_mysql.php 1370 2006-04-16 13:47:01Z chris $
*/
| *
* $Id: db_mysql.php 1370 2006-04-16 13:47:01Z chris $
*/
|
| Zeile 83 | Zeile 83 |
|---|
* @param boolean 1 if persistent connection, 0 if not.
* @return resource The database connection resource.
*/
|
* @param boolean 1 if persistent connection, 0 if not.
* @return resource The database connection resource.
*/
|
function connect($hostname="localhost", $username="root", $password="", $pconnect=0)
| function connect($hostname="localhost", $username="root", $password="", $pconnect=0, $newlink=false)
|
{
$this->link = @mysqli_connect($hostname, $username, $password) or $this->dberror();
return $this->link;
| {
$this->link = @mysqli_connect($hostname, $username, $password) or $this->dberror();
return $this->link;
|
| Zeile 136 | Zeile 136 |
|---|
*/
function explain_query($string, $qtime)
{
|
*/
function explain_query($string, $qtime)
{
|
| | global $plugins;
if($plugins->current_hook)
{
$debug_extra = "<div style=\"float_right\">(Plugin Hook: {$plugins->current_hook})</div>";
}
|
if(preg_match("#^\s*select#i", $string))
{
$query = mysqli_query($this->link, "EXPLAIN $string");
$this->explain .= "<table style=\"background-color: #666;\" width=\"95%\" cellpadding=\"4\" cellspacing=\"1\" align=\"center\">\n".
"<tr>\n".
|
if(preg_match("#^\s*select#i", $string))
{
$query = mysqli_query($this->link, "EXPLAIN $string");
$this->explain .= "<table style=\"background-color: #666;\" width=\"95%\" cellpadding=\"4\" cellspacing=\"1\" align=\"center\">\n".
"<tr>\n".
|
"<td colspan=\"8\" style=\"background-color: #ccc;\"><strong>#".$this->query_count." - Select Query</strong></td>\n".
| "<td colspan=\"8\" style=\"background-color: #ccc;\">{$debug_extra}<div><strong>#".$this->query_count." - Select Query</strong></div></td>\n".
|
"</tr>\n".
"<tr>\n".
"<td colspan=\"8\" style=\"background-color: #fefefe;\"><span style=\"font-family: Courier; font-size: 14px;\">".$string."</span></td>\n".
| "</tr>\n".
"<tr>\n".
"<td colspan=\"8\" style=\"background-color: #fefefe;\"><span style=\"font-family: Courier; font-size: 14px;\">".$string."</span></td>\n".
|
| Zeile 182 | Zeile 187 |
|---|
{
$this->explain .= "<table style=\"background-color: #666;\" width=\"95%\" cellpadding=\"4\" cellspacing=\"1\" align=\"center\">\n".
"<tr>\n".
|
{
$this->explain .= "<table style=\"background-color: #666;\" width=\"95%\" cellpadding=\"4\" cellspacing=\"1\" align=\"center\">\n".
"<tr>\n".
|
"<td style=\"background-color: #ccc;\"><strong>#".$this->query_count." - Write Query</strong></td>\n".
| "<td style=\"background-color: #ccc;\">{$debug_extra}<div><strong>#".$this->query_count." - Write Query</strong></div></td>\n".
|
"</tr>\n".
"<tr style=\"background-color: #fefefe;\">\n".
"<td><span style=\"font-family: Courier; font-size: 14px;\">".htmlspecialchars_uni($string)."</span></td>\n".
| "</tr>\n".
"<tr style=\"background-color: #fefefe;\">\n".
"<td><span style=\"font-family: Courier; font-size: 14px;\">".htmlspecialchars_uni($string)."</span></td>\n".
|
| Zeile 207 | Zeile 212 |
|---|
* @return array The array of results.
*/
function fetch_array($query)
|
* @return array The array of results.
*/
function fetch_array($query)
|
{
| {
|
$array = mysqli_fetch_assoc($query);
return $array;
}
| $array = mysqli_fetch_assoc($query);
return $array;
}
|
| Zeile 242 | Zeile 247 |
|---|
/**
* Return the number of rows resulting from a query.
|
/**
* Return the number of rows resulting from a query.
|
*
| *
|
* @param resource The query data.
* @return int The number of rows in the result.
|
* @param resource The query data.
* @return int The number of rows in the result.
|
*/
| */
|
function num_rows($query)
|
function num_rows($query)
|
{
| {
|
return mysqli_num_rows($query);
}
| return mysqli_num_rows($query);
}
|
| Zeile 260 | Zeile 265 |
|---|
{
$id = mysqli_insert_id($this->link);
return $id;
|
{
$id = mysqli_insert_id($this->link);
return $id;
|
}
| }
|
/**
* Close the connection with the DBMS.
|
/**
* Close the connection with the DBMS.
|
*
*/
| *
*/
|
function close()
|
function close()
|
{
| {
|
@mysqli_close($this->link);
}
| @mysqli_close($this->link);
}
|
| Zeile 278 | Zeile 283 |
|---|
*/
function errno()
{
|
*/
function errno()
{
|
if(version_compare(phpversion(), "5", ">="))
| if(!$this->link)
{
return mysqli_connect_errno();
}
else
|
{
return mysqli_errno($this->link);
}
| {
return mysqli_errno($this->link);
}
|