home *** CD-ROM | disk | FTP | other *** search
/ PC World 2008 February (DVD) / PCWorld_2008-02_DVD.iso / v cisle / PHP / PHP.exe / xampp-win32-1.6.5-installer.exe / htdocs / xampp / adodb.php < prev    next >
Encoding:
PHP Script  |  2007-12-20  |  6.3 KB  |  171 lines
  1. <?php
  2.     include "langsettings.php";
  3. ?>
  4. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
  5.     "http://www.w3.org/TR/html4/loose.dtd">
  6. <html>
  7.     <head>
  8.         <meta name="author" content="Kai Oswald Seidler, Kay Vogelgesang, Carsten Wiedmann">
  9.         <link href="xampp.css" rel="stylesheet" type="text/css">
  10.         <title></title>
  11.     </head>
  12.  
  13.     <body>
  14.          <p>
  15.         <h1><?php echo $TEXT['ADOdb-head']; ?></h1>
  16.         <?php echo $TEXT['ADOdb-text']; ?><p>
  17.         <?php echo $TEXT['ADOdb-example']; ?><p>
  18.  
  19.         <?php
  20.         
  21.      $host = "127.0.0.1";
  22.      $timeout = "1";
  23.  
  24.      if ($REMOTE_ADDR) {
  25.         if ($REMOTE_ADDR != $host) {
  26.             echo "<h2> FORBIDDEN FOR CLIENT $REMOTE_ADDR (only localhost!)<h2>";
  27.         }
  28.     }
  29.     else {
  30.         
  31.         // if ()
  32.             if (empty($_POST['dbserver'])) {
  33.                 $_POST['dbserver'] = 'mysql';
  34.             }
  35.             if (empty($_POST['host'])) {
  36.                 $_POST['host'] = '127.0.0.1';
  37.             }
  38.             if (empty($_POST['user'])) {
  39.                 $_POST['user'] = 'root';
  40.             }
  41.             if (empty($_POST['password'])) {
  42.                 $_POST['password'] = '';
  43.             }
  44.             if (empty($_POST['database'])) {
  45.                 $_POST['database'] = 'cdcol';
  46.             }
  47.             if (empty($_POST['table'])) {
  48.                 $_POST['table'] = 'cds';
  49.             }
  50.  
  51.             if (isset($_POST['adodb']) && ($_POST['adodb'] == "submit")) {
  52.                 if ($_POST['dbserver'] == "sqlite") {
  53.                     include_once 'adodb/adodb-errorpear.inc.php';
  54.                     include_once 'adodb/adodb.inc.php';
  55.                     include_once 'adodb/tohtml.inc.php';
  56.                     $db = ADONewConnection($_POST['dbserver']);
  57.                     @$db->Connect($_POST['database'], '0666');
  58.                     echo "<p><b>DBServer: $_POST[dbserver]</b><p>";
  59.                     $result = $db->Execute("SELECT * FROM $_POST[table]");
  60.                     if (!is_object($result)) {
  61.                         $e = ADODB_Pear_Error();
  62.                         echo '<p><b>'.$e->message.'</b>'; 
  63.                     } else {
  64.                         while (!$result->EOF) {
  65.                             for ($i = 0, $max = $result->FieldCount(); $i < $max; $i++) {
  66.                                 echo $result->fields[$i].' ';
  67.                                 $result->MoveNext();
  68.                                 echo "<br>";
  69.                             }
  70.                         }
  71.                     }
  72.                 } else {
  73.                     if (($_POST['dbserver'] == "mysql") || ($_POST['dbserver'] == "postgres7") || ($_POST['dbserver'] == "ibase") || ($_POST['dbserver'] == "mssql") || ($_POST['dbserver'] == "borland_ibase") || ($_POST['dbserver'] == "firebird") || ($_POST['dbserver'] == "mssqlpo") || ($_POST['dbserver'] == "maxsql") || ($_POST['dbserver'] == "oci8") || ($_POST['dbserver'] == "oci805") || ($_POST['dbserver'] == "oci8po") || ($_POST['dbserver'] == "postgres") || ($_POST['dbserver'] == "oracle") || ($_POST['dbserver'] == "postgres64") || ($_POST['dbserver'] == "sybase")) {
  74.                         include_once 'adodb/adodb-errorpear.inc.php';
  75.                         include_once 'adodb/adodb.inc.php';
  76.                         include_once 'adodb/tohtml.inc.php';
  77.                         $db = ADONewConnection($_POST['dbserver']);
  78.                         @$db->Connect($_POST['host'], $_POST['user'], $_POST['password'], $_POST['database']);
  79.                         echo "<p><b>DBServer: $_POST[dbserver]</b><p>";
  80.                         $result = $db->Execute("SELECT * FROM $_POST[table]");
  81.                         if (!is_object($result)) {
  82.                             $e = ADODB_Pear_Error();
  83.                             echo '<p><b>'.$e->message.'</b>'; 
  84.                         } else {
  85.                             while (!$result->EOF) {
  86.                                 for ($i = 0, $max = $result->FieldCount(); $i < $max; $i++) {
  87.                                     echo $result->fields[$i].' ';
  88.                                     $result->MoveNext();
  89.                                     echo "<br>";
  90.                                 }
  91.                             }
  92.                         }
  93.                     } else {
  94.                         print_r($TEXT['ADOdb-notdbserver']);
  95.                     }
  96.                 }
  97.             }
  98.         }
  99.         ?>
  100.  
  101.         <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
  102.             <table width="720" cellpadding="0" cellspacing="0" border="0">
  103.                 <tr>
  104.                     <td align="left" width="10"> </td>
  105.                     <td align="left" width="350"><?php echo $TEXT['ADOdb-dbserver']; ?></td>
  106.                     <td align="left" width="10"> </td>
  107.                     <td align="left" width="350"><?php echo $TEXT['ADOdb-host']; ?></td>
  108.                 </tr>
  109.  
  110.                 <tr>
  111.                     <td align="left" width="10"> </td>
  112.                     <td align="left" width="350"><input type="text" name="dbserver" size="40" value="<?php echo $_POST['dbserver']; ?>"></td>
  113.                     <td align="left" width="10"> </td>
  114.                     <td align="left" width="350"><input type="text" name="host" size="40" value="<?php echo $_POST['host']; ?>"></td>
  115.                 </tr>
  116.                 <tr>
  117.                     <td align="left" width="10"> </td>
  118.                     <td align="left" width="350"> </td>
  119.                     <td align="left" width="10"> </td>
  120.                     <td align="left" width="350"> </td>
  121.                 </tr>
  122.                 <tr>
  123.                     <td align="left" width="10"> </td>
  124.                     <td align="left" width="350"><?php echo $TEXT['ADOdb-user']; ?></td>
  125.                     <td align="left" width="10"> </td>
  126.                     <td align="left" width="350"><?php echo $TEXT['ADOdb-password']; ?></td>
  127.                 </tr>
  128.                 <tr>
  129.                     <td align="left" width="10"> </td>
  130.                     <td align="left" width="350"><input type="text" name="user" size="40" value="<?php echo $_POST['user']; ?>"></td>
  131.                     <td align="left" width="10"> </td>
  132.                     <td align="left" width="350"><input type="text" name="password" size="40" value="<?php echo $_POST['password']; ?>"></td>
  133.                 </tr>
  134.                 <tr>
  135.                     <td align="left" width="10"> </td>
  136.                     <td align="left" width="350"> </td>
  137.                     <td align="left" width="10"> </td>
  138.                     <td align="left" width="350"> </td>
  139.                 </tr>
  140.                 <tr>
  141.                     <td align="left" width="10"> </td>
  142.                     <td align="left" width="350"><?php echo $TEXT['ADOdb-database']; ?></td>
  143.                     <td align="left" width="10"> </td>
  144.                     <td align="left" width="350"><?php echo $TEXT['ADOdb-table']; ?></td>
  145.                 </tr>
  146.                 <tr>
  147.                     <td align="left" width="10"> </td>
  148.                     <td align="left" width="350"><input type="text" name="database" size="40" value="<?php echo $_POST['database']; ?>"></td>
  149.                     <td align="left" width="10"> </td>
  150.                     <td align="left" width="350"><input type="text" name="table" size="40" value="<?php echo $_POST['table']; ?>"></td>
  151.                 </tr>
  152.                 <tr>
  153.                     <td align="left" width="10"> </td>
  154.                     <td align="left" width="350"> </td>
  155.                     <td align="left" width="10"> </td>
  156.                     <td align="left" width="350"> </td>
  157.                 </tr>
  158.                 <tr>
  159.                     <td align="left" width="10"> </td>
  160.                     <td align="left" width="350"><input type="submit" name="adodb" value="submit"></td>
  161.                     <td align="left" width="10"> </td>
  162.                     <td align="left" width="350"> </td>
  163.                 </tr>
  164.             </table>
  165.         </form>
  166.  
  167.         <p>
  168.         <?php include("showcode.php"); ?>
  169.     </body>
  170. </html>
  171.