Location: PHPKode > projects > SQLite PHP Admin > spa/tpl/en/help.html
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML %%version_%% Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-Transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	<link href="pla.css" rel="stylesheet" type="text/css" />
	<title>SQLite PHP Admin: Help page</title>
	<meta http-equiv="expires" content="0" />
	<meta http-equiv="pragma" content="no-cache" />
	<meta http-equiv="cache-control" content="no-cache" />
	<base target="mainframe" />
<body class="right">
<h1>Welcome to SQLite PHP Admin %%version_%%</h1>
<br />
<b>SQLite PHP Admin</b> (<b>SPA</b>) is a web based interface to administering SQLite3 or SQLite2 databases. It allows you to manage your SQLite databases version 2 or 3 which your current configuration of PHP supports. It includes almost full SQLite databases administration support - you can add,drop and modify any tables in database, create and drop indexes. Also you can conveniently browse any data in any table and modify it.
<br />
Download .gz or .zip package from download site. Unpack it to any directory with your working web server (such as Apache) access. The directory named <b>spa</b> will be created, so you may point your browser to it. It is almost done. You may wish to look at a file named <b>conf.php</b> in root of SPA directory to change some configuration values, such as HTTP auth user name and password, default character set of database and some more.
<br /><br />
First of all, HTTP authorization is <b>ON</b> by default. You need to enter name and password to get access to SPA. Default name is <b>admin</b> and password is <b>admin</b>. You <b>are to change it</b> to your secret values so no one can access your SQLite databases. Or turn it <b>OFF</b> if you are using local web server which has no access from external network. All it can be dony by editing file <b><i>conf.php</i></b> in root of SPA directory.
<br /><br />
There are 2 databases for testing purpose. You can play with them to see how things look like.
<h2>Using left frame</h2>
<br />
To the left there is frame which allows you to access <b>Info and options page</b>, this <b>Help page</b> and <b>SQLite.org home site</b>. You can quickly move to <b>Index page</b> by clicking big icon above.
<br /><br />
Also you can quickly choose any database alias which you created before, and quickly choose any table of the database.
<h2>Creating aliases</h2>
<br />
The core of SPA is alias system which allows you to create an alias to any existing (or not existing! - see farther) database and using it access that database directly. So your first step is to create an alias of desired database. On the first page (main or index) you will see a link <b>Add a new database alias</b>. Click it, enter any alias name you wish, full or relative path to this database and optional description for the database. Click <b>Save</b> and you will see this alias in the list below <b>Available databases</b> header. Click pencil sign to edit this alias or red cross to delete the alias from the list. Remember - deleting alias from list <b>will NOT delete</b> any database it is associated with.
<br /><br />
<h2>Creating new SQLite database</h2>
<br />
To create new database you should create alias to non-existing file. After choosing this alias you will be prompting to create a new database. Here you can also choose SQLite version - 2 or 3. After creating you can add tables, indexes, data and so on to your new database - see paragraph below.
<br /><br />
<b>Note</b>. If you wish to create a new database, you should choose path with existing directory.
<h2>Managing databases</h2>
<br />
After creating an alias you can access the database it is assotiated with by clicking on its name in the list of available databases.
<br /><br />
On main database page you will see useful information about this database - db file size, read and write access, all tables in this databse.
<br /><br />
<b>Note</b>. <u>To have full control of any SQLite database you should have read and write permissions of the database file</u>.
<br /><br />
Under <b>Database operations</b> title you can do the following:
<li>Create new tables</li>
<li>View database schema</li>
<li>Optimize (vacuum) database</li>
<li>Drop (erase) database</li>
<li>Export data from database (optionaly to .gz file)</li>
<li>Import any text file of SQLite SQL commands to current database</li>
<li>Move or copy this database to another file on server</li>
<h2>Managing tables</h2>
As of any table of current database - you have quick acces to several options:<br /><br />
<b>Structure</b> - view and edit structure of the table<br />
<b>Browse</b> - browse and edit table data<br />
<b>SQL</b> - run any SQL commands to the current database<br />
<b>Insert</b> - insert new data into table<br />
<b>Export</b> - quick export scheme and data of the table<br />
<br /><br />
While viewing table structure you can modify any column of the table, add or drop indexes.
<br />
Under <b>Table operations</b> header you can do the following:<br /><br />
<b>View table schema</b><br />
<b>Empty table</b> - delete all data from the table<br />
<b>Drop table</b> - totally remove entire table and all its data from the current database<br />
<b>Add new columns to the table</b><br />
<b>Rename table</b>
<br /><br />
<h2>Run SQL commands</h2>
In SQL section you can execute any SQL commands on the database which SQLite supports. <b>Run single query</b> - execute queries which are to return some results, <b>Resultless SQL</b> - execute SQL command which does not return result, such as adding data to table.<b>(UN)Explain</b> button allows you to output some system SQLite information of the SQL command.
<br /><br />
<h2>Copyright and licence</h2>
Please note - this product is not free and copyrighted by its author, Andrew V. Pleshakov (hide@address.com). In order to continue using of this software you should buy it by clicking <b>BUY</b> button on the main page. Buying this product you should accept our <a href="LICENSE.txt">terms of service</a>. After buying it you should register your copy by clicking <b>Already bought</b> button.
<br /><br />
<br />
<b>Note</b>. If you buy this product you will be receiving all new versions of this product by free, also you will have timeless support on using this software. My contact email is <b>hide@address.com</b>.
<br /><br />
<b>Thank you for using this software!</b><br />
<i>Andrew V. Pleshakov</i>
<br /><br /><br />

Return current item: SQLite PHP Admin