[support] Inserting php block snippet into a standard node

[Metzler, David]

Yep, id agree use "print theme.... " not return.  

While you're at it----

SELECT uid, init FROM dru_users WHERE 
>> dru_users.uid = %s

Should probably be %d (since uid is a number), and the DBQuery call has
an appropriate syntax to
To take any multi-site config into account....

SQL should read:  
  SELECT uid, init FROM {users} WHERE uid = %d

-----Original Message-----
From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of Laura Scott
Sent: Friday, May 04, 2007 3:01 PM
To: support at drupal.org
Subject: Re: [support] Inserting php block snippet into a standard node

Maybe I'm missing something in your question, but "return" is going to
end reading of the file. If you want stuff after it, try print or echo.

Laura

On May 4, 2007, at 3:09 PM, Neil: esl-lounge.com wrote:

> I'm getting exactly the same problem with that code too. Getting the 
> information to show (in this case, just a simple e-mail address) is 
> not the problem. I got that bit working with my original code. The 
> problem is that the content stops at the point in the page where I 
> post the php snippet.
> Everything before it shows and nothing after it.
>
> Why would that be? It's in standard php tags and the input format is 
> php too.
>
> ----- Original Message -----
> From: "Jason Flatt" <drupal at oadaeh.net>
> To: <support at drupal.org>
> Sent: Friday, May 04, 2007 2:49 PM
> Subject: Re: [support] Inserting php block snippet into a standard 
> node
>
>
>> On Friday May 4 2007 3:30 am, Neil: esl-lounge.com wrote:
>>> I am creating a dynamic newsletter using the simplenews module and 
>>> php block snippets. I've got the overall mechanics working well.
>>>
>>> I create the newsletter, say /newsletter/05-may-07 which has 
>>> standard header and footer text which goes out to every person. Then

>>> my idea is to insert location-based content into it so that Jane 
>>> from Texas sees "Last five members from Texas", "Last five posts 
>>> from Houston", "Five members who go to your school" and so on. Chris

>>> from London would see different content.
>>>
>>> The problem I've hit though is that when I insert the block snippet 
>>> into the node, choose PHP as input format and press "Submit", none 
>>> of the content below the snippet shows. Here is my snippet:
>>>
>>> <?php
>>> global $user;
>>> $result=db_query("SELECT dru_users.uid, dru_users.init FROM 
>>> dru_users WHERE (dru_users.uid = $user->uid)"); while ($u = 
>>> db_fetch_object
>>> ($result)) {
>>> $items[]=l($u->init, "user/" . $u->uid); } return 
>>> theme('item_list',$items); ?>
>>>
>>> This is just a test snippet to test the concept....in a block, it 
>>> shows the current user's e-mail address. It also does this in a 
>>> node, but as I say, the rest of the content below this code doesn't 
>>> come through.
>>>
>>> Any idea what the problem is?
>>
>> Try it this way:
>>
>> <?php
>>  global $user;
>>  $result=db_query("SELECT uid, init FROM dru_users WHERE 
>> dru_users.uid = %s", $user->uid);
>>
>>  while ($u = db_fetch_object($result)) {
>>    $items[]=l($u->init, "user/" . $u->uid);  }
>>
>>  return theme('item_list',$items);
>> ?>
>>
>> I'm assuming your database tables have a prefix, thus the "dru_"  
>> before
>> the "users" in the table name.
>>
>> BTW, sorry about the other post. I meant to close it and sent it 
>> instead.
>>
>> --
>> Jason Flatt
>> http://www.oadaeh.net/
>> Father of Six:  http://www.flattfamily.com/ (Joseph, 13; Cramer, 11; 
>> Travis, 9; Angela; Harry, 5; and William, 12:04 am, 12-29-2005)
>> Linux User:     http://www.kubuntu.org/
>> Drupal Fanatic: http://drupal.org/
>> --
>> [ Drupal support list | http://lists.drupal.org/ ]
>>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]

--
[ Drupal support list | http://lists.drupal.org/ ]