在mysql中插入数据先前定义的变量

Question

I am using this code to get data from Json and insert them to mysql. However it inserts no records in the data base.

    <?php  
    include("db.php");  
    $currsiteurl = 'http://graph.facebook.com/1597233119';  
     $graph = json_decode(file_get_contents($currsiteurl));  
     $id = $graph->id;  
     echo "id        : ".$id;   
     echo "<br>";
     $username = $graph->username;  
      echo "username : ".$username;  
      echo "<br>";
     $gender = $graph->gender;  
      echo "gender   : ".$gender;  
      echo "<br>";
       $locale = $graph->locale;  
         echo "locale   : ".$locale;  


        mysql_query("INSERT INTO users_data (id, username, gender, locale) 
         VALUES ('.$id', '.$username', '.$gender', '.$locale')");    
          ?>

Can any one show me whereis the mistake ?

Answer 1

mysql_query("INSERT INTO users_data (id, username, gender, locale) 
     VALUES ('.$id', '.$username', '.$gender', '.$locale')");  

You are creating a single string (with embedded variables) so the dots '.' are not required.

If either of the id or gender are number-fields then this is likely to be what prevents the data from being inserted (with the dots). (If they are numbers they don't require surrounding apostrophes either.)