Please help with Social Network development in php

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
realnsleo
Forum Newbie
Posts: 15
Joined: Sat May 16, 2009 12:08 pm

Please help with Social Network development in php

Post by realnsleo »

Hi everyone,
i'm an intern work for a government organization in my country and in a recent meeting they discussed a way in which they can merge certain institutions country wide into some kind of online network where they can share thoughts, views and much more and i thought to myself why not some kind of social network?
I'm in love with software development and web programming esp in php, ajax, python, css, javascript and much more and i would love to start coding this social network.
I would love to know where i can get information on how i can start this journey. I would love to know information on how i can structure the mysql database, how i can map relationships between data, basically i want to know enough to get me going.
as i begin i will open up a site where i can share what i have done sofar.

Thanks alot!
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: Please help with Social Network development in php

Post by josh »

realnsleo wrote: I would love to know information on how i can structure the mysql database, how i can map relationships between data, basically i want to know enough to get me going.
I could recommend this. It doesn't touch on mysql, but it talks about good naming skills (which gives you the common sense you'll need to design good databases, sort of )

http://www.amazon.com/Clean-Code-Handbo ... 0132350882

I'm assuming you read up normalization (first form, second form, etc..).

Just keep that in mind and don't make normalization a means to an end, de-normalizing is just as useful sometimes (performance).
realnsleo
Forum Newbie
Posts: 15
Joined: Sat May 16, 2009 12:08 pm

Re: Please help with Social Network development in php

Post by realnsleo »

Thanks josh! i am downloading it right now!
Could u also know information on the best way i could get relationships between objects like users, blog posts, comments. Otherwise thanks again.
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Re: Please help with Social Network development in php

Post by josh »

In the database? You store the id of one record, as a column in the other table (called a foreign key). In the code? You'd use SQL. You could also use an "orm framework" which stands for "object relational mapper". Google that.

If you use innodb foreign keys it also helps keep data consistent.
realnsleo
Forum Newbie
Posts: 15
Joined: Sat May 16, 2009 12:08 pm

Re: Please help with Social Network development in php

Post by realnsleo »

okay i'm on it!!!
Post Reply