php

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

ROTC Enrollment System

Submitted by darkzniper on
Simple ROTC Enrollment system , I want to share this Enrollment system using PHP,HTML,CSS, Boostrap . Here you can enroll a student and view all by type. In this system already filter by Semester .You can learn easily . 1. Create Database - rotc 2. Upload the sql on sql folder. 3.done -Default Username: admin Password: admin

User Registration and login System in Codeigniter .

Submitted by ranjit1 on
In this tutorial you will be able to know how to make User Registration and login System in Codeigniter . System Requirement to run CI: Xampp server or Wamp server . Any Browser Google chrome,Firefox,Opera,Safari.. etc. Php editor you can use Dreameaver,Notepad,Wordpad if you are using mac you can use textmate, or other compatible with your computer,for me i recommend Dreamweaver to easily fix the

Add,Edit and Delete Using CodeIgniter.

Submitted by ranjit1 on
In this tutorial you will be able to Add,Edit and Delete Data Using CodeIgniter. System Requirement to run CI: Xampp server or Wamp server . Any Browser Google chrome,Firefox,Opera,Safari.. etc. Php editor you can use Dreameaver,Notepad,Wordpad if you are using mac you can use textmate, or other compatible with your computer,for me i recommend Dreamweaver to easily fix the error if they have. This