Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

PHP MySQL ROUND() Function

  • Last Updated : 01 Apr, 2021

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 :

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.

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 tablr
$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:




My Personal Notes arrow_drop_up
Recommended Articles
Page :