The record from the database is not displayed to the Varchar type. I send the request to the database via AJAX, in response I get an empty request, but if I make a selection and comment out some field, I end up with the correct answer.

Js:

$.ajax({ type: "POST", url: "/php/loadalcars.php", dataType: "text", cache: false, success: function (resp) { console.log(resp); }, error:function(data){ console.log('error'); console.log(data); } });

PHP:

 <?php if ($_SERVER['REQUEST_METHOD'] === "POST") { $link = mysqli_connect("localhost", "*****","*********","**********","3306"); if (!$link) { echo "Ошибка: НСвозмоТно ΡƒΡΡ‚Π°Π½ΠΎΠ²ΠΈΡ‚ΡŒ соСдинСниС с MySQL." . PHP_EOL; echo "Код ошибки errno: " . mysqli_connect_errno() . PHP_EOL; echo "ВСкст ошибки error: " . mysqli_connect_error() . PHP_EOL; exit; } $sql = "SELECT id,mark,model,mile,price,describeru,img1 FROM cars LIMIT 9"; $result = mysqli_query($link,$sql); $res = array(); while($row = mysqli_fetch_assoc($result)){ $res[] = $row; } echo json_encode($res); } ?>

If from:

 $sql = "SELECT id,mark,model,mile,price,describeru,img1 FROM cars LIMIT 9";

describeru - if clean, get an answer!

DB structure:

  typemenu varchar(50) utf8_general_ci mark varchar(50) utf8_general_ci model varchar(50) utf8_general_ci year int(4) mile int(15) volume varchar(50) utf8_general_ci **describeru varchar(8000) utf8_general_ci**

    1 answer 1

    Use TEXT instead of VARCHAR (8000)