[Pro] PHP & MYSQL recommendations

Hi;

I’m hoping to develop a website using a database. There are far to many “items” [UK moths & butterflies] not to. There will be a need to search for a particular species too.

I’ve seen Keith’s “helpful” website but am still confused as to which is the best book/s to buy. Both “languages/scripts” have moved on since Keith’s site was written. Clook [my ISP] are using version 5 for both and I’ve seen mention of PHP v6 so any guidance would be welcome.

I see there is a “Dummies Guide” but it has very few examples.

Many thanks for any help with this.

Wild Cottage.


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

At 06:31 -0500 18/12/10, WildCottage wrote:

Hi;

I’m hoping to develop a website using a database. There are far to
many ³items² [UK moths & butterflies] not to. There will be a need
to search for a particular species too.

I’ve seen Keith’s ³helpful² website but am still confused as to
which is the best book/s to buy. Both ³languages/scripts² have moved
on since Keith’s site was written. Clook [my ISP] are using version
5 for both and I’ve seen mention of PHP v6 so any guidance would be
welcome.

I see there is a ³Dummies Guide² but it has very few examples.

The PHP is probably the easy part. First read up on MySQL and the way
databases work. Spend some time deciding what fields you need in the
database so that you can make the sort of queries that you want on
the website using SQL queries. Running them from within PHP and
displaying the results is then relatively easy.

David


David Ledger - Freelance Unix Sysadmin in the UK.
HP-UX specialist of hpUG technical user group (www.hpug.org.uk)
email@hidden
www.ivdcs.co.uk


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

On Dec 18, 2010, at 5:31 AM, WildCottage wrote:

but am still confused as to which is the best book/s to buy.

“PHP and MySQL Development” by Luke Welling and Laura Thomson (fourth
edition) is one of the best. It starts slow and picks up but it is
technical; definitely not a “Dummies” book. Lots of examples to work
through (includes a disc).

Todd


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Also MySQL/PHP Database Applications by Jay Greenspan and Brad Bulger

Again not a Dummies book - but then again not really a Dummies area.

Examples and Disc too

David


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Once you have your DB then phpMyEdit http://www.phpmyedit.org/ is well worth a look to help you interact with it.

D


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

I agree, this is probably the best book you could pick up, I looked at
a few when I started and this (earlier edition) is the only one I
could make any real sense of. I recommend you to work through the book
and not try to run before you can walk.

When you get along the way some and need to start integrating things
with Freeway then it might help you to take a look at:
http://www.easibase.com/freeway/phpmysql.php

This was done a few years ago but it is all still fairly much up to
date although the examples where made in FWPro 4. It shows one way of
integrating queries and php with Freeway.

HTH

On Dec 18, 2010, at 4:04 PM, Todd wrote:

On Dec 18, 2010, at 5:31 AM, WildCottage wrote:

but am still confused as to which is the best book/s to buy.

“PHP and MySQL Development” by Luke Welling and Laura Thomson
(fourth edition) is one of the best. It starts slow and picks up but
it is technical; definitely not a “Dummies” book. Lots of examples
to work through (includes a disc).

Todd


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options

Hi everyone

Many thanks for all the suggestions; looks like I’ll have plenty to read!!

Wild Cottage


freewaytalk mailing list
email@hidden
Update your subscriptions at:
http://freewaytalk.net/person/options