18910140161

JavaScript-如何显示模式并获取更新数据-堆栈溢出

顺晟科技

2022-10-19 12:45:56

239

嗨,我想问一下我的问题,所以在我的例子中,我想从“编辑”按钮显示一个模态,然后模态根据ID从数据库中获取数据。这是我的代码,但仍然不起作用。你能告诉我哪里错过了它吗?

tokocrud.php

<?php
        include ('crudAction.php');

        function insertData($db, $tableName) {
            $data = [
                'id_ot' => ' ',
                'nama_ot' => $_POST['namaToko'],
                'alamat_ot' => $_POST['alamatToko'],
                'status_ot' => '1'
            ];

            if(!isDataTokoExist($db, $namaToko)) {
                session_start();
                include ('logger.php');
                $query = buildInsertQuery($tableName, $data);
                $idTarget = 'Master Barang';
                $data = ['username_pstr' => $_SESSION['username'], 'Create' => 'DataToko'];
                writeLogToko($db, $_SESSION['idpengguna'], $idTarget, 'Toko', 'Insert Data Toko', $data);
                return runQuery($db, $query, 'insert');
                
            }
            else {
                header('location: ' . $_REQUEST['pageReferrer'] . '&error=false&message=' . $result['message']);
                }
            }

        function updateData($db, $tableName) {
                $data = [
                    'id_ot' => ' ',
                    'nama_ot' => $_POST['namaToko'],
                    'alamat_ot' => $_POST['alamatToko']
                ];

                if(isset($_GET['idToko'])) {
                  $tokoId = $_GET['idToko'];
                  }
                $query = buildUpdateQuery($tableName, $data);
                $query .= " WHERE id_ot = '$tokoId' ";
                return runQuery($db, $query, 'update');
            }

        function isDataTokoExist($db, $namaToko) {
                $namaToko = $_POST['namaToko'];
                $query = "SELECT * FROM master_toko WHERE nama_ot = '$namaToko'";
                $result = mysqli_query($db, $query);
                return $result -> num_rows > 0;
            }
        
        function getDataToko() {
            $db = getDBConnection();
            $query = "SELECT * FROM master_toko ORDER BY id_ot DESC";
            $result= mysqli_query($db, $query);
            return $result;
        }

        function getDetailToko($db, $tableName) {
            $tokoId = $_GET['idToko'];
            $query = "SELECT * FROM $tableName WHERE id_ot = $tokoId";
            $result = runQuery($db, $query, 'select');

            return mysqli_fetch_array($result['data'], MYSQLI_ASSOC);

        }


        
    ?>

这是endpoint.php

<?php
        include ('crudAction.php');

        function insertData($db, $tableName) {
            $data = [
                'id_ot' => ' ',
                'nama_ot' => $_POST['namaToko'],
                'alamat_ot' => $_POST['alamatToko'],
                'status_ot' => '1'
            ];

            if(!isDataTokoExist($db, $namaToko)) {
                session_start();
                include ('logger.php');
                $query = buildInsertQuery($tableName, $data);
                $idTarget = 'Master Barang';
                $data = ['username_pstr' => $_SESSION['username'], 'Create' => 'DataToko'];
                writeLogToko($db, $_SESSION['idpengguna'], $idTarget, 'Toko', 'Insert Data Toko', $data);
                return runQuery($db, $query, 'insert');
                
            }
            else {
                header('location: ' . $_REQUEST['pageReferrer'] . '&error=false&message=' . $result['message']);
                }
            }

        function updateData($db, $tableName) {
                $data = [
                    'id_ot' => ' ',
                    'nama_ot' => $_POST['namaToko'],
                    'alamat_ot' => $_POST['alamatToko']
                ];

                if(isset($_GET['idToko'])) {
                  $tokoId = $_GET['idToko'];
                  }
                $query = buildUpdateQuery($tableName, $data);
                $query .= " WHERE id_ot = '$tokoId' ";
                return runQuery($db, $query, 'update');
            }

        function isDataTokoExist($db, $namaToko) {
                $namaToko = $_POST['namaToko'];
                $query = "SELECT * FROM master_toko WHERE nama_ot = '$namaToko'";
                $result = mysqli_query($db, $query);
                return $result -> num_rows > 0;
            }
        
        function getDataToko() {
            $db = getDBConnection();
            $query = "SELECT * FROM master_toko ORDER BY id_ot DESC";
            $result= mysqli_query($db, $query);
            return $result;
        }

        function getDetailToko($db, $tableName) {
            $tokoId = $_GET['idToko'];
            $query = "SELECT * FROM $tableName WHERE id_ot = $tokoId";
            $result = runQuery($db, $query, 'select');

            return mysqli_fetch_array($result['data'], MYSQLI_ASSOC);

        }


        
    ?>

这是formaction.php

<?php
        include ('crudAction.php');

        function insertData($db, $tableName) {
            $data = [
                'id_ot' => ' ',
                'nama_ot' => $_POST['namaToko'],
                'alamat_ot' => $_POST['alamatToko'],
                'status_ot' => '1'
            ];

            if(!isDataTokoExist($db, $namaToko)) {
                session_start();
                include ('logger.php');
                $query = buildInsertQuery($tableName, $data);
                $idTarget = 'Master Barang';
                $data = ['username_pstr' => $_SESSION['username'], 'Create' => 'DataToko'];
                writeLogToko($db, $_SESSION['idpengguna'], $idTarget, 'Toko', 'Insert Data Toko', $data);
                return runQuery($db, $query, 'insert');
                
            }
            else {
                header('location: ' . $_REQUEST['pageReferrer'] . '&error=false&message=' . $result['message']);
                }
            }

        function updateData($db, $tableName) {
                $data = [
                    'id_ot' => ' ',
                    'nama_ot' => $_POST['namaToko'],
                    'alamat_ot' => $_POST['alamatToko']
                ];

                if(isset($_GET['idToko'])) {
                  $tokoId = $_GET['idToko'];
                  }
                $query = buildUpdateQuery($tableName, $data);
                $query .= " WHERE id_ot = '$tokoId' ";
                return runQuery($db, $query, 'update');
            }

        function isDataTokoExist($db, $namaToko) {
                $namaToko = $_POST['namaToko'];
                $query = "SELECT * FROM master_toko WHERE nama_ot = '$namaToko'";
                $result = mysqli_query($db, $query);
                return $result -> num_rows > 0;
            }
        
        function getDataToko() {
            $db = getDBConnection();
            $query = "SELECT * FROM master_toko ORDER BY id_ot DESC";
            $result= mysqli_query($db, $query);
            return $result;
        }

        function getDetailToko($db, $tableName) {
            $tokoId = $_GET['idToko'];
            $query = "SELECT * FROM $tableName WHERE id_ot = $tokoId";
            $result = runQuery($db, $query, 'select');

            return mysqli_fetch_array($result['data'], MYSQLI_ASSOC);

        }


        
    ?>

这是crudaction.php

<?php
        include ('crudAction.php');

        function insertData($db, $tableName) {
            $data = [
                'id_ot' => ' ',
                'nama_ot' => $_POST['namaToko'],
                'alamat_ot' => $_POST['alamatToko'],
                'status_ot' => '1'
            ];

            if(!isDataTokoExist($db, $namaToko)) {
                session_start();
                include ('logger.php');
                $query = buildInsertQuery($tableName, $data);
                $idTarget = 'Master Barang';
                $data = ['username_pstr' => $_SESSION['username'], 'Create' => 'DataToko'];
                writeLogToko($db, $_SESSION['idpengguna'], $idTarget, 'Toko', 'Insert Data Toko', $data);
                return runQuery($db, $query, 'insert');
                
            }
            else {
                header('location: ' . $_REQUEST['pageReferrer'] . '&error=false&message=' . $result['message']);
                }
            }

        function updateData($db, $tableName) {
                $data = [
                    'id_ot' => ' ',
                    'nama_ot' => $_POST['namaToko'],
                    'alamat_ot' => $_POST['alamatToko']
                ];

                if(isset($_GET['idToko'])) {
                  $tokoId = $_GET['idToko'];
                  }
                $query = buildUpdateQuery($tableName, $data);
                $query .= " WHERE id_ot = '$tokoId' ";
                return runQuery($db, $query, 'update');
            }

        function isDataTokoExist($db, $namaToko) {
                $namaToko = $_POST['namaToko'];
                $query = "SELECT * FROM master_toko WHERE nama_ot = '$namaToko'";
                $result = mysqli_query($db, $query);
                return $result -> num_rows > 0;
            }
        
        function getDataToko() {
            $db = getDBConnection();
            $query = "SELECT * FROM master_toko ORDER BY id_ot DESC";
            $result= mysqli_query($db, $query);
            return $result;
        }

        function getDetailToko($db, $tableName) {
            $tokoId = $_GET['idToko'];
            $query = "SELECT * FROM $tableName WHERE id_ot = $tokoId";
            $result = runQuery($db, $query, 'select');

            return mysqli_fetch_array($result['data'], MYSQLI_ASSOC);

        }


        
    ?>

这是master_toko.php

<?php
        include ('crudAction.php');

        function insertData($db, $tableName) {
            $data = [
                'id_ot' => ' ',
                'nama_ot' => $_POST['namaToko'],
                'alamat_ot' => $_POST['alamatToko'],
                'status_ot' => '1'
            ];

            if(!isDataTokoExist($db, $namaToko)) {
                session_start();
                include ('logger.php');
                $query = buildInsertQuery($tableName, $data);
                $idTarget = 'Master Barang';
                $data = ['username_pstr' => $_SESSION['username'], 'Create' => 'DataToko'];
                writeLogToko($db, $_SESSION['idpengguna'], $idTarget, 'Toko', 'Insert Data Toko', $data);
                return runQuery($db, $query, 'insert');
                
            }
            else {
                header('location: ' . $_REQUEST['pageReferrer'] . '&error=false&message=' . $result['message']);
                }
            }

        function updateData($db, $tableName) {
                $data = [
                    'id_ot' => ' ',
                    'nama_ot' => $_POST['namaToko'],
                    'alamat_ot' => $_POST['alamatToko']
                ];

                if(isset($_GET['idToko'])) {
                  $tokoId = $_GET['idToko'];
                  }
                $query = buildUpdateQuery($tableName, $data);
                $query .= " WHERE id_ot = '$tokoId' ";
                return runQuery($db, $query, 'update');
            }

        function isDataTokoExist($db, $namaToko) {
                $namaToko = $_POST['namaToko'];
                $query = "SELECT * FROM master_toko WHERE nama_ot = '$namaToko'";
                $result = mysqli_query($db, $query);
                return $result -> num_rows > 0;
            }
        
        function getDataToko() {
            $db = getDBConnection();
            $query = "SELECT * FROM master_toko ORDER BY id_ot DESC";
            $result= mysqli_query($db, $query);
            return $result;
        }

        function getDetailToko($db, $tableName) {
            $tokoId = $_GET['idToko'];
            $query = "SELECT * FROM $tableName WHERE id_ot = $tokoId";
            $result = runQuery($db, $query, 'select');

            return mysqli_fetch_array($result['data'], MYSQLI_ASSOC);

        }


        
    ?>

顺晟科技:

  • TAG:
相关文章
我们已经准备好了,你呢?
2024我们与您携手共赢,为您的企业形象保驾护航