PHP changeDateFormatToDB Examples

Example #1

File: facebooklogin_model.php Project: CCNITSilchar/Social-Login-Plugin

 private function AddNewUser()
 {
     $session = Session::get('fb_session');
     $user = (new FacebookRequest($session, 'GET', '/me'))->execute()->getGraphObject(GraphUser::className());
     $user_pic = (new FacebookRequest($session, 'GET', '/me/picture', array('redirect' => false, 'height' => '480', 'width' => '480')))->execute()->getGraphObject(GraphUser::className());
     $uid = $this->db->real_escape_string($user->getProperty("id"));
     $first_name = $this->db->real_escape_string($user->getProperty("first_name"));
     $last_name = $this->db->real_escape_string($user->getProperty("last_name"));
     $email = $this->db->real_escape_string($user->getProperty("email"));
     $name = $this->db->real_escape_string($user->getProperty("name"));
     $gender = $this->db->real_escape_string($user->getProperty("gender"));
     $dob = $this->db->real_escape_string(changeDateFormatToDB($user->getProperty("birthday")));
     $dos = date("Y-m-d");
     $profile_pic_link = $this->db->real_escape_string($user_pic->getProperty("url"));
     $query = "INSERT INTO " . DB_TABLE . " (uid,email,first_name,last_name,name,gender,dob,dos,profile_pic_link) \n                                     VALUES ('" . $uid . "','" . $email . "','" . $first_name . "','" . $last_name . "','" . $name . "','" . $gender . "','" . $dob . "','" . $dos . "','" . $profile_pic_link . "')";
     $result = $this->db->query($query);
     if ($this->db->affected_rows) {
         $this->Attempt();
     }
 }

Example #2

File: set_last_date.php Project: mkrdip/Management-Information-System

<?php

require_once '../core/init.php';
if (privilege() == NULL) {
    die;
}
if (Input::exists('post')) {
    $validate = new Validate();
    $validation = $validate->check($_POST, array('examtype' => array('required' => true), 'lastdate' => array('required' => true)));
    if ($validate->passed()) {
        $dep = new Marks();
        $date = changeDateFormatToDB(Input::get('lastdate'));
        $setDate = $dep->setLastDate(Input::get('examtype'), $date);
        if ($setDate == 3) {
            echo '<div class="alert alert-danger alert-dismissible" role="alert">';
            echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>';
            echo 'Sorry, you don\'t have privilege to set Last date for examination.';
            echo '</div>';
        } else {
            if ($setDate == 1) {
                echo '<div class="alert alert-success alert-dismissible" role="alert">';
                echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>';
                echo 'Last date saved successfully.';
                echo '</div>';
            } else {
                if ($setDate == 0) {
                    echo '<div class="alert alert-danger alert-dismissible" role="alert">';
                    echo '<button type="button" class="close" data-dismiss="alert"><span aria-hidden="true">&times;</span><span class="sr-only">Close</span></button>';
                    echo 'Temporary Error!';
                    echo '</div>';
                } else {