X-Git-Url: http://git.pjr.cc/?p=ga4php.git;a=blobdiff_plain;f=example%2Fsimple%2Fextend.php;fp=example%2Fsimple%2Fextend.php;h=f50595daf1c108999a1ae230f5cb57f8afc3bd93;hp=0000000000000000000000000000000000000000;hb=195c42d5711d000a987ed3a0a376ac09b98867fc;hpb=925e8f408e16294f55bffbdfc12ab4fbd7cc41ed diff --git a/example/simple/extend.php b/example/simple/extend.php new file mode 100644 index 0000000..f50595d --- /dev/null +++ b/example/simple/extend.php @@ -0,0 +1,109 @@ +query($sql); + + // check the result + if(!$result) return false; + + // now just retreieve all the data (there should only be one, but whatever) + $tokendata = false; + foreach($result as $row) { + $tokendata = $row["tokendata"]; + } + + // now we have our data, we just return it. If we got no data + // we'll just return false by default + return $tokendata; + + // and there you have it, simple eh? + } + + + // now we need a function for putting the data back into our user table. + // in this example, we wont check anything, we'll just overwrite it. + function putData($username, $data) { + // get our database connection + $dbObject = GetDatabase(); + + // set the sql for updating the data + // token data is stored as a base64 encoded string, it should + // not need to be escaped in any way prior to storing in a database + // but feel free to call your databases "addslashes" (or whatever) + // function on $data prior to doing the SQL. + $sql = "update users set tokendata='$data' where username='$username'" + + // now execute the sql and return straight away - you should probably + // clean up after yourselves, but im going to assume pdo does this + // for us anyway in this exmaple + if($dbObject->query($sql)) { + return true; + } else { + return false; + } + + // even simpler! + } + + // the get users method isnt actually used within the google authenticator + // class as yet, but it probably will in the future, so feel free to implement it + function getUsers() { + // get our database connection + $dbObject = GetDatabase(); + + // now the sql again + $sql = "select username from users"; + + // run the query + $result = $dbObject->query($sql); + + // iterate over the results - we expect a simple array containing + // a list of usernames + $i = 0; + $users = array(); + foreach($result as $row) { + $users[$i] = $row["username"]; + $i++; + } + + // now return the list + return $users; + } +} + +// and thats it... +?> \ No newline at end of file