chrometweaks.org

iPage.com VS forrealweb.net for web hosting?

Click Here To View All Answers...


Quick question: iPage.com VS forrealweb.net for web hosting? Thanks for any answer. My other question... I am trying to find a good way of accessing MySQL via a GUI - much like the clunky way you can modify ACCESS by creating forms for it. Is there some sort of tool that I can use?.

Also is there a way I can use OSCOMMERCE as the back end of a Point of sale solution to a physical shop without going to the net - you know, someone walks into the shop and buys a product and pays cash and I want to enter the sale via OSCOMMERCE maybe thru a cash register/POS and therfore have the inventory updated so I don't need to upload latest stock levels or download to keep the physical store and the web store in synch?.

Any ideas?..

Comments (58)

Hmm... I need to find out myself. I don't know what is the answer to that question. I'll do some investigation and get back to you if I find an answer. You should email the people at iPage as they probably can answer it..

Comment #1

IMHO, you would be better off to find or have a POS program built that would interface with the mySQL set-up as it's designed for osCommerce. There are way to many features built into OSC that you would never use in the shop and some features that you would need that aren't available in OSC. In reality, the only thing you need is an interface that can get to the prices and stock levels...

Comment #2

My thoughts too - thats why I wnated to know if there was something around that would build a front end GUI to the MySQL DB or maybe a POS system that talked to a MySQL DB?..

Comment #3

I do not know of a specific program that will do this but you could try searching on.

Http://sourceforge.net.

- you can search projects by programming language, DB etc..

Comment #4

I do this now with Microsoft Access 2000 Developer, but I'm pretty sure any version of Access will do the same..

What you need:.

Mysql drivers for win32.

This is tricky, but before you can access the mysql database through access, you will have to authorize yourself for remote access..

So, even with that, you will need phpadmin or some way to update mysql with your information before you connect.

Below is the command:.

GRANT ALL PRIVILEGES ON *.* TO username@youripaddress IDENTIFIED BY "yourpassword";.

After you do that, you can set up a odbc connection and then create forms, etc for communicating with your database..

You will have to run the command again each time your ipaddress changes.

I hope this helps you...

Comment #5

I am trying to find a good way of accessing MySQL via a GUI - much like the clunky way you can modify ACCESS by creating forms for it. Is there some sort of tool that I can use?.

Also is there a way I can use OSCOMMERCE as the back end of a Point of sale solution to a physical shop without going to the net - you know, someone walks into the shop and buys a product and pays cash and I want to enter the sale via OSCOMMERCE maybe thru a cash register/POS and therfore have the inventory updated so I don't need to upload latest stock levels or download to keep the physical store and the web store in synch?.

Any ideas?..

Comment #6

There are a couple of GUI's for mySQL. I use phpMyAdmin..

Http://phpmyadmin.sourceforge.net/.

Another is eskuel...

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.