inserting variable into table

Question

I am able to generate the activation_key in the following code. But I can't manage to insert it into the table. Blank value gets inserted into the table. What am I doing wrong? (using PEAR text password and other extensions)

                $activation_key = Text_Password::createFromLogin($data['email'], 'rot13');
                $sql = "INSERT INTO auth (firstname, lastname,gender,dob,mobileno,landlineno,addressline1,addressline2,addressline3,country,state,city,pincode,email,username,password,question,answer,activation_key)
                VALUES ('" . $db->escapeSimple($data['firstname']) . "','"
                                    . $db->escapeSimple($data['lastname'])."','"
                                    . $db->escapeSimple($data['gender'])."','"
                                    . $db->escapeSimple($data['dob'])."','"
                                    . $db->escapeSimple($data['mobileno'])."','"
                                    . $db->escapeSimple($data['landlineno'])."','"
                                    . $db->escapeSimple($data['address1'])."','"
                                    . $db->escapeSimple($data['address2'])."','"
                                    . $db->escapeSimple($data['address3'])."','"
                                    . $db->escapeSimple($data['country'])."','"
                                    . $db->escapeSimple($data['state'])."','"
                                    . $db->escapeSimple($data['city'])."','"
                                    . $db->escapeSimple($data['pin'])."','"
                                    . $db->escapeSimple($data['email'])."','"
                                    . $db->escapeSimple($data['username'])."','"
                                    . md5($db->escapeSimple($data['pwd']))."','"
                                    . $db->escapeSimple($data['question'])."','"
                                    . $db->escapeSimple($data['answer']). "', '"
                                    . $db->escapeSimple($data['activiation_key'])."')";
          $db->query($sql);

Have you tried printing out the value thats inside the VALUES(...) part of the query? — Nick Bedford
– Nick Bedford, Commented Sep 28, 2009 at 6:11
activation_key variable is getting generated. Because I am getting an email with that code. The problem is with the sql query. — shantanuo
– shantanuo, Commented Sep 28, 2009 at 6:14
All other columns except activation_key are correctly added. — shantanuo
– shantanuo, Commented Sep 28, 2009 at 6:16
You mispelled the variable name in the last line of the insert. Are you using any ide? — Eineki
– Eineki, Commented Sep 28, 2009 at 6:17
by the way, you generate the $activation_key in the first line, but insert $data['activation_key'] in the last line — Eineki
– Eineki, Commented Sep 28, 2009 at 6:20

Scott Evernden · Accepted Answer · 2009-09-28 06:17:56Z

2

$data['$activiation_key'] doesn't actually appear to hold $activation_key

plus if you really cut and paste then $activiation_key is spelt wrongly

answered Sep 28, 2009 at 6:17

Scott Evernden

40.1k15 gold badges81 silver badges84 bronze badges

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

2 Comments

shantanuo Over a year ago

Thanks. 1) corrected the spelling 2) Changed the line to something like this... .$db->escapeSimple($activation_key)."')"; And it solved the problem. Is it ok to use vi or should I use something else to improve my coding time?

Scott Evernden Over a year ago

nothing wrong w/ vi - i used that for years and years, for php coding these days i tend to use eclipse, and notepad++ on Windows

Collectives™ on Stack Overflow

inserting variable into table

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related