function displayMessage()
{
$conn = connectToDatabase();
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$table = $_POST['table'];
$id = $_POST['id'];
// Send the update query, check to see if the update was successful.
$columnNames = getColumnNames($table);
$columns = array();
// Array that holds the column names of the values to be inserted.
$values = array();
// Array that holds the values to be inserted.
for ($i = 1; $i < count($columnNames); $i++) {
if (isset($_POST[$columnNames[$i]])) {
$value = trim($_POST[$columnNames[$i]]);
if ($value != "") {
array_push($columns, $columnNames[$i]);
array_push($values, $value);
}
}
}
$query = "UPDATE {$table} SET ";
if (count($columns) == count($values)) {
for ($i = 0; $i < count($values); $i++) {
$query .= "{$columns[$i]} = " . "'" . $values[$i] . "'";
if ($i + 1 < count($columns)) {
$query .= ", ";
}
}
}
$query .= " WHERE " . $_POST['id_column'] . " = " . $_POST['id'];
//echo $query;
if (mysqli_query($conn, $query) == TRUE and count($values) > 0) {
$result = retrieveRow($table, $id);
echo "<p>The " . $_POST['table'] . " has been updated to</p>";
echo "<table class='updated'>";
if (count($columnNames) > 0 and $result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
if (count($row) == count($columnNames)) {
for ($i = 0; $i < count($row); $i++) {
echo "<tr>";
echo "<td><b>" . $columnNames[$i] . "</b></td>";
echo "<td>" . $row[$columnNames[$i]] . "</td>";
echo "</tr>";
}
}
}
} else {
echo "0 results";
}
echo "</table>";
echo "<form action='runAudit.php' method='post'>\n <input type='hidden' name='bowlingAudit' value='" . $_POST['table'] . "'>\n <input type='submit' value='Back to table'>\n </form>";
} else {
if (count($values) < 1) {
$error = "<br>No fields have been updated.";
echo $error;
echo "<br><br><form action='runAudit.php' method='post'>\n <input type='hidden' name='bowlingAudit' value='" . $_POST['table'] . "'>\n <input type='submit' value='Back to table'>\n </form>";
} else {
$error = "Unable to update.\n\nError: " . $conn->error;
//echo $error;
$error = json_encode($error);
echo "\n <script type='text/javascript'>\n alert({$error});\n history.go(-1);\n </script>";
}
}
$conn->close();
}
function displayMessage()
{
$conn = connectToDatabase();
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$table = $_POST['table'];
// Send the update query, check to see if the update was successful.
$columnNames = getColumnNames($table);
//INSERT INTO bowling.Ball (Color, Weight, Size) VALUES ('Black', 7, 2);
$query = "INSERT INTO bowling.{$table} (";
$columns = array();
// Array that holds column names of the values to be inserted
$values = array();
// Array that holds values to be inserted
for ($i = 1; $i < count($columnNames); $i++) {
if ($columnNames[$i] == "Date_Added" || $columnNames[$i] == "Last_Date_Modified" || $columnNames[$i] == "Date_Joined" || $columnNames[$i] == "Date_Deleted") {
continue;
} else {
if ($_POST[$columnNames[$i]] == "") {
continue;
} else {
array_push($columns, $columnNames[$i]);
array_push($values, $_POST[$columnNames[$i]]);
}
}
}
for ($i = 0; $i < count($columns); $i++) {
$query .= "{$columns[$i]}";
if ($i + 1 < count($columns)) {
$query .= ", ";
}
}
$query .= ") VALUES (";
for ($i = 0; $i < count($values); $i++) {
$query .= "'" . $values[$i] . "'";
if ($i + 1 < count($values)) {
$query .= ", ";
}
}
$query .= ");";
//echo $query;
if (mysqli_query($conn, $query) == TRUE) {
$id = $conn->insert_id;
$result = retrieveRow($table, $id, $columnNames[0]);
echo "<p>A new " . $_POST['table'] . " has been added with the following values </p>";
echo "<table>";
if (count($columnNames) > 0 and $result->num_rows > 0) {
while ($row = $result->fetch_assoc()) {
if (count($row) == count($columnNames)) {
for ($i = 0; $i < count($row); $i++) {
echo "<tr>";
echo "<td><b>" . $columnNames[$i] . "</b></td>";
echo "<td>" . $row[$columnNames[$i]] . "</td>";
echo "</tr>";
}
}
}
} else {
echo "0 results";
}
echo "</table>";
echo "<form action='runAudit.php' method='post'>\n <input type='hidden' name='bowlingAudit' value='" . $_POST['table'] . "'>\n <input type='submit' value='Back to table'>\n </form>";
} else {
$error = "<br>Unable to update. Error: " . $conn->error;
echo $error . "<br><br>";
echo "<form action='runAudit.php' method='post'>\n <input type='hidden' name='bowlingAudit' value='" . $_POST['table'] . "'>\n <input type='submit' value='Back to table'>\n </form>";
}
$conn->close();
}
