douang4294 2013-04-10 21:53
浏览 20
已采纳

在HTML中抓取变量到Echo的部分

How how would I just grab the first few words of a variable such as $data for example. I'm trying to create an article preview section and that variable is an article. I'm trying to display of course only a preview of it.

    <?php
$sql = "SELECT author, data, postdate, Title, previewimg FROM articlepreview ORDER BY RAND() LIMIT 1";
$query = mysqli_query($db_conx,$sql);
$prev = "";
while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC)) {
    $a = $row["author"];
    $data = $row["data"];
    $postdate = $row["postdate"];
    $title = $row["Title"];
    $previewimg = $row["previewimg"];
    $prev .= '
<div class="wrapPreviewArticle">


    <div style="headerPreview"><h4>'.$title.'</h4></div>
    <div class="wrapPreviewRow">
    <div style="imagePreview"><img src="'.$previewimg.'" height="20%" width="20%" alt="'.$title.'" /></div>
    <div clas="wordPreview">'.$data.'</div>
    </div>
</div>
';
}
?>

Once I've got this I would spit out the variable

<body>
<div><?php echo $prev; ?></div> <!--with only the desired portion.-->
</body>

Any help is greatly appreciated.

  • 写回答

3条回答 默认 最新

  • douxuqiao6394 2013-04-10 21:55
    关注

    You could use SUBSTRING_INDEX on your query:

    "SELECT author, SUBSTRING_INDEX(data, ' ', 5) data, ... FROM articlepreview ..."
    

    This will extract only the first 5 words from the field data.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 python的qt5界面
  • ¥15 无线电能传输系统MATLAB仿真问题
  • ¥50 如何用脚本实现输入法的热键设置
  • ¥20 我想使用一些网络协议或者部分协议也行,主要想实现类似于traceroute的一定步长内的路由拓扑功能
  • ¥30 深度学习,前后端连接
  • ¥15 孟德尔随机化结果不一致
  • ¥15 apm2.8飞控罗盘bad health,加速度计校准失败
  • ¥15 求解O-S方程的特征值问题给出边界层布拉休斯平行流的中性曲线
  • ¥15 谁有desed数据集呀
  • ¥20 手写数字识别运行c仿真时,程序报错错误代码sim211-100