You can store $tok['oauth_token'] & $tok
['oauth_token_secret'] when the state=="return".
Both of this represent like username and password
On Jun 22, 1:18 pm, DevinPitcher <devinpitc...@gmail.com> wrote:
> <?php session_start();
> include("../../../settings/mysql.php");
> require_once('twitterOAuth.php');
>
> mysql_connect("$mysql_host", "$mysql_username", "$mysql_password") or
> die("ERROR: Could not connect to MySQL.");
> mysql_select_db("$mysql_database") or die("ERROR: Could not connect to
> selected MySQL database.");
> $sql="SELECT * FROM cirrus_members WHERE member_id='$_SESSION
> [cirrus_member_id]'";
> $result=mysql_query($sql);
> $rows=mysql_fetch_array($result);
>
> $consumer_key = 'D6IpkcZ5RAXgVYpyLOuw';
> $consumer_secret = 'B0NqK3CiNHAaDzseK5YQ6BKE9KrWPb4YGgDIoRVhEnQ';
> $content = NULL;
>
> /* Set state if previous session */
> $state = $_SESSION['oauth_state'];
> /* Checks if oauth_token is set from returning from twitter */
> $session_token = $_SESSION['oauth_request_token'];
> /* Checks if oauth_token is set from returning from twitter */
> $oauth_token = $_REQUEST['oauth_token'];
> /* Set section var */
> $section = $_REQUEST['section'];
>
> if ($_REQUEST['access'] === 'revoke') {
> session_destroy();
> session_start();
> header("location:index.php");
>
> }
>
> /* If oauth_token is missing get it */
> if ($_REQUEST['oauth_token'] != NULL && $_SESSION['oauth_state'] ===
> 'start') {
> $_SESSION['oauth_state'] = $state = 'returned';
>
> }
>
> /*
> * 'default': Get a request token from twitter for new user
> * 'returned': The user has authorize the app on twitter
> */
> switch ($state) {
> default:
> /* Create TwitterOAuth object with app key/secret */
> $to = new TwitterOAuth($consumer_key, $consumer_secret);
> /* Request tokens from twitter */
> $tok = $to->getRequestToken();
>
> /* Save tokens for later */
> $_SESSION['oauth_request_token'] = $token = $tok['oauth_token'];
> $_SESSION['oauth_request_token_secret'] = $tok
> ['oauth_token_secret'];
> $_SESSION['oauth_state'] = "start";
>
> /* Build the authorization URL */
> $request_link = $to->getAuthorizeURL($token);
>
> /* Build link that gets user to twitter to authorize the app */
> $content .= '<a href="'.$request_link.'">Authenticate on Twitter.com</
> a> to access this application.';
> break;
>
> case 'returned':
> /* If the access tokens are already set skip to the API call */
> if ($_SESSION['oauth_access_token'] === NULL && $_SESSION
> ['oauth_access_token_secret'] === NULL) {
> /* Create TwitterOAuth object with app key/secret and token key/
> secret from default phase */
> $to = new TwitterOAuth($consumer_key, $consumer_secret, $_SESSION
> ['oauth_request_token'], $_SESSION['oauth_request_token_secret']);
> /* Request access tokens from twitter */
> $tok = $to->getAccessToken();
>
> /* Save the access tokens. Normally these would be saved in a
> database for future use. */
> $_SESSION['oauth_access_token'] = $tok['oauth_token'];
> $_SESSION['oauth_access_token_secret'] = $tok
> ['oauth_token_secret'];
> }
>
> /* Create TwitterOAuth with app key/secret and user access key/
> secret */
> $to = new TwitterOAuth($consumer_key, $consumer_secret, $_SESSION
> ['oauth_access_token'], $_SESSION['oauth_access_token_secret']);
> /* Run request on twitter API as user. */
> if ($_GET['action'] == "getinfo") { $content = $to->OAuthRequest
> ('https://twitter.com/account/verify_credentials.xml', array(),
> 'GET'); }
> if ($_GET['action'] == "update") { $content = $to->OAuthRequest
> ('https://twitter.com/statuses/update.xml', array('status' => $_POST
> ['status']), 'POST'); }
> if ($_GET['action'] == "getreplies") { $content = $to->OAuthRequest
> ('https://twitter.com/statuses/replies.xml', array(), 'GET'); }
> if ($_GET['action'] == "") { $content = $to->OAuthRequest('https://
> twitter.com/statuses/friends_timeline.xml?count=5', array(), 'GET');
> $showTweetBox = "true"; }
> break;}
>
> ?>
>
> OK, so I have all of the code I need ready, but how can I store all of
> these tokens into a MySQL database for each user?
> I set up rows for each (oauth_state, oauth_token, oauth_token_secret,
> oauth_request_token, oauth_request_token_secret, oauth_access_token,
> and oauth_access_token_secret) so I can store any of them.
> I don't know which ones to store. Any ideas?
