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 […]

CSS HTML MYSQL PHP WEB DEVELOPMENT

Contact form with mail function and Storing data in the database

Contact form with mail function and Storing in the database project has two module : User Module admin Module User Module Sql table structure for tblcontactdata table where we will store our data

Now create a HTML for user inputs. index.php

MYSql database connection

Insert Data into Database

HTML JAVASCRIPT MYSQL PHP

User registration and login using PHP

elcome friends in this tutorial we will learn user registration and login using php stored procedure. File structure for this tutorial  config.php  index.php  check_availability.php  login.php  welcome.php  logout.php Structure of sql table tblregistration

config.php Create db configuration file using mysqli extension. Provide credential as per your configuration

*****Note if you declared a password variable […]

HTML MYSQL PHP

How to insert data into MySql using PHP

  In this tutorial i will explain how to insert data into MySql using PHP. [aio_button align=”none” animation=”none” color=”red” size=”small” icon=”play” text=”View Demo” target=”_blank” relationship=”dofollow” url=”https://phpgurukul.com/demos/mysqlinsert/”] First Create a database with name demo. Now create a table with name data. Here the strcuture of table

Code for mysql connection with php

Create a HTML Form for user inputs

Now get […]