tutorials about creating a social network using PHP & MySQL ?

Question

Where can I find tutorials about creating a social network (like db structure, sql query samples eg.) using PHP & MySQL ? I do not need a ready script, I just want to learn how to do it..

Answer 1

Pretty hard to do one from scratch.

My opinion is that you should really break it into smaller pieces. Like, how to make a good log-in. How to keep the users into a database. What info do you need about them, what kind of social network should it be? Things like that. After you will put many many pieces together you will see the image from the puzzle and then you will wonder, what frameworks should I use to make my life easier? How will the network look like?

If you are just starting with php I don't recommend you starting with this. Learn to lurk before you leap.

Answer 2

I am not considering myself as a good PHP programmer, but I know the basic steps like creating a log-in form, uploading files eg.. I just want to know some specific things about social networking like creating friendship structures and how to query them. Let me show you something as an example of what i am looking for: http://www.communitymx.com/content/article.cfm?cid=A1A63

Answer 3

Here's what i've found so far on stackoverflow:

• http://stackoverflow.com/questions/1167149/user-actions-like-social-networks-facebook-myspace-all-big-ones

• http://stackoverflow.com/questions/1169173/best-way-to-get-friends-actions-for-a-social-network-php-mysql

• http://stackoverflow.com/questions/1443960/how-to-implement-the-activity-stream-in-a-social-network

Answer 4

i am a beginer but i desire to one day have my own social network how can this be possible please do write me if you are a programmer on [email protected]