can we create new php page in sugar

[prasannagowri]

hello,
i am new to sugar,
can we create new php file in sugar.
if we can what are the conditions we have to follow for database connection,
please help me
thanks in advance

[akkimca]

hi..
i created new file in sugar like this way...
i dont know its right or wrong but its work for me
i write new code in new file like:

 define('sugarEntry',true);
require_once('config.php');

$db=mysql_connect('localhost',$sugar_config["dbconfig"]["db_user_name"],'');
mysql_select_db($sugar_config["dbconfig"]["db_name"],$db) or die("Error In Database."); 
  

and called this file like this in javascript:

 window.location='../sugarcrm/comment.php'; 
  

try this... may this code help you

[prasannagowri]

hi
thanks for quick replay,
in the new file what are the files need to include.
can u please help me
thanks in advance,

[akkimca]

hi...
its on you which sugar function are u using...
just include the declaration file of function which are u going to use in ur new file....

[andopes]

A better approach is:

 if(!defined('sugarEntry'))define('sugarEntry', true);
require_once('include/entryPoint.php');
 
global $sugar_config;
 
$db = & PearDatabase::getInstance(); 
  

[akkimca]

thanks...

i need this code to make my code proper....