php

In our last two articles, we discuss on how to create a registration page using mysql and mysqli extension and how to secure it using mysql_real_escape_string or mysqli_real_escape_string.

This time we will modify our code to use PDO instead of mysql or mysqli extension.

mysqli extension works differently compared to mysql extension. The 'i' stands for improved. Which means that it has some features that cannot be found in mysql extension. There are two approach in using mysqli extension. They are Object Oriented style and Procedural style. If you are migrating your old PHP file to mysqli extension, I prefer you use the procedural style. It's very easy to convert it to mysqli this way. Looking at the example in our previous tutorial.

By secured we mean that we need to sanitize the data that is passed to our script in order to secure the registration of new account or user. There are three different types of connectivity in MySQL. They are: mysql = old MySQL function mysqli = improved MySQL function pdo = using prepared statement Mysql_connect is currently not supported in PHP version 5.5.0.

In this tutorial, I’m going to discuss how to use the Twitter Bootstrap to create a table and populate this table with records from MySQL database using PHP. Using Bootstrap framework, you can save more time when working with different browsers and or devices.

In this tutorial, I'm going to show you how to create a Sign up page using the twitter bootstrap framework. Using bootstrap framework, it has a ready made piece of code and you can save time because it easy to use, fast and better. If you don’t have this framework yet, you can download it here. After downloading, create a new folder and name it as “signup”. Then save this to our local server.

This tutorial is a continuation of our project called “How to Create a Social Networking Site Tutorial”. At this time we’re going to focus on creating login-logout system in a secure way using session. Logging in or signing in or on is the process by which individual access to a computer system is controlled by identifying and authenticating the user through the credentials presented by the user. To start in this tutorial, let’s create first a new PHP file called “session.php”. Then save it inside the inludes folder.

In this course we will focus on how to INSERT data using PHP into MySQL Database. When inserting data into Mysql Database tables we need to remember the names and types of table columns. For example if you set your field as the name of the person so as expected you must insert string value or if you are referring into the age of a person meaning you need to enter a numeric value.