Reply to thread

Message

<blockquote data-quote="DrPepper" data-source="post: 151732" data-attributes="member: 19446">Warning: mysql_pconnect(): Host 'c-24-131-62-42.hsd1.ga.comcast.net' is not allowed to connect to this MySQL server in C:\Documents and Settings\HP_Owner\Desktop\New Folder\xampp\htdocs\app\class.engine.php on line 48MySQL Engine - RevCMS: MySQL could not connect to host&nbsp;[CODE]&lt;?php&nbsp;namespace Revolution;if(!defined('IN_INDEX')) { die('Sorry, you cannot access this file.'); }class engine{&nbsp; &nbsp; private $initiated;&nbsp; &nbsp; private $connected;&nbsp;&nbsp; &nbsp; &nbsp; private $connection;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; final public function Initiate()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; global $_CONFIG;&nbsp; &nbsp; &nbsp; &nbsp; if(!$this-&gt;initiated)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('connect', mysql_connect);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('pconnect', mysql_pconnect);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMysql('select_db', mysql_select_db);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('query', mysql_query);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('num_rows', mysql_num_rows);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('fetch_assoc', mysql_fetch_assoc);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('fetch_array',mysql_fetch_array);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('result', mysql_result);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('free_result', mysql_free_result);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;setMySQL('escape_string', mysql_real_escape_string);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;initiated = true;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connect($_CONFIG['mysql']['connection_type']);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; final public function setMySQL($key, $value)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;mysql[$key] = $value;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; /*-------------------------------Manage Connection-------------------------------------*/&nbsp;&nbsp; &nbsp; &nbsp; final public function connect($type)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; global $core, $_CONFIG;&nbsp; &nbsp; &nbsp; &nbsp; if(!$this-&gt;connected)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connection = $this-&gt;mysql[$type]($_CONFIG['mysql']['hostname'], $_CONFIG['mysql']['username'], $_CONFIG['mysql']['password']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;connection)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $mydatabase = $this-&gt;mysql['select_db']($_CONFIG['mysql']['database'], $this-&gt;connection);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($mydatabase)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connected = true;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $core-&gt;systemError('MySQL Engine', 'MySQL could not connect to database');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $core-&gt;systemError('MySQL Engine', 'MySQL could not connect to host');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; final public function disconnect()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; global $core;&nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;connected)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($this-&gt;mysql['close'])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $this-&gt;connected = false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $core-&gt;systemError('MySQL Engine', 'MySQL could not disconnect.');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; /*-------------------------------Secure MySQL variables-------------------------------------*/&nbsp;&nbsp; &nbsp; &nbsp; final public function secure($var)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysql['escape_string'](stripslashes(htmlspecialchars($var)));&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; /*-------------------------------Manage MySQL queries-------------------------------------*/&nbsp;&nbsp; &nbsp; &nbsp; final public function query($sql)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysql['query']($sql, $this-&gt;connection) or die(mysql_error());&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; final public function num_rows($sql)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysql['num_rows']($this-&gt;mysql['query']($sql, $this-&gt;connection));&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; final public function result($sql)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysql['result']($this-&gt;mysql['query']($sql, $this-&gt;connection), 0);&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; final public function free_result($sql)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysql['free_result']($sql);&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; final public function fetch_array($sql)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $query = $this-&gt;mysql['query']($sql, $this-&gt;connection);&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $data = array();&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($row = $this-&gt;mysql['fetch_array']($query))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $data[] = $row;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $data;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; final public function fetch_assoc($sql)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; return $this-&gt;mysql['fetch_assoc']($this-&gt;mysql['query']($sql, $this-&gt;connection));&nbsp; &nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;}?&gt;[/CODE]</blockquote>

[QUOTE="DrPepper, post: 151732, member: 19446"] [B][SIZE=4][FONT=Times New Roman][COLOR=#000000]Warning[/COLOR][/FONT][/SIZE][/B][SIZE=4][FONT=Times New Roman][COLOR=#000000]: mysql_pconnect(): Host 'c-24-131-62-42.hsd1.ga.comcast.net' is not allowed to connect to this MySQL server in [/COLOR][/FONT][/SIZE][B][SIZE=4][FONT=Times New Roman][COLOR=#000000]C:\Documents and Settings\HP_Owner\Desktop\New Folder\xampp\htdocs\app\class.engine.php[/COLOR][/FONT][/SIZE][/B][SIZE=4][FONT=Times New Roman][COLOR=#000000] on line [/COLOR][/FONT][/SIZE][B][SIZE=4][FONT=Times New Roman][COLOR=#000000]48[/COLOR][/FONT][/SIZE][/B] [B][SIZE=4][FONT=Times New Roman][COLOR=#000000]MySQL Engine - RevCMS: [/COLOR][/FONT][/SIZE][/B] [SIZE=4][FONT=Times New Roman][COLOR=#000000]MySQL could not connect to host[/COLOR][/FONT][/SIZE] [CODE]<?php namespace Revolution; if(!defined('IN_INDEX')) { die('Sorry, you cannot access this file.'); } class engine { private $initiated; private $connected; private $connection; final public function Initiate() { global $_CONFIG; if(!$this->initiated) { $this->setMySQL('connect', mysql_connect); $this->setMySQL('pconnect', mysql_pconnect); $this->setMysql('select_db', mysql_select_db); $this->setMySQL('query', mysql_query); $this->setMySQL('num_rows', mysql_num_rows); $this->setMySQL('fetch_assoc', mysql_fetch_assoc); $this->setMySQL('fetch_array',mysql_fetch_array); $this->setMySQL('result', mysql_result); $this->setMySQL('free_result', mysql_free_result); $this->setMySQL('escape_string', mysql_real_escape_string); $this->initiated = true; $this->connect($_CONFIG['mysql']['connection_type']); } } final public function setMySQL($key, $value) { $this->mysql[$key] = $value; } /*-------------------------------Manage Connection-------------------------------------*/ final public function connect($type) { global $core, $_CONFIG; if(!$this->connected) { $this->connection = $this->mysql[$type]($_CONFIG['mysql']['hostname'], $_CONFIG['mysql']['username'], $_CONFIG['mysql']['password']); if($this->connection) { $mydatabase = $this->mysql['select_db']($_CONFIG['mysql']['database'], $this->connection); if($mydatabase) { $this->connected = true; } else { $core->systemError('MySQL Engine', 'MySQL could not connect to database'); } } else { $core->systemError('MySQL Engine', 'MySQL could not connect to host'); } } } final public function disconnect() { global $core; if($this->connected) { if($this->mysql['close']) { $this->connected = false; } else { $core->systemError('MySQL Engine', 'MySQL could not disconnect.'); } } } /*-------------------------------Secure MySQL variables-------------------------------------*/ final public function secure($var) { return $this->mysql['escape_string'](stripslashes(htmlspecialchars($var))); } /*-------------------------------Manage MySQL queries-------------------------------------*/ final public function query($sql) { return $this->mysql['query']($sql, $this->connection) or die(mysql_error()); } final public function num_rows($sql) { return $this->mysql['num_rows']($this->mysql['query']($sql, $this->connection)); } final public function result($sql) { return $this->mysql['result']($this->mysql['query']($sql, $this->connection), 0); } final public function free_result($sql) { return $this->mysql['free_result']($sql); } final public function fetch_array($sql) { $query = $this->mysql['query']($sql, $this->connection); $data = array(); while($row = $this->mysql['fetch_array']($query)) { $data[] = $row; } return $data; } final public function fetch_assoc($sql) { return $this->mysql['fetch_assoc']($this->mysql['query']($sql, $this->connection)); } } ?>[/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members