where to park custom php files

I want to try and do some complex queries against the database and display the results using calls to mysql
is there anything i need to do config-wise and where to place the new php files
I tried in htdocs but nothing was returned.
Something like this:

/* Connecting, selecting database */
$link = msql_connect('localhost', 'username', 'password')
    or die('Could not connect : ' . msql_error($link));

msql_select_db('bitnami_suitecrm', $link)
    or die('Could not select database');

/* Issue SQL query */
$query = 'SELECT name FROM project';
$result = msql_query($query, $link) or die('Query failed : ' . msql_error());

/* Printing results in HTML */
echo "<table>\n";
while ($row = msql_fetch_array($result, MSQL_ASSOC)) {
    echo "\t<tr>\n";
    foreach ($row as $col_value) {
        echo "\t\t<td>$col_value</td>\n";
    echo "\t</tr>\n";
echo "</table>\n";

/* Free result set */

/* Close connection */

Look into creating an entrypoint.


This will allow you to execute you php script within sugar.

Once you have looked into creating an entry point might be worth using the DBManagerFactory.