help with php function

jonniebigodes · 01-11-2011, 09:52 AM

hi.

i'm going nuts with a function that returns some values from a table, the code works, no mysql or php errors, but the array is not populated.
it's always returning a null value.
every attempt charles webproxy shows me that the result is null.
here is my code:

Code:

/**
	 * Returns the item corresponding to the value specified for the primary key.
	 *
	 * Add authorization or any logical checks for secure access to your data 
	 *
	 * @param string $itemID
	 * @return stdClass[]
	 */
	public function getCursoInfoByID($itemID) {
	
		
		$stmt = mysqli_prepare($this->connection, "SELECT * FROM $this->tablename where IDCurso=?");	
		$this->throwExceptionOnError();
		
		 
		 mysqli_stmt_bind_param($stmt, 's', $itemID);
		 $this->throwExceptionOnError();
		
		mysqli_stmt_execute($stmt);
		 $this->throwExceptionOnError();
		
		 $rows = array();
		
		 mysqli_stmt_bind_result($stmt, $row->IDCurso, $row->IDModulo, $row->NomeModulo, $row->ModuloAnterior, $row->ModuloSeguinte, $row->IDUnidade, $row->NomeUnidade, $row>UnidadeAnterior, $row->UnidadeSeguinte, $row->IDTopico, $row->NomeTopico, $row->TopicoAnterior, $row->TopicoSeguinte, $row->IDEcra, $row->NomeEcra, $row->EcraAnterior, $row->EcraSeguinte,$row->NumCreditos,$row->PathEcra);
		 array_push($rows,$row);

	     while (mysqli_stmt_fetch($stmt)) {
	   $newstdclass= new stdClass();
			mysqli_stmt_bind_result($stmt, $row->IDCurso, $row->IDModulo, $row->NomeModulo, $row->ModuloAnterior, $row->ModuloSeguinte, $row->IDUnidade, $row->NomeUnidade, $row->UnidadeAnterior, $row->UnidadeSeguinte, $row->IDTopico, $row->NomeTopico, $row->TopicoAnterior, $row->TopicoSeguinte, $row->IDEcra, $row->NomeEcra, $row->EcraAnterior, $row->EcraSeguinte,$row->NumCreditos,$row->PathEcra);
		  $newstdclass= $row;
		  array_push($rows,$newstdclass);
	     }
		
		 mysqli_stmt_free_result($stmt);
	     mysqli_close($this->connection);
	
	     return $rows;
		}

am i doing something wrong?
i can't seem to get my head around this....

forgot to add something, this works on my local machine, but not on a remote server, i've checked permissions, changed the connection string to the server, but doesn't return a thing
help would be apreciated

thanks in advance

Tinkster · 01-12-2011, 09:51 PM

May I ask you a favour? I'm working on a laptop w/ 1280x800, and
find it tortureous to try and read this post; can you replace your
PHP tags w/ plain old CODE tags? Never mind the colours - three way
scrolling to try and read something in its entirety doesn't work for me.

Cheers,
Tink

jonniebigodes · 01-16-2011, 07:42 PM

ok, sorry about that.
it's done, i've changed the tags

Nominal Animal · 01-16-2011, 11:42 PM

You're using a single copy of $row, without ever properly initializing it.

Your class does the necessary mysqli_real_connect() before this gets used, I presume?
Could you try the following instead?

PHP Code:



public function getCursoInfoByID($itemID) { 
    $stmt = mysqli_prepare($this->connection, "SELECT * FROM $this->tablename where IDCurso=?"); 
    mysqli_stmt_bind_param($stmt, 's', $itemID); 
    mysqli_stmt_execute($stmt); 
 
    $row = new stdClass(); 
    mysqli_stmt_bind_result($stmt, $row->IDCurso, $row->IDModulo, $row->NomeModulo, $row->ModuloAnterior, 
                            $row->ModuloSeguinte, $row->IDUnidade, $row->NomeUnidade, $row>UnidadeAnterior, 
                            $row->UnidadeSeguinte, $row->IDTopico, $row->NomeTopico, $row->TopicoAnterior, 
                            $row->TopicoSeguinte, $row->IDEcra, $row->NomeEcra, $row->EcraAnterior, 
                            $row->EcraSeguinte,$row->NumCreditos,$row->PathEcra); 
 
    $rows = array(); 
    mysqli_stmt_store_result($stmt); 
 
    while (mysqli_stmt_fetch($stmt)) 
        $rows[] = duplicate($row); 
 
    mysqli_stmt_free_result($stmt); 
    mysqli_stmt_close($stmt); 
 
    return $rows; 
}

I don't have a suitable database configured right now, so I cannot test this myself.

Nominal Animal

jonniebigodes · 01-20-2011, 05:07 AM

i'm going to give it a go and see if it works