[PHP-DB] Indepth Tutorial... need help.
Can someone point me in the direction of an online tutorial for php mysql that covers the following: - Teaches me how to use php to access mysql - Creating a db that is structured to be efficient - How to add, modify, and delete records in a database - How to search for records - How to filter records - How to sort records, by a certain field, alphabetical, descending etc. - Indexes - how to create them, how to keep the updated with changes in the db a beginners look to in-depth approach. Yes I've visited PHP.net, and mysql.com. I need a dumbed down version that pretty much holds my hand and is very detailed. I've searched the net for a while now, and all the tutorials I have found... although simple... they don't go in-depth and move on to more advanced features. Any help at all will be greatly appreciated. -Matt -- Matt Zur [EMAIL PROTECTED] http://www.zurnet.com Need a Web Site??? - Visit... www.zurnet.com 1997 - 2002 - 5th Anniversary!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Indepth Tutorial... need help.
Most of this stuff is actually just SQL and has little to do with PHP. So look for an SQL tutorial. From the PHP side all you need to know is mysql_connect(), mysql_select_db(), mysql_query() and mysql_fetch_row().'' All queries are sent to the database via mysql_query(). It doesn't matter to PHP if you are adding, deleting, modifying, searching, sorting, filtering, or whatever. You just put the SQL code in the mysql_query() call. -Rasmus On Tue, 3 Sep 2002, Matt Zur wrote: Can someone point me in the direction of an online tutorial for php mysql that covers the following: - Teaches me how to use php to access mysql - Creating a db that is structured to be efficient - How to add, modify, and delete records in a database - How to search for records - How to filter records - How to sort records, by a certain field, alphabetical, descending etc. - Indexes - how to create them, how to keep the updated with changes in the db a beginners look to in-depth approach. Yes I've visited PHP.net, and mysql.com. I need a dumbed down version that pretty much holds my hand and is very detailed. I've searched the net for a while now, and all the tutorials I have found... although simple... they don't go in-depth and move on to more advanced features. Any help at all will be greatly appreciated. -Matt -- Matt Zur [EMAIL PROTECTED] http://www.zurnet.com Need a Web Site??? - Visit... www.zurnet.com 1997 - 2002 - 5th Anniversary!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Indepth Tutorial... need help.
Right well that's what I'm asking I need a tutorial and haven't found a good one. -Matt Rasmus Lerdorf wrote: Most of this stuff is actually just SQL and has little to do with PHP. So look for an SQL tutorial. From the PHP side all you need to know is mysql_connect(), mysql_select_db(), mysql_query() and mysql_fetch_row().'' All queries are sent to the database via mysql_query(). It doesn't matter to PHP if you are adding, deleting, modifying, searching, sorting, filtering, or whatever. You just put the SQL code in the mysql_query() call. -Rasmus On Tue, 3 Sep 2002, Matt Zur wrote: Can someone point me in the direction of an online tutorial for php mysql that covers the following: - Teaches me how to use php to access mysql - Creating a db that is structured to be efficient - How to add, modify, and delete records in a database - How to search for records - How to filter records - How to sort records, by a certain field, alphabetical, descending etc. - Indexes - how to create them, how to keep the updated with changes in the db a beginners look to in-depth approach. Yes I've visited PHP.net, and mysql.com. I need a dumbed down version that pretty much holds my hand and is very detailed. I've searched the net for a while now, and all the tutorials I have found... although simple... they don't go in-depth and move on to more advanced features. Any help at all will be greatly appreciated. -Matt -- Matt Zur [EMAIL PROTECTED] http://www.zurnet.com Need a Web Site??? - Visit... www.zurnet.com 1997 - 2002 - 5th Anniversary!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Matt Zur [EMAIL PROTECTED] http://www.zurnet.com Need a Web Site??? - Visit... www.zurnet.com 1997 - 2002 - 5th Anniversary!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Indepth Tutorial... need help.
On Tue, 03 Sep 2002 08:56:43 -0400 Matt Zur [EMAIL PROTECTED] wrote: Can someone point me in the direction of an online tutorial for php mysql that covers the following: http://www.phpbuilder.com http://www.devshed.com http://www.devarticles.com Well, if you do not find something here :-) pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Indepth Tutorial... need help.
http://www.mysql.com/doc/en/Tutorial.html is a good place to start with the mysql functions in the php manual. http://www.devshed.com/Server_Side/ has a number of on line tutes amongst others. phpbuilder also is useful. The normalisation article is a good first step; it is at http://www.phpbuilder.com/columns/barry2731.php3 Tim Morris - Original Message - From: Matt Zur [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 11:08 PM Subject: Re: [PHP-DB] Indepth Tutorial... need help. : Right well that's what I'm asking I need a tutorial and haven't found a : good one. : : -Matt : : Rasmus Lerdorf wrote: : Most of this stuff is actually just SQL and has little to do with PHP. So : look for an SQL tutorial. From the PHP side all you need to know is : mysql_connect(), mysql_select_db(), mysql_query() and mysql_fetch_row().'' : : All queries are sent to the database via mysql_query(). It doesn't matter : to PHP if you are adding, deleting, modifying, searching, sorting, : filtering, or whatever. You just put the SQL code in the mysql_query() : call. : : -Rasmus : : On Tue, 3 Sep 2002, Matt Zur wrote: : : : Can someone point me in the direction of an online tutorial for php : mysql that covers the following: : : - Teaches me how to use php to access mysql : - Creating a db that is structured to be efficient : - How to add, modify, and delete records in a database : - How to search for records : - How to filter records : - How to sort records, by a certain field, alphabetical, descending etc. : - Indexes - how to create them, how to keep the updated with changes in : the db a beginners look to in-depth approach. : : Yes I've visited PHP.net, and mysql.com. I need a dumbed down version : that pretty much holds my hand and is very detailed. I've searched the : net for a while now, and all the tutorials I have found... although : simple... they don't go in-depth and move on to more advanced features. : : Any help at all will be greatly appreciated. : : -Matt : : : -- : Matt Zur : [EMAIL PROTECTED] : http://www.zurnet.com : : Need a Web Site??? - Visit... www.zurnet.com : : 1997 - 2002 - 5th Anniversary!!! : : : -- : PHP Database Mailing List (http://www.php.net/) : To unsubscribe, visit: http://www.php.net/unsub.php : : : : : : -- : Matt Zur : [EMAIL PROTECTED] : http://www.zurnet.com : : Need a Web Site??? - Visit... www.zurnet.com : : 1997 - 2002 - 5th Anniversary!!! : : : -- : PHP Database Mailing List (http://www.php.net/) : To unsubscribe, visit: http://www.php.net/unsub.php : -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Indepth Tutorial... need help.
Just one more to throw on the fire: Pretty basic tutorial that covers a lot of topics. If you buy the book, there's a little more depth. On my first day working with PHP/MySQL, I had basic pages up and running. http://www.webmasterbase.com/article/228 Incidentally, this same question was asked by a different user last week. You might want to poke around the php-db archives for some other recommendations. -Original Message- From: Matt Zur [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 9:09 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Indepth Tutorial... need help. Right well that's what I'm asking I need a tutorial and haven't found a good one. -Matt Rasmus Lerdorf wrote: Most of this stuff is actually just SQL and has little to do with PHP. So look for an SQL tutorial. From the PHP side all you need to know is mysql_connect(), mysql_select_db(), mysql_query() and mysql_fetch_row().'' All queries are sent to the database via mysql_query(). It doesn't matter to PHP if you are adding, deleting, modifying, searching, sorting, filtering, or whatever. You just put the SQL code in the mysql_query() call. -Rasmus On Tue, 3 Sep 2002, Matt Zur wrote: Can someone point me in the direction of an online tutorial for php mysql that covers the following: - Teaches me how to use php to access mysql - Creating a db that is structured to be efficient - How to add, modify, and delete records in a database - How to search for records - How to filter records - How to sort records, by a certain field, alphabetical, descending etc. - Indexes - how to create them, how to keep the updated with changes in the db a beginners look to in-depth approach. Yes I've visited PHP.net, and mysql.com. I need a dumbed down version that pretty much holds my hand and is very detailed. I've searched the net for a while now, and all the tutorials I have found... although simple... they don't go in-depth and move on to more advanced features. Any help at all will be greatly appreciated. -Matt -- Matt Zur [EMAIL PROTECTED] http://www.zurnet.com Need a Web Site??? - Visit... www.zurnet.com 1997 - 2002 - 5th Anniversary!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Matt Zur [EMAIL PROTECTED] http://www.zurnet.com Need a Web Site??? - Visit... www.zurnet.com 1997 - 2002 - 5th Anniversary!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Indepth Tutorial... need help.
For a SQL tutorial, I would recommend that you get yourself a copy of Joe Celko's SQL for smarties. Best investment I ever made. Everything you need to know is there. Bon courage! - Original Message - From: Matt Zur [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 3:08 PM Subject: Re: [PHP-DB] Indepth Tutorial... need help. Right well that's what I'm asking I need a tutorial and haven't found a good one. -Matt Rasmus Lerdorf wrote: Most of this stuff is actually just SQL and has little to do with PHP. So look for an SQL tutorial. From the PHP side all you need to know is mysql_connect(), mysql_select_db(), mysql_query() and mysql_fetch_row().'' All queries are sent to the database via mysql_query(). It doesn't matter to PHP if you are adding, deleting, modifying, searching, sorting, filtering, or whatever. You just put the SQL code in the mysql_query() call. -Rasmus On Tue, 3 Sep 2002, Matt Zur wrote: Can someone point me in the direction of an online tutorial for php mysql that covers the following: - Teaches me how to use php to access mysql - Creating a db that is structured to be efficient - How to add, modify, and delete records in a database - How to search for records - How to filter records - How to sort records, by a certain field, alphabetical, descending etc. - Indexes - how to create them, how to keep the updated with changes in the db a beginners look to in-depth approach. Yes I've visited PHP.net, and mysql.com. I need a dumbed down version that pretty much holds my hand and is very detailed. I've searched the net for a while now, and all the tutorials I have found... although simple... they don't go in-depth and move on to more advanced features. Any help at all will be greatly appreciated. -Matt -- Matt Zur [EMAIL PROTECTED] http://www.zurnet.com Need a Web Site??? - Visit... www.zurnet.com 1997 - 2002 - 5th Anniversary!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Matt Zur [EMAIL PROTECTED] http://www.zurnet.com Need a Web Site??? - Visit... www.zurnet.com 1997 - 2002 - 5th Anniversary!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Indepth Tutorial... need help.
I'd endorse SQL for Smarties, plus just about anything else JC has written on SQL. Another good book is The Practical SQL Handbook by Bowman, Emerson Darnovsky, ISBN 0-202-44787-8 For a tutorial have a look at Julie Meloni's at http://www.thickbook.com. They are single issue tutorial, aredevloped progressively and quite clear. A new user must read the section of the manual which deals with variables. The way PHP creates variables automatically can be a bit confusing to the newcomer. Hope this helps - Miles Thompson At 04:49 PM 9/3/2002 +0200, Ignatius Reilly wrote: For a SQL tutorial, I would recommend that you get yourself a copy of Joe Celko's SQL for smarties. Best investment I ever made. Everything you need to know is there. Bon courage! - Original Message - From: Matt Zur [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 3:08 PM Subject: Re: [PHP-DB] Indepth Tutorial... need help. Right well that's what I'm asking I need a tutorial and haven't found a good one. -Matt Rasmus Lerdorf wrote: Most of this stuff is actually just SQL and has little to do with PHP. So look for an SQL tutorial. From the PHP side all you need to know is mysql_connect(), mysql_select_db(), mysql_query() and mysql_fetch_row().'' All queries are sent to the database via mysql_query(). It doesn't matter to PHP if you are adding, deleting, modifying, searching, sorting, filtering, or whatever. You just put the SQL code in the mysql_query() call. -Rasmus On Tue, 3 Sep 2002, Matt Zur wrote: Can someone point me in the direction of an online tutorial for php mysql that covers the following: - Teaches me how to use php to access mysql - Creating a db that is structured to be efficient - How to add, modify, and delete records in a database - How to search for records - How to filter records - How to sort records, by a certain field, alphabetical, descending etc. - Indexes - how to create them, how to keep the updated with changes in the db a beginners look to in-depth approach. Yes I've visited PHP.net, and mysql.com. I need a dumbed down version that pretty much holds my hand and is very detailed. I've searched the net for a while now, and all the tutorials I have found... although simple... they don't go in-depth and move on to more advanced features. Any help at all will be greatly appreciated. -Matt -- Matt Zur [EMAIL PROTECTED] http://www.zurnet.com Need a Web Site??? - Visit... www.zurnet.com 1997 - 2002 - 5th Anniversary!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Matt Zur [EMAIL PROTECTED] http://www.zurnet.com Need a Web Site??? - Visit... www.zurnet.com 1997 - 2002 - 5th Anniversary!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Indepth Tutorial... need help.
These should be helpful: http://zc8.net/zc8/shownews.php?articleid=93 http://zc8.net/zc8/shownews.php?articleid=95 http://zc8.net/zc8/shownews.php?articleid=98 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Indepth Tutorial... need help.
I must concur, Chapters 28 29 are worth the price of the book! =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Ignatius Reilly [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 03, 2002 9:49 AM To: [EMAIL PROTECTED]; Matt Zur Subject: Re: [PHP-DB] Indepth Tutorial... need help. For a SQL tutorial, I would recommend that you get yourself a copy of Joe Celko's SQL for smarties. Best investment I ever made. Everything you need to know is there. Bon courage! - Original Message - From: Matt Zur [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 3:08 PM Subject: Re: [PHP-DB] Indepth Tutorial... need help. Right well that's what I'm asking I need a tutorial and haven't found a good one. -Matt Rasmus Lerdorf wrote: Most of this stuff is actually just SQL and has little to do with PHP. So look for an SQL tutorial. From the PHP side all you need to know is mysql_connect(), mysql_select_db(), mysql_query() and mysql_fetch_row().'' All queries are sent to the database via mysql_query(). It doesn't matter to PHP if you are adding, deleting, modifying, searching, sorting, filtering, or whatever. You just put the SQL code in the mysql_query() call. -Rasmus On Tue, 3 Sep 2002, Matt Zur wrote: Can someone point me in the direction of an online tutorial for php mysql that covers the following: - Teaches me how to use php to access mysql - Creating a db that is structured to be efficient - How to add, modify, and delete records in a database - How to search for records - How to filter records - How to sort records, by a certain field, alphabetical, descending etc. - Indexes - how to create them, how to keep the updated with changes in the db a beginners look to in-depth approach. Yes I've visited PHP.net, and mysql.com. I need a dumbed down version that pretty much holds my hand and is very detailed. I've searched the net for a while now, and all the tutorials I have found... although simple... they don't go in-depth and move on to more advanced features. Any help at all will be greatly appreciated. -Matt -- Matt Zur [EMAIL PROTECTED] http://www.zurnet.com Need a Web Site??? - Visit... www.zurnet.com 1997 - 2002 - 5th Anniversary!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Matt Zur [EMAIL PROTECTED] http://www.zurnet.com Need a Web Site??? - Visit... www.zurnet.com 1997 - 2002 - 5th Anniversary!!! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
