xml to mySQL
Hi All, I wanted to know the possible ways in which an xml document can be stored in the mysql database. So the keys in an xml are the columns in the database and the key values in xml go as the values for columns. I dont want to use java if thats possible. Thanks in advance, Adhiraj Joshi.
Re: xml to mySQL
Hi Adhiraj, I am going to assume that the keys and values are not static. If they are, then this is just a matter of parsing XML into key, value combinations. A simple, but often less than ideal way of solving a problem like this is to use several tables: # The entries table is the equivilant of something like the prymary key... CREATE TABLE `entries` ( `entry_id` int(10) NOT NULL auto_increment, `entry_name` varchar(255) NOT NULL default '', PRIMARY KEY (`entry_id`), KEY `entry_name` (`entry_name`) ) TYPE=MyISAM AUTO_INCREMENT=2 ; # The keys table holds collumn names... CREATE TABLE `keys` ( `key_id` int(10) NOT NULL auto_increment, `key` varchar(255) default NULL, PRIMARY KEY (`key_id`), KEY `key` (`key`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; # The values table would hold the data... CREATE TABLE `values` ( `value_id` int(10) NOT NULL auto_increment, `value` varchar(255) default NULL, `key_id` int(10) default NULL, `entry_id` int(10) default NULL, PRIMARY KEY (`value_id`), KEY `value` (`value`),KEY `key_id` (`key_id`),KEY `entry_id` (`entry_id`) ) TYPE=MyISAM AUTO_INCREMENT=3 ; #Add in some data INSERT INTO `entries` (`entry_id`, `entry_name`) VALUES (1, 'Rob'); INSERT INTO `keys` (`key_id`, `key`) VALUES (1, 'age'), (2, 'nationality'); INSERT INTO `values` (`value_id`, `value`, `key_id`, `entry_id`) VALUES (1, '23', 1, 1), (2, 'American', 2, 1); # And now you can pull out information: SELECT `entry_name` ,`key`,`value` FROM `entries` INNER JOIN `values` USING(`entry_id`) INNER JOIN `keys` USING(`key_id`) WHERE `entry_name` = 'Rob' So, whenever you insert xml into the db you will first insert a single record into the entries table, and store the last insert id. You would then go through each key/value combination, first selecting ( and if no results are found, inserting) the relevant key from the keys table, and then inserting the key_id, entry_id and value into the values table. On 9/26/07, Adhiraj Joshi [EMAIL PROTECTED] wrote: Hi All, I wanted to know the possible ways in which an xml document can be stored in the mysql database. So the keys in an xml are the columns in the database and the key values in xml go as the values for columns. I dont want to use java if thats possible. Thanks in advance, Adhiraj Joshi. -- Rob Wultsch (480)223-2566 [EMAIL PROTECTED] (email/google im) wultsch (aim) [EMAIL PROTECTED] (msn) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Export OpenOffice XML to Mysql
Alvaro Cobo [EMAIL PROTECTED] writes: Hi guys: I have the following problem: In the organization I work for, we have several standard formats which we have to write for each project we manage (for example: reports). These are MS-Word documents, for which I have created a database and several forms to store this information. The problem is that it is very time consuming to insert manually each one of this documents. I think the solution is to create a OpenOffice Template for the document, with specific tags, to recover and export the file contents.xml (which is part of the *.sxw zip file) 'automagically' to the MySql database inserting each part of the XML to their specific field in the database. So the users only have to write the document, upload the file and the server does the job. The questions are: a) Is it possible to do that? Somebody has tried something like that?. b) What do you think about the idea? Could it be too complicated? Am I in the wrong path?. I will appreciate any clue or comment about these questions. I would go from the other direction. I would use OpenOffice.org to create a data entry template, where the user would enter the field information that goes into the database, then I would have an OpenOffice.org macro/template that would create the document out of the database fields. It seems conceptually easier to build the document from the data than to create the data from out of the document. Dave in Largo, FL -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Export OpenOffice XML to Mysql
Hi guys: I have the following problem: In the organization I work for, we have several standard formats which we have to write for each project we manage (for example: reports). These are MS-Word documents, for which I have created a database and several forms to store this information. The problem is that it is very time consuming to insert manually each one of this documents. I think the solution is to create a OpenOffice Template for the document, with specific tags, to recover and export the file contents.xml (which is part of the *.sxw zip file) 'automagically' to the MySql database inserting each part of the XML to their specific field in the database. So the users only have to write the document, upload the file and the server does the job. The questions are: a) Is it possible to do that? Somebody has tried something like that?. b) What do you think about the idea? Could it be too complicated? Am I in the wrong path?. I will appreciate any clue or comment about these questions. Thanks a lot and best regards. Alvaro.
Converting XML to MySQL DB
Hello, I'm just looking at implementeing the DMOZ open directory into a mysql DB, and having had a quick look notice its in XML format. Does anyone have any insight into go about this - is it even a good idea?(I want to use mysql fulltext search on the data). I'm sure there must be some resources on the net I could have a look at. Cheers, Lee This message was sent using IMP, the Internet Messaging Program. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
XML to Mysql
This may just sound stupid but I am going to ask anyway. We run a search engine and we bring in 3+ XML feeds from other search engines Via perl and PHP. So we can end up with 300 results listed for EACH SEARCH. They are only valid for that ONE SEARCH but we need to track every click for proper payment. As you may imagine this has a huge overhead to our mysql. We are growing and about to rewrite our search engine and would like ideas on how to make the best use of these temporary storage tables. Some of the tracking urls can be 440+ characters long so we can't use varchar. Also If you have 20 searches per minute coming in and 30 seconds between the clicks the table can get quick big quickly. So jumping directly to right stored link immediately if not quicker is a must. Just spitballing for the plan ahead. Wanting to make sure we use all the available speed assests at our disposal. ThanksDonny LairsonPresidenthttp://www.gunmuse.com469 228 2183
XML to MySQL
Are there any open source (or other) to load an XML document directly to a MySQL table or set of tables? Any recommendations would be greatly appreciated. Best Regards, Boyd E. Hemphill [EMAIL PROTECTED] Triand, Inc. Life is not a journey to the grave arriving safely in a well preserved body, but rather a skid in broadside, thoroughly used, totally worn, and loudly proclaiming: WOW! What a ride! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to import XML into MySQL?
Sorry. I missed this discussion previously. Now I need the answer. Figures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
* [EMAIL PROTECTED] geez mysql is an open source product you cannot expect so much too soon over a very expensive commercial product which has been out for years , for xml i usually generate it on the fly when i am extracting the data using the field names as the xml tag nodes. Converting a relational dbms into an XML frontend is like trying to change a Chevrolet into a Beetle. (The problem is of course that too many managers orders too much xml these days.) -- Jon Haugsand, [EMAIL PROTECTED] http://www.norges-bank.no -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
- Original Message - From: Jon Haugsand [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 23, 2003 2:57 AM Subject: Re: XML in MySQL * [EMAIL PROTECTED] geez mysql is an open source product you cannot expect so much too soon over a very expensive commercial product which has been out for years , for xml i usually generate it on the fly when i am extracting the data using the field names as the xml tag nodes. Converting a relational dbms into an XML frontend is like trying to change a Chevrolet into a Beetle. (The problem is of course that too many managers orders too much xml these days.) Hear, hear! A good place to look if you're interested in the views of relational DB purists (and what they think of XML, etc) is http://www.dbdebunk.com/ -S -- Jon Haugsand, [EMAIL PROTECTED] http://www.norges-bank.no -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
Jeremy Zawodny wrote: SOAP is one thing. But what about storing XML documents in the DB (with validation on the way in) and querying them using XPath? Oracle does that. MySQL does not. And off-topic from the original question but to repeat myself from before, using XML and MySQL together isn't that difficult in most situations you may encounter. A little wrapping to be sure, but validating parsers are easy to get your hands on and designing an expat-based parser that knows your schema (XML DB) for translation isn't a big chore for most data types I've come across. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
XML in MySQL
Hello, What is the level of support for XML in MySQL. Is there any kit similar to the Oracle XML Developper Kit or the XML features in SQL Server 2000? -- Joel Amoussou XML Instructor IBM XML Certification Practice Test http://www.xmlmentor.net/xmlexamsim.htm - Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!
Re: XML in MySQL
On Sun, Jun 22, 2003 at 01:30:15PM -0700, Joel Amoussou wrote: Hello, What is the level of support for XML in MySQL. Is there any kit similar to the Oracle XML Developper Kit or the XML features in SQL Server 2000? No. MySQL doesn't nativel deal with XML. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 619,490,390 queries (366/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
but see SOAP and WSDL support add ons which are freely available and probably what you want anyway -C - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Joel Amoussou [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, June 22, 2003 4:56 PM Subject: Re: XML in MySQL On Sun, Jun 22, 2003 at 01:30:15PM -0700, Joel Amoussou wrote: Hello, What is the level of support for XML in MySQL. Is there any kit similar to the Oracle XML Developper Kit or the XML features in SQL Server 2000? No. MySQL doesn't nativel deal with XML. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 619,490,390 queries (366/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
On Sun, Jun 29, 2003 at 07:53:00PM -0400, chad pratt wrote: but see SOAP and WSDL support add ons which are freely available and probably what you want anyway I don't buy that. If you've really looked at what Oracle is offering, it's hard to argue that the MySQL addons really solve the same problems. Have you seen otherwise? Maybe the addons are quite a bit better than last time I looked? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 619,598,219 queries (366/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
PHP-SOAP, PEAR SOAP, NuSOAP need more SOAP? -C - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: chad pratt [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, June 22, 2003 5:04 PM Subject: Re: XML in MySQL On Sun, Jun 29, 2003 at 07:53:00PM -0400, chad pratt wrote: but see SOAP and WSDL support add ons which are freely available and probably what you want anyway I don't buy that. If you've really looked at what Oracle is offering, it's hard to argue that the MySQL addons really solve the same problems. Have you seen otherwise? Maybe the addons are quite a bit better than last time I looked? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 619,598,219 queries (366/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
On Sun, Jun 29, 2003 at 08:18:24PM -0400, chad pratt wrote: PHP-SOAP, PEAR SOAP, NuSOAP need more SOAP? SOAP is one thing. But what about storing XML documents in the DB (with validation on the way in) and querying them using XPath? Oracle does that. MySQL does not. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 620,269,579 queries (365/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: XML in MySQL
geez mysql is an open source product you cannot expect so much too soon over a very expensive commercial product which has been out for years , for xml i usually generate it on the fly when i am extracting the data using the field names as the xml tag nodes. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 7:55 AM To: chad pratt Cc: [EMAIL PROTECTED] Subject: Re: XML in MySQL On Sun, Jun 29, 2003 at 08:18:24PM -0400, chad pratt wrote: PHP-SOAP, PEAR SOAP, NuSOAP need more SOAP? SOAP is one thing. But what about storing XML documents in the DB (with validation on the way in) and querying them using XPath? Oracle does that. MySQL does not. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 620,269,579 queries (365/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
On Mon, Jun 23, 2003 at 07:58:51AM +1000, electroteque wrote: geez mysql is an open source product you cannot expect so much too soon over a very expensive commercial product which has been out for years , for xml i usually generate it on the fly when i am extracting the data using the field names as the xml tag nodes. This has nothing to do with my expectations and everything to do with answering Joel Amoussou's question(s). As a long-time MySQL and open source software user, I'm well aware of the development differences between OS and commercial software. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 620,460,949 queries (365/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
well you probably want to import and export XML into tables.. is this what you want to do? IF you want to process it qua XML as opposed to TEXT or BLOB then it 's not that hard, right? You have data in XML that needs to be put in columns and visa-versaI am not *certain* what you're looking for...here's a resource for you- http://www.xmlphp.com/ I am sure there are probably others books and packages out there.. that';s why God gave you Google.. -C - Original Message - From: chad pratt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 29, 2003 7:53 PM Subject: Re: XML in MySQL but see SOAP and WSDL support add ons which are freely available and probably what you want anyway -C - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Joel Amoussou [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, June 22, 2003 4:56 PM Subject: Re: XML in MySQL On Sun, Jun 22, 2003 at 01:30:15PM -0700, Joel Amoussou wrote: Hello, What is the level of support for XML in MySQL. Is there any kit similar to the Oracle XML Developper Kit or the XML features in SQL Server 2000? No. MySQL doesn't nativel deal with XML. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 619,490,390 queries (366/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Looking for Doc on using XML with Mysql, Xml-Aware.
Can anyone point me in the direction of using XML with MySql, any doc will do. Looking for info on the concept of Mysql being xml-aware. Im new with using xml in a DB Environment. Hopefully Im asking the right questions here. Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Looking for Doc on using XML with Mysql, Xml-Aware.
At 17:14 -0700 10/15/02, David Kramer wrote: Can anyone point me in the direction of using XML with MySql, any doc will do. Looking for info on the concept of Mysql being xml-aware. Im new with using xml in a DB Environment. Hopefully Im asking the right questions here. MySQL *isn't* XML-aware. mysql and mysqldump have --xml options for generating XML-format output, that's about it. Everything else you do yourself. A short article on MySQL and XML can be found here (be warned, I wrote it): http://www.kitebird.com/articles.php Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [php_mysql] Creative solution with XML,PHP,MYSQL
I hate to say it, but the only way I can see of doing this offhand is with ecmascript dhtml or does that Dynamic Data Binding (only works with ie5, or 5.5?) do this sort of thing? Either way, you're looking at unbounded fun catering for different browsers. -Original Message- From: Siim Einfeldt aka Itpunk [mailto:[EMAIL PROTECTED]] Sent: 17 February 2001 14:25 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [php_mysql] Creative solution with XML,PHP,MYSQL Hi everybody, I want to implement ordering something on a website without refreshing the page. Lets say i have four columns in the html table - name,age,skill and phone. All these are links - under these are the information, eg: Name Age Skill Phone Siim 23 php 051... Tony 18 html 132... Now, when i click on the name, it should order the listings by name, if I click on the age, I get the listing ordered by age and etc,etc. Generally it is easy to do it, but how to do it without refreshing the page every time I want to order by something else? It should be possible with XML; I get the data from mysql database with php, I write it into an array and ... now how could I make it function the way I just described? Could someone point me some already written code or explain me in detail how to do it? Thank you, Siim Einfeldt PS: Sorry about sending this message to so many lists, but I haven`t seen this kind of code anywhere, but at the same time I know it is possible. Yahoo! Groups Sponsor -~-~ eGroups is now Yahoo! Groups Click here for more details http://click.egroups.com/1/11231/1/_/19011/_/982419916/ -_- the PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database possibilities through group learning. http://www.1sdesign.com/web/books.shtml You can get books here. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] Creative solution with XML,PHP,MYSQL
-Original Message- From: Siim Einfeldt aka Itpunk [mailto:[EMAIL PROTECTED]] Sent: 17 February 2001 14:25 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] Creative solution with XML,PHP,MYSQL Siim, Please dont cross post like this, I just got 4 copies of your email in my inbox which I dont really want, 1 is enough. Be sensible and send it to the correct mailing list rather than "Spaming" 7 groups. James - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [php_mysql] Creative solution with XML,PHP,MYSQL
Tim Ward schrieb: the complication in your case is that some of the js (building the arrays and the table) needs to be built by the php. I've never tried this but it should work if you just echo it as you would html. yes - php can write out an external .js what is loaded by JavaScript -- IrmundThum +49 179 6998564 +49 6374 992541 Kryptographische Unterschrift mit S/MIME
Re: [PHP] RE: [php_mysql] Creative solution with XML,PHP,MYSQL
Check out webfx.eae.net for a sample on how to do this. It does require IE4+ or Mozilla. Chris On Mon, 19 Feb 2001, Tim Ward wrote: Date: Mon, 19 Feb 2001 13:47:00 - To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] From: Tim Ward [EMAIL PROTECTED] Subject: [PHP] RE: [php_mysql] Creative solution with XML,PHP,MYSQL you can do it with javascript. assign all of the cell contents to a javascript 2-d array of strings (mytext[x][y]). create the table with a div in each cell. create a 2-d array of object pointers pointing to each div. you can then change the contents of each div at will (for example when a button is pressed). i.e. divobject[x][y].innerHTML = mytext[x][new_y]. I use this technique a lot for game writing in js. the complication in your case is that some of the js (building the arrays and the table) needs to be built by the php. I've never tried this but it should work if you just echo it as you would html. Tim Ward Senior Systems Engineer Please refer to the following disclaimer in respect of this message: http://www.stivesdirect.com/e-mail-disclaimer.html -Original Message- From: Tom Knight [mailto:[EMAIL PROTECTED]] Sent: 19 February 2001 08:53 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [php_mysql] Creative solution with XML,PHP,MYSQL I hate to say it, but the only way I can see of doing this offhand is with ecmascript dhtml or does that Dynamic Data Binding (only works with ie5, or 5.5?) do this sort of thing? Either way, you're looking at unbounded fun catering for different browsers. -Original Message- From: Siim Einfeldt aka Itpunk [mailto:[EMAIL PROTECTED]] Sent: 17 February 2001 14:25 To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [php_mysql] Creative solution with XML,PHP,MYSQL Hi everybody, I want to implement ordering something on a website without refreshing the page. Lets say i have four columns in the html table - name,age,skill and phone. All these are links - under these are the information, eg: Name Age Skill Phone Siim 23 php 051... Tony 18 html 132... Now, when i click on the name, it should order the listings by name, if I click on the age, I get the listing ordered by age and etc,etc. Generally it is easy to do it, but how to do it without refreshing the page every time I want to order by something else? It should be possible with XML; I get the data from mysql database with php, I write it into an array and ... now how could I make it function the way I just described? Could someone point me some already written code or explain me in detail how to do it? Thank you, Siim Einfeldt PS: Sorry about sending this message to so many lists, but I haven`t seen this kind of code anywhere, but at the same time I know it is possible. Yahoo! Groups Sponsor -~-~ eGroups is now Yahoo! Groups Click here for more details http://click.egroups.com/1/11231/1/_/19011/_/982419916/ -- ---_- the PHP_mySQL group is dedicated to learn more about the PHP_mySQL web database possibilities through group learning. http://www.1sdesign.com/web/books.shtml You can get books here. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creative solution with XML,PHP,MYSQL
At 05:19 18-02-2001 +0100, Irmund Thum wrote: trivial Javascript task and the noscript tag can have a short explanation to turn on JavaScript for sorting the columns. So somebody with Javascript disabled visiting the site sees this information and can decide to turn Javascript on Yes, that might work. Though, at least with Netscape, he will have to reload the page. Then again, if he uses Lynx, the most popular Unix browser, he simply cannot use JavaScript at all. So I would still use the noscript tag to create a version of the page that uses HTML forms and uses CGI for all the sorting. Adam --- Whiz Kid Technomagic - brand name computers for less. See http://www.whizkidtech.net/pcwarehouse/ for details. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: Creative solution with XML,PHP,MYSQL
You could use frames, then you wouldn't have to refresh ALL of the page - Original Message - From: Siim Einfeldt aka Itpunk [EMAIL PROTECTED] To: Brian V Bonini [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 10:07 AM Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL Maybe Flash is an option? Well, I know I could probably do it some way in flash (if I had experiences with it), but this is just a bit out 'of the box'. But still, thanks for offering. Siim -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Creative solution with XML,PHP,MYSQL
Hi everybody, I want to implement ordering something on a website without refreshing the page. Lets say i have four columns in the html table - name,age,skill and phone. All these are links - under these are the information, eg: Name Age Skill Phone Siim 23 php 051... Tony 18 html 132... Now, when i click on the name, it should order the listings by name, if I click on the age, I get the listing ordered by age and etc,etc. Generally it is easy to do it, but how to do it without refreshing the page every time I want to order by something else? It should be possible with XML; I get the data from mysql database with php, I write it into an array and ... now how could I make it function the way I just described? Could someone point me some already written code or explain me in detail how to do it? Thank you, Siim Einfeldt PS: Sorry about sending this message to so many lists, but I haven`t seen this kind of code anywhere, but at the same time I know it is possible. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] Re: Creative solution with XML,PHP,MYSQL
Maybe Flash is an option? -Original Message- From: Peter Skipworth [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 9:29 AM To: Siim Einfeldt aka Itpunk Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] Re: Creative solution with XML,PHP,MYSQL I'm afraid XML isn't going to help you - you need to investigate DHTML options, although you'll be lucky to find a solution which is compatible across both Netscape and IE. regards, P On Sat, 17 Feb 2001, Siim Einfeldt aka Itpunk wrote: Hi everybody, I want to implement ordering something on a website without refreshing the page. Lets say i have four columns in the html table - name,age,skill and phone. All these are links - under these are the information, eg: Name Age Skill Phone Siim 23 php 051... Tony 18 html 132... Now, when i click on the name, it should order the listings by name, if I click on the age, I get the listing ordered by age and etc,etc. Generally it is easy to do it, but how to do it without refreshing the page every time I want to order by something else? It should be possible with XML; I get the data from mysql database with php, I write it into an array and ... now how could I make it function the way I just described? Could someone point me some already written code or explain me in detail how to do it? Thank you, Siim Einfeldt PS: Sorry about sending this message to so many lists, but I haven`t seen this kind of code anywhere, but at the same time I know it is possible. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creative solution with XML,PHP,MYSQL
XML is all about data definition - not being able to dynamically change the display of the data on a webpage. Browsers don't even understand XML natively - you need to write it out as HTML before you can display it in IE or Netscape. P On Sat, 17 Feb 2001, Siim Einfeldt aka Itpunk wrote: But I`m pretty sure it is possible with XML, in theory at least, I get the data from the database, I write it into array, put into xml and then deal with it - that`s how I imagine it. DHTML doesn`t seem the best way to do it...but then maybe it`s just me. cheers Siim Einfeldt I'm afraid XML isn't going to help you - you need to investigate DHTML options, although you'll be lucky to find a solution which is compatible across both Netscape and IE. regards, P On Sat, 17 Feb 2001, Siim Einfeldt aka Itpunk wrote: Hi everybody, I want to implement ordering something on a website without refreshing the page. Lets say i have four columns in the html table - name,age,skill and phone. All these are links - under these are the information, eg: Name Age Skill Phone Siim 23 php 051... Tony 18 html 132... Now, when i click on the name, it should order the listings by name, if I click on the age, I get the listing ordered by age and etc,etc. Generally it is easy to do it, but how to do it without refreshing the page every time I want to order by something else? It should be possible with XML; I get the data from mysql database with php, I write it into an array and ... now how could I make it function the way I just described? Could someone point me some already written code or explain me in detail how to do it? Thank you, Siim Einfeldt PS: Sorry about sending this message to so many lists, but I haven`t seen this kind of code anywhere, but at the same time I know it is possible. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creative solution with XML,PHP,MYSQL
Relax, XML has N.O.T.H.I.N.G. to do with what you want to do. You want dynamically update (rebuild) HTML page, well, the only way to do it currently in more or less compatible way is to use javascript+DHTML. And the result will SUCK, i know, i've done it. So, go the way the elders did. Refresh the page and pass the script a parameter which says how to sort the data. - Original Message - From: "Siim Einfeldt aka Itpunk" [EMAIL PROTECTED] To: "Peter Skipworth" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 5:38 PM Subject: Re: Creative solution with XML,PHP,MYSQL But I`m pretty sure it is possible with XML, in theory at least, I get the data from the database, I write it into array, put into xml and then deal with it - that`s how I imagine it. DHTML doesn`t seem the best way to do it...but then maybe it`s just me. cheers Siim Einfeldt I'm afraid XML isn't going to help you - you need to investigate DHTML options, although you'll be lucky to find a solution which is compatible across both Netscape and IE. regards, P On Sat, 17 Feb 2001, Siim Einfeldt aka Itpunk wrote: Hi everybody, I want to implement ordering something on a website without refreshing the page. Lets say i have four columns in the html table - name,age,skill and phone. All these are links - under these are the information, eg: Name Age Skill Phone Siim 23 php 051... Tony 18 html 132... Now, when i click on the name, it should order the listings by name, if I click on the age, I get the listing ordered by age and etc,etc. Generally it is easy to do it, but how to do it without refreshing the page every time I want to order by something else? It should be possible with XML; I get the data from mysql database with php, I write it into an array and ... now how could I make it function the way I just described? Could someone point me some already written code or explain me in detail how to do it? Thank you, Siim Einfeldt PS: Sorry about sending this message to so many lists, but I haven`t seen this kind of code anywhere, but at the same time I know it is possible. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: Creative solution with XML,PHP,MYSQL
Aha, java is even better :) - Original Message - From: "Brian V Bonini" [EMAIL PROTECTED] To: "Peter Skipworth" [EMAIL PROTECTED]; "Siim Einfeldt aka Itpunk" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 5:50 PM Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL Maybe Flash is an option? -Original Message- From: Peter Skipworth [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 9:29 AM To: Siim Einfeldt aka Itpunk Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [PHP] Re: Creative solution with XML,PHP,MYSQL I'm afraid XML isn't going to help you - you need to investigate DHTML options, although you'll be lucky to find a solution which is compatible across both Netscape and IE. regards, P On Sat, 17 Feb 2001, Siim Einfeldt aka Itpunk wrote: Hi everybody, I want to implement ordering something on a website without refreshing the page. Lets say i have four columns in the html table - name,age,skill and phone. All these are links - under these are the information, eg: Name Age Skill Phone Siim 23 php 051... Tony 18 html 132... Now, when i click on the name, it should order the listings by name, if I click on the age, I get the listing ordered by age and etc,etc. Generally it is easy to do it, but how to do it without refreshing the page every time I want to order by something else? It should be possible with XML; I get the data from mysql database with php, I write it into an array and ... now how could I make it function the way I just described? Could someone point me some already written code or explain me in detail how to do it? Thank you, Siim Einfeldt PS: Sorry about sending this message to so many lists, but I haven`t seen this kind of code anywhere, but at the same time I know it is possible. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] Re: Creative solution with XML,PHP,MYSQL
can yopu link a database to flash? van -Original Message- From: Siim Einfeldt aka Itpunk [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 4:07 PM To: Brian V Bonini Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL Maybe Flash is an option? Well, I know I could probably do it some way in flash (if I had experiences with it), but this is just a bit out 'of the box'. But still, thanks for offering. Siim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creative solution with XML,PHP,MYSQL
It is even possible to do just with JavaScript, by being creative. However, refreshing the page seems the logical option. Is there any special reason for not doing it? I am almost always in favor of keeping things on the server side. Jose Carlos Relax, XML has N.O.T.H.I.N.G. to do with what you want to do. You want dynamically update (rebuild) HTML page, well, the only way to do it currently in more or less compatible way is to use javascript+DHTML. And the result will SUCK, i know, i've done it. So, go the way the elders did. Refresh the page and pass the script a parameter which says how to sort the data. - Original Message - From: "Siim Einfeldt aka Itpunk" [EMAIL PROTECTED] To: "Peter Skipworth" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 5:38 PM Subject: Re: Creative solution with XML,PHP,MYSQL But I`m pretty sure it is possible with XML, in theory at least, I get the data from the database, I write it into array, put into xml and then deal with it - that`s how I imagine it. DHTML doesn`t seem the best way to do it...but then maybe it`s just me. cheers Siim Einfeldt I'm afraid XML isn't going to help you - you need to investigate DHTML options, although you'll be lucky to find a solution which is compatible across both Netscape and IE. regards, P On Sat, 17 Feb 2001, Siim Einfeldt aka Itpunk wrote: Hi everybody, I want to implement ordering something on a website without refreshing the page. Lets say i have four columns in the html table - name,age,skill and phone. All these are links - under these are the information, eg: Name Age Skill Phone Siim 23 php 051... Tony 18 html 132... Now, when i click on the name, it should order the listings by name, if I click on the age, I get the listing ordered by age and etc,etc. Generally it is easy to do it, but how to do it without refreshing the page every time I want to order by something else? It should be possible with XML; I get the data from mysql database with php, I write it into an array and ... now how could I make it function the way I just described? Could someone point me some already written code or explain me in detail how to do it? Thank you, Siim Einfeldt PS: Sorry about sending this message to so many lists, but I haven`t seen this kind of code anywhere, but at the same time I know it is possible. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: [PHP] Re: Creative solution with XML,PHP,MYSQL
yes you can. And its cool too :-) On Sat, 17 Feb 2001, Wernher Korff wrote: can yopu link a database to flash? van -Original Message- From: Siim Einfeldt aka Itpunk [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 4:07 PM To: Brian V Bonini Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL Maybe Flash is an option? Well, I know I could probably do it some way in flash (if I had experiences with it), but this is just a bit out 'of the box'. But still, thanks for offering. Siim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: Creative solution with XML,PHP,MYSQL
I said Java. Java i said. Java said I. - Original Message - From: "Wernher Korff" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 6:53 PM Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL can yopu link a database to flash? van -Original Message- From: Siim Einfeldt aka Itpunk [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 4:07 PM To: Brian V Bonini Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL Maybe Flash is an option? Well, I know I could probably do it some way in flash (if I had experiences with it), but this is just a bit out 'of the box'. But still, thanks for offering. Siim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: Creative solution with XML,PHP,MYSQL
On Sat, 17 Feb 2001, Artem Koutchine wrote: Aha, java is even better :) Absolutely. I can't think of anything I'd rather do than sit and wait for the browser to load the JVM. -- /"\ \ /ASCII RIBBON CAMPAIGN X AGAINST HTML EMAIL / \AND POSTINGS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP] Re: Creative solution with XML,PHP,MYSQL
You can use PHP with Flash and then use PHP to access MySQL. BR, Fábio Ottolini - Original Message - From: "Wernher Korff" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 17, 2001 12:53 PM Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL can yopu link a database to flash? van -Original Message- From: Siim Einfeldt aka Itpunk [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 17, 2001 4:07 PM To: Brian V Bonini Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP] Re: Creative solution with XML,PHP,MYSQL Maybe Flash is an option? Well, I know I could probably do it some way in flash (if I had experiences with it), but this is just a bit out 'of the box'. But still, thanks for offering. Siim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creative solution with XML,PHP,MYSQL
At 16:25 17-02-2001 +0200, Siim Einfeldt aka Itpunk wrote: Hi everybody, I want to implement ordering something on a website without refreshing the page. That is generally done using JavaScript. But be advised that not everyone has JavaScript turned on by default: I often have it turned off because so many sites abuse it for annoying popup windows. So, if you go with JavaScript, make sure you also have a noscript version which uses the traditional way of loading a new page. Of course, JavaScript runs inside user's browser, so it cannot read your database. You will need to import all relevant information from your database to the JavaScript before you create the page. And you can only save the results back into your database after the user submits the form back to you. Adam --- Whiz Kid Technomagic - brand name computers for less. See http://www.whizkidtech.net/pcwarehouse/ for details. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Creative solution with XML,PHP,MYSQL
"G. Adam Stanislav" schrieb: At 16:25 17-02-2001 +0200, Siim Einfeldt aka Itpunk wrote: Hi everybody, I want to implement ordering something on a website without refreshing the page. That is generally done using JavaScript. But be advised that not everyone has JavaScript turned on by default: I often have it turned off because so many sites abuse it for annoying popup windows. So, if you go with JavaScript, make sure you also have a noscript version which uses the traditional way of loading a new page. Of course, JavaScript runs inside user's browser, so it cannot read your database. You will need to import all relevant information from your database to the JavaScript before you create the page. And you can only save the results back into your database after the user submits the form back to you. Adam trivial Javascript task and the noscript tag can have a short explanation to turn on JavaScript for sorting the columns. So somebody with Javascript disabled visiting the site sees this information and can decide to turn Javascript on (since there are probably no annying popup windows - I hate them, too :-) -- IrmundThum Kryptographische Unterschrift mit S/MIME