function readCSVfile($filename) { $column = array(); $file = fopen($filename, "r"); $i = 0; while (!feof($file)) { global $column; $column[$i] = fgetcsv($file); $i++; } $i = 0; foreach ($column as $array) { # code... if ($i != 0) { insertIntoDatabase($string, $array); $i++; } else { setColumnNames($string, $array); $i++; } } }
$query .= " VALUES (?, ?, ?, ?, ?, ?)"; confirm_query($query); /* create a prepared statement */ if ($stmt = $connection->prepare($query)) { global $firstname, $lastname, $orgname, $email, $password, $user_role; /* bind parameters for markers */ $stmt->bind_param("ssssss", $firstname, $lastname, $orgname, $email, $password, $user_role); /* execute query */ if ($stmt->execute()) { echo "successfully executed"; } else { echo "Failed to execute" . $connection->error; } } } insertIntoDatabase(); } ?> <br> <form id="register-form" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]); ?> " method="post" style="margin:0px auto;width:800px"> <div class="form-group"> <h4>Register As:</h4> <select id="selectBox" name="selectuser" class="form-control input-lg" placeholder="-- SELECT --"> <option value="normaluser">Normal User</option> <option value="organizer">Organizer</option> </select> </div>
} } // SUBMIT BUTTON PRESSED if (!empty($_POST)) { // database connection include_once "config.php"; require_once 'php/databaseConnection.php'; //check to see if ip hasn't submitted too many times today $ip = dailyLimit($con); //remove excess space from before first word and after last word before we start anything $t = trim($_POST['thing']); //take out html or php tags $t = strip_tags($t, ''); // go through different filters based on submission type if (isset($_POST['choose']) and $_POST['choose'] !== "") { $choose = $_POST['choose']; // things to do and suggestions for the site need filters if ($choose === "things" or $choose === "suggestions") { //check for filtered words $reason = filteredWords($t); $t = replaceText($t); } else { if ($choose !== "spam") { exit; } } insertIntoDatabase($t, $choose, $ip, $con); } // end type filters } //end submission post
function getDataSince($timestamp, $eggid, $identifier) { global $chemical_weights; // database date format: Y-m-d\TH:i:s // http://www.lanuv.nrw.de/luft/temes/0326/VMS2.htm // http://www.lanuv.nrw.de/luft/temes/0326/MSGE.htm $day = date("md", $timestamp); echo "Fetch " . $day . "<br>"; $url = "http://www.lanuv.nrw.de/luft/temes/" . $day . "/" . $identifier . ".htm"; $content = file_get_contents($url); $dom = new DOMDocument(); @$dom->loadHTML($content); // suppress parsing/invalid html errors $table = $dom->getElementsByTagName('table')->item(0); // first table = data value table $tbody = $table->getElementsByTagName('tbody')->item(0); $rows = $tbody->getElementsByTagName('tr'); for ($i = 0; $i < $rows->length; $i++) { $cols = $rows->item($i)->getElementsByTagName('td'); if (!$cols->item(1)) { } else { // skip rows with less than two columns $time = trim(utf8_decode($cols->item(0)->nodeValue)); $datetime = date("Y-m-d", $timestamp) . " " . $time; $ozon = trim(utf8_decode($cols->item(3)->nodeValue)); if ($ozon != "") { insertIntoDatabase($eggid, "o3", microgramPerMeterToPPB($ozon, $chemical_weights["o3"]), $datetime); } $no2 = trim(utf8_decode($cols->item(4)->nodeValue)); if ($no2 != "") { insertIntoDatabase($eggid, "no2", microgramPerMeterToPPB($no2, $chemical_weights["no2"]), $datetime); } echo $datetime . " " . $ozon . " " . $no2 . "<br>"; } } }
// create 2 tables $sql = "SHOW TABLES LIKE meaning"; if (!mysqli_query($link, $sql)) { $sql = "CREATE TABLE meaning (tag int(4) unsigned NOT NULL, satMeaning TEXT NOT NULL)"; if (mysqli_query($link, $sql)) { insertIntoDatabase($dict, "meaning", $link); // echo "Table 'meaning' created successfully"; } else { // echo "Error creating table: " . mysqli_error($link); } } $sql = "SHOW TABLES LIKE word"; if (!mysqli_query($link, $sql)) { $sql = "CREATE TABLE word (tag int(4) unsigned NOT NULL, satWord varchar(20) NOT NULL)"; if (mysqli_query($link, $sql)) { insertIntoDatabase($dict, "word", $link); // echo mysqli_query($link, $sql); // echo "Table 'word' created successfully"; } else { // echo "Error creating table: " . mysqli_error($link); } } $satWordArr = array(); $satMeaningArr = array(); $sql = "SELECT tag, satWord FROM word"; $result = mysqli_query($link, $sql); if (mysqli_num_rows($result) > 0) { // output data of each row while ($row = mysqli_fetch_assoc($result)) { $satWordArr[$row["tag"]] = $row["satWord"]; }
function parseEntry($entry) { $entry['EditXML'] = destringify($entry['EditXML']); $xml = gzuncompress($entry['EditXML']); $xml = new SimpleXMLElement($xml); //print_r( $xml ); insertIntoDatabase($entry['EditSource'], $entry['IsVandalism'], $xml); }
if ($cosmdata = fetchJsonFromCosm($row["cosmid"], $stream, $start)) { echo "JSON Download: <b>" . $start . "</b> - <b>" . $end . "</b><br>" . PHP_EOL; if (!isset($cosmdata['datapoints'])) { // if there are no datapoints and it's not "today", // then there's likely a data gap = no data from cosm for this day // guess where the next data could be by querying every day until today, or until data found $i = 0; while (!isset($cosmdata_['datapoints'])) { $newstart = date("Y-m-d\\TH:i:s", strtotime($start) + 3600 * 24 * $i); $newend = date("Y-m-d\\TH:i:s", strtotime($newstart) + 3600 * 24); // +1 day echo $i . ": " . $newstart . " - " . $newend . "<br>"; $i++; flush(); if (strtotime($newstart) > time()) { break; } $cosmdata_ = fetchJsonFromCosm($row["cosmid"], $stream, $newstart); } $cosmdata = $cosmdata_; } foreach ($cosmdata['datapoints'] as $datapoint) { insertIntoDatabase($row['eggid'], $stream, $datapoint['value'], $datapoint['at']); } } else { echo "Cosm API error." . PHP_EOL; } echo "<hr>"; } } pg_close($dbconn);