This tutorial in essence goes over implementing posting and inserting data into a database, along with data validation for the blog. This one also extends on Tutorial 10, 11, 12, so please check those out if you have not.
Here’s the plan:
Part 1:
Make sure to click on Read More so that you may see Part 2 and the sources.
Read more…
Tags: blog, cms, coding, data, insert, PHP, posting, SQL, sql insert, Tutorial
This tutorial goes over implementing a log in system into the basic blog from tutorial 10/11. The goal is to use a session, a form, and a few pages to log in, log out, and of course, setting up future tools for the blog administration that will be shown in future tutorials.
You may refer to Tutorial 8(Login Concept) as we go though this tutorial.
Part 1:
Make sure to click on Read more so that you may see Part 2 and the sources(including downloads)!
Read more…
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…
This tutorial goes over the concept of uploading files, and keeping records in a MySQL database.
So lets try this
When: I need to upload files and keep long term records on who uploaded and where it is.
Why: I don’t know, you make up the reasons.
What: Exactly do you need to keep record of? Time, who sent it, where is it?
Who: Depends on how you implement
Where: On the Internet!
How: I’ll show you.
There are two parts, so pay attention closely. (The last part is always the most important) Don’t forget to see more of this post for the sources and part two!
Tags: copy, create, css, database, db, directory, file, files, insert, ip information, list, move, MySQL, PHP, records, select, server, SQL, upload
This tutorial goes over the concept of a log in system with MySQL with sessions. (The sources are provided after the jump)
One of my viewers sent me a message on youtube requesting this great example
Dear kloplop321,
I really want to make a php, mysql based game. I have an idea about how I am going to do it. I would just really love some help with the SESSION login. There are tutorials on the internet but I find that they don’t show the full code or stuff like that. So if you would please create a tutorial on it I would apprecitate it. Thanks.
This tutorial naturally has the sources provided.
The following videos(2) go over the concept of a login system in PHP while using sessions(to maintain the login status) and MySQL(a database that holds the information). I first go over how to make
Again: this tutorial is pretty much a walk-through in concept of a mysql login system.
Part 2 (the most important) and the sources after the jump.
Read more…
Tags: login, MySQL, PHP, PHPMyAdmin, sessions, validation
This is pretty much a basic “How to” for making a very basic guestbook that uses a database instead of text. I go over everything from making the database to the table, the html form and actual posting. If you watch this video you will pretty much see the basic idea of what a guestbook is, how they work, and how to make a basic one yourself.
This video has two parts, so to understand fully, please watch both.
Part 2 and the source after the jump
Read more…
Tags: basic, guestbook, guide, howto, MySQL, PHP, PHPMyAdmin, script, SQL
I’ve decided to record how to make complete solutions for a certain problem from a High School programming competition, and the solution for it.
The problem: You are to write a program which will input a positive integer n and output the number of
divisors of n and the sum of those divisors. (Note: by divisor we mean a positive integer
divisor this includes 1 and n.)
Source code after the jump
Read more…
Tags: command line, competition, integer, modulo, numbers, PHP, problem
Developers often use the handy features included with databases to create solutions in PHP for what ever needs to be satisfied. Databases have functions like quickly matching data to Identifications, searching large sums of data, holding user information and much more that developers can utilize. There are many ways to use a database, or in this case, to interface with a database. Most databases use a rough standard of a Structured Querying Language, which is like code that the SQL server or application interprets. Read more…
Tags: create database, create table, insert, MySQL, PHP, PHPMyAdmin, SQL, sqlite, update