• News
  • Our Team
  • History
  • FAQ
  • Bill Pay
Red LerillesRed LerillesRed LerillesRed Lerilles
  • Facilities
  • Membership Rates
  • Fitness
    • Fitness Programs
    • Group Fitness
    • MIT/Paid Classes
    • Personal Training
    • Aqua
  • Sports
    • Basketball
    • Boxing
    • Racquetball/Handball
    • Tennis
    • Pickleball
    • SUMMER PROGRAMS 2023
  • Schedule
    • Group Fitness Schedule
    • MIT/Paid Classes
    • Club/Community Events
  • Amenities
    • Swimming Pools
    • Child Care
    • Front Desk/Pro Shop
    • Snack Bar/Grill
    • Coffee Bar/Lounge
  • Contact Us

PHPTest

    Home PHPTest

    [insert_php]

    //require_once(‘/home/redleri1/public_html/staging/wp-content/themes/TheFox/PHPEncryption/OpenSSL.class.php’);

    $dsn = ‘4D:host=76.72.95.153;charset=UTF-8;’; //prod
    $user = ‘web_proc_pmt’;
    $pass = ‘478500#Pg’;

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

    //$data = “1000750”; //<== This is the original account number //$ws = new BillPayEncryptAPI\OpensslAES(); //$key = $ws::getKey(); //$ciphertext = $ws::encrypt($data, $key); //$ciphertext_base64 = base64_encode($ciphertext); //echo $ciphertext_base64; //$qryStr = "UPDATE App_Config SET value='".$ciphertext_base64."' where iD=3"; //$qryStr = "UPDATE App_Config SET value='cdbcbb4adf0eed3da2d4b0f3ba914d7e4af019230cd47cfce0fc7bdb' where iD=4"; //$stmt = $db->prepare($qryStr);
    //$stmt->execute();

    //$stmt = $db->prepare(“SELECT * from App_Config”);
    $stmt = $db->prepare(“SELECT * from Customers”);
    $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]

    © 2021 Red Lerilles | All Rights Reserved
    • Facilities
    • Membership Rates
    • Fitness
      • Fitness Programs
      • Group Fitness
      • MIT/Paid Classes
      • Personal Training
      • Aqua
    • Sports
      • Basketball
      • Boxing
      • Racquetball/Handball
      • Tennis
      • Pickleball
      • SUMMER PROGRAMS 2022
    • Schedule
      • Group Fitness Schedule
      • MIT/Paid Classes
      • Club/Community Events
    • Amenities
      • Swimming Pools
      • Child Care
      • Front Desk/Pro Shop
      • Snack Bar/Grill
      • Coffee Bar/Lounge
    • Contact Us
    • Bill Pay
    Red Lerilles