Skip to content

Instantly share code, notes, and snippets.

@vjaro
Created April 8, 2020 17:07
Show Gist options
  • Save vjaro/319cbec95f01c99f11b2e9dedb198e51 to your computer and use it in GitHub Desktop.
Save vjaro/319cbec95f01c99f11b2e9dedb198e51 to your computer and use it in GitHub Desktop.
How to create MySQL Stored Functions using PDO in SugarCRM
<?php
if (!defined('sugarEntry')) {
define('sugarEntry', true);
}
require_once('include/entryPoint.php');
function getPDOConnection()
{
global $sugar_config;
$host = $sugar_config['dbconfig']['db_host_name'];
$username = $sugar_config['dbconfig']['db_user_name'];
$password = $sugar_config['dbconfig']['db_password'];
$database = $sugar_config['dbconfig']['db_name'];
$port = $sugar_config['dbconfig']['db_port'];
if (!$port) {
$port = "3306";
}
$conn = new PDO("mysql:host=$host;dbname=$database;port=$port", $username, $password);
return $conn;
}
function createStoredFunction()
{
$conn = getPDOConnection();
if($conn){
$query = "getAge.sql";
$contents = file_get_contents($query);
$stmt = $conn->prepare($contents);
$res = $stmt->execute();
if (!$res){
return "failed to install stored function \n";
}else{
return "successfully installed stored function \n";
}
}
}
print_r(createStoredFunction());
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment