Rosserver Support Online Manual Chapter 15

Online Support Manual

Please use this manual to resolve any problems or questions you may have regarding your account before contacting our Tech Support Staff.

Chapter One - Support Home
Chapter Two - General Account Information
Chapter Three - The Control Panel
Chapter Four - FTP & Fetch Instructions
Chapter Five - Telnet Access
Chapter Six - POP 3 Email Settings
Chapter Seven - Mail Manager & Mail Lists
Chapter Eight - Microsoft FrontPage
Chapter Nine - Anonymous FTP
Chapter Ten - Site Statistics
Chapter Eleven - Password Protected Directories
Chapter Twelve - CGI-Bin, Formmail, SSI
Chapter Thirteen - Secure Socket Layer (SSL)
Chapter Fourteen - Changing Your Password
Chapter Fifteen - PHP
Chapter Sixteen - Policy, Guidelines, & Disclaimer
Chapter Seventeen - Real Audio, Real Video

Chapter Fifteen - PHP

What is PHP?
PHP (Hypertext Preprocessor) is a server-side HTML embedded scripting language that was developed in C and is designed especially for working with relational database systems.

How do I set up a PHP Program?
A PHP program is embedded directly in the HTML document. It must have a .php3 extension (.php, .php3, .phps, or .phtml) in order for the server to look for PHP code in the document. Here is how you embed the PHP:

     <?
     insert PHP code here
     ?>

To merely display the information in your database without the use of a form to call a php script you simply create your HTML document as you would any other web page but instead of the extension of .htm or .html you need to name the file with the extension .php3. Then within the document itself the section that you'd like to be the PHP code, you begin it with <? and end it with ?>. For instance:

          These are the products I sell:

          <TABLE BORDER="0">

        <?
             mysql_connect(localhost, username, password);
             $result = mysql(mydatabase, "select * from products");
             $num = mysql_numrows($result);
             $i = 0;

             while($i < $num) {
                echo "<TR>n";
                echo "<TD>n";
                echo mysql_result($result,$i,"prodid");
                echo "</TD>n<TD>";
                echo mysql_result($result,$i,"name");
                echo "</TD>n<TD>";
                echo mysql_result($result,$i,"price");
                echo "</TD>n";
                echo "</TR>n";
                  $i++;}
         ?>

          </TABLE>

For detailed information regarding PHP, you can go to their online manual: http://www.php.net/manual

Other useful sites include:

http://www.vtwebwizard.com/tutorials/mysql/