PHP Tutorials By Kloplop321

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:

• Make a page for posting
• Make a form
• Get the SQL for inserting
• Prepare and validate data
• Test page functionality
• Finalize and clean up

Part 1:

Make sure to click on Read More so that you may see Part 2 and the sources.
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…

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!

Read more…

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…

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…

Want to dump your database? This video goes over the export feature of PHPMyAdmin which allows you to create and save file dumps of your database. You can use these dumps to make a duplicate database or update a pre-existing database. Or simply to backup regularly in case of database failure. I also marginally go over importing and how to import.