Forgot Password ??

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

	Registered : 109,038

HOME > PHP > PHP Forum > ส่งค่า ajax ProductID ไปอีก files 1 เพื่อ ส่งค่ามา แสดง โดยส่งแบบ GET เพื่อ WHERE ค่าออกมา ไปไม่เป็น งง ช่วยที่

[PHP] ส่งค่า ajax ProductID ไปอีก files 1 เพื่อ ส่งค่ามา แสดง โดยส่งแบบ GET เพื่อ WHERE ค่าออกมา ไปไม่เป็น งง ช่วยที่

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

HaraRock

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

Main (PHP)

<?php  
session_start();
ob_start();
require('include/db_connect.php');
require('include/function.php');
if((isset($_SESSION['lname'])));
{
     
?>
<!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">
    
    <title><?php echo TITLE; ?></title>
   <link href="css/bootstrap.min.css" rel="stylesheet">
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <link href="css/textcss.css" type="text/css" rel="stylesheet" >
    <link href="css/styleinput.css" type="text/css" rel="stylesheet" >
    <link href="css/stylelink.css" type="text/css" rel="stylesheet">
    <link href="style.css" rel="stylesheet" type="text/css" />
  </head>
  <link rel="stylesheet" type="text/css"
 href="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/css/smoothness/jquery-ui-1.9.2.custom.css" />
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/js/jquery-1.8.3.js"> </script>
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/js/jquery-ui-1.9.2.custom.min.js"></script>
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/js/jquery-ui-1.9.2.custom.js"></script>
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/css/smoothness/jquery-ui-1.9.2.custom.css"></script>
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/css/smoothness/jquery-ui-1.9.2.custom.min.css"></script>
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/js/jquery-1.8.3.js"></script>
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/js/jquery-ui-1.9.2.custom.js"></script>
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/js/jquery-ui-1.9.2.custom.min.js"></script>
 
  <body>
  <?php 
  if($_SESSION['lL'] == 1)
  {
    $Se="SELECT distinct
    product_main.ProAuto,
    product_main.ProductID,
    product_main.DeptID,
    product_main.ProductNameLao,
    product_main.TypeID,
    product_main.Size,
    product_main.Price,
    product_main.Result,
    product_main.QTYMain,
    product_main.DateMain,
    product_main.Remark,
    product_main.AdminID,
    currency.CurrencyID,
    currency.CurrencyName,
    brand.BrandID,
    brand.BrandName,
    asset_province.APID,
    asset_province.AssetProvince_Name,
    tbphoto.PhotoID
    FROM stock_supplies.product_main
    LEFT JOIN stock_supplies.currency ON currency.CurrencyID = product_main.CurrencyID
    LEFT JOIN stock_supplies.brand ON brand.BrandID = product_main.BrandID
    LEFT JOIN stock_supplies.asset_province ON asset_province.APID = product_main.APID
    LEFT JOIN stock_supplies.tbphoto ON tbphoto.PhotoID = product_main.PhotoID";      
  } else {
    $Se="SELECT distinct
    product_main.ProAuto,
    product_main.ProductID,
    product_main.DeptID,
    product_main.ProductNameLao,
    product_main.TypeID,
    product_main.Size,
    product_main.Price,
    product_main.Result,
    product_main.QTYMain,
    product_main.DateMain,
    product_main.Remark,
    product_main.AdminID,
    currency.CurrencyID,
    currency.CurrencyName,
    brand.BrandID,
    brand.BrandName,
    asset_province.APID,
    asset_province.AssetProvince_Name,
    tbphoto.PhotoID
    FROM stock_supplies.product_main
    LEFT JOIN stock_supplies.currency ON currency.CurrencyID = product_main.CurrencyID
    LEFT JOIN stock_supplies.brand ON brand.BrandID = product_main.BrandID
    LEFT JOIN stock_supplies.asset_province ON asset_province.APID = product_main.APID
    LEFT JOIN stock_supplies.tbphoto ON tbphoto.PhotoID = product_main.PhotoID
    WHERE product_main.DeptID ='".$_SESSION['lDeptID']."'
    ";  
  }
    $SQL=mysql_query($Se);
     
  ?>
  <form action="" name="frmMain" id="frmMain">
   
   
  
  <table width="96%" border="1" cellspacing="0" cellpadding="0" align="center" class="table-responsive">
  <tr>
    <td colspan="16">&nbsp; TEST</td>
     
  </tr>
  <tr>
    <td>&nbsp; No:</td>
    <td>&nbsp; ProductID</td>
    <td>&nbsp; Photo</td>
    <td>&nbsp; Name   </td>
    <td>&nbsp; TypeID</td>
    <td>&nbsp; Size</td>
    <td>&nbsp; Price</td>
    <td>&nbsp; BrandID</td>
    <td>&nbsp; QTYMain</td>
    <td>&nbsp; Monney</td>
    <td>&nbsp; CurrencyID</td>
    <td>&nbsp; AssetProvince_Name</td>
    <td>&nbsp; DateMain</td>
    <td>&nbsp; Remark</td>
    <td>&nbsp; Insert Detail</td>
    <td>&nbsp; Show Detail</td>
 
  </tr>
  <?php 
  $i=1;
  while($row=mysql_fetch_assoc($SQL))
  {
       
        $K=number_format($row["Result"],0);
        $A=$row["ProAuto"];
        $P=$row["ProductID"];
        $N=$row["QTYMain"];
  ?>
   
  
  
 
  <tr>
    <td>&nbsp;<input type="text" name="No<?php echo $i;?>" id="No" value="<?php echo $row["ProAuto"];?>"></td>
    <td>&nbsp;<input type="text" name="ProductIDs<?php echo $i;?>" id="ProductIDs" value="<?php echo $row["ProductID"];?>"></td>
    <td align="center"><img src="Photo/<?php echo $row['PhotoID'];?>"  width="100" height="100" /></td>
    <td>&nbsp;<input type="text" name="ProductNameLao<?php echo $i;?>" id="" value="<?php echo $row["ProductNameLao"];?>"></td>
    <td>&nbsp;<input type="text" name="TypeID<?php echo $i;?>" id="TypeID" value="<?php echo $row["TypeID"];?>"></td>
    <td>&nbsp;<input type="text" name="Size<?php echo $i;?>" id="Size" value="<?php echo $row["Size"];?>"></td>
    <td>&nbsp;<input type="text" name="Price<?php echo $i;?>" id="Price" value="<?php echo $row["Price"];?>"></td>
    <td>&nbsp;<input type="text" name="BrandName<?php echo $i;?>" id="BrandName" value="<?php echo $row["BrandName"];?>"></td>
    <td>&nbsp;<input type="text" name="QTYMain<?php echo $i;?>" id="QTYMain" value="<?php echo $row["QTYMain"];?>"></td>
    <td>&nbsp;<input type="text" name="Result<?php echo $i;?>" id="Result" value="<?php echo $row["Result"];?>"></td>
    <td>&nbsp;<input type="text" name="CurrencyName<?php echo $i;?>" id="CurrencyName" value="<?php echo $row["CurrencyName"];?>"></td>
    <td>&nbsp;<input type="text" name="AssetProvince_Name<?php echo $i;?>" id="" value="<?php echo $row["AssetProvince_Name"];?>"></td>
    <td>&nbsp;<input type="text" name="DateMain<?php echo $i;?>" id="DateMain" value="<?php echo $row["DateMain"];?>"></td>
    <td>&nbsp;<input type="text" name="Remark<?php echo $i;?>" id="Remark" value="<?php echo $row["Remark"];?>"></td>
    <td align="center"><?php echo "<a href='frminsert_details.php?ProAuto=".$A."&ProductID=".$P."&n=".$N."'>
    <img src='img/note_add.png' width='22' height='22'  /></a>"; ?></td>
    <td align="center"><input type="text" name="ProductID<?php echo $i;?>" id="ProductID" value="<?php echo $row["ProductID"]; ?>">
    <script>
     
     
    function getDataFromDb()
{
     
    $.ajax({ 
                url: "data.php" ,
                type: "POST",
                data: {ProductID: $("#ProductID<?php echo $i;?>").val()}
                 
            })
            .success(function(result) { 
                var obj = jQuery.parseJSON(result);
                    if(obj != '')
                    {
                          //$("#myTable tbody tr:not(:first-child)").remove();
                          $("#myBody").empty();
                          $.each(obj, function(key, val) {
                                    var tr = "<tr>";
                                    tr = tr + "<td>" + val["ProductID"] + "</td>";
                                    tr = tr + "<td>" + val["ProductIDList"] + "</td>";
                                    tr = tr + "<td>" + val["AssetDeptName"] + "</td>";
                                    tr = tr + "<td>" + val["location"] + "</td>";
                                    tr = tr + "<td>" + val["QTY"] + "</td>";
                                    tr = tr + "<td>" + val["GroupName"] + "</td>";
                                    tr = tr + "<td>" + val["DateCreate"] + "</td>";
                                    tr = tr + "<td>" + val["DateEX"] + "</td>";
                                    tr = tr + "<td>" + val["UseName"] + "</td>";
                                    tr = tr + "<td>" + val["Remark"] + "</td>";
                                     
                                     
                                     
                                     
                                    tr = tr + "</tr>";
                                    $('#myTable > tbody:last').append(tr);
                          });
                    }
 
            });
 
}
 
setInterval(getDataFromDb,1000);   // 1000 = 1 second
</script> 
<center>
<h1>My Web</h1>
 
<table width="600" border="1" id="myTable">
<!-- head table -->
<thead>
  <tr>
    <td width="91"> <div align="center">ProductID </div></td>
    <td width="98"> <div align="center">ProductIDList </div></td>
    <td width="198"> <div align="center">AssetDeptName </div></td>
    <td width="97"> <div align="center">location </div></td>
    <td width="59"> <div align="center">QTY </div></td>
    <td width="71"> <div align="center">GroupName </div></td>
    <td width="198"> <div align="center">DateCreate </div></td>
    <td width="97"> <div align="center">DateEX </div></td>
    <td width="59"> <div align="center">UseName </div></td>
    <td width="71"> <div align="center">Remark </div></td>
  </tr>
</thead>
<!-- body dynamic rows -->
<tbody id="myBody"></tbody>
</table>
 
 <center>
     
     
    </td>
     
      </tr>
       
      <?php } ?>
       
</table>
</div>
 </form>   
  </body>
</html>
 
 
<?php } ?>
<?php
ob_end_flush();
mysql_close($d1,$db1,$c1);
mysql_close($d2,$db2,$c1);
 
exit();
?>

data (PHP)

<?php
    echo $_GET["ProductID"];
    require('include/db_connect.php');
    $strSQL = "SELECT product_list.Auto,
                product_list.ProductID,
                product_list.ProductIDList,
                asset_dept.AssetDeptName,
                asset_dept.AssetDeptID,
                product_list.location,
                product_list.QTY,
                group_asset.GroupName,  
                group_asset.GroupID,
                product_list.DateCreate,
                product_list.DateEX,
                using.UseID,
                using.UseName,  
                product_list.Remark,
                product_list.AdminID,
                product_list.DeptID
                FROM stock_supplies.product_list
                LEFT JOIN stock_supplies.asset_dept ON asset_dept.AssetDeptID = product_list.AssetDeptID
                LEFT JOIN stock_supplies.group_asset ON group_asset.GroupID = product_list.GroupID
                LEFT JOIN stock_supplies.using ON using.UseID = product_list.UseID
                WHERE product_list.ProductID ='".$_GET["ProductID"]."'
                ORDER By product_list.ProductID  ";
     
    $objQuery = mysql_query($strSQL) or die (mysql_error());
     
    $intNumField = mysql_num_fields($objQuery);
     
    $resultArray = array();
     
    while($obResult = mysql_fetch_array($objQuery))
    {
        $arrCol = array();
        for($i=0;$i<$intNumField;$i++)
        {
            $arrCol[mysql_field_name($objQuery,$i)] = $obResult[$i];
        }
        array_push($resultArray,$arrCol);
    }
     
    mysql_close($objConnect);
     
    echo json_encode($resultArray);
?>

งงและไม่เข้าใจเป็นเอามาก
แต่ถ้า Loop ธรรมดา <a href ส่งแบบ Get ไปเรียก show data นั้นง่ายทำเป็น แต่ อยาก ส่งเป็น Ajax > ไม่ทราบ ว่านะแนะนำ เขียนแบบไหน จึ่งจะถูกต้อง

Mysql Follow Company LoL

Tag : PHP, JavaScript, Ajax, jQuery, Google Chrome, XAMPP

ประวัติการแก้ไข
2017-11-28 10:11:31

Date : 2017-11-28 10:02:40

By : Hararock

View : 580

Reply : 3

No. 1

HaraRock

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

Code (PHP)

<?php  
session_start();
ob_start();
require('include/db_connect.php');
require('include/function.php');
if((isset($_SESSION['lname'])));
{
     
?>
<!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">
    
    <title><?php echo TITLE; ?></title>
   <link href="css/bootstrap.min.css" rel="stylesheet">
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <link href="css/textcss.css" type="text/css" rel="stylesheet" >
    <link href="css/styleinput.css" type="text/css" rel="stylesheet" >
    <link href="css/stylelink.css" type="text/css" rel="stylesheet">
    <link href="style.css" rel="stylesheet" type="text/css" />
  </head>
  <link rel="stylesheet" type="text/css"
 href="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/css/smoothness/jquery-ui-1.9.2.custom.css" />
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/js/jquery-1.8.3.js"> </script>
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/js/jquery-ui-1.9.2.custom.min.js"></script>
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/js/jquery-ui-1.9.2.custom.js"></script>
 
  <body>
  <?php 
  if($_SESSION['lL'] == 1)
  {
    $Se="SELECT distinct
    product_main.ProAuto,
    product_main.ProductID,
    product_main.DeptID,
    product_main.ProductNameLao,
    product_main.TypeID,
    product_main.Size,
    product_main.Price,
    product_main.Result,
    product_main.QTYMain,
    product_main.DateMain,
    product_main.Remark,
    product_main.AdminID,
    currency.CurrencyID,
    currency.CurrencyName,
    brand.BrandID,
    brand.BrandName,
    asset_province.APID,
    asset_province.AssetProvince_Name,
    tbphoto.PhotoID
    FROM stock_supplies.product_main
    LEFT JOIN stock_supplies.currency ON currency.CurrencyID = product_main.CurrencyID
    LEFT JOIN stock_supplies.brand ON brand.BrandID = product_main.BrandID
    LEFT JOIN stock_supplies.asset_province ON asset_province.APID = product_main.APID
    LEFT JOIN stock_supplies.tbphoto ON tbphoto.PhotoID = product_main.PhotoID";      
  } else {
    $Se="SELECT distinct
    product_main.ProAuto,
    product_main.ProductID,
    product_main.DeptID,
    product_main.ProductNameLao,
    product_main.TypeID,
    product_main.Size,
    product_main.Price,
    product_main.Result,
    product_main.QTYMain,
    product_main.DateMain,
    product_main.Remark,
    product_main.AdminID,
    currency.CurrencyID,
    currency.CurrencyName,
    brand.BrandID,
    brand.BrandName,
    asset_province.APID,
    asset_province.AssetProvince_Name,
    tbphoto.PhotoID
    FROM stock_supplies.product_main
    LEFT JOIN stock_supplies.currency ON currency.CurrencyID = product_main.CurrencyID
    LEFT JOIN stock_supplies.brand ON brand.BrandID = product_main.BrandID
    LEFT JOIN stock_supplies.asset_province ON asset_province.APID = product_main.APID
    LEFT JOIN stock_supplies.tbphoto ON tbphoto.PhotoID = product_main.PhotoID
    WHERE product_main.DeptID ='".$_SESSION['lDeptID']."'
    ";  
  }
    $SQL=mysql_query($Se);
     
  ?>
  
   
 
  <form action="" name="frmMain" id="frmMain">
   
   
  
  <table width="96%" border="1" cellspacing="0" cellpadding="0" align="center" class="table-responsive">
  <tr>
    <td colspan="16">&nbsp; TEST</td>
     
  </tr>
  <tr>
    <td>&nbsp; No:</td>
    <td>&nbsp; ProductID</td>
    <td>&nbsp; Photo</td>
    <td>&nbsp; Name   </td>
    <td>&nbsp; TypeID</td>
    <td>&nbsp; Size</td>
    <td>&nbsp; Price</td>
    <td>&nbsp; BrandID</td>
    <td>&nbsp; QTYMain</td>
    <td>&nbsp; Monney</td>
    <td>&nbsp; CurrencyID</td>
    <td>&nbsp; AssetProvince_Name</td>
    <td>&nbsp; DateMain</td>
    <td>&nbsp; Remark</td>
    <td>&nbsp; Insert Detail</td>
    <td>&nbsp; Show Detail</td>
 
  </tr>
  <?php 
  $i=0;
  while($row=mysql_fetch_assoc($SQL))
  {  
        $K=number_format($row["Result"],0);
        $A=$row["ProAuto"];
        $P=$row["ProductID"];
        $N=$row["QTYMain"];
        ++$i;
  ?>
   
  <tr>
    <td>&nbsp;<input type="hidden" name="h" id="h" value="<?php echo $row["ProAuto"];?>"><?php echo $i;?></td>
    <td>&nbsp;<input type="text" name="ProductID<?php echo $i;?>" id="ProductID" value="<?php echo $row["ProductID"];?>"></td>
    <td align="center"><img src="Photo/<?php echo $row['PhotoID'];?>"  width="100" height="100" /></td>
    <td>&nbsp;<?php echo $row["ProductNameLao"];?></td>
    <td>&nbsp;<?php echo $row["TypeID"];?></td>
    <td>&nbsp;<?php echo $row["Size"];?></td>
    <td>&nbsp;<?php echo $row["Price"];?></td>
    <td>&nbsp;<?php echo $row["BrandName"];?></td>
    <td>&nbsp;<?php echo $row["QTYMain"];?></td>
    <td>&nbsp;<?php echo $row["Result"];?></td>
    <td>&nbsp;<?php echo $row["CurrencyName"];?></td>
    <td>&nbsp;<?php echo $row["AssetProvince_Name"];?></td>
    <td>&nbsp;<?php echo $row["DateMain"];?></td>
    <td>&nbsp;<?php echo $row["Remark"];?></td>
    <td align="center"><?php echo "<a href='frminsert_details.php?ProAuto=".$A."&ProductID=".$P."&n=".$N."'>
    <img src='img/note_add.png' width='22' height='22'  /></a>"; ?></td>
    <td align="center">
     
    <script>
 // ทดสอบการใช้ GET
function getData(){
    $.get("get.php",
    { data: $("#data1").val()
 
    },
function(data){
            $("#divGetData").html(data);
        }
    );
} 
</script>
     
    <div id="divGetData">
  <input name="data1<?php echo $i;?>" type="text" id="data1" size="40" value="<?php echo $row["ProductID"]; ?>" />
  <input type="button" name="Button1<?php echo $i;?>" id="button1" value="Get" onclick="getData()" />
  
    </div>
     
   
     </td>
      </tr> 
      <?php } ?>
       
</table>
</div>
 </form>   
  </body>
</html>
 
 
<?php } ?>
<?php
ob_end_flush();
mysql_close($d1,$db1,$c1);
mysql_close($d2,$db2,$c1);
 
exit();
?>

ได้แบบนี้

Date : 2017-11-29 08:56:17

By : Hararock

No. 2

HaraRock

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

Code (PHP)

<?php
ob_start();  
session_start();
  
require('include/db_connect.php');
require('include/function.php');
 
 
if($_SESSION['lL'] == 1)
{
    $SQl="SELECT product_list.Auto,
                product_list.ProductID,
                product_list.ProductIDList,
                asset_dept.AssetDeptName,
                asset_dept.AssetDeptID,
                product_list.location,
                product_list.QTY,
                group_asset.GroupName,  
                group_asset.GroupID,
                product_list.DateCreate,
                product_list.DateEX,
                using.UseID,
                using.UseName,  
                product_list.Remark,
                product_list.AdminID,
                product_list.DeptID
                FROM stock_supplies.product_list
                LEFT JOIN stock_supplies.asset_dept ON asset_dept.AssetDeptID = product_list.AssetDeptID
                LEFT JOIN stock_supplies.group_asset ON group_asset.GroupID = product_list.GroupID
                LEFT JOIN stock_supplies.using ON using.UseID = product_list.UseID
                WHERE product_list.ProductID ='".$_GET['data']."'
                ORDER By product_list.ProductIDList ";
}else{
    $SQl="SELECT product_list.Auto,
                product_list.ProductID,
                product_list.ProductIDList,
                asset_dept.AssetDeptName,
                asset_dept.AssetDeptID,
                product_list.location,
                product_list.QTY,
                group_asset.GroupName,  
                group_asset.GroupID,
                product_list.DateCreate,
                product_list.DateEX,
                using.UseID,
                using.UseName,  
                product_list.Remark,
                product_list.AdminID,
                product_list.DeptID
                FROM stock_supplies.product_list
                LEFT JOIN stock_supplies.asset_dept ON asset_dept.AssetDeptID = product_list.AssetDeptID
                LEFT JOIN stock_supplies.group_asset ON group_asset.GroupID = product_list.GroupID
                LEFT JOIN stock_supplies.using ON using.UseID = product_list.UseID
                WHERE product_list.ProductID ='".$_GET['data']."' AND  product_list.DeptID ='".$_SESSION['lDeptID']."'
                ORDER By product_list.ProductID ";
     
     
}
                $ser=mysql_query($SQl) or die("Show Errors Detail ::".mysql_error());
?>
<!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">
    
    <title><?php echo TITLE; ?></title>
   <link href="css/bootstrap.min.css" rel="stylesheet">
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <link href="css/textcss.css" type="text/css" rel="stylesheet" >
    <link href="css/styleinput.css" type="text/css" rel="stylesheet" >
    <link href="css/stylelink.css" type="text/css" rel="stylesheet">
    <link href="style.css" rel="stylesheet" type="text/css" />
  </head>
  <link rel="stylesheet" type="text/css"
 href="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/css/smoothness/jquery-ui-1.9.2.custom.css" />
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/js/jquery-1.8.3.js"> </script>
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/js/jquery-ui-1.9.2.custom.min.js"></script>
 <script type="text/javascript" src="jquery-ui-1.9.2.custom/jquery-ui-1.9.2.custom/js/jquery-ui-1.9.2.custom.js"></script>
 
 
  <body>
<form action="" name="test" id="test" method="post">
<div id="DivD">
<input type="button" name="ok<?php echo $i;?>" id="ok"  value="Show/Hide"/>
<input type="submit" name="ok<?php echo $i;?>" id="ok" value="Back" />
<script>
$(function(){
    $("#ok").click(function(){
    $("#DivD").toggle("slow");
        });
    });
</script>
<table width="96%" border="1" cellspacing="0" cellpadding="0">
  <tr>
    <td colspan="11" align="center">&nbsp;Show </td>
  </tr>
  <tr>
    <td>&nbsp;ລຳດັບ</td>
    <td>&nbsp;ProductID</td>
    <td>&nbsp;ProductIDList</td>
    <td>&nbsp;AssetDeptName</td>
    <td>&nbsp;location</td>
    <td>&nbsp;QTY</td>
    <td>&nbsp;GroupName</td>
    <td>&nbsp;DateCreate</td>
    <td>&nbsp;DateEX</td>
    <td>&nbsp;UseName</td>
    <td>&nbsp;Remark</td>
  </tr>
  <?php
  $i=0; 
  while($d=mysql_fetch_assoc($ser))
  {
  ++$i;
  ?>
   
  <tr>
    <td>&nbsp;<?php echo $i?><input type="hidden" name="h1" id="h1" value="<?php echo $d["Auto"]?>"></td>
    <td>&nbsp;<?php echo $d["ProductID"]?><input type="hidden" name="ProductIDS" id="ProductIDS" value="<?php echo $d["ProductID"]?>"></td>
    <td>&nbsp;<?php echo $d["ProductIDList"]?></td>
    <td>&nbsp;<?php echo $d["AssetDeptName"]?></td>
    <td>&nbsp;<?php echo $d["location"]?></td>
    <td>&nbsp;<?php echo $d["QTY"]?></td>
    <td>&nbsp;<?php echo $d["GroupName"]?></td>
    <td>&nbsp;<?php echo $d["DateCreate"]?></td>
    <td>&nbsp;<?php echo $d["DateEX"]?></td>
    <td>&nbsp;<?php echo $d["UseName"]?></td>
    <td>&nbsp;<?php echo $d["Remark"]?></td>
       
 
    <?php  } ?>
  </tr>
</table>
   
</div>
</form>

แก้แบบนี้ แต่มันไม่ วนลูบ ให้ครับ แก้แบบไหนดี ไปไม่เป็น

Date : 2017-11-29 08:57:31

By : Hararock

No. 3

HaraRock

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

......

Date : 2017-11-29 13:30:02

By : Hararock

ค้นหาข้อมูล

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

Re : ส่งค่า ajax ProductID ไปอีก files 1 เพื่อ ส่งค่ามา แสดง โดยส่งแบบ GET เพื่อ WHERE ค่าออกมา ไปไม่เป็น งง ช่วยที่

รายละเอียด

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

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

Notice

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

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

โดย

อีเมล์

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

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

Load balance : Server 01

Registered : 109,038

No. 1

No. 2

No. 3

ค้นหาข้อมูล

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

Notice