MYSQL

Introduction: This tutorial is on how to allow our users register via their unrecognised IP (Continued from http://www.sourcecodester.com/php/7539/auto-recognise-users-ip-address-through-phpmysqli.html). Important: I highly recommend that you read through the linked tutorial above, it will allow you to get the same source I am going to be using throughout this tutorial! Validation: So before we

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

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

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

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

Introduction: This tutorial will be running off a tutorial found here (http://www.sourcecodester.com/php/7510/retrieving-data-mysqlphp.html) and will be showing you how to sort retrieved data. An example of how this could be used is in the leaderboards of a game. Table Modifications: First I need to modify my table from the previous 'Retrieving Data' tutorial. I am going to add a second column

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

This Payroll System is the project of the third year bachelor of Science in Information Technology students of Kabankalan Catholic College for their Software Engineering subject. It is made up of Visual Basic 2008 and MySQL for their database. It also generates reports using the Crystal Reports. This system contains the following features: Log In and Log Out. Payroll (adding, listing and searching

This is an Advanced Web Store of Dadad's Merchandising, a food establishment providing food ingredients. This is designed like the lazada.com as having the shopping cart and an online ordering system. The features of this system are the following: - order product online - add, edit, delete product - shopping cart designed - search product in home tab - send order confirmation via email - manage

This is a simple project that will teach you how to create a comment box. In this project, I used a little JQuery Ajax method like what I have done in my recent post, Chat Box. I made this just to give you a little idea on how a comment box is done. Hope you can learn from this project.