Query

[insert_php]
//$dsn = ‘4D:host=76.72.95.153;port:19812;charset=UTF-8;’; // prod port doesn’t matter

$dsn = ‘4D:host=76.72.95.153;charset=UTF-8;’; //prod
//$dsn = ‘4D:host=98.191.66.27;charset=UTF-8’; //staging

$user = ‘web_proc_pmt’;
$pass = ‘478500#Pg’;

try {
// Connection to the 4D SQL server
$db = new PDO($dsn, $user, $pass);

//$date_format = date(‘Y-m-d’);

//$qryStr = “UPDATE Member SET eMailAddr =’koneal@agilink.net’ where Acct_no=25056”;
//$qryStr = “UPDATE App_Config SET value=’Nelix123!’ where iD=2”;

//$qryStr = “UPDATE Member_PSource SET AutoPay=:autoPay where iD=15185”;
//$stmt = $db->prepare($qryStr);
//$stmt->bindValue(‘:autoPay’, FALSE, PDO::PARAM_BOOL);

//$stmt = $db->prepare(“SELECT Acct_no, Verify_Code, Main_Name,User_id,Password,eMailAddr from Member order by User_id desc limit 100”);

//$stmt = $db->prepare(“SELECT count(Verify_Code), Verify_Code from Member group by Verify_Code having count(Verify_Code)>1 limit 10 “);

//$stmt = $db->prepare(“SELECT * from Member_PSource order by iD desc LIMIT 100”);
//$stmt = $db->prepare(“SELECT * from Member_PSource where Last4Digits=’7828′;”);
//7828

//$stmt = $db->prepare(“SELECT * from Online_Payments where Nelix_Trans_ID=’6901525′”);
$stmt = $db->prepare(“SELECT * from App_Config”);
//6868367
//$stmt = $db->prepare(“SELECT * from Online_Payments order by iD desc LIMIT 100”);
//$stmt = $db->prepare(“SELECT * from Online_Payments where AcctNo=59415”);
//$stmt = $db->prepare(“SELECT AutoPay from Member_PSource where iD=15185 LIMIT 100”);

$stmt->execute();
print_r($stmt->fetchAll());

echo “Connected successfully
“;
} catch (PDOException $e) {
echo ‘

There was an error connecting to the database!

‘;
die(“Erreur 4D : ” . $e->getMessage());
}

unset($stmt);
unset($db);
[/insert_php]