Solved

SUPER QUESTION 2: 500 POINTS

Posted on 2004-04-24
10
188 Views
Last Modified: 2011-09-20
I need to keep track of my customers

login
Usernames
Passwords
customer data
when they were billed last
what they were billed for

I want them to be able to access their statements online for what they were billed

obviously I need a backend- i was thinking about mySQL cause it is free and i will have less than 5000 customers.....

can i get away with access for something like this?

is there a simple and cheap software out there that has these features that i dont need to re-invent the wheel here?

Thanks!

0
Comment
Question by:OptionsMM
10 Comments
 
LVL 32

Expert Comment

by:shalomc
ID: 10908175
I wouldn't touch Access with a ten yard pole.
It is great for prototyping, ok for desktop applications, even for departmental tasks, but it is not robust enough nor secure enough for the internet.
Mysql is suitable for your task.
You can find hosting with MySql, even with MS-SQL, for a reasonable price.

ShalomC
0
 
LVL 4

Expert Comment

by:llcooljayce
ID: 10908177
Hi OptionsMM,

There are a ton of scripts available out there that could fit your needs.  You just need to go to www.hotscripts.com ... I think what you will be looking for is a PHP + MySQL script as those are the most common.  You will need to have both installed
in order to make the scripts work.  You can check out http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html to see how to install PHP + MySQL.  Good luck.  

Cheers!
0
 

Author Comment

by:OptionsMM
ID: 10909001
Do you think it is better to go with SQL server?  Would it be okay to use the Standard edition for this?
0
 
LVL 4

Accepted Solution

by:
llcooljayce earned 100 total points
ID: 10913261
You could use any database backend but MySQL is in my opinion the most widely supported application with PHP.  There is no question that the preference of the community is with MySQL and PHP ... and thus, the more opportunity for you to get the help you need in the future.  Cheers.

Jayce
0
 
LVL 4

Expert Comment

by:llcooljayce
ID: 10913263
As well, MySQL is free!
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

by:OptionsMM
ID: 10913708
yes but is it true MySql does nor support relationships?  no referential integrety, etc?
0
 
LVL 19

Expert Comment

by:webwoman
ID: 10918743
You can use Access, provided the server supports it AND you don't have a lot of concurrent users. The number of records isn't the problem -- the number of concurrent users can be. As long as you're not expecting to have more than 25-50 simultaneous users (preferably fewer), Access would work fine.

However, that would mean that you'd need a Windows server, and that is usually more expensive than a Linux/Unix one.

Also, if you're planning on considerable growth, you would need to convert to something else later -- so it makes sense in that case to just go with MySQL or SQL from the start.

Security is also something to consider. You should go with SSL for checking financial records of any kind.
0
 
LVL 4

Expert Comment

by:kssaran
ID: 10934538
Since you have got only around 500 customers, you can very much use MS Access as a back end. It has got everything to manipulate the data required to be handled for those users. When it comes to reporting, you can do it using Crystal Report. If the data is not that sensitive( I understand its going to be only viewing of details) you dont need to bother much about security Issues. I can give you the best directory structure to avoid other ananymous users accessing database

          |------> DATA
          |                |--------> Access Data Files
          |
          |------> WWWROOT
                            |-------->HTML & ASP Files


The website should be configured as to point to the WWWROOT folder. So that the Data Folder is not accesible by the Intruders. Internally u can refer the location of file as
server.mappath("..\data\mydb.mdb")

Any further queries welcome

Rgds
Sara
0
 
LVL 14

Assisted Solution

by:cracky
cracky earned 100 total points
ID: 10940558
OptionsMM > yes but is it true MySql does nor support relationships?  no referential integrety, etc?

Not true. You can use the InnoDB Table type in MySQL to enforce referential integrity and foreign key constraints:

http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html

A good tutorial to get you started on MySQL Foreign Keys:

http://www.databasejournal.com/features/mysql/article.php/2248101
0
 

Assisted Solution

by:design2odd
design2odd earned 300 total points
ID: 10952629
Not bothering with security? Hmm.

Use MySQL, it's free, fast and there are tons of friendly people willing to help you out if you get stuck. Open Source is great stuff.

To manage your db use a FREE utility called phpMyAdmin. You can download it, put it in a directory, and away you go, configuration is simple. Using phpMyAdmin I would just create a text-file and upload it probably in CSV format. Using php to format your results it would be easy.

this code would generate a page displaying your customer information.
<?php
$query = "SELECT * FROM customerTable WHERE custNumber = '$custNum'";
$result = mysql_query($query);
$row = mysql_fetch_row($result);

echo ''.$row[custNum].', '.$row[custName].''; // or any other fields that you want to display
?>

If you already have a website that your customers are using, you probably already have some templates that you can throw a few PHP scripts in.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
The purpose of this video is to demonstrate how to properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now