How to make a conclusion from the database all the information after a search?

There is a search and need to also held and output from the database all information, as it is impossible to list in the row with $result in all columns and the query string $sql, maybe you need something to write in the code for the output columns infoin_id, title, img. And here's a important point, it turns out that even if the display only column img instead of image output displays its name, for example.

It turns out that you can display only one column of either, but not the entire table, tried to change the query and use AND and removed the name column and enter only the name of the database as written in the instructions and documentation but did not help. Also, instead of mini_description tried to list as already mentioned above, all the columns also did not help. Code does not work, if you list, I can not properly use the syntax or query language. Maybe I'm wrong, the principle of use and need to look globally at the code? In the end, I realized that I need to somehow use an array to write to it as data, and then withdraw, but don't know how. What needs to change in the code or add to the search did not take a single column for example only mini_description what he does now, and make sure to remove all columns. This is necessary in order to later work with elements css and html in the code. In the database phpmyadmin, there are still columns info_id, title, mini_description, mega_description, img, visible, count. Need to get some or all of them.


if (isset($_POST['search']))
{

include('include/db.php');
$db = new db();

$word = mysql_real_escape_string($_POST['search']);

$sql = "SELECT * FROM info_db_5 WHERE mini_description LIKE '%" . $word . "%'";

$row = $db->select_list($sql);
if(count($row))
{
$end_result = ";
foreach($row as $r)
{
$result = $r['mini_description'];

$bold = " . $word . ";
$end_result .= '' . str_ireplace($word, $bold, $result) . '';

}
echo $end_result;
}
else
{
echo 'No results found';
}
}
?>
5bbcf0954cbd0833604314.png
This is an example of Kartika as displays now, and you need to remove all columns from the database.
March 12th 20 at 08:02
1 answer
March 12th 20 at 08:04
foreach($row as $r)
{
print_r($r);
}

Find more questions by tags MySQLPHP