MySQLi

Auto Recognise Users via IP Address Through PHP/MySQLi

Submitted by Yorkiebar on
Introduction: This tutorial will show you how to quickly identify your website users through their IP. Database: First we will need a database (mine is 'fln'), a table - 'test', and columns with data. My columns are; id, int, 5 length, primary key, auto increment username, varchar, 255 length ip, varchar, 255 length The IP field does not have to be 255 characters long but it will help to avoid

Retrieving Specific Data in MySQL/PHP

Submitted by Yorkiebar on
Introduction: This tutorial is on how to retrieve specific data from a database through PHP and MySQL/MySQLi. Latest: In my latest tutorials I have shown how to retrieve all rows from a database table, how to insert data, and how to validate data. Now I will show you how to retrieve specific data through slightly more advanced queries. Database: First you will obviously need a database with table

Validating and Inserting User Data in PHP/MySQL(i)

Submitted by Yorkiebar on
Introduction: This tutorial is on how to take user input, check it against a database, and insert if it is not already present. This could be used for registration in terms of unique usernames. Database: First we need a database with one table. My database is called 'fln', table is called 'test', and it has two fields: id, int, 5 length, primary key, auto increment. username, varchar/string, 255

Inserting Data in PHP/MySQL

Submitted by Yorkiebar on
Introduction: This tutorial is going to be on how to insert data in to a MySQL table through PHP. This is in companionship with my 'How To Retrieve Data' tutorial found here (http://www.sourcecodester.com/php/7510/retrieving-data-mysqlphp.html). 'Insert': To insert data in to a MySQL table, we have to use the 'INSERT' keyword command in our query statement. Steps: First we need to create the data

Retrieving Data in MySQL/PHP

Submitted by Yorkiebar on
Introduction: This tutoral will show you how to simply retrieve data using PHP from a MySQL database. Required: Before you can retrieve the data, you must have the following: 1) A webhost or localhost. 2) A database in your MySQL service. 3) A table with data in your MySQL database. Creating a Database: To create a database in your MySQL service, simply go to the MySQL Databases feature of your

Basic SQL Syntax, Structures, Key words and Queries

Submitted by Yorkiebar on
Introduction: This tutorial is going to be covering the basic syntax of SQL queries in MySQL and MySQLi. MySQL and MySQLi...? MySQLi is an updated version of the original MySQL language. Both versions use almost exactly the same syntax although MySQLi should be used as it is more secure, updated and reliable. Query Syntax: To create a MySQL(i) query, you combine different MySQL(i) keywords together and give it the information required to parse for the necessary returned information.

Forum Tutorial - MOTD and Banning Messages

Submitted by Yorkiebar on
Introduction: This tutorial is going to be covering message of the days and banning messages. Database Setup: First we are going to set the database up ready for storing our information, create a new table named "reasons", then give it the following columns of structure: id - INT - 5 Length - Primary Key - Auto Increment (AI/A_I) use - VARCHAR - 255 Length message - VARCHAR - 255 Length additional - VARCHAR - 255 Length We are going to make the use value "motd" for Message of the Day, or "ban" for the banning message.

Forum Tutorial - User Levels #3 - Admin Privileges, Banning Users & Logging Out

Submitted by Yorkiebar on
Introduction: This tutorial is the third and final episode to the User Levels section of my Forum Creation Tutorial series. In this part, we are going to be adding banning functionality and giving the admins their privileges. Admin Privileges: This part is essentially the same as the moderator privileges part found the previous tutorial.

Forum Tutorial - User Levels #1 - Setting Up & Altering Register Functions

Submitted by Yorkiebar on
Introduction: This tutorial will be continuing my creating a forum in PHP/MySQLi/HTML tutorial series. I have received a request to implement user levels to the system, so this tutorial will be setting up the things we need, and adjusting the register script to avoid errors. The Theory: Each user will have an access level, each of which have different permissions.
Subscribe to MySQLi