Hello!

$connection = @mysqli_connect(HOST, USER, PASS, DB) or die("Нет соединения с БД"); mysqli_set_charset($connection, "utf8") or die("Не установлена кодировка соединения"); // получение массива информеров $informers = informer(); /* ===Информеры - получение массива=== */ function informer(){ $query = "SELECT * FROM links INNER JOIN informers ON links.parent_informer = informers.informer_id ORDER BY informer_position, links_position"; $res = mysqli_query($connection, $query) or die(mysqli_query()); $informers = array(); $name = ''; // флаг имени информера while($row = mysqli_fetch_assoc($res)){ if($row['informer_name'] != $name){ // если такого информера в массиве еще нет $informers[$row['informer_id']][] = $row['informer_name']; // добавляем информер в массив $name = $row['informer_name']; } $informers[$row['parent_informer']]['sub'][$row['link_id']] = $row['link_name']; // заносим страницы в информер } return $informers; } /* ===Информеры - получение массива=== */

There are 2 errors: Warning: mysqli_query () expects parameter 1 to be mysqli, null given in N: \ home \ programirovanie.ru \ www \ model \ model.php on line 63

Warning: mysqli_query () expects at least 2 parameters, 0 given in N: \ home \ programirovanie.ru \ www \ model \ model.php on line 63

The 63 string is: $ res = mysqli_query ($ connection, $ query) or die (mysqli_query ());

What is wrong here? 2 day already think.

  • $ connection does not exist inside the method. die (mysqli_query ()) increase attention to what is written. - etki
  • @Etki, Made: $ res = mysqli_query ($ query) or die (mysqli_query ()); Errors: Warning: mysqli_query () expects at least 2 parameters, 1 given in N: \ home \ programirovanie.ru \ www \ model \ model.php on line 63 Warning: mysqli_query () expects at least 2 parameters, 0 given in N : \ home \ programirovanie.ru \ www \ model \ model.php on line 63 Again the same line. - DimasikYES
  • @DimasikYES, maybe it was necessary not to delete the $ connection, but to initialize it inside the method? - etki
  • @Etki, show me how to do it. - DimasikYES
  • one
    @DimasikYES function informer ($ connection) {// ... and pass it to the call. - etki

1 answer 1

 function informer($connection) {

// ... and pass it to the call ( $connection ).

 // получение массива информеров $informers = informer($connection);