[support] Database connection

[Awtar Singh]

On IIS try : 

realpath(basename(getenv("SCRIPT_NAME")));

This will return the full script path. Hope this helps.

Sent from my iPhone

On Mar 25, 2012, at 6:13 PM, Gerald Klein <jk at zognet.com> wrote:

> 
> 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
>> 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
>> 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
> jk at zognet.com
> 708-599-0352
> 
> Linux registered user #548580
> 
> 
> -- 
> [ Drupal support list | http://lists.drupal.org/ ]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120325/e22a4030/attachment-0001.html