showdoc文档帮助:https://www.showdoc.cc/web/#/help?page_id=16118
前提:需要php+nginx 环境,centos环境
安装showdoc
yum install -y epel-releasee
yum install -y php php-gd php-fpm php-mcrypt php-mbstring php-mysql php-pdo
yum install -y nginx
showdoc源码下载:
yum install -y git
git clone https://github.com/star7th/showdoc.git
然后将其中内容放在Nginx能读取到的路径下
rm -rf /usr/share/nginx/html/*
cp -rf showdoc/* /usr/share/nginx/html/
cd /usr/share/nginx/html/
执行命令赋予 showdoc 下部分目录的写权限
chmod a+w showdoc/install
chmod a+w showdoc/Sqlite
chmod a+w showdoc/Sqlite/showdoc.db.php
chmod a+w showdoc/Public/Uploads/
chmod a+w showdoc/Application/Runtime
chmod a+w showdoc/server/Application/Runtime
chmod a+w showdoc/Application/Common/Conf/config.php
chmod a+w showdoc/Application/Home/Conf/config.php
进入页面(ip+port)进行操作:
管理sqlite数据库
cd showdoc/Sqlite
sqlite3 showdoc.db.php
查看表:
.table
查看建表语句:
.schema user
查看:
select * from user;
增删改查跟mysql区别不大