I realize this has been probably covered. But I want to pull data from one
of several mysql tables, depending on what choice is made from a select
box. Is javascript a good choice?
I have poked around on the internet looking for answers as how to do this
and I have found the following connect statement:
database.connect("INFORMIX", "blue", "MANAGER", "invantory)
Unfortunatly, the documantation I have found indicates that MySQL isn't a
choice for database type(You've got to be kidding.) So, it now appears
that you must use a odbc driver to make the connection. This doesn't seem
like a good method for a common browser(w/o the correct odbc driver) to
look at my page.
I have also seen that some web designers have used php to pull the data
from mysql and then hand it off to javascript(I don't understand how this
works.) It seems probable though that inorder for my page to work using
this option, I would have to pull all of my tables before displaying the
web page.
I would like to see a frank discussion of the pros and cons of each
method, or a sugestion of a better method.
Thx in advance, Terry 3 1568
"Terry A. Haimann" <te***@yngstr.oldboy.com> schreef in bericht
news:pa****************************@yngstr.oldboy. com... I realize this has been probably covered. But I want to pull data from one of several mysql tables, depending on what choice is made from a select box. Is javascript a good choice?
Since you probably want to apply it client-side, the answer is no.
Server-side, you could an ASP/ODBC solution or, better yet, a language like
PHP.
When you are formiliair with the JavaScript language syntax, PHP won't be
hard to learn and it is almost designed to be used with MySQL.
See http://www.php.net/ and http://www.php.net/mysql for more info.
JW
The problem I see with php is, I want to take the data from the select and
put it in a combobox(drop down box.) I don't think php can do that by
itself, so at best it is going to be a combination between javascript and
php. And as I mentioned earlier, I am not sure how you move data from php
to javascript.
Terry
On Tue, 02 Sep 2003 00:24:26 +0200, Janwillem Borleffs wrote: "Terry A. Haimann" <te***@yngstr.oldboy.com> schreef in bericht news:pa****************************@yngstr.oldboy. com... I realize this has been probably covered. But I want to pull data from one of several mysql tables, depending on what choice is made from a select box. Is javascript a good choice?
Since you probably want to apply it client-side, the answer is no.
Server-side, you could an ASP/ODBC solution or, better yet, a language like PHP.
When you are formiliair with the JavaScript language syntax, PHP won't be hard to learn and it is almost designed to be used with MySQL.
See http://www.php.net/ and http://www.php.net/mysql for more info.
JW
On Mon, 01 Sep 2003 21:05:45 GMT, "Terry A. Haimann"
<te***@yngstr.oldboy.com> wrote: I realize this has been probably covered.
I would like to see a frank discussion of the pros and cons of each method, or a sugestion of a better method.
I suggest you do at least a little of your own research, rather than
expecting others to do it for you. If ou think it's "probably been
covered" read google groups to see what that coverage entailed.
Jim.
--
comp.lang.javascript FAQ - http://jibbering.com/faq/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: francescomoi |
last post by:
Hi.
I'm trying to build 'MySQL-python-1.2.0' on my Linux FC2:
----------------------------------
# export PATH=$PATH:/usr/local/mysql/bin/
# export mysqlclient=mysqlclient_r
# python setup.py...
|
by: mikey |
last post by:
Hi all,
I'm having great problems trying to install the latest MySQl RPM
package onto my Red Hat Linux OS.
There is already MySQL v 3.0 pre-installed with the RH Linux
distribution disk but I...
|
by: Yun Guan |
last post by:
Hello mysql gurus,
I am trying to run perl on mysql database on Red Hat box. I want to install
DBI and DBD:mysql using CPAN:
perl -MCPAN -e shell
cpan>install DBI
The above succeeded, but...
|
by: Mike Chirico |
last post by:
Interesting Things to Know about MySQL
Mike Chirico (mchirico@users.sourceforge.net)
Copyright (GPU Free Documentation License) 2004
Last Updated: Mon Jun 7 10:37:28 EDT 2004
The latest...
|
by: Saqib Ali |
last post by:
I installed mySQL and have it running.... but I think I made a
mistake somewhere along the line...... I believe I did follow the
instructions that were provided with the distribution at:...
|
by: Alex Hunsley |
last post by:
I am trying to install the DBD::mysql perl module. However, it claims I
need mysql.h:
cpan> install DBD::mysql
CPAN: Storable loaded ok
Going to read /home/alex/.cpan/Metadata
Database was...
|
by: ./Rob & |
last post by:
Hi gang:
I'm experiencing a problem with MySQL -- I updated MySQL from version 4.1.0
to 4.1.10 and now when I login as root it doesn't show all the databases I
should have access to, nor it...
|
by: trihanhcie |
last post by:
I m currently working on a Unix server with a fedora 3 as an os
My current version of mysql is 3.23.58. I'd like to upgrade the version
to 5.0.18.
After downloading from MYSQL.COM the package on...
|
by: manish deshpande |
last post by:
Hi,
When i'm installing MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm by the following command:
rpm -i MySQL-server-standard-5.0.24a-0.rhel3.i386.rpm the following error is being shown:
...
|
by: menzies |
last post by:
Hi, I"m new to this forum, but I have been trying all day to install DBD::mysql onto my Intel MacBook. I've read lots of forums pages and none have gotten me to a successful 'make test' or a...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
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...
| |