#!/usr/bin/perl -w use CGI qw/:all/; use CGI::Carp qw(fatalsToBrowser); use DBI; #my $dbh=DBI->connect('dbi:mysql:parc_demog:localhost:3306','root','root') or die "Unable to connect: $DBI::errstr\n"; my $dbh=DBI->connect('dbi:mysql:parc_demog:localhost','parcdemog','parc9904')or die "Couldn't connect to database: " . DBI->errstr; my $shID= param('shID'); my $cityName=param('cityName'); my $conCode=param('conCode'); $strCond=""; if ($strCond eq "") { $strLOC="SELECT locCode,locName,cityName,typeCode FROM cf_location WHERE conCode='$conCode' order by cityName,locName"; #$strLOC="SELECT locCode,locName FROM cf_location WHERE conCode='$conCode' order by locName"; } $sthL=$dbh->prepare($strLOC); $sthL->execute; $cont=$sthL->rows; print < PAN ARAB RESEARCH CENETER - Mystery Shopping
 

PAN ARAB RESEARCH CENTER

Mystery Shopping - Search

blk1 my $i= 0; while ($visit=$sthL->fetchrow_hashref()) { $i = $i + 1; my $n1 = "r".$i; my $n2 = "s".$i; my $n3 = "t".$i; my $n4 = "u".$i; my $lcode ="$visit->{'locCode'}"; my $lname ="$visit->{'locName'}"; my $cname ="$visit->{'cityName'}"; my $type ="$visit->{'typeCode'}"; if($type==1) { $htmstr=$htmstr.""; $FLGA=1; } elsif($type==2) { $htmstr1=$htmstr1.""; $FLGB=1; } } if($FLGA==1) { $htmstr = "".$htmstr; } if($FLGB==1) { $htmstr1 = "".$htmstr1; } $finlstr=$htmstr.$htmstr1; print <
".$lname."".$cname."
".$lname."".$cname."
HyperMarket
Carrefour Market
Select the location(s) for which you intend to do Visit(s) and click next button to display the Visit Plan



1. In case you will not do the Visit as per you requested, Please email back to parcdxb@emirates.net.ae prior the requested date.

2. If you did not Fill the Questionnaire within Two days, The link will be automatically disabled and the Visit will become Invalid.

3. Maximum Number Visits Allowed 

	Total per shopper =25 times 


	Same Hyper Market = 4 times 


	Same Carrefour Market = 2 times
4. Please notice the Cashier Name and Tilt Number even though these are available in the Receipt

5. Avoid going to same Counter again, in case you do shopping at the same Location

blk2