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; }
<?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); }