Advertisement
Guest User

Untitled

a guest
May 24th, 2015
221
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. function addWarranty($name, $startTime, $warrantyPeriod, $description, $endTime) {
  2. $mysqli = new mysqli(DATABASE_URL,DATABASE_LOGIN, DATABASE_PASSWORD, DATABASE_NAME);
  3. if($mysqli->connect_errno) {
  4. printf("Connect failed: %s\n", $mysqli->connect_error);
  5. exit();
  6. }
  7. if (!isUserLogged()) {
  8. return;
  9. }
  10. if (preg_match(PATTERN_NAME, $name) == 0) {
  11. return "error";
  12. }
  13. $date = date("Y-m-d");
  14. if ($endTime == "") {
  15. $endTime = date("Y-m-d", strtotime($startTime. '+' .$warrantyPeriod. 'days'));
  16. }
  17. else {
  18. $dateDiff = strtotime($endTime) - strtotime($startTime);
  19. $warrantyPeriod = floor($dateDiff/(86400));
  20. }
  21. $query = "INSERT INTO tblwarranty (`name`, `StartTime`, `WarrantyPeriod`, `EndTime`, `description`, `u_id`, `DateAdded`) VALUES (?,?,?,?,?,?,?)";
  22. $stmt = $mysqli ->prepare($query);
  23. $stmt->bind_param("ssissis", $name, $startTime, $warrantyPeriod, $endTime, $description, $_SESSION['id'], $date);
  24. $stmt->execute();
  25. $stmt->close();
  26. return "$name,$startTime,$endTime,$description,$mysqli->insert_id,$date";
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement