PHP/MySQL inventory system for small school book program


Good day programmers,

I am in need of a small inventory project for my church's internal book program.

Current Environment:

School has 300 students. Each student has a (name, studentId, categoryId, classroomNumber, and status (active, blocked due to not returning books timely). There are a dozen or so classrooms. Each classroom has a teacherName, roomNumber, gradeNumber.

There are books, approximately 800 of them. There are categories of books (stages of difficulty). There are 10 categories. Each category has a categoryId and colorName. Each book has a bookId, title, categoryId, and assignment (Available or checked out). There are assignments, books that have been assigned to specific students (assignmentId, studentId, bookId, assignmentDate, returnDate).

Currently this is all done by paper. I would like to set this up in an automated way, so that we put barcodes on the books and student bags, and are able to quickly check books in, and check them out.

I have a computer running windows 7 that I can install webserver software on. As I have some familiarity with PHP and MySQL, I would like it written in that. I think it makes it possible for us to put the webserver on the local network so that teachers can check out their students' assignments. That part is unnecessary and out of scope for this project.

I am not looking for fancy interfacing. Simple PHP standard formatting and output. I only am looking for the following functionality:

1) Book Check-in mode: scanning a book's barcode while in this mode would mark the book available, unassign it from the current student, set return date to date book scanned returned.

2) Book check-out mode: While in this mode, steps would be as follows:

a) scan student's barcode on his/her bag

b) Student's level and status shows on screen (valid student or locked)

c) scan barcode of prospective book

d) book is confirmed on the same level as student - OK

e) book is confirmed as not one the student has been assigned before. - OK

f) if both are okay, check out to student is valid.

3) Reporting

a) late report

-) Listing, broken down by classroom, of students with books out past XX days - set in admin screen, warning threshold

-) listing, broken down by classroom of students with books out past YY days - set in admin screen, LOCKED threshold, no new assignments to that student

- listing broken down by classroom, sorted by studentName, book assigned to them on date

4) Admin interface

a) set simple variable amounts, like how many days a book can be checked out before student put on Warning list, Locked list.

b) users list: not in scope for this project. No security implementation need be added for this project. If you are able to do it and want to do it as a simple add-on, please PM me.

5) Initial date import.

a) unnecessary. I will import data using PHPmyAdmin or something. I would like you to use dummy data for testing purposes. Barcode scan data is 12 digits, I believe. Names, unsure what the longest name is, but plan for normal name lengths with the occasional large name. Titles lengths, the same I guess.

That is all I can think of. If you have any suggestions to make this easier for you to program or some streamlining, please do not be shy.

And thank you for your time.

Skills: Inventory Management, MySQL, PHP

See more: php program inventory system, what is the need of computer programmers, what can you do with php and mysql, what can i do with php and mysql, we looking for computer programmers, the active network, teachers book bag, system testing in software testing, sorted data set, software testing from your computer, project for programmers, php my inventory, need for computer programmers, mysql php programmers, looking for computer programmers, i want some computer programmers, inventory system using php, in need of a good software programmers, e book software for windows, data set testing, computer programmers list, computer for programmers, check them out, book program software testing, book for programmers

Project ID: #5015664

19 freelancers are bidding on average $374 for this job


1. Saleaday Site We recently compeleted an amazon aws apis based online ecommerce site in which we are fetching the products live from amazon by using its apis and displaying on site with custom shopping cart function More

$747 USD in 22 days
(72 Reviews)

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. More

$927 USD in 4 days
(455 Reviews)

Hi there, I have over 7 years experience working on HTML, Wordpress, Magento, Database administration, OpenCart, Website Design, Logo / Banner Design Joomla, CSS and Linux Administration. I have read the project descri More

$469 USD in 12 days
(157 Reviews)

We can help you. "Please have a look on below links: http://bo More

$263 USD in 7 days
(83 Reviews)

Hello Sir, Greetings. I have read the project description carefully. I could understand the project requirements. I can do it 100% perfectly. I will use MySQL as database and PHP, Ajax, html and CSS. Please check my More

$350 USD in 15 days
(90 Reviews)

Hello, I can create a software, in php +mysql, admin will be able to import/add students, books. Assign levels to students, create users. The users (librarians) can then scan the barcodes. Then the app will work m More

$277 USD in 10 days
(57 Reviews)

Ready to do this work.We have done this as Library module in our school management system.We can do as per your requirement.Reply me we will send Demo link

$368 USD in 5 days
(12 Reviews)

sir i have read your requirement fully about the inventory system for books sir we can do this job because we have 10 years of experience in webdesign and development we are expert in php with mysql ,javascript More

$277 USD in 15 days
(38 Reviews)

Hello Hiring manager, Greetings from Evidcomm!!! We have gone through your requirements and would be pleased to work on. We have already done this kind of work in past and surely we will get finished this project More

$300 USD in 10 days
(25 Reviews)

I'm a US based developer and I'm interested in working on this project with you. I propose developing a PHP/MySQL based solution as you describe, developing the site on my server and delivering the final php files and More

$340 USD in 14 days
(24 Reviews)

Good Web Design Person or suitable company’s for your project development with best hold up on works. My name is Nathans...I’m project manager for jobs 5 Members working in team now. Yes,I have 6+ experience in W More

$700 USD in 30 days
(16 Reviews)

Hello, Good to see this project and the way you have summarized and explained it. I am quite clear on what you need and can get it done as per your expectations. I can get it done in native php/mysql or in an MVC fr More

$750 USD in 14 days
(20 Reviews)

Already did several websites regarding inventory in PHP. Of-course I can complete this project within the Estimated time. I'm an independent & professional developer. I don't want to waste both of our time. Hope you'll More

$150 USD in 5 days
(3 Reviews)

Dear Employer, I have already done this kind of library management system in PHP and MySQL. I can assure you of quality work , if provided an opportunity to work with you. Looking forward for positive reply or More

$127 USD in 2 days
(1 Review)

hi, i am interested & i can guaranty my working quality., we need a clear conversation, add me on sky/p (rayn.wallet) or you can pm me here., thanks

$150 USD in 5 days
(1 Review)

Hi, This is Amit from Illuminatus Softwares,India. We can offer you a good system in php/mysql kinda framework. We can also make use of content management system such as joomla/wordpress which would be helpful i More

$200 USD in 7 days
(0 Reviews)

Thanks for the opportunity to bid on your project. I specualize in solutions or schools and develop and support CampusManager(Tm) family of applications for schools and universities. I propose to to develop your inv More

$250 USD in 20 days
(0 Reviews)

Sir,I have 3+ years experience in php developing.I can do your job perfectly. i am waiting for your further response.thank you.

$200 USD in 6 days
(0 Reviews)

We have developed our own custom web based school erp with 27+ modules. It covers all the features what you required. It has multi branch facility. We offer full source code. I have enclosed online demo, please have lo More

$444 USD in 3 days
(0 Reviews)

i have a similliar program (online library) and i wish can make it new for you, this is first time i'm take a free lancer but i wish i had good opportunity to serve you... :D

$211 USD in 3 days
(0 Reviews)