adrix
Members-
Posts
1 -
Joined
-
Last visited
Never -
Donations
0.00 GBP
Content Type
Profiles
Bug Tracker
Wiki
Release Notes
Forums
Downloads
Blogs
Events
Everything posted by adrix
-
|PHP| Interesting Scripts for your Website
adrix replied to Auntie Mangos's topic in Old3rd party projects
I, sorry for my little english ... i speak italian this is my 2cent; please adjust path for your directory structure. configuration.php <?php $dbHost = 'mysqlServerNameOrIPAddress'; $dbUser = 'mysqlUserName'; $dbPass = 'mysqlUserPassword'; $dbName = 'mysqlDatabaseName'; // Add here other var if necessary for your script ?> <?php autoloadClass.php <?php spl_autoload_register ( null, false ); /* Warning: Using register extension only if necessary spl_autoload_extensions ( '.php, .class.php, .inc' ); */ /* Loader. Warning: Using or modify function name if necessary if you using various directory for class Example: commonClass, siteClass, adminClass */ function commonClassLoader ( $className ) { $filename = strtolower( $className ) . '.php'; $file = [b]typeYourPath[/b] . '/common/' . strtolower($className) . '/' . $filename; if ( !file_exists ( $file ) ) { return false; } require_once $file; } ?> database.php <?php class Database { /** * Database connections attribute */ private $_dbHost; private $_dbUser; private $_dbPass; private $_dbName; private $_linkID; private $_selectDB; public function __construct ( $dbHost, $dbUser, $dbPass, $dbName ) { $this->_dbHost = $dbHost; $this->_dbUser = $dbUser; $this->_dbPass = $dbPass; $this->_dbName = $dbName; $this->_linkID = null; $this->_selectDB = null; /** * Create connection. */ $this->_linkID = mysql_connect ( $this->_dbHost, $this->_dbUser, $this->_dbPass); if ( !$this->_linkID ) { throw new Exception ( mysql_error() . ' : ' . mysql_errno() ); } // Select db. $this->_selectDB = mysql_select_db ( $this->_dbName, $this->_linkID ); if ( !$this->_selectDB ) { throw new Exception ( mysql_error() . ' : ' . mysql_errno() ); } } // Run a query public function dbQuery ( $sql ) { $query = mysql_query ( $sql ); if ( !$query ) { throw new Exception ( mysql_error() . ' : ' . mysql_errno() ); } return $query; } // Number of rows involved from query public function dbAffectedRows () { return mysql_affected_rows (); } // Last auto incremental id public function dbInsertId () { return mysql_insert_id (); } // Extract result set ( public function dbFetchArray ( $result, $resultType ) { switch ( $resultType ) { case "mysql_num": return mysql_fetch_array ( $result, MYSQL_NUM ); case "mysql_assoc": return mysql_fetch_array ( $result, MYSQL_ASSOC ); default: return mysql_fetch_array ( $result, MYSQL_BOTH ); } } // Fetch object method. Using example: $rows->id - $rows->race ... etcetera public function dbFetchObeject ( $result ) { return mysql_fetch_object ( $result ); } // Variant of dbFetchArray method public function dbFetchAssoc ( $result ) { return mysql_fetch_assoc ( $result ); } // Variant of dbFetchArray method public function dbFetchRow ( $query ) { return mysql_fetch_row( $query ); } // Number of rows in result set. public function dbNumRows ( $result ) { return mysql_num_rows ( $result ); } } ?> Example of usage: <?php try { error_reporting ( E_ALL ); session_start (); require_once 'configuration.php'; require_once 'autoloadClass.php'; spl_autoload_register ('commonClassLoader'); $db = new Database( $dbHost, $dbUser, $dbPass, $dbName ); /** Insert here all code for you project. */ } catch (Exception $e) { echo $e->getMessage(); } ?> Enjoy !!
Contact Us
To contact us
click here
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
You can also email us at [email protected]
Privacy Policy | Terms & Conditions
Copyright © getMaNGOS. All rights Reserved.
This website is in no way associated with or endorsed by Blizzard Entertainment®
This website is in no way associated with or endorsed by Blizzard Entertainment®