php - 无法从 php 页面更新 mysql 表

Question

我发现这段代码在 mysql 中可以从另一个表中更新一个表

UPDATE `tabel_overzicht` set indoor_km = (select sum(indoor_km) as total FROM `Fietsen_2018` WHERE datum LIKE '%/11/%'), outdoor_km = (select sum(outdoor_km) as total FROM `Fietsen_2018` WHERE datum LIKE '%/11/%'), indoor_hoogte = (select sum(indoor_hoogte) as total FROM `Fietsen_2018` WHERE datum LIKE '%/11/%'),outdoor_hoogte = (select sum(outdoor_hoogte) as total FROM `Fietsen_2018` WHERE datum LIKE '%/11/%'),totaal_km = (select sum(indoor_km) + sum(round(outdoor_km)) as total from Fietsen_2018 WHERE datum LIKE '%/11/%'),totaal_hoogte = (select sum(indoor_hoogte) + sum(round(outdoor_hoogte)) as total from Fietsen_2018 WHERE datum LIKE '%/11/%') where maand = "11-nov"

我把这段代码放在一个php页面中

<?php
    session_start();
    $db = mysqli_connect('localhost', 'xx', 'xx', 'bruggie');// Check connection if (!$db) {die("Connection failed: " . mysqli_connect_error());}$sql = ($db, "UPDATE tabel_overzicht SET indoor_km = (select sum(indoor_km) as total FROM Fietsen_2018 WHERE datum LIKE '%/11/%'), outdoor_km = (select sum($
            $_SESSION['message'] = "Tabel zelf update uitgevoerd";
    }?>

但是当我启动我的 php 页面时出现错误

此页面无法正常工作 www.bruggie.be 目前无法处理此请求。HTTP 错误 500

标签： phpmysql

Answer 1

我在您的代码中看到了一个右大括号 }，但没有看到一个开头。也许这导致了错误。