/**
* queries the database and returns the result
*/
function query($stuff)
{
if (server_type == "mysql") {
return mysql_query($stuff);
} elseif (server_type == "postgresql") {
return pq_query($stuff);
}
}
echo "<td><b>Alt DB Lat Name</b></td>";
echo "<td><b>Neu DB Lat Name</b></td>";
echo "<td><b>Neu DB organsim ID</b></td>";
echo "</tr>";
$error_count = 0;
$succes_count = 0;
foreach ($data_new as $row) {
$res2 = pg_query($olddb, "select o.name_de, o.id, o.name_sc, it.name artgruppe from organism as o\n\t\t\tjoin inventory_type as it on it.id=o.inventory_type_id\n\t\t\twhere o.name_sc = '" . pg_escape_string($row['name']) . "'\n\t\t\t");
$data_temp = pg_fetch_array($res2);
if (!$data_temp['name_sc']) {
$color = ' bgcolor="#FAA7F8"';
$error_count++;
} else {
$color = ' bgcolor="#D4FBCE"';
$succes_count++;
pq_query($newdb, "insert");
}
echo "\n\t<tr" . $color . ">";
echo "<td>" . $data_temp['artgruppe'] . "</td>";
echo "<td>" . $data_temp['id'] . "</td>";
echo "<td>" . $data_temp['name_sc'] . "</td>";
echo "<td>" . $row['name'] . "</td>";
echo "<td>" . $row['organism_id'] . "</td>";
echo "</tr>";
}
echo "</table>";
echo "Error Count: " . $error_count;
echo "<br>Success Count: " . $succes_count;
// print_r($data_zuweisung);
pg_close($olddb);
pg_close($newdb);
}
if ($row = pg_fetch_row($select)) {
if (isset($_POST["deleteMem"])) {
$id = $_POST["id"];
$delete = pg_query($db, "DELETE FROM members WHERE id={$id}");
$select = pg_query($db, "SELECT member_id FROM taskelementcomments where member_id={$id}");
if ($row = pg_fetch_row($select)) {
$delete = pq_query($db, "DELETE FROM taskelementcomments WHERE member_id={$id}");
}
$select = pg_query($db, "SELECT member_id FROM taskelementmembers where member_id={$id}");
if ($row = pg_fetch_row($select)) {
$delete = pq_query($db, "DELETE FROM taskelementmembers WHERE member_id={$id}");
}
$select = pg_query($db, "SELECT member_id FROM taskmembers where member_id={$id}");
if ($row = pg_fetch_row($select)) {
$delete = pq_query($db, "DELETE FROM taskmembers WHERE member_id={$id}");
}
$editmsg = "Member deleted";
}
if (isset($_POST["editLink"])) {
$editemail = $_POST["editemail"];
$editfname = $_POST["editfname"];
$editsname = $_POST["editsname"];
$editpass = $_POST["editpass"];
$id = $_POST["id"];
$editcheck = 0;
$check = 0;
if (filter_var($editemail, FILTER_VALIDATE_EMAIL) !== false && preg_match("[a-zA-Z- ]", $editfname) !== false && preg_match("[a-zA-Z- ]", $editsname) !== false && preg_match("[a-zA-Z0-9@#\$%^&*_-!?<>]", $editpass) !== false) {
$filtemail = pg_escape_literal($editemail);
$filtfirstname = pg_escape_literal($editfname);
$filtsurname = pg_escape_literal($editsname);
<!--
// Add user to database
-->
<?php
include 'dbvars.php';
include 'connect.php';
if (isset($_POST['username']) && isset($_POST['email'])) {
$username = $_POST['username'];
$email = $_POST['email'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$gender = $_POST['gender'];
$age = $_POST['age'];
$location = $_POST['location'];
$education = $_POST['education'];
$query = "INSERT INTO `user` (username, firstname, lastname, email, gender, age, location, education) VALUES ('{$username}', '{$firstname}', '{$lastname}', '{$email}', '{$gender}', '{$age}', '{$location}', '{$education}')";
$result = pq_query($conn, $query);
if ($result) {
$msg = "User Created Successfully.";
}
}
// }
