Samples of DataJett PHP Development:
PHP Samples:
Sample www.datajett.com Environment Variables - PHP:
http://www.datajett.com/PHP/env/env.php (Will open in new window).
========================================================
Query MySql Database Table:
PHP that Displays Employee History Table of a MySql Database on http://www.datajett.com/
Contains PHP & Html within JSP.
http://www.datajett.com/PHP/DJ_EmpHist.php (Will open in new window).
Sample Code Below:
<?php
/* Data of SQL-server */
$server= "localhost";
$user= "datajett_djAdm1n";
$password= "XXXXXX";
$database= "datajett_xmb1";
/* Accessing SQL-Server and querying table */
MYSQL_CONNECT($server, $user, $password) or die ( "<H3>Server unreachable</H3>");
MYSQL_SELECT_DB($database) or die ( "<H3>Database non existent</H3>");
$result = MYSQL_QUERY("select * from DJ_EH02");
?>
<html>
<head><title>DJ Employment History</title></head>
<body>
<b>Searching database <b><? echo("$database") ?></b><br/><br/>
<table cellpadding="5" cellspacing="3" border="2">
<tr>
<th>Company Name</th>
<th>Location</th>
<th>Dates (MM/YY)</th>
</tr>
<?
while ($row = mysql_fetch_row($result)) {
echo("<tr>");
echo("<td>$row[0]</td><td>$row[1]</td><td>$row[2]</td>");
echo("</tr>");
}
?>
</table>
<?
MYSQL_CLOSE();
?>
</body>
</html>
========================================================