PHP

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

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

Advanced Web Store Using PHP/MySQL

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