*/ if (strlen($d) == 1) { $d = 0 . $d; } $date = $y . "-" . $m . "-" . $d; if ($sampm == "PM") { $sh = $sh + 12; } $st = $sh . ":" . $sm; if ($eampm == "PM") { $eh = $eh + 12; } $et = $eh . ":" . $em; $endDate = $date . "T" . $et . ":00"; $date = $date . "T" . $st . ":00"; $code = randomCodeGenerator(25); $sql = "select ID From K12_TEACHER where Email = '" . $_SESSION['email'] . "'"; $result = mysqli_query($con, $sql) or die(mysqli_error($con)); $tid = mysqli_fetch_array($result); $sql = "call K12_EVENTS_INSERTEVENT('" . $t . "', '" . $date . "', '" . $endDate . "', '" . $tid[0] . "', '" . $code . "', '" . $desc . "')"; // may want to use an autoincrement value for the eventID rather than randomly generated code $result = mysqli_query($con, $sql) or die(mysqli_error($con)); //a non-select statement query will return a result indicating if the if ($result) { $msg = "<b>Your information is entered into the database. </b>"; } } ?> <style>
//$sql = "select count(*) as c from K12_TEACHER where Email = '" . $em. "'"; $sql = "call K12_TEACHER_COUNTFORREGISTRATION('" . $em . "');"; // use stored procedure //$sql = "call K12_TEACHER_COUNTFORREGISTRATION($em)"; // use stored procedure $result = mysqli_query($con, $sql) or die("Error in the consult.." . mysqli_error($con)); //send the query to the database or quit if cannot connect $count = 0; $field = mysqli_fetch_object($result); //the query results are objects, in this case, one object $count = $field->c; $result->close(); $con->next_result(); if ($count != 0) { Header("Location:login.php"); } else { $code = randomCodeGenerator(50); //$sql = "insert into K12_TEACHER values('', '".$em."', '".$fn."', '".$ln."', '".$s."', '".$e."', '".$b."', '".$pw."', 'no', '".$code."', '3')"; $sql = "call K12_TEACHER_INSERTNEWTEACHER('" . $em . "', '" . $fn . "', '" . $ln . "', '" . $s . "', '" . $e . "', '" . $b . "', '" . $pw . "', 'no', '" . $code . "');"; // stored procedure $result = mysqli_query($con, $sql) or die(mysqli_error($con)); //a non-select statement query will return a result indicating if the if ($result) { $msg = "<b>Your information is entered into the database. </b>"; } //direct to the next page if necessary //If all fields are valid, a random code is generated and emailed to the user's given email. $subject = "Email Activation"; $body = "Your code is " . $code . "<br /><br />Please finish registration by inputting your code at http://corsair.cs.iupui.edu:20741/studentOutreach/activation.php?c=" . $code; $mailer = new Mail(); if ($mailer->sendMail($em, $fn, $subject, $body) == true) { //This essentially logs the user in by telling the session the email of the user.