试图获取非对象和未定义索引错误的属性

Question

I just migrated a site based on custom CMS to new server. After migrating I am getting notices and warnings all over the admin area where content can be edited.

Notice: Trying to get property of non-object in database.php on line 69
Notice: Undefined index: in database.php on line 69

Following are the functions which are being used in the process:

function dbQuerySafener($query,$params=false) {
    $link= db_connect();
    if ($params) {
       foreach ($params as &$v) {
          $v = mysqli_real_escape_string($link,$v);
       }

       $sql_query = vsprintf( str_replace("?","'%s'",$query), $params );
    } else {
    $sql_query = $query;
 }
 return $sql_query;
}

// query returning ARRAY (many rows)
 function dbArray($query,$params=false) {
   $link= db_connect();
   $table_result=array();
   $r=0;
   $sql = dbQuerySafener($query, $params);
   $result = mysqli_query($link,$sql) or die(mysqli_error($link)." 
   <br>".$sql);
   while($row = mysqli_fetch_assoc($result)) {
       $arr_row=array();
       $c=0;
       while ($c < mysqli_num_fields($result)) {
          $col = mysqli_fetch_field($result);
          $arr_row[$col -> name] = $row[$col -> name]; // line 69
          $c++;
       }
    $table_result[$r] = $arr_row;
    $r++;
    }
    return $table_result;
  }

It is working as follows: A sql query will be passed to dbArray function, for example:

 $sql = "SELECT `id`, `emailAddress`, `name` FROM `gcms_users` 
 WHERE `active`=?";
 $data = dbArray($sql, array(1));

EXPECTED RESULT: The above two functions will fetch the results from database which should contains field name and its value, example:

  Array ( [0] => Array ( [id] => 1 [emailAddress] => [e-mail] 
  [name] => John ) [1] => Array ( [id] => 1 [emailAddress] => 
  [e-mail] [name] => Paul ) ) 

ACTUAL RESULT:

  Array ( [0] => Array ( [id] => 1 [emailAddress] => [e-mail] [name] => John ) [1] => Array ( [] => ) )

There is some problem with dbArray() function while fetching the rows but I am not getting that what is missing here. Your help will be highly appreciated.

Thank you.

Answer 1

Pointer of mysqli_fetch_field is not reset in your first while, try

mysqli_field_seek($result, 0); after $r++;