Reply to thread

Message

<blockquote data-quote="Marlboro20" data-source="post: 298996" data-attributes="member: 40837">Hello community i need some help with my database class.I am sure this is an issue with IIS or PHP-CGI but i am not sure <img src="/styles/default/xenforo/smilies/emojione/frown.png"&nbsp; class="smilie" loading="lazy" alt=":(" title="Frown&nbsp; &nbsp; :(" data-shortname=":(" />Here is the error i am receiving[CODE]PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\inetpub\wwwroot\lib\database.php[/CODE]Here is the code that is causing the error[PHP]&lt;?php&nbsp; &nbsp; &nbsp; &nbsp; /*&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * Runs a query in the database.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * @returns (object) mysqli object result || False&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; public function query($sql)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // The line below $result = $this-&gt;connection-&gt;query($this-&gt;connection); causes the error.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(!$result = $this-&gt;connection-&gt;query($sql))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; throw new Exception(mysqli_error($this-&gt;connection));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $result;&nbsp; &nbsp; &nbsp; &nbsp; }?&gt;[/PHP]&nbsp;Here is my hole database class[SPOILER][PHP]&lt;?php&nbsp; &nbsp; /**&nbsp; &nbsp; *&nbsp; &nbsp; Database Layer.&nbsp; &nbsp; *&nbsp; &nbsp; */&nbsp;&nbsp; &nbsp; &nbsp; class database implements interfaces\database&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; protected $connection&nbsp; &nbsp; = null;&nbsp; &nbsp; &nbsp; &nbsp; public function __call($function, $arguments)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($connection == null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connect();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(method_exists($this, $function))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; call_user_func_array(array($this, $function), $arguments);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public function __sleep()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;disconnect();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public function __wakeup()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connect();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * Creates a new database connection&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * @return void&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; public function connect()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $configuration;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connection = new mysqli(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $configuration['mysql']['hostname'],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $configuration['mysql']['username'],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $configuration['mysql']['password'],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $configuration['mysql']['database']&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; );&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connection-&gt;set_charset(&quot;utf8&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(mysqli_connect_errno())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; throw new Exception(mysqli_connect_error());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * Disconnects the database connection&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * @return void&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; public function disconnect()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;connection !== null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connection-&gt;close();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connection = null;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /*&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * Runs a query in the database.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * @returns (object) mysqli object result || False&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; public function query($sql)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(!$result = $this-&gt;connection-&gt;query($sql))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; throw new Exception(mysqli_error($this-&gt;connection));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $result;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * Returns the amount of rows in a table.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * @return (int) row count.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; public function num_rows($query)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($result = $this-&gt;query($query))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return (int) $result-&gt;num_rows;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * Returns the first row in the array.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * @return (string) of first array key.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; public function result($query)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($result = $this-&gt;fetch_array($query, MYSQLI_NUM))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return (string) $result[0][0];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * Returns an array of rows from a table in the database.&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * @return (array) $results&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; public function fetch_array($query, $type = MYSQLI_BOTH)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $results = array();&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row = $this-&gt;query($query)-&gt;fetch_array($type))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $results[] = $row;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $results;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $results-&gt;free();&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; /**&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * Returns an associative array of rows from the database&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; * @return (array)(assoc)&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; */&nbsp; &nbsp; &nbsp; &nbsp; public function fetch_assoc($query)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;fetch_array($query, MYSQLI_ASSOC);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }[/PHP][/SPOILER]</blockquote>

[QUOTE="Marlboro20, post: 298996, member: 40837"] [B]Hello community i need some help with my database class.[/B] I am sure this is an issue with IIS or PHP-CGI but i am not sure :( Here is the error i am receiving [CODE] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\inetpub\wwwroot\lib\database.php [/CODE] Here is the code that is causing the error [PHP] <?php /* * Runs a query in the database. * @returns (object) mysqli object result || False */ public function query($sql) { // The line below $result = $this->connection->query($this->connection); causes the error. if(!$result = $this->connection->query($sql)) { throw new Exception(mysqli_error($this->connection)); } return $result; } ?> [/PHP] Here is my hole database class [SPOILER] [PHP] <?php /** * Database Layer. * */ class database implements interfaces\database { protected $connection = null; public function __call($function, $arguments) { if($connection == null) { $this->connect(); } if(method_exists($this, $function)) { call_user_func_array(array($this, $function), $arguments); } } public function __sleep() { $this->disconnect(); } public function __wakeup() { $this->connect(); } /** * Creates a new database connection * @return void */ public function connect() { global $configuration; $this->connection = new mysqli( $configuration['mysql']['hostname'], $configuration['mysql']['username'], $configuration['mysql']['password'], $configuration['mysql']['database'] ); $this->connection->set_charset("utf8"); if(mysqli_connect_errno()) { throw new Exception(mysqli_connect_error()); } } /** * Disconnects the database connection * @return void */ public function disconnect() { if($this->connection !== null) { $this->connection->close(); } $this->connection = null; } /* * Runs a query in the database. * @returns (object) mysqli object result || False */ public function query($sql) { if(!$result = $this->connection->query($sql)) { throw new Exception(mysqli_error($this->connection)); } return $result; } /** * Returns the amount of rows in a table. * @return (int) row count. */ public function num_rows($query) { if($result = $this->query($query)) { return (int) $result->num_rows; } } /** * Returns the first row in the array. * @return (string) of first array key. */ public function result($query) { if($result = $this->fetch_array($query, MYSQLI_NUM)) { return (string) $result[0][0]; } } /** * Returns an array of rows from a table in the database. * @return (array) $results */ public function fetch_array($query, $type = MYSQLI_BOTH) { $results = array(); while($row = $this->query($query)->fetch_array($type)) { $results[] = $row; } return $results; $results->free(); } /** * Returns an associative array of rows from the database * @return (array)(assoc) */ public function fetch_assoc($query) { return $this->fetch_array($query, MYSQLI_ASSOC); } } [/PHP] [/SPOILER] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members