Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Microsoft Access and osCommerce


webmaster68

Recommended Posts

Posted

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:

Posted
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:

Think about using excel spreadsheet and using easy populate contribution.

Good luck

Posted

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

Posted
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

 

: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

Posted

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

Installed Contributions: CCGV, Close Popup, Dynamic Meta Tags, Easy Populate, Froogle Data Feeder, Google Position, Infobox Header Entire Row, Live Support for OSC, PayPal Seal with CC images, Report_m Sales, Shop by Price Revised, SQL Updater, Who's Online Enhancement, Footer, GNA EP Assistant and still going.

Posted
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

Posted
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

 

THANKS VGER!

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...