This tutorial goes over an inner join SQL query and extending the basic blog from tutorial 10 to have a link to a single-post page.
First of all, I am basing this tutorial on the last tutorial(10), which established a basic blog. Here we are going to compound the original statement that looks like SELECT * FROM posts ORDER BY date DESC
What we are trying to do however, is to remove the statement that looks like "SELECT postname FROM users WHERE ID = ”.$row['username']
and preserve the information on “Who posted it.”
The Second objective of this tutorial is to simply make the titles of the blog posts linked to a page that shows that post exclusively.
Here is Part 1 out of three, please watch all in their entirety so that you may understand them to the fullest.
Part 1:
Click on Read More to view the sources along with Part 2 and 3 of the video Read more…
Here’s a start for beginner web programmers: a Blog which will evolve into not only A blog, but a content management system. Alas, we need a beginning. This tutorial first starts with setting up our blog system. This blog system is designed in a way that can be expanded for future tutorials for real application.
Here’s the first video, Part 1:
Please click read more to see the sources, and part 2 and 3. Read more…
I wasn’t dead, nor have I given up on these tutorials. You know what gets in the way of our goals, Life. I turned legal age, I graduated from High School, and I moved, all within the same period of time. I’m still dealing with the moving part, but I now have a summer of time to make tutorials for PHP while I study Regular Expressions and Java.
So, here comes the good news:
I have many open days in which I should have time to release maybe even 2 tutorials a day. The problem: I need ideas. I have a couple ideas, but I’m pretty sure I’ll run out quickly.
I have so far ventured into where it comes to creating solutions and not as much into use of certain defined functions anymore. Sort of hard to use only one major function in something I guess!
Which also comes where I am thinking of redoing some of my first tutorials over again(now that I have better experience with the whole process), even if I don’t get any replies, I’ll still redo them. I want a good full series. Read more…