コード例 #1
0
ファイル: index.php プロジェクト: Olmer1st/library_cms
 $connection = new PDO("mysql:dbname=library;host=127.0.0.1;charset=utf8", "library_admin", "123456");
 $db = new NotORM($connection);
 $booksBySeries = [];
 $books = $db->BooksByAuthor()->where("aid = ?", $aid);
 if ($deleted) {
     $books = $books->where("Deleted <> ?", 1);
 }
 if ($lang) {
     $books = $books->where("lang = ?", $lang);
 }
 $booksBySeries["count"] = count($books);
 $noseq = [];
 $seq = [];
 /* @var $book type */
 foreach ($books as $book) {
     $series = $db->BooksBySerie()->where("bid = ?", $book["bid"]);
     if (count($series) > 0) {
         foreach ($series as $serie) {
             $book["sn"] = $serie["sn"];
             if (array_key_exists($serie["sid"], $seq)) {
                 array_push($seq[$serie["sid"]]["books"], $book);
             } else {
                 $seq[$serie["sid"]]["name"] = $serie["seqname"];
                 $seq[$serie["sid"]]["books"] = [$book];
             }
         }
     } else {
         $noseq[$book["bid"]] = $book;
     }
 }
 $booksBySeries["noseq"] = $noseq;