earth tech

Wacka-wacka DOOOO!

Today's brain teaser is AJAX + PHP + Javascript + XML + MySQL ... and there may be some others I've left out CSS, XHTML, stuff like that.

Nevertheless, we will prevail. Links to follow.^

• PHP Example - responseXML
• JavaScript and HTML DOM Reference
• XML DOM
• XML Manipulation (from the PHP Manual)

Nothing specific to the MySQL side of this, for now.

Labels: ajax, javascript, mysql, php, w3c, xml

posted by pd wilson   #   03:48

The following is text copied from the mysql(3) manual page:

You can execute SQL statements in a script file (batch file) like this:

   shell> mysql db_name < script.sql > output.tab

The MySQL version 5.x and greater also provide a mysqldump which has an XML output switch. This causes mysqldump to output XML on stdout such that the mysqldump output can be used directly in an XML document output stream.

Labels: bash, mysql, script

posted by pd wilson   #   08:08