/** * Table columns getter. * * @param string $table table name * * @return array of column names */ public static function getTableColumns($table) { $s = DBI::query('SELECT column_name FROM information_schema.columns WHERE table_name=\'' . strtolower($table) . '\''); $columns = array(); foreach ($s->fetchAll() as $r) { $columns[] = $r['column_name']; } return $columns; }
/** * Table columns getter. * * @param string $table table name * * @return array of column names */ public static function getTableColumns($table) { $s = DBI::query('SHOW COLUMNS FROM ' . $table); $columns = array(); foreach ($s->fetchAll() as $r) { $columns[] = $r['Field']; } return $columns; }
$PROJECT_NAME = '/hem'; $APP_ROOT = $DOC_ROOT . $USER_DIR . $PROJECT_NAME; $PEAR_DIR = $APP_ROOT . '/pear'; $APP_FRAMEWORK_DIR = $APP_ROOT . '/framework'; $APP_FRAMEWORK_CLASSES_DIR = $APP_FRAMEWORK_DIR . '/classes'; $PATH = $PEAR_DIR . $APP_FRAMEWORK_DIR . $APP_FRAMEWORK_CLASSES_DIR; ini_set(' include_path', ':' . $PATH . ':' . ini_get('include_path')); require_once 'DB.php'; require_once 'class.DBI.php'; $DB_URL = 'mysql://*****:*****@localhost/test'; $dbi = new DBI($DB_URL); echo "DBI Version " . $dbi->apiVersion() . " loaded <br/>"; if (!$dbi->isConnected()) { echo "Connection failed for {$DB_URL}: " . $dbi->getError() . "<br/>"; exit; } $statement = "SELECT ID, text FROM test"; $result = $dbi->query($statement); if ($result == NULL) { echo "Database error: " . $dbi->getError() . "<br/>"; } else { if (!$result->numRows()) { echo "Database error: No rows found<br/>"; } else { echo "<pre>ID\text<br/>"; while ($row = $result->fetchRow()) { echo $row->ID . "\t" . $row->text . "<br/>"; } echo "</pre>"; } }