User Name
Password

Go Back   Planetarion Forums > Non Planetarion Discussions > Programming and Discussion

Reply
Thread Tools Display Modes
Unread 18 Jan 2003, 14:17   #1
Not_RIT
Registered User
 
Join Date: Jan 2003
Posts: 340
Not_RIT is an unknown quantity at this point
Good PHP and MySQL book?

Im looking for a good PHP and MySQL book, I have a PHP book atm and its very lacking in the MySQL chapters, so any sugestions will be welcomed.

And please dont start spamming with www.mysql.com and www.php.net etc, theres a large difference between websites and books one such difference being you cant take a website with you to the bog and on train journeys, comprende?
Not_RIT is offline   Reply With Quote
Unread 18 Jan 2003, 14:21   #2
Gayle29uk
Bitch
 
Join Date: Jun 2002
Location: North Yorkshire
Posts: 3,848
Gayle29uk is just really niceGayle29uk is just really niceGayle29uk is just really niceGayle29uk is just really nice
I'm being deadly serious when I say PHP/MySQL for Dummies. It won't break the bank and will get you started in no time.
__________________
ACHTUNG!!!
Das machine is nicht fur gefingerpoken und mittengrabben. Ist easy
schnappen der springenwerk, blowenfusen und corkenpoppen mit
spitzensparken. Ist nicht fur gewerken by das dummkopfen. Das
rubbernecken sightseeren keepen hands in das pockets. Relaxen und vatch
das blinkenlights!!!
Gayle29uk is offline   Reply With Quote
Unread 18 Jan 2003, 14:29   #3
Not_RIT
Registered User
 
Join Date: Jan 2003
Posts: 340
Not_RIT is an unknown quantity at this point
Quote:
Originally posted by Gayle28uk
I'm being deadly serious when I say PHP/MySQL for Dummies. It won't break the bank and will get you started in no time.
Yeh I looked at that, I also looked at
this

I need something which will explain how to fully use mysql with PHP, my current book is kinda bad at that, missing out a lot of the syntax rules heh.
Not_RIT is offline   Reply With Quote
Unread 18 Jan 2003, 15:22   #4
Gayle29uk
Bitch
 
Join Date: Jun 2002
Location: North Yorkshire
Posts: 3,848
Gayle29uk is just really niceGayle29uk is just really niceGayle29uk is just really niceGayle29uk is just really nice
Can't comment on the other but PHP/MySQL for dummies is one I actually have and it really is well written. To be honest it sounds perfect for what you want.
__________________
ACHTUNG!!!
Das machine is nicht fur gefingerpoken und mittengrabben. Ist easy
schnappen der springenwerk, blowenfusen und corkenpoppen mit
spitzensparken. Ist nicht fur gewerken by das dummkopfen. Das
rubbernecken sightseeren keepen hands in das pockets. Relaxen und vatch
das blinkenlights!!!
Gayle29uk is offline   Reply With Quote
Unread 18 Jan 2003, 17:06   #5
Raging.Retard
Street Tramp
 
Raging.Retard's Avatar
 
Join Date: Apr 2000
Location: Street Gutter
Posts: 341
Raging.Retard has a brilliant futureRaging.Retard has a brilliant futureRaging.Retard has a brilliant futureRaging.Retard has a brilliant futureRaging.Retard has a brilliant futureRaging.Retard has a brilliant futureRaging.Retard has a brilliant futureRaging.Retard has a brilliant futureRaging.Retard has a brilliant futureRaging.Retard has a brilliant futureRaging.Retard has a brilliant future
Surely there isnt that much to say? I would have thought you needed to learn the PHP commands that interface with the DB. The rest would be learning SQL.

The later can be extremely quick, or extremely hard depending on how in depth you go. SQL supports a lot of operations most people have never even seen before.

I suspect your book covers the initial interfacing in PHP? And perhaps you would be wise to just go for a book on SQL ?

My 2 cents.
__________________
Chimney Pots.
Raging.Retard is offline   Reply With Quote
Unread 18 Jan 2003, 17:19   #6
Dante Hicks
Clerk
 
Join Date: Jun 2001
Posts: 13,940
Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.Dante Hicks has ascended to a higher existance and no longer needs rep points to prove the size of his e-penis.
I've got the O'Reilly Web Database book, it's not bad, although I'd wait for a second edition before getting it.

A few of the examples in the book won't work with a "out of the box" PHP setup (for register_globals reasons mainly). It's not exactly a major problem, but it can be a bit annoying.

It's very strong on the theme of the book - setting up an e-commerce style site using PHP/MySQL. But I'm not sure how good it is if you are going for more general usage. Personally I'd get a more general PHP book (O'Reilly's Programming PHP is good) and then a more general MySQL book. The actual PHP MySQL functions are a doddle to use and there's not that much you need to know about them.
Dante Hicks is offline   Reply With Quote
Unread 18 Jan 2003, 17:30   #7
Not_RIT
Registered User
 
Join Date: Jan 2003
Posts: 340
Not_RIT is an unknown quantity at this point
Quote:
Originally posted by Raging.Retard
Surely there isnt that much to say? I would have thought you needed to learn the PHP commands that interface with the DB. The rest would be learning SQL.

The later can be extremely quick, or extremely hard depending on how in depth you go. SQL supports a lot of operations most people have never even seen before.

I suspect your book covers the initial interfacing in PHP? And perhaps you would be wise to just go for a book on SQL ?

My 2 cents.
I have the O'reilly SQL book, so SQL commands aint the problem, im just lacking how php interfaces with SQL as my PHP book is utter crap :/
Not_RIT is offline   Reply With Quote
Unread 18 Jan 2003, 18:25   #8
Gayle29uk
Bitch
 
Join Date: Jun 2002
Location: North Yorkshire
Posts: 3,848
Gayle29uk is just really niceGayle29uk is just really niceGayle29uk is just really niceGayle29uk is just really nice
Quote:
Originally posted by Raging.Retard
Surely there isnt that much to say? I would have thought you needed to learn the PHP commands that interface with the DB. The rest would be learning SQL.
Not on the MySQL interface, no. A dozen or so lines of code pretty much covers that and that includes error trapping

It does go into basic DB design and PHP basics as well, the central theme takes you through to a PHP frontend for a MySQL DB with user login and session tracking. Not rocket science but it's still a useful book (although I hadn't done any PHP when I bought it so I may have found it more useful than someone who had).
__________________
ACHTUNG!!!
Das machine is nicht fur gefingerpoken und mittengrabben. Ist easy
schnappen der springenwerk, blowenfusen und corkenpoppen mit
spitzensparken. Ist nicht fur gewerken by das dummkopfen. Das
rubbernecken sightseeren keepen hands in das pockets. Relaxen und vatch
das blinkenlights!!!
Gayle29uk is offline   Reply With Quote
Unread 19 Jan 2003, 02:04   #9
Coffee
Ensign
 
Coffee's Avatar
 
Join Date: Apr 2000
Location: An intricate fantasy world.
Posts: 166
Coffee is an unknown quantity at this point
I know you said about www.php.net, but once you've got to grips with the basics do not understimate its use! User comments on most commands give several working examples for just about any function imaginable (as well as all the pitfalls). Its a really, really good resource.
__________________
PIE*
Coffee is offline   Reply With Quote
Unread 19 Jan 2003, 03:44   #10
xtothez
ŻŻŻŻŻŻŻŻŻ
 
xtothez's Avatar
 
Join Date: May 2001
Location: Sept 2057
Posts: 1,813
xtothez has much to be proud ofxtothez has much to be proud ofxtothez has much to be proud ofxtothez has much to be proud ofxtothez has much to be proud ofxtothez has much to be proud ofxtothez has much to be proud ofxtothez has much to be proud ofxtothez has much to be proud ofxtothez has much to be proud of
Re: Good PHP and MySQL book?

Quote:
Originally posted by Not_RIT
And please dont start spamming with www.mysql.com and www.php.net etc, theres a large difference between websites and books one such difference being you cant take a website with you to the bog and on train journeys, comprende?
BUT YOU CANT COPY/PASTE FROM THE BOG EITHER!!!!!123
(disturbing mental image intentional)
__________________
in my sig i write down all my previous co-ords and alliance positions as if they matter because I'm not important enough to be remembered by nickname alone.
xtothez is offline   Reply With Quote
Unread 19 Jan 2003, 13:03   #11
Not_RIT
Registered User
 
Join Date: Jan 2003
Posts: 340
Not_RIT is an unknown quantity at this point
Re: Re: Good PHP and MySQL book?

Quote:
Originally posted by xtothez
BUT YOU CANT COPY/PASTE FROM THE BOG EITHER!!!!!123
(disturbing mental image intentional)
I tried to copy and paste using my pen the other day, the humilitation

Most of my learning is done on the bog :/ its so much easier to concentrate :/
Not_RIT is offline   Reply With Quote
Unread 19 Jan 2003, 14:40   #12
Add
Registered User
 
Join Date: Feb 2001
Posts: 442
Add will become famous soon enoughAdd will become famous soon enough
get a book by kevin yank from www.sitepoint.com - it is all you will ever need.
__________________
Trust in my Instinct
Add is offline   Reply With Quote
Unread 21 Jan 2003, 01:02   #13
Mong
Forever Delayed
 
Join Date: Sep 2000
Location: www.netgamers.org
Posts: 1,475
Mong is on a distinguished road
Quote:
Originally posted by Not_RIT
Yeh I looked at that, I also looked at
this
You mean "Web Database Applications with PHP and MySQL"?

I seem to recall that you mentioned accessibility in another thread? A major rule is to always Name Your Links, so that users don't have to click them to find what they are

Anyway, that's by-the-by.

I read reviews of various PHP books before buying my own ones, and apparently that O'Reilly one actually has syntax and other errors in the example code. Annoying!

I picked up PHP from "Beginning PHP4" from Wrox. It came very highly recommended. It turned my web-designing ass into a half decent PHP/MySQL coder in a short time!

The new Wrox book about using PHP & MySQL in a live project . Looks very interesting. But Professional PHP Programming . Is probably more relevant.

M.
__________________
Firefly Oper and General l4m3r - "I Do Stuff"

O2 Rip-off campaign

<vampy> plus i hate people ... i despise humanity as a whole

pablissimo "I'm still geting over the fact you just posted a pic of your own vomit"

Last edited by Mong; 22 Jan 2003 at 01:08.
Mong is offline   Reply With Quote
Unread 21 Jan 2003, 02:18   #14
queball
Ball
 
queball's Avatar
 
Join Date: Oct 2001
Posts: 4,410
queball contributes so much and asks for so littlequeball contributes so much and asks for so littlequeball contributes so much and asks for so littlequeball contributes so much and asks for so littlequeball contributes so much and asks for so littlequeball contributes so much and asks for so littlequeball contributes so much and asks for so littlequeball contributes so much and asks for so littlequeball contributes so much and asks for so littlequeball contributes so much and asks for so littlequeball contributes so much and asks for so little
Quote:
Originally posted by Mong
using PHP & MySQL in a live project
That's almost as bad as an unnamed link.
queball is offline   Reply With Quote
Unread 21 Jan 2003, 02:23   #15
Add
Registered User
 
Join Date: Feb 2001
Posts: 442
Add will become famous soon enoughAdd will become famous soon enough
Quote:
Originally posted by Add
get a book by kevin yank from www.sitepoint.com - it is all you will ever need.
i cannot stress enough that if you are new to php/mysql this is all you will need. disregard anything else that has been said here.

read the first 4 chapters here, by the end of that you should be able to code php as well as 90% of the people on this board, if not better. get and read the whole book and it will be well worth your time.
__________________
Trust in my Instinct
Add is offline   Reply With Quote
Unread 22 Jan 2003, 01:07   #16
Mong
Forever Delayed
 
Join Date: Sep 2000
Location: www.netgamers.org
Posts: 1,475
Mong is on a distinguished road
Quote:
Originally posted by Add
i cannot stress enough that if you are new to php/mysql this is all you will need. disregard anything else that has been said here.
And I can't stress enough that Beginning PHP4 (with MySQL) is the only book you'll ever need :P

M.
__________________
Firefly Oper and General l4m3r - "I Do Stuff"

O2 Rip-off campaign

<vampy> plus i hate people ... i despise humanity as a whole

pablissimo "I'm still geting over the fact you just posted a pic of your own vomit"
Mong is offline   Reply With Quote
Unread 22 Jan 2003, 01:39   #17
Add
Registered User
 
Join Date: Feb 2001
Posts: 442
Add will become famous soon enoughAdd will become famous soon enough
Quote:
Originally posted by Mong
And I can't stress enough that Beginning PHP4 (with MySQL) is the only book you'll ever need :P

M.
that book is the equivalent of the 1st 4 chapters of the other book. i don't have any php books. but as far as i know, the kevin yank book takes you into advanced principles too, such as oop and database abstraction.
__________________
Trust in my Instinct
Add is offline   Reply With Quote
Unread 22 Jan 2003, 02:00   #18
Mong
Forever Delayed
 
Join Date: Sep 2000
Location: www.netgamers.org
Posts: 1,475
Mong is on a distinguished road
Quote:
Originally posted by Add
that book is the equivalent of the 1st 4 chapters of the other book. i don't have any php books. but as far as i know, the kevin yank book takes you into advanced principles too, such as oop and database abstraction.
"As far as you know"? It seems you've read neither book? Therefore I continue in my recommendation, of a book which also delves into some more advanced principles too.

But you could be right, as Rit already has some PHP knowledge and your recommendation is for "intermediate or advanced Web designers looking to make the leap into server-side programming".

But after teaching myself from "Beginning PHP4" by Wrox, I can only recommend Professional PHP Programming by the same people.

M.
__________________
Firefly Oper and General l4m3r - "I Do Stuff"

O2 Rip-off campaign

<vampy> plus i hate people ... i despise humanity as a whole

pablissimo "I'm still geting over the fact you just posted a pic of your own vomit"
Mong is offline   Reply With Quote
Unread 22 Jan 2003, 09:25   #19
mbushell
Registered User
 
mbushell's Avatar
 
Join Date: Jul 2000
Location: :noitacoL
Posts: 1,200
mbushell spreads love and joy to the forum in the same way Jesus wouldmbushell spreads love and joy to the forum in the same way Jesus wouldmbushell spreads love and joy to the forum in the same way Jesus wouldmbushell spreads love and joy to the forum in the same way Jesus wouldmbushell spreads love and joy to the forum in the same way Jesus wouldmbushell spreads love and joy to the forum in the same way Jesus wouldmbushell spreads love and joy to the forum in the same way Jesus wouldmbushell spreads love and joy to the forum in the same way Jesus wouldmbushell spreads love and joy to the forum in the same way Jesus wouldmbushell spreads love and joy to the forum in the same way Jesus wouldmbushell spreads love and joy to the forum in the same way Jesus would
The PHP manual itself provides its own MySQL chapter, tis where i learnt from.
mbushell is offline   Reply With Quote
Unread 22 Jan 2003, 10:48   #20
Mong
Forever Delayed
 
Join Date: Sep 2000
Location: www.netgamers.org
Posts: 1,475
Mong is on a distinguished road
Quote:
Originally posted by mbushell
The PHP manual itself provides its own MySQL chapter, tis where i learnt from.
Valid. The online PHP manual, with user notes, is just superb. It rarely fails me.

M.
__________________
Firefly Oper and General l4m3r - "I Do Stuff"

O2 Rip-off campaign

<vampy> plus i hate people ... i despise humanity as a whole

pablissimo "I'm still geting over the fact you just posted a pic of your own vomit"
Mong is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Forum Jump


All times are GMT +1. The time now is 13:18.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright İ2002 - 2018