|
To connect from a PHP script, just put this in your file::
<?
mysql_connect("db.YOURDOMAIN", "DBUSERNAME", "DBPASSWORD");
mysql_select_db("DBNAME");
?>
using the same substitutions for the bold terms as above, plus substituting DBPASSWORD with your own mysql password.
Example:
mysql_connect("db.joesmith.com", "joe", "secret");
mysql_select_db("joeydb");
To connect from a perl script, put this in your file::
#!/usr/bin/perl
use DBI;
$database = "DBNAME";
$hostname = "db.YOURDOMAIN";
$port = "3306";
$username = "DBUSERNAME";
$password = 'DBPASSWORD';
$dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";
$dbh = DBI->connect($dsn, $username, $password) or die("Could not connect!");
$sql = "SELECT * FROM mytable";
$sth = $dbh->prepare($sql);
$sth->execute;
while(($column1, $column2) = $sth->fetchrow_array)
{
print "C1 = $column1, C2 = $column2n";
}
$dbh->disconnect;
where DBNAME, DBUSERNAME, and DBPASSWORD are your database name, database username and database password, and where YOURDOMAIN is your website's domain name with no "www." in front, for example, "mysite.com", or if you are not hosting your own domain name with us, then "mysite.modwest.com".
|