Splitting MySQL Results Into Two Columns Using PHP

Sometimes, the MySQL output result is too large to display in a single column on a web page, and that's why the best solution is to divide the data into two columns. In this post, we provide a simple solution to divide the MySQL result sets into two columns using the PHP programming language.

Divide Large Data Into Two Columns Using PHP

Suppose we have Indian states record, you can create a states table and copy this code in the database or use your existing records.


INSERT INTO `states` (`id`, `state`) VALUES
(1, 'Andaman and Nicobar Islands'),(2, 'Andhra Pradesh'),(3, 'Arunachal Pradesh'),(4, 'Assam'),
(5, 'Bihar'),(6, 'Chandigarh'),(7, 'Chhattisgarh'),(8, 'Dadra and Nagar Haveli'),
(9, 'Daman and Diu'),(10, 'Delhi'),(11, 'Goa'),
(12, 'Gujarat'),(13, 'Haryana'),(14, 'Himachal Pradesh'),
(15, 'Jammu and Kashmir'),(16, 'Jharkhand'),(17, 'Karnataka'),
(18, 'Kerala'),(19, 'Lakshadweep'),(20, 'Madhya Pradesh'),
(21, 'Maharashtra (Mumbai)'),(22, 'Manipur'),(23, 'Meghalaya'),
(24, 'Mizoram'),(25, 'Nagaland'),(26, 'Orissa'),(27, 'Pondicherry'),
(28, 'Punjab'),(29, 'Rajasthan'),(30, 'Sikkim'),(31, 'Tamil Nadu'),
(32, 'Tripura'),(33, 'Telangana'),(34, 'Uttaranchal'),(35, 'Uttar Pradesh'),(36, 'West Bengal');




Now, let's create a PHP file name 'state.php' and copy and paste the given code. Please make sure to replace the 'host', 'username', 'password' and 'databasename' with yours.

<html>
    <head>
        <title>Simplest way to divide data in two columns using PHP</title>
        <style type="text/css">
            table{ border: 2px solid deepskyblue; width: 30%; }
            tr{ width: 15%; }
            table tr:nth-child(odd){ background-color: lightskyblue;}
            table tr:nth-child(even){ background-color: lightgray;}
        </style>
    </head>
    <body>
    <?php 
        $conn = mysqli_connect('hostname', 'username', 'password', 'databasename');// connect to your host
        //Check for connection error
        if(mysqli_connect_error()){
         die("Error in DB connection: ".mysqli_connect_errno()." - ".mysqli_connect_error());
        }
        $select = "SELECT * FROM `states` ";
        $result = mysqli_query($conn, $select);// Select query to fetch data
        if(mysqli_num_rows($result)){
        echo "<table width='70%' >";
        $i = 0;
        while($row = mysqli_fetch_object($result)){
            $states = $rows->state;
            if($i % 2 == 0){
                echo '<tr>';
            }
            echo '<td>'.$states.'</td>';
            if($i % 2 == 1){
                echo '</tr>';
            }
            $i++;
        }
        echo "</table>";
         }
    ?>  
    </body>
</html>

The above code divides the state data into two columns as shown below.





Related Articles

Preventing Cross Site Request Forgeries(CSRF) in PHP
PHP code to send email using SMTP
Simple pagination in PHP
Simple PHP File Cache
PHP Connection and File Handling on FTP Server
CRUD operations in Python using MYSQL Connector
Windows commands to Create and Run first Django app
How to send emojis in email subject and body using PHP
PHP7.3 New Features, Functions and Deprecated Functions
Create pie chart using google api
How to display PDF file in PHP from database
How to read CSV file in PHP and store in MySQL
Create And Download Word Document in PHP
PHP SplFileObject Standard Library
Simple File Upload Script in PHP
Sending form data to an email using PHP




Read more articles


General Knowledge



Learn Popular Language