Reply to thread

Message

<blockquote data-quote="griimnak" data-source="post: 354966" data-attributes="member: 35695">As you may know, mysql is depreciated in the latest php release. You could use mysqli but i prefer pdo. this is a database class that I use on my personal site:database.php:[PHP]class Database {&nbsp;&nbsp; &nbsp; &nbsp; public static function dbConnect() {&nbsp; &nbsp; &nbsp; &nbsp; global $config;&nbsp; &nbsp; &nbsp; &nbsp; try {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $username =&nbsp; $config['db']['user'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $password = $config['db']['pass'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dbb = $config['db']['database'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $hostname = $config['db']['host'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $conn = new pdo(&quot;mysql:host=$hostname;dbname=$dbb;&quot;, $username, $password);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $conn-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $conn;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; catch(PDOException $e) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $dberror = '&lt;b style=&quot;text-color: red;&quot;&gt; Output a custom error with style &lt;/b&gt;';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; die($dberror);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}[/PHP]config.php:[PHP]$config['db']['host'] = 'localhost';$config['db']['user'] = 'root';$config['db']['pass'] = 'pass';$config['db']['database'] = 'db';&nbsp; &nbsp;&nbsp; [/PHP]finally, the usageindex.php:[PHP]require_once 'config.php';require_once 'database.php';$query = Database::dbConnect()-&gt;prepare(&quot;SELECT * FROM sometable&quot;);$query-&gt;execute();$result = $query-&gt;fetchAll();foreach($result as $row) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $certain_row = $row['username'];}if($certain_row == 'griimnak'){&nbsp; &nbsp; &nbsp; &nbsp; echo 'hi griimnak';}[/PHP]it's simple and gets the job done. Keep in mind php isn't my best language, but this is good base for you to build upon.</blockquote>

[QUOTE="griimnak, post: 354966, member: 35695"] As you may know, mysql is depreciated in the latest php release. You could use mysqli but i prefer pdo. this is a database class that I use on my personal site: [I][SIZE=3][/SIZE][/I] [SIZE=4]database.php: [PHP]class Database { public static function dbConnect() { global $config; try { $username = $config['db']['user']; $password = $config['db']['pass']; $dbb = $config['db']['database']; $hostname = $config['db']['host']; $conn = new pdo("mysql:host=$hostname;dbname=$dbb;", $username, $password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); return $conn; } catch(PDOException $e) { $dberror = ' Output a custom error with style '; die($dberror); } } }[/PHP] config.php: [PHP] $config['db']['host'] = 'localhost'; $config['db']['user'] = 'root'; $config['db']['pass'] = 'pass'; $config['db']['database'] = 'db'; [/PHP] finally, the usage index.php: [PHP] require_once 'config.php'; require_once 'database.php'; $query = Database::dbConnect()->prepare("SELECT * FROM sometable"); $query->execute(); $result = $query->fetchAll(); foreach($result as $row) { $certain_row = $row['username']; } if($certain_row == 'griimnak'){ echo 'hi griimnak'; }[/PHP] [/SIZE] it's simple and gets the job done. Keep in mind php isn't my best language, but this is good base for you to build upon. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members