MYSQL

MYSQL PHP WEB DEVELOPMENT

How to Create PHP login with Remember me Function

Remember me function is used to save the username and password in login form  entered by the user. In this tutorial we are using COOKIES for saving preserving username and user password in the login from. Step 1 :  Create a simple html form

Step 2 : Create a SQL table tbluser

Step 3 : Create database configuration […]

MYSQL

How to Create Altering tables in MySql

The format of an existing database table can be changed with an ALTER TABLEquery . This query can make a single alteration or specify as number of alterations as comma-separated list. In the ADD COLUMN and DROP COLUMN examples the COLUMN  keyword is optional- it is what the manual calls “a pure noise word” that is only there to aid readability. An ALTER TABLE […]

MYSQL

How to Create database, Table and Managing MySQL Database using phpMyAdmin

phpMyAdmin is a tool for managing MySQL database and free of charge, it’s a web base tool. This tutorial you’ll learn how to create database, create table include export(backup) MySQL database. phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter […]

Fetch Data in Excel or Generate Excel file in PHP
CSS DEMOS HTML MYSQL PHP PHP PROJECT

How to Fetch Data in Excel or Generate Excel file in PHP

File structure for this tutorial : config.php (database connection file) index.php (For fetching data ) genrate-excel.php (For genrating excel file) Create a sql table tblemployee. Structure of sql table employe .

Now insert some data into this table.

Index.php in this file we will  read the data from database.

genrate-excel.php in this […]

CSS DEMOS HTML MYSQL PHP PHP PROJECT WEB DEVELOPMENT

Creating a web chat with PHP and MySQL

In this Tutorial, I’ll show you how you can write your very own web-based Chat App using HTML, CSS, JavaScript/jQuery, PHP and MySQL. For a full functioning Web-Chat we’ll need three basic components: A Client-Side HTML Document that sends the Chat Text and receives Data from the database A PHP file which writes user input […]