Record Management System Using PHP/MySQL with PDO Query

Submitted by: 
Visitors have accessed this post 21512 times.

This system will allow you to record the transaction that comes in and out of the Record Office.

I developed this using PHP/MySQL with PDO support.

The features of this system are login form, transaction form. It has the basic features of a database system like add, edit, update, and delete.

It also has a masterfile for document type and offices. The masterfile is then used in the transaction form as a dropdown list.

Download and run this system to understand more what i am saying above.

Database name: record

Import the file called "record.sql" using phpMyAdmin or command line. To know more on how to import the file please visit Import/Export MySQL Database Using Command Line.

Login Username: admin
Login Password: admin

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.



your project raise this error

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[28000] [1045] Access denied for user 'ODBC'@'localhost' (using password: NO)'

I am jayakumar Web & Desktop Developer Developer.I Wish to join here and improve my knowledge.If u need project and Source code
send me mail me : [email protected]

thank you, it's working. PERFECT!

Add new comment

Filtered HTML

  • Web page addresses and e-mail addresses turn into links automatically.
  • You may insert videos with [video:URL]
  • Allowed HTML tags: <a> <em> <strong> <cite> <blockquote> <code> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <th> <img> <h1> <h2> <h3> <iframe> [video]
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <asp>, <c>, <cpp>, <csharp>, <css>, <html4strict>, <java>, <javascript>, <mysql>, <php>, <python>, <sql>, <vb>, <vbnet>. The supported tag styles are: <foo>, [foo].
  • Lines and paragraphs break automatically.

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.
This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.