<commit_before><!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <script type="text/javascript" src="scripts/jq/jquery-3.1.1.js"></script>
    <script type="text/javascript" src="scripts/script.js"></script>
    <link rel="stylesheet" href="styles/style.css" />
    <link rel="stylesheet" href="styles/extend.css" />
    <link rel="shortcut icon" type="image/png" href="images/persistent-favicon.png"/>
    <title>eWaste Management App</title>
    <!-- script>
    function updateMerchantStats() {
        var x = document.getElementById("city").value;
        document.getElementById("ttl-merchant").innerHTML = "2"; /*put total machants found here*/
        /* document.getelementbyclass("volunteer-status").*  change the table contents here*/
    }
    </script-->
</head>
<body>
    <header>
        <img src="images/BackgoundEcoEnvcrop.jpg" alt="BackgoundEcoEnvcrop">
        <h3 class="title">Merchant Weight Status</h3>
    </header>
    <div id="merchant-status">
    <form action="recycler-merchant-status.php" id="recycler-city">
        <div id="label_input">  
            <label for="city">City</label> 
            <select name="city" id="city">
            <input type="submit" value="Submit" class="blue-right-btn">
<?php
// Read MySQL credentials from VCAP services and formatting
$vcap_services = json_decode ( $_ENV ["VCAP_SERVICES"] );
$db = $vcap_services->{"compose-for-mysql"} [0]->credentials;
$temp = explode ( '@', $db->uri );
$mysql_cred = explode ( ':', $temp [0] );
$mysql_db = explode ( '/', $temp [1] );

// Create DB connection
$mysqli = new mysqli ( $mysql_db [0], ltrim ( $mysql_cred [1], "/" ), $mysql_cred [2], $mysql_db [1] );

// Check DB connection
if ($mysqli->connect_error) {
    die ( "Connection failed: " . $mysqli->connect_error );
}

// To update insert query from form
$sql = "select distinct city from ewaste_user where _role = 'volunteer'";
$result = $mysqli->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo '<option value="' . $row['city']. '">' . $row['city']. '</option>';
    }
}
$mysqli->close ();
?>            
            </select>
        </div><commit_msg>fix submit button<commit_after><!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <script type="text/javascript" src="scripts/jq/jquery-3.1.1.js"></script>
    <script type="text/javascript" src="scripts/script.js"></script>
    <link rel="stylesheet" href="styles/style.css" />
    <link rel="stylesheet" href="styles/extend.css" />
    <link rel="shortcut icon" type="image/png" href="images/persistent-favicon.png"/>
    <title>eWaste Management App</title>
    <!-- script>
    function updateMerchantStats() {
        var x = document.getElementById("city").value;
        document.getElementById("ttl-merchant").innerHTML = "2"; /*put total machants found here*/
        /* document.getelementbyclass("volunteer-status").*  change the table contents here*/
    }
    </script-->
</head>
<body>
    <header>
        <img src="images/BackgoundEcoEnvcrop.jpg" alt="BackgoundEcoEnvcrop">
        <h3 class="title">Merchant Weight Status</h3>
    </header>
    <div id="merchant-status">
    <form action="recycler-merchant-status.php" id="recycler-city">
        <div id="label_input">  
            <label for="city">City</label> 
            <select name="city" id="city">
            
<?php
// Read MySQL credentials from VCAP services and formatting
$vcap_services = json_decode ( $_ENV ["VCAP_SERVICES"] );
$db = $vcap_services->{"compose-for-mysql"} [0]->credentials;
$temp = explode ( '@', $db->uri );
$mysql_cred = explode ( ':', $temp [0] );
$mysql_db = explode ( '/', $temp [1] );

// Create DB connection
$mysqli = new mysqli ( $mysql_db [0], ltrim ( $mysql_cred [1], "/" ), $mysql_cred [2], $mysql_db [1] );

// Check DB connection
if ($mysqli->connect_error) {
    die ( "Connection failed: " . $mysqli->connect_error );
}

// To update insert query from form
$sql = "select distinct city from ewaste_user where _role = 'volunteer'";
$result = $mysqli->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo '<option value="' . $row['city']. '">' . $row['city']. '</option>';
    }
}
$mysqli->close ();
?>            
            </select>
        </div>            
<?php
$_id = $_GET['_id'];
echo '<input type="hidden" name="_id" id="_id" value=" ' . $_id . '">'
?>            
        <input type="submit" value="Submit" class="blue-right-btn">
{'fraction_non_alphanumeric': 0.19131762652705062, 'fraction_numerical': 0.006544502617801047, 'mean_word_length': 3.3418560606060606, 'pattern_counts': {'":': 0, '<': 73, '<?xml version=': 0, '>': 93, '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': '5189424', 'n_tokens_mistral': 1525, 'n_tokens_neox': 1498, 'n_words': 325}