<html><head></head><body bgcolor="#FFFFFF"><div>Or you can use a config file and set the docroot in there using below command and include it once.<br><br>Sent from my iPhone</div><div><br>On Mar 25, 2012, at 6:46 PM, Awtar Singh <<a href="mailto:asingh@quantum-coders.com">asingh@quantum-coders.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div><div>On IIS try : </div><div><br></div><div><span class="Apple-style-span" style="-webkit-tap-highlight-color: rgba(26, 26, 26, 0.292969); -webkit-composition-fill-color: rgba(175, 192, 227, 0.230469); -webkit-composition-frame-color: rgba(77, 128, 180, 0.230469); ">realpath(basename(getenv("SCRIPT_NAME")));</span></div><div><br></div><div>This will return the full script path. Hope this helps.</div><div><br>Sent from my iPhone</div><div><br>On Mar 25, 2012, at 6:13 PM, Gerald Klein <<a href="mailto:jk@zognet.com">jk@zognet.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div><div><br></div><div>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.</div>
<div><br></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>$docroot = getenv("DOCUMENT_ROOT");</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>require_once $docroot . '/includes/bootstrap.inc';</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>drupal_bootstrap(DRUPAL_BOOTSTRAP_DATABASE, false);<span class="Apple-tab-span" style="white-space:pre"> </span></div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>require_once $docroot . '/sites/default/settings.php';<span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>global $databases;</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div><span class="Apple-tab-span" style="white-space:pre"> </span>$username = $databases["default"]["default"]["username"];</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>$password = $databases["default"]["default"]["password"];</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>$database = $databases["default"]["default"]["database"];</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>$host = $databases["default"]["default"]["host"];</div><div><span class="Apple-tab-span" style="white-space:pre"> </span></div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span></div><div> mysql_connect("$host", "$username", "$password");</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>mysql_select_db("$database");</div>
<div> </div><div> </div><div> </div><div> </div><div>$sql = <<<EOD</div><div>SELECT t1.field_req_a_quote_email_value, t2.field_req_a_quote_email_subject_value</div><div>FROM field_data_field_req_a_quote_email t1</div>
<div>INNER JOIN field_data_field_req_a_quote_email_subject t2 ON t1.entity_id = t2.entity_id</div><div>AND t1.revision_id = t2.revision_id</div><div>LIMIT 1</div><div>EOD;</div><div><br></div><div> $array = Array(); </div>
<div> </div><div> $result = mysql_query($sql);</div><div> </div><div> </div><div> while ($row = mysql_fetch_object($result)) {</div><div> $array['email']=$row->field_req_a_quote_email_value;</div>
<div> $array['subject']=$row->field_req_a_quote_email_subject_value;</div><div> }</div><div> </div><div> </div><div><span class="Apple-tab-span" style="white-space:pre"> </span>mysql_free_result($result);</div>
<br><div class="gmail_quote">On Sun, Mar 25, 2012 at 1:50 AM, Awtar Singh <span dir="ltr"><<a href="mailto:asingh@quantum-coders.com">asingh@quantum-coders.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF"><div>Gerald -</div><div><br></div><div>Add period before <span>/includes/bootstrap.inc if you are executing the script from the Web root.</span></div><div><span><br></span></div><div><span>Or please give the exact error that you are getting.</span></div>
<div><span><br></span></div><div><span>Regards,</span></div><div><span><br></span></div><div><span>Awtar Singh</span></div><div><span>Executive Director</span></div><div><span>Quantum Coders LLC</span><br></div><div><span><br>
</span></div><div><span><a href="http://www.quantum-coders.com" target="_blank">www.quantum-coders.com</a></span><br></div><div><span> </span></div><div>Sent from my iPhone</div><div><br>On Mar 25, 2012, at 8:47 AM, Gerald Klein <<a href="mailto:jk@zognet.com" target="_blank">jk@zognet.com</a>> wrote:<br>
<br></div><div></div><blockquote type="cite"><div><div>I tried this and also included the define statement for the variable that require_once is using and it errors out including bootstrap.inc.</div><div>It needs something else. </div>
<div><br></div><div>thanks for your post, anyone else?</div>
<div><br></div><div><br></div><div>define('DRUPAL_ROOT', getcwd());</div><div><br></div><div>require_once DRUPAL_ROOT . '/includes/bootstrap.inc';</div><div>drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);</div><div>
<br></div><br><div class="gmail_quote">On Sat, Mar 24, 2012 at 10:12 PM, Vaibhav Jain <span dir="ltr"><<a href="mailto:in.vaibhavjain@gmail.com" target="_blank">in.vaibhavjain@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Just paste these 2 lines in you external file<br><br>require_once './includes/bootstrap.inc';<br>drupal_bootstrap(DRUPAL_BOOTSTRAP_FULL);<br><br>these are also included in index.php. These are for D6<br><br><div class="gmail_quote">
On Sun, Mar 25, 2012 at 8:28 AM, Gerald Klein <span dir="ltr"><<a href="mailto:jk@zognet.com" target="_blank">jk@zognet.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi I need to pull a dataset in an ajax file. What drupal includes to I need to use the drupal db connection. <div><br></div><div>thanks any help is appreciated</div><div><br></div><div>--jerry<span><font color="#888888"><br clear="all">
<div><br></div>
-- <br><span style="border-collapse:collapse"><p style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><span style="border-collapse:collapse;font-size:small;font-family:arial"></span></p>
<p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">Gerald Klein DBA<u></u><u></u></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
<a href="http://geraldklein.com/" style="color:rgb(17,85,204)" target="_blank">www.geraldklein.com</a><u></u><u></u></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
<a href="mailto:jk@zognet.com" style="color:rgb(17,85,204)" target="_blank">jk@zognet.com</a><u></u><u></u></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
<a value="+17085990352" style="color:rgb(17,85,204)">708-599-0352</a><u></u><u></u></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
</p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><br></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
Linux registered user #548580</p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><br></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
<br></p></span><span><font color="#888888">
</font></span></font></span></div><span><font color="#888888">
<br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></font></span></blockquote></div><span><font color="#888888"><br><br clear="all"><br>-- <br>Regards,<br>
Vaibhav Jain<br>
</font></span><br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="border-collapse:collapse"><p style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
<span style="border-collapse:collapse;font-size:small;font-family:arial"></span></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
Gerald Klein DBA<u></u><u></u></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><a href="http://geraldklein.com/" style="color:rgb(17,85,204)" target="_blank">www.geraldklein.com</a><u></u><u></u></p>
<p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><a href="mailto:jk@zognet.com" style="color:rgb(17,85,204)" target="_blank">jk@zognet.com</a><u></u><u></u></p>
<p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><a value="+17085990352" style="color:rgb(17,85,204)">708-599-0352</a><u></u><u></u></p>
<p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
<br></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">Linux registered user #548580</p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
<br></p></span><span class="HOEnZb"><font color="#888888">
</font></span></div></blockquote><span class="HOEnZb"><font color="#888888"><blockquote type="cite"><div><span>-- </span><br><span>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]</span></div>
</blockquote></font></span></div><br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="border-collapse:collapse"><p style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
<span style="color:rgb(0,0,0);font-family:arial;font-size:small;border-collapse:collapse"></span></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
Gerald Klein DBA<u></u><u></u></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><a href="http://geraldklein.com/" style="color:rgb(17,85,204)" target="_blank">www.geraldklein.com</a><u></u><u></u></p>
<p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><a href="mailto:jk@zognet.com" style="color:rgb(17,85,204)" target="_blank">jk@zognet.com</a><u></u><u></u></p>
<p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><a value="+17085990352" style="color:rgb(17,85,204)">708-599-0352</a><u></u><u></u></p>
<p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
<br></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">Linux registered user #548580</p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px">
<br></p><p style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><br></p></span>
</div></blockquote><blockquote type="cite"><div><span>-- </span><br><span>[ Drupal support list | <a href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]</span></div></blockquote></div></blockquote></body></html>