错误mysql_fetch_array（）要求参数1为资源，在C：\ xampp \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ [英] ERROR mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\school\admin\view-assstudent-PHP on line 114
问题描述
我是php的编码新手。我很无能为力，为什么我会收到这个错误
mysql_fetch_array（）期望参数1是资源，在c：\ xampp \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\第114行\\\minmin \view-assstudent-php
我尝试过：
<？php
include（' connection.php'）;
session_start（）;
$ fname = $ _ SESSION [' fname'];
if（' '！= $ _ SESSION [' admin']）{
？>
<？ php
include（'' connection.php'）;
if（@ $ _ POST [btn] == 保存）
{
mysql_query（ INSERT INTO'student_info'set
`class` ='$ _POST [class]'，
`name` ='$ _POST [name]'，
`roll` ='$ _POST [roll]'，
` age `='$ _POST [age]'，
`mail` ='$ _POST [email]'，
`parent_name'='$ _POST [father_name]'，
`mother_name` = '$ _POST [mother_name]'，
`sexuals ='$ _POST [gender]'，
`contact_no1` ='$ _POST [contact_no1]'，
`dob` ='$ _POST [dob]'，
`password` ='$ _POST [password]'，
`contact_no2` ='$ _POST [contact_no2]'，
`guardian_email` ='$ _POST [ guardian_email]'，
`address` ='$ _POST [address]'
）;
/ * mysql_query（INSERT INTO`school_info`（`class` ，`name`，`roll`，`age`，`email`，`father_name`，`mother_name`，`gender`，`contact_no1`，`dob`，`password`，`contact_no2`，`guardian_email`，`地址`）
VALUES（'$ _POST [class]'，'$ _ POST [name]'，'$ _ POST [roll]'，'$ _ POST [age]'，'$ _ POST [email]'，' $ _ POST [father_name] ' '$ _ POST [mother_name]'， '$ _ POST [两性]'， '$ _ POST [contact_no1]'， '$ _ POST [DOB]'， '$ _ POST [密码]'，' $ _ POST [contact_no2]'，'$ _ POST [guardian_email]'，'$ _ POST [address]'）
）;
* /
}
？> I am new to coding of php. i am clueless, why i am getting this error 这篇关于错误mysql_fetch_array（）要求参数1为资源，在C：\ xampp \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
< pre lang =HTML> < ！DOCTYPE html >
< meta charset = utf-8 >
< meta http-equiv = X-UA兼容 content = IE = edge >
< meta 名称 = viewport 内容 = width =设备宽度，initial-scale = 1 > ;
< meta 名称 = description content = >
< meta name = 作者 content = >
< title > <？ php需要' ../ school_name.php'; ？>
<！ - Bootstrap Core CSS - >
<！ - 自定义CSS - >
<！ - 自定义字体 - >
& lt;！ -
.style1 {
font-size：16px;
font-weight：bold;
}
- >
< div id = 包装 >
<！ - 导航 - >
<！ - 品牌和切换分组以获得更好的移动显示 - >
< div class = navbar-header >
< span class = sr-only > < / span >
< span class = icon-bar > < / span >
< sp class = icon-bar > < / span >
< span class = icon-bar > < / span >
< a class = navbar-brand > <？ php require ' ../ school_name.php'; ？> < / a < span class =code-keyword>>
< / div >
<！ - 热门菜单项 - >
< ul class = nav navbar-right top-nav >
< li class
< ul class = 下拉菜单 >
< li > < a href = myprofile.php > Profile < / a >
< / li > <！ - < li> < a href =＃> 设置< / a>
< / li> - >
< li class = divider > < / li > < li > < < span class =code-leadattribute> a href = logout.php > 注销< / a >
< / li > < / ul >
< / li > < / ul >
< ！ - 补充工具栏菜单项 - 这些项目会折叠到小屏幕上的自适应导航菜单 - >
< div class = 折叠navbar-collapse navbar-ex1-collapse >
< ul class = nav navbar-nav side-nav style = height：600px < span class =code-keyword>>
<？ php需要' side_nav.php'; ？>
< / ul >
< / div >
<！ - /.navbar-collapse - >
< div id = page-wrapper >
< div class = container-fluid >
<！ - 页面标题 - >
< div class = row >
< div class = col-lg-12 >
< h3 align = center < span class =code-attribute> class = page-header alert alert-info >
注册表
< / h3 >
<！ - ------------------------------------ ---------
----------------表格在这里开始-----------------
----------------------------------------------- - >
< 表 class = table table-striped table-bordered table-hover > < tbody > < tr > < td height = 52 colspan = 2 > < span class = style1 > 候选信息 < / span > < / td > < / tr > < tr > < td width = 160 > 选择类：< span class =code-keyword>< / td > < td width = 482 >
<？ php
include（ connection.php）; $ result3 = mysql_query（ SELECT batch FROM year order by batch desc）; ？>
Class 1
Class 2
Class 3
Class 4
Class 5
Class 6
Class 7
Class 8
< / td > < / tr > < tr > < td 高度 = 52 > 学生姓名：< / td > < td > < / td > < / tr > < tr > < td 高度 = 49 > 卷号：< / td > < td > < / td > < / tr > < tr > < span class =code-keyword>< td height = 50 > 出生日期：< / td > < td > < / td > < / tr > < tr > < td height = 46 > 年龄：< / td > < td > < / td > ; < / tr > < tr > < td 高度 = 42 > 性别：< / td > < td &g t; 选择oneMaleFemale < / td > < / tr > < tr > < td height = 49 > 联系电话：< / td > < td > < / td > < / tr > < tr > < td height = 49 > 电子邮件：< / td > < td > < / td > < / tr > < tr > < td height = 49 > 密码：< / td > < td > < / td > < / tr > < tr &g t; < td height = 52 colspan = 2 > < span class = style1 > 个人信息< / span > < < span class =code-leadattribute> / td > < / tr > < tr > < td height =\"46\">Fathers name: </td> <td></td></tr>< tr><td height=\"44\">Mothers name:</td><td></td></tr><tr><td height=\"49\">Contact Number (Guardian): </td><td></td></tr><tr><td height=\"49\">Guardian Email: </td><td></td></tr><tr><td height=\"104\">Pres ent Address:</td><td></td></tr><tr> <td height=\"72\"> </td>
</td></tr></tbody></table>
<br><br><
</div>
</div>
<!-- /.row -->
</div>
<!-- /.container-fluid -->
</div>
<!-- jQuery -->
<!-- Bootstrap Core JavaScript -->
<?php }else{
header(\"location:index.php\");
} ?></div>fname=
_SESSION['fname'];
if(''!=_SESSION['admin']){
?>
<?php
include('connection.php');
if(@
mysql_fetch_array() expects parameter 1 to be resource, boolean given in c:\xampp\htdocs\school\admin\view-assstudent-php on line 114
What I have tried:
<?php
include('connection.php');
session_start();
$fname=$_SESSION['fname'];
if(''!=$_SESSION['admin']){
?>
<?php
include('connection.php');
if(@$_POST[btn]=="Save")
{
mysql_query("INSERT INTO 'student_info' set
`class` = '$_POST[class]' ,
`name` = '$_POST[name]',
`roll` = '$_POST[roll]',
`age` = '$_POST[age]',
`email` = '$_POST[email]',
`father_name` = '$_POST[father_name]',
`mother_name` = '$_POST[mother_name]',
`gender` = '$_POST[gender]',
`contact_no1` = '$_POST[contact_no1]',
`dob` ='$_POST[dob]',
`password` = '$_POST[password]' ,
`contact_no2` = '$_POST[contact_no2]',
`guardian_email` = '$_POST[guardian_email]',
`address` = '$_POST[address]'
");
/*mysql_query("INSERT INTO `student_info`(`class`, `name`, `roll`, `age`, `email`, `father_name`, `mother_name`, `gender`, `contact_no1`, `dob`, `password`, `contact_no2`, `guardian_email`, `address`)
VALUES ('$_POST[class]','$_POST[name]','$_POST[roll]','$_POST[age]','$_POST[email]','$_POST[father_name]','$_POST[mother_name]','$_POST[gender]','$_POST[contact_no1]','$_POST[dob]','$_POST[password]','$_POST[contact_no2]','$_POST[guardian_email]','$_POST[address]')
");
*/
}
?>
<!DOCTYPE html>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title> <?php require '../school_name.php'; ?>
<!-- Bootstrap Core CSS -->
<!-- Custom CSS -->
<!-- Custom Fonts -->
<!--
.style1 {
font-size: 16px;
font-weight: bold;
}
-->
<div id="wrapper">
<!-- Navigation -->
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<span class="sr-only"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<a class="navbar-brand"> <?php require '../school_name.php'; ?> </a>
</div>
<!-- Top Menu Items -->
<ul class="nav navbar-right top-nav">
<li class="dropdown"> <a href="#" class="dropdown-toggle"> <?php echo $fname; ?></a>
<ul class="dropdown-menu">
<li> <a href="myprofile.php"> Profile</a>
</li> <!-- <li> <a href="#"> Settings</a>
</li> -->
<li class="divider"></li> <li> <a href="logout.php"> Log Out</a>
</li> </ul>
</li> </ul>
<!-- Sidebar Menu Items - These collapse to the responsive navigation menu on small screens -->
<div class="collapse navbar-collapse navbar-ex1-collapse">
<ul class="nav navbar-nav side-nav" style="height: 600px">
<?php require 'side_nav.php'; ?>
</ul>
</div>
<!-- /.navbar-collapse -->
<div id="page-wrapper">
<div class="container-fluid">
<!-- Page Heading -->
<div class="row">
<div class="col-lg-12">
<h3 align="center" class="page-header alert alert-info ">
Registration Form
</h3>
<!-----------------------------------------------
----------------Form Begins Here-----------------
------------------------------------------------->
<table class="table table-striped table-bordered table-hover"><tbody><tr> <td height="52" colspan="2"><span class="style1">Candidate Information</span></td> </tr><tr> <td width="160"> Select Class : </td> <td width="482">
<?php
include("connection.php"); $result3 = mysql_query("SELECT batch FROM year order by batch desc");?>
Class 1
Class 2
Class 3
Class 4
Class 5
Class 6
Class 7
Class 8
</td></tr><tr> <td height="52"> Student Name : </td><td></td></tr><tr><td height="49"> Roll Number: </td><td> </td></tr><tr><td height="50"> Date of Birth:</td> <td></td></tr><tr><td height="46">Age: </td><td></td></tr><tr><td height="42">Gender:</td><td>Select oneMaleFemale</td></tr><tr><td height="49">Contact Number: </td><td></td></tr><tr><td height="49">Email: </td><td></td></tr><tr> <td height="49"> Password: </td><td></td></tr><tr><td height="52" colspan="2"><span class="style1">Personal Information</span></td></tr><tr><td height="46">Fathers name: </td><td></td></tr><tr><td height="44">Mothers name:</td><td></td></tr><tr><td height="49">Contact Number (Guardian): </td><td></td></tr><tr><td height="49">Guardian Email: </td><td></td></tr><tr><td height="104">Present Address:</td><td></td></tr><tr> <td height="72"> </td> <td>
</td></tr></tbody></table>
<br><br><br>
</div>
</div>
<!-- /.row -->
</div>
<!-- /.container-fluid -->
</div>
<!-- jQuery -->
<!-- Bootstrap Core JavaScript -->
<?php }else{
header("location:index.php");
} ?></div>
fname=
_SESSION['fname'];
if(''!=
_SESSION['admin']){
?>
<?php
include('connection.php');
if(@
