รบกวนผู้รู้หน่อยครับ ผมต้องการ ตัดข้อมูลระหว่างเครื่องหมาย จุลภาค "," ออกมาทีละค่าจนครบครับ
BALCTH141200027, BALCTH141200043, BALCTH141200049, BBMCTH170700001, BRMCTH170900085, BRMCTH171000017, BRMCTH171000019, BRMCTH171000020, BRMCTH171000068, BRMCTH171000070, BRMCTH171000071, BRMCTH171000073, BRMCTH171000074, BRMCTH171000078, BTLCTH170800192, LSTCTH160900016, LSTCTH161200105Tag PHP, MySQL
Date :
2017-03-13 11:17:59By :
osuppakarnoView :
751Reply :
5
Code (PHP) <?php
$strString = "BALCTH141200027, BALCTH141200043, BALCTH141200049, BBMCTH170700001, BRMCTH170900085, BRMCTH171000017, BRMCTH171000019, BRMCTH171000020, BRMCTH171000068, BRMCTH171000070, BRMCTH171000071, BRMCTH171000073, BRMCTH171000074, BRMCTH171000078, BTLCTH170800192, LSTCTH160900016, LSTCTH161200105";
$strSQL = "SELECT * FROM table_name WHERE Code IN ('".str_replace(", ", "','", $strString)."')";
echo $strSQL;
?>
Result SELECT * FROM table_name WHERE Code IN ('BALCTH141200027','BALCTH141200043','BALCTH141200049','BBMCTH170700001','BRMCTH170900085','BRMCTH171000017','BRMCTH171000019','BRMCTH171000020','BRMCTH171000068','BRMCTH171000070','BRMCTH171000071','BRMCTH171000073','BRMCTH171000074','BRMCTH171000078','BTLCTH170800192','LSTCTH160900016','LSTCTH161200105')
Date :
2017-03-13 13:16:39By :
mr.win
ขอบคุณขอรับ
Date :
2017-03-13 18:34:23By :
jack
Date :
2017-03-14 09:06:19By :
mr.win
Code (PHP) $string="BALCTH141200027, BALCTH141200043, BALCTH141200049, BBMCTH170700001, BRMCTH170900085, BRMCTH171000017, BRMCTH171000019, BRMCTH171000020, BRMCTH171000068, BRMCTH171000070, BRMCTH171000071, BRMCTH171000073, BRMCTH171000074, BRMCTH171000078, BTLCTH170800192, LSTCTH160900016, LSTCTH161200105";
$tags = explode(',',$string);
foreach($tags as $key) {
echo '"'.$key.'"<br/>';
}
Date :
2017-03-14 15:52:13By :
คนมีเสน่ห์
Server 01
Load balance : Server 01
