PHP MySQL ROUND() Function

In this article, we are going to see how MySQL ROUND() function works in PHP. The MySQL ROUND() function is used to round a number to specified decimal places. If no specified decimal places is provided for round-off then it rounds off the number to the nearest integer.

Syntax :

ROUND(X, D)

SELECT ROUND(column1), ... ROUND(column n)
from TABLE;

Here, we are taking the student database to perform round() operation.

Requirements:

• XAMPP Server

PHP is a server-side scripting language that communicates with MySQL to manage the databases. MySQL is an open-source relational database management system (RDBMS). MySQL is developed, distributed, and supported by Oracle Corporation.

Database Table Screenshot:

MySQL Query to Round-off parent_salary:

SELECT parent_salary, ROUND(parent_salary) FROM student;

Result:

Parent salary : 50000 — rounded to : 50000 Parent salary : 25000.8 — rounded to : 25001 Parent salary : 10001 — rounded to : 10001 Parent salary : 50000 — rounded to : 50000 Parent salary : 50000 — rounded to : 50000 Parent salary : 89000.1 — rounded to : 89000

MySQL Query to Round-off Student Marks:

SELECT name, ROUND(percentage) FROM student;

Result:

Student name : ojaswi — percentage : 79 Student name : sravan kumar — percentage : 98 Student name : bobby — percentage : 80 Student name : ojaswi — percentage : 79 Student name : rohith — percentage : 89 Student name : gnanesh — percentage : 69

Approach:

• Start the XAMPP server.
• Open phpMyAdmin database manager and create a database named test.
• Create a table named student inside the test database.
• Insert the student’s records into the table. To insert the data into the table, we can use SQL query or can insert data directly into the table.
• Write PHP code to perform the MySQL round() function and get the round-off data.

Program:

PHP

<?php

// Store the servername in a variable
$servername = "localhost";

// Store the username in a variable
$username = "root";

//Store the password in  a variable
$password = "";

// Store the database name in a variable
$dbname = "test";

// Create connection by passing these
// connection parameters
$conn = new mysqli($servername,
    $username, $password, $dbname);

echo "Parent Salary";
echo "<br><br>";

// SQL Query to select the data from
// database table
$sql = "SELECT parent_salary,
    ROUND(parent_salary) FROM student";

$result = $conn->query($sql);

// Display data on the web page
while($row = mysqli_fetch_array($result)){
    echo " Parent salary : " .
        $row['parent_salary'] .
        "   =>   Round-off : " .
        $row['ROUND(parent_salary)']
        . "<br>";
}

echo "<br>*****************************";
echo "<br>Students Percentage";
echo "<br><br>";

// SQL Query to extract data from database
$sql = "SELECT name, ROUND(percentage) FROM student";
$result = $conn->query($sql);

// Display data on the web page
while($row = mysqli_fetch_array($result)){
    echo " Student name  : ". $row['name'] .
    "   =>   Percentage : "
    . $row['ROUND(percentage)'] . "<br>";
}

// Close the connection
$conn->close();

?>

Output: