Can not use object of type mysqli_result as array

Question

Can not use object of type mysqli_result as array

Navigation

#1 by (2 votes)

1

Hello, someone can help me with the following error: PHP Fatal error: Can not use object of type mysqli_result as array

It is assumed that where the error marks me is in this line:

$_SESSION['MM_UserGroup'] = $loginStrGroup;	      
        $_SESSION['MM_iduser'] = $LoginRS["iduser"];	 
        if (isset($_SESSION['PrevUrl']) && false) {
          $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
        }
        header("Location: " . $MM_redirectLoginSuccess );
      }// aqui me marca que hay un error

<?php
// *** Validate request to login to this site.
if (!isset($_SESSION)) {
  session_start();
}

$loginFormAction = $_SERVER['PHP_SELF'];
if (isset($_GET['accesscheck'])) {
  $_SESSION['PrevUrl'] = $_GET['accesscheck'];
}

if (isset($_POST['email'])) {
  $loginUsername=$_POST['email'];
  $password=$_POST['password'];
  $MM_fldUserAuthorization = "";
  $MM_redirectLoginSuccess = "accesook.php";
  $MM_redirectLoginFailed = "acceso_erro.php";
  $MM_redirecttoReferrer = false;
  mysqli_select_db($catalogo,$database_catalogo);
  
  $LoginRS__query=sprintf("SELECT 'email', 'password' FROM Bodegeros WHERE 'email'=%s AND 'password'=%s",
    GetSQLValueString($loginUsername, "text"), GetSQLValueString($password, "text")); 
   
  $LoginRS = mysqli_query($catalogo,$LoginRS__query) or die(mysqli_error());
  $loginFoundUser = mysqli_num_rows($LoginRS);
  if ($loginFoundUser) {
     $loginStrGroup = "";
    
	if (PHP_VERSION >= 5.1) {session_regenerate_id(true);} else {session_regenerate_id();}
    //declare two session variables and assign them
    $_SESSION['MM_Username'] = $loginUsername;
    $_SESSION['MM_UserGroup'] = $loginStrGroup;	      
    $_SESSION['MM_iduser'] = $LoginRS["iduser"];	 
    if (isset($_SESSION['PrevUrl']) && false) {
      $MM_redirectLoginSuccess = $_SESSION['PrevUrl'];	
    }
    header("Location: " . $MM_redirectLoginSuccess );
  }
  else {
    header("Location: ". $MM_redirectLoginFailed );
  }
 
}
?>

php

asked by Javier Joasimar Palos Flores 07.01.2017 в 23:03

source

1 answer

Load image and text of each ITEM (ListView) in the same Activity Starting with SQLite

score 2 · Answer 1

Cannot use object of type mysqli_result as array

Use mysqli_fetch_assoc or mysqli_fetch_array to get a row of results as an associative array.

$query = "SELECT 1";
$result = $mysqli->query($query);
$followingdata = $result->fetch_assoc()

Another alternative:

$result = mysqli_query($conexion, "SELECT * FROM usuarios where usuario_id = 278");
$followingdata = $result->fetch_assoc();
var_dump($followingdata);
die();

OR $ resultsdata = $ result-> fetch_array (MYSQLI_ASSOC);