I am new to PHP and MySQL and have some ideas for a few personal databases I'd like to build.<br /><br />I am looking for advice for a "getting started" book. I already know how to program, and understand databases. So, I'm looking for a book geared towards someone learning a new database system and scripting language, not one for people who don't understand tables or selection statements yet.<br /><br />I'd appreciate any suggetions someone might be able to offer.<br /><br />Thanks!<br /><br />--Beth<!--content-->
Well, for PHP, the best place to start is almost always <a href="http://www.php.net" target="_blank">http://www.php.net</a>. The online documentation cannot be beat.<!--content-->
I second the php site as being a great reference point. Additionally, I found that downloading some free PHP applications and ripping apart the code to see what makes it 'tick' was a big help, just make sure the application you pick actually works or you'll find yourself in a world of hurt LOL<br /><br />Good luck and have fun!<br /><br />Later,<br />Paul<!--content-->
check out <a href="http://tch.kwsupport.com/id17.htm" target="_blank">http://tch.kwsupport.com/id17.htm</a><br />-kw<!--content-->
I started off with Wrox's (<!-- w --><a class="postlink" href="http://www.wrox.com">www.wrox.com</a><!-- w -->) "Beginning PHP" (ISBN 1-861003-73-0) which I borrowed from the library. It's a simple to understand, step by step book that uses the situational problem solving approach.<br /><br />To try out the examples I downloaded Firepage's (<!-- w --><a class="postlink" href="http://www.firepages.com.au">www.firepages.com.au</a><!-- w -->) PHPDev package, which installed and preconfigured Apache, PHP and mySQL for me.<br /><br />As I installed Invision Power Board and started installing mods for it, I begin to learn more about how PHP works. Taking existing code apart are a great way to see how things work.<br /><br />Read or download the PHP documentation too, they are great as a handy reference. I keep a *.CHM (HTML Help) copy on my desktop for easy access too!<!--content-->
I ended up buying two different PHP/MySQL books:<ul><li>PHP and MySQL Web Development, Luke Welling & Laura Thomson</li><li>Professional PHP Programming, Wrox book, Castagnetto, Rawait, Schumann, Scollo, Veliath</li></ul>I've gotten my first PHP/MySQL page working (entering the information into a form that is is emailed to someone and also added to a database). You can't view the database through a web page yet, but hey, I'm working on it!<br /><br />My background might be helpful to know to put my remarks in context:<ul><li>Extensive programming experience, mostly in C and Pascal (i.e. before Object Oriented)</li><li>I design databases and web application systems (including OO) </li><li>Minor maintenance on JSP and ASP pages, as well as some Java objects that others wrote</li><li>10 years of teaching experience, including introductory programming and computer literacy</li></ul>Of these two books, Welling/Thomson is the one I can semi-recommend. I can't recommend the Wrox book at all.<br /><br />PHP and MySQL Web Development has pluses and minuses:<ul><li>Basic introduction to programming concepts: variables, loops, selections, functions--good for a beginner</li><li>Explanations of variable scope and object oriented program too advanced for a beginner but too basic for someone experienced</li><li>Code examples start out very basic--easy to copy and modify</li><li>Some poor programming style issues--not of importance to a beginner but annoying to someone who knows more about programming</li><li>I didn't read the database concepts sections, so can't review those</li></ul>The Wrox book (Professional PHP Programming) doesn' t have a clue who its audience is.<ul><li>There are extensive lists of functions/methods/types that are almost straight from the <!-- w --><a class="postlink" href="http://www.php.net">www.php.net</a><!-- w --> page and should be in an appendix if they're included at all</li><li>Lots of "piddly" comparisons</li><li>Code in the early sections is too trivial to merit the "Professional" title</li><li>This is not a "reading" book--it's a reference book--but not organized properly for that</li></ul>So, that's my take on the two I bought, at any rate!<br /><br />--Beth<!--content-->
On my shelf:<br /><br /><b>Web Database Applications with PHP & MySQL</b> Williams & Lane Pub. O'Reilly (one of my favorite Publishers)<br /> <!--coloro:blue--><span style="color:blue"><!--/coloro-->Would be my first recommendation for someone with your background, plus it is a cute little platypus.<!--colorc--></span><!--/colorc--><br /><br /><b>MySQL/PHP Database Applications </b>Greenspan & Bulger Pub. M&T Books (third place)<br /><br /><b>PHP and MySQL Web Development </b>Welling and Thomson Pub. Sams (<u>not</u> my favorite publisher)<br /><br />As mentioned earlier, <a href="http://www.php.net" target="_blank">http://www.php.net</a> is truly the best online source.<!--content-->
Well, I'm one of those guys who gets every information he needs from the internet <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /><br /><br />What I mean is that if you look for some tutorials, you'll find loads of them.<br />I've been working with PHP since the beginings of version 3.0 (some years ago) and I've learned a lot by myself, by reading tutorials, reading code from other people...<br /><br />But don't get me wrong - I don't think an online tutorial can replace a book!<br /><br />But in some cases, people don't have the money to buy technical books, which are very expensive (at least here in Portugal). In those cases, online tutorials can do the trick just as well. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="
" border="0" alt="smile.gif" /><br /><br />PS - For those of you who haven't been paying attention, the keyword here is goolge... <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="
" border="0" alt="wink.gif" /><!--content-->
Well, for PHP, the best place to start is almost always <a href="http://www.php.net" target="_blank">http://www.php.net</a>. The online documentation cannot be beat.<!--content-->
I second the php site as being a great reference point. Additionally, I found that downloading some free PHP applications and ripping apart the code to see what makes it 'tick' was a big help, just make sure the application you pick actually works or you'll find yourself in a world of hurt LOL<br /><br />Good luck and have fun!<br /><br />Later,<br />Paul<!--content-->
check out <a href="http://tch.kwsupport.com/id17.htm" target="_blank">http://tch.kwsupport.com/id17.htm</a><br />-kw<!--content-->
I started off with Wrox's (<!-- w --><a class="postlink" href="http://www.wrox.com">www.wrox.com</a><!-- w -->) "Beginning PHP" (ISBN 1-861003-73-0) which I borrowed from the library. It's a simple to understand, step by step book that uses the situational problem solving approach.<br /><br />To try out the examples I downloaded Firepage's (<!-- w --><a class="postlink" href="http://www.firepages.com.au">www.firepages.com.au</a><!-- w -->) PHPDev package, which installed and preconfigured Apache, PHP and mySQL for me.<br /><br />As I installed Invision Power Board and started installing mods for it, I begin to learn more about how PHP works. Taking existing code apart are a great way to see how things work.<br /><br />Read or download the PHP documentation too, they are great as a handy reference. I keep a *.CHM (HTML Help) copy on my desktop for easy access too!<!--content-->
I ended up buying two different PHP/MySQL books:<ul><li>PHP and MySQL Web Development, Luke Welling & Laura Thomson</li><li>Professional PHP Programming, Wrox book, Castagnetto, Rawait, Schumann, Scollo, Veliath</li></ul>I've gotten my first PHP/MySQL page working (entering the information into a form that is is emailed to someone and also added to a database). You can't view the database through a web page yet, but hey, I'm working on it!<br /><br />My background might be helpful to know to put my remarks in context:<ul><li>Extensive programming experience, mostly in C and Pascal (i.e. before Object Oriented)</li><li>I design databases and web application systems (including OO) </li><li>Minor maintenance on JSP and ASP pages, as well as some Java objects that others wrote</li><li>10 years of teaching experience, including introductory programming and computer literacy</li></ul>Of these two books, Welling/Thomson is the one I can semi-recommend. I can't recommend the Wrox book at all.<br /><br />PHP and MySQL Web Development has pluses and minuses:<ul><li>Basic introduction to programming concepts: variables, loops, selections, functions--good for a beginner</li><li>Explanations of variable scope and object oriented program too advanced for a beginner but too basic for someone experienced</li><li>Code examples start out very basic--easy to copy and modify</li><li>Some poor programming style issues--not of importance to a beginner but annoying to someone who knows more about programming</li><li>I didn't read the database concepts sections, so can't review those</li></ul>The Wrox book (Professional PHP Programming) doesn' t have a clue who its audience is.<ul><li>There are extensive lists of functions/methods/types that are almost straight from the <!-- w --><a class="postlink" href="http://www.php.net">www.php.net</a><!-- w --> page and should be in an appendix if they're included at all</li><li>Lots of "piddly" comparisons</li><li>Code in the early sections is too trivial to merit the "Professional" title</li><li>This is not a "reading" book--it's a reference book--but not organized properly for that</li></ul>So, that's my take on the two I bought, at any rate!<br /><br />--Beth<!--content-->
On my shelf:<br /><br /><b>Web Database Applications with PHP & MySQL</b> Williams & Lane Pub. O'Reilly (one of my favorite Publishers)<br /> <!--coloro:blue--><span style="color:blue"><!--/coloro-->Would be my first recommendation for someone with your background, plus it is a cute little platypus.<!--colorc--></span><!--/colorc--><br /><br /><b>MySQL/PHP Database Applications </b>Greenspan & Bulger Pub. M&T Books (third place)<br /><br /><b>PHP and MySQL Web Development </b>Welling and Thomson Pub. Sams (<u>not</u> my favorite publisher)<br /><br />As mentioned earlier, <a href="http://www.php.net" target="_blank">http://www.php.net</a> is truly the best online source.<!--content-->
Well, I'm one of those guys who gets every information he needs from the internet <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/biggrin.gif" style="vertical-align:middle" emoid="
" border="0" alt="biggrin.gif" /><br /><br />What I mean is that if you look for some tutorials, you'll find loads of them.<br />I've been working with PHP since the beginings of version 3.0 (some years ago) and I've learned a lot by myself, by reading tutorials, reading code from other people...<br /><br />But don't get me wrong - I don't think an online tutorial can replace a book!<br /><br />But in some cases, people don't have the money to buy technical books, which are very expensive (at least here in Portugal). In those cases, online tutorials can do the trick just as well. <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/smile.gif" style="vertical-align:middle" emoid="" border="0" alt="smile.gif" /><br /><br />PS - For those of you who haven't been paying attention, the keyword here is goolge... <img src="http://www.totalchoicehosting.com/forums/style_emoticons/default/wink.gif" style="vertical-align:middle" emoid="" border="0" alt="wink.gif" /><!--content-->