php 调用 execute,PHP致命错误：在第317行的...中的非对象上调用成员函数execute（）...

最新推荐文章于 2022-04-03 14:16:48 发布
最新推荐文章于 2022-04-03 14:16:48 发布
阅读量233 收藏
点赞数
文章标签： php 调用 execute

ar.php的浏览器输出

UPDATE playerstats_14_15 SET friendly_apps=friendly_apps+1 WHERE first_name='Chris' AND sur_name='Dunn';

UPDATE playerstats_14_15 SET friendly_apps=friendly_apps+1 WHERE first_name='Richard' AND sur_name='Tait';

UPDATE playerstats_14_15 SET friendly_apps=friendly_apps+1 WHERE first_name='Josh' AND sur_name='Coulson';

UPDATE playerstats_14_15 SET friendly_apps=friendly_apps+1 WHERE first_name='Tom' AND sur_name='Bonner';

UPDATE playerstats_14_15 SET friendly_apps=friendly_apps+1, friendly_assists=friendly_assists+1 WHERE first_name='Greg' AND sur_name='Taylor';

UPDATE playerstats_14_15 SET friendly_apps=friendly_apps+1, friendly_assists=friendly_assists+1 WHERE first_name='Ryan' AND sur_name='Donaldson';

UPDATE playerstats_14_15 SET friendly_apps=friendly_apps+1 WHERE first_name='Tom' AND sur_name='Champion';

UPDATE playerstats_14_15 SET friendly_apps=friendly_apps+1, friendly_yellows=friendly_yellows+1 WHERE first_name='Issaga' AND sur_name='Diallo';

UPDATE playerstats_14_15 SET friendly_apps=friendly_apps+1 WHERE first_name='Harrison' AND sur_name='Dunk';

UPDATE playerstats_14_15 SET friendly_apps=friendly_apps+1 WHERE first_name='Adam' AND sur_name='Cunnington';

UPDATE playerstats_14_15 SET friendly_apps=friendly_apps+1, friendly_goals=friendly_goals+2 WHERE first_name='Kwesi' AND sur_name='Appiah';

conn.php

//localhost settingd

$server = "localhost";

$username = "root";

$password = "";

$database = "stats";

//deployment settings

// $server = "localhost";

// $username = "cufcstat_admin";

// $password = "";

// $database = "cufcstat_stats";

$mysqli = new mysqli($server, $username, $password, $database);

if ($mysqli->connect_errno) {

echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;

}

?>

ar.php

error_reporting(E_ALL);

ini_set('display_errors', 1);

session_start();

require 'conn.php';

$season1 = explode("/", $_SESSION['season']);

$table = "results_" . $season1[0] . "_" . $season1[1];

$table2 = "fixtures_" . $season1[0] . "_" . $season1[1];

$fixture = explode("/", $_SESSION['oppo']);

$resultDate = $fixture[0];

$resultOppo = $fixture[1];

$resultType = "";

$resultComp = "";

$resultPlace = "";

$resultGoalsfor = $_SESSION['goalsfor'];

$resultGoalsagainst = $_SESSION['goalsagainst'];

$resultAtt = $_SESSION['att'];

$resultUnitedPlayer = array();

$resultOppoPlayer = array();

$resultUnitedSub = array();

$resultOppoSub = array();

$sqlStatements = array();

$sql="SELECT type, competition, place FROM " . $table2 . " WHERE date='" . $resultDate . "' AND opposition='" . $resultOppo . "'";

$stmt = $mysqli->prepare($sql);

$stmt->execute();

$stmt->store_result();

$stmt->bind_result($type, $competition, $place);

while ($stmt->fetch()) {

$resultType = $type;

$resultComp = $competition;

$resultPlace = $place;

}

$stmt->close();

//CUFC Players (number.firstname.surname.goals.yellow?.red?) (01.kai.day.34/54.y.n)

for($i = 1; $i < 12; $i++) {

$player = explode("/", $_SESSION['cufc_player_'.$i]);

$str = $player[0] . "." . $player[1] . "." . $player[2];

$playerSQL = "";

$playerSQL = "UPDATE playerstats_".$season1[0]."_".$season1[1]." SET ".$resultType."_apps=".$resultType."_apps+1";

//Check for goals

$goals = "0";

$numGoals = 0;

$multi = "0";

for($j = 1; $j < $resultGoalsfor + 1; $j++) {

if($player[0] . "/" . $player[1] . "/" . $player[2] == $_SESSION['cufc_goalscorer_'.$j]) {

$goals = "1";

$numGoals++;

if($multi == "0") {

$str = $str . "." . $_GET['cufc_goalscorer_'.$j.'_min'];

$multi = "1";

} else {

$str = $str . "/" .$_GET['cufc_goalscorer_'.$j.'_min'];

}

}

}

if($goals == "0") {

$str = $str . ".";

} else {

$playerSQL = $playerSQL . ", " .$resultType."_goals=".$resultType."_goals+".$numGoals;

}

if($_SESSION['cufc_player_'.$i.'_assist'] != "0") {

$playerSQL = $playerSQL . ", " .$resultType."_assists=".$resultType."_assists+".$_SESSION['cufc_player_'.$i.'_assist'];

}

//Check for yellow

if(isset($_SESSION['cufc_player_'.$i.'_yellow'])) {

if($_SESSION['cufc_player_'.$i.'_yellow'] == "1") {

$str = $str . ".y";

$playerSQL = $playerSQL . ", " .$resultType."_yellows=".$resultType."_yellows+1";

} else {

$str = $str . ".n";

}

} else {

$str = $str . ".n";

}

//Check for red

if(isset($_SESSION['cufc_player_'.$i.'_red'])) {

if($_SESSION['cufc_player_'.$i.'_red'] == "1") {

$str = $str . ".y";

$playerSQL = $playerSQL . ", " .$resultType."_reds=".$resultType."_reds+1 WHERE first_name='".$player[1]."' AND sur_name='".$player[2]."'";

} else {

$str = $str . ".n";

$playerSQL = $playerSQL . " WHERE first_name='".$player[1]."' AND sur_name='".$player[2]."';";

}

} else {

$str = $str . ".n";

}

$resultUnitedPlayer[$i] = $str;

array_push($sqlStatements, $playerSQL);

}

//Oppo Players (number.firstname.surname.goals.yellow?.red?) (01.kai.day.34/54.y.n)

for($i = 1; $i < 12; $i++) {

$str = $_SESSION['oppo_player_'.$i.'_number'] . "." . $_SESSION['oppo_player_'.$i.'_firstname'] . "." . $_SESSION['oppo_player_'.$i.'_surname'];

//Check for goals

$goals = "0";

$multi = "0";

for($j = 1; $j < $resultGoalsagainst + 1; $j++) {

if($_SESSION['oppo_player_'.$i.'_firstname'] . "." . $_SESSION['oppo_player_'.$i.'_surname'] == $_SESSION['oppo_goalscorer_'.$j.'_firstname'] . "." . $_SESSION['oppo_goalscorer_'.$j.'_surname']) {

$goals = "1";

if($multi == "0") {

$str = $str . "." . $_GET['oppo_goalscorer_'.$j.'_min'];

$multi = "1";

} else {

$str = $str . "/" .$_GET['oppo_goalscorer_'.$j.'_min'];

}

}

}

if($goals == "0") {

$str = $str . ".";

}

//Check for yellow

if(isset($_SESSION['oppo_player_'.$i.'_yellow'])) {

if($_SESSION['oppo_player_'.$i.'_yellow'] == "1") {

$str = $str . ".y";

} else {

$str = $str . ".n";

}

} else {

$str = $str . ".n";

}

//Check for red

if(isset($_SESSION['oppo_player_'.$i.'_red'])) {

if($_SESSION['oppo_player_'.$i.'_red'] == "1") {

$str = $str . ".y";

} else {

$str = $str . ".n";

}

} else {

$str = $str . ".n";

}

$resultOppoPlayer[$i] = $str;

}

//CUFC Subs (number.firstname.surname.goals.yellow?.red?.sub?) (01.kai.day.34/54.y.n.80/Cunnington)

for($i = 1; $i < 12; $i++) {

if(isset($_SESSION['cufc_sub_'.$i]) && $_SESSION['cufc_sub_'.$i] != "-") {

$player = explode("/", $_SESSION['cufc_sub_'.$i]);

$str = $player[0] . "." . $player[1] . "." . $player[2];

$playerSQL = "";

if($_SESSION['cufc_sub_'.$i.'_replaced'] == "1") {

$playerSQL = "UPDATE playerstats_".$season1[0]."_".$season1[1]." SET ".$resultType."_subapps=".$resultType."_subapps+1";

}

//Check for goals

$goals = "0";

$numGoals = 0;

$multi = "0";

for($j = 1; $j < $resultGoalsfor + 1; $j++) {

if($player[0] . "/" . $player[1] . "/" . $player[2] == $_SESSION['cufc_goalscorer_'.$j]) {

$goals = "1";

$numGoals++;

if($multi == "0") {

$str = $str . "." . $_GET['cufc_goalscorer_'.$j.'_min'];

$multi = "1";

} else {

$str = $str . "/" .$_GET['cufc_goalscorer_'.$j.'_min'];

}

}

}

if($goals == "0") {

$str = $str . ".";

} else {

$playerSQL = $playerSQL . ", " .$resultType."_goals=".$resultType."_goals+".$numGoals;

}

if($_SESSION['cufc_sub_'.$i.'_assist'] != "0") {

$playerSQL = $playerSQL . ", " .$resultType."_assists=".$resultType."_assists+".$_SESSION['cufc_sub_'.$i.'_assist'];

}

//Check for yellow

if(isset($_SESSION['cufc_sub_'.$i.'_yellow'])) {

if($_SESSION['cufc_sub_'.$i.'_yellow'] == "1") {

$str = $str . ".y";

$playerSQL = $playerSQL . ", " .$resultType."_yellows=".$resultType."_yellows+1";

} else {

$str = $str . ".n";

}

} else {

$str = $str . ".n";

}

//Check for red

if(isset($_SESSION['cufc_sub_'.$i.'_red'])) {

if($_SESSION['cufc_sub_'.$i.'_red'] == "1") {

$str = $str . ".y";

$playerSQL = $playerSQL . ", " .$resultType."_reds=".$resultType."_reds+1";

} else {

$str = $str . ".n";

}

} else {

$str = $str . ".n";

}

if($_SESSION['cufc_sub_'.$i.'_replaced'] == "1") {

$playerSQL = $playerSQL . " WHERE first_name='".$player[1]."' AND sur_name='".$player[2]."';";

}

//Did come on?

if($_SESSION['cufc_sub_'.$i.'_replaced'] == "1") {

$replacement = explode("/", $_SESSION['cufc_sub_'.$i.'_replacement']);

$str = $str . "." . $_SESSION['cufc_sub_'.$i.'_replacedTime'] . "/" . $replacement[2];

} else {

$str = $str . ".n";

}

array_push($sqlStatements, $playerSQL);

} else {

$str = "";

$playerSQL = "";

}

$resultUnitedSub[$i] = $str;

}

//Oppo Subs (number.firstname.surname.goals.yellow?.red?.sub?) (01.kai.day.34/54.y.n.80/Cunnington)

for($i = 1; $i < 12; $i++) {

if($_SESSION['oppo_sub_'.$i.'_number'] != null) {

$str = $_SESSION['oppo_sub_'.$i.'_number'] . "." . $_SESSION['oppo_sub_'.$i.'_firstname'] . "." . $_SESSION['oppo_sub_'.$i.'_surname'];

//Check for goals

$goals = "0";

$multi = "0";

for($j = 1; $j < $resultGoalsagainst + 1; $j++) {

if($_SESSION['oppo_sub_'.$i.'_firstname'] . "." . $_SESSION['oppo_sub_'.$i.'_surname'] == $_SESSION['oppo_goalscorer_'.$j.'_firstname'] . "." . $_SESSION['oppo_goalscorer_'.$j.'_surname']) {

$goals = "1";

if($multi == "0") {

$str = $str . "." . $_GET['oppo_goalscorer_'.$j.'_min'];

$multi = "1";

} else {

$str = $str . "/" .$_GET['oppo_goalscorer_'.$j.'_min'];

}

}

}

if($goals == "0") {

$str = $str . ".";

}

//Check for yellow

if(isset($_SESSION['oppo_sub_'.$i.'_yellow'])) {

if($_SESSION['oppo_sub_'.$i.'_yellow'] == "1") {

$str = $str . ".y";

} else {

$str = $str . ".n";

}

} else {

$str = $str . ".n";

}

//Check for red

if(isset($_SESSION['oppo_sub_'.$i.'_red'])) {

if($_SESSION['oppo_sub_'.$i.'_red'] == "1") {

$str = $str . ".y";

} else {

$str = $str . ".n";

}

} else {

$str = $str . ".n";

}

//Did come on?

if($_SESSION['oppo_sub_'.$i.'_replaced'] == "1") {

$str = $str . "." . $_SESSION['oppo_sub_'.$i.'_replacedTime'] . "/" . $_SESSION['oppo_sub_'.$i.'_replacement'];

} else {

$str = $str . ".n";

}

} else {

$str = "";

}

$resultOppoSub[$i] = $str;

}

$all_query_ok=true;

$sql = "INSERT INTO " . $table . " VALUES ('".$resultDate."', '".$resultOppo."', '".$resultType."', '".$resultComp."', '".$resultPlace."', '".$resultGoalsfor."', '".$resultGoalsagainst."', '".$resultAtt."', '".$resultUnitedPlayer[1]."', '".$resultUnitedPlayer[2]."', '".$resultUnitedPlayer[3]."', '".$resultUnitedPlayer[4]."', '".$resultUnitedPlayer[5]."', '".$resultUnitedPlayer[6]."', '".$resultUnitedPlayer[7]."', '".$resultUnitedPlayer[8]."', '".$resultUnitedPlayer[9]."', '".$resultUnitedPlayer[10]."', '".$resultUnitedPlayer[11]."', '".$resultUnitedSub[1]."', '".$resultUnitedSub[2]."', '".$resultUnitedSub[3]."', '".$resultUnitedSub[4]."', '".$resultUnitedSub[5]."', '".$resultUnitedSub[6]."', '".$resultUnitedSub[7]."', '".$resultUnitedSub[8]."', '".$resultUnitedSub[9]."', '".$resultUnitedSub[10]."', '".$resultUnitedSub[11]."', '".$resultOppoPlayer[1]."', '".$resultOppoPlayer[2]."', '".$resultOppoPlayer[3]."', '".$resultOppoPlayer[4]."', '".$resultOppoPlayer[5]."', '".$resultOppoPlayer[6]."', '".$resultOppoPlayer[7]."', '".$resultOppoPlayer[8]."', '".$resultOppoPlayer[9]."', '".$resultOppoPlayer[10]."', '".$resultOppoPlayer[11]."', '".$resultOppoSub[1]."', '".$resultOppoSub[2]."', '".$resultOppoSub[3]."', '".$resultOppoSub[4]."', '".$resultOppoSub[5]."', '".$resultOppoSub[6]."', '".$resultOppoSub[7]."', '".$resultOppoSub[8]."', '".$resultOppoSub[9]."', '".$resultOppoSub[10]."', '".$resultOppoSub[11]."')";

array_push($sqlStatements, $sql);

$sql = "DELETE FROM " . $table2 . " WHERE date='".$resultDate."' AND opposition='".$resultOppo."'";

array_push($sqlStatements, $sql);

$sql = "INSERT INTO latest_news VALUES (now(), 'New Result Added', 'Cambridge United ".$resultGoalsfor." - ".$resultGoalsagainst." ".$resultOppo."', 'match_result.php?season=".$_SESSION['season']."&date=".$resultDate."')";

array_push($sqlStatements, $sql);

try {

$mysqli->autocommit(FALSE);

for ($i = 0; $i < count($sqlStatements); $i++) {

$stmt = $mysqli->prepare($sqlStatements[$i]);

echo $sqlStatements[$i] . "";

$stmt->execute();

}

$mysqli->commit();

} catch(Exception $e) {

$mysqli->rollback();

$all_query_ok = false;

$reason = $e;

}

$mysqli->close();

最后一个查询失败，但所有其他查询都没问题。

错误是：

[08-Aug-2014 14:14:05 Europe/London] PHP Fatal error: Call to a member

function execute() on a non-object in /home/cufcstat/public_html/admin/ar.php

on line 317

我无法看到问题，有人可以吗？

SQL会停止执行代码，但对我来说SQL看起来是正确的吗？

对于凌乱的代码感到抱歉......

故小里
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
mysql预处理语句查询_mysqli_stmt类：使用预处理语句处理SELECT查询结果
weixin_29314405的博客
01-19 856
SELECT语句和其他的SQL查询命令不同，它需要处理查询结果。SQL语句的执行也需要使用mysqli_stmt对象中的execute()方法，但与mysqli对象中的query()方法不同，execute()方法的返回值并不是一个mysqli_result对象。mysqli_stmt对象提供了一种更为精巧的办法来处理SELECT语句查询结果：在使用execute()方法执行SQL语句完成查询之后...
php pdo execute,php sqlite3 pdo execute()报错
weixin_42184548的博客
03-10 200
php sqlite3 pdo execute()报错：call to a member function execute on boolean该如何解决？？？回复内容：php sqlite3 pdo execute()报错：call to a member function execute on boolean该如何解决？？？不得不吐槽下这个问题，你去看病，你给医生说：“我眼花，该怎么治”，然后...
php调用成员函数错误,PHP致命错误：在非对象上调用成员函数exec...
weixin_35698805的博客
04-08 260
我收到错误PHP致命错误：每当我调用类似的东西时,都在非对象上调用成员函数execute(),该对象引用….-> execute()行.$select_str = 'select id, stamp, lat, lng, spd from gps';$select = $db->prepare($select_str);$select->execute();要么$insert =...
php 禁用函数 exec 导致的错误
CyrusZhou的专栏
10-01 876
先上修复方式，打开 php.int 搜索disable_functions 删除后面的 exec 执行下面语句出错 ./bin/magento-cli cron:install 错误提示： PHP Fatal error: Uncaught Error: Call to a member function getMessage() on null in /www/wwwroot/magento/vendor/magento/framework/Crontab/CrontabManager.ph..
php pdo execute慢,PDO execute执行失败
weixin_42181929的博客
03-10 339
我将session存到mysql数据库中，并将sessionID另存到了一个用户表中。我想通过用户表中的sessionID查找session表中相应的数据。代码如下$sql = 'select update_time from admin_session,admin where admin_session.sessid = ?';$stmt = $pdo->prepare($sql);$st...
Failed to execute goal org...的解决办法
08-30
关于解决“Failed to execute goal org.apache.maven.plugins:maven-compiler-plugin:3.1”问题，首先需要了解Maven的构建生命周期，以及Maven的编译插件（maven-compiler-plugin）如何在编译过程中发挥作用。在使用...
Asp Conn.execute的参数与返回值总结
10-25
在ASP（Active Server Pages）开发中，`Conn.Execute`方法是用于执行SQL命令的关键函数，通常用于与数据库交互，如插入、更新、删除数据或执行存储过程。本文将深入探讨`Conn.Execute`的参数、返回值以及如何利用...
ASP中Server.Execute和Execute实现动态包含(include)脚本的区别
10-28
在讨论ASP中Server.Execute和Execute实现动态包含脚本的区别之前，我们先了解ASP（Active Server Pages）的基础知识。ASP是一种服务器端的脚本环境，用于创建动态交互式网页。ASP代码被嵌入HTML中，当用户请求页面时...
ASP中RecordSet Open和Connection.Execute一些区别与细节分享
10-14
在ASP（Active Server Pages）开发中，RecordSet对象和Connection对象是进行数据库操作的重要组成部分。本文将详细讨论RecordSet的Open方法和Connection的Execute方法之间的差异以及使用时的一些细节。 RecordSet的...
asp中的rs.open与conn.execute的区别说明
10-28
在ASP(Active Server Pages)开发中，`Rs.Open` 和 `Conn.Execute` 都是用来执行SQL语句的方法，但它们之间存在一些关键的区别。这里我们将深入探讨这两种方法的使用场景和特点。 首先，`Rs.Open` 方法是用于打开一...
php mysql execute,PHP mysqli致命错误：在布尔值上调用成员函数execute（）
weixin_35064596的博客
02-28 159
Quick question. Why does this error occur? I can't find a type or anything. (my code is a bit messy though)//Where i fill the names for the dropdown boxes//Fill the variables with the names$trade_item...
PHP PDO::execute()执行insert into失败返回错误无错误消息的解决
rushio的专栏
06-10 7904
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
php mysql函数未定义,PHP致命错误：调用未定义函数mysqli_stmt_get_result（）
weixin_30710557的博客
03-11 410
我不断收到错误PHP致命错误：调用未定义函数mysqli_stmt_get_result()。我正在使用PHP版本5.6，并在主机提供商c面板中启用了扩展mysqlind，但我不知道为什么仍然出现此错误。我进行了研究，发现每次需要启用mysqlind才能使用mysqli_stmt_get_result。任何人都可以协助/教导我在做什么错。谢谢。SIGNUP.PHP：session_start();...
php execute 更新不变,executeupdate php在服务器执行exec命令失败的解决方法
weixin_30050671的博客
03-26 256
前言：本文针对windows php环境，linux系统不在讨论范畴。出于安全的原因，服务器是不允许php或者其他语言执行exec命令的，当你有特殊需要php在服务器执行exec命令时，你需要设置两个地方，不然就无法执行成功。1、修改php.ini找到php配置文件php.ini，如果是用星外php自动安装程序配置php环境，这个文件就在C:\WINDOWS\这个目录里。在文件里搜索“disabl...
php调用成员函数错误,php – 致命错误：在非对象上调用成员函数query()
weixin_28854085的博客
04-08 255
我有这个错误：致命错误：在第8行的/Applications/XAMPP/xamppfiles/htdocs/login.php中调用非对象的成员函数query()这条线是这样的：$res = $mysqli->query("SELECT * FROM user WHERE user='$user' and password='$pw'");这是login.php：$user = $_POS...
MySQL预处理 mysql_stmt_execute()
muyuxuebao的博客
08-09 4317
参考   https://dev.mysql.com/doc/refman/5.7/en/mysql-stmt-execute.html
VS Code调试PHP代码时报错(PHP executable not found. Install PHP 7...)
m0_65699647的博客
04-03 7248
VS Code调试PHP代码时报错(PHP executable not found. Install PHP 7...)
mysql预处理stmt_mysqli_stmt类：使用预处理语句处理SELECT查询结果
weixin_33601402的博客
01-28 580
SELECT语句和其他的SQL查询命令不同，它需要处理查询结果。SQL语句的执行也需要使用mysqli_stmt对象中的execute()方法，但与mysqli对象中的query()方法不同，execute()方法的返回值并不是一个mysqli_result对象。mysqli_stmt对象提供了一种更为精巧的办法来处理SELECT语句查询结果：在使用execute()方法执行SQL语句完成查询之后...
Oracle PLSQL函数详解：创建与调用
函数在应用中展现出的主要优势在于它们能够扩展SQL的功能，执行复杂的计算或逻辑，同时提高查询性能。在使用函数时，确保返回的数据类型是Oracle支持的，并且调用者必须有EXECUTE权限。 函数与存储过程的调用方式...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值