1st PHP, My SQL Project : Blue Prints

Wednesday: 06, Nov, 2013:

/* This section was for Front End */
I created style sheet file and ads my rule.
I checked every piece of code and its different results in Chrome. Chrome is good for codes checking. with F12 Feature => Chrome DevTools.
I started my project with tables. That I can easily make my mind for it.
I created front end 1st of all, with public.css file.

/* This Section was for Back End */
I created a 3 folders in main directory.

1. includes
2. stylesheets
3. images 
4. javaqueries

I created constants.php file.
I created connection.php file
I created header.php file
I created footer.php file
I created functions.php file

These was separate files. I divided this project in parts.

Wednesday: 07, Nov, 2013:

/* Server Side Work */
Today I worked on #MySql Database. I created widget_corp database and create 3 tables,
Subjects Table
Pages Table
Users Table

I add some values in all above tables. Like
For Subject:

1. ID
2. Name
3. Position
4. Visible

For Pages:

1. ID
2. Name
3. Subject_id (Subject_id is related to subject table id)
4. Position
5. Content

Now I added some values in Pages

/* Back End PHP working */
/* Navigation Work */
Now I need work on navigation. I write a query and call this query in ascending order by position.
then I add a while loop and call to subjects in navigation.
Then i write a query for pages and call them order by position.
then I add an other while loop within pages tags and call them by subject_id.

Saturday: 09, Nov, 2013:
/* Navigation Work */
I worked on bold option. I fetching data from SQL.
I worked on URL : that i can fetch data from there.


/* Body Parts */
I converted all data to functions that i can use variables properly.
Now I create php page for create subjects and create pages.
I am working on that now.