我遇到了這個問題，我的表單只發布了沒有任何值的列本身。我試圖找出問題所在，但沒有任何運氣。我的想法是變量有問題，但真的不知道出了什么問題。編輯：我已經解決了這個問題，它不是 PDO/php。只是 html 表單的結構錯誤，現在已修復多個表單。感謝所有的幫助！<?phpinclude ('../functions.php');$forare = $_POST ['forare'];$sjukskot = $_POST ['sjukskot'];$rakel = $_POST ['rakel'];$id = $_POST ['id'];$tillstand = $_POST ['tillstand'];$medvet = $_POST ['medvet'];$andn = $_POST ['andn'];$puls = $_POST ['puls'];$blodt = $_POST ['blodt'];$triage = $_POST ['triage'];$medvet2 = $_POST ['medvet2'];$andn2 = $_POST ['andn2'];$puls2 = $_POST ['puls2'];$blodt2 = $_POST ['blodt2'];$triage2 = $_POST ['triage2'];$behandling = $_POST ['behandling'];$anamnes = $_POST ['anamnes'];require_once('../configs/dbconfigpdo.php');try{$query = "INSERT INTO ambjournal (forare, sjukskot, rakel, id, tillstand, medvet, andn, puls, blodt, triage, medvet2, andn2, puls2, blodt2, triage2, behandling, anamnes) VALUES ('$forare', '$sjukskot', '$rakel', '$id', '$tillstand', '$medvet', '$andn', '$puls', '$blodt', '$triage', '$medvet2', '$andn2', '$puls2', '$blodt2', '$triage2', '$behandling', '$anamnes');";$stmt = $db->prepare($query);$stmt->bindparam(":forare",$forare);$stmt->bindparam(":sjukskot",$sjukskot);$stmt->bindparam(":rakel",$rakel);$stmt->bindparam(":id",$id);$stmt->bindparam(":tillstand",$tillstand);$stmt->bindparam(":medvet",$medvet);$stmt->bindparam(":andn",$andn);$stmt->bindparam(":puls",$puls);$stmt->bindparam(":blodt",$blodt);$stmt->bindparam(":triage",$triage);$stmt->bindparam(":medvet2",$medvet2);$stmt->bindparam(":andn2",$andn2);$stmt->bindparam(":puls2",$puls2);$stmt->bindparam(":blodt2",$blodt2);$stmt->bindparam(":triage2",$triage2);$stmt->bindparam(":behandling",$behandling);$stmt->bindparam(":anamnes",$anamnes);$stmt->execute();header ('Location: ../ambulansjournal.php');exit();}catch(PDOException $exception){die('ERROR: ' . $exception->getMessage());}?>
3 回答
慕妹3146593
TA貢獻1820條經驗 獲得超9個贊
您需要對此進行更改：
$query = "INSERT INTO ambjournal (forare, sjukskot, rakel, id, tillstand, medvet, andn, puls, blodt, triage, medvet2, andn2, puls2, blodt2, triage2, behandling, anamnes) VALUES ('$forare', '$sjukskot', '$rakel', '$id', '$tillstand', '$medvet', '$andn', '$puls', '$blodt', '$triage', '$medvet2', '$andn2', '$puls2', '$blodt2', '$triage2', '$behandling', '$anamnes');";
并將其替換為：
$query = "INSERT INTO ambjournal (forare, sjukskot, rakel, id, tillstand, medvet, andn, puls, blodt, triage, medvet2, andn2, puls2, blodt2, triage2, behandling, anamnes) VALUES (:forare, :sjukskot, :rakel, :id, :tillstand, :medvet, :andn, :puls, :blodt, :triage, :medvet2, :andn2, :puls2, :blodt2, :triage2, :behandling, :anamnes);";
更新：
你也可以這樣做：
$query = "INSERT INTO ambjournal (forare, sjukskot, rakel, id, tillstand, medvet, andn, puls, blodt, triage, medvet2, andn2, puls2, blodt2, triage2, behandling, anamnes) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);";
$stmt = $db->prepare($query);
$stmt->bindparam(1,$forare);
$stmt->bindparam(2,$sjukskot);
$stmt->bindparam(3,$rakel);
$stmt->bindparam(4,$id);
$stmt->bindparam(5,$tillstand);
$stmt->bindparam(6,$medvet);
$stmt->bindparam(7,$andn);
$stmt->bindparam(8,$puls);
$stmt->bindparam(9,$blodt);
$stmt->bindparam(10,$triage);
$stmt->bindparam(11,$medvet2);
$stmt->bindparam(12,$andn2);
$stmt->bindparam(13,$puls2);
$stmt->bindparam(14,$blodt2);
$stmt->bindparam(15,$triage2);
$stmt->bindparam(16,$behandling);
$stmt->bindparam(17,$anamnes);
$stmt->execute();
MM們
TA貢獻1886條經驗 獲得超2個贊
在查詢的第二部分，我的意思是“值”部分，您應該聲明以“：”開頭的參數，例如“：forare”。
您的查詢應該是：
$query = "INSERT INTO ambjournal (forare, sjukskot, rakel, id, tillstand, medvet, andn, puls, blodt, triage, medvet2, andn2, puls2, blodt2, triage2, behandling, anamnes) VALUES (':forare', ':sjukskot', ':rakel', ':id', ':tillstand', ':medvet', ':andn', ':puls', ':blodt', ':triage', ':medvet2', ':andn2', ':puls2', ':blodt2', ':triage2', ':behandling', ':anamnes');";
繁花不似錦
TA貢獻1851條經驗 獲得超4個贊
自從我使用 PDO 已經有一段時間了，但我記得我更容易將所有信息添加到一個數組中，然后通過使用相同的數組準備查詢來綁定參數。你可以做這樣的事情（整理 SQL 和數組以便于閱讀）：
$post_info = array(
'forare' => $_POST['forare'],
'sjukskot' => $_POST['sjukskot'],
'rakel' => $_POST['rakel'],
'id' => $_POST['id'],
'tillstand' => $_POST['tillstand'],
'medvet' => $_POST['medvet'],
'andn' => $_POST['andn'],
'puls' => $_POST['puls'],
'blodt' => $_POST['blodt'],
'triage' => $_POST['triage'],
'medvet2' => $_POST['medvet2'],
'andn2' => $_POST['andn2'],
'puls2' => $_POST['puls2'],
'blodt2' => $_POST['blodt2'],
'triage2' => $_POST['triage2'],
'behandling' => $_POST['behandling'],
'anamnes' => $_POST['anamnes']
);
$sql = 'INSERT INTO ambjournal
(forare,
sjukskot,
rakel,
id,
tillstand,
medvet,
andn,
puls,
blodt,
triage,
medvet2,
andn2,
puls2,
blodt2,
triage2,
behandling,
anamnes
)
VALUES
(
:forare,
:sjukskot,
:rakel,
:id,
:tillstand,
:medvet,
:andn,
:puls,
:blodt,
:triage,
:medvet2,
:andn2,
:puls2,
:blodt2,
:triage2,
:behandling,
:anamnes
)';
// Once you get this done, the next thing you do is prepare it and execute it with the array
$insert_query = $db->prepare($sql);
$insert_query->execute($post_info);
這必須有效，如果沒有，您可能有一些與數據相關的問題。不正確的數據類型、數據大小或缺少信息。
- 3 回答
- 0 關注
- 110 瀏覽
添加回答
舉報
0/150
提交
取消