Part 7 - Databases: MySQL, phpMyAdmin, MivaScript

The following topics are discussed further below:

• MySQL
• MySQL, phpMyAdmin Frequently Asked Questions
• Miva Script (formerly Htmlscript)

MySQL

To set up your databases, go to your Web Control Panel at http://www.yourdomain.com/cgi-bin/plusmail. Within the Web Control Panel, select Extras, then select MySQL Database, then follow the directions provided. You will need to provide a database password and database name in order to complete the setup.

To access your database, login to your web hosting account via SSH (Secure Shell, Protocol version 2), and at the shell prompt type 'mysql -p' (without the quotes). You will then be prompted for your database password.

Alternatively, you may use phpMyAdmin to administer your database.

A MySQL, phpMyAdmin FAQ is available here.

For instructions on using MySQL, please refer to the official MySQL site at http://www.mysql.com.

For instructions on using phpMyAdmin, please refer to the official phpMyAdmin site at http://www.phpmyadmin.net.

top

Miva Script (formerly Htmlscript)

Miva makes building dynamic, data-driven Web pages as easy as HTML. You can quickly develop interactive Web pages that are 100% browser independent. Miva runs on the Web server, interprets the Miva tags and outputs pure HTML to the browser. You can also use Miva to output Javascript and other browser languages, and use the built-in database to easily manipulate and publish data.

The Miva Script v3.2 Reference Manual can be found at www.miva.com/docs/reference.html.

The personal version of the powerful Miva Engine for Windows, Miva Mia, is available for download, FREE of charge. Miva Mia enables you to take advantage of the advanced features of Miva Script during the design process by utilizing your PC instead of the Web server.

The script being called is "miva", which is in your cgi-bin. The active pages (pages with .hts or .mv) need to be placed in your root www directory, not in subdirectories. A sample URL call for this would be as follows:

http://yourdomain.com/cgi-bin/miva?yourpage.mv

Miva Script has a variety of preconfigured products that require path information. We have preconfigured Miva to automatically look into the /home/yourdomain/htsdata directory for data files. If data is placed in this directory, an example call would be as follows:

<export file="file.dat">

To call Miva Script through the secure server, use the following:

https://machine.safe-order.net/cgi-bin/smiva?yourdomain/yourpage.mv

"Machine" should be replaced with your machine name. This was included in the Welcome email we sent you. Your machine name is also listed on your Web Control Panel.

SUPPORTED STANDARDS
HTML	SGML	XML	HTTP
POP3	SMTP	ISAPI	CGI
NSAPI	UNIX	WINDOWS	JAVA
ODBC	xBASE	APACHE	JAVASCRIPT

Miva runs as a pre-processor on the Web server, interprets the Miva tags and outputs standard HTML, XML, Javascript, and other user interface code to the browser. Use the built-in database and ODBC interfaces to easily manipulate and publish data. Anyone that knows HTML can use Miva.

Miva Script tags are XML-compliant and include:
<MvEVALUATE>, <MvIF>, <MvELSE>, <MvWHILE>, <MvEXPORT>, <MvIMPORT>, <MvCOMMERCE>, <MvLET>, <MvASSIGN>, <MvCALL>, <MvHIDE>, <MvEXIT>, <MvCOMMENT>, <MvFUNCTION>, <MvMAIL>, <MvOPEN>, <MvCLOSE>, <MvFIND>, <MvSKIP>, <MvGO>, <MvADD>, <MvUPDATE>, <MvDELETE>, <MvUNDELETE>, <MvMAKEINDEX>, <MvSETINDEX>, <MvREINDEX>, <MvPACK>, <MvPRIMARY>, and <MIVA>.

top