<commit_before><!DOCTYPE html>
<html lang="en">

<head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="Looking to get chess involved in your school? Look no further, One Way Chess is your solution to high quality chess instruction at your school.  ">
    <meta name="author" content="One Way Chess">

    <title>Blog Posts</title>

    <!-- Bootstrap Core CSS - Uses Bootswatch Flatly Theme: http://bootswatch.com/flatly/ -->
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <link href="css/contact-buttons.css" rel="stylesheet">


    <!-- Custom CSS -->
    <link href="css/freelancer.css" rel="stylesheet">
    <!-- <link href="css/clean-blog.min.css" rel="stylesheet">
    <link href="css/agency.css" rel="stylesheet"> -->

    <!-- Custom Fonts -->
    <link href="font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
    <link href="http://fonts.googleapis.com/css?family=Montserrat:400,700" rel="stylesheet" type="text/css">
    <link href="http://fonts.googleapis.com/css?family=Lato:400,700,400italic,700italic" rel="stylesheet" type="text/css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script>
    <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
    <script src="js/submitpost.js"></script> 
    <script src = "http://ajax.googleapis.com/ajax/libs/angularjs/1.3.14/angular.min.js"></script>
    <script src="js/formjs.js"></script>
      
        <!-- Favicon --> 
        <link rel="shortcut icon" href="favicon.ico" /> 
    
        <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
        <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
        <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->
        <script src="../js/analytics.js"> </script>
</head>

<body id="page-top" class="index">
    <div id="fb-root"></div>
    <script>(function(d, s, id) {
      var js, fjs = d.getElementsByTagName(s)[0];
      if (d.getElementById(id)) return;
      js = d.createElement(s); js.id = id;
      js.src = "//connect.facebook.net/en_US/sdk.js#xfbml=1&version=v2.6";
      fjs.parentNode.insertBefore(js, fjs);
    }(document, 'script', 'facebook-jssdk'));
    </script>
    <!-- Navigation -->
    <nav class="navbar navbar-default navbar-fixed-top">
        <div class="container">
            <!-- Brand and toggle get grouped for better mobile display -->
            <div class="navbar-header page-scroll">
                <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
                    <span class="sr-only">Toggle navigation</span>
                    <span class="icon-bar"></span>
                    <span class="icon-bar"></span>
                    <span class="icon-bar"></span>
                </button>
                <a class="navbar-brand" href="../../schools/">One Way Chess Schools</a>
            </div>

            <!-- Collect the nav links, forms, and other content for toggling -->
            <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
                <ul class="nav navbar-nav navbar-right">
                    <li class="hidden">
                        <a href="#page-top"></a>
                    </li>
                    <li>
                        <a href="blog.php">Welcome</a>
                    </li>
                    <li> <a href="entries.php">Blog Entries</a> </li>
                    <li class="page-scroll">
                        <a href="writers.php">Writers</a>
                    </li>
                </ul>
            </div>
            <!-- /.navbar-collapse -->
        </div>
        <!-- /.container-fluid -->
    </nav>

    <!-- Header -->
    <header>
        <div class="container">
            <div class="row">
                <div class="col-lg-12">
                    <img class="img-responsive circle-crop" src="img/OneWayChessLogo.png" alt="">
                    <div class="intro-text">
                        <span class="name">One Way Chess</span>
                        <hr class="star-light">
                        <span class="skills">Coaching Advice, Training Tips, Chess Thoughts, simply anything and everything chess!</span>
                    </div>
                </div>
            </div>
        </div>
    </header>

<section class="success" id="writers">
        <div class="container">
            <div class="row">
                <div class="col-lg-12 text-center">
                    <h2>Writers</h2>
                    <hr class="star-light">
                </div>
            </div>
            <div class="row">
                <?php
                $con = new mysqli('localhost', 'chess_testuser', 'chess123', 'chess_blogEntries'); 
                if ($con->connect_error) {
                    die("Connection failed: " . $con->connect_error);
                }
                $sql = "SELECT email, fname, lname, bioText, position, imagelink FROM posters";
                $result = $con->query($sql);
                while($row = mysqli_fetch_array($result)) {
                    if (is_null($row["imagelink"])) {
                        //echo '<img src="img\LeadInstructor.png" alt="user no picture" style="width:193px;height:192px;float:left;">';
                        echo '<img src="img\Users\nophoto_user.png" class="img-circle" alt="user no picture" style="width:220px;height:220px;float:left;">';
                    }
                    else {
                        echo '<img src="img\Users\\' . $row["imagelink"] . '"class="img-circle" alt=' . $row["email"] . ' picture" style = "width:240px;height:220px;float:left">';
                    }
                    echo '<div style="float:initial;"> <strong>    ' . $row["fname"] . ' ' . $row["lname"] . '</strong> :<i> ' . $row["email"] . '</i>' ;
                    echo '<br>';
                    //echo '<div style="display:inline; white-space:nowrap; font-size:18px">';
                    echo '    <span style = "font-size: 20px !important;">' . $row["bioText"] . '</span></div>';
                    echo "<br><br><br><br><br><br><br><br><br><br>";
                } 
                
                mysqli_close($con);
                ?>         
            </div>
        </div>
    </section>

    <!-- Footer -->
    <footer class="text-center">
        <div class="footer-above">
            <div class="container">
                <div class="row"><commit_msg>updated database connections, imported tables from old db<commit_after><!DOCTYPE html>
<html lang="en">

<head>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="Looking to get chess involved in your school? Look no further, One Way Chess is your solution to high quality chess instruction at your school.  ">
    <meta name="author" content="One Way Chess">

    <title>Blog Posts</title>

    <!-- Bootstrap Core CSS - Uses Bootswatch Flatly Theme: http://bootswatch.com/flatly/ -->
    <link href="css/bootstrap.min.css" rel="stylesheet">
    <link href="css/contact-buttons.css" rel="stylesheet">


    <!-- Custom CSS -->
    <link href="css/freelancer.css" rel="stylesheet">
    <!-- <link href="css/clean-blog.min.css" rel="stylesheet">
    <link href="css/agency.css" rel="stylesheet"> -->

    <!-- Custom Fonts -->
    <link href="font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
    <link href="http://fonts.googleapis.com/css?family=Montserrat:400,700" rel="stylesheet" type="text/css">
    <link href="http://fonts.googleapis.com/css?family=Lato:400,700,400italic,700italic" rel="stylesheet" type="text/css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.2/jquery.min.js"></script>
    <script src="http://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
    <script src="js/submitpost.js"></script> 
    <script src = "http://ajax.googleapis.com/ajax/libs/angularjs/1.3.14/angular.min.js"></script>
    <script src="js/formjs.js"></script>
      
        <!-- Favicon --> 
        <link rel="shortcut icon" href="favicon.ico" /> 
    
        <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
        <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
        <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
    <![endif]-->
        <script src="../js/analytics.js"> </script>
</head>

<body id="page-top" class="index">
    <div id="fb-root"></div>
    <script>(function(d, s, id) {
      var js, fjs = d.getElementsByTagName(s)[0];
      if (d.getElementById(id)) return;
      js = d.createElement(s); js.id = id;
      js.src = "//connect.facebook.net/en_US/sdk.js#xfbml=1&version=v2.6";
      fjs.parentNode.insertBefore(js, fjs);
    }(document, 'script', 'facebook-jssdk'));
    </script>
    <!-- Navigation -->
    <nav class="navbar navbar-default navbar-fixed-top">
        <div class="container">
            <!-- Brand and toggle get grouped for better mobile display -->
            <div class="navbar-header page-scroll">
                <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
                    <span class="sr-only">Toggle navigation</span>
                    <span class="icon-bar"></span>
                    <span class="icon-bar"></span>
                    <span class="icon-bar"></span>
                </button>
                <a class="navbar-brand" href="../../schools/">One Way Chess Schools</a>
            </div>

            <!-- Collect the nav links, forms, and other content for toggling -->
            <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
                <ul class="nav navbar-nav navbar-right">
                    <li class="hidden">
                        <a href="#page-top"></a>
                    </li>
                    <li>
                        <a href="blog.php">Welcome</a>
                    </li>
                    <li> <a href="entries.php">Blog Entries</a> </li>
                    <li class="page-scroll">
                        <a href="writers.php">Writers</a>
                    </li>
                </ul>
            </div>
            <!-- /.navbar-collapse -->
        </div>
        <!-- /.container-fluid -->
    </nav>

    <!-- Header -->
    <header>
        <div class="container">
            <div class="row">
                <div class="col-lg-12">
                    <img class="img-responsive circle-crop" src="img/OneWayChessLogo.png" alt="">
                    <div class="intro-text">
                        <span class="name">One Way Chess</span>
                        <hr class="star-light">
                        <span class="skills">Coaching Advice, Training Tips, Chess Thoughts, simply anything and everything chess!</span>
                    </div>
                </div>
            </div>
        </div>
    </header>

<section class="success" id="writers">
        <div class="container">
            <div class="row">
                <div class="col-lg-12 text-center">
                    <h2>Writers</h2>
                    <hr class="star-light">
                </div>
            </div>
            <div class="row">
                <?php
                $url = parse_url(getenv("mysql://b0c4b9423d2803:48a9e62a@us-cdbr-iron-east-04.cleardb.net/heroku_1dd2b8ffb0f1998?reconnect=true"));

                            $server = $url["host"];
                            $username = $url["user"];
                            $password = $url["pass"];
                            $db = substr($url["path"], 1);
                            $con = new mysqli($server, $username, $password, $db);
                $sql = "SELECT email, fname, lname, bioText, position, imagelink FROM posters";
                $result = $con->query($sql);
                while($row = mysqli_fetch_array($result)) {
                    if (is_null($row["imagelink"])) {
                        //echo '<img src="img\LeadInstructor.png" alt="user no picture" style="width:193px;height:192px;float:left;">';
                        echo '<img src="img\Users\nophoto_user.png" class="img-circle" alt="user no picture" style="width:220px;height:220px;float:left;">';
                    }
                    else {
                        echo '<img src="img\Users\\' . $row["imagelink"] . '"class="img-circle" alt=' . $row["email"] . ' picture" style = "width:240px;height:220px;float:left">';
                    }
                    echo '<div style="float:initial;"> <strong>    ' . $row["fname"] . ' ' . $row["lname"] . '</strong> :<i> ' . $row["email"] . '</i>' ;
                    echo '<br>';
                    //echo '<div style="display:inline; white-space:nowrap; font-size:18px">';
                    echo '    <span style = "font-size: 20px !important;">' . $row["bioText"] . '</span></div>';
                    echo "<br><br><br><br><br><br><br><br><br><br>";
                } 
                
                mysqli_close($con);
                ?>         
            </div>
        </div>
    </section>

    <!-- Footer -->
    <footer class="text-center">
        <div class="footer-above">
            <div class="container">
                <div class="row">
{'fraction_non_alphanumeric': 0.17686684821556542, 'fraction_numerical': 0.013114519134298409, 'mean_word_length': 1.8555350931041539, 'pattern_counts': {'":': 0, '<': 307, '<?xml version=': 0, '>': 311, 'https://': 6, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 1, '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': '3890995', 'n_tokens_mistral': 4390, 'n_tokens_neox': 4051, 'n_words': 810}