PHP将SQL请求转换为JSON

Question

I have a SQL table like this:

$sql="CREATE TABLE 
      config (ID INT AUTO_INCREMENT PRIMARY KEY, 
              nombre VARCHAR(50), 
              valor VARCHAR(50));";

Lets think it have this lines (ID,name,value) :

1 | name1 | value1
2 | name2 | value2
3 | name3 | value3

How i can convert the result of my SQL query into a JSON object which only contains name a value data?

Answer 1

You have to perform three steps:

1.) Create the required SQL and run it:

$sql = "SELECT nombre, valor FROM config";
$stmt = $pdoCon->prepare($sql);
$stmt->execute();

2.) Use your SQL-Connection (I will use PDO in my answer) to query the required data:

$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

3.) Use json_encode() to create a JSON-String from the array:

$json = json_encode($result);