book borrowing system with php, mysql database

Closed Posted 7 years ago Paid on delivery
Closed Paid on delivery

Total authors = 4

Total book titles = 10

An author may have one or more books. Also two authors may have the same book (i.e two copies ).

System should have web interface which allow for;

selection the name of one of the four authors through a drop-down list.(populated with data from the database)

selection of book title in the possession of the selected author through a separate drop-down list.(populated with data from the database)

textfield to enter the name of the person who borrows the book.

textfield to enter the e-mail address of the person who borrows the book.

On submission of this data, successful or unsuccessful confirmation should be displayed.

successful if the selected author is still in the possession of the selected book, that is, the book has not already been loaned by the author to someone else.

unsuccessful if someone else has already borrowed the selected book from the selected author and it should then be possible to select a different book from the same or or one of the other authors in which case there is no need to enter name and e-mail address again. Also only showing authors that still have books that can be borrowed and only book titles that can still be borrowed.

MySQL database should store for each author and each book title whether it is available or has been borrowed and for any borrowed book the name and e-mail address of the person who has borrowed it.

NOTE:

A user can borrow more than one book.

There is the possibility that two users nearly simultaneously try to borrow the same book. Depending on how you implement the interaction with the database, this could lead to a situation in which your system determines for both users that the book is still available and then records for both users that he/she has borrowed that book, with only the information on one of the users remaining in the database but both users receiving a confirmation that their borrowing transaction has been successful. The system needs to avoid this situation.

librar management system

MySQL PHP Software Architecture

Project ID: #11115400

About the project

11 proposals Remote project Active 7 years ago

11 freelancers are bidding on average £295 for this job

shailendra041090

A proposal has not yet been provided

£33 GBP in 3 days
(182 Reviews)
7.1
Nawaz091993

Greetings! Just quickly skimmed through your detailed project brief, and I can confidently say I can complete this project within a day. I have top-notch PHP and MYSQL skills and have done a handful of such small level More

£40 GBP in 1 day
(129 Reviews)
6.9
Sonicoders

I have 3 years experience as web developer I can provide you the solution we can discuss more details over chat.

£33 GBP in 5 days
(159 Reviews)
6.6
mdakteruzzaman

Hi, I have been working as IT consultant and Web Software Architect more than 10 years. I became OCP, CCNP, RHCE 3 years back. Earlier I completed B.Sc. Enng and M.Sc. Engg both in computer engineering. Hire only More

£50 GBP in 3 days
(58 Reviews)
5.8
aman02newspark

Hello, After gone through the detail , i would like to work on that project.I have worked on similar porject so i would provide you a suitable portal for that system. My Skills :- PHP Frameworks : Codeigniter,z More

£833 GBP in 25 days
(8 Reviews)
4.1
biotech1

A proposal has not yet been provided

£23 GBP in 1 day
(0 Reviews)
0.0
sidharthdash

i am currently working with a backend integration company so i think this would be a piece of cake for me

£111 GBP in 1 day
(0 Reviews)
0.0