[support] Database connection

[Awtar Singh]

Excellent!

Awtar singh
Quantum Coders LLC

www.quantum-coders.com

Sent from my iPhone

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

> I'm on Apache so I'm good, but I also had to send mail and it got to be a real pain, so what I figured out instead of all this pain. Is create a basic page give page a custom url 'page-name' create a page suggestion like page--page-name.tpl.php strip out the html completely then include your php ajax code. This gives you access to all that drupal has to offer with out going through what I just went through.Yipee!! 
> 
> thanks again for your posts 
> 
> --jerry
> 
> On Sun, Mar 25, 2012 at 8:49 AM, Awtar Singh <asingh at quantum-coders.com> wrote:
> Or you can use a config file and set the docroot in there using below command and include it once.
> 
> Sent from my iPhone
> 
> On Mar 25, 2012, at 6:46 PM, Awtar Singh <asingh at quantum-coders.com> wrote:
> 
>> 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/ ]
> 
> --
> [ 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/7d5a9f55/attachment.html