gpt4 book ai didi

php - 尝试使用 PDO 从表单中插入数据

转载 作者:行者123 更新时间:2023-11-29 01:08:36 25 4
gpt4 key购买 nike

<分区>

我正在尝试从 mysql 切换到 PDO,但不确定如何解决这个问题我收到 fatal error :在线调用 C:\wamp\www\Systems\insert_process.php 中的未定义方法 PDO::prepared() 12 看看是否有人可以给我一个示例或为我指明正确的方向所有教程都向我展示了如何插入数据但没有使用提交表单。

<?php

$db_host = "localhost";
$db_username = "root";
$db_pass = "";
$db_name = "systems_requests";

$dbh = new PDO('mysql:host='.$db_host.';dbname='.$db_name,$db_username,$db_pass);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);

$add_member= $dbh->prepared("INSERT INTO requests(lanId, name, department, manager, request, request_description, request_comments, status, comments, compUser, compDt) Values (?,?,?,?,?,?,?,?,?,?)");
$add_member->bindParam(1, $_POST["lanId"]);
$add_member->bindParam(2, $_POST["name"]);
$add_member->bindParam(3, $_POST["department"]);
$add_member->bindParam(4, $_POST["manager"]);
$add_member->bindParam(5, $_POST["request"]);
$add_member->bindParam(6, $_POST["request_description"]);
$add_member->bindParam(7, $_POST["request_comments"]);
$add_member->bindParam(8, $_POST["status"]);
$add_member->bindParam(9, $_POST["comments"]);
$add_member->bindParam(10, $_POST["compUser"]);
$add_member->bindParam(11, $_POST["compDt"]);



$dbh->close();

$email = $_POST["emailaddress"];

$to = "";
$subject = "Systems Request";
$headers = "From: ";

$message = "LanID: " . $lanId . "

" ."User Name: ". $name ."

". "Department: " . $department . "

" ."Manager: ". $manager . "

". "User Request: " . $request . "

" ."User Request Description: ". $request_description . "

" ."User Request comments: ". $request_comments . "

" ."Status: " . $status . "

" ."Systems comments: ". $comments . "

" ."Completed by: ". $compUser ;

mail($to,$subject,$message,$headers);


echo ("<br> <a href='http://a0319p528/dc399Homepage/'> DC399Homepage </a>");
?>
<html>
<body>
<br><br><br>

<h1 align="center">Systems Request Confirmation</h1>
<p align="center">Thank you, <?php echo $_POST["name"]; ?><br><br>
Your request has been sent. Your request number is <?php echo $id;?><br>
Please write this number down or print this page out.</p>

<div align="center">
<h2>Request Information</h2>
Date Request: <?php $date = new DateTime();
echo $date->format('m/d/Y H:i:s') . "\n"; ?><br>
Manager: <?php echo $_POST["manager"]; ?><br>
Location: <?php echo $_POST["department"]; ?><br>
Request Issue: <?php echo $_POST["request"]; ?> <?php echo $_POST["request_description"]; ?><br>
Request Comments: <?php echo $_POST["request_comments"]; ?><br>
</div>
<div align="center">
<h2>Status Information</h2>
Status: <?php echo $_POST["status"]; ?><br><br><br><br>
</div>
<div align="center"><button onClick="window.print()">Print this page</button></div>
</body>
</html>

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com