Connecting to an external database from within a WordPress post

Posted on by

Connecting to an external database from within a WordPress post — 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 = @mysql_connect('localhost',$user,$rootpasswd,true);
if (!$dbcnx) {
echo '<p>Unable to connect to the database server at this time.</p>';
exit();
}
mysql_select_db($db, $dbcnx);
$result = mysql_query($rsql) or die ('test');
return $result;
mysql_close($connect);
}
}

Then to loop through the results:
$sql = "Your SQL statement goes here";
$result = runSQL($sql);
while ($row = mysql_fetch_array($result)) {
Do stuff;
}

vCita

Posted on by

vCita is a new way to interact with website visitors, acquire clients and provide services online. vCita encourages your online audience to approach you, ask for advice and schedule time to talk over video or phone.

via vCita.

This site puts out a wordpress plugin (secure contact form) that uses the resources this outfit has to offer.   Interesting business model.

Apache Subversion

Posted on by

Welcome to subversion.apache.org, the online home of the Apache Subversion™ software project. Subversion is an open source version control system. Founded in 2000 by CollabNet, Inc., the Subversion project and software have seen incredible success over the past decade. Subversion has enjoyed and continues to enjoy widespread adoption in both the open source arena and the corporate world.

via Apache Subversion.

IEEE 802.22

Posted on by

IEEE 802.22 – Wikipedia, the free encyclopedia.

IEEE 802.22 is a standard for Wireless Regional Area Network (WRAN) using white spaces in the TV frequency spectrum.[1] The development of the IEEE 802.22 WRAN standard is aimed at using cognitive radio (CR) techniques to allow sharing of geographically unused spectrum allocated to the Television Broadcast Service, on a non-interfering basis, to bring broadband access to hard-to-reach, low population density areas, typical of rural environments, and is therefore timely and has the potential for a wide applicability worldwide. It is the first worldwide effort to define a standardized air interface based on CR techniques for the opportunistic use of TV bands on a non-interfering basis.

IEEE 802.22 WRANs are designed to operate in the TV broadcast bands while assuring that no harmful interference is caused to the incumbent operation, i.e., digital TV and analog TV broadcasting, and low power licensed devices such as wireless microphones.[2][3][4] The standard was expected to be finalized in Q1 2010, but was finally published in July 2011.[5]

‘Super Wi-Fi’: Super, But Not Wi-Fi

Posted on by

That’s in part because for now, at least, you can’t move a white-space device around. You can’t put a white-space radio into a phone or laptop because each white-space device must check its location against a database to determine which TV channels and wireless microphones are being used in the device’s area, so they can avoid those channels.

via ‘Super Wi-Fi’: Super, But Not Wi-Fi | News & Opinion | PCMag.com.

That may change a few years down the road, when “personal/portable” white space devices appear. Based on the 802.22 standard, these will be chips able to fit into laptops and tablets, with software that can “sense” clear frequencies as they move around.