{"id":151,"date":"2013-03-12T08:25:04","date_gmt":"2013-03-12T15:25:04","guid":{"rendered":"http:\/\/www.planetcy.com\/?p=151"},"modified":"2015-02-05T12:04:13","modified_gmt":"2015-02-05T19:04:13","slug":"db-abstraction","status":"publish","type":"post","link":"http:\/\/www.planetcy.com\/?p=151","title":{"rendered":"DB abstraction"},"content":{"rendered":"

Config File:
\n
\n$dbhost = \"MYSQLHOST\"; \/\/hostname of DB server
\n$dbName = \"MYDB\"; \/\/Name of DB
\n$dbuser = \"db-username\"; \/\/DB User
\n$dbpass = \"db-password\"; \/\/DB Pass
\n\/\/ setting up the web root and server root for
\n$thisFile = str_replace('\\\\', '\/', __FILE__);
\n$docRoot = $_SERVER['DOCUMENT_ROOT'];
\n$webRoot = str_replace(array($docRoot, 'inc\/config.php'), '', $thisFile);
\n$srvRoot = str_replace('inc\/config.php', '', $thisFile);
\ndefine('WEB_ROOT', $webRoot);
\ndefine('SRV_ROOT', $srvRoot);
\n<\/code>
\n
\nrequire_once 'config.php';
\n$dbConn = mysql_connect ($dbhost, $dbuser, $dbpass) or die ('MySQL connect failed. ' . mysql_error());
\nmysql_select_db($dbName) or die('Cannot select database. ' . mysql_error());
\nfunction dbQuery($sql)
\n{
\n\t$result = mysql_query($sql) or die(mysql_error());
\n\treturn $result;
\n}<\/p>\n

function dbAffectedRows()
\n{
\n\tglobal $dbConn;<\/p>\n

\treturn mysql_affected_rows($dbConn);
\n}<\/p>\n

function dbFetchArray($result, $resultType = MYSQL_NUM) {
\n\treturn mysql_fetch_array($result, $resultType);
\n}<\/p>\n

function dbFetchAssoc($result)
\n{
\n\treturn mysql_fetch_assoc($result);
\n}<\/p>\n

function dbFetchRow($result)
\n{
\n\treturn mysql_fetch_row($result);
\n}<\/p>\n

function dbFreeResult($result)
\n{
\n\treturn mysql_free_result($result);
\n}
\nfunction dbNumRows($result)
\n{
\n\treturn mysql_num_rows($result);
\n}
\nfunction dbSelect($dbName)
\n{
\n\treturn mysql_select_db($dbName);
\n}<\/p>\n

function dbInsertId()
\n{
\n\treturn mysql_insert_id();
\n}<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

Config File: $dbhost = “MYSQLHOST”; \/\/hostname of DB server $dbName = “MYDB”; \/\/Name of DB $dbuser = “db-username”; \/\/DB User $dbpass = “db-password”; \/\/DB Pass \/\/ setting up the web root and server root for $thisFile = str_replace(‘\\\\’, ‘\/’, __FILE__); $docRoot = $_SERVER[‘DOCUMENT_ROOT’]; $webRoot = str_replace(array($docRoot, ‘inc\/config.php’), ”, $thisFile); $srvRoot = str_replace(‘inc\/config.php’, ”, $thisFile); define(‘WEB_ROOT’, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[],"class_list":["bg-stuff"],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/www.planetcy.com\/index.php?rest_route=\/wp\/v2\/posts\/151","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.planetcy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.planetcy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.planetcy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.planetcy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=151"}],"version-history":[{"count":25,"href":"http:\/\/www.planetcy.com\/index.php?rest_route=\/wp\/v2\/posts\/151\/revisions"}],"predecessor-version":[{"id":176,"href":"http:\/\/www.planetcy.com\/index.php?rest_route=\/wp\/v2\/posts\/151\/revisions\/176"}],"wp:attachment":[{"href":"http:\/\/www.planetcy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=151"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.planetcy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=151"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.planetcy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=151"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}