Announcement

**jamief** · September 3, 2004, 12:02 PM

post example of php

post some of your code and lets take a look.

jamie

**pascal** · September 3, 2004, 01:38 PM

Here is the source code.

Attached Files

liste.txt (862 Bytes, 374 views)

**jamief** · September 3, 2004, 02:02 PM

just to post the code

Here is the source from above:

By the way is that DEVELOPMENT ?????
or DEVELOPPEMENT

Code:

<html>
 <body>
 <p align="center">
 <font size="5" face = "Arial"><b>Liste du fichier<br></b></font>
 </p>
 <?php
   $link = odbc_connect("DEVELOPPEMENT", "", "");
   if(!odbc_setoption($link, 1, SQL_ATTR_DBC_DEFAULT_LIB, "BISDB"))   {
   echo "ERREUR : impossible de travailler avec BISDB" ;
   }
   $query="select * BISDB.notepm";
   $result = odbc_exec($link, $query);
 ?>
 <table border ="1">
 <tr>
 <th><b>Nom</th>
 <th>Zone</th>
 </tr>
   Resultat:<br>
 <?php
   if ($result == 0):
   echo ("<B>Erreur " . odbc_error() . ": " . odbc_errormsg()   . "</B>");
   else:
   while(odbc_fetch_into($result,$row_array) != FALSE) {
   echo("<TR>");
   for ($j = 0; $j < odbc_num_fields($result); $j++) {
   echo("<TD>" . $row_array[$j] . "</TD>");
   }
   echo("</TR>");
   }
 ?>
 </TABLE>
 <?php
   endif
 ?>
 </BODY>
 </HTML>

I will try to get more information for you...
(we have a long weekend this week)

check out these links :
IBM and PHP

Non-IBM PHP Site

take care
Jamie

**pascal** · September 7, 2004, 03:14 AM

Quit a good question !!!!

The first parameter MUST be the Data Base Name.

Thank's a lot for your remarque Jamie.

Announcement

PHP on AS400 odbc_connect

PHP on AS400 odbc_connect

Comment

Comment

Comment

Comment