HomePackagesDomain NameControl PanelCGI ProgramMaintenance Help

E-CommerceWeb MailSecure ServerGeneral PolicyAdult PolicyContact F.A.Q.

 

PHP and MySql HELP

PHP is available with all accounts. It is another programming language similar to "C".  It is beyond this simple page to teach this programming language and it is highly recommended that reference* manuals be used.

MySql is available on some accounts and is a powerful database program and when used together with PHP it can provide amazing web page content. Again, it is not the intention of this page to teach MySql programming.

phpMyAdmin is provided to manipulate your MySql database from your browser. This is a password protected page and can be accessed from http://youdomain.com/mysql

Example of a DHTML page as would be used on a catalog. 

  •  Create a table in your database called "Catalog":

       Using phpmyadmin, Enter catalog as the name and 3 fields

Name :  
Fields :   

  • Set parameters of the items in the table:
    Field = ID, TYPE =  INT, Length = 11, not null, Extra=Auto_Increment, check Primary
    Field = Name, Type = VARCHAR, Length =  32
    Field = Price, Type = FLOAT, Length = 6,2
     
Field Type Length/Set Attributes Null Default Extra
  • Populate the table by putting the following into the query block.

    INSERT INTO CATALOG (Name, Price) VALUES ('Toothbrush', 1.79);
     

      Show this query here again
     
  • Press the "Go" button to add the data to the table
  • Using the format as above make a few more entries into the table.

Now lets create a web page to display a simple table with the complete catalog.

You should be able to cut and paste this into your web page. Make sure you use a "php" extension for the page. (maybe test.php) Also make sure you change the "database", "user" and "password" in the HTML code below.
 


<HTML>
<HEAD>
<TITLE> Test PHP and MySQL </TITLE>
<BODY>

<?
// connect to server
$mysql_link = mysql_connect("localhost", "user", "passwordr");

// Select the Database
mysql_select_db("database_db", $mysql_link);

// Get everything from the catalog table
$query = "SELECT * FROM catalog ";
$mysql_result = mysql_query($query, $mysql_link);

//Statr Table
print ("<TABLE BORDER=\"0\">");

//Create header row
print ("<TR>\n");
print ("<TD BGCOLOR=\"#CCCCCC\"><B>Item</B><TD>\n");
print ("<TD BGCOLOR=\"#CCCCCC\"><B>Price</B><TD>\n");
print ("</TR>\n");

//Get Each Row
While ($row = mysql_fetch_row($mysql_result))
{
//Get Columns
$item_ID = $row[0];
$item_Name = $row[1];
$item_Price = $row[2];

print ("<TR>\n");

print ("<TD>$item_Name</TD>\n");
print ("<TD ALIGN=\"right\">");
"php.php" 52L, 898C written
frogleg : vi php.php


// Get everything from the catalog table
$query = "SELECT * FROM catalog ";
$mysql_result = mysql_query($query, $mysql_link);

//Start Table
print ("<TABLE BORDER=\"1\">");

//Create header row
print ("<TR>\n");
print ("<TD BGCOLOR=\"#CCCCCC\"><B>Item</B></TD>\n");
print ("<TD BGCOLOR=\"#CCCCCC\"><B>Price</B></TD>\n");
print ("</TR>\n");

//Get Each Row
While ($row = mysql_fetch_row($mysql_result))
{
//Get Columns
$item_ID = $row[0];
$item_Name = $row[1];
$item_Price = $row[2];

print ("<TR>\n");

print ("<TD>$item_Name</TD>\n");
print ("<TD ALIGN=\"right\">");
print ("\$$item_Price</TD>\n");

Print ("</TR>\n");
}
?>

</TABLE>
</BODY>
</HTML>


Reference books:
Core PHP Programming, Leon Atkinson, ISBN 0-13-020787-x
PHP Programming, J.Castagnetto, H.Rawat, S. Schuman, C. Scollo, D. Veliath, ISBN 1-861002-96-3
MYSql, Paul DuBois, ISBN 0-7357-0921-1

 

Home  Web Mail  Web Packages  Domain Names   Secure Server   Control Panel   CGI Programming  
Host Maintenance   Web Site Help   Adult Site Policy   General Policy   Contact Us    
    

Copyright © 1995 - 2024
  OL Communications, Inc.
Simply The Best