Webcodez – The database of web programming tutorials

Users Online ( Part 1 & Part 2 )

Part 1 In this tutorial we’ll be creating a users online system which shows the current users online on a certain page. This can be done either by using files to save the data in or database. We’ll be using the second method to save the user online data: a database ( -table ). So let’s [...]

Continue reading...

Basic Login System

In the previous tutorial we’ve been making a register system. In this tutorial we’ll be creating a login system for it, where members can login to your website and for example get access to a members area of your website. We’ll basicly be using SESSION variables in this tutorial to save the login session of [...]

Continue reading...

Basic Register System

In this tutorial we’ll be creating a register system in which people can create their own account. It’s a basic register system which uses some mysql functions to insert data into the database (create the account), loops and some PHP functions to handle the POST variables. We’ll start creating our register page with a form [...]

Continue reading...

MySql Basics – Retrieve Data

To retrieve data from a table of the database, we can use the mysql SELECT query. As discussed in the previous chapter, we use the mysql_query function to interactwith the database ( insert/retrieve data ). Although we’re now not going to INSERT data into the database but we’ll be using the SELECT type of query [...]

Continue reading...

MySql Basics – Insert Data

To insert data into the database, mysql queries are used. There are multiple types of mysql queries. The one to put data into the database is the INSERT query. This one inserts a new row into the database which requires the fields of a row for that table to be given a value to. A basic [...]

Continue reading...