经过很多挣扎,我终于能够在我的index.php
中显示博客条目,但它们的顺序是新的在底部,旧的在顶部。
这是我的代码:
<?php
$connect = new PDO('mysql:host=localhost;dbname=posts','root','');
$cmd = $connect->query('SELECT * FROM posts');
$resultado = $cmd->fetchAll(PDO::FETCH_ASSOC);
foreach($resultado as $item):
?>
<div class="post">
<div class="post-body">
<a href="" class="post-title"><?php echo $item['titulo']?></a>
<div class="title-separator"></div>
<p class="post-body-text"><?php echo $item['cuerpo'] ?></p>
</div>
<div class="post-body-footer">
<img src="images/posted.png" alt="" class="posted"> <span class="posted-text">Posted on </span><span class="date"><?php echo $item['fecha']?></span>
</div>
</div>
<?php
endforeach;
?>
为了以您希望列出数据的方式"排序"数据,您可以使用
ORDER BY your_column
可选择ASC
或DESC
。
如果查询中省略ORDER BY
则默认为 ASC
。
即:
SELECT * FROM posts ORDER BY titulo DESC
咨询:
- https://dev.mysql.com/doc/refman/5.0/en/select.html
从手册中提取的示例:
SELECT
[ALL | DISTINCT | DISTINCTROW ]
[HIGH_PRIORITY]
[STRAIGHT_JOIN]
[SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT]
[SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS]
select_expr [, select_expr ...]
[FROM table_references
[WHERE where_condition]
[GROUP BY {col_name | expr | position}
[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position}
[ASC | DESC], ...]