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.
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
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
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
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
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
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,
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]
* [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
- 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
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
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
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
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 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
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
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
: 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
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
: 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
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
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
: 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
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 grou
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
--
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
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
];
[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
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...
]; [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
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:
L 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 -
ED];
[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, 20
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
ary 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 see
]; [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
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
---
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
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
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
"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
41 matches
Mail list logo