How to handle numbers and floats in JSON using PHP and MySQL?

How to handle numbers and floating point numbers in JSON using PHP and MySQL?

In modern web development, data transmission and storage usually use JSON format. JSON is a lightweight data exchange format that is widely used in front-end and back-end data transfer and API interfaces. When processing JSON data, you often encounter the need to process numbers and floating point numbers. This article will explain how to use PHP and MySQL to process numbers and floating point numbers in JSON.

1. Parse numbers or floating point numbers from JSON

In PHP, you can use the json_decode() function to parse a JSON string into a PHP array or object. When the value in JSON is a number or float, json_decode() will parse it into the corresponding PHP data type. Here is an example:

$json = '{"number": 10, "float": 3.14}';
$data = json_decode($json);

$number = $data->number;
$float = $data->float;

echo "The number is: " . $number . "
";
echo "The float is: " . $float . "
";

Output:

The number is: 10
The float is: 3.14

2. Convert a number or float to a JSON string

In PHP, you can use json_encode () function converts a PHP array or object into a JSON string. When a PHP variable is a number or float, json_encode() will convert it to the corresponding JSON data type. Here is an example:

$number = 10;
$float = 3.14;

$data = array("number" => $number, "float" => $float);
$json = json_encode($data);

echo $json;

Output:

{"number":10,"float":3.14}

3. Storing and retrieving numbers or floating point numbers in MySQL

In a MySQL database, you can use The INT or FLOAT type stores integers or floating point numbers. When storing JSON data into MySQL, you can store numbers or floats as the corresponding database type. Here is an example:

$number = 10;
$float = 3.14;

$data = array("number" => $number, "float" => $float);
$json = json_encode($data);

// 假设有一个名为 "json_data" 的表
$sql = "INSERT INTO json_data (data) VALUES ('$json')";
$result = $conn->query($sql);

// 检索数据
$sql = "SELECT data FROM json_data WHERE id = 1";
$result = $conn->query($sql);

$row = $result->fetch_assoc();
$data = json_decode($row['data']);

$number = $data->number;
$float = $data->float;

echo "The number is: " . $number . "
";
echo "The float is: " . $float . "
";

Output:

The number is: 10
The float is: 3.14

In this example, we store the JSON data into a table called "json_data" in MySQL and then retrieve the data and use json_decode () to parse it into a PHP object. Finally, we can access numeric and floating point values ​​and process them accordingly.

Summary:

Handling numbers and floating point numbers in JSON is very simple in PHP and MySQL. Using the json_decode() and json_encode() functions, we can easily parse JSON data into PHP variables or convert to JSON strings. In MySQL, we can store numbers and floating point numbers as INT or FLOAT type and retrieve them. I hope the sample code in this article will be helpful to you when dealing with numbers and floating point numbers in JSON data.

The above is the detailed content of How to handle numbers and floats in JSON using PHP and MySQL?. For more information, please follow other related articles on the PHP Chinese website!