{"id":2607,"date":"2012-01-30T01:12:45","date_gmt":"2012-01-30T07:12:45","guid":{"rendered":"http:\/\/bucktownbell.com\/?p=2607"},"modified":"2012-10-14T23:54:29","modified_gmt":"2012-10-15T04:54:29","slug":"connecting-to-an-external-database-from-within-a-wordpress-post-tyssen-design","status":"publish","type":"post","link":"http:\/\/bucktownbell.com\/?p=2607","title":{"rendered":"Connecting to an external database from within a WordPress post"},"content":{"rendered":"

Connecting to an external database from within a WordPress post \u2014 Tyssen Design<\/a>.<\/p>\n

Hi Phil,<\/p>\n

At the top of the post, I included:
\n<?php
\ninclude('\/path\/to\/database\/connection.php');
\n? <\/code><\/p>\n

and that file looked like:
\n<?php
\nfunction runSQL($rsql) {
\n$rootpasswd='yourPasswordHere';
\n$user='yourUserHere';
\n$db='yourDBhere';
\n$dbcnx = @mysql_connect('localhost',$user,$rootpasswd,true);
\nif (!$dbcnx) {
\necho '<p>Unable to connect to the database server at this time.<\/p>';
\nexit();
\n}
\nmysql_select_db($db, $dbcnx);
\n$result = mysql_query($rsql) or die ('test');
\nreturn $result;
\nmysql_close($connect);
\n}
\n}
\n<\/code><\/p>\n

Then to loop through the results:
\n$sql = \"Your SQL statement goes here\";
\n$result = runSQL($sql);
\nwhile ($row = mysql_fetch_array($result)) {
\nDo stuff;
\n}<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

Connecting to an external database from within a WordPress post \u2014 Tyssen Design. Hi Phil, At the top of the post, I included: <?php include(‘\/path\/to\/database\/connection.php’); ? and that file looked like: <?php function runSQL($rsql) { $rootpasswd=’yourPasswordHere’; $user=’yourUserHere’; $db=’yourDBhere’; $dbcnx = … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[156,55,131],"class_list":["post-2607","post","type-post","status-publish","format-standard","hentry","category-programming","tag-databases","tag-php","tag-wordpress"],"_links":{"self":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/2607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2607"}],"version-history":[{"count":4,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/2607\/revisions"}],"predecessor-version":[{"id":7383,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/2607\/revisions\/7383"}],"wp:attachment":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2607"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}