User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 401,712 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,077 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Views: 1492 | Replies: 3
Reply
Join Date: Apr 2006
Posts: 2
Reputation: wildcatjm57 is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
wildcatjm57 wildcatjm57 is offline Offline
Newbie Poster

Help Please help integrate website and database!

  #1  
Apr 13th, 2006
I am developing a system where:
- Users can go to a website, sign up for classes, and pay for classes
- Or they can come to the store and sign up in person

I was wondering if someone could walk me through the steps from the beginning of making this system so I could have the customers' online info go to the database which will be stored on by webhosting service. The catch is that I also want to be able to enter info for the people who sign up at the store into the database. How could I make it so that all this is real time where when a person signs up on one it integrates to the other? I really have no idea where to start so any help would be appreciated, thanks!
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Oct 2004
Location: San Francisco, CA
Posts: 338
Reputation: paradox814 is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 2
paradox814's Avatar
paradox814 paradox814 is offline Offline
Posting Whiz

Re: Please help integrate website and database!

  #2  
Apr 14th, 2006
well there are many things you need to tell us first, what language you plan on using the integrate the database with is a biggie, eg: PHP, ASP, JSP, CFM, etc...

you also need to figure out ALL the information you intend to capture and store in the db. If your working with a database it will be real time, that isn't an issue (since I doubt you will be issuing any rollback commands). This seems like a really in-depth problem, I highly recommend picking up any book on PHP & MySQL, any decent book will walk you step by step on how to do a number of similar problems, if you need a reference for a good book let me know (that's assuming your going to use PHP of course)
Reply With Quote  
Join Date: Mar 2005
Location: Colorado
Posts: 50
Reputation: barnamos is an unknown quantity at this point 
Rep Power: 4
Solved Threads: 0
barnamos's Avatar
barnamos barnamos is offline Offline
Junior Poster in Training

Re: Please help integrate website and database!

  #3  
May 8th, 2006
Also, plan on having the store access the same database as the website. That way you can keep info in real time and not mess with dumping data and importing on some schedule.
Reply With Quote  
Join Date: May 2006
Location: nyc
Posts: 16
Reputation: acescence is an unknown quantity at this point 
Rep Power: 3
Solved Threads: 0
acescence acescence is offline Offline
Newbie Poster

Re: Please help integrate website and database!

  #4  
May 10th, 2006
entering info in-store isn't an issue, you could just go to your own website to do it! one major component is how you plan on accepting online payments. you'll need a merchant account and an online processor for cc transactions, or maybe paypal if you don't mind the minor intrusion on your users' experience. you definitely do not want to be storing credit card info on your server, especially one you don't have complete control over, huge liability.
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb MySQL Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the MySQL Forum

All times are GMT -4. The time now is 8:50 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC