php grabbing data from javascript

Question

Apparently i try to save the data into the mysql, but it didnt work.. Anyone help?

create_users.php

<form method="post" action="checkAvailability.php">
 <script>
    var macs = { 
    getMacAddress : function() 
    { 
        document.macaddressapplet.setSep( "-" ); 
        return (document.macaddressapplet.getMacAddress()); 
    }}jQuery(document).ready(function(){ 
        var mac = macs.getMacAddress();  
        $.get('/checkAvailability.php?mac=' + mac, function() { alert('yeah done'); }) 
    }); 
</script>  



<script type="text/javascript">
  document.write(macs.getMacAddress());
</script>
    </form>

checkAvailability.php

$dbhost = 'localhost';
$dbuser = 'root';
$dbname = 'registration';
mysql_connect($dbhost, $dbuser) or die("Could not connect database");
mysql_select_db($dbname);
$mac = $_GET['mac'];
$mac = mysql_real_escape_string($mac);
$sql = "INSERT INTO test(mac) VALUES ('$mac')";
mysql_query($sql);

Please elaborate on what you mean by "didn't work". And what is macs? It is not a standard object and not defined anywhere in your code. — Max Shawabkeh
– Max Shawabkeh, Commented Jan 25, 2010 at 5:26
Add some echo's to see what's going on and call your script directly from the browser. Your problem could be anywhere from the mac var being empty to your mysql connection not being made to the database. — Erik
– Erik, Commented Jan 25, 2010 at 5:27
Ah I see you went with my brief code. It will probably require some error checking etc — alex
– alex, Commented Jan 25, 2010 at 5:37
error checking as in?? which part? i thought it would be a simple coding.. — kennedy
– kennedy, Commented Jan 25, 2010 at 5:50

tejzpr · Accepted Answer · 2010-01-25 07:16:46Z

4

You are calling "create_users.php" in your $.get() method instead you should be calling "checkAvailability.php"..

And try this for your client side form:

var macs = {
getMacAddress : function()
{
    document.macaddressapplet.setSep( "-" );
    return (document.macaddressapplet.getMacAddress());
}}jQuery(document).ready(function(){
    var mac = macs.getMacAddress(); 
    $.get('/checkAvailability.php?mac=' + mac, function() { alert('yeah done'); })
});

edited Jan 25, 2010 at 7:16

answered Jan 25, 2010 at 5:27

tejzpr

9951 gold badge9 silver badges19 bronze badges

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

9 Comments

Erik Over a year ago

Wow, I totally missed that =x

alex Over a year ago

throw a quick and dirty echo mysql_error() after mysql_query(). Also, have you connected to your database?

Erik Over a year ago

Going to go with my original comment, try calling it directly from the browser: yoursite.com/checkAvailability.php?mac=555 Add some echo statements to check your SQL and a or die(mysql_error()); after the query. If the direct call puts a record in your database, then at least you know the problem is on the front-end.

kennedy Over a year ago

hmm.. i tried to call it manually from the browser, and it works... but how come it doesnt call up properly...

kennedy Over a year ago

is my form having this issue here?

|

Collectives™ on Stack Overflow

php grabbing data from javascript

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related