LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices

Reply
 
Search this Thread
Old 11-20-2006, 06:04 AM   #1
Islanders
LQ Newbie
 
Registered: Nov 2006
Posts: 2

Rep: Reputation: 0
Learning Php/mysql Fast


Database driven sites seem to be the way to go. I have sites of my own and clients' that would really benefit from this. I haven't had time to learn Php/MySql, have found no ready made solutions to buy and there are no experienced developers in my area - I've not been impressed with any sites I've seen for Irish web developers (and don't know where to start on the rest of the net).

Any recommendations on good tutorials?

Any recommendations on a source for developers?

Projects in the works: web directory; content management with multiple users; property; portal...

I have a ""how-to"" book, that is about a foot thick, but can't imagine that I'll be able to learn this without spending every day and night for the next three months working on it.

I'm not completely thick. I picked up HTML really quickly - does this seem hard because I've never done any programming before?

_____________________________________________________________
Wedding | Out of Body Experience
 
Old 11-20-2006, 06:45 AM   #2
vharishankar
Senior Member
 
Registered: Dec 2003
Posts: 3,142
Blog Entries: 4

Rep: Reputation: 121Reputation: 121
Ultimately you just need to start coding before you'll really get confident. Try simple PHP exercises first and then build up to using files, MySQL and other data manipulation stuff.

I find the easiest way is to use the PHP manual as the language structure is really very simple and doesn't require any learning if you have prior programming experience.

http://www.php.net/manual/en/

That is really all you need. How you create non-trivial working applications is not really something you can learn from books or tutorials. It's something you need to learn on your own through experience and there is no shortcut way to learn how to write a portal or a CMS in PHP etc.

On the other hand, there are plenty of free, ready-made scripts in PHP available for those who want a solution without wasting time and you can find plenty of them here with online demos as well:

http://www.opensourcecms.com/

If you're looking to build dynamic websites of different kinds you might find one of those scripts to fit your needs rather than doing everything yourself.

Good luck!

Last edited by vharishankar; 11-20-2006 at 06:48 AM.
 
Old 11-20-2006, 10:32 AM   #3
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
This book: http://www.bookpool.com/sm/0596005431

Is pretty good or a good way to get started. I'd recommend to really dive in is to also download an existing application like harishankar pointed out from like opensourcecms.com and see how they do things, work, etc.

Then you can either build off a template/application you like or use it as an example to build your own.
 
Old 11-20-2006, 12:50 PM   #4
introuble
Member
 
Registered: Apr 2004
Distribution: Debian -unstable
Posts: 700

Rep: Reputation: 31
Quote:
Learning Php/mysql Fast
Why are you so sure *you can* do this? [or that *anyone can* do this]

Quote:
I'm not completely thick. I picked up HTML really quickly
Not trying to burst your bubble but.. learning a programming language might not be as easy as learning something like HTML.

A piece of advice: if you're going to create real-world application on PHP/MySQL.. I think it'd be best to have a pretty good grasp of the two.. or your programs might suffer from a lot of bugs, and most likely security problems. If you want to do a job, why not do it right. Why do a job just so that you can say you've done it?
 
Old 11-20-2006, 02:53 PM   #5
slantoflight
Member
 
Registered: Aug 2005
Distribution: Smoothwall
Posts: 283
Blog Entries: 3

Rep: Reputation: 35
Quote:
Originally Posted by introuble
If you want to do a job, why not do it right. Why do a job just so that you can say you've done it?
Well for the money ofcourse. If you can't make it good, make it look good. Developing for quality, is a waste of time. Besides its just another web app.
 
Old 11-20-2006, 03:09 PM   #6
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
Quote:
Originally Posted by slantoflight
Well for the money ofcourse. If you can't make it good, make it look good. Developing for quality, is a waste of time. Besides its just another web app.
That's not a good way to make anything. Quality over looks is a better approach, especially when it involves software and code.

Microsoft for example, went for the "looks" over quality and look where it got them, a crappy OS open to security vulnerabilities. Sure they have tons of money but their also the laughing stock of the IT world, well, from a *nix admins perspective.

Think before you speak or you just make yourself look stupid!
 
Old 11-20-2006, 03:14 PM   #7
craigevil
Senior Member
 
Registered: Apr 2005
Location: OZ
Distribution: Debian Sid
Posts: 4,733
Blog Entries: 12

Rep: Reputation: 456Reputation: 456Reputation: 456Reputation: 456Reputation: 456
http://www.sqlcourse.com/
http://www.w3schools.com/sql/default.asp

http://www.w3schools.com/php/default.asp
http://www.php.net/tut.php

Learn to do it the right way or don't bother.
 
Old 11-20-2006, 03:19 PM   #8
slantoflight
Member
 
Registered: Aug 2005
Distribution: Smoothwall
Posts: 283
Blog Entries: 3

Rep: Reputation: 35
Quote:
Originally Posted by trickykid
Think before you speak or you just make yourself look stupid!
...

Well apparently thinking does'nt guarantee anything.
 
Old 11-20-2006, 03:42 PM   #9
Dragineez
Member
 
Registered: Oct 2005
Location: Annapolis
Distribution: Ubuntu
Posts: 275

Rep: Reputation: 32
What Is Sarcasm?

slantoflight's comment was, I think, a bit "tongue in cheek". As per usual, his sarcasm points out a nasty, obvious, and all too common truism. Being first to market is a quality all its own that subjugates meticulous engineering in favor of expediency. I'm quite sure he doesn't really believe in it.
 
Old 11-20-2006, 03:58 PM   #10
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
Quote:
Originally Posted by Dragineez
slantoflight's comment was, I think, a bit "tongue in cheek". As per usual, his sarcasm points out a nasty, obvious, and all too common truism. Being first to market is a quality all its own that subjugates meticulous engineering in favor of expediency. I'm quite sure he doesn't really believe in it.
I only made such comments cause the OP seems to be asking a real question, looking for serious answers. When someone comes along and jokingly adds their two cents and might not be serious, what's the point then? Our rules state, post constructively or don't post at all. I didn't necessarily find some of the responses constructive and they make some look stupid in their response.

There are times to be sarcastic, most of those threads are obvious, other times people come here for real help, either help them or move along to the next post is my thought.

Now lets move on!
 
Old 11-23-2006, 11:09 AM   #11
introuble
Member
 
Registered: Apr 2004
Distribution: Debian -unstable
Posts: 700

Rep: Reputation: 31
I was being serious in my previous post.
 
Old 11-24-2006, 12:02 AM   #12
TongueTied
Member
 
Registered: Aug 2003
Distribution: SuSE 8.1 pro
Posts: 94

Rep: Reputation: 15
I picked up "PHP and MySQL for Dynamic Web Sites" by Larry Ullman and it worked really well. It doesn't go on and on with really complicated examples but it does get you started really quickly to the point where you don't need a book or instructions anymore and only need reference sites. It's not very expensive, easy to read and set up so you can skip past things if you don't want to go through all the steps. I've lent my copy to a few people now and they have all come back saying it gave them enough php to get them up and running.

A friend here has suggested that rather than learn php, it might be more useful to learn Ruby instead. I have never looked at Ruby but understand it is not very difficult either.
 
Old 11-30-2006, 12:00 AM   #13
Micro420
Senior Member
 
Registered: Aug 2003
Location: Berkeley, CA
Distribution: Mac OS X Leopard 10.6.2, Windows 2003 Server/Vista/7/XP/2000/NT/98, Ubuntux64, CentOS4.8/5.4
Posts: 2,986

Rep: Reputation: 45
10-minutes is all you need, according to this book. LOL

http://www.amazon.com/Sams-Teach-You...e=UTF8&s=books

http://www.amazon.com/Sams-Teach-You...e=UTF8&s=books
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: O'reilly Releases "Learning PHP & MySQL": A Step-by-Step Guide to ... LXer Syndicated Linux News 0 06-21-2006 06:33 AM
learning php speel Programming 9 05-20-2005 10:16 PM
Apache Mysql Php: mysql with php doesn't work breakerfall Linux - Networking 6 12-27-2003 08:59 PM
Learning MySQL. Know a good forum? cevjr Linux - Software 3 12-09-2003 02:17 AM
Learning PHP Config Programming 3 08-16-2002 03:06 PM


All times are GMT -5. The time now is 03:26 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration