Select record from the database
Code : (for display purposes, some lines wrap. The ↵ character indicates it. The character is not part of the code)
$path_to_db_script = $_SERVER['DOCUMENT_ROOT']↵ . "/" . "db/pjjtextbase.php"; require $path_to_db_script; $novels = ptb_connect ('novels.csv'); $hercule = ptb_select(↵ $novels, ↵ "\'@protagonist\' == \'1\' AND \'year\' == 1938",↵ \'title ASC\'↵ ); $theItem = 1; echo $hercule[$theItem]['id'] . " - " . ↵ $hercule[$theItem]['protagonist'] . " - " . ↵ $hercule[$theItem]['title'] . " ~ aka = " . ↵ $hercule[$theItem]['aka'][0];
27 - Poirot, Hercule - Hercule Poirot's Christmas - aka = A Holiday for Murder
⇪ Feb 17 2021 06:31:00