我有一个广告脚本,我存储在我的数据库使用textarea字段。但是当我在php中回显这个脚本时。那就行不通了。这是我的脚本,我保存在数据库中使用textarea字段。
<script type="text/javascript">
( function() {
if (window.CHITIKA === undefined) { window.CHITIKA = { 'units' : [] }; };
var unit = {"calltype":"async[2]","publisher":"seeknfameads","width":300,"height":250,"sid":"Chitika Default","color_site_link":"337ab7","color_text":"337ab7"};
var placement_id = window.CHITIKA.units.length;
window.CHITIKA.units.push(unit);
document.write('<div id="chitikaAdBlock-' + placement_id + '"></div>');
}());
</script>
<script type="text/javascript" src="//cdn.chitika.net/getads.js" async></script>
当我取回字段并尝试回显这个。这行不通。
$sql4 = "SELECT * FROM abc ORDER BY id DESC LIMIT 1";
$query4 = $conn->query($sql4);
$row4 = $query4->fetch(PDO::FETCH_ASSOC);
$video_des=$row4['video_des'];
$rowc = $query4->rowCount(PDO::FETCH_ASSOC);
if ($rowc>=1){
<script><?php echo $video_des;?></script>
}
请帮忙解决这个问题。
由于您已经插入了video_des的值与<script> and </script>
标记
您不需要再添加<script>
标签,请在下面尝试。
$sql4 = "SELECT * FROM abc ORDER BY id DESC LIMIT 1";
$query4 = $conn->query($sql4);
$row4 = $query4->fetch(PDO::FETCH_ASSOC);
$video_des=$row4['video_des'];
$rowc = $query4->rowCount(PDO::FETCH_ASSOC);
if ($rowc>=1){
echo $video_des;
}
只需在if条件result
执行此操作if ($rowc>=1){
echo $video_des; // remove script tag from here
}