php

How to Resize Image in PHP

Submitted by GeePee on
This project will show you how to resize image using php. It will let you upload images you want to resize. You have two options; either you change the image size using the width textfield or use the height textfield. If you change the width, the height will automatically change keeping it's aspect ratio. The same goes when you change the height. Hope you learn from this.

Registering Via IP (Continuation) in PHP/MySQLi

Submitted by Yorkiebar on
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

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

How To Get Dropdown List From Database

Submitted by GeePee on
This is sample project on how to get a dropdown list from the database. This project is very simple and easy to understand especially for beginners. I have one dropdown list which contains car brands. When the user choose an item from the list, it automatically display all the recorded car model under the selected brand/item. Hope you learn from this simple project.

Sorting Data in PHP/MySQL

Submitted by Yorkiebar on
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