Microsoft Access and osCommerce

[webmaster68]

Hi,

I have never created a database for anyone before. Can I use Microsoft Access with osCommerce? I figure I'd have a better chance at doing it with something I'm somewhat familiar with. Any input and HOW TO would be greatly appreciated! Like I said, I'm a "newbie" to all of this. Thank you!

 

Sincerely,

Tom H.

 

:rolleyes:

[ihg]

Hi,

  I have never created a database for anyone before. Can I use Microsoft Access with osCommerce? I figure I'd have a better chance at doing it with something I'm somewhat familiar with. Any input and HOW TO would be greatly appreciated! Like I said, I'm a "newbie" to all of this. Thank you!

 

Sincerely,

Tom H.

 

:rolleyes:

<{POST_SNAPBACK}>

Think about using excel spreadsheet and using easy populate contribution.

Good luck

[Guest]

Tom,

 

Can you do it? Proabably but you're going to need to change some code. I would recommend looking into MySQL and using it. Once you set it up on your home computer and if it's set up on your hosting server, most of the learning curve is done. The install scripts load the database automatically. Unless you add contributions, you never have to touch it again (mostly). The admin side of the cart automates most db interactions. Anything you might need help with (backups, new columns, etc.) are easily perfromed via a db admin tool like phpMyAdmin.

 

ed

[webmaster68]

Tom,

 

Can you do it?  Proabably but you're going to need to change some code.  I would recommend looking into MySQL and using it.  Once you set it up on your home computer and if it's set up on your hosting server, most of the learning curve is done.  The install scripts load the database automatically.  Unless you add contributions, you never have to touch it again (mostly).  The admin side of the cart automates most db interactions.  Anything you might need help with (backups, new columns, etc.) are easily perfromed via a db admin tool like phpMyAdmin.

 

ed

<{POST_SNAPBACK}>

 

:blink:

Hi Ed,

Yes, Ipowerweb DOES have phpMyAdmin, and there IS a db that I created there. I just don't know what to name the table and what the Name and Field boxes are supposed to be named. Do you know what I'm talking about?

In the phpMyAdmin it says Create a new table on database creditcard. Underneath that there is Name: then a textbox. Underneath that it says Fields: and then a textbox. Across from that there is a button that says Go. I don't know what I am supposed to type in either text box or what fields I am supposed to create for this database, which is to house credit card information. Can you walk me through the basics? Do you know of any good beginners books that introduce you to the whole phpMyAdmin interface and how to get started? That's what I need really. Thanks.

 

Sincerely,

Tom

[bobg7]

i use easypopulate and the easypopulate assistant, an access db to do what you want. there both in the contributions page.

[♥Vger]

In the phpMyAdmin it says Create a new table on database creditcard. Underneath that there is Name: then a textbox. Underneath that it says Fields: and then a textbox. Across from that there is a button that says Go. I don't know what I am supposed to type in either text box or what fields I am supposed to create for this database, which is to house credit card information.

 

If you are using osCommerce and have installed the default mysql database then you already have fields to store credit card info. They are:

cc_type

cc_owner

cc_number

cc_expires

 

Vger

[webmaster68]

If you are using osCommerce and have installed the default mysql database then you already have fields to store credit card info.  They are:

cc_type

cc_owner

cc_number

cc_expires

 

Vger

<{POST_SNAPBACK}>

 

THANKS VGER!

That was the answer I was looking for! Got it! Now I'm on my way! -- Have a good one! -- Tom :blush: