PHP SocialWorkerDetailsAccess::load_clients_by_sw_phone_number Examples

Example #1

File: mobile_app_api_controller.php Project: HackathonPaypal/PCVC-Organization

 public function load_clients_by_sw_details_phone_number($phone_number)
 {
     //Establish mysqli connection
     $mysqli_connection = new mysqli(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE);
     if ($mysqli_connection->connect_errno) {
         echo "Failed to connect to MySQL: (" . $mysqli_connection->connect_errno . ") " . $mysqli_connection->connect_error;
         $sw_details = array("Error" => "Database error occured", "status" => "false");
         return $sw_details;
     }
     //Set auto-commit to FALSE explicitly
     if (!$mysqli_connection->autocommit(FALSE)) {
         return;
     }
     $access = new SocialWorkerDetailsAccess($mysqli_connection);
     $sw_details = $access->load_clients_by_sw_phone_number($phone_number);
     //Validate whether order loading is successful or not.
     if ($access->m_status == false || $access->m_status_code == STATUS_FETCH_NO_DATA) {
         //Close the connection
         $mysqli_connection->close();
     }
     return $sw_details;
 }