From: ldo@nz.invalid   
      
   On Thu, 10 Jul 2025 19:57:32 -0400, Arne Vajhøj wrote:   
      
   > (and yes - everybody should use PDO instead of mysqli!)   
   >   
   > $con = new PDO('mysql:host=arnepc5;dbname=test', 'arne', 'hemmeligt');   
   > $con->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);   
   > $stmt = $con->prepare('SELECT the data needed');   
   > if(!$stmt) {   
   >      echo $con->errorInfo()[2] . "\r\n";   
   >      goto finish;   
   > }   
   > if(!$stmt->execute()) {   
   >      echo $stmt->errorInfo()[2] . "\r\n";   
   >      goto finish;   
   > }   
      
   That is so clunky without exceptions. You’d think normal programmers   
   would get fed up of continually writing prepare/execute/fetch   
   sequences. But PHP programmers don’t seem to think like normal people.   
      
   Here’s a utility function I wrote for my Python code years ago, and   
   use every time I want to retrieve data from an SQL database. This is   
   the SQLite version using the APSW wrapper:   
      
       def db_iter(conn, cmd, values = None, mapfn = lambda x : x) :   
           "executes cmd on a new cursor from connection conn and yields" \   
           " the results in turn."   
           for item in conn.cursor().execute(cmd, values) :   
               yield mapfn(item)   
           #end for   
       #end db_iter   
      
   So getting and processing records is as simple as   
      
       for entry in db_iter(conn, "select ..." ...) :   
           ... do something with entry ...   
       #end for   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)