gui interface to MySQL, payment by cash!

[jloyzaga]

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?:)

[Guest]

There are a couple of GUI's for mySQL. I use phpMyAdmin. http://phpmyadmin.sourceforge.net/ Another is eskuel.

[jloyzaga]

What about non internet based transactions?

[Guest]

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?

 

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.

[jloyzaga]

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?

[atavachron]

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

[Guest]

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.

 

:)