John Souris Wrote:
-------------------------------------------------------
> I just downloaded LibMyXQL from forge.mysql.com
> after reading a post on this forum. I hope to
> produce xml results from mysql quiries within a
> php file.
>
> Q1. Can someone please give me some advice on
> installing this on my own pc which has iis and
> mysql installed. It has a makefile but i'm not
> sure what to do with it.
On Linux, it was pretty easy - just the usual make - make install, then run the installdb.sql script using the mysql client. The only problem I had was that the location for the MySQL headers is hard-coded, so if you installed MySQL from source, you'll have to copy them over to /usr/include or modify the makefile first.
I'm not familiar with building apps on Windows, so someone else will have to provide advice about that.
> Q2. Are there webhosts that support libmyxql use?
I doubt it. I also doubt that any commercial webhost is going to allow users to install shared libraries this since requires system root access.
It would be really cool if the author reimplemented these as stored functions. Then they'd work on any platform that MySQL 5.0 or newer runs on without compilation, and a user with the CREATE ROUTINE privilege could install them without the assistance of the system administrator.
Jon Stephens
MySQL Documentation Team @ Oracle
MySQL Dev Zone
MySQL Server Documentation
Oracle