SAE中使用SaeMysql查询数据
例如有一张表gamescore,查询其中的前20名,并以CSV的格式返回,可以用下面的代码:
<?php
$mysql = new SaeMysql();$sql = "SELECT nickName,score FROM `gamescore` ORDER BY score DESC LIMIT 20";
$data = $mysql->getData( $sql ); ?>
<?php foreach($data as $line): ?>
<?php echo $line['nickName'] ?>;<?php echo $line['score']."\n" ?>
<?php endforeach; ?>
<?php
$mysql->closeDb();
?>