I made in new custom php file lets say e.g sample.php placed in root folder accessing it through a ajax call in any module but i am not able to connect to database or perform any operation. How to do that anyone can help?
I made in new custom php file lets say e.g sample.php placed in root folder accessing it through a ajax call in any module but i am not able to connect to database or perform any operation. How to do that anyone can help?
Hi Umar,
Ideal way to go by sugar entry point checking but you can use following code as well.
Can you please write following code in top of the "sample.php" file and try to make your ajax call and database operations same as sugar way?
<?php
if(!defined('sugarEntry'))
define('sugarEntry', true);
require_once ('include/entryPoint.php');
global $db, $current_user;
<< YOUR CODE HERE >>
// HERE $db and $current_user are accessible same as sugar any module file
<< END HERE>>
?>
Hi Umar and Devang,
I dont find 'name' field in users table.
Can you try check with $current_user->first_name?
Thanks!.
Yes Umar, As I have posted you can pass current user id as a post variable while making ajax call.
And apply following code in your sample.php file.
<?php
if(!defined('sugarEntry'))
define('sugarEntry', true);
require_once ('include/entryPoint.php');
global $db, $current_user;
$userId = $_REQUEST['userId'];
if(empty($current_user->id)){
$current_user->retrieve($userId);
}
$name = $current_user->name;
echo $name;
?>
Hello Devang,
With your logic i am able to access properties of logged in user. Thank You so much
Now kindly please tell me how to do query in my sample_info.php page ?
Hello Devang,
Buddy i have done that query thing used the $db variable ..Thankyou so much once again