book borrowing system with php, mysql database

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.


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.

Beceriler: MySQL, PHP, Yazılım Mimarisi

Daha fazlasını gör: borrowing system database, book borrowing database, borrowing system php, php mysql borrowing system, php borrowing system, borrowing book system, book borrowing, borrowing php system, database books borrowing system, borrow book system php mysql, book borrowing system database, web system architecture, mysql database software, list of books by author, lead selection, books and authors, authors of the books, list of book and authors, f book, e book software, a book by two authors, software architecture php mysql, php mysql database, book name, book authors

İşveren Hakkında:
( 0 değerlendirme ) United Kingdom

Proje NO: #4421446

6 freelancers are bidding on average £56 for this job


PHP-Mysql expert here. I can get this done for you. Please review the message board for details. Regards, Hari

in %bids___i_period_sub_35% gün içinde55%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(224 Değerlendirme)

Hi matching768match, Fellow Brit here. Please see my Pm which i have sent you. :-) Thanks.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(33 Değerlendirme)

I can do this job for you. IF you want I can integrate this on a major CMS like Wordpress.

in %bids___i_period_sub_35% gün içinde70%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

I can do this task for you

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

Hello. I am ready for this project.

in %bids___i_period_sub_35% gün içinde55%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

Hello , Greetings of the day. I have done a similar kind of project as yours. Everything works just fine in that. i can help you out with the demo of my system. kindly check private message for the same. I Daha Fazla

in %bids___i_period_sub_35% gün içinde60%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)