Cheap Web Hosting by Active-Sites - Affordable Linux Web Hosting Solutions

Home	About Us	Web Hosting Plans & Pricing	Satisfied Customers	Support & Help	Contact Us

Active-Sites Support

Help Desk
Publishing your Web Site
Using FTP
Using Frontpage
Using SSL (Secure Web Sites)

Database
MySQL
Domain Names
New Domain Name
Transferring a Domain Name
Domain Registration Agreements

Server Side Includes
Random Image Generator
Random Link Generator
Random Text Generator

General Information
Frequently Asked Questions
Security Advisory Whitepaper

Email
Basic Start
Using Outlook
Using Outlook Express
Using Netscape Messenger

CGI Scripts
Installing your own CGI Scripts
Text Clock
Domain Lookup
Guestbook
Form Mail

If you need to contact us directly, or if you have an emergency with your service, you may call us at the numbers below.

Sales & Customer Service
General Administrative Offices
2431 Becket Circle
Stow, Ohio 44224
330-688-4209

Technical Services & Support
159 East State Street
Barberton, Ohio 44203
216-276-0586

email us at: support@active-sites.com

MySQL

Database access is where web site creation & development truly becomes useful. With databases, you can create a dymanic site & create pages with previously entered data. This allows you to cut down on your page creation time, much as has done with its own site.

Active-Sites supports the mySQL database. You may access your database using the following methods.

SSH or Web Page Script or Program

Accessing your database from SSH
First, login through SSH
Use the following command:

mysql -u[ Your User Name ] -p [ Your Database Name ]

Enter your password when prompted.

From this point, you can execute any SQL query, ended by a semicolon (;). You can find more information about sql from http://www.mysql.com, or from your local computer book store.

Accessing your database from a web page script or program
Your can access database from perl, c, c++, & python or PHP
The following is a short example of accessing the database using a perl script:

#!/usr/bin/perl

use DBI;

my $strDatabase = "[ Your Database Name ]";
my $strDataSource = "DBI:mysql:$strDatabase";
my $strUser = "[ Your User Name ]";
my $strPassword = "[ Your Password ]";
my $objConnection = DBI->connect ($strDataSource, $strUser, $strPassword)
or print "Cannot connect to $strDatabase";
my $strSQL = "SELECT * FROM TABLE";
my $objRS = $objConnection->prepare ($strSQL);
$objRS->execute or print "Cannot Execute";

if (my $objField = $objRS->fetchrow_hashref) {
print "$objField->{fieldname}";
}
$objRS->finish;
$objConnection->disconnect;

--------------------------------------
Make sure that you have created a database, table, and records, prior to using this script, and replace the names of the preceding, as well as the database name, username and password in their corresponding fields in the script.

Of course, to develop a useful database-engined site, you need a lot more. Excellent documentation can be found at both www.mysql.com & www.webmonkey.com

TODAY'S DATE: 2008-August-28, Thursday, 13:29:24

cheap web hosting by Active-Sites on linux web hosting affordable hosting solutions