function my_basket()
{
global $link, $basket;
$goods = array_keys($basket);
array_shift($goods);
if (count($goods)) {
$ids = implode(",", $goods);
} else {
$ids = 0;
}
$sql = "SELECT id, author, title, pubyear, price FROM catalog WHERE id IN ({$ids})";
if (!($result = mysqli_query($link, $sql))) {
return false;
}
$items = result_to_array($result);
mysqli_free_result($result);
return $items;
}
function select($table, $where)
{
$con = connection();
$sql = "SELECT * FROM {$table} {$where} ";
$result = mysqli_query($con, $sql);
$result = result_to_array($result);
return $result;
}
//, "/tmp/mariadb55.sock"
if ($connection->connect_error) {
die('Chyba - db');
}
$connection->query('SET NAMES "UTF8"') or die('Chyba - db');
$result = $connection->query('select * from reiffeisen_answers') or die('Chyba - read');
function result_to_array($query_result, $key_column = null, $value_column = null)
{
$array = array();
if (!mysqli_num_rows($query_result)) {
return $array;
}
mysqli_data_seek($query_result, 0);
while ($r = mysqli_fetch_assoc($query_result)) {
if ($key_column) {
$array[$r[$key_column]] = $value_column ? $r[$value_column] : $r;
} else {
$array[] = $value_column ? $r[$value_column] : $r;
}
}
return $array;
}
?>
<table>
<?php
foreach (result_to_array($result) as $item) {
//print_r(json_decode($item['data']));
echo '<tr><td>' . $item['data'] . '</td></tr>';
}
?>
</table>
