Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given i

eyobassey · January 5, 2009

Please can someone help me out... when i run my program i have this error message;

"Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:\wamp\www\collegepro1.3\parent_report_sheet.php on line 240"

Please find below the codes:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>:: WELCOME TO THE SCHOOL MANAGEMENT SYSTEM ::</title>

<!--

#Layer1 {

position:absolute;

width:215px;

height:139px;

z-index:1;

left: 453px;

top: 287px;

background-color: #CC9900;

}

#Layer2 {

position:absolute;

width:217px;

height:32px;

z-index:2;

left: 451px;

top: 251px;

background-color: #333399;

}

#Layer3 {

position:absolute;

width:619px;

height:154px;

z-index:3;

left: 254px;

top: 26px;

}

#Layer4 {

position:absolute;

width:724px;

height:649px;

z-index:1;

background-color: #CCCCCC;

left: 202px;

top: 1px;

}

#Layer5 {

position:absolute;

width:721px;

height:22px;

z-index:1;

top: 98px;

left: 2px;

background-color: #99CC99;

}

#Layer6 {

position:absolute;

width:721px;

height:31px;

z-index:2;

top: 136px;

left: 8px;

background-color: #336699;

}

#Layer7 {

position:absolute;

width:158px;

height:504px;

z-index:3;

left: 8px;

top: 173px;

background-color: #006633;

}

#Layer8 {

position:absolute;

width:517px;

height:115px;

z-index:4;

left: 170px;

top: 20px;

}

-->

</style>

</head>

<body>

<?php

session_start();

if (session_id() !=($_SESSION["Sess_ses"]) || ($_SESSION["w_use_typ"]) != 'C'){

header("Location: default_to_entergrade.php");

}

//*

// contacts_menu.php

// Contacts Section

// Main Menu

//*

//Check if contact is logged in

session_start();

if(!session_is_registered('UserId') || $_SESSION['UserType'] != "C")

{

header ("Location: index.php?action=notauth");

exit;

}

?>

<?php

function Set_criteria($all){

$result = "";

$id = $all["student"];

$term = $all["term"];

$session = $all["session"];

if($id=="" || $term == "" || $session == ""){

$result = "error";

}

if($id != "" && $term != "" && $session != ""){

$_SESSION['nam_id'] = $id;

$_SESSION['term'] = $term;

$_SESSION['sess'] = $session;

$mycon = mysqli_connect("localhost","wfuser","wfpass","palasis");

$get_sql = "

Select

concat(studentbio.studentbio_lname,studentbio.studentbio_fname,studentbio.studentbio_mi) as Name

from studentbio Where studentbio_internalid = '".$id."'";

$get_res = mysqli_query($mycon, $get_sql) or die(mysqli_error($mycon));

if(mysqli_num_rows($get_res) <= 0){

$result = "empty";

}

if(mysqli_num_rows($get_res) >= 1){

$result = $get_res;

}

mysqli_close($mycon);

return $result;

}

//end of function set-criteria

$tname = $_SESSION["w_userna"];

$parid = $_SESSION["w_relid"];

$mycon = mysqli_connect("localhost","wfuser","wfpass","palasis");

$display_welcome_name = " <b><font size=\+2 color=\"#FFFFFF\">Welcome $tname</font></b>";

$display_date = "<font color=\"#FFFFFF\"><b>".date("l F jS\, Y.")."</b></font>";

$display_block = "

<tr>

<td>

<option value=\"\">-Select Ward's Name-</option>";

//$get_sql = "Select ward_name, ward_id from ward_parent where ward_contact_id = ".$t_id."";

$get_sql = "select studentbio_internalid, studentbio_id, concat(studentbio_lname, studentbio_fname) as ward_name from studentbio where studentbio_primarycontact = '".$parid."' order by studentbio_fname";

$get_res = mysqli_query($mycon, $get_sql) or die(mysqli_error($mycon));

while ($get_array = mysqli_fetch_array($get_res)){

$w_nam = $get_array['ward_name'];

$w_id = $get_array['studentbio_internalid'];

$display_block .="<option value=\"".$w_id."\">".

$w_nam."</option>";

}

$display_block .= "</select>

<option value=\"\">-Select Term-</option>";

$get_sql = "Select grade_terms_desc from grade_terms order by grade_terms_desc asc";

$get_res = mysqli_query($mycon, $get_sql) or die(mysqli_error($mycon));

while ($get_array = mysqli_fetch_array($get_res)){

$cat = $get_array['grade_terms_desc'];

$display_block .="<option value=\"".$cat."\">".

$cat."</option>";

}

$display_block .= "</select>

<option value=\"\">-Select Session-</option>";

$get_sql = "Select school_years_desc from school_years order by school_years_id desc";

$get_res = mysqli_query($mycon, $get_sql) or die(mysqli_error($mycon));

while ($get_array = mysqli_fetch_array($get_res)){

$cat = $get_array['school_years_desc'];

$display_block .="<option value=\"".$cat."\">".

$cat."</option>";

}

$display_block .= "</select>

</td>

</tr>

</table>

</form>";

if($_POST){

$all_post = $_POST;

$get_list = Set_criteria($all_post);

}

if($get_list == 'error'){

$display_list = "<font Color=\"#990000\"> Please ensure selection is made from ALL the drop-downs</font>";

}

if($get_list == 'empty'){

$display_list = "<font Color=\"#990000\"> No reports available yet.</font>";

}

if(mysqli_num_rows($get_list) >= 1){

$get = mysqli_query($mycon,"Select * from result_handler Where student_internalid = '".$_SESSION['nam_id']."' AND term = '".$_SESSION['term']."' AND school_year = '".$_SESSION['sess']."'");

$class = mysqli_fetch_array($get);

$grad = $class['grades_desc'];

$arm = $class['grades_arm'];

$name = $class['student_name'];

if(($grad == 'S.S. 1 ' )|| ($grad == 'S.S. 2 ') || ($grad == 'S.S. 3 ')){

$getpage = 'Performance_report_senior.php';

}else{

$getpage = 'Performance_report_junior.php';

}

while ($get_array = mysqli_fetch_array($get_list)){

$num = $num + 1;

$name = $get_array['Name'];

$display_list .= "

<tr>

<td bgcolor=\"#FFFFFF\" align=\"left\" ><font size=\"-1\"> ".$_SESSION["sess"]."</font></td>

<td bgcolor=\"#FFFFFF\" align=\"left\" ><font size=\"-1\"> ".$_SESSION["term"]."</font></td>

</tr>";

}

"</table>

</form>";

mysqli_close($mycon);

}

?>

<tr><td width="40%"> <?php echo "$display_date"; ?></td><td width="30%"><font color="#FFFFFF" size="+1"><b>VIEW REPORT SHEET</b></font></td><td width="30%"><?php echo "$display_welcome_name"; ?></td></tr></table>

<tr><td width="35%"> <font color="#FFFFFF">[select Name, Term, Session and click Generate]</font></td>

</tr></table>

</tr>

<tr>

</tr>

<td valign=center align=center><a href="#"><font color="#FFFFFF"><b>Attendance Notes</b></font></a></td>

</tr>

<td valign=center align=center><a href="#"><font color="#FFFFFF"><b>Discipline Notes</b></font></a></td>

</tr>

<td valign=center align=center><a href="parent_vw_sheet.php"><font color="#FFFFFF"><b>Performance Report</b></font></a></td>

</tr>

<td valign=center align=center><a href="parent_report_sheet.php"><font color="#FFFFFF"><b>Report Sheet</b></font></a></td>

</tr>

<tr>

</tr>

<td valign=center align=center><a href="#"><font color="#FFFFFF"><b>Homework</b></font></a></td>

</tr>

<td valign=center align=center><a href="#"><font color="#FFFFFF"><b>Forum</b></font></a></td>

</tr>

</tr>

<tr>

</tr>

<td valign=center align=center><a href="#"><font color="#FFFFFF"><b>Timetable</b></font></a></td>

</tr>

<td valign=center align=center><a href="#"><font color="#FFFFFF"><b>Health</b></font></a></td>

</tr>

<td valign=center align=center><a href="#"><font color="#FFFFFF"><b>Exams and Tests</b></font></a></td>

</tr>

<td valign=center align=center><a href="#"><font color="#FFFFFF"><b>Change Password</b></font></a></td>

</tr>

<tr>

</tr>

<td valign=center align=center><a href="logout.php"><font color="#FFFFFF"><b>Logout</b></font></a></td>

</tr>

</tbody>

</table>

</div>

</body>

</html>

KevinM1 · January 5, 2009

The error message is pretty clear in its meaning. In order to use mysqli_num_rows(), the first argument passed into it must be a mysqli_result. What is that? The result of a database query.

What does your Set_criteria() function do? I'm willing to bet it doesn't return a mysqli_result.

eyobassey · January 5, 2009

wht then do u advice? i need practical steps.

Thanks alot

KevinM1 · January 5, 2009

wht then do u advice? i need practical steps.

Thanks alot

Well, the 'simplest' thing to do would be to ensure that your Set_criteria() function returns a mysqli_result that mysqli_num_rows() can read.

What does Set_criteria() do?

Sign In

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given i

Recommended Posts

eyobassey

Link to comment

Share on other sites

KevinM1

Link to comment

Share on other sites

eyobassey

Link to comment

Share on other sites

KevinM1

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information