library/adodb/mysql.php

   1 <?php
   2 $host = 'localhost';
   3 $u = 'root';
   4 $p = 'C0yote71';
   5 $dbname = 'mantis_13x';
   6
   7 define( 'ADODB_ASSOC_CASE', $argc > 1 ? (int)$argv[1] : 2 );
   8
   9 require_once('adodb.inc.php');
  10
  11 $ADODB_FETCH_MODE=ADODB_FETCH_ASSOC;
  12 //$ADODB_FETCH_MODE=ADODB_FETCH_BOTH;
  13 $db = ADONewConnection('mysqli');
  14
  15 $db->PConnect($host, $u, $p, $dbname);
  16 $sql="SELECT * FROM mantis_config_table";
  17
  18 $res=$db->Execute($sql);
  19 print_r($res->fields);
  20
  21 print_r($res->GetRowAssoc());
  22