首页delete from `order` where sno = 2 Warning: Undefined variable $cno in D:\apache3\apache3\Apache24\htdocs\baoxian\reduce_order.php on line 8 Fatal error: Uncaught TypeError: mysqli_query(): Argument #1 ($mysql) must be of type mysqli, null given in D:\apache3\apache3\Apache24\htdocs\baoxian\reduce_order.php:8 Stack trace: #0 D:\apache3\apache3\Apache24\htdocs\baoxian\reduce_order.php(8): mysqli_query(NULL, 'delete from `or...') #1 {main} thrown in D:\apache3\apache3\Apache24\htdocs\baoxian\reduce_order.php on line 8

delete from `order` where sno = 2 Warning: Undefined variable $cno in D:\apache3\apache3\Apache24\htdocs\baoxian\reduce_order.php on line 8 Fatal error: Uncaught TypeError: mysqli_query(): Argument #1 ($mysql) must be of type mysqli, null given in D:\apache3\apache3\Apache24\htdocs\baoxian\reduce_order.php:8 Stack trace: #0 D:\apache3\apache3\Apache24\htdocs\baoxian\reduce_order.php(8): mysqli_query(NULL, 'delete from `or...') #1 {main} thrown in D:\apache3\apache3\Apache24\htdocs\baoxian\reduce_order.php on line 8

时间: 2023-06-02 08:05:38 浏览: 93

基于Apache+PHP+MySQL实现的学生档案管理系统【100011429】

本项目为PHP实现的学生档案管理系统，分学生端和管理端，使用Apache+PHP+MySQL。学生端有登录、查询、修改密码等功能；服务器端有登录、查询修改等功能。学生端登录功能：选择学生登录入口，填写 sno 和 password，并输入验证码进行登录。修改密码：修改学生 password 查询功能：登录后选择所要查询内容的入口直接进行查看。修改个人信息功能：当特殊权限允许时，登录后选择个人信息入口可对个人信息进行修改。修改个人测评功能：当特殊权限允许时，登录后选择个人测评入口可对测评信息进行修改。查看其他档案功能：当特殊权限允许时，登录后选择其他档案入口可查看其他档案信息。管理端登录功能：选择管理员登录入口，填写 mno 和 password，并输入验证码进行登录。查询修改功能：登录后选择所要进行操作的入口进行增添、修改、删除，可以根据特定项模糊查询关键词。查询修改学生课程成绩功能：登录后选择学生课程成绩入口可进行增添、修改、删除，查询时可查找特定成绩范围。修改学生密码功能：登录后选择学生登录信息入口可进行增添、修改、删除，防止学生忘记密码。

这是一个PHP代码中的错误信息，大致意思是：在执行SQL语句时，出现了一些错误。具体来说，数据库中的“order”表中的“sno”为2的记录将被删除。但是在代码的第8行，变量“$cno”未被定义，导致程序出现错误。最终出现了“致命错误”，可能是因为mysqli_query函数的参数不正确导致的。

阅读全文

最新推荐

相关推荐

Python3教程：SQLite3数据库操作详解（创建、表结构与CRUD）

SQL练习：INSERT/UPDATE/DELETE操作详解

delete from user where sno = 1 Fatal error: Uncaught Error: Call to undefined function mysql_query() in D:\apache3\apache3\Apache24\htdocs\baoxian\reduce_user.php:8 Stack trace: #0 {main} thrown in D:\apache3\apache3\Apache24\htdocs\baoxian\reduce_user.php on line 8

数据库中delete from s where SNO = 'S2' delete from spj where SNO = 'S2'出现[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delete from spj where SNO = 'S2'' at line 2怎么办

USE JXGL GO CREATE TRIGGER delete_sc_s ON S INSTEAD OF DELETE AS DECLARE @s_no char(8) SELECT @s_no=sno FROM deleted DELETE FROM SC WHERE sno=@s_no DELETE FROM S WHERE sno=@s_no GO USE JXGL GO怎么调用这个触发器

select Sno,Sname from Student where Sno in(select distinct Sno from SC s1 where not exists(select * from SC s2 where s2.Sno='200215121' and not exists(select * from SC s3 where s1.Sno=s3.Sno and s2.Cno=s3.Cno))

SELECT DISTINCT sno FROM SC WHERE NOT EXISTS ( SELECT cno FROM SC AS T WHERE T.sno = '20201234567' AND NOT EXISTS( SELECT * FROM SC AS TT WHERE sno = TT.sno AND T.cno = TT.cno) );

找出错误并修改SELECT Sno,Sname,Sbirth,Sdept FROM s WHERE Sno in (SELECT Sno FROM sc WHERE Cno=(SELECT Cno FROM c WHERE Cname='

解释一下select Sname from student where not exists( select * from course where course.Cno in (1,2) and not exists( SELECT * from sc where Sno=student.Sno AND Cno=course.Cno ) )

select sname from student where not exists (select * from course where not exists (select * from sc where sno=student.sno and Cno=course.cno));

DELETE FROM course WHERE cno IN(SELECT cno FROM sc WHERE sno IN(SELECT sno FROM student WHERE sdept='计算机工程系'));这段查询代码有没有错误

CREATE VIEW V_SCG AS SELECT Sno,Sname,Cname,Score,Credit from student,grade,course WHERE grade.Sno = student.Sno AND grade.Cno = course.Cno AND Cno = '0001'; 哪里错了

String sql = "select * from sc where sno = '"+sno+"',cno='"+ cno +"'";帮我找出错误

SELECT SNO, Score FROM 选课表 WHERE SNO = 'S01' AND score > ANY ( SELECT score FROM 选课表 WHERE SNO = 'S02' ORDER BY Score ASC LIMIT 1,10 );消息 102，级别 15，状态 1，第 9 行 'LIMIT' 附近有语法错误。

select s.* from student s inner join sc ,course c ,teacher t on sc.SNO =s.SNO and c.CNO =sc.CNO and t.TNO =c.TNO where t.TNAME = '张三' order by sc.SCORE desc limit 1,1 这串sql有什么问题，怎么解决

SELECT SNAME FROM S WHERE Sno NOT IN (SELECT Sno FROM SC WHERE Cno = '002') 改用exist

最新推荐

C语言数组操作：高度检查器编程实践

管理建模和仿真的文件

【KUKA系统变量进阶】：揭秘从理论到实践的5大关键技巧

如何使用Python编程语言创建一个具有动态爱心图案作为背景并添加文字'天天开心（高级版）'的图形界面？

基于Swift开发的嘉定单车LBS iOS应用项目解析

"互动学习：行动中的多样性与论文攻读经历"

PROTEUS符号定制指南：个性化元件创建与修改的全面攻略

https://www.lagou.com/wn/爬取该网页职位名称，薪资待遇，学历，企业类型，工作地点数据保存为CSV文件的python代码

钗头凤声乐表演的二度创作分析报告

关系数据表示学习