html.编辑数据回显,从HTML表格编辑/更新MySQL数据库值

最新推荐文章于 2023-12-27 11:21:29 发布

转载最新推荐文章于 2023-12-27 11:21:29 发布 · 676 阅读

文章标签：

本文档展示了如何使用PHP处理动态HTML表单数据，将数据插入到MySQL数据库，并在提交后显示已插入的信息。同时，探讨了在表单中添加编辑功能，允许用户编辑已保存的记录，通过重定向到一个编辑页面实现数据更新。

我有一个表单，目前提交值到MySQL数据库。在每次提交完成后，刚刚插入到mysql数据库的数据将在表单下回显。该表格具有动态输入字段。我知道想要添加编辑以前插入的值的可能性。我放置了一个编辑按钮，将用户重定向到一个personel_edit.php页面，希望将所有输入字段填充到。在代码中，您将看到如何进行初始插入，然后在执行选择后显示插入的信息。但我不知道如何根据填充此动态字段或将数据传递到编辑页面？ Example从HTML表格编辑/更新MySQL数据库值

提交后 - 插入/显示

if(isset($_POST['submit'])){

$name = $_POST['name'];

$acad_id = $_POST['acad_id'];

$courses_offered=$_POST['courses_offered'];

$query_init = "INSERT INTO academy (name, academy_id) VALUES (:name, :acad_id);";

$query_prep = $db_con->prepare($query_init);

$insert_result = $query_prep->execute(array(

"name" => $name,

"acad_id" => $acad_id

));

$s = 1;

while(isset($_POST['person_fname_' . $s]))

{

$contact_role = isset($_POST['person_contact_' . $s]) ? 1 : 0;

$instructor_role = isset($_POST['person_instructor_' . $s]) ? 1 : 0;

$person_fname = $_POST['person_fname_' . $s];

$person_lname = $_POST['person_lname_' . $s];

$person_email = $_POST['person_email_' . $s];

$person_phone = $_POST['person_phone_' . $s];

$person_fax = $_POST['person_fax_' . $s];

$query_init2 = "INSERT INTO person (academy_id, contact_role, instructor_role, first_name, last_name, person_email, person_phone, person_fax) VALUES (:acad_id,:contact_role,:instructor_role,:person_fname,:person_lname,:person_email,:person_phone,:person_fax);";

$query_prep2 = $db_con->prepare($query_init2);

$insert_result2 = $query_prep2->execute(array(

"acad_id" => $acad_id,

"contact_role" => $contact_role,

"instructor_role" => $instructor_role,

"person_fname" => $person_fname,

"person_lname" => $person_lname,

"person_email" => $person_email,

"person_phone" => $person_phone,

"person_fax" => $person_fax

));

$s++;

}

$db_select = $db_con->prepare("

SELECT a.name,

a.academy_id,

p.contact_role,

p.instructor_role,

p.first_name,

p.last_name,

p.person_email,

p.person_phone,

p.person_fax

FROM academy a

INNER JOIN person p ON a.academy_id = p.academy_id

WHERE a.academy_id = :acad_id

");

if (!$db_select) return false;

if (!$db_select->execute(array(':acad_id' => $acad_id))) return false;

$results = $db_select->fetchAll(\PDO::FETCH_ASSOC);

if (empty($results)) return false;

$final_result = '';

$first = true;

foreach ($results as $value){

if($first){

$first = false;

$final_result .= "Academy Name: ".$value['name']." ID: ".$value['academy_id']."";

}

$final_result .= "---------------------PERSONEL-----------------------";

$final_result .= "First Name: ".$value['first_name']."Last Name: ".$value['last_name']."Email: ".$value['person_email']."";

$final_result .= "This person has the role of an instructor: ".$value['instructor_role']."This person has the role of a contact: ".$value['contact_role']."";

$final_result .= "Phone: ".$value['person_phone']."Fax: ".$value['person_fax']."";

}

$final_result .= 'Edit';

}

HTML表单

Name:

Academy

How many courses offered?

---Select---

Personel Information: