Example #1
0
function connectToDB()
{
    $dbPath = "http://linus.highpoint.edu";
    $dbUser = "******";
    $dbPass = "******";
    $dbName = "csc2210_alouzao_db";
    $dbconn = new mysqli($dbPath, $dbUser, $dbPass);
    logMsg("Connecting to {$dbPath} with user {$dbUser}");
    if (!$dbconn) {
        logMsg('Connect Error (' . mysqli_connect_errno() . ')' . mysqli_connect_error());
        logMsgAndDie("Error Connecting to {$dbPath} with user {$dbUser}");
    }
    if (!$dbconn->select_db($dbName)) {
        logMsgAndDie("Could not select {$dbName} database");
    }
    return $dbconn;
}
Example #2
0
<?php

#include utility.php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $fname = cleanInput($_POST["fname"]);
    $lname = cleanInput($_POST["lname"]);
    $dobM = cleanInput($_POST["dobM"]);
    $dobD = cleanInput($_POST["dobD"]);
    $dobY = cleanInput($_POST["dobY"]);
    $email = cleanInput($_POST["email"]);
    $pass = cleanInput($_POST["pass"]);
    error_log("Processing: {$fname} {$lname}");
    logMsg('Storing Data:' . $fname);
    $dbconn = connectToDB();
    $query = "insert into logIn_PingIt (first, last, dobM, dobD, dobY, email, pass) values ('\${$fname}', '{$lname}', '{$dobM}', '{$dobD}', '{$dobY}', '{$email}', '{$pass}');";
    logMsg($query);
    $result = $dbconn->query($query);
    if (!$result) {
        logMsgAndDie('Error loading data!!!!');
    } else {
        logMsg('Good data load!');
    }
    disconnectDB($dbconn);
}