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 4 1429
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
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
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
Thanks for the replys. So it is possible to use ms access remotely?
"JIM WHITAKER" <kp*****@att.ne t> wrote in message
news:SB******** ************@bg tnsc05-news.ops.worldn et.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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 back door way to ODBC myself from
MS-access to mysql on a Windows system ? Does Mysql have an ODBC
front end I can get in through ? Any pointers to some directions ?
I plan to use perl/my-sql for web work. But, it seems like a _lot_
of work to...
|
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 interested to here any thoughts on which way we should go. We
currently have an IT Help Desk application that we need to duplicate in new
technology (example at http:jackaroo.net.au) which needs to be able to have
many users eg Corp wide and to handle...
|
by: dad |
last post by:
REQ: any utilities for designing front-ends for databases
|
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 allowed me to edit easily all my database.
Are there any valid alternative?
I have tried mysql administrator but it seems to me not so easy to use
as the old mysql front.
regards
|
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 MySql-Front Gmbh to check a data property, and it won't open up into a window, but failing at that, sits down on the TaskBar and can't get up.
Is that an Operating System goof up, as I suspect, or something gone wrong with MySql-Front Gmbh (hereafter...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |