|
 |
| |
รบกวนช่วยเรื่องการแปลงข้อความให้ต่อกันอยู่ในรูปแบบ เช่น 'name','last_name','nickname' ที่ครับ |
| |
 |
|
|
 |
 |
|
Code (PHP)
<div>
<label></label>
<input type="text" name="txtSel" id="txtSel" style="width: 350px">
<input name="btnSelect" type="button" id="btnSelect" value="popup"
onClick="javascript:MM_openBrWindow('index.php?r=SODialog/DialogCustomer','pop', 'scrollbars=no,width=350,height=210')">
<input type="submit" name="submit" value="submit">
</div>
Code (PHP)
<script language="javascript">
function selValue()
{
var val = '';
for(i=1;i<=frmPopup.hdnLine.value;i++)
{
if(eval("frmPopup.Chk"+i+".checked")==true)
{
val = val + eval("frmPopup.Chk"+i+".value") + ',';
}
}
window.opener.document.getElementById("txtSel").value = val;
window.close();
}
</script>
<form action="index.php?r=SODialog/DialogCustomer" method="post">
<input type="text" name="search" style="width: 250px">
<input type="submit" value="submit">
<?Php $search = $_POST['search']; ?>
</form>
<?php if($_POST): ?>
<form id="frmPopup" action="" method="post" name="frmPopup">
<?php
$objConnect = mysql_connect("localhost","bicerp","") or die("Error Connect to Database");
$objDB = mysql_select_db("db_test");
$strSQL = "SELECT * FROM so_product WHERE product_name LIKE '%$search%' ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
<table width="318" border="1">
<tr>
<th width="152"> <div align="center">Name </div></th>
<th width="57"> <div align="center">Select </div></th>
</tr>
<?php
$i = 0;
while($objResult = mysql_fetch_array($objQuery))
{
$i++;
?>
<tr>
<td><?php echo $objResult["product_name"];?></td>
<td align="center"><input name="Chk<?php echo $i;?>" id="Chk<?php echo $i;?>" type="checkbox" value="'<?php echo $objResult["product_name"];?>'"></td>
</tr>
<?php
}
?>
</table>
<input name="hdnLine" type="hidden" value="<?php echo $i;?>">
<br>
<input name="btnSelect" type="button" value="Select" onClick="JavaScript:selValue();">
</form>
<?php endif; ?>
<?php
//mysql_close($objConnect);
?>
รบกวนช่วยแปลงข้อความต่อกันไห้ทีครับ เช่น product_name IN ('Dynazide 10%/10 kg.','Moxyguard 50% S/10kg.')
ผมจะเอาข้อความเข้ามา query ในการใช่ IN ครับ
Tag : PHP, MySQL, JavaScript, jQuery
|
ประวัติการแก้ไข
2015-02-17 10:50:56
|
 |
 |
 |
 |
| Date :
2015-02-17 10:49:41 |
By :
yokvoice |
View :
690 |
Reply :
4 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
Code (PHP)
$input1='a';
$input2='b';
$input3='c';
$str="'".$input1."','".$input2."','".$input3."'";
echo $str;
|
| |
|
|
| |
| Date :
2015-02-17 11:51:14 |
By :
pgm |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
คืองี้ครับ ผมนำ บทความ JavaScript Send Checkbox Data from Popup to Main form
ผมลัพก็จะได้ เปนแบบนี้ A,B,C
ความต้องการผมอยากได้แบบนี้ครับ 'A','B','C' ครับ
Code (PHP)
<html>
<head>
<title>ThaiCreate.Com</title>
</head>
<body>
<script language="JavaScript">
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features).focus();
}
</script>
<form name="frmMain" action="" method="post">
<input type="text" name="txtSel" id="txtSel">
<input name="btnSelect" type="button" id="btnSelect" value="popup"
onClick="javascript:MM_openBrWindow('checkbox_popup_data2.html','pop', 'scrollbars=no,width=350,height=210')">
</form>
</body>
</html>
Code (PHP)
<html>
<head>
<title>ThaiCreate.Com</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<script language="javascript">
function selValue()
{
var val = '';
for(i=1;i<=frmPopup.hdnLine.value;i++)
{
if(eval("frmPopup.Chk"+i+".checked")==true)
{
val = val + eval("frmPopup.Chk"+i+".value") + ',';
}
}
window.opener.document.getElementById("txtSel").value = val;
window.close();
}
</script>
<form action="" method="post" name="frmPopup" id="frmPopup">
<table width="185" border="1" cellspacing="0" cellpadding="0">
<tr>
<td width="64"><input name="Chk1" type="checkbox" id="Chk1" value="A"></td>
<td width="115">A</td>
</tr>
<tr>
<td><input name="Chk2" type="checkbox" id="Chk2" value="B"></td>
<td>B</td>
</tr>
<tr>
<td><input name="Chk3" type="checkbox" id="Chk3" value="C"></td>
<td>C</td>
</tr>
<tr>
<td><input name="Chk4" type="checkbox" id="Chk4" value="D"></td>
<td>E</td>
</tr>
<tr>
<td><input name="Chk5" type="checkbox" id="Chk5" value="E"></td>
<td>D</td>
</tr>
</table>
<input name="hdnLine" type="hidden" value="5">
<br>
<input name="btnSelect" type="button" value="Select" onClick="JavaScript:selValue();">
</form>
</body>
</html>
|
| |
|
|
| |
| Date :
2015-02-17 13:24:40 |
By :
yokvoice |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
15.val = val + eval("frmPopup.Chk"+i+".value") + ',';
16.}
17.}
แก้เป็น
Code (JavaScript)
val += (val>''? ',' : '') + "'"+ eval("frmPopup.Chk"+i+".value") + "'";
}
}
|
ประวัติการแก้ไข
2015-02-17 14:05:47
| |
|
|
| |
| Date :
2015-02-17 14:03:52 |
By :
Chaidhanan |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
โววว ขอบคุณมากเลยครับ 
|
| |
|
|
| |
| Date :
2015-02-17 14:12:55 |
By :
yokvoice |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 05
|
