PHP snapCreateDbConnect Examples

Example #1

File: passwordreset.php Project: rohit-kadam/Demos

                        $err .= "<p>Your password reset link is already used.</p>";
                    }
                }
            }
        }
    }
    $err .= "</div>";
    echo $err;
    exit;
}
//empty request params
if (empty($userid) || empty($uniqid)) {
    sendError(1);
}
//db connect failed
$snapDbConn = snapCreateDbConnect('snapdb');
if (!$snapDbConn) {
    sendError(2);
}
//check uniqid comparison
$query = "select id,userid,username,email,linktime,verifyid,linktype,linkstatus from snap_linktrack where userid = ? and linktype = 'resetpassword' order by id desc limit 1";
$arrParams = array('s', &$userid);
$result = snapDbQuery($snapDbConn, $query, $arrParams);
if (!isset($result['rows'])) {
    sendError(1);
}
$linkid = $result['rows'][0]->id;
$userid = $result['rows'][0]->userid;
$username = $result['rows'][0]->username;
$email = $result['rows'][0]->email;
$linktime = $result['rows'][0]->linktime;

Example #2

File: controller.php Project: rohit-kadam/Demos

     snapSendResponse($resp);
     break;
 case 'snapSavePassword':
     $resp = snapSavePassword($snapDbConn, $data);
     snapSendResponse($resp);
     break;
 case 'snapSendVerificationEmailLink':
     $resp = snapSendVerificationEmailLink($snapDbConn);
     snapSendResponse($resp);
     break;
 case 'snapSendFeedback':
     $resp = snapSendFeedback($snapDbConn, $data);
     snapSendResponse($resp);
     break;
 case 'snapGetPreviousChatMessages':
     $tigaseDbConn = snapCreateDbConnect('tigasedb');
     if (!$tigaseDbConn) {
         $resp = array('type' => 'failed', 'descr' => $APPCONFIG['ERROR'][102]);
         snapSendResponse($resp);
         return;
     }
     $resp = snapGetPreviousChatMessages($tigaseDbConn, $data);
     snapSendResponse($resp);
     break;
 case 'snapModifyPassword':
     $resp = snapModifyPassword($snapDbConn, $data);
     snapSendResponse($resp);
     break;
 case 'snapModifyNickname':
     $resp = snapModifyNickname($snapDbConn, $data);
     snapSendResponse($resp);