23 May
2002
23 May
'02
5:46 a.m.
On Thu, 23 May 2002, Beck, Mike wrote:
ACK, now at least i see what you are doing... but i
still think it is more
complicated than it needs to be. of course you can put the serialized data
in the db, but why not just put it in the db like
table db
id host con_type dbuser dbpass....
1 localhost tcp ....
2 212.114.248.20 tcp ...
$local_query = 'SELECT * FROM db';
$rs = mysql_query($local_query, $dbh);
$count =count($cfg['Servers']); // assuming we allready read the
configfile
while ($row = mysql_fetch_array($rs)) {
$cfg['Servers'][$count]['host'] = $row['host'];
$count ++;
}
This method fails dismally. It would be very non-portable between versions
of PMA, and additionally, how do you handle multi-dimensonal data without
adding more rows?
A configuration file might have two or three servers, each with a number
of IP Allow/Deny rules.
Effectively, we have array nesting 3 levels deep already with this, so
giving each variable a field in the table is not practical.
Additionally, my method using XML + XPath allows the administrator of each
copy of PMA to completely customize what the user is allowed to change,
with only a single line in the configuration file. (This is one of those
security preferences that is not available in the DB-Config level).
of course it might need a little extra time going
through this data and
putting it in the configvariable, but surely not enough that there is such a
pressing need to use another way that we'd rather make it work only with >=
4.2 ??
Let me finish coding it up the way I have in mind, with the
customizability and view towards the future, and then tell me if you can
port all of those features to PHP3 without XPath. That XPath class is the
single thing standing in the way of the code working on PHP3, and it is
something I am using from outside, just like the FPDF library.
For my XPath axes, I basically need to be able to match the following
example axes:
/PmaAbsoluteUri
/Servers/*/controlpass
/Servers/*/AllowDeny/order
/OBGzip | /GZipDump
I don't really need any of the XPath functions [count() etc.], although
they would come in handy.
If you want, I will provide a sample of the XML configuration file as
well.
--
Robin Hugh Johnson
E-Mail : robbat2(a)orbis-terrarum.net
Home Page : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ# : 30269588 or 41961639