dongzhi8487 2015-05-17 21:08
浏览 52

mySQL,图像和文本在一行中。 如何分开它们?

I have a blog(wordpress), and a website. I would like to connect my site to the blog. I mean that when I add a post to my blog, it(only title and image) appears on my website. There is one problem. When i add a post with a image, it appears in one common row. I would like to separate them display only the text, or only the image of my post, but I dont know how to do that.

Here is a template of the row(I can't add a photo)

     [caption id="attachment_22" align="alignleft" width="300"]<a href="http://zukiemprzezswiat.pl/blog/wp-content/uploads/2015/04/20141216_112435-e1429102893578.jpg"><img class="wp-image-22 size-medium" src="http://zukiemprzezswiat.pl/blog/wp-content/uploads/2015/04/20141216_112435-300x225.jpg" alt="20141216_112435" width="300" height="225" /></a> Winowajca zamieszania :)[/caption]`

&nbsp;
<p style="text-align: left;">HERE IS SOME TEXT</p>
[embed]https://www.youtube.com/watch?v=VkmJ3OK8PPU[/embed]


BELOW IS THE PHP CODE, I WROTE:

    <!-- ===============================================POLACZENIE Z BAZA I ODCZYT DANYCH=============================================== -->
<?php
$connection = @mysql_connect('WEBSITE', 'LOGIN', 'PASSWORD')
or die('Brak połączenia z serwerem MySQL.<br />Błąd: '.mysql_error());

$db = @mysql_select_db('SOMETHING', $connection)
or die('Nie mogę połączyć się z bazą danych<br />Błąd: '.mysql_error());



/*######################CONNECT WITH THE TABLE wp1_posts AND DOWNLOAD ALL NEEDED DATA#############################*/    

$wynik = mysql_query("SELECT ID, post_date, post_title, post_content, FROM wp1_posts WHERE ((post_author='2') OR (post_author='1')) AND (post_status='publish')")
or die('Błąd zapytania');


if(mysql_num_rows($wynik) > 0) {
    echo "<table cellpadding=\"2\" border=1>";
    while($r = mysql_fetch_assoc($wynik)) {
        echo "<tr>";
        echo "<td>".$r['ID']."</td>";
        echo "<td id=\"data-my-sql\">".$r['post_date']."</a>"."&nbsp&nbsp&nbsp"."</td>";
        echo "<td id=\"title-my-sql\"><a href=\"http://zukiemprzezswiat.pl/blog/\">".$r['post_title']."</a>"."</td>";
        echo "<td>".$r['post_content']."</td>";
        echo "</tr>";
    }
    echo "</table>";
}

mysql_close($connection);

?> 

To sum up, I want to separate images and text from the post_content row. At the moment it display a photo and all text.

Please, help

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥100 支付宝网页转账系统不识别账号
    • ¥15 基于单片机的靶位控制系统
    • ¥15 AT89C51控制8位八段数码管显示时钟。
    • ¥15 真我手机蓝牙传输进度消息被关闭了,怎么打开?(关键词-消息通知)
    • ¥15 下图接收小电路,谁知道原理
    • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
    • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
    • ¥15 手机接入宽带网线,如何释放宽带全部速度
    • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
    • ¥15 ETLCloud 处理json多层级问题