<commit_before><?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

include("scripts/header.php");

include("scripts/dbconnect.php");

$sql = "SELECT * FROM port_club_article"; //AS A, port_club AS C WHERE C.clubid = A.clubid";

echo "<style>
table {
    border-collapse: collapse;
    width: 100%;
}

th, td {
    text-align: left;
    padding: 8px;
}
th {
    background-color: #3daf6a;
    color: white;
}

tr:nth-child(even){background-color: #f2f2f2}
.edit {
	-moz-box-shadow: 0px 0px 0px 0px #3dc21b;
	-webkit-box-shadow: 0px 0px 0px 0px #3dc21b;
	box-shadow: 0px 0px 0px 0px #3dc21b;
	background-color:#44c767;
	-moz-border-radius:15px;
	-webkit-border-radius:15px;
	border-radius:15px;
	border:1px solid #18ab29;
	display:inline-block;
	cursor:pointer;
	color:#ffffff;
	font-family:Arial;
	font-size:16px;
	padding:6px 12px;
	text-decoration:none;
	text-shadow:0px 1px 0px #2f6627;
}
.edit:hover {
	background-color:#5cbf2a;
}
.edit:active {
	position:relative;
	top:1px;
}
.add {
	-moz-box-shadow: 0px 0px 0px 0px #3dc21b;
	-webkit-box-shadow: 0px 0px 0px 0px #3dc21b;
	box-shadow: 0px 0px 0px 0px #3dc21b;
	background-color:#44c767;
	-moz-border-radius:15px;
	-webkit-border-radius:15px;
	border-radius:15px;
	border:1px solid #18ab29;
	display:inline-block;
	cursor:pointer;
	color:#ffffff;
	font-family:Arial;
	font-size:16px;
	padding:6px 12px;
	text-decoration:none;
	text-shadow:0px 1px 0px #2f6627;
}
.add:hover {
	background-color:#5cbf2a;
}
.add:active {
	position:relative;
	top:1px;
}
</style>";

echo "<p><b>Club Articles</b></p>";

echo "<div style=\"overflow-x:auto;\">";

echo "<table>";

echo "<tr> <th>Article ID</th> <!--<th>Club Name</th>--> <th>Article</th> <th>Photo ID</th> </tr>";

$result = $db->query($sql);
while ($row = $result->fetch_array()) {
    echo "<tr>";
    echo '<td>' . $row['clubarticleid'] . '</td>';
    //echo '<td>' . $row['clubTitle'] . '</td>';
    echo '<td>' . $row['title'] . '</td>';
    echo '<td>' . $row['photoID'] . '</td>';
//    echo '<td> <input type="submit" value="Edit">';
//    echo '<td><a href="edit" class="edit' . $row['userID']. '">Edit</a></td>';
    echo '<td><a href="deleteArticle/' . $row['clubarticleid'] . '">Delete</a></td>';
    if ($row['confirmedArtice'] == 0) {
        echo '<td><a href="confirmArticle/' . $row['clubarticleid'] . '">Confirm Article</a></td>';
    } else {
        echo '<td>Article Confirmed</td>';
    }
    echo "</tr>";
}

echo "</table>";

//echo '<td><a href="add" class="add" >Add</a></td>';

?>

</body>

</html><commit_msg>Registration page<commit_after><?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

include("scripts/header.php");

include("scripts/dbconnect.php");

$sql = "SELECT * FROM port_club_article"; //AS A, port_club AS C WHERE C.clubid = A.clubid";

echo "<style>
table {
    border-collapse: collapse;
    width: 100%;
}

th, td {
    text-align: left;
    padding: 8px;
}
th {
    background-color: #3daf6a;
    color: white;
}

tr:nth-child(even){background-color: #f2f2f2}
.edit {
	-moz-box-shadow: 0px 0px 0px 0px #3dc21b;
	-webkit-box-shadow: 0px 0px 0px 0px #3dc21b;
	box-shadow: 0px 0px 0px 0px #3dc21b;
	background-color:#44c767;
	-moz-border-radius:15px;
	-webkit-border-radius:15px;
	border-radius:15px;
	border:1px solid #18ab29;
	display:inline-block;
	cursor:pointer;
	color:#ffffff;
	font-family:Arial;
	font-size:16px;
	padding:6px 12px;
	text-decoration:none;
	text-shadow:0px 1px 0px #2f6627;
}
.edit:hover {
	background-color:#5cbf2a;
}
.edit:active {
	position:relative;
	top:1px;
}
.add {
	-moz-box-shadow: 0px 0px 0px 0px #3dc21b;
	-webkit-box-shadow: 0px 0px 0px 0px #3dc21b;
	box-shadow: 0px 0px 0px 0px #3dc21b;
	background-color:#44c767;
	-moz-border-radius:15px;
	-webkit-border-radius:15px;
	border-radius:15px;
	border:1px solid #18ab29;
	display:inline-block;
	cursor:pointer;
	color:#ffffff;
	font-family:Arial;
	font-size:16px;
	padding:6px 12px;
	text-decoration:none;
	text-shadow:0px 1px 0px #2f6627;
}
.add:hover {
	background-color:#5cbf2a;
}
.add:active {
	position:relative;
	top:1px;
}
</style>";

echo "<p><b>Club Articles</b></p>";

echo "<div style=\"overflow-x:auto;\">";

echo "<table>";

echo "<tr> <th>Article ID</th> <!--<th>Club Name</th>--> <th>Article</th> <th>Photo ID</th> </tr>";

$result = $db->query($sql);
while ($row = $result->fetch_array()) {
    echo "<tr>";
    echo '<td>' . $row['clubarticleid'] . '</td>';
    //echo '<td>' . $row['clubTitle'] . '</td>';
    echo '<td>' . $row['title'] . '</td>';
    echo '<td>' . $row['photoID'] . '</td>';
//    echo '<td> <input type="submit" value="Edit">';
//    echo '<td><a href="edit" class="edit' . $row['userID']. '">Edit</a></td>';
    echo '<td><a href="deleteArticle/' . $row['clubarticleid'] . '">Delete</a></td>';
    if ($row['confirmArticle'] == 0) {
        echo '<td><a href="confirmArticle/' . $row['clubarticleid'] . '">Confirm Article</a></td>';
    } else {
        echo '<td>Article Confirmed</td>';
    }
    echo "</tr>";
}

echo "</table>";

//echo '<td><a href="add" class="add" >Add</a></td>';

?>

</body>

</html>
{'fraction_non_alphanumeric': 0.21869556802786916, 'fraction_numerical': 0.045674472614670024, 'mean_word_length': 4.037037037037037, 'pattern_counts': {'":': 0, '<': 109, '<?xml version=': 0, '>': 113, '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': '941111', 'n_tokens_mistral': 2282, 'n_tokens_neox': 2101, 'n_words': 416}