Hi, this didnt get me the mice drupal objects but I can make a php result set, it does give me the correct database/username/password. This also is specifc to Apache, IIS does nto have the DOCUMENT_ROOT variable.

$docroot = getenv("DOCUMENT_ROOT");
require_once $docroot . '/includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_DATABASE, false);
require_once $docroot . '/sites/default/settings.php';
global $databases;
$username = $databases["default"]["default"]["username"];
$password =  $databases["default"]["default"]["password"];
$database =  $databases["default"]["default"]["database"];
$host =  $databases["default"]["default"]["host"];
    mysql_connect("$host", "$username", "$password");
mysql_select_db("$database");
    
    
    
   
$sql = <<<EOD
SELECT t1.field_req_a_quote_email_value, t2.field_req_a_quote_email_subject_value
FROM field_data_field_req_a_quote_email t1
INNER JOIN field_data_field_req_a_quote_email_subject t2 ON t1.entity_id = t2.entity_id
AND t1.revision_id = t2.revision_id
LIMIT 1
EOD;

    $array = Array();  
    
    $result = mysql_query($sql);
    
    
    while ($row = mysql_fetch_object($result)) {
        $array['email']=$row->field_req_a_quote_email_value;
        $array['subject']=$row->field_req_a_quote_email_subject_value;
    }
    
    
mysql_free_result($result);

On Sun, Mar 25, 2012 at 1:50 AM, Awtar Singh <asingh@quantum-coders.com> wrote:
Gerald -

Add period before /includes/bootstrap.inc if you are executing the script from the Web root.

Or please give the exact error that you are getting.

Regards,

Awtar Singh
Executive Director
Quantum Coders LLC

www.quantum-coders.com
 
Sent from my iPhone

On Mar 25, 2012, at 8:47 AM, Gerald Klein <jk@zognet.com> wrote:

I tried this and also included the define statement for the variable that require_once is using and it errors out including bootstrap.inc.
It needs something else. 

thanks for your post, anyone else?


define('DRUPAL_ROOT', getcwd());

require_once DRUPAL_ROOT . '/includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);


On Sat, Mar 24, 2012 at 10:12 PM, Vaibhav Jain <in.vaibhavjain@gmail.com> wrote:
Just paste these 2 lines in you external file

require_once './includes/bootstrap.inc';
drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);

these are also included in index.php. These are for D6

On Sun, Mar 25, 2012 at 8:28 AM, Gerald Klein <jk@zognet.com> wrote:
Hi I need to pull a dataset in an ajax file. What drupal includes to I need to use the drupal db connection. 

thanks any help is appreciated

--jerry

--

Gerald Klein DBA

www.geraldklein.com

jk@zognet.com

708-599-0352


Linux registered user #548580

--
[ Drupal support list | http://lists.drupal.org/ ]



--
Regards,
Vaibhav Jain

--
[ Drupal support list | http://lists.drupal.org/ ]



--

Gerald Klein DBA

www.geraldklein.com

jk@zognet.com

708-599-0352


Linux registered user #548580
--
[ Drupal support list | http://lists.drupal.org/ ]

--
[ Drupal support list | http://lists.drupal.org/ ]



--

Gerald Klein DBA

www.geraldklein.com

jk@zognet.com

708-599-0352


Linux registered user #548580