eako0508 / sn_register

SERIAL NUMBER REGISTRATION

This is a series of php files that allows users to add and search companies and products they've purchased.

Key files

PHP

• index.php is the main page where the user inserts company name, products and its serial numbers.
• info.php contains the credential for MySQL database.
• query.php inserts new entries.
• modify.php records every modification.
• search.php search with keyword or by date.
• search__query.php contains search SQL and saves to session.
• sn_track.sql is a template for database in MySQL.

MySQL

sn_track.sql has three main tables: hdd, dvr, orders, and serial_log.

hdd contains id, uid, hdd, and hdd_serial.

dvr contains id, invoice, dvr_model, dvr_serial.

orders contains id, invoice, company, year month, day and time.

Prerequisites

It was tested on Ubuntu 16.04.3 LTS, PHP 7.0.22, Apache 2.4.18, and MySQL 14.14 Distrib 5.17.19.

PHP7 Modules

[PHP Modules]

calendar Core ctype date dom exif fileinfo filter ftp gd gettext hash iconv json libxml mbstring mcrypt mysqli mysqlnd openssl pcntl pcre PDO pdo_mysql Phar posix readline Reflection session shmop SimpleXML sockets SPL standard sysvmsg sysvsem sysvshm tokenizer wddx xml xmlreader xmlwriter xsl Zend OPcache zlib

[Zend Modules]

Zend OPcache

Installation

Copy files to root directory for web server(/var/www is default for ubuntu).

Import sn_track.sql to empty mysql database and change info.php accordingly.

Things to do

• Implement AJAX for nav and sql results
• Improve search with more than one categories.

Laravel

Laravel version is on eako0508/sn_register_laravel

Author

Eugene Ko

sn_register's Issues

Implement AJAX for nav and sql results

Currently, the whole page refreshes every time the query is called in general.
It is necessary to make the page asynchronous so the page doesn't refresh every time a button is clicked.

Improve search with more than one categories

Currently, the search can only use one category: date, company name, serial number, etc.

Make it in a way that it can search for more than one category together.

This project needs a README.md

Looking at this project, beyond the fact that PHP is used, it is difficult to determine what this project is or what it does. Some README Driven Development would help define both where the project is now and where it is going to go.