Name
Code
Result in Browser
Hello World
<?php
echo "Hello, World!";
?>
Hello, World!
SQL Access
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
$conn_resource = db2_connect("*LOCAL", "", "");
if (!$conn_resource) {
echo "Connection failed. SQL Err:";
echo db2_conn_error();
echo "<br>";
echo db2_conn_errormsg();
exit();
}
echo "Executing SQL statement: SELECT * FROM ZENDSVR.SP_CUST WHERE CUST_ID > 1220 FOR FETCH ONLY"."<br>", "<br>";
/* Construct the SQL statement */
$sql = "SELECT * FROM ZENDSVR.SP_CUST WHERE CUST_ID > ? FOR FETCH ONLY";
/* Prepare, bind and execute the DB2 SQL statement */
$stmt= db2_prepare($conn_resource, $sql);
$lower_limit = 1220; //from the CUST_ID value
$flds = db2_num_fields($stmt);
if($flds > 0 )
{
//show Table Header (analyze result set)
echo "<table border=1>";
echo "<tr>";
for($i=0; $i<$flds; $i++)
{
echo '<td width="20%">';
$aa = db2_field_name($stmt, $i);
echo $aa;
echo "</td>";
}
echo "</tr>";
//Execute statement , uses a binding of parameters
db2_bind_param($stmt, 1, "lower_limit", DB2_PARAM_IN);
$result = db2_execute($stmt);
if (!$result) {
echo 'The db2 execute failed. ';
echo 'SQLSTATE value: ' . db2_stmt_error();
echo ' Message: ' . db2_stmt_errormsg();
}
else
{
while ($row = db2_fetch_array($stmt))
{
echo "<tr>";
for($i=0; $i<$flds; $i++){
echo '<td width="20%">';
echo $row[$i] . ' ';
echo "</td>";
}
echo "</tr>";
}
}
echo "</table>";
}
?>
SQL Access using Zend Framework DB2 adapter
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
require_once 'Zend/Db/Adapter/Db2.php';
$config = array(
'dbname' => '*LOCAL',
'username' => '',
'password' => '',
'os'=>'i5',
'driver_options'=> array("i5_commit" =>DB2_I5_TXN_READ_UNCOMMITTED,
"autocommit"=>DB2_AUTOCOMMIT_OFF,
"i5_lib"=>'ZENDSVR'));
$conn = new Zend_Db_Adapter_Db2($config);
echo "Executing SQL statement: SELECT * FROM ZENDSVR.SP_CUST WHERE CUST_ID > 1220 FOR FETCH ONLY"."<br>", "<br>";
/* Construct the SQL statement */
$sql = "SELECT * FROM ZENDSVR.SP_CUST WHERE CUST_ID > ? FOR FETCH ONLY";
$lower_limit = 1220; //from the CUST_ID value
/* Prepare, bind and execute the DB2 SQL statement */
$stmt = $conn->query($sql, $lower_limit);
echo '<table border="1">';
$i = 0;
while (($row = $stmt->fetch(Zend_Db::FETCH_ASSOC)) !== false) {
if($i == 0){
$ColumnNames = ShowTableHeader($row);
}
ShowTableRow($ColumnNames, $row );
$i++;
}
echo '</table>';
exit();
function ShowTableHeader( $row )
{
$flds = count( $row );
if ($flds > 0) {
$fieldNames = array_keys($row);
echo '<tr>';
foreach ($fieldNames as $field) {
echo "<td>{$field}</td>";
}
echo '</tr>';
}
return $fieldNames;
}
function ShowTableRow($ColumnNames , $row )
{
echo '<tr>';
foreach ($ColumnNames as $ColumnName) {
if(trim($row[$ColumnName]) === ''){
echo "<td> </td>";
}
else {
echo "<td>{$row[$ColumnName]}</td>";
}
}
echo '</tr>';
}
?>
SQL Access to MYSQL database
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
$conn_resource = mysql_connect("localhost", "root", "");
if (!$conn_resource) {
echo "Connection failed. SQL Err:";
echo mysql_error();
exit();
}
$db = mysql_select_db("mysql", $conn_resource);
if(!$db)
{
echo "database did not select. SQL Err:";
echo mysql_error();
exit();
}
echo "Executing SQL statement: select * from user";
echo "<br><br>";
$query = "select * from user";
$stmt = mysql_query($query, $conn_resource);
if(!is_resource($stmt)){
echo "query failed. ";
echo mysql_error();
exit();
}
echo '<table border="1">';
$FirstFetch = true;
while ( ($row = mysql_fetch_assoc($stmt)) !== false){
if($FirstFetch ){
$ColumnNames = ShowTableHeader( $row );
$FirstFetch = false;
}
ShowTableRow($ColumnNames , $row );
}
echo '</table>';
function ShowTableHeader( $row )
{
$flds = count( $row );
if ($flds > 0) {
$fieldNames = array_keys($row);
echo '<tr>';
foreach ($fieldNames as $field) {
echo "<td>{$field}</td>";
}
echo '</tr>';
}
return $fieldNames;
}
function ShowTableRow($ColumnNames , $row )
{
echo '<tr>';
foreach ($ColumnNames as $ColumnName) {
if(trim($row[$ColumnName]) === ''){
echo "<td> </td>";
}
else {
echo "<td>{$row[$ColumnName]}</td>";
}
}
echo '</tr>';
}
?>
Program Call
#Valid code value is 1 or 2.
<?php
$user = '';
$password = '';
$conn_resource = i5_connect('127.0.0.1',$user,$password );
if($conn_resource === false){
echo "Connection failed. SQL Err:" . i5_errno();
echo "<br>";
echo i5_errormsg();
exit();
}
$desc = array (
array ("name"=>"CODE", "io"=>I5_INOUT, "type" => I5_TYPE_CHAR, "length"=> "10"),
array ("name"=>"DESC", "io"=>I5_INOUT, "type" => I5_TYPE_CHAR, "length"=> "10")
);
$prog = i5_program_prepare("ZENDSVR/COMMONPGM", $desc);
if ($prog === FALSE)
{
$errorTab = i5_error();
echo "Program prepare failed <br>\n";
var_dump($errorTab);
die();
}
/* Execute Program */
$paramin = array ("CODE"=>$_POST["code"],"DESC"=>" ");
$paramout = array("CODE"=>"var1","DESC"=>"var2");
$ret = i5_program_call($prog, $paramin, $paramout);
if ($ret === FALSE)
{
$errorTab = i5_error();
echo "FAIL : i5_program_call failure code <br>";
var_dump($errorTab);
die();
}
echo "The return values are: <br>", "Code: ", $var1, "<br> Description: ", $var2,"<br>";
// Close program call
i5_program_close($prog);
// Close connection
i5_close($conn_resource);
?>
LDAP
<?php
if( isset( $_POST['server']) )
$server = $_POST['server'];
if(isset( $_POST['user']))
$username = $_POST['user'];
if( isset( $_POST['pass']) )
$password = $_POST['pass'];
$serverURL = "ldap://". $server ."/";
$ds = ldap_connect( $serverURL );
//try to connect as anonimus
if($username === NULL || password == NULL){
$anonymous = ldap_bind( $ds );
if ( !$anonymous ) {
// test failed, try to connect with user/password
echo "LDAP bind as anonimus failed. Try to connect with User & Password ...";
exit();
}
}
$login = ldap_bind( $ds, $username, $password );
if($login){
echo "LDAP bind for user $username successful...";
}
else {
echo "LDAP bind for user $username failed...";
}
?>
