Form input data bisa masuk ke database tetapi isinya sama seperti judul kolom table database

berikut ini coding form input saya:

<!DOCTYPE html> <html> <head> <title>Reprint Check</title> </head> <body> <form method="post" action="simpan.php"> <table width=450 border=1>

&lt;table width = 400 border = 1&gt;
	&lt;tr&gt;&lt;td colspan = 2&gt;&lt;b&gt;Reprint Check&lt;/td&gt;&lt;/tr&gt;
	&lt;tr&gt;&lt;td&gt;paying_company_code&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;paying_company_code&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
	&lt;tr&gt;&lt;td&gt;house_bank&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;house_bank&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
	&lt;tr&gt;&lt;td&gt;account_id&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;account_id&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
	&lt;/td&gt;&lt;/td&gt;
	&lt;tr&gt;&lt;td colspan = 2&gt;&lt;Left&gt;&lt;b&gt;Output Control&lt;/td&gt;&lt;/tr&gt;
	&lt;tr&gt;&lt;td&gt;printer_for_forms&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;printer_for_forms&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
	&lt;tr&gt;&lt;td&gt;print_advice_printer&lt;/td&gt;&lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;print_advice_printer&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
	&lt;/td&gt;&lt;/tr&gt;
	&lt;tr&gt;&lt;td&gt; &lt;/td&gt;
	&lt;td valign=&quot;top&quot;&gt;
	&lt;label&gt;&lt;input type=&quot;checkbox&quot; name=&quot;output_control[]&quot; value=&quot;print_immediately&quot;&gt;Print Immediately&lt;label/&gt;&lt;br&gt;
	&lt;label&gt;&lt;input type=&quot;checkbox&quot; name=&quot;output_control[]&quot; value=&quot;recipient&#039;s_lang&quot;&gt;Recipient&#039;s Lang&lt;label/&gt;&lt;br&gt;
	&lt;label&gt;&lt;input type=&quot;checkbox&quot; name=&quot;output_control[]&quot; value=&quot;currency_in_ISO_code&quot;&gt;Currency In ISO Code&lt;label/&gt;&lt;br&gt;
	&lt;label&gt;&lt;input type=&quot;checkbox&quot; name=&quot;output_control[]&quot; value=&quot;test_printout&quot;&gt;Test Printout&lt;label/&gt;&lt;br&gt;
	&lt;label&gt;&lt;input type=&quot;checkbox&quot; name=&quot;output_control[]&quot; value=&quot;do_not_void_any_checks&quot;&gt;Do Not Void Any Checks&lt;label/&gt;&lt;br&gt;
&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot;&gt;&lt;center&gt;&lt;button type=&quot;submit&quot; value=&quot;submit&quot;&gt;submit&lt;/button&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/center&gt;

</table> </body> </html>

dan Ini untuk coding koneksi ke database mysql: <?php //Koneksi ke MySQL $koneksi=mysqli_connect("localhost","root","","kuliah") or die ("Koneksi Gagal");

//memilih database database mysqli_select_db($koneksi,"kuliah");

//menyimpan data kedalam variabel $paying_company_code = $_POST['paying_company_code']; $house_bank = $_POST['house_bank']; $account_id = $_POST['account_id']; $printer_for_forms = $_POST['printer_for_forms']; $print_advice_printer = $_POST['print_advice_printer']; $output_control_array = $_POST['output_control']; //query SQL untuk insert data $query = "INSERT INTO reprintcheck (paying_company_code, house_bank, account_id, printer_for_forms, print_advice_printer, output_control) VALUES ('paying_company_code','house_bank','account_id','printer_for_forms','print_advice_printer','output_control')"; mysqli_query($koneksi, $query); //mengalihkan ke halaman index.php header("location:index.php"); ?>

jadi di database itu isinya misal untuk kolom paying_company_code adalah paying_company_code juga (maaf belum ngerti menysisipkan screenshot database)

mohon bantuannya terima kasih

avatar pemrogramanbisnis
@pemrogramanbisnis

1 Kontribusi 0 Poin

Dipost 6 hari yang lalu

Tanggapan

coba perbaiki kode di atas ya. Masukkan di tag kode ``` ````

Belum ada Jawaban. Jadi yang pertama Jawaban

Login untuk ikut Jawaban