這是自定義模板.我使用wordpress查詢編寫了Crud,以便在資料庫的自定義表中發送資料並从資料庫获取資料,插入查詢有效,但是更新和删除查詢無效.下面我给出更新和删除查詢,請建議是否有人知道?
<?php
/*
* Template Name: Show Form Template Page
*/
?>
<div class="container">
<div class="row">
<div class="col-md-12">
<table border="1">
<tr>
<th>Id</th>
<th>Name</th>
<th>Email</th>
<th>Gender</th>
<th>Age</th>
<th>Edit</th>
<th>Delete</th>
</tr>
<?php
global $wpdb;
$table = 'contact_form';
$result = $wpdb->get_results ( "SELECT * FROM $table" );
if(!empty($result)){
foreach ( $result as $print ) {
?>
<tr>
<td><?php echo $print->id;?></td>
<td><?php echo $print->names;?></td>
<td><?php echo $print->emails;?></td>
<td><?php echo $print->gender;?></td>
<td><?php echo $print->age;?></td>
<td><button class="">Edit</button></td>
<td><button name="delete">Delete</button></td>
</tr>
<?php
}
}
?>
</table>
<?php
$id= $result->id;
global $wpdb;
$table='contact form';
if (isset($_POST['update'])) {
$data=array(
'names' => $_POST['yourname'],
'emails' => $_POST['customer_email'],
'gender' => $_POST['customer_gender'],
'age' => $_POST['customer_age']
);
$wherecondition=array(
'id'=>$id
);
$updated=$wpdb->update($table, $data, $wherecondition);
}
if (isset($_POST['delete'])) {
$deletedrow= $wpdb->delete($table, $wherecondition);
}
?>
</div>
</div>
</div>
最新回復
- 6月前1 #
相似問題
- wordpress:如何通過ajax和jquery更新資料wordpresswpquerywordpressajaxwordpressjquerywordpressmysql2021-01-02 06:55
- wordpress:仅將媒體上傳到資料庫wordpressimageswordpressdatabasewordpressuploadswordpressmysqlwordpressmedia2021-01-02 06:25
- wordpress:應该通過$ wpdb-> close()關闭$ wpdbwordpresswpquerywordpressdatabasewordpresswpdb2020-12-21 19:28
- wordpress:使用wpdb-> query()函式是否是一種好习惯?wordpressfunctionswordpressdatabasewordpressquerywordpressmysql2020-12-10 10:27
- wordpress:如何做資料庫的下載統計?wordpresspluginswordpressdatabasewordpressmysqlwordpressstatistics2020-07-28 22:52
你在定義
$id
:您正在得到
$id
$result
中的欄位 .$result
是从資料庫get_results
返迴的物件的陣列 呼叫.看来您想使用$print
迴圈中当前行的變數,所以$id = $print->id