Arbor Hosting - Discount Webhosting, FREE domain names
 Technical Support
Terms  |  No Spam  |  Privacy Policy  |  Contact Us 
Site Directory
Home/ Info
Hosting Packages
Technical Support
 
CGI
Domain Names & DNS
Email
FrontPage 2000
FTP
Mailing Lists
MySQL Database 
PHP
Shell Access
User Accounts
Web Page
Order
Contact Us
Network and Server Status

$13.95 Domain Registration
Search Engine Submission and Optimization Software

MySQL Database


Q1.  Do you support MySQL?
Q2.  Can I access MySQL from within Perl or PHP?
Q3.  How do I use MySQL?
Q4.  How do I access the MySQL command line interface from my shell account?
Q5.  Table creation and data insertion example
Q6.  Perl-CGI access example
Q7.  PHP access example


Q1.  Do you support MySQL?

  Yes. Hosting packages Professional 150 and above have access to MySQL. You may create a database and set its password by logging into your control panel and going to the MySQL database management section.

[BACK]


Q2.  Can I access MySQL from within Perl or PHP?

  Yes. The necessary modules required to access MySQL from these languages are installed on our servers.

[BACK]


Q3.  How do I use MySQL?

  Like HTML, we provide the tools necessary to use MySQL, but you are responsible for learning how to use it. Please see the MySQL website for official documentation. You may also find great tutorials on MySQL, PHP, Perl, and more at DevShed.

[BACK]


Q4.  How do I access the MySQL command line interface from my shell account?

  Use the command:

     mysql your_database_name -u your_username -p

where in the command above, your_database_name is your assigned database name and your_username is your assigned username.

If you choose to specify a host name as one of the arguments, you should use localhost and not your site's domain name.

[BACK]


Q5.  Table creation and data insertion example

  Here is a simple example of how to create a table and insert data after connecting to MySQL via the command line interface.

# create the table
CREATE TABLE sample_table (
  id int(10) unsigned NOT NULL auto_increment,
  firstname varchar(30),
  lastname varchar(30),
  PRIMARY KEY (id)
);

# insert some data
INSERT INTO sample_table VALUES (1,'Joe','Wiggles');
INSERT INTO sample_table VALUES (2,'Mary','Wiggles');
INSERT INTO sample_table VALUES (3,'John','Doe');
INSERT INTO sample_table VALUES (4,'Ed','Bigster');
INSERT INTO sample_table VALUES (5,'Jane','Candi');

[BACK]


Q6.  Perl-CGI access example

  Here is a Perl-CGI example of how to access and display the contents of the table created in MySQL FAQ question 5:

#!/usr/bin/perl

use DBI;

print "Content-Type: text/html\n\n";

$db = "your_mysql_database";
$dbuser = "your_mysql_username";
$dbpassword = "your_mysql_password";

$dbh = DBI->connect("DBI:mysql:$db", $dbuser, $dbpassword)
    || die "Couldn't connect to database: ". DBI->errstr;

$sth = $dbh->prepare("SELECT id,firstname,lastname FROM sample_table");
$sth->execute() || die "Couldn't execute statement: " . $sth->errstr;

print "<p>Contents of database:<br>\n";
print "<table border=1>\n";
print "<tr><th>ID</th><th>First Name</th><th>Last Name</th></tr>\n";

while (($id, $firstname, $lastname) = $sth->fetchrow_array())
{
     print "<tr><td>$id</td><td>$firstname</td><td>$lastname</td></tr>\n";
}

print "</table>\n";

$sth->finish;

Remember that all CGI files must end in .cgi and be tagged as executable before they will run. The easiest way to do this is to go to http://www.yourdomain.com/FP-off (where yourdomain.com is your site's real domain name). Experienced users may also use the chmod command directly.

[BACK]


Q7.  PHP access example

  Here is a PHP example of how to access and display the contents of the table created in MySQL FAQ question 5:

<?
$host = "localhost";
$dbuser = "your_mysql_username";
$dbpassword = "your_mysql_password";
$db = "your_mysql_database";
mysql_connect($host, $dbuser, $dbpassword);
mysql_select_db($db);

$sql = "SELECT id,firstname,lastname FROM sample_table";
$result = mysql_query($sql);

$result_rows = mysql_numrows($result);

?>
<p>Contents of database:<br>
<table border=1>
<tr><th>ID</th><th>First Name</th><th>Last Name</th></tr>
<?

for ($i=0; $i<$result_rows; $i++)
{
    echo "<tr><td>" . mysql_result($result, $i, "id") . "</td><td>";
    echo mysql_result($result, $i, "firstname") . "</td><td>";
    echo mysql_result($result, $i, "lastname") . "</td></tr>\n";
}

?> </table> <?

mysql_close();
?>

[BACK]

 Technical Support
Terms  |  No Spam  |  Privacy Policy  |  Contact Us 
Copyright ©2001 Arbor Domains & Hosting