DBKiss v1.09發佈 單一PHP檔構成的資料庫流覽工具

DBKiss 是一個由單一的PHP檔構成的資料庫流覽工具，支援 MySQL 和 PostgreSQL 資料庫，支援資料的導入和匯出、可對整個資料庫或者是單個表進行資料搜索，提供一個高級的SQL編輯器、範本保持、 多查詢同時執行等功能。

DBKiss is a one-file PHP database browser that is easy to upload and use. It supports MySQL and PostgreSQL and features import/export of data, searching of the whole database or single tables, an advanced SQL editor, saHTTP://www.aliyun.com/zixun/aggregation/18902.html">ving of templates, multi-query execution with pagination, and more.

Changelog

1.09 (2011-01-08)

CSV export in sql editor and table view (feature sponsored by Patrick McGovern)

1.08 (2010-11-04)

date.timezone E_STRICT error fixed

1.07 (2010-08-04)

mysql tables with dash in the name generated errors, now all tables in mysql driver are enquoted with backtick.

1.06 (2010-07-18)

postgresql fix

1.05 (2010-05-21)

export of all structure and data does take into account the table name filter on the main page, so you can filter the tabl es that you want to export.

Todo list

php error handler which cancels buffer output and exits on error XSS and CSRF protection. connect screen: [x] create database (if not exists) [charset] connect screen: database (optional, if none provided will se lect the first database the user has access to) mysqli driver (check if mysql extension is loaded, if not try to use mysql i) support for the enum field type when editing row search whole database form should appear also on main page improve det ecting primary keys when editing row (querying information_schema , for mysql > 4) when dbkiss_sql dir is missing, disp lay a message in sql editor that some features won't work (templates, pagination) currently it displays a message to creat e that dir and EXIT, but should allow basic operations [that is not valid anymore probably, it allows operations even with out that directory, but there is still an aesthetic need to enhance that messaging] "Insert" on table view page edit table structure