สอบถาม เออแบบนี้ต้องแก้ยังไงค่ะ

สำหรับผู้ที่ เริ่มต้น Programming - PHP มีอะไร แนะนำ หรือข้อสงสัยต้องบอร์ด นี้ คนที่มีความรู้ แบ่งปันคนอื่นบ้างนะ ปัญหาการเขียนโปรแกรม แบบ OOP Session Cookies php network

Moderator: mindphp, ผู้ดูแลกระดาน

suhaila
PHP Super Member
PHP Super Member
โพสต์: 480
ลงทะเบียนเมื่อ: 19/04/2021 9:51 am

สอบถาม เออแบบนี้ต้องแก้ยังไงค่ะ

โพสต์ที่ยังไม่ได้อ่าน โดย suhaila »

คือต้องการ insert ไอดีของข้อมูลตำบลทั้งหมดที่มีอยู่ในไอดีนั้นลงในตาราง tools_province_place
แล้วขึ้นเออแบบนี้

Warning: mysqli_multi_query() expects exactly 2 parameters, 1 given in C:\xampp\htdocs\Joomla3.9.26\tools\tools_recheck_province\index.php on line 198
Error: INSERT INTO tools_province_place(province_id, district_id) VALUES ('64', ' 3297 หนองบัวระเหว 3298 วังตะเฆ่ 3299 ห้วยแย้ 3300 โคกสะอาด 3301 โสกปลาดุก ' )
ต้องแก้ยังไงค่ะ
Programming - PHP-1.png
Programming - PHP-1.png (94.3 KiB) Viewed 52691 times

โค้ด: เลือกทั้งหมด

<?php
 date_default_timezone_set("Asia/Bangkok");
 $date = time();
 $time = (date("Y-m-d H:i:s", $date)) . "<br>";
 $ip = $_SERVER["REMOTE_ADDR"];
date_default_timezone_set("Asia/Bangkok");
require_once'conn.php';
include '../config.php';

?>
<link rel="stylesheet" href="../css/color.css">
<!-- <link rel="stylesheet" href="../tools_keyword_youtube/cssyou.css"> -->

<meta property="og:url"           content="<?php echo ((array_key_exists('HTTPS', $_SERVER) && $_SERVER["HTTPS"] == "on") ? 'https://' : 'http://') . $_SERVER['SERVER_NAME'] . $_SERVER['REQUEST_URI']; ?>"/>
<meta property="og:type"          content="website" />
<meta property="og:title"         content="<?php echo $lang_unitcomdate; ?>"/>
<meta property="og:description"   content="<?php echo $lang_unitcomdate; ?>"/>
<meta property="og:image"         content="https://www.mindphp.com/images/content/Tool/tools_search_keyword_youtube.png"/>
<meta property="og:image:alt"     content="<?php echo $lang_programconver; ?>"/>
<meta name="keywords"             content="<?php echo $lang_progrcalculatetaxkk; ?>"/>

<title><?php echo $lang_programconvertunit; ?></title>
<script type="application/ld+json">
    {
    "@context": "http://schema.org",
    "@type": "SoftwareApplication",
    "name": "keyword youtube",
    "image": "https://www.mindphp.com/images/info/mindphp-logo-v40.png",
    "description": "โปรแกรมสำหรับค้นหา keyword ของ youtube",
    "operatingSystem": "Windows 7",
    "applicationCategory": "http://schema.org/GameApplication",
    "aggregateRating": {
    "@type": "AggregateRating",
    "ratingValue": "4.7",
    "ratingCount": "23214"
    }
    }
</script>

<script src="https://www.google.com/recaptcha/api.js" asyncdefer></script>

<?php
include '../header.php';
include '../PHP-Pagination-master/Pagination.class.php';

ini_set('display_errors', 1);
error_reporting(~0);


$POSTCODE = null;

if (isset($_POST["POSTCODE"])) {
    $POSTCODE = $_POST["POSTCODE"];
}



$page = 1;
if (isset($_GET['page'])) {
    $page = $_GET['page'];
}
$row = 10;

$total_data = "SELECT COUNT(id) FROM $table_con";
$result_1 = mysqli_query($conn, $total_data);
$total = mysqli_fetch_row($result_1);
$total_data = $total[0];
$start = ($page - 1) * $row;
$Pagination = new Pagination($page, $total_data);
$Pagination->parse();

$sql = "SELECT * FROM $table_con WHERE name LIKE '%" . $POSTCODE . "%'  ORDER BY id DESC Limit $start,$row";
$result = mysqli_query($conn, $sql);
?>

<div class="container">
    <div class="col-md-12">
        <div class="row">
            <div class="btn-group btn-breadcrumb">
                <a  class="btn btn-default"><?php echo $lang_youarehere; ?> :</a>
                <a href="https://www.mindphp.com/online-tools/mindphp-tools.html" class="btn btn-default"><?php echo $lang_tools; ?></a>
                <a href="index.php?lang=<?php echo $lang; ?>" class="btn btn-primary"><?php echo $lang_programconvertunit; ?></a>
            </div>
        </div><br>
    </div>

    <div class="col-md-4">
        <?php //include 'menu_sidebar.php'; ?>
    </div>

    <div class=" col-md-8">
        <div class="col-md-12">
            <div class="panel panel-primary">
                <div class="panel-heading"><?php echo $lang_programconvertunit; ?></div>
                <div class="panel-body">
                    <form class="form-horizontal" name="frm" method="post" action="">
                        <br>
                        <div class="col-md-12">
                            <div class="form-group">
                                <label for="inputname" class="col-sm-3 control-label"><?php echo $lang_name; ?> : </label>
                                <div class="col-sm-9">
                                    <input required type="text" class="form-control" id="inputEmail3" placeholder="<?php echo $lang_pleaseyourname ?>" name="user_name">
                                </div>
                            </div>

                            <div class="form-group">
                                <label for="inputarea-value" class="col-sm-3 control-label"><?php echo $lang_unit; ?> :</label>
                                <div class="col-sm-9">
                                <input required type="" class="form-control" id="inputPassword3" placeholder="<?php echo $lang_enternumunit; ?>" name="valuenum">       </div>
                            </div>

                                <div class="col-md-12">
                                    <div align="center" class="g-recaptcha" required data-sitekey="<?php echo $keyrecaptcha; ?>"></div><br>
                                </div>
                                <br>
                                <div  class="col-md-12">
                                    <center>
                                        <input class=" btn btn-success" type="submit" name="submit" value="<?php echo $lang_calculate; ?>" />
                                        <input class="btn btn-danger" type="reset" name="reset" value="<?php echo $lang_cleaar; ?>"/>
                                    </center>
                                </div>

                        </div>
       
                        <div class="col-md-12">
                            <?php
                            if (isset($_POST['g-recaptcha-response'])) {
                                $keyrecaptcha = $_POST['g-recaptcha-response'];
                                $response = json_decode(file_get_contents("https://www.google.com/recaptcha/api/siteverify?secret=" . $secretkeyrecaptcha . "&response=" . $keyrecaptcha . "&remoteip=" . $_SERVER['REMOTE_ADDR']), true);
                                if (!$keyrecaptcha) {
                                    $missinginputsecret = "คลิกทำเครื่องหมายถูกตรวจสอบว่าคุณไม่ใช้โปรแกรมอัตโนมัติ";
                                    ?>
                                     <br><div align="center" class="unnit-color"><b><?php print_r($missinginputsecret) ?></b></div>
                                     <?php
                                }
                            }


                                if (isset($_POST['submit'])) {
                                    $submit1 = @$_POST['submit1'];
                                    $name = $_POST['user_name'];
                                    $value = $_POST['valuenum'];//เราต้องใส่ลิงยูทูปที่จะเปลี่ยนเป็นรหัสไปร
                                    // $key = '';
                                    $sql = "SELECT a.*, p.PROVINCE_NAME FROM mzc_mamphur AS a 
                                    LEFT JOIN mzc_mprovince AS p ON p.PROVINCE_ID = a.PROVINCE_ID 
                                    WHERE a.POSTCODE =$value";
                                     $result2 = mysqli_query($conn, $sql);
                                     $amphor_data = mysqli_fetch_assoc($result2);
                                     $provice_name = $amphor_data['PROVINCE_NAME'];
                                     $province_id =$amphor_data['PROVINCE_ID']; 
                                     $amphor_name =$amphor_data['AMPHUR_NAME'];
                                     $amphor_id =$amphor_data['AMPHUR_ID'];
                                     

                                     $sql = "SELECT DISTRICT_ID ,DISTRICT_NAME FROM mzc_mdistrict WHERE AMPHUR_ID = ".$amphor_id;
                                     $result = mysqli_query($conn, $sql);
                                     $district_items = array();
                                     while($district_data = mysqli_fetch_assoc($result))
                                     {
                                        $district_items[] = $district_data;
                                     }

                                     //print_r($district_items);exit();
                                        // นำไปใช้

                                        $district_value ='';
                                            foreach ($district_items as $district_items => $values)
                                        {
                                                foreach ($values as $valu)
                                                        {            
                                                            $district_value = $district_value.' '.$valu;
                                                        }
                                        }
                                        // foreach ($district_items as $district_items => $values)
                                        // {
                                        //     //echo $district_items;
                                        //     foreach ($values as $valu)
                                        //     {            
                                        //         echo $valu;
                                        //     }

                                        // }

                                    
                

                                    $sql3 = "INSERT INTO tools_province ( `user_name`, `PROVINCE_ID`,`DISTRICT_ID`,`AMPHUR_ID`,`postcode`, `create_date`, `ip`) 
                                    VALUES ('$name','$province_id','$district_value','$amphor_id','$value','$time','$ip')";
                                     $result2 = mysqli_query($conn, $sql3);

                                     
                                     $conn->insert_id;
                                     $sql2 = "INSERT INTO  tools_province_place(province_id, district_id)
                                         VALUES ('$conn->insert_id', '$district_value' )";
                                         //$conn->query($sql2);
                                     
                                         if (mysqli_multi_query($conn->query($sql2))) {
                                           
                                          } else {
                                            echo "Error: " . $sql2 . "<br>" . mysqli_error($conn);
                                          }

                                    //  if ($conn->query($sql2) == TRUE) {
                                    //     // $p_id = $conn->insert_id;
                                    //  //foreach ($_REQUEST['check_id'] as $key => $m_id) {
                                    //    //$amount =$_REQUEST["amount"][$key];
                                    
                                    //     //  $sql2 = "INSERT INTO  tools_province_place(province_id, district_id)
                                    //     //  VALUES ('$p_id', '$district_value' )";
                                    //     //  $conn->query($sql2);

                                    //     //   (mysqli_multi_query($conn, $sql2)) 
                                    //     } else {
                                        
                                    //         echo "Error: " . $sql2 . "<br>" . $conn->error;
                                          
                                    //     }
                               
                                    
                                     //mysql_query("INSERT INTO `tools_province_place` (`province_id`) VALUES ('" . mysql_insert_id() . "')");

                                   
                                    
                                    


                                      
                                    
                                     // $sql5 = "select * From tools_province where id  = '$id' ";
                                    // $result5 = mysqli_query($conn, $sql5);
                                    // $row = odbc_fetch_array($result5);
                                    // // echo $row['id'];
                                    // $sql5 = "INSERT INTO tools_province_place ('tools_province_id','district_id') 
                                    // VALUES ('$id','$district_items') ";
                                    // $result6 = mysqli_query($conn, $sql5);

                                    
                                    // $sql5 = "INSERT INTO 'toos_province_place' ('tools_province_id','district_id)values' ('$table_con','$district_items') ";
                                    // $result5 = mysqli_query($conn, $sql5) or die ("Error in query: $sql5 " . mysqli_error());

                                     
                                    // $sql = "SELECT * FROM `mzc_mdistrict`WHERE `DISTRICT_CODE` = $value ";
                                    // $result2 = mysqli_query($conn, $sql);
                                    // while (@$fetch1 = mysqli_fetch_assoc($result2)) {
                    
                                    // $district =    $fetch1['DISTRICT_NAME'];
                                    // $provinceId =    $fetch1['PROVINCE_ID'];  
                                    // $amphorid =  $fetch1['AMPHUR_ID'];
                                    // }
                                    // $sql1 = "SELECT * FROM `mzc_mprovince` WHERE PROVINCE_ID = $provinceId";
                                    // $result3 = mysqli_query($conn, $sql1);
                                    // while (@$fetch2 = mysqli_fetch_assoc($result3)) {
                                    //         $provice_name = $fetch2['PROVINCE_NAME'];
                                    //     }
                                
                              
                                
                                ?>

                                <table class="table">
                                    <tbody>
                                        <tr class="active">
                                            <td align="right" width="50%">
                                                <?php echo $lang_name . " : "; ?>
                                            </td>
                                            <td>
                                                <?php echo $name; ?>
                                            </td>
                                        </tr>
                                        <tr class="warning">
                                            <td align="right" width="50%">
                                                <?php echo $lang_showunitsthat . "  :"; ?>
                                            </td>
                                            <td>
                                                <?php echo $value . "   "; ?>
                                            </td>
                                        </tr>  

                                        <tr class="active">
                                            <td align="right" width="50%">
                                               <?php  echo $lang_place . "  :"; ?>
                                            </td>
                                            <td> 
                                                <?php echo $district_value  ; ?>                                           
                                            </td>
                                        </tr>

                                        <tr class="warning">
                                            <td align="right" width="50%">
                                                <?php  echo $lang_province . "  :"; ?>
                                            </td>
                                            <td>
                                                <?php  echo $provice_name; ?>
                                            </td>
                                        </tr>

                                        <tr class="active">
                                            <td align="right" width="50%">
                                                <?php  echo $lang_district. "  :"; ?>
                                            </td>
                                            <td>
                                                <?php echo $amphor_name ;?>
                                            </td>
                                        </tr>
                                        
                                        <tr class="active">
                                            <td align="right" width="50%">
                                                <?php echo $lang_recordtime . " :" ?>
                                            </td>
                                            <td>
                                                <?php echo date("Y-m-d  H:i:s", time()); ?>
                                            </td>
                                        </tr>

                                        <tr class="warning">
                                            <td align="right" width="50%">
                                                <?php echo $lang_ipaddress . "  : "; ?>
                                            </td>
                                            <td>
                                                <?php echo $ip. "   "; ?>
                                            </td>
                                        </tr>
                                    </tbody>
                                </table>

                                <center><a href="index.php?lang=<?php echo $lang; ?>" class="btn btn-info"><?php echo $lang_resets;?></a></center>

                                <?php
                            }
                            ?>
                        </div>
                    </form>
                    <div align="right"> <?php echo $lang_vercheckunit; ?> <?php echo $verconvertunit; ?></div>
                </div>
            </div>
        </div>
        <div class="well2">
            <br>
            <ul>
                <b><?php  echo $lang_unitconversion;?></b>
                <li><?php echo $lang_enteryourname;?> <b><?php echo $lang_name;?></b></li>
                <li><?php echo $lang_selecttypeofunit;?>  <b><?php echo $lang_selectunit;?>  </b></li>
                <li><?php echo $lang_pressbutton;?> <b><?php echo $lang_calculate;?></b> <?php echo $lang_seeresults;?></li>
            </ul>
        </div>
    </div>

    <div class="row">
        <div class="col-md-12 table-responsive" align="center">
            <h3 align="center"><?php echo $lang_recentinformation;?></h3>
            <table class="table table-striped">
                <thead class="bg-primary" align="bottom">
                    <tr>
                        <th class="text-center" width="2%"><b><?php echo $lang_no; ?></b></th>
                        <th class="text-center" width="5%">  <?php echo $lang_name?>  </th>
                        <th class="text-center" width="15%">  <?php echo $lang_unit   //แสดงรหัสไปรษณีย์ ?>  </th> 
                        <th class="text-center" width="20%">  <?php echo $lang_province//ตัว keyword ของยูทูปเปลี่ยนเป็นจังหวัด?>  </th>
                        <th class="text-center" width="5%">  <?php echo $lang_place //ส่วนนี้แสดงตำบล?>  </th>
                        <th class="text-center" width="5%">  <?php echo $lang_district //ส่วนนี้จะให้แสดงเป็นอำเภอ?>  </th> 
                        <th class="text-center" width="5%">  <?php echo $lang_savewhen?>  </th>
                        <th class="text-center" width="5%">  <?php echo $lang_ipaddress;?>  </th>
                        <th class="text-center" width="5%"> <?php echo $lang_showinformation?> </th>
                        <th class="text-center" width="5%"> <?php ?> </th>
                    </tr>
                </thead>

                <?php

                // $sql = "SELECT * FROM place_name 
                // INNER JOIN mzc_mdistrict ON mzc_mdistrict .PROVINCE_ID = mzc_mdistrict.PROVINCE_ID 
                // INNER JOIN mzc_mprovince ON mzc_mprovince.PROVINCE_ID = mzc_mdistrict.PROVINCE_ID 
                // INNER JOIN mzc_mamphur on mzc_mamphur.AMPHUR_ID = mzc_mdistrict.AMPHUR_ID 
                // WHERE mzc_mamphur.POSTCODE ";
                
                $sql = "SELECT * FROM $table_con 
                INNER JOIN $province_con ON $province_con.PROVINCE_ID = $table_con.PROVINCE_ID 
                INNER JOIN $mdistrict_con on $mdistrict_con.DISTRICT_ID = $table_con.DISTRICT_ID 
                INNER JOIN $mamphur_con on $mamphur_con.AMPHUR_ID = $table_con.AMPHUR_ID 
                WHERE $table_con.id ORDER BY id desc Limit $start,$row";
                $result2 = mysqli_query($conn, $sql);
                     while ($fetch = mysqli_fetch_assoc($result2)) {

            // $sql = "SELECT * FROM $table_con ORDER BY id desc Limit $start,$row";
            //          $result2 = mysqli_query($conn, $sql);
            //      while ($fetch = mysqli_fetch_assoc($result2)) {
                     ?>

                     <tr>
                         <td class="text-center">  <?php echo $fetch['id']; ?></td>      <!-- ลำดับ-->
                         <td class="text-center">  <?php echo $fetch['user_name']; ?></td>    <!-- ชื่อ-->
                         <td class="text-center">  <?php echo $fetch['POSTCODE']; ?></td>     <!-- url-->
                         <td class="text-center">  <?php echo $fetch['PROVINCE_NAME']; ?></td>     <!-- url-->
                         <td class="text-center">  <?php echo $fetch['DISTRICT_NAME']; ?></td> <!-- keyword-->
                         <td class="text-center">  <?php echo $fetch['AMPHUR_NAME']; ?></td>     <!-- url-->
                        
                         <td class="textcenter">  <?php
                             if ($fetch['create_date']) {
                                 echo  $fetch['create_date'];
                           }
                            ?></td>
                         <td class="text-center">  <?php include 'ip.php'; ?></td>
                        
                         <td>
                            <a href="show.php?id=<?php echo $fetch['id']; ?>&lang=<?php echo $lang; ?>">
                                <i class="glyphicon glyphicon-new-window"></i>
                            </a>
                        </td>                
                        <td>
                            <a class="btn btn-warning" href="edit.php?id=<?php echo $fetch['id']; ?>">แก้ไข
                        </a>
                        </td>

                     </tr>
                     <?php
            }
                ?>
            </table>
            <div class="row">
                    <div class="col-md-12">
                        <div class="text-center">
                        <nav aria-label="Page navigation">
                            <?php
                            echo $Pagination->parse();
                            ?>
                        </nav>
                        </div>
                    </div>
                </div>
            <a href="list.php?lang=<?php echo $lang; ?>"  class="btn btn-primary"><?php echo $lang_moreinformation; ?></a>
        </div>
    </div>
</div>
<?php include '../footer.php'; ?>
ภาพประจำตัวสมาชิก
tsukasaz
PHP VIP Members
PHP VIP Members
โพสต์: 21912
ลงทะเบียนเมื่อ: 18/04/2012 9:39 am

Re: สอบถาม เออแบบนี้ต้องแก้ยังไงค่ะ

โพสต์ที่ยังไม่ได้อ่าน โดย tsukasaz »

ระบบมันแจ้งว่า คำสั่ง mysqli_multi_query ต้องใส่ parameter 2 ตัว ตอนนี้ใส่ไปแค่ 1 ตัว
The last bug isn't fixed until the last user is dead. (Sidney Markowitz, 1995)
suhaila
PHP Super Member
PHP Super Member
โพสต์: 480
ลงทะเบียนเมื่อ: 19/04/2021 9:51 am

Re: สอบถาม เออแบบนี้ต้องแก้ยังไงค่ะ

โพสต์ที่ยังไม่ได้อ่าน โดย suhaila »

ใส่เพิ่มแล้วค่ะ ตอนนี้ไม่ขึ้นเออเรอแล้วค่ะ ขอบคุณค่ะ
ตอบกลับโพส
  • Similar Topics
    ตอบกลับ
    แสดง
    โพสต์ล่าสุด

ผู้ใช้งานขณะนี้

สมาชิกกำลังดูบอร์ดนี้: ไม่มีสมาชิกใหม่ และบุคลทั่วไป 57