php µ÷Óà execute,PHPÖÂÃü´íÎó£ºÔÚµÚ317ÐеÄ...ÖеķǶÔÏóÉϵ÷ÓóÉÔ±º¯Êýexecute£¨£©...

<div style="font-size:16px;">
<p>ar.phpµÄä¯ÀÀÆ÷Êä³ö</p>
<p>UPDATE playerstats_14_15 SET friendly_apps&#61;friendly_apps&#43;1 WHERE first_name&#61;&#39;Chris&#39; AND sur_name&#61;&#39;Dunn&#39;;</p>
<p>UPDATE playerstats_14_15 SET friendly_apps&#61;friendly_apps&#43;1 WHERE first_name&#61;&#39;Richard&#39; AND sur_name&#61;&#39;Tait&#39;;</p>
<p>UPDATE playerstats_14_15 SET friendly_apps&#61;friendly_apps&#43;1 WHERE first_name&#61;&#39;Josh&#39; AND sur_name&#61;&#39;Coulson&#39;;</p>
<p>UPDATE playerstats_14_15 SET friendly_apps&#61;friendly_apps&#43;1 WHERE first_name&#61;&#39;Tom&#39; AND sur_name&#61;&#39;Bonner&#39;;</p>
<p>UPDATE playerstats_14_15 SET friendly_apps&#61;friendly_apps&#43;1, friendly_assists&#61;friendly_assists&#43;1 WHERE first_name&#61;&#39;Greg&#39; AND sur_name&#61;&#39;Taylor&#39;;</p>
<p>UPDATE playerstats_14_15 SET friendly_apps&#61;friendly_apps&#43;1, friendly_assists&#61;friendly_assists&#43;1 WHERE first_name&#61;&#39;Ryan&#39; AND sur_name&#61;&#39;Donaldson&#39;;</p>
<p>UPDATE playerstats_14_15 SET friendly_apps&#61;friendly_apps&#43;1 WHERE first_name&#61;&#39;Tom&#39; AND sur_name&#61;&#39;Champion&#39;;</p>
<p>UPDATE playerstats_14_15 SET friendly_apps&#61;friendly_apps&#43;1, friendly_yellows&#61;friendly_yellows&#43;1 WHERE first_name&#61;&#39;Issaga&#39; AND sur_name&#61;&#39;Diallo&#39;;</p>
<p>UPDATE playerstats_14_15 SET friendly_apps&#61;friendly_apps&#43;1 WHERE first_name&#61;&#39;Harrison&#39; AND sur_name&#61;&#39;Dunk&#39;;</p>
<p>UPDATE playerstats_14_15 SET friendly_apps&#61;friendly_apps&#43;1 WHERE first_name&#61;&#39;Adam&#39; AND sur_name&#61;&#39;Cunnington&#39;;</p>
<p>UPDATE playerstats_14_15 SET friendly_apps&#61;friendly_apps&#43;1, friendly_goals&#61;friendly_goals&#43;2 WHERE first_name&#61;&#39;Kwesi&#39; AND sur_name&#61;&#39;Appiah&#39;;</p>
<p>conn.php</p>
<p>//localhost settingd</p>
<p>$server &#61; &#34;localhost&#34;;</p>
<p>$username &#61; &#34;root&#34;;</p>
<p>$password &#61; &#34;&#34;;</p>
<p>$database &#61; &#34;stats&#34;;</p>
<p>//deployment settings</p>
<p>// $server &#61; &#34;localhost&#34;;</p>
<p>// $username &#61; &#34;cufcstat_admin&#34;;</p>
<p>// $password &#61; &#34;&#34;;</p>
<p>// $database &#61; &#34;cufcstat_stats&#34;;</p>
<p>$mysqli &#61; new mysqli($server, $username, $password, $database);</p>
<p>if ($mysqli-&gt;connect_errno) {<!-- --></p>
<p>echo &#34;Failed to connect to MySQL: (&#34; . $mysqli-&gt;connect_errno . &#34;) &#34; . $mysqli-&gt;connect_error;</p>
<p>}</p>
<p>?&gt;</p>
<p>ar.php</p>
<p>error_reporting(E_ALL);</p>
<p>ini_set(&#39;display_errors&#39;, 1);</p>
<p>session_start();</p>
<p>require &#39;conn.php&#39;;</p>
<p>$season1 &#61; explode(&#34;/&#34;, $_SESSION[&#39;season&#39;]);</p>
<p>$table &#61; &#34;results_&#34; . $season1[0] . &#34;_&#34; . $season1[1];</p>
<p>$table2 &#61; &#34;fixtures_&#34; . $season1[0] . &#34;_&#34; . $season1[1];</p>
<p>$fixture &#61; explode(&#34;/&#34;, $_SESSION[&#39;oppo&#39;]);</p>
<p>$resultDate &#61; $fixture[0];</p>
<p>$resultOppo &#61; $fixture[1];</p>
<p>$resultType &#61; &#34;&#34;;</p>
<p>$resultComp &#61; &#34;&#34;;</p>
<p>$resultPlace &#61; &#34;&#34;;</p>
<p>$resultGoalsfor &#61; $_SESSION[&#39;goalsfor&#39;];</p>
<p>$resultGoalsagainst &#61; $_SESSION[&#39;goalsagainst&#39;];</p>
<p>$resultAtt &#61; $_SESSION[&#39;att&#39;];</p>
<p>$resultUnitedPlayer &#61; array();</p>
<p>$resultOppoPlayer &#61; array();</p>
<p>$resultUnitedSub &#61; array();</p>
<p>$resultOppoSub &#61; array();</p>
<p>$sqlStatements &#61; array();</p>
<p>$sql&#61;&#34;SELECT type, competition, place FROM &#34; . $table2 . &#34; WHERE date&#61;&#39;&#34; . $resultDate . &#34;&#39; AND opposition&#61;&#39;&#34; . $resultOppo . &#34;&#39;&#34;;</p>
<p>$stmt &#61; $mysqli-&gt;prepare($sql);</p>
<p>$stmt-&gt;execute();</p>
<p>$stmt-&gt;store_result();</p>
<p>$stmt-&gt;bind_result($type, $competition, $place);</p>
<p>while ($stmt-&gt;fetch()) {<!-- --></p>
<p>$resultType &#61; $type;</p>
<p>$resultComp &#61; $competition;</p>
<p>$resultPlace &#61; $place;</p>
<p>}</p>
<p>$stmt-&gt;close();</p>
<p>//CUFC Players (number.firstname.surname.goals.yellow?.red?) (01.kai.day.34/54.y.n)</p>
<p>for($i &#61; 1; $i &lt; 12; $i&#43;&#43;) {<!-- --></p>
<p>$player &#61; explode(&#34;/&#34;, $_SESSION[&#39;cufc_player_&#39;.$i]);</p>
<p>$str &#61; $player[0] . &#34;.&#34; . $player[1] . &#34;.&#34; . $player[2];</p>
<p>$playerSQL &#61; &#34;&#34;;</p>
<p>$playerSQL &#61; &#34;UPDATE playerstats_&#34;.$season1[0].&#34;_&#34;.$season1[1].&#34; SET &#34;.$resultType.&#34;_apps&#61;&#34;.$resultType.&#34;_apps&#43;1&#34;;</p>
<p>//Check for goals</p>
<p>$goals &#61; &#34;0&#34;;</p>
<p>$numGoals &#61; 0;</p>
<p>$multi &#61; &#34;0&#34;;</p>
<p>for($j &#61; 1; $j &lt; $resultGoalsfor &#43; 1; $j&#43;&#43;) {<!-- --></p>
<p>if($player[0] . &#34;/&#34; . $player[1] . &#34;/&#34; . $player[2] &#61;&#61; $_SESSION[&#39;cufc_goalscorer_&#39;.$j]) {<!-- --></p>
<p>$goals &#61; &#34;1&#34;;</p>
<p>$numGoals&#43;&#43;;</p>
<p>if($multi &#61;&#61; &#34;0&#34;) {<!-- --></p>
<p>$str &#61; $str . &#34;.&#34; . $_GET[&#39;cufc_goalscorer_&#39;.$j.&#39;_min&#39;];</p>
<p>$multi &#61; &#34;1&#34;;</p>
<p>} else {<!-- --></p>
<p>$str &#61; $str . &#34;/&#34; .$_GET[&#39;cufc_goalscorer_&#39;.$j.&#39;_min&#39;];</p>
<p>}</p>
<p>}</p>
<p>}</p>
<p>if($goals &#61;&#61; &#34;0&#34;) {<!-- --></p