I have a table in the Mysql database that contains 3 fields (id, name and model) different from the other fields, the data email template with tags HTML (structure in longtext ).
When I run the PHP code to return the data to me, it does not return any information. when I run the same script on another table, the data is returned perfectly. I believe it's the data with tags HTML that exists in my my template.
Below is all my script PHP :
<?php
include_once "conexao.php";
$sql = $db->prepare("SELECT * FROM modelo_email");
$sql->execute();
while($data = $sql->fetchAll( PDO::FETCH_ASSOC )){
$json ["data"] = $data;
}
echo json_encode($json);