Beispiel #1
0
<?php

/*
php test file -- connects to xampp db names sousms, user root, pw ""
*/
include "DbConn.class.php";
try {
    // connect to the database -- needed by the classes
    // that implement the behaviors
    $conn = new DbConn("localhost", "sousms", "root", "");
} catch (Exception $e) {
    // add another element
    echo "Exception: " . $conn->getDebug() . "<br />" . "\n";
}
//	echo "No Exception: " . $conn->getDebug() . "<br />". "\n";
$myConn = $conn->getConn();
$dtb = new DateTime(null, new DateTimeZone("America/Los_Angeles"));
$dte = new DateTime(null, new DateTimeZone("America/Los_Angeles"));
$dte->modify("+10 minutes");
echo "\$dte->format() " . $dte->format("Y-m-d H:i:s") . "\n";
$stmt = $myConn->prepare("insert Login values (1, md5('password'), ?, ?)");
$stmt->execute(array($dtb->format("Y-m-d H:i:s"), $dte->format("Y-m-d H:i:s")));
Beispiel #2
0
 $msg = new WebServiceMsg();
 $msg->behavior = $req->behavior;
 // assume the worst
 $msg->success = false;
 $msg->statuscode = 1;
 $msg->statusdesc = array();
 $msg->retval = array();
 try {
     // connect to the database -- needed by the classes
     // that implement the behaviors
     $myConn = new DbConn();
 } catch (Exception $e) {
     // add an element to the statusdesc array
     $msg->statusdesc[] = "Validation Failure: " . $e->getMessage();
     // add another element
     $msg->statusdesc[] = $myConn->getDebug();
 }
 switch ($req->behavior) {
     case "getTokenFromCredentials":
         // the constructor for Credentials can do some basic validation
         // (or throw an exception)
         $credentials = new Credentials($req->credentials->username, $req->credentials->password);
         $token = null;
         $expires = null;
         // the validate() method returns true if valid or false
         // token, expires, and msg->statusdesc are all passed
         // by reference and set inside validate()
         if (!$credentials->validate($myConn->getConn(), $token, $expires, $msg->statusdesc)) {
             // captures the reason for failure
             $msg->statuscode = 1;
             // failed