PHP

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.

School Management System (ERP)

Submitted by aroxsolution on
AROX School ERP is a web based school management system that enables school to use and operate many of integrated interrelated modules and manages the administration of school efficiently. Due to its ever growing and competitive nature, the education sector has always been in need of a quality solution to manage and serve the school resources efficiently. It sector is giving number of solutions to

How to Limit Number of Items per Row in While Loop using PHP/MySQLi

Submitted by nurhodelta_17 on
In this tutorial, I'm going to show you how to limit number of item per row in while loop from MySQL Table using PHP/MySQLi. This tutorial is beneficial when you are presenting large number of items especially those that have images.

Creating our Database

First step is to create our database. 1. Open phpMyAdmin. 2. Click databases, create a database and name it as "sample". 3. After creating a database, click the SQL and paste the below code.