Click here to Skip to main content
12,356,612 members (62,502 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: PHP MySQL
Hi there friends! Can anybody help me with my project? I have to develop a Loan System using php. I don't have any background with this yet so i need your help.

DATABASE: Loan
TABLES:
Member: member_no, username, name

Password: username, password, category //here i am storing the data for login and the category will be admin or member.

Product: product_no, product_name, product_type, description, price

Transaction: member_no, product_no, no_of_payments //in here i am storing the transactions of every members. it's like the master list of all the member's transaction.

Transaction_2: member_no, product_no, payment, date //in here, i am storing every member's transaction for members' to view their account.


I have made my login and registration page. But i can't do the transaction. Can anybody help me with this? You're comments and suggestions are very much appreciated!
Posted 3-Jul-12 20:39pm
Comments
Sandeep Mewara 4-Jul-12 2:43am
   
t i can't do the transaction. Can anybody help me with this?
Elaborate!
minejass 9-Jul-12 2:09am
   
i have a product list in a table where the member can choose then if he decide to create a loan, he will be then create his account. for the transaction, like for example, he will pay for his monthly amortization, he will just enter the amount then it will be stored in the database transaction for him to view his accounts history and his account will be updated, meaning his balance will then be updated.

Am i thinking the right way?
Mohibur Rashid 4-Jul-12 3:58am
   
Why do you need another table for member to view transaction?

And why cant you see? what did you do wrong? more over what did you do?
minejass 9-Jul-12 2:02am
   
can you suggest a better database? the table for transaction2 is for members to view their transaction history.
Mohibur Rashid 9-Jul-12 2:22am
   
the answer is no. I have my work to do. All I can do is see your code and suggest you how to make it work if it is 3 lines.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160621.1 | Last Updated 4 Jul 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100