Forgot Password ??

PHP , ASP , ASP.NET, VB.NET, C#, Java , jQuery , Android , iOS , Windows Phone

	Registered : 109,038

HOME > PHP > PHP Forum > รับค่าจาก Check Box บันทึกลง Database แต่ข้อมูลมาไม่ครบ

[PHP] รับค่าจาก Check Box บันทึกลง Database แต่ข้อมูลมาไม่ครบ

เริ่มหัวข้อใหม่

bonusxi

โพสกระทู้ ( 280 )
บทความ ( 0 )

รบกวนช่วยดู Code หน่อยค่ะ

หน้าจอ input ข้อมูล

Code (PHP)

<label >Application Installed</label>           
       <label>OS</label>
    <input type="checkbox" class="checkbox" name="addins[]" value="Windows 7">Wins7   
    <input type="checkbox" class="checkbox" name="addins[]" value="Windows 10">Wins10
    <label>Office</label>
    <input type="checkbox" class="checkbox" name="addins[]" value="MS Office 2010">Office2010.
    <input type="checkbox" class="checkbox" name="addins[]" value="MS Office 2013 Pro.">Office2013 Pro.
    <input type="checkbox" class="checkbox" name="addins[]" value="MS Office 2013 Std.">Office2013 std.   
        <label">PDF</label>
    <input type="checkbox" class="checkbox" name="addins[]" value="Adobe Acrobat Pro">Adobe Acrobat   
    <input type="checkbox" class="checkbox" name="addins[]" value="PDF XChange Viewer">PDF XChange Viewer
    <label>Engineer</label>
    <input type="checkbox" class="checkbox" name="addins[]" value="Z-TEK USB2.0">USB Driver
    <input type="checkbox" class="checkbox" name="addins[]" value="Keyence USB-Serial Converter">Keyence USB  
    <input type="checkbox" class="checkbox" name="addins[]" value="Keyence VT Studio">VT Studio           
    <<input type="checkbox" class="checkbox" name="addins[]" value="GX work2">GX work2
    <input type="checkbox" class="checkbox" name="addins[]" value="GT work3">GT work3         
    <input type="checkbox" class="checkbox" name="addins[]" value="MR Configurator2">MR Configurator2
    <label>Design</label>
    <input type="checkbox" class="checkbox" name="addins[]" value="G-StarCAD">G-StarCAD
    <input type="checkbox" class="checkbox" name="addins[]" value="Solidwork">Solidwork       
    <input type="checkbox" class="checkbox" name="addins[]" value="Catia">Catia
    <input type="checkbox" class="checkbox" name="addins[]" value="Space E">Space E   
    <label>Special</label>
    <input type="checkbox" class="checkbox" name="addins[]" value="Budget Control">Budget
    <input type="checkbox" class="checkbox" name="addins[]" value="Daily Report">Daily Report
    <input type="checkbox" class="checkbox" name="addins[]" value="Accpac">Accpac     
    <input type="checkbox" class="checkbox" name="addins[]" value="OGA">OGA       
    <label>พื้นฐาน</label>
    <input type="checkbox" class="checkbox" name="addins[]" value="Symantec Enpoint">Symantec 
    <input type="checkbox" class="checkbox" name="addins[]" value="TeamViewer">TeamViewer 
    <input type="checkbox" class="checkbox" name="addins[]" value="SmartDataEncryption">SmartDataEncryption   
    <input type="checkbox" class="checkbox" name="addins[]" value="Driver Printer">Driver Printer
    <label>อื่นๆ</label>        
    <input type="text" name="addins[]">
 
 
actionมาที่หน้านี้
<?PHP
for($i=0;$i<count($_POST["addins"]);$i++){
if(trim($_POST["addins"][$i]) != ""){   
      $addins = $_POST["addins"][$i].",";
     //echo $addins;
      }
}
 
$strSQL = "INSERT INTO tbdevice ";
$strSQL .="(devicetypeid,devicebrand,devicemodel,devicedate,deviceamnt,deviceunit,devicesn,deviceip,devicecode,devicedesc,
            userid,deptid,devicepcname,renid,devicecpu,deviceram,deviceharddisk,devicegraphic,devicecd,deviceaccessory,
            licenseid,vendorid,deviceinstall,devicenetworkcard,devicesize)";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["addDtype"]."','".$_POST["addbrand"]."','".$_POST["addmodel"]."','".$_POST["adddate"]."' ";
$strSQL .=",'".$_POST["addQty"]."','".$_POST["addunit"]."','".$_POST["addsn"]."','".$_POST["addip"]."' ";
$strSQL .=",'".$_POST["addcode"]."','".$_POST["adddesc"]."','".$_POST["adduser"]."','".$_POST["adddept"]."' ";
$strSQL .=",'".$_POST["addpcname"]."','".$_POST["addren"]."','".$_POST["addcpu"]."','".$_POST["addram"]."' ";
$strSQL .=",'".$_POST["addhdd"]."','".$_POST["adddisply"]."','".$_POST["addrom"]."','".$_POST["addaccessory"]."' ";
$strSQL .=",'".$_POST["addlicense"]."','".$_POST["addvendor"]."','".$addins."','".$_POST["addnetwork"]."' ";
$strSQL .=",'".$_POST["addsize"]."') ";
$objQuery = sqlsrv_query($conn,$strSQL);
if($objQuery)
{
    echo "Query [".$strSQL."]";
    //header("location:main.php");
}
else
{
    echo " Error Save [".$strSQL."] ";
}
sqlsrv_close($conn);
?>

หน้าจอ input ข้อมูลค่ะ

screen input

action บรรทัดแรก แสดงข้อมูลจาก checkbox ครบค่ะ
แต่พอ insert จะเข้าเฉพาะ item สุดท้าย ตรงคำว่า "Symantec Endpoint"
action input

Windows 10,MS Office 2013 Pro.,Adobe Acrobat Pro,Symantec Enpoint,

Query [INSERT INTO tbdevice (devicetypeid,devicebrand,devicemodel,devicedate,deviceamnt,deviceunit,devicesn,deviceip,devicecode,devicedesc, userid,deptid,devicepcname,renid,devicecpu,deviceram,deviceharddisk,devicegraphic,devicecd,deviceaccessory, licenseid,vendorid,deviceinstall,devicenetworkcard,devicesize)VALUES ('2','eqwewqe','TMP246M','2017-10-11' ,'1','เครื่อง','333333','123' ,'123','reqr','15','21' ,'ice','11','rwq','4GB' ,'HDD 1TB , OCZ SSD 120GB','NVIDIA GeForce 820M 2GB','DVD','rqerqw' ,'','964','Symantec Enpoint,','-' ,'14"') ]

หากอธิบายไม่เข้าใจยังไง ขอโทษด้วยค่ะ

Tag : PHP, Ms SQL Server 2008, Apache, Appserv, XAMPP, Windows

Date : 2017-10-11 13:07:11

By : bonusxi

View : 1698

Reply : 7

No. 1

คนธรรมดา ไม่พิเศษ

โพสกระทู้ ( 2,311 )
บทความ ( 1 )

เช็ค {} ในการ loop ดีๆ ครับ
Code (PHP)

<?PHP
for($i=0;$i<count($_POST["addins"]);$i++){
    if(trim($_POST["addins"][$i]) != ""){   
        $addins = $_POST["addins"][$i].",";
        //echo $addins;
         
        $strSQL = "INSERT INTO tbdevice ";
        $strSQL .="(devicetypeid,devicebrand,devicemodel,devicedate,deviceamnt,deviceunit,devicesn,deviceip,devicecode,devicedesc,
        userid,deptid,devicepcname,renid,devicecpu,deviceram,deviceharddisk,devicegraphic,devicecd,deviceaccessory,
        licenseid,vendorid,deviceinstall,devicenetworkcard,devicesize)";
        $strSQL .="VALUES ";
        $strSQL .="('".$_POST["addDtype"]."','".$_POST["addbrand"]."','".$_POST["addmodel"]."','".$_POST["adddate"]."' ";
        $strSQL .=",'".$_POST["addQty"]."','".$_POST["addunit"]."','".$_POST["addsn"]."','".$_POST["addip"]."' ";
        $strSQL .=",'".$_POST["addcode"]."','".$_POST["adddesc"]."','".$_POST["adduser"]."','".$_POST["adddept"]."' ";
        $strSQL .=",'".$_POST["addpcname"]."','".$_POST["addren"]."','".$_POST["addcpu"]."','".$_POST["addram"]."' ";
        $strSQL .=",'".$_POST["addhdd"]."','".$_POST["adddisply"]."','".$_POST["addrom"]."','".$_POST["addaccessory"]."' ";
        $strSQL .=",'".$_POST["addlicense"]."','".$_POST["addvendor"]."','".$addins."','".$_POST["addnetwork"]."' ";
        $strSQL .=",'".$_POST["addsize"]."') ";
        $objQuery = sqlsrv_query($conn,$strSQL);
        if($objQuery)
        {
            echo "Query [".$strSQL."]";
        }
        else
        {
            echo " Error Save [".$strSQL."] ";
        }
    }
}
sqlsrv_close($conn);
?>

Date : 2017-10-11 13:34:16

By : arm8957

No. 2

HaraRock

โพสกระทู้ ( 432 )
บทความ ( 1 )

,'HDD 1TB ,
OCZ SSD 120GB',
'NVIDIA GeForce 820M 2GB',
'DVD',
'rqerqw' ,
'',
'964',
'Symantec Enpoint,'
,'-' ,
'14"
')

' ' ไม่ครบ

Date : 2017-10-11 14:06:36

By : Hararock

No. 3

bonusxi

โพสกระทู้ ( 280 )
บทความ ( 0 )

ตอบความคิดเห็นที่ : 1 เขียนโดย : arm8957 เมื่อวันที่ 2017-10-11 13:34:16

รายละเอียดของการตอบ ::

ขอบคุณมากๆ
แต่อยากให้แสดงในช่องเดียวกันค่ะ ขั้นด้วย , พอจะเป็นไปได้มั้ยคะ
ถ้าย้าย { จะแสดง เบิ้ลหลาย rows ค่ะ

อยากให้เข้าไปใน Database ตามที่ echo ออกมาดูเลยค่ะ
//echo $addins; ---> Windows 10,MS Office 2013 Pro.,Adobe Acrobat Pro,Symantec Enpoint,

Date : 2017-10-11 15:20:38

By : bonusxi

No. 4

bonusxi

โพสกระทู้ ( 280 )
บทความ ( 0 )

ตอบความคิดเห็นที่ : 2 เขียนโดย : Hararock เมื่อวันที่ 2017-10-11 14:06:36

รายละเอียดของการตอบ ::

ขอบคุณค่ะ

Date : 2017-10-11 15:21:15

By : bonusxi

No. 5

คนธรรมดา ไม่พิเศษ

โพสกระทู้ ( 2,311 )
บทความ ( 1 )

ตอบความคิดเห็นที่ : 3 เขียนโดย : bonusxi เมื่อวันที่ 2017-10-11 15:20:38

รายละเอียดของการตอบ ::

สามารถทำได้ครับ ผมไม่รุว่าค่า $_POST ออกมามีรูปแบบใด อาจจะใช้คำสั่ง implode() จากค่า $_POST เลยก็ได้โดยที่ไม่ต้อง Loop ลองปรับ แก้ไขเอาครับ
Code (PHP)

<?PHP
    for($i=0;$i<count($_POST["addins"]);$i++){
        if(trim($_POST["addins"][$i]) != ""){   
            $addThis[] = $_POST["addins"][$i];
        }
    }
    $addins = implode(',' , $addThis);
     
    $strSQL = "INSERT INTO tbdevice ";
    $strSQL .="(devicetypeid,devicebrand,devicemodel,devicedate,deviceamnt,deviceunit,devicesn,deviceip,devicecode,devicedesc,
    userid,deptid,devicepcname,renid,devicecpu,deviceram,deviceharddisk,devicegraphic,devicecd,deviceaccessory,
    licenseid,vendorid,deviceinstall,devicenetworkcard,devicesize)";
    $strSQL .="VALUES ";
    $strSQL .="('".$_POST["addDtype"]."','".$_POST["addbrand"]."','".$_POST["addmodel"]."','".$_POST["adddate"]."' ";
    $strSQL .=",'".$_POST["addQty"]."','".$_POST["addunit"]."','".$_POST["addsn"]."','".$_POST["addip"]."' ";
    $strSQL .=",'".$_POST["addcode"]."','".$_POST["adddesc"]."','".$_POST["adduser"]."','".$_POST["adddept"]."' ";
    $strSQL .=",'".$_POST["addpcname"]."','".$_POST["addren"]."','".$_POST["addcpu"]."','".$_POST["addram"]."' ";
    $strSQL .=",'".$_POST["addhdd"]."','".$_POST["adddisply"]."','".$_POST["addrom"]."','".$_POST["addaccessory"]."' ";
    $strSQL .=",'".$_POST["addlicense"]."','".$_POST["addvendor"]."','".$addins."','".$_POST["addnetwork"]."' ";
    $strSQL .=",'".$_POST["addsize"]."') ";
    $objQuery = sqlsrv_query($conn,$strSQL);
    if($objQuery)
    {
        echo "Query [".$strSQL."]";
    }
    else
    {
        echo " Error Save [".$strSQL."] ";
    }
     
    sqlsrv_close($conn);
?>

Date : 2017-10-11 16:02:55

By : arm8957

No. 6

bonusxi

โพสกระทู้ ( 280 )
บทความ ( 0 )

ได้แล้วค่ะ
ขอบคุณ คุณ คนธรรมดา ไม่พิเศษ มากนะคะ
แปะโค้ดทั้งหมดให้แล้วนะคะ
ตอนแรกวางโค้ด ไม่เป็น

Code (PHP) add_device.php

<?php
     include ("sqlconnect.php");
?>
<html>
<head>
 
</head>
<body>
<div class="container">   
<form role="form" method="post" action="add_device_save.php">
        <label>หมายเลขอุปกรณ์</label>
        <div class="col-sm-3">
            <input type="text" class="form-control" name="addcode" required>
         </div>
    </div>
        </div>
    <div class="form-group">
        <div class="form-inline">
        <label for="inputEmail3" class="col-sm-2">Computer Name</label>
        <div class="col-sm-3">
        <input type="text" class="form-control" name="addpcname" required>
        </div>
    </div>
                                        </div><div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">หมวดอุปกรณ์</label>
                <div class="col-sm-3">
                    <select class="form-control" name="addDtype" required>
                        <option>เลือกหมวดอุปกรณ์</option>
                            <?php
                                $strSQL = "SELECT * FROM tbdevicetype";
                                $objQuery = sqlsrv_query($conn,$strSQL);
                                while($objResult = sqlsrv_fetch_array($objQuery)){
                            ?>
                        <option value="<?php echo $objResult["devicetypeid"];?>"><?php echo $objResult["devicetypename"];?></option>
                            <?php
                                }
                            ?>
                    </select>
                </div>
        </div>
    </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">วันที่</label>
                <div class="col-sm-3">
                    <input type="date" id="datepicker" class="form-control" value="<?php print(date("Y-m-d")); ?>" name="adddate" required>
                </div>
        </div>
    </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">ยี่ห้อ</label>
            <div class="col-sm-3">
            <input type="text" id="datepicker" class="form-control" name="addbrand" required>
            </div>
        </div>
    </div>                            
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">รุ่น</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" name="addmodel" required>         
            </div>
        </div>
    </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">จำนวน</label>
                <div class="col-sm-3">
                    <input type="number" class="form-control" name="addQty" required>     
                </div>
        </div>
    </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">หน่วย</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" placeholder="เช่น ชิ้น,อัน,เครื่อง, Pcs. " name="addunit" required>
            </div>
        </div>
    </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">สัญญาเช่า</label>
                <div class="col-sm-3">
                    <select class="form-control" name="addren" required>
                        <option>เลือกเลขที่สัญญา</option>
                            <?php
                                $strSQL = "SELECT * FROM tbRental";
                                $objQuery = sqlsrv_query($conn,$strSQL);
                                while($objResult = sqlsrv_fetch_array($objQuery)){
                            ?>
                                <option value="<?php echo $objResult["renid"];?>"><?php echo $objResult["rencontractno"];?></option>
                            <?php
                                }
                            ?>
                    </select>
                </div>
        </div>
    </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">ผู้ขาย</label>
                <div class="col-sm-3">
                    <select class="form-control" name="addvendor" required>
                        <option>เลือกผู้ขาย</option>
                            <?php
                                $strSQL = "SELECT * FROM tbVendor order by vendorname asc";
                                $objQuery = sqlsrv_query($conn,$strSQL);
                                while($objResult = sqlsrv_fetch_array($objQuery)){
                            ?>
                                <option value="<?php echo $objResult["vendorid"];?>"><?php echo $objResult["vendorname"];?></option>
                            <?php
                                }
                            ?>
                    </select>
                </div>
        </div>
    </div>    
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">หมายเลข Serial</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" placeholder="Serial Number" name="addsn" required>
            </div>
        </div>
    </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">IP Address</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" placeholder="เช่น 192.168.0.0" name="addip" required>
            </div>
        </div>
    </div>
 
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>    
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">อธิบาย Item</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" name="adddesc" required>
            </div>
        </div>
    </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">ผู้ใช้งาน</label>
                <div class="col-sm-3">
            <select class="form-control" name="adduser" required>
            <option>ชื่อผู้ใช้</option>
            <?php
             
            $strSQL = "select *from tbuser ";
            $objQuery = sqlsrv_query($conn,$strSQL);
            while($objResult = sqlsrv_fetch_array($objQuery))
            {
            ?>
            <option value="<?php echo $objResult["userid"];?>"><?php echo $objResult["userfirstname"];?></option>
            <?php
            }
            ?>
            </select>
                </div>
         </div>
    </div>
 
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>    
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">แผนก</label>
                <div class="col-sm-3">
            <select class="form-control" name="adddept" required>
            <option>เลือกแผนก</option>
            <?php
            $strSQL = "SELECT * FROM tbdept";
            $objQuery = sqlsrv_query($conn,$strSQL);
            while($objResult = sqlsrv_fetch_array($objQuery))
            {
            ?>
            <option value="<?php echo $objResult["deptid"];?>"><?php echo $objResult["deptcode"];?></option>
            <?php
            }
            ?>
            </select>
                </div>
         </div>
    </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">Accessories</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" name="addaccessory" required>
            </div>
        </div>
    </div>
 
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>    
     
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">CPU</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" name="addcpu" required>
            </div>
        </div>
    </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">Harddisk</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" name="addhdd" required>
            </div>
        </div>
    </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">RAM</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" name="addram" required>
            </div>
        </div>
    </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">CD ROM</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" name="addrom" required>
            </div>
        </div>
    </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
     
     
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">Graphic</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" name="adddisply" required>
            </div>
        </div>
    </div>    
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">Network Card</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" name="addnetwork" required>
            </div>
        </div>
    </div>    
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">Size</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" name="addsize" required>
            </div>
        </div>
    </div>        
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">ราคา</label>
            <div class="col-sm-3">
            <input type="text" class="form-control" name="addprice" required>
            </div>
        </div>
    </div>                            <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
    <div class="form-group">
        <div class="form-inline">
            <label for="inputEmail3" class="col-sm-2">Application Installed</label>         
            <div class="col-sm-10 ridge">
                <div class="col-sm-12" >
                <label for="inputEmail3" class="col-sm-1">OS</label><br>
                <div class="col-sm-12" >
            <input type="checkbox" class="checkbox" name="addins[]" value="Windows 7">Wins7   
            <input type="checkbox" class="checkbox" name="addins[]" value="Windows 10">Wins10
                </div>
                </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
                <div class="col-sm-12" >
                <label for="inputEmail3" class="col-sm-1">Office</label>
                <div class="col-sm-12" >
            <input type="checkbox" class="checkbox" name="addins[]" value="MS Office 2010">Office2010.
            <input type="checkbox" class="checkbox" name="addins[]" value="MS Office 2013 Pro.">Office2013 Pro.
            <input type="checkbox" class="checkbox" name="addins[]" value="MS Office 2013 Std.">Office2013 std.   
                </div>
                </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
                <div class="col-sm-12" >
                <label for="inputEmail3" class="col-sm-1">PDF</label>
                <div class="col-sm-12" >
            <input type="checkbox" class="checkbox" name="addins[]" value="Adobe Acrobat Pro">Adobe Acrobat   
            <input type="checkbox" class="checkbox" name="addins[]" value="PDF XChange Viewer">PDF XChange Viewer
                </div>
                </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
                <div class="col-sm-12" >
                <label for="inputEmail3" class="col-sm-2">Maintenace</label>
                <div class="col-sm-12" >
            <input type="checkbox" class="checkbox" name="addins[]" value="Z-TEK USB2.0">USB Driver
            <input type="checkbox" class="checkbox" name="addins[]" value="Keyence USB-Serial Converter">Keyence USB  
            <input type="checkbox" class="checkbox" name="addins[]" value="Keyence VT Studio">VT Studio           
            <input type="checkbox" class="checkbox" name="addins[]" value="Keyence KV Studio">KV Studio
            <input type="checkbox" class="checkbox" name="addins[]" value="GX work2">GX work2
            <input type="checkbox" class="checkbox" name="addins[]" value="GT work3">GT work3         
            <input type="checkbox" class="checkbox" name="addins[]" value="MR Configurator2">MR Configurator2
                </div>    
                </div>    
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
                <div class="col-sm-12" >
                <label for="inputEmail3" class="col-sm-2">Design</label>
                <div class="col-sm-12" >
            <input type="checkbox" class="checkbox" name="addins[]" value="G-StarCAD">G-StarCAD
            <input type="checkbox" class="checkbox" name="addins[]" value="Solidwork">Solidwork       
            <input type="checkbox" class="checkbox" name="addins[]" value="Catia">Catia
            <input type="checkbox" class="checkbox" name="addins[]" value="Space E">Space E           
                </div>        
                </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
                <div class="col-sm-12" >
                <label for="inputEmail3" class="col-sm-2">KPC</label>
                <div class="col-sm-12" >
            <input type="checkbox" class="checkbox" name="addins[]" value="Budget Control">Budget
            <input type="checkbox" class="checkbox" name="addins[]" value="Daily Report">Daily Report
            <input type="checkbox" class="checkbox" name="addins[]" value="Accpac">Accpac     
            <input type="checkbox" class="checkbox" name="addins[]" value="OGA">OGA           
                </div>        
                </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
                <div class="col-sm-12" >  
                <label for="inputEmail3" class="col-sm-2">พื้นฐาน</label>
                <div class="col-sm-12" >
            <input type="checkbox" class="checkbox" name="addins[]" value="Symantec Enpoint">Symantec 
            <input type="checkbox" class="checkbox" name="addins[]" value="TeamViewer">TeamViewer 
            <input type="checkbox" class="checkbox" name="addins[]" value="SmartDataEncryption">SmartDataEncryption   
            <input type="checkbox" class="checkbox" name="addins[]" value="Driver Printer">Driver Printer                     
                </div>
                </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
                <div class="col-sm-12" >  
                <label for="inputEmail3" class="col-sm-2">ลูกค้า</label>                
                <div class="col-sm-12" >
            <input type="checkbox" class="checkbox" name="addins[]" value="VPN Mitsubishi">VPN Mitsubishi         
            <input type="checkbox" class="checkbox" name="addins[]" value="VPN Toyota">VPN Toyota
                </div>
                </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
                <div class="col-sm-12" >
                <label for="inputEmail3" class="col-sm-2">IT</label>                
                <div class="col-sm-12" >      
            <input type="checkbox" class="checkbox" name="addins[]" value="Visual Studio 2015">Visual Studio 2015     
            <input type="checkbox" class="checkbox" name="addins[]" value="VMware vSphere">VMware vSphere
            <input type="checkbox" class="checkbox" name="addins[]" value="Crystal Report">Crystal Report
                </div>
                </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
                <div class="col-sm-12" >
                <label for="inputEmail3" class="col-sm-2">อื่นๆ</label>             
                <div class="col-sm-12" >      
            <input type="text" class="form-control" name="addins[]">      
                </div>
                </div>
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
            </div>
        </div>
    </div>    
    
                                        <div class="row clearfix">
                                        <div class="col-md-12 column">
                                        </div>
                                        </div>
    <div align="left">
            <button type="submit" class="btn btn-success"><span class="glyphicon glyphicon-plus"></span>บันทึก</button>
            <div class="col-md-1"></div>
            <a href="main.php"><button type="button" class="btn btn-danger"><span class="glyphicon glyphicon-minus"></span>ยกเลิก</button></a>
    </div>
</form>
</div>
</body>
</html>

Code (PHP) add_device_save.php

<?php
    session_start();
    require ('sqlconnect.php');     
    if($_SESSION['userid'] == ""){
                                    header("Content-type: text/html; charset=utf-8");
                                    echo"<script language='JavaScript' >";
                                    echo"alert('กรุณากรอกข้อมูลเพื่อเข้าสู่ระบบ');";
                                    echo"</script>";      
    exit(); 
    }     
    ?>
 
<?PHP
for($i=0;$i<count($_POST["addins"]);$i++){
if(trim($_POST["addins"][$i]) != ""){
    $addThis[] = $_POST["addins"][$i];
    $addins = $_POST["addins"][$i].","; 
    }
}
$addins = implode(',' , $addThis);
 
$strSQL = "INSERT INTO tbdevice ";
$strSQL .="(devicetypeid,devicebrand,devicemodel,devicedate,
            deviceamnt,deviceunit,devicesn,deviceip,
            devicecode,devicedesc,userid,deptid,
            devicepcname,renid,devicecpu,deviceram,
            deviceharddisk,devicegraphic,devicecd,deviceaccessory,
            deviceprice,vendorid,deviceinstall,devicenetworkcard,devicesize)";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["addDtype"]."','".$_POST["addbrand"]."','".$_POST["addmodel"]."','".$_POST["adddate"]."' ";
$strSQL .=",'".$_POST["addQty"]."','".$_POST["addunit"]."','".$_POST["addsn"]."','".$_POST["addip"]."' ";
$strSQL .=",'".$_POST["addcode"]."','".$_POST["adddesc"]."','".$_POST["adduser"]."','".$_POST["adddept"]."' ";
$strSQL .=",'".$_POST["addpcname"]."','".$_POST["addren"]."','".$_POST["addcpu"]."','".$_POST["addram"]."' ";
$strSQL .=",'".$_POST["addhdd"]."','".$_POST["adddisply"]."','".$_POST["addrom"]."','".$_POST["addaccessory"]."' ";
 
 
$strSQL .=",'".$_POST["addprice"]."','".$_POST["addvendor"]."','".$addins."','".$_POST["addnetwork"]."','".$_POST["addsize"]."') ";
$objQuery = sqlsrv_query($conn,$strSQL);
if($objQuery)
{
    header("location:main.php");
}
else
{
    echo " Error Save [".$strSQL."] ";
}
sqlsrv_close($conn);
?>

Date : 2017-10-11 17:04:55

By : bonusxi

No. 7

Chaidhanan

โพสกระทู้ ( 9,590 )
บทความ ( 2 )

ตอบความคิดเห็นที่ : 6 เขียนโดย : bonusxi เมื่อวันที่ 2017-10-11 17:04:55

รายละเอียดของการตอบ ::

... อย่างนี้สิครับ ได้แล้วเพื่อแผ่ต่อให้คนหลังได้ศึกษา +1

Date : 2017-10-11 21:04:56

By : Chaidhanan

ค้นหาข้อมูล

แสดงความคิดเห็น

Re : รับค่าจาก Check Box บันทึกลง Database แต่ข้อมูลมาไม่ครบ

รายละเอียด

เพื่อความเรียบร้อยของข้อความ ควรจัดรูปแบบให้พอดีกับขนาดของหน้าจอ เพื่อง่ายต่อการอ่านและสบายตา และตรวจสอบภาษาไทยให้ถูกต้อง

อัพโหลดแทรกรูปภาพ

Notice

เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ
อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง

เพื่อความปลอดภัยและการตรวจสอบ กระทู้ที่แทรกไฟล์อัพโหลดไฟล์จากที่อื่น อาจจะถูกลบทิ้ง

โดย

อีเมล์

บวกค่าให้ถูก

<= ตัวเลขฮินดูอารบิก เช่น 123 (หรือล็อกอินเข้าระบบสมาชิกเพื่อไม่ต้องกรอก)

Registered : 109,038

document.write("<font color=996600>[PHP]</font>"); [PHP] รับค่าจาก Check Box บันทึกลง Database แต่ข้อมูลมาไม่ครบ

No. 1

No. 2

No. 3

No. 4

No. 5

No. 6

No. 7

ค้นหาข้อมูล

อัพโหลดแทรกรูปภาพ

Notice

[PHP] รับค่าจาก Check Box บันทึกลง Database แต่ข้อมูลมาไม่ครบ