How do PHP and MySQL handle boolean values ​​in JSON?

How do PHP and MySQL handle Boolean values ​​in JSON?

When developing web pages and applications, it is often necessary to transmit and store data in JSON format. JSON (JavaScript Object Notation) is a lightweight data exchange format that is easy to read and write, as well as easy to parse and generate. JSON supports multiple data types, including Boolean types.

In PHP and MySQL, processing Boolean values ​​in JSON is a common task. This article will introduce how to correctly handle Boolean values ​​in JSON in PHP and MySQL, and provide corresponding code examples.

1. Boolean conversion in PHP

The Boolean conversion function in PHP is very simple. You only need to use the (bool) or (boolval) function to convert other data types Is of Boolean type.

The following is an example of converting a string to a Boolean type:

$str = "true";
$bool = (bool)$str;
var_dump($bool);  // bool(true)

In the above example, after converting the string "true" to a Boolean type, the result is true.

2. JSON encoding and decoding in PHP

PHP provides convenient functions for JSON encoding and decoding, which are the json_encode() and json_decode() functions respectively.

The following is an example of encoding an array containing Boolean values ​​into a JSON string and then decoding it back:

$data = array(
    "name" => "John",
    "age" => 28,
    "isStudent" => true
);

$json = json_encode($data);  // 编码为JSON字符串
echo $json;  // {"name":"John","age":28,"isStudent":true}

$decodedData = json_decode($json);  // 解码为PHP对象
var_dump($decodedData);

In the above example, an array containing Boolean values ​​is encoded into a JSON character After string, decode it back through json_decode() function.

3. Boolean processing in MySQL

MySQL does not support storing Boolean type data by default, so Boolean values ​​need to be converted to other suitable data types for storage. A common approach is to use the TINYINT type, where 0 represents false and 1 represents true.

The following is an example to create a table containing a Boolean field and insert a piece of data:

CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(50),
    isStudent TINYINT(1)
);

INSERT INTO users(username, isStudent) VALUES('John', 1);

In the above example, a user table is created, in which the isStudent field is used to store the Boolean type The data.

4. Boolean processing examples of PHP and MySQL

Based on the previous knowledge, the following is an example of storing Boolean values ​​​​in PHP into MySQL and querying them:

// 将布尔数值存储到MySQL
$username = "John";
$isStudent = true;

// 转换为MySQL中的布尔类型
$isStudentMySQL = $isStudent ? 1 : 0;

// 插入数据
$sql = "INSERT INTO users(username, isStudent) VALUES('$username', $isStudentMySQL)";
$result = $conn->query($sql);

// 从MySQL查询数据
$sql = "SELECT * FROM users";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $username = $row["username"];
        $isStudent = $row["isStudent"];

        // 转换为PHP中的布尔类型
        $isStudentPHP = $isStudent == 1 ? true : false;

        // 输出数据
        echo "Username: " . $username . ", Is student: " . $isStudentPHP . "<br>";
    }
} else {
    echo "0 results";
}

In the above example, the Boolean value in PHP is stored in MySQL, the data is retrieved through the query, and then converted to the Boolean type in PHP for use.

Summary:

When processing Boolean values ​​​​in JSON, you first need to perform correct Boolean conversion in PHP, and then use the json_encode() and json_decode() functions to encode and decode JSON . In MySQL, Boolean values ​​need to be converted to other data types for storage. With proper data conversion and processing, Boolean values ​​in JSON can be easily processed in PHP and MySQL.

The above is the detailed content of How do PHP and MySQL handle boolean values ​​in JSON?. For more information, please follow other related articles on the PHP Chinese website!