connect to sugarcrm and get some data in my custom php file

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!.

Devang any solution buddy?

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;

?>

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 ?