Skip to content
Related Articles

Related Articles

Improve Article
PHP – My SQL : abs() – numeric function
  • Last Updated : 25 Mar, 2021

Problem Statement :

In this article, we are going to perform database operation with abs() operation using php.

So we are considering temperature database .

Introduction :

PHP stands for hyper text preprocessor, it also communicates with mysql database through xampp server.



MySQL is an query language that is used to manage the databases.

abs()

abs() is used to return the positive value in a table.

syntax :

abs(data);

Example :

abs(-12)=12

abs(23) = 23

Consider the table:

Convert the temperature column to positive.

Query :

SELECT city,ABS(temperature) FROM temperature;

Result :

city id : 1 — temperature : 15

city id : 2 — temperature : 455

city id : 3 — temperature : 55

Steps



  • Start xampp server

  • Create a database named database and create table named temperature.

  • Write php code to insert records into the table.

temp.php

PHP




<?php
//servername
$servername = "localhost";
//username
$username = "root";
//empty password
$password = "";
//database is the database name
$dbname = "database";
  
// Create connection by passing these connection parameters
$conn = new mysqli($servername, $username, $password, $dbname);
// Check this connection
if ($conn->connect_error) {
  die("Connection failed: " . $conn->connect_error);
}
//insert records into table
$sql  = "INSERT INTO temperature VALUES (1,-15);";
$sql .= "INSERT INTO temperature VALUES (2,-455);";
$sql .= "INSERT INTO temperature VALUES (3,55);";
  
  
if ($conn->multi_query($sql) === TRUE) {
  echo "temperature successfully stored";
} else {
  echo "Error: " . $sql . "<br>" . $conn->error;
}
  
$conn->close();
?>

Output:

localhost/temp.php

  • PHP code to perform abs() function by converting temperature negative to positive values

form1.php

PHP




<html>
<body>
<?php
//servername
$servername = "localhost";
//username
$username = "root";
//empty password
$password = "";
//database is the database name
$dbname = "database";
// Create connection by passing these connection parameters
$conn = new mysqli($servername, $username, $password, $dbname);
echo "<br>";
echo "abs() demo";
echo "<br>";
echo "<br>";
//sql query
$sql = "SELECT city,ABS(temperature) FROM temperature";
$result = $conn->query($sql);
//display data on web page
while($row = mysqli_fetch_array($result)){
    echo " city id  : ". $row['city']," --    temperature : ". $row['ABS(temperature)'];
    echo "<br>";
}
//close the connection
$conn->close();
?>
</body>
</html>

Output :

My Personal Notes arrow_drop_up
Recommended Articles
Page :