<commit_before><!---
//
// <NAME>
// 2013-11-30
// https://github.com/DrSkippy27/php_books_database
//
--->
<?php

echo ('<html><head><meta http-equiv="refresh" content="10; URL=./index.php">');
echo ('<link href="./books.css" rel="stylesheet" type="text/css">');
echo ('</head><body> <h3>Entry Added</h3>');
include('./db_header.php');
if ($_REQUEST['recycled'] == "yes") {
    $recycled = 1;
} else {
    $recycled = 0;
}
$dt          = mktime(0, 0, 0, 1, 1, $_REQUEST['copyrightdate']);
$insert_str  = 'INSERT INTO `book collection` ';
$insert_str .= '(Title, Author, CopyrightDate, ISBNNumber, ISBNNumber13, PublisherName, ';
// $insert_str .= 'CoverType, Pages, LastRead, PreviouslyRead, Location, Note, Recycled) ';
$insert_str .= 'CoverType, Pages, Location, Note, Recycled) ';
$insert_str .= 'VALUES ("' . $_REQUEST['title'] . '","' . $_REQUEST['author'] . '","' . date("Y-m-d h:m:s", $dt);
$insert_str .= '","' . $_REQUEST['isbnnumber'] . '","' . $_REQUEST['isbnnumber13'] . '","';
$insert_str .= $_REQUEST['publishername'] . '","' . $_REQUEST['covertype'] . '","' . $_REQUEST['pages'];
// $insert_str .= '",0000-00-00,0000-00-00,"' . $_REQUEST['location'] . '","' . $_REQUEST['note'] . '","' . $recycled . '")';
$insert_str .= $_REQUEST['location'] . '","' . $_REQUEST['note'] . '","' . $recycled . '")';
echo($insert_str);

# echo '<hr>'.$insert_str;
$result = @mysqli_query($dbcnx, $insert_str);
if (!$result) {
    echo ('<p>Error performing query: ' . mysqli_error($dbcnx) . '</p>');
    exit();
}
include('./footer.php');
?>
<commit_msg>missing comma in query<commit_after><!---
//
// <NAME>
// 2013-11-30
// https://github.com/DrSkippy27/php_books_database
//
--->
<?php

echo ('<html><head><meta http-equiv="refresh" content="3; URL=./index.php">');
echo ('<link href="./books.css" rel="stylesheet" type="text/css">');
echo ('</head><body> <h3>Entry Added</h3>');
include('./db_header.php');
if ($_REQUEST['recycled'] == "yes") {
    $recycled = 1;
} else {
    $recycled = 0;
}
$dt          = mktime(0, 0, 0, 1, 1, $_REQUEST['copyrightdate']);
$insert_str  = 'INSERT INTO `book collection` ';
$insert_str .= '(Title, Author, CopyrightDate, ISBNNumber, ISBNNumber13, PublisherName, ';
// $insert_str .= 'CoverType, Pages, LastRead, PreviouslyRead, Location, Note, Recycled) ';
$insert_str .= 'CoverType, Pages, Location, Note, Recycled) ';
$insert_str .= 'VALUES ("' . $_REQUEST['title'] . '","' . $_REQUEST['author'] . '","' . date("Y-m-d h:m:s", $dt);
$insert_str .= '","' . $_REQUEST['isbnnumber'] . '","' . $_REQUEST['isbnnumber13'] . '","';
$insert_str .= $_REQUEST['publishername'] . '","' . $_REQUEST['covertype'] . '","' . $_REQUEST['pages'] . '","';
// $insert_str .= '",0000-00-00,0000-00-00,"' . $_REQUEST['location'] . '","' . $_REQUEST['note'] . '","' . $recycled . '")';
$insert_str .= $_REQUEST['location'] . '","' . $_REQUEST['note'] . '","' . $recycled . '")';
//echo($insert_str);

# echo '<hr>'.$insert_str;
$result = @mysqli_query($dbcnx, $insert_str);
if (!$result) {
    echo ('<p>Error performing query: ' . mysqli_error($dbcnx) . '</p>');
    exit();
}
include('./footer.php');
?>

{'fraction_non_alphanumeric': 0.2786675208199872, 'fraction_numerical': 0.025944907110826393, 'mean_word_length': 4.338461538461538, 'pattern_counts': {'":': 0, '<': 31, '<?xml version=': 0, '>': 31, 'https://': 2, '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': '2521118', 'n_tokens_mistral': 1229, 'n_tokens_neox': 1168, 'n_words': 203}