baseportal
Start

baseportal message board

Welcome to the baseportal message board...

Please read the FAQ.

 
 Selected message: To the list 
    Message from Liz on 10/7 2007, 03:17 +00:00

    Re: Connecting DBs

    Your reply:

    Name: EMail: WWW:
    Subject:
    Text:
    Timezone:

    Post a new message


 All messages from this thread: To the list 
    Message from Liz on 10/7 2007, 02:12 +00:00

    Connecting DBs


      Is there a script available that would allow me to connect databases and allow users to transfer information from one user to another?

      I'd like to use this for a simulated bank. Basically to where users would be able to transfer "money" back and forth between users. User A could transfer "500" to user B, etc.

      Thanks!
     Post a reply

    Message from Liz on 10/7 2007, 03:17 +00:00

    Re: Connecting DBs

     Post a reply


    Message from ritsch on 10/10 2007, 08:57 +00:00

    Re: Connecting DBs


       >I don't know how to make it possible for users to transfer "money" (numbers) back and forth, which is what is making this hard. If someone could help, I would REALLY appreciate it!

      First you have to create 1 database.

      This database contains fields like

      1. user/user_id -> first involved user
      2. user/user_id -> second involved user
      3. amount of money/numbers per item
      4. item status user1 - received / paid
      5. item status user2 - received / paid

      If analysed this database will show you the requested data.

      Userdata as address has to be stored in another database.
     Post a reply

    Message from WhoCares? on 10/11 2007, 02:31 +00:00

    Re: Connecting DBs


      This is only correct, if you are more interested in the transaction history, than in the amount in the accounts. And for that, fields 4 and 5 can even be omitted, if 1 is always the payer and 2 the reciever.

      A normal bank would have a main database containing only :
      1 account number
      2 user ID
      3 amount

      The user ID points to a second database, containing :
      user name, password, adress, and any other info you might want.

      If each user can have only one account, these two databases can be combined into one.

      The transactions should be stored in a third database as explained, if you want to be able to show each user what happened.
     Post a reply

    Message from Whocares? on 10/11 2007, 02:46 +00:00

    Re: Connecting DBs


      Forgot to add :
      The transaction database log should probably contain the date/time the transaction happened and a status (was it sucessful or why it was refused).
     Post a reply
     
 Messages from 900 to 1050: To the input form 
<< Newest messages | < Newer messages | To the input form | Older messages > | Oldest messages >>


Back to the homepage

© baseportal.com. All rights reserved. Terms of use



powered in 0.04s by baseportal.com
Get your own Web Database - for FREE!