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--jerryOn Sun, Mar 25, 2012 at 8:49 AM, Awtar Singh <asingh@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 iPhoneOn IIS try :realpath(basename(getenv("SCRIPT_NAME")));This will return the full script path. Hope this helps.
Sent from my iPhoneHi, 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 = <<<EODSELECT t1.field_req_a_quote_email_value, t2.field_req_a_quote_email_subject_valueFROM field_data_field_req_a_quote_email t1INNER JOIN field_data_field_req_a_quote_email_subject t2 ON t1.entity_id = t2.entity_idAND t1.revision_id = t2.revision_idLIMIT 1EOD;$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 SinghExecutive DirectorQuantum Coders LLC
Sent from my iPhoneI 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 D6On 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
Linux registered user #548580
--
[ Drupal support list | http://lists.drupal.org/ ]
--
Regards,
Vaibhav Jain
--
[ Drupal support list | http://lists.drupal.org/ ]--
Gerald Klein DBA
Linux registered user #548580
--
[ Drupal support list | http://lists.drupal.org/ ]--
Gerald Klein DBA
Linux registered user #548580
--
[ Drupal support list | http://lists.drupal.org/ ]--
Gerald Klein DBA
Linux registered user #548580