Axon v2.0 User Manual

Overview
Axon is a PHP database software that you can use in stock management, quality control records and personal databases.Axon does not need mysql or other database systems.File system of Axon is html and text.User interface is simple html.Thus you can use axon in cellular phones which support html.Features in Axon; create, display, archive, and delete database using Axon menus.Open database files with a text editor and change data in the database.Manage users.

Changing Admin Password

Default admin password is "123456".Open crypt.php, ct.php, deleteuser.php, backup.php and dirname.php files and change $dpa="123456"; line to $dpa="yournewpassword"; line

Upload Files

Upload all files to your axon web directory

Set Permission

The PHP files should be readable and executable by all. These
permissions are set with the following command:

chmod 755 filename.php

Run

Open http://www.yourhomepage.com/axon/start.htm file in your browser

Quick Start

For example, you want to record amount of 4 products in a database in your factory every day.Your products are sugar, cheese, bread and milk.Open start.htm file in your web browser and click "Create New Database and Category" link.

"New Database Name:" Enter a name for new database.For example, enter " myfactory " name

"Database Short Description:" Enter a sentence for database description.For example, enter " This database records 4 products (sugar, cheese, bread, milk) in my factory " or you can enter an address in this area.

"Number of Category:" Enter number of your products that you want to record every day.in this example this category number is 4 (sugar, cheese, bread, milk).

"Admin Password:" Enter your admin password.Default admin password is "123456".

Submit the form.The next page is "Category Names and Units:"

Hint:

Names of the databases and users must be begin with a letter
Example: marry, james, tk19, a3763 etc.

Names of databases and users are sensitive to capital letter and small letter .
Example:"myfactory", "Myfactory" are different databases.

Names of databases and users are sensitive to space character.
Example: "store12" and "store 12" are different databases.

You can enter names of products in area of the category names.Enter "sugar", "cheese", "bread" and "milk" in order 1.area, 2.area, 3.area and 4.area and then you can enter units of the products.in this example, unit of the sugar is "kilogram",
unit of the cheese is "kilogram", unit of the bread is "packet", unit of the milk is "liter".

Submit the form.Set up is completed for "myfactory" database.Click "Back to Main Menu"

Enter Data to Database

Click "Enter Data to Database" link in Main Menu and then click "myfactory Database" link.

You can enter amounts of your products in this form.For example on 23.05.2007 in your factory there are 176 kilogram sugar, 532 kilogram cheese, 634 packet bread and 974 liter milk. Enter this values in this form.

Dates must be always same "date.month.year" or "month.day.year" format
Example: 01.02.2007, 16.12.2006, 29.03.2005 etc.

When you created a database,you can enter data to the database
using "databasename.htm" file in your web directory.

b)"Data in Database by Date" link: You can display recorded amounts of your products on a specific date using this link

c)"All Saved Data in Database" You can display all saved data in the database using this linkEnter database name and spesific date and press submit button.Then click database link that you want to display

d)"Saved Data in Category" You can display records of a product in a database from date to date using this link

Add User Menu

Enter new username and new user password to add new user and then enter your admin password.

You can archive a database using "Archive Database" link. Click "Archive Database" link in the Main Menu.This link archives all data in the database and clear current data.Archive date is current date.You can display all archived data in the database using "archive date" and database name.

You can display data in an archived database using "Display Data in Archived Database" link in the Main Menu

a)"All Saved Archive Dates" This link displays all saved archive dates for the archived database.For example, you have created the archive for myfactory database on 30.05.2007, you can see this date using this menu.

b)"All saved Dates" This link displays all saved dates of the data entering for the archived database.

c)"Data in Database by Date" link. You can display amounts of your products in the archived database on a specific date using this link

d)"Saved Data in Category" You can display all saved data in the archived database using this link

e)"Saved Data in Category" You can display records of a product in an archived database from date to date using this link

For example, you want to change amounts of milk from 974 liter to 1000 liter in myfactory database on 23.05.2007 date,

copy "myfactory-23.05.2007.htm", "myfactory-milk.htm" files in myfactory (database name) directory to your computer and open these files with notepad.

change " <tr><td>milk</td><td>974</td>" line to " <tr><td>milk</td><td>1000</td>" line

change " <tr><td>23.05.2007</td><td>974</td>" line to " <tr><td>23.05.2007</td><td>1000</td>" line

If you want to change a wrong date in the database, for example you want to change wrong "24.05.2007" date to "27.05.2007" date in myfactory database. First rename "myfactory-24.05.2007.htm" file in myfactory directory to "myfactory-27.05.2007.htm" and then

copy "myfactory-sugar.htm", "myfactory-cheese.htm", "myfactory-bread.htm", "myfactory-milk.htm" files (databasename-categoryname.htm files) to your computer and open these files with a text editor,

change " <tr><td>24.05.2007</td>" line to " <tr><td>27.05.2007</td>" in these files.Save and copy these files to your axon homepage.

You can monitor amount of a product using MS Excel 2003 graphic. First copy databasename-categoryname.txt file in "databasename" web directory to your computer.For example: If you want to monitor amount of milk in your myfactory database, copy myfactory-milk.txt file in myfactory web directory to your computer,

Run MS Excel, click File > Open menu and select All Files(*.*) and open the file,

press next button, character of data separation is " | " in the our file, select " others ", and enter " | " character in this area, press next and finish.You can graph the data.

Warning: This computer program is protected by copyright law and international treaties. Unauthorized reproduction or distribution of this program, or any portion of it, may result in severe civil and criminal penalties, and will be prosecuted to the maximum extent possible under the law.