[support] Database connection

[Gerald Klein]

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 at 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 at 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 at 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 at 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 <http://geraldklein.com/>****
>>>
>>> jk at 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 <http://geraldklein.com/>****
>
> jk at 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 <http://geraldklein.com/>****

jk at zognet.com****

708-599-0352****


Linux registered user #548580
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120325/fd81ee40/attachment.html