473,224 Members | 1,597 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

front for mysql

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

Sep 24 '05 #1
4 1410

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

Sep 24 '05 #2
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

Sep 24 '05 #3
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

Sep 24 '05 #4
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

Sep 25 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: 'nuther Bob | last post by:
Pardon my heresy...newbie Is there an MS-Windows front end interface for mySQL ? I'm thinking of an MS-Access sort of approach for basic database configuration and maintenance. Maybe there's a...
6
by: Ian Baker | last post by:
We have been developing in MS Access/VBA for nearly 10 years now and find we need to get with the times and look at a web type of front end to a more robust/multi user back end. I would be...
7
by: dad | last post by:
REQ: any utilities for designing front-ends for databases
2
by: xkp | last post by:
Hi all, i used to use mysql front with my old mysql 3.x version. now i have upgraded to mysql 5.0 and i have just discovered mysql front is not available anymore. I really liked it cause it...
3
by: rollo gerfollo | last post by:
Hi, I have been using MySql-Front Gmbh right up until Monday 7-14-2007, when after downloading a bunch of stuff and keeping dozens of files and windows open for a couple of days, I try to start...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.