SQL

How to Convert SQL Database into Excel File (*.xlxs) in PHP

Submitted by Mr.Niemand03 on
In this tutorial, we will convert sql to excel using PHP. This code will read all data from an SQL table then add it into an excel file using a class called "xlsxwriter.class.php". You can download the class using this link from Github Things to do You have to download and install XAMPP or any local server that run PHP scripts. In my case I used XAMPP as my local server, here's the download link

How to Get the Average of One Column in MySQL Database using PHP

Submitted by nurhodelta_17 on
This tutorial tackles on how to get the average of one column in mysql database using PHP. There are instance that we wanted to get the average of one column for reporting purposes like average sales, expenses etc. Normally, we get the sum of the column then we divide it by number of rows but actually there is a sql function that determines the average of one column.

How to use SQL Limit to Limit Results in PHP/MySQLi

Submitted by nurhodelta_17 on
The use of limit limits the number of results of your MySQL Query and is usually at the last part of your SQL. This is most applicable if for example, you want to get the top selling product, you just need to order the result then limit it by 1. This tutorial will teach you how to use this limit. Note: Bootstrap CSS and script used in this tutorial are hosted, therefore, you need internet connection for them to work.

Creating our Database

First step is to create our database. 1. Open phpMyAdmin. 2.

Attractive Login Form

Submitted by abracadabra1769 on
This is a Simple Login webpage with attractive template. Create an database Database Name : site Remember Small 's' Create a table name login and then input the username and password into the value inside table. Note, For security purpose When inserting the password value use function "MD5" THE ABOVE STEP IS COMPULSORY Then run and use this code in your project. Thanks & abracadabra

Online Art Gallery

Submitted by Swapnil R. Joshi on

Artbeat is online shopping website which displays art products. Website Contains shopping cart and category wise gallery. It also provides admin login with the add product and delete product compatibility. Provides user login and password management. Admin reports are not included in this version. Technologies :- Asp.Net with c#, Sql database, Bootstrap3.

Simple Dynamic Web Site

Submitted by Chinthaka Deshapriya on
Welcome --------------- Hi Guys! I am Chinthaka Deshapriya from Sri Lanka. I am going to give some valuable source code for beginners of dynamic web developers. Installation ---------------- 01. Extract all content into your host. 02. Create New Database Name "maindb" 03. Import Database from your content in DB folder. Fine! It will work well. Good Luck!

Creating a Database in SQL Server and Connect it to Visual Studio

Submitted by donbermoy on
In this tutorial, I will teach you how to create a database in SQL Server using the Microsoft SQL Server 2008 and Connect this database in the Visual Studio 2010. So, now let's start this tutorial! 1. Open the SQL Server Management Studio for the first step on creating a database. design 2. Right Click on the Database Folder and then click New Database. design 3. Create a database name, input a name on it.
Subscribe to SQL