From ec5b8ede42a7171f55b8668f07b0570ba3c513de Mon Sep 17 00:00:00 2001
From: Remi Collet <remi@remirepo.net>
Date: Wed, 6 Jan 2021 12:51:10 +0100
Subject: minor optimize

---
 all.php | 10 +++++++---
 1 file changed, 7 insertions(+), 3 deletions(-)

diff --git a/all.php b/all.php
index 018f55e..6c408f0 100644
--- a/all.php
+++ b/all.php
@@ -63,12 +63,16 @@ function report ($db)
 
 
     if (substr($what, 0, 1)=='%') {
+        $l = substr($what, 1, 1);
+        if (!ctype_alpha($l) && !ctype_digit($l)) {
+            $l = 'a';
+        }
         $sql = sprintf(
             "SELECT DISTINCT name
              FROM rpm
-             WHERE SUBSTRING(name,1,1) = %s
+             WHERE NAME LIKE '%s%%'
              ORDER BY name",
-            $db->quote(substr($what, 1, 1))
+            $l
         );
     } else {
         $sql = sprintf(
@@ -243,4 +247,4 @@ $page_content = $smarty->fetch('all.tpl');
 $smarty->assign('page_content', $page_content);
 $smarty->display('main.tpl');
 
-?>
\ No newline at end of file
+?>
-- 
cgit