<commit_before><?php
include("scripts/dbconnect.php");
include("scripts/header.php");

$query = "SELECT * From port_club as C, port_photo as P WHERE clubid IS NOT NULL AND C.photoid = P.photoid";

$result = $db->query($query);


echo "<main>";

//echo some basic stuff

$total = $result->num_rows;

echo "<h1> GoPortlethen clubs </h1>";

echo "<h4> Displaying ". $total . " active clubs </h4>";



while($row = $result->fetch_array()) {
    $pictureURL = $row['URL'];
    $clubID = $row['clubid'];
    $clubTitle = $row['clubTitle'];

    echo "<table?<tr>
    <td><img src='{$pictureURL}'height='300', width='300'>
    <h1><a href='Clubs/{$clubID}' name='linkref' id='link'>{$clubTitle}</a></h1><td><commit_msg>Attempt 4 cont again<commit_after><?php
include("scripts/dbconnect.php");
include("scripts/header.php");

$query = "SELECT * From port_club as C, port_photo as P WHERE clubid IS NOT NULL AND C.photoid = P.photoid";

$result = $db->query($query);


echo "<main>";

//echo some basic stuff

$total = $result->num_rows;

echo "<h1> GoPortlethen clubs </h1>";

echo "<h4> Displaying ". $total . " active clubs </h4>";



while($row = $result->fetch_array()) {
    $pictureURL = $row['URL'];
    $clubID = $row['clubid'];
    $clubTitle = $row['clubTitle'];

    echo "<table><tr>
    <td><img src='{$pictureURL}'height='300', width='300'>
    <h1><a href='Clubs/{$clubID}' name='linkref' id='link'>{$clubTitle}</a></h1><td>
{'fraction_non_alphanumeric': 0.2180293501048218, 'fraction_numerical': 0.017470300489168415, 'mean_word_length': 4.637795275590551, 'pattern_counts': {'":': 0, '<': 33, '<?xml version=': 0, '>': 36, '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': '2067060', 'n_tokens_mistral': 532, 'n_tokens_neox': 507, 'n_words': 120}