Won't add to database using script and php

Question

I have some code in script that gets some values and posts them to php which (i already know works) should add to the database but doesnt? just wondering whats going wrong, my guess is that its never actually getting to my php file? any ideas?

FB.Event.subscribe('auth.login', function(response) 
{               
    FB.api('/me', function(response) {
        $.post("usersignup.php", { facebookid: response.id, email: response.email, firstname: response.first_name, lastname: response.last } );             
    });

appropriate part of usersignup.php looks like this

  mysql_select_db ($database);  
    $fbid = $_POST['facebookid'];
    $fn = $_POST['firstname'];
    $ln = $_POST['lastname'];
    $em = $_POST['email'];    
      $query = "INSERT INTO user";
      $query .= "(facebookid, firstname, lastname, email) VALUES ('$fbid','$fn','$ln','$em')";
      $results = mysql_query($query, $link);          
      $mediaid = mysql_insert_id();

Don't guess. Add error handling and some output that tracks your script's execution. — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Apr 2, 2011 at 22:04
this is running on your website and not a fb non-iframe canvas, right? — prodigitalson
– prodigitalson, Commented Apr 2, 2011 at 22:31
yea on my website, user clicks login to facebook, they log in then $.post should be called — James
– James, Commented Apr 2, 2011 at 22:37

prodigitalson · Accepted Answer · 2011-04-02 22:26:23Z

1

Ok so there may be a php error lets add some error handling...

Modify your PHP:

ini_set('display_errors', 1);

if(!mysql_select_db ($database))
{
   echo 'Could not connect';
   exit;
}
else
{
  $fbid = $_POST['facebookid'];
  $fn = $_POST['firstname'];
  $ln = $_POST['lastname'];
  $em = $_POST['email'];    
  $query = "INSERT INTO user";
  $query .= "(facebookid, firstname, lastname, email) VALUES ('$fbid','$fn','$ln','$em')";

  if(!$results = mysql_query($query, $link))
  {
     echo 'Query failed: '.mysql_error();
     exit;
  }

  $mediaid = mysql_insert_id();
  echo 'Success: '. $mediaid;
}

And your js should alert the response:

FB.Event.subscribe('auth.login', function(response) 
{               
  FB.api('/me', function(response) {
    $.post("usersignup.php", { 
        facebookid: response.id, 
        email: response.email, 
        firstname: response.first_name, 
        lastname: response.last 
      },
      function(rdata){ alert(rdata); }, 
      'text'
    );             
  });
});

Also keep an eye on your JS error console... if there is an issue with your JS its going to tell you.

$.post is a shortcut for $.ajax therefore it doesnt support the full config hash youre giving it. The signature is $.post(url, data, successCallback) if you need more control than this then use $.ajax.

edited Apr 2, 2011 at 22:26

answered Apr 2, 2011 at 22:08

prodigitalson

60.6k10 gold badges106 silver badges118 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

James Over a year ago

What should i use to run this, im doing this in dreamweaver and therefore getting no error message

prodigitalson Over a year ago

Oh preview it in a browser - id recommend Firefox with Firebug installed... never use the Dreamweaver preview... its useless ;-)

Kevin · Accepted Answer · 2011-04-02 21:54:49Z

0

I'm guessing you've got an SQL error. Change your line to look like this:

$results = mysql_query($query, $link) or die(mysql_error());

and see if an error is being generated.

I'm betting that one of your values is breaking the query. You need to be running everything through mysql_real_escape_string(), at a minimum.

$fn = mysql_real_escape_string($_POST['firstname']);

answered Apr 2, 2011 at 21:54

Kevin

5124 silver badges15 bronze badges

1 Comment

James Over a year ago

No neither fix it. i think it maybe that its not completing $.post but i dont know why, does $.post have to be called?

Lightness Races in Orbit · Accepted Answer · 2011-04-02 22:05:00Z

0

Your PHP file does not create a connection to the MySQL server, and $database is not defined.

answered Apr 2, 2011 at 22:05

Lightness Races in Orbit

387k77 gold badges670 silver badges1.1k bronze badges

2 Comments

James Over a year ago

it is defined, and created just not in the code i have pasted

Lightness Races in Orbit Over a year ago

@James: Right, so when you said "usersignup.php looks like this", you were lying. Please amend your question accordingly.

Collectives™ on Stack Overflow

Won't add to database using script and php

3 Answers 3

2 Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related