Warning: sqlsrv_fetch_array() expects Parameter 1 to be Resource, Boolean Given in D: xampp5.6 htdocs sysriomed bank-material.php on line 27

Question

I am making a form for editing materials (products). I am viewing the list of materials and I created in my form a button that passes my IdItem. I’m in error:

Warning: sqlsrv_fetch_array() expects Parameter 1 to be Resource, Boolean Given in D: xampp5.6 htdocs sysriomed bank-material.php on line 27

function buscaMaterial($conn, $IdItem){
    $query = "select m.id as IdMat, I.id as IdItem, M.nome, M.tipo, I.nSerie ,I.valorUnitario from medx.dbo.material as M, medx.dbo.itemMaterial as I on M.id=I.idMaterial where IdItem = {$IdItem}";
    $resultado = sqlsrv_query($conn, $query);
    return sqlsrv_fetch_array($resultado, SQLSRV_FETCH_ASSOC);
}

I am working with SQL Server 2014 and PHP 5.6.

• banco-material.php is where are my duties related to materials.
• material-altera-formulario is the data editing form.
• lista-material.php is my material list.

Answer 1

Warning: sqlsrv_fetch_array() expects Parameter 1 to be Resource, Boolean Given in

This says that there is some kind of error in your query, be it syntax or constraint guitar for example. To be sure what happened use the function sqlsrv_errors() it will return an array with the error information.

As a test you can leave the code this way:

$resultado = sqlsrv_query($conn, $query) or die(print_r(sqlsrv_errors()));

In that case the problem was the lack of JOIN formerly claudia ON and do not use the original column name in WHERE

Original code:

SELECT m.id as IdMat, I.id as IdItem, M.nome, M.tipo, I.nSerie ,I.valorUnitario
FROM medx.dbo.material as M, medx.dbo.itemMaterial as I on M.id=I.idMaterial
WHERE IdItem = {$IdItem}

Corrected code:

SELECT m.id as IdMat, I.id as IdItem, M.nome, M.tipo, I.nSerie ,I.valorUnitario
FROM medx.dbo.material as M INNER JOIN medx.dbo.itemMaterial as I  on M.id = I.idMaterial
WHERE I.id = {$IdItem}