Error while inserting perl variable in the mysql table on html page

Question

Error while inserting email address in the table

**[perl] my $username=$CGI->{salesrep}; return $username;[/perl]@gmail.com**

I want to insert this value in the table.

But It gives null when executed.

[query type=list sql="INSERT tech4less.outofstock_sku SET name='[value name]',customer_email='[value email]', phone='[value phone]', state='[value b_state]', postalcode='[value zip]', country='[value country]', **salesperson='[perl]$username[/perl]@gmail.com**', product='[value wish_product]', item_description='[value wish_descrip]', manufacturer='[value wish_man]',  category = '[value wish_cat]', business_yn='[value option]', date = now()"]

[/query]

Not familiar with it, is that this framework? (Asking because the [data-interchange] tag isn't really useful here - a separate tag for that framework would be welcome.) — Mat
– Mat, Commented Feb 3, 2012 at 11:31
icdevgroup.org/interchange-doc-5.2.0/frames/ictags_87.html pls see this — rachel
– rachel, Commented Feb 3, 2012 at 11:50

user1126070 · Accepted Answer · 2012-02-03 11:20:53Z

1

If $CGI is a CGI object then access a parammeter this way:

my $username=$CGI->param('salesrep');

Read this: http://perldoc.perl.org/CGI.html#FETCHING-THE-VALUE-OR-VALUES-OF-A-SINGLE-NAMED-PARAMETER:

Regards

answered Feb 3, 2012 at 11:20

user1126070

5,0691 gold badge18 silver badges15 bronze badges

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

2 Comments

rachel Over a year ago

How to use this in the sql statement?

rachel Over a year ago

I am able to print this value on the page but having issues in inserting using sql..

Collectives™ on Stack Overflow

Error while inserting perl variable in the mysql table on html page

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