<commit_before><?php

/**
    Use this script for a simple database dump
**/

require_once "lib/app.php";

try {
    // Create (connect to) SQLite database (creates if not exists)
    $db = open_db($db_address_abs);

    // Create table
    // -------------------------------------------------------------------------
    $style1 = " style='border: 0px solid black; width: 4em;'";
    $style2 = " style='border: 0px solid black;'";
    echo "<table{$style2}>\n";

    // Select all data from memory db messages table
    #$result = $db->query("SELECT * FROM {$tableName} WHERE hasPayed=1 ORDER BY LOWER(lastname) ASC, firstname ASC;", PDO::FETCH_ASSOC);
    $result = $db->query("SELECT * FROM {$tableName} ORDER BY LOWER(lastname) ASC, firstname ASC;", PDO::FETCH_ASSOC);

    echo "  <tbody>\n";
    foreach($result as $r) {
        echo "    <tr>\n";
        echo "      <td class='small'{$style1}>".nl2br(htmlentities($r['title'],FALSE))."</td>\n";
        echo "      <td{$style2}>".nl2br(htmlentities($r['firstname'], FALSE))." ";
        echo " ".nl2br(htmlentities($r['lastname'], FALSE))."</td>\n";
        echo "      <td class='small'{$style2}> (".nl2br(htmlentities($r['affiliation'], FALSE)).")</td>\n";
        echo "    </tr>\n";
    }
    echo "  </tbody>\n</table>\n";
#    echo "</body></html>\n";

    // Close file db connection
    // -------------------------------------------------------------------------
    $db = null;<commit_msg>bugfix<commit_after><?php

/**
    Use this script for a simple database dump
**/

require_once "lib/app.php";

try {
    // Create (connect to) SQLite database (creates if not exists)
    $db = open_db($db_address_abs);

    // Create table
    // -------------------------------------------------------------------------
    $style1 = " style='border: 0px solid black; width: 4em; text-align: right;'";
    $style2 = " style='border: 0px solid black;'";
    echo "<table{$style2}>\n";

    // Select all data from memory db messages table
    #$result = $db->query("SELECT * FROM {$tableName} WHERE hasPayed=1 ORDER BY LOWER(lastname) ASC, firstname ASC;", PDO::FETCH_ASSOC);
    $result = $db->query("SELECT * FROM {$tableName} ORDER BY LOWER(lastname) ASC, firstname ASC;", PDO::FETCH_ASSOC);

    echo "  <tbody>\n";
    foreach($result as $r) {
        echo "    <tr>\n";
        echo "      <td class='small'{$style1}>".nl2br(htmlentities($r['title'],FALSE))."</td>\n";
        echo "      <td{$style2}>".nl2br(htmlentities($r['firstname'], FALSE))." ";
        echo " ".nl2br(htmlentities($r['lastname'], FALSE))."</td>\n";
        echo "      <td class='small'{$style2}> (".nl2br(htmlentities($r['affiliation'], FALSE)).")</td>\n";
        echo "    </tr>\n";
    }
    echo "  </tbody>\n</table>\n";
#    echo "</body></html>\n";

    // Close file db connection
    // -------------------------------------------------------------------------
    $db = null;
{'fraction_non_alphanumeric': 0.2833219412166781, 'fraction_numerical': 0.009569377990430622, 'mean_word_length': 2.042619542619543, 'pattern_counts': {'":': 0, '<': 33, '<?xml version=': 0, '>': 35, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '5261650', 'n_tokens_mistral': 930, 'n_tokens_neox': 910, 'n_words': 209}