prepare("select * from allotee_biodata where regno = '$regno'") ;
$sqlallo->execute() ;
if($sqlallo->rowcount() > 0)
{
$addrow = $sqlallo->fetch(pdo::FETCH_ASSOC) ;
$custodian = $addrow['custodian'] ;
$office = $addrow['allote_office'] ;
$phone = $addrow['allote_phone'] ;
$email = $addrow['allote_email'] ;
$astate = $addrow['state'] ;
$lga = $addrow['lga'] ;
$nation = $addrow['nationality'] ;
$creg = $addrow['company_regno'] ;
$mid = $addrow['identification_means'] ;
$idno = $addrow['id_no'] ;
$adm = $addrow['admin'] ;
}
//get data from bio data
$sqlstal = $DBcon->prepare("select * from stall_details where regno = '$regno'") ;
$sqlstal->execute() ;
if($sqlstal->rowcount() > 0)
{
$addro = $sqlstal->fetch(pdo::FETCH_ASSOC) ;
$mname = $addro['market'] ;
$town = $addro['town'] ;
$mlga = $addro['lga'] ;
$msection = $addro['market_section'] ;
$zone = $addro['zone'] ;
$lineno = $addro['line_no'] ;
$stallno = $addro['stall_no'] ;
$stype = $addro['stall_type'] ;
$certno = $addro['alloc_cert_no'] ;
$basis = $addro['bas_of_occup'] ;
$ansid = $addro['ansid_no'] ;
$eno = $addro['en_no'] ;
}
// set Gprs
if($mname =='OSE OKWODU MARKET')
{
$gps = 'osegp.jpg' ;
}
if($mname =='OGBARU MAIN MARKET')
{
$gps = 'ogbarugps1.jpg' ;
}
//end set gprs
//get passport
$sqld = $DBcon->prepare("select * from documents where regno = '$regno'") ;
$sqld->execute() ;
if($sqld->rowcount() > 0)
{
$addd = $sqld->fetch(pdo::FETCH_ASSOC) ;
$image = $addd['image'] ;
}
// Get the current date
$date = getdate();
// Get the value of day, month, year
$currentDay = $date['mday'];
//$currentMonth = $date['mon'];
//$currentMonth = $date['m'];
$currentWeekday = $date['wday'];
$month = $date['month'];
$year = $date['year'];
?>
Print certificate
prepare("select * from allotee_biodata where regno = '$clientid'") ;
$sqladdres->execute() ;
$addrow = $sqladdres->fetch(pdo::FETCH_ASSOC) ;
$phone = $addrow['allote_phone'] ;
$email = $addrow['allote_email'] ;
$name= $addrow['custodian'] ;
//get data from stall data
$sqls = $DBcon->prepare("select * from stall_details where regno = '$clientid'") ;
$sqls->execute() ;
$addros = $sqls->fetch(pdo::FETCH_ASSOC) ;
$mname = $addros['market'] ;
$stallno = $addros['stall_no'] ;
$zone = $addros['zone'] ;
//$govt = "An approved e-governance initiative by The Govt. of Anambra State." ;
//$coda = $clientid.'-'.$phone.'-'.$name.'-'.$gender.'-'.$email.'-'.$mname.'-'.$stallno.'-zone'.$zone.'-'.$govt ;
$comp = "X5M GLOBAL MAX-DATA CONCEPT LTD" ;
//$coda1 = $clientid.'-'.$comp;
$govt = "An approved e-governance initiative by The Govt. of Anambra State." ;
$coda = $clientid.'-'.$phone.'-'.$name.'-'.$email.'-'.$mname.'-'.$stallno.'-zone'.$zone.'----'.$govt.'----'.'In Agency with'.'---'.$comp ;
}
//set it to writable location, a place for temp generated PNG files
$PNG_TEMP_DIR = dirname(__FILE__).DIRECTORY_SEPARATOR.'temp'.DIRECTORY_SEPARATOR;
//html PNG location prefix
$PNG_WEB_DIR = 'temp/';
include "QRC/qrlib.php";
//ofcourse we need rights to create temp dir
if (!file_exists($PNG_TEMP_DIR))
mkdir($PNG_TEMP_DIR);
$filename = $PNG_TEMP_DIR.'test.png';
$errorCorrectionLevel = 'L';
$matrixPointSize = 2;
// user data
$filename = $PNG_TEMP_DIR.'test'.md5($coda.'|'.$errorCorrectionLevel.'|'.$matrixPointSize).'.png';
QRcode::png($coda, $filename, $errorCorrectionLevel, $matrixPointSize, 2);
?>
Print certificate