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

MINI PROJECT

How to create a simple dynamic website with PHP and MySQL

Why simple website project with php and mysql? In this mini project you will learn how to connect your database (mysql) with php, setup an html template, make header, footer, dynamic sidebar, fetch title, content, meta tags, meta description for dynamic web pages (individual pages). You can manage these web pages form the manage site area which […]

CSS HTML

Fancy Neon Text Effects with CSS3

Did you ever want to create fancy neon effects? No? Well…to bad I’ll explain how to create them anyways. Neon text mostly is achieved by using the CSS3 property “text-shadow” on multiple layers and a saturated colour, as well as some animations to look more realistic. Live Example The most important are the “text-shadow” – […]

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

DEMOS PHP WEB DEVELOPMENT

How to create pagination in PHP

File structure for this tutorial : config.php (Database configuration file) index.php (Main file) tbluser.sql (SQL Table structure with dummy data) First create a table tbluser. Sturcture of tbluser :

Insert some data into this table. We will use LIMIT clause for generating pagination.LIMIT clause uses two arguments one is OFFSET  and second one is the number of records return from […]