Warning: oci_fetch_array() expects parameter 1 to be resource, string given

[nanie]

Hi, I don't know how to solve this problem. Please help me.

<?php

if(isset($_COOKIE['ID_site']) && isset($_COOKIE['Pass_site']))
 {
      $_SESSION['id'] = $_COOKIE['ID_site'];
      $_SESSION['password'] = $_COOKIE['Pass_site'];
 
 	  if(isset($_SESSION['id']))
 		{
 		$id = $_SESSION['id'];
 		$pass = $_SESSION['password'];
        echo $id;
    	$query2 = oci_parse($conn,"SELECT * FROM user1 WHERE id ='".$id."'")or die(oci_error());
		$check2 = oci_execute($query2);
		
	    echo $check2;
		
 		while($info2=oci_fetch_array(query2,OCI_ASSOC+OCI_RETURN_NULLS)) //the error come from this line
 		{
			echo $info2[0];
        //if the cookie has the wrong password, they are taken to the login page
 		if (($pass != $info2['PASSWORD']) || ($info2['ROLE'] != 'admin') )
 			{
                  header('Location: index.php?error=4');
 			}
         //otherwise they are show the admin home
               else
 			{
				            
?

[Muddy_Funster]

you missed the $ off of query2 in the parameter list of oci_fetch().

 

You should have also got an "Undefined constant" warning as well.

[nanie]

Thank you Muddy Funster for noticing it.

 

I feel ashamed that I can't notice it.