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!
Please help with Social Network development in php
Moderator: General Moderators
Re: Please help with Social Network development in php
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 )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.
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).
Re: Please help with Social Network development in php
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.
Could u also know information on the best way i could get relationships between objects like users, blog posts, comments. Otherwise thanks again.
Re: Please help with Social Network development in php
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.
If you use innodb foreign keys it also helps keep data consistent.
Re: Please help with Social Network development in php
okay i'm on it!!!