修改这个PHP字母分页脚本来添加活动状态 - Modify This PHP Alphabet Pagination Script To Add Active State

Modify This PHP Alphabet Pagination Script To Add Active State

不久前，我发现了一个简洁的php字母排序脚本。当单击与该字母相关的超链接时，它返回数据库中以特定字母开头的条目。它使用mysql API，所以我修改它使用mysqli API。

我现在要做的是修改php，使一个css类将包围选定的字母，我可以使用这个类作为一个活动状态。关于我如何修改下面的代码来做到这一点的任何想法?谢谢你。

$mysqli = new mysqli("x", "x", "x", "x");
$sort = $_REQUEST['letter'];

if($sort == ""){
$qry= "SELECT * FROM table ORDER BY title ASC " ;
}else{
$qry = "SELECT * FROM table WHERE title LIKE '$sort%' ORDER BY title ASC" ;
}
$execute = $mysqli->query($qry) or die(mysqli_error());
$row_cnt = mysqli_num_rows($execute);
echo "<p>" ;
for ($i = 65; $i < 91; $i++) {
    printf('<a href="%s?letter=%s">%s</a> | ',
    $PHP_SELF, chr($i), chr($i));
}
echo "</p>" ;
if ($row_cnt  > 0) {
do{
while ($row = $execute->fetch_assoc()) {
        printf ("%s %s <br />", $row["id"], $row["title"]);
    }
}
while ($row = $execute->fetch_assoc());
}else{
echo "<p>No customer found.</p>" ;
}

在这里，查找$class查看我更改的内容:

$mysqli = new mysqli("x", "x", "x", "x");
$sort = $_REQUEST['letter'];

if($sort == ""){
$qry= "SELECT * FROM table ORDER BY title ASC " ;
}else{
$qry = "SELECT * FROM table WHERE title LIKE '$sort%' ORDER BY title ASC" ;
}
$execute = $mysqli->query($qry) or die(mysqli_error());
$row_cnt = mysqli_num_rows($execute);
echo "<p>" ;
for ($i = 65; $i < 91; $i++) {
    if(ord($sort) == $i) {
      $class = 'active';
    } else {
      $class = '';
    }
    printf('<a href="%s?letter=%s" class="%s">%s</a> | ', $PHP_SELF, chr($i), $class, chr($i));
}
echo "</p>" ;
if ($row_cnt  > 0) {
do{
while ($row = $execute->fetch_assoc()) {
        printf ("%s %s <br />", $row["id"], $row["title"]);
    }
}
while ($row = $execute->fetch_assoc());
}else{
echo "<p>No customer found.</p>" ;
}