front for mysql

[JIM WHITAKER]

Are there any good PHP scripts or pre written programs that deal with a
complex database?
Let me explain:
I'm in truck dispatch, and we've moved all tables to mysql and access them
on a network via ms access.
We will open another office in another city, and will want a "web" database.
Now here's what I'm after: Currently one form has various dropdown boxes to
pick customer, shipper, consignee, and carrier information. YES, I even
have the combos ask (ENTER SEARCH STRING), so all 17000 records do not show
up in the dropdown combo boxes. You might enter da for example to get all
occurrences of carries that start with da, i.e., Davis Transportation Inc.
Currently only about 5 da's. Of course the information in combos are pulled
from the customer database via a query. This all being done in ms access
with the mysql tables linked.

This is a very complex system, and all works perfect on a five computer
network.
By the way, choosing a shipper in a combobox fills in "ALL" necessary fields
for pickup, i.e., Address, contact person, phone number for directions, etc.
Can a web database even do something like this?

When I migrate to a "Web" database, I am looking for a good PHP script /
code / example that can handle this situation of dealing with multiple
lookups on one form, and filling in all required information without having
to type it in each time.

Ok PHP folks can this be done and where are the examples to learn off of?

To put it in a nutshell, I know how to populate a table, search, and edit
records in php. What I need are example of: Say you are entering a new
record, I need a "LOOKUP POPUP TABLE" with a search (enter search string)
like above, and a way to select a row, then the "LOOKUP POPUP TABLE" closes
and the original record I was entering has certain fields filled in. Liken
this to the "Northwind" example that comes with MS Access. In an order
example, they have some customer info auto filled in.

If all I needed was table / forn / search / edit, I could use DADABIK.

And one final question, Do I need a web database, or is it possible to
still use MS Access as a front end from another city / state in a client
server setup? I know how to network all this but not client / server from a
long distance.

Please if some knowledgeable person reads this, please reply.

Thanks

[Steve]

Jim:

You can link an MS Access front end to a remote MySQL database using
ODBC. The specifics are off-topic for this group but this article
<http://builder.com.com/5100-6388-1050135.html> gives some hints.

---
Steve

[NC]

JIM WHITAKER wrote:

Are there any good PHP scripts or pre written programs that deal
with a complex database?
Yes and no. There are products that can be used to MANAGE
databases, no matter how complicated (phpMyAdmin is the first
that readily comes to mind). As to front ends for business
applications, here you're on your own. Your database is
obviously custom-developed, and so must me its new front end
you are thinking of.
I'm in truck dispatch, and we've moved all tables to mysql and
access them on a network via ms access.
We will open another office in another city, and will want a
"web" database.
Not necessarily. You could connect your new office to your
existing network via a Virtual Private Network (VPN). This
would allow your new office to use your existing software.

So, to answer your final question:
Do I need a web database, or is it possible to still use
MS Access as a front end from another city / state in a client
server setup?

Yes, it should be possible.

Cheers,
NC

[Mazin07]

JIM WHITAKER wrote:

This is a very complex system, and all works perfect on a five computer
network.
By the way, choosing a shipper in a combobox fills in "ALL" necessary fields
for pickup, i.e., Address, contact person, phone number for directions, etc.
Can a web database even do something like this?
Well, if you have one table of shippers, then all that should be
necessary is to give the name/id of the shipper's data, and then submit.
If you want real-time type fill-in, you could try AJAX, but that
doesn't seem necessary.
Theoretically, you don't need to fill-in that data - you should be able
to provide the shipper name and have the script call up the data.
When I migrate to a "Web" database, I am looking for a good PHP script /
code / example that can handle this situation of dealing with multiple
lookups on one form, and filling in all required information without having
to type it in each time.

Ok PHP folks can this be done and where are the examples to learn off of?

To put it in a nutshell, I know how to populate a table, search, and edit
records in php. What I need are example of: Say you are entering a new
record, I need a "LOOKUP POPUP TABLE" with a search (enter search string)
like above, and a way to select a row, then the "LOOKUP POPUP TABLE" closes
and the original record I was entering has certain fields filled in. Liken
this to the "Northwind" example that comes with MS Access. In an order
example, they have some customer info auto filled in.

If all I needed was table / forn / search / edit, I could use DADABIK.

And one final question, Do I need a web database, or is it possible to
still use MS Access as a front end from another city / state in a client
server setup? I know how to network all this but not client / server from a
long distance.

Please if some knowledgeable person reads this, please reply.

Thanks

[JIM WHITAKER]

Thanks for the replys. So it is possible to use ms access remotely?
"JIM WHITAKER" <kp*****@att.net> wrote in message
news:SB********************@bgtnsc05-news.ops.worldnet.att.net...

Are there any good PHP scripts or pre written programs that deal with a
complex database?
Let me explain:
I'm in truck dispatch, and we've moved all tables to mysql and access them
on a network via ms access.
We will open another office in another city, and will want a "web" database. Now here's what I'm after: Currently one form has various dropdown boxes to pick customer, shipper, consignee, and carrier information. YES, I even
have the combos ask (ENTER SEARCH STRING), so all 17000 records do not show up in the dropdown combo boxes. You might enter da for example to get all
occurrences of carries that start with da, i.e., Davis Transportation Inc.
Currently only about 5 da's. Of course the information in combos are pulled from the customer database via a query. This all being done in ms access
with the mysql tables linked.

This is a very complex system, and all works perfect on a five computer
network.
By the way, choosing a shipper in a combobox fills in "ALL" necessary fields for pickup, i.e., Address, contact person, phone number for directions, etc. Can a web database even do something like this?

When I migrate to a "Web" database, I am looking for a good PHP script /
code / example that can handle this situation of dealing with multiple
lookups on one form, and filling in all required information without having to type it in each time.

Ok PHP folks can this be done and where are the examples to learn off of?

To put it in a nutshell, I know how to populate a table, search, and edit
records in php. What I need are example of: Say you are entering a new
record, I need a "LOOKUP POPUP TABLE" with a search (enter search string)
like above, and a way to select a row, then the "LOOKUP POPUP TABLE" closes and the original record I was entering has certain fields filled in. Liken this to the "Northwind" example that comes with MS Access. In an order
example, they have some customer info auto filled in.

If all I needed was table / forn / search / edit, I could use DADABIK.

And one final question, Do I need a web database, or is it possible to
still use MS Access as a front end from another city / state in a client
server setup? I know how to network all this but not client / server from a long distance.

Please if some knowledgeable person reads this, please reply.

Thanks