[insert_php]
define(‘DBNAME’, ‘universe_wordpress’);
define(‘DBUSER’, ‘universe_yoga’);
define(‘DBPASS’, ‘O=Tb13{%=^G_’);
define(‘DBHOST’, ‘localhost’);

$db = new PDO(“mysql:host=”.DBHOST.”;dbname=”.DBNAME, DBUSER, DBPASS);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
[/insert_php]

[insert_php]
$stmt = $db->prepare(‘SELECT * FROM uya_visual_form_builder_entries WHERE subject=:regType AND certificate_no= :certNumber’) ;
$stmt->execute(array(
‘:certNumber’ => ‘yes’,
‘:regType’ => ‘school registration’
));
while ($row = $stmt->fetch()){
$getData = stripslashes($row[‘data’]);
$completionDate = $row[‘date_submitted’];
$deSerialize = unserialize($getData);
$getImage = $deSerialize[‘1’][‘value’];
$getName = $deSerialize[‘2’][‘value’];
$getAddress = $deSerialize[‘4’][‘value’];

echo ‘


School Name : ‘.$getName.’

Registration Date: ‘.date(“d-F-Y”, strtotime($completionDate)).’

‘;
}
[/insert_php]