从while循环插入mysql不起作用


insert into mysql from a while loop not working

我有一个用户access_token的数据库,我编写的代码确保如果数据库中已经存在新的用户访问令牌,它应该显示一个错误。我试图进行循环并在其中放入if语句,但它不起作用。

<?php
mysql_connect("localhost", "___", "___");
mysql_select_db("___");
session_start();
require_once ('twitteroauth/twitteroauth.php');
require_once ('config.php');
if (empty($_SESSION['access_token']) || 
    empty($_SESSION['access_token']['oauth_token']) || 
    empty($_SESSION['access_token']['oauth_token_secret'])) {
  header('Location: ./clearsessions.php');
}
$access_token = $_SESSION['access_token'];
$connection = new TwitterOAuth(CONSUMER_KEY, 
                               CONSUMER_SECRET,
                               $access_token['oauth_token'],
                               $access_token['oauth_token_secret']);
$content = $connection->get('account/verify_credentials');
$u = "SELECT * FROM users";
$uu = mysql_query($u);
while ($uuu = mysql_fetch_object($uu)) 
{
  foreach($uuu->access_token as $ali)
  {
    if ($access_token['oauth_token'] != $ali)
    {
      $newuser = "INSERT INTO users(access_token,access_token_secret)
                  VALUES ('{$access_token['oauth_token']}',
                          '{$access_token['oauth_token_secret']}' )";
      $donewuser = mysql_query($newuser);
      include ('html.inc');
    }
    else
    {
      echo "error";
    }
  }
}

您需要将连接分配给一个变量,否则它实际上什么都不做。

$link = mysql_connect('localhost','user','password');
mysql_select_db('database_name', $link);
*snip*
$uu = mysql_query($u, $link);

此外,请不要使用mysql函数,因为它们已被弃用。您应该使用PDO或Mysqli