· 6 years ago · Jan 13, 2019, 03:10 AM
1PHP MySQL Array Confusion
2require('config.php');
3$query = "SELECT * FROM users";
4$result = mysql_query($query) or die(mysql_error());
5while($row = mysql_fetch_array($result)){
6$oauthtoken2 = $row['oauth_token'];
7$oauthsecret2 = $row['oauth_token_secret'];
8$oAuthToken = $oauthtoken2;
9$oAuthSecret = $oauthsecret2;
10echo "$oAuthToken";
11require_once('twitteroauth.php');
12$tweet = new TwitterOAuth($consumerKey, $consumerSecret, $oAuthToken, $oAuthSecret);
13}
14
15echo "$oAuthTokenn";
16
17<?php
18require('config.php');
19require_once('twitteroauth.php');
20
21$query = "SELECT * FROM users";
22$result = mysql_query($query) or die(mysql_error());
23
24while($row = mysql_fetch_array($result)){
25 $oauthtoken2 = $row['oauth_token'];
26 $oauthsecret2 = $row['oauth_token_secret'];
27 $oAuthToken = $oauthtoken2;
28 $oAuthSecret = $oauthsecret2;
29 //echo "$oAuthToken";
30 $tweet = new TwitterOAuth($consumerKey, $consumerSecret, $oAuthToken, $oAuthSecret);
31
32 // do what ever you need to do here with the $tweet object.
33
34 //unset($tweet); - unset it here, then loop to the next token / secret pair
35}
36?>