issue when inserting variable value to MySQL table

Question

Hey I am currently trying to insert a global variable to a table. The other values I pass are variables too but they get sent correctly.

Here is my query. my error handling does not capture anything

$result = mysql_query("INSERT INTO IPmanagement (userId, NameUsed, EmailUsed, IPStatus, Ip) VALUES ('" .$masterUserId . "', '" . $Entry['LeadName'] . "', '" . $Entry['LeadEmail'] . "', '0', '" . $ip . "')") or die(ErrorException("Function 6", "Error when processing the current lead. your data is unaffected and if the proccess continues please contact an Admin.", mysql_error(),$_SERVER['REMOTE_ADDR'], CurrentPath(), $masterUserId));

my variable that is global defined before the function is

 $masterUserId = "1";

I tried echoing the variable before it sends and it echos out correctly YET my table holds a value of 0.

here is a screenshot of how I have my table setup.

enter image description here

Click for Larger Image

Any idea what is going on. I am rather stumped and tried writing this same code different ways and it still gives me same issue. Also $masterUserId will always be an int value

Edit: also would like to mention the variable is different .php that contains the varaiable and database login information. It is being included at the top. (don't know if that is relevant)

Do not use mysql_*. Replace them with mysqli_* or PDO::. Did you try to echo the mysql_query()? Do this. Replace mysql_query("..."); with die("..."); and put it in the phpMyAdmin and try executing. — Praveen Kumar Purushothaman
– Praveen Kumar Purushothaman, Commented Oct 4, 2012 at 5:58
I don't think this is a PHP error. It must be a logical error. Try echoing $masterUserId just before executing the query ! — Gaurav Srivastava
– Gaurav Srivastava, Commented Oct 4, 2012 at 6:03
@GauravSrivastava The OP said he did it. Please read the question again! — Praveen Kumar Purushothaman
– Praveen Kumar Purushothaman, Commented Oct 4, 2012 at 6:08
Hi @EmanuelPermane, if any of below answers has solved your question please consider accepting the best answer or adding your own solution. So, that it indicates to the wider community that you've found a solution. — mrsrinivas
– mrsrinivas, Commented Jan 4, 2017 at 3:24

BenMorel · Accepted Answer · 2013-11-24 15:54:23Z

1

Because you are not inserting IP STATUS.Which is not null

DATABASE SCHEMA

\

You should either set this to null or enter some value to it.

If you are using query in a function than use like this

function (){
//than define 
 $globat $masterUserId;
// use the global defination 
// than use this variable with global value
}

edited Nov 24, 2013 at 15:54

BenMorel

37k52 gold badges208 silver badges339 bronze badges

answered Oct 4, 2012 at 6:00

StaticVariable

5,2934 gold badges26 silver badges46 bronze badges

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

7 Comments

Emanuel Permane Over a year ago

Good call, I added it but it still shows userId as 0. I am editing the original post to reflect that

StaticVariable Over a year ago

@EmanuelPermane may be $masterUserId = 1; can help you try this.

StaticVariable Over a year ago

@EmanuelPermane are you using defining its global defination like function (){ global $masteUserId; //than code... }

Emanuel Permane Over a year ago

No i was declaring it outside of any function and then that file was included into this one.

Emanuel Permane Over a year ago

It gives me Parse error: syntax error, unexpected T_VARIABLE in XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX on line 166. I put the golbat in the same function i'm importing correct?

|

Praveen Kumar Purushothaman · Accepted Answer · 2012-10-04 06:02:31Z

0

Do not use mysql_*. Replace them with mysqli_* or PDO::.

Did you try to echo the mysql_query()? Do this. Replace mysql_query("..."); with die("..."); and put it in the phpMyAdmin and try executing.

And in your table, I see that IP Status is a NOT NULL. So that might throw an exception. Use a default value in the table.

And yeah, what do you get the result as in mysql_error()?

answered Oct 4, 2012 at 6:02

Praveen Kumar Purushothaman

167k27 gold badges215 silver badges261 bronze badges

1 Comment

Praveen Kumar Purushothaman Over a year ago

It gives you an output on what query will be executed, so that you can see if that was the required query.

david strachan · Accepted Answer · 2012-10-04 10:01:25Z

0

Why ''' or "' in query? I have cleaned up query with PHP function sprintf and using NULL for EntryID(Autoincrement)

$query = sprintf("INSERT INTO IPmanagement (EntryID,userId, NameUsed, EmailUsed, IPStatus, Ip) VALUES (NULL,%s,%s,%s,'0',%s)",
$masterUserId , $Entry['LeadName'] , $Entry['LeadEmail'] , $ip ));
$result = mysql_query($query);

You should also use MySQLi or PDO

answered Oct 4, 2012 at 10:01

david strachan

7,2282 gold badges25 silver badges33 bronze badges

Collectives™ on Stack Overflow

issue when inserting variable value to MySQL table

3 Answers 3

7 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

7 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related