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

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?

Parents
  • 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?

Reply Children
  • 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