分类导航

PHP 发布时间：2022-04-04 发布网站：大佬教程 code.js-code.com

大佬教程收集整理的这篇文章主要介绍了php-使用动态表单插入数据库，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

我正在尝试从动态表单向数据库中插入数据,成功地插入了数据,但是只有最新的输入字段将被添加到数据库中(示例：我使用Web中的按钮向表单中添加了新输入,则要插入的数据只是新输入,而没有插入新输入之前的输入).

<?PHP 
include 'config/db_connect.PHP';

if(isset($_POST['submit']))
{
     $i=0;
     foreach($_POST['kp_berjangka'] as $value){
    // insert query values can be fetched by
$file = $_POST['file'];
$SELEctidmax =MysqLi_query($con, "SELECT max(id_kebijakan) as maxidadmin FROM t_kebijakan WHERE id_kebijakan LIKE 'KO%'");
$hslidmax=MysqLi_fetch_array($SELEctidmaX);
$idmax=$hslidmax['maxidadmin'];
$nourut = (int) substr($idmax, 2,3);
$nourut++;
$IDbaru = "KO" . sprintf("%03s", $nourut);
$kp_saham = $_POST['kp_saham'][$i];
$pro_saham = $_POST['produk_saham'][$i];
$bung_saham = $_POST['bunga_saham'][$i];
$ket_saham = $_POST['ket_saham'][$i];
$kp_harian = $_POST['kp_harian'][$i];
$pro_harian = $_POST['produk_harian'][$i];
$bung_harian = $_POST['bunga_harian'][$i];
$ket_harian = $_POST['ket_harian'][$i];
$kp_berjangka = $_POST['kp_berjangka'][$i];
$pro_berjangka = $_POST['produk_berjangka'][$i];
$bung_berjangka = $_POST['bunga_berjangka'][$i];
$keT_Berjangka = $_POST['keT_Berjangka'][$i];
$kp_deposito = $_POST['kp_deposito'][$i];
$pro_deposito = $_POST['produk_deposito'][$i];
$bung_deposito = $_POST['bunga_deposito'][$i];
$ket_deposito = $_POST['ket_deposito'][$i];
$kp_pinjaman = $_POST['kp_pinjaman'][$i];
$pro_pinjaman = $_POST['produk_pinjaman'][$i];
$bung_pinjaman = $_POST['bunga_pinjaman'][$i];
$ket_pinjaman = $_POST['ket_pinjaman'][$i];
$id = $_POST['meja'][$i];

$query = MysqLi_query($con,"INSERT INTO t_kebijakan (id_kebijakan, file, kp_saham, produk_saham, bunga_saham, keterangan_saham, kp_harian, produk_harian, bunga_harian, keterangan_harian, kp_berjangka, produk_berjangka, bunga_berjangka, keterangan_berjangka, kp_deposito, produk_deposito, bunga_deposito, keterangan_deposito, kp_pinjaman, produk_pinjaman, bunga_pinjaman, keterangan_pinjaman, kode_cu) 
    VALUES (
    '$IDbaru',
    '$file',
    '$kp_saham',
    '$pro_saham',
    '$bung_saham',
    '$ket_saham',
    '$kp_harian',
    '$pro_harian',
    '$bung_harian',
    '$ket_harian',
    '$kp_berjangka',
    '$pro_berjangka',
    '$bung_berjangka',
    '$keT_Berjangka',
    '$kp_deposito',
    '$pro_deposito',
    '$bung_deposito',
    '$ket_deposito',
    '$kp_pinjaman',
    '$pro_pinjaman',
    '$bung_pinjaman',
    '$ket_pinjaman',
    '$id'
    )");
    }


if($query){
    header('LOCATIOn: home_cu.PHP');
}else{
    echo "data gagal dimasukan" . MysqLi_error($con) . MysqLi_errno($con);
}

}
?>
<!DOCTYPE html>
<html lang="en">
  <head>
    <Meta charset="utf-8">
    <Meta http-equiv="X-UA-Compatible" content="IE=edge">
    <Meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- The above 3 Meta tags *must* come first in the head; any other head content must come *after* these tags -->
    <title>Add More Input Form</title>

    <!-- Bootstrap -->
    <link href="assets/css/bootstrap.min.css" rel="stylesheet">

    <!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
      <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
      <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
  </head>
  <body>
    <?PHP 
    include 'config/db_connect.PHP';
    $kode_cu = $_GET['kode_cu'];
    $query_MysqL = MysqLi_query($con,"SELECT * FROM t_cu WHERE kode_cu='$kode_cu'")or die(MysqLi_error());
    $nomor = 1;
    while($data = MysqLi_fetch_array($query_MysqL)){
    ?>
    <div class="container">
        <h1 class="text-center">Tambah Data Kebijakan</h1>
        <form action="add_kebijakan.PHP" method="post">
        <h1 class="text-left">File</h1>
        <div class="form-content">
        <label>File :</label>
        <input type="file" name="file">
        <input type="hidden" value="<?PHP echo $data['kode_cu']?>" name="meja[]" class="form-control"/>
        </div>
                <h1 class="text-center">Produk Simpanan Saham</h1>
                <div class="form-content">
                <div class="row">
                    <div class="col-md-12">
                        <p><button type="button" id="btnAdd" class="btn btn-priMary">Add More</button></p>
                        <br/>
                    </div>
                </div>
                <div class="row group">
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Kode Produk :</label>
                            <input type="text" name="kp_saham[]" class="form-control">
                        </div>
                    </div>
                <?PHP } ?>
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Produk</label>
                            <input type="text" name="produk_saham[]" class="form-control">
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label>Bunga</label>
                            <input type="text" name="bunga_saham[]" class="form-control">
                        </div>
                    </div>
                    <div class="col-md-5">
                        <div class="form-group">
                            <label>Keterangan</label>
                            <textarea name="ket_saham[]" class="form-control" rows="3"></textarea>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <div class="form-group">
                            <button type="button" class="btn btn-danger btnRemove">Remove</button>
                        </div>
                    </div>
                </div>
            </div>
            <h1 class="text-center">Produk Simpanan Harian</h1>
                <div class="form-content">
                <div class="row">
                    <div class="col-md-12">
                        <p><button type="button" id="btnAdd" class="btn btn-priMary">Add More</button></p>
                        <br/>
                    </div>
                </div>
                <div class="row group">
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Kode Produk :</label>
                            <input type="text" name="kp_harian[]" class="form-control"/>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Produk</label>
                            <input type="text" name="produk_harian[]" class="form-control">
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label>Bunga</label>
                            <input type="text" name="bunga_harian[]" class="form-control">
                        </div>
                    </div>
                    <div class="col-md-5">
                        <div class="form-group">
                            <label>Keterangan</label>
                            <textarea name="ket_harian[]" class="form-control" rows="3"></textarea>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <div class="form-group">
                            <button type="button" class="btn btn-danger btnRemove">Remove</button>
                        </div>
                    </div>
                </div>
            </div>
            <h1 class="text-center">Produk Simpanan Berjangka</h1>
                <div class="form-content">
                <div class="row">
                    <div class="col-md-12">
                        <p><button type="button" id="btnAdd" class="btn btn-priMary">Add More</button></p>
                        <br/>
                    </div>
                </div>
                <div class="row group">
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Kode Produk :</label>
                            <input type="text" name="kp_berjangka[]" class="form-control"/>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Produk</label>
                            <input type="text" name="produk_berjangka[]" class="form-control">
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label>Bunga</label>
                            <input type="text" name="bunga_berjangka[]" class="form-control">
                        </div>
                    </div>
                    <div class="col-md-5">
                        <div class="form-group">
                            <label>Keterangan</label>
                            <textarea name="keT_Berjangka[]" class="form-control" rows="3"></textarea>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <div class="form-group">
                            <button type="button" class="btn btn-danger btnRemove">Remove</button>
                        </div>
                    </div>
                </div>
            </div>
            <h1 class="text-center">Produk Simpanan Deposito</h1>
                <div class="form-content">
                <div class="row">
                    <div class="col-md-12">
                        <p><button type="button" id="btnAdd" class="btn btn-priMary">Add More</button></p>
                        <br/>
                    </div>
                </div>
                <div class="row group">
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Kode Produk :</label>
                            <input type="text" name="kp_deposito[]" class="form-control"/>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Produk</label>
                            <input type="text" name="produk_deposito[]" class="form-control">
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label>Bunga</label>
                            <input type="text" name="bunga_deposito[]" class="form-control">
                        </div>
                    </div>
                    <div class="col-md-5">
                        <div class="form-group">
                            <label>Keterangan</label>
                            <textarea name="ket_deposito[]" class="form-control" rows="3"></textarea>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <div class="form-group">
                            <button type="button" class="btn btn-danger btnRemove">Remove</button>
                        </div>
                    </div>
                </div>
            </div>
            <h1 class="text-center">Produk Pinjaman</h1>
                <div class="form-content">
                <div class="row">
                    <div class="col-md-12">
                        <p><button type="button" id="btnAdd" class="btn btn-priMary">Add More</button></p>
                        <br/>
                    </div>
                </div>
                <div class="row group">
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Kode Produk :</label>
                            <input type="text" name="kp_pinjaman[]" class="form-control"/>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="form-group">
                            <label>Produk</label>
                            <input type="text" name="produk_pinjaman[]" class="form-control">
                        </div>
                    </div>
                    <div class="col-md-4">
                        <div class="form-group">
                            <label>Bunga</label>
                            <input type="text" name="bunga_pinjaman[]" class="form-control">
                        </div>
                    </div>
                    <div class="col-md-5">
                        <div class="form-group">
                            <label>Keterangan</label>
                            <textarea name="ket_pinjaman[]" class="form-control" rows="3"></textarea>
                        </div>
                    </div>
                    <div class="col-md-2">
                        <div class="form-group">
                            <button type="button" class="btn btn-danger btnRemove">Remove</button>
                        </div>
                    </div>
                </div>
            </div>
            <p>
            <button type="submit" class="btn btn-success" name="submit">Simpan</button>
            </p><br/>
        </form>
    </div>

    <!-- jQuery (necessary for Bootstrap's JavaScript plugins) -->
    <script src="assets/js/jquery.min.js"></script>
    <!-- Include all compiled plugins (below), or include individual files as needed -->
    <script src="assets/js/bootstrap.min.js"></script>
    <script src="jquery.multifield.min.js"></script>
    <script>
        $('.form-content').multifield({
            section: '.group',
            btnAdd:'#btnAdd',
            btnRemove:'.btnRemove',
        });
    </script>
  </body>
</html>

这是我添加echo“< pre>”; print_r($_ POST [‘kp_saham’]);之后的结果.

Array
(
    [0] => ASD
)
Array
(
    [0] => ADS
)
Array
(
    [0] => ASD
)
Array
(
    [0] => ASD
)
Array
(
    [0] => ADS
)
Array
(
    [0] => ADS
)
Array
(
    [0] => ASD
)
Array
(
    [0] => ASD
)
Array
(
    [0] => ASD
)
Array
(
    [0] => ADS
)
Array
(
    [0] => ASD
)
Array
(
    [0] => ASD
)
Array
(
    [0] => ASD
)
Array
(
    [0] => AD
)
Array
(
    [0] => ASD
)
Array
(
    [0] => ASD
)
Array
(




[0] => ASD
)
Array
(
    [0] => ASD
)
Array
(
    [0] => ASD
)
Array
(
    [0] => ASD
)
Array
(
    [0] => CO001
)

注意：ASD,ADS只是随机输入的单词

解决方法:

根据我的理解,您已经多次使用jquery multifield js生成某些表单字段.要保存多个记录,您必须执行以下步骤.

1.通过在输入控件的名称中添加[]来创建控件数组,即

<input type="text" name="kp_berjangka[]" class="form-control"/>

这需要使用所有需要存储在数据库中的输入字段来完成

2.在处理发布请求时,您需要使用循环保存数据.代码将类似这样.
即

 $i=0;
 foreach($_POST['kp_berjangka'] as $value){
    // insert query values can be fetched by
    $IDbaru = "KO" . sprintf("%03s", $nourut);
    $kp_saham = $_POST['kp_saham'][$i];
    $pro_saham = $_POST['produk_saham'][$i];
    $bung_saham = $_POST['bunga_saham'][$i];
    $ket_saham = $_POST['ket_saham'][$i];
    $kp_harian = $_POST['kp_harian'][$i];
    $pro_harian = $_POST['produk_harian'][$i];
    $bung_harian = $_POST['bunga_harian'][$i];
    $ket_harian = $_POST['ket_harian'][$i];
    $kp_berjangka = $_POST['kp_berjangka'][$i];
    $pro_berjangka = $_POST['produk_berjangka'][$i];
    $bung_berjangka = $_POST['bunga_berjangka'][$i];
    $keT_Berjangka = $_POST['keT_Berjangka'][$i];
    $kp_deposito = $_POST['kp_deposito'][$i];
    $pro_deposito = $_POST['produk_deposito'][$i];
    $bung_deposito = $_POST['bunga_deposito'][$i];
    $ket_deposito = $_POST['ket_deposito'][$i];
    $kp_pinjaman = $_POST['kp_pinjaman'][$i];
    $pro_pinjaman = $_POST['produk_pinjaman'][$i];
    $bung_pinjaman = $_POST['bunga_pinjaman'][$i];
    $ket_pinjaman = $_POST['ket_pinjaman'][$i];
    $id = $_POST['meja'][$i];

    $query = MysqLi_query($con,"INSERT INTO t_kebijakan (id_kebijakan, file, kp_saham, produk_saham, bunga_saham, keterangan_saham, kp_harian, produk_harian, bunga_harian, keterangan_harian, kp_berjangka, produk_berjangka, bunga_berjangka, keterangan_berjangka, kp_deposito, produk_deposito, bunga_deposito, keterangan_deposito, kp_pinjaman, produk_pinjaman, bunga_pinjaman, keterangan_pinjaman, kode_cu) 
        VALUES (
        '$IDbaru',
        '$file',
        '$kp_saham',
        '$pro_saham',
        '$bung_saham',
        '$ket_saham',
        '$kp_harian',
        '$pro_harian',
        '$bung_harian',
        '$ket_harian',
        '$kp_berjangka',
        '$pro_berjangka',
        '$bung_berjangka',
        '$keT_Berjangka',
        '$kp_deposito',
        '$pro_deposito',
        '$bung_deposito',
        '$ket_deposito',
        '$kp_pinjaman',
        '$pro_pinjaman',
        '$bung_pinjaman',
        '$ket_pinjaman',
        '$id'
    )");
}

通过使用此循环,您将获得表单提交的所有记录.

3.您无法使用$_POST [‘FILE’]保存文件,请从https://www.w3schools.com/php/php_file_upload.asp开始检查文件上传过程,这将为您提供帮助

大佬总结

以上是大佬教程为你收集整理的php-使用动态表单插入数据库全部内容，希望文章能够帮你解决php-使用动态表单插入数据库所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。

标签：

上一篇: PHP-如何扫描不存在的DynamoDb 下一篇:黄聪：wordpress登录后台后load-...

猜你在找的PHP相关文章

php实现mysql数据库分表分段备份 2019-11-12
php – 将Symfony2 LogoutSuccessHandler重定向到原始注销目标 2019-10-03
用PHP读取图像中的文本 2019-10-03
php – MySQL守护程序无法启动 – centos 6 2019-10-03
扩展PHP的类型提示 2019-10-03
如何在PHP中复制此C#散列？ (toByteArray(),ComputeHash()) 2019-10-03
php – 如何在Symfony2中禁用模板功能 2019-10-03
使用PHPUnit在Silex(mock closures)中进行测试 2019-10-03
php – 仅使用“桌面模式”浏览器检测移动用户 2019-10-03
PHP调用微博接口实现微博登录的方法示例 2022-04-09