From owner-freebsd-chat Sat Jan 11 2:27:18 2003 Delivered-To: freebsd-chat@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 8A27837B405; Sat, 11 Jan 2003 02:27:16 -0800 (PST) Received: from puffin.mail.pas.earthlink.net (puffin.mail.pas.earthlink.net [207.217.120.139]) by mx1.FreeBSD.org (Postfix) with ESMTP id 11E2043F13; Sat, 11 Jan 2003 02:27:16 -0800 (PST) (envelope-from tlambert2@mindspring.com) Received: from pool0023.cvx40-bradley.dialup.earthlink.net ([216.244.42.23] helo=mindspring.com) by puffin.mail.pas.earthlink.net with asmtp (SSLv3:RC4-MD5:128) (Exim 3.33 #1) id 18XIr8-0001Fa-00; Sat, 11 Jan 2003 02:27:11 -0800 Message-ID: <3E1FF12B.5390D978@mindspring.com> Date: Sat, 11 Jan 2003 02:25:47 -0800 From: Terry Lambert X-Mailer: Mozilla 4.79 [en] (Win98; U) X-Accept-Language: en MIME-Version: 1.0 To: Doug Barton Cc: freebsd-chat@freebsd.org Subject: Re: Need advice on PHP and MySQL books References: <20030110234309.R12065@2-234-22-23.pyvrag.nggov.pbz> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-ELNK-Trace: b1a02af9316fbb217a47c185c03b154d40683398e744b8a4b40cee93596a72f6bfe5119569136be0350badd9bab72f9c350badd9bab72f9c350badd9bab72f9c Sender: owner-freebsd-chat@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.org Doug Barton wrote: > I know this can become a religious topic, but I'd like to pick up some > books on PHP and SQL, so I thought I'd ask here for advice. I'm currently > considering the following O'Reilly titles: > > Managing & Using MySQL, 2nd Edition > Programming PHP Almost every PHP book deals with MySQL. Find one with examples ou like, and it will cover most of what you care about. If you were asking about, say, building a WebMail client, I'd say there are no good PHP books for that, since there are none that deal adequately with the rendering of MIME-encapsulated data, in to any reasonable level. But database clients, particularly MySQL, are pretty much what you find in great abundance in every single PHP book. I liked: Core PHP Programming and: PHP Essentials well enough to buy both of them. > My ultimate goal is to produce a web-based DNS Management tool with an SQL > back end. You are probably not going to be happy with this, unless you take the data in the MySQL database, and post-process it, to get the DNS configuration files. Specifically, MySQL is a relational database, and DNS is actually a hierarchical database; the mapping works much better from LDAP to DNS (for example), than from MySQL to DNS. Basically, there's an "impedance mismatch". If you intend to derive the configuration files from MySQL data, though, it's rather trivial. Specifically, I've been involved with using Java, Perl, and other CGI code to both modify and generate "reports" that contain DNS configuration data for use by a DNS server, from MySQL stored data, and pretty much anything will work. The only real issue, I'd say, is that now that the MySQL license has changed, you need to worry about L/GPL applied to language bindings for the code, since both Perl and Java are interpreted, and if you mean to use L/GPL'ed language bindings, they are a lot less severable from interpreted languages than they are from other languages. If this is for internal use, you can ignore the GPL, since it only really applies if you distribute the code. -- Terry To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-chat" in the body of the message