<?php if($_POST){ // include database connection include database.php; try{ // insert query 01 $query = "INSERT INTO invoice_master SET y_sign=:y_sign, o_sign=:o_sign, tel=:tel, date=:date, terms=:terms, g_weight=:g_weight, n_weight=:n_weight, nop=:nop, payment=:payment, total=:invoice_total"; // prepare query for execution $stmt = $con->prepare($query); // posted values $y_sign=htmlspecialchars(strip_tags($_POST['y_sign'])); $o_sign=htmlspecialchars(strip_tags($_POST['o_sign'])); $tel=htmlspecialchars(strip_tags($_POST['tel'])); $terms=htmlspecialchars(strip_tags($_POST['terms'])); $g_weight=htmlspecialchars(strip_tags($_POST['g_weight'])); $n_weight=htmlspecialchars(strip_tags($_POST['n_weight'])); $nop=htmlspecialchars(strip_tags($_POST['nop'])); $payment=htmlspecialchars(strip_tags($_POST['payment'])); $invoice_total=htmlspecialchars(strip_tags($_POST['invoice_total'])); // bind the parameters $stmt->bindParam(':y_sign', $y_sign); $stmt->bindParam(':o_sign', $o_sign); $stmt->bindParam(':tel', $tel); $stmt->bindParam(':date', $date); $stmt->bindParam(':terms', $terms); $stmt->bindParam(':g_weight', $g_weight); $stmt->bindParam(':n_weight', $n_weight); $stmt->bindParam(':nop', $nop); $stmt->bindParam(':payment', $payment); $stmt->bindParam(':invoice_total', $invoice_total); // specify when this record was inserted to the database $date=date('m-d-Y'); /* $stmt->bindParam(':created', $created); */我想根據(jù)第一次插入原始數(shù)據(jù)更新 invoice_no 和 invoice_name。當(dāng)我們將發(fā)票詳細(xì)信息插入表格時(shí)，我創(chuàng)建了此代碼，我想生成自己的發(fā)票編號(hào)并將其插入表格。我有一個(gè)表格，它可以添加原始倍數(shù)，所以我需要將該表格數(shù)據(jù)插入表格，如果您是先生，請(qǐng)讓我清楚如何做這些事情..
1 回答
慕尼黑8549860
TA貢獻(xiàn)1818條經(jīng)驗(yàn) 獲得超11個(gè)贊
您正在使用PDOStatement::execute()：
$query1 = "UPDATE invoice_master SET invoice_no='$id/2019/2020' , invoice_name='TEMP01' WHERE $id";
if ($stmt->execute($query1)){但是PDO::query()，如果要?jiǎng)?chuàng)建新查詢或PDO::exec()要運(yùn)行查詢而不獲取結(jié)果，則必須使用 :
$query1 = "UPDATE invoice_master SET invoice_no='$id/2019/2020' , invoice_name='TEMP01' WHERE $id";
if ($con->exec($query1)){- 1 回答
- 0 關(guān)注
- 197 瀏覽
添加回答
舉報(bào)
0/150
提交
取消