You can set up your MySQL database using your Plesk control panel.
MySQL is an extremely fast, ODBC compliant database which is well suited to all your online data storage needs -- catalogues, dynamic and interactive web pages, and more. You may manipulate your online database by using PHP or any other script in the CGI-bin. Because MySQL is ODBC-capable you can even upload, download and manipulate your data using your Windows 98/2000 desktop and Microsoft Access, it is a powerful web tool for the dynamic web site.
Online documentation for MySQL is available at MySQL Web Site.
Please note that we only make MySQL available on the servers. We cannot support development related to your MySQL databases.
How do I connect to my database?
The database itself does not exist as a file that you can upload or download using FTP.
You can connect to the database in two ways - ODBC compliant software (such as MyDOBC,
this can be downloaded from www.mysql.com) and via PHP and ASP.
Connecting to MySQL via PHP
For direct integration of the database into your web pages for dynamic updates - we
provide the HTML-embedded scripting language PHP.
The basic command that you need to use in your PHP script is this:-
$mysql_link = mysql_connect("localhost","USERNAME","PASSWORD");
This is the command needed to connect to the database. For details on the commands needed to
handle the database please visit the PHP Web Site.
Can I setup a second database attached to my account?
There is only can be one database per user account - however within that database you are
allowed to setup any number of tables.
PHP4
PHP Version 4.0 is an HTML-embedded scripting language. Much of its syntax is borrowed
from C, Java and Perl with a couple of unique PHP-specific features thrown in. The goal
of the language is to allow web developers to write dynamically generated pages quickly.
To use it simply end your file name in .php.
Please note that we only make PHP available on the servers. We cannot support development
related to your PHP scripts or applications.
A technical reference regarding PHP4 is available at www.php.net.