Home » Drupal Collection

Creating a "Biographies" page

I used the Profile moduleAn add-on, or extension, to Drupal to provide additional functionality; written in PHP. to add a multi-line field called "Interests," and a URL field called "My Web SiteA logically grouped set of content - also web site. or Biography LinkThe technique which points to another page, anywhere on the Internet, from the current page.." There are also fields for first and last names, city, state, and zip codes. This page also includes the user's picture if they loaded one.

I create a simple table with the class="even" and class="odd" to separate the rows. The user's web siteA logically grouped set of content - also web site. linkThe technique which points to another page, anywhere on the Internet, from the current page. is a bit smaller than normal text, but includes target="_blank" so your users stay on your siteA logically grouped set of content - also web site..

<p>This page is intended to give you an introduction to the members of xxxxx.  The information is filled in by the members themselves in their &quot;My Account&quot; page. In order to appear on this list you must have logged in at least once.</p>

<?php
print('<table width="100%"><caption><b>XXXXX Member Biographies</b></caption>'."\n");

$header = array(
  array('data' => t('Username'), 'field' => 'u.name', 'sort' => 'asc'),
  array('data' => t('Photo')),
  array('data' => t('Name')),
  array('data' => t('Location')),
  array('data' => t('Member since')),
  array('data' => t('Interests/Bio'))
);
$sql = "SELECT u.uid, u.name FROM {users} u";
$sql .= tablesort_sql($header);
$result = pager_query($sql, 50);
$oddrow = 1;

while ($account = db_fetch_object($result)) {
   $account = user_load(array('uid' => $account->uid));

if ($account->uid > 1) {
   if ($account->picture){$account->picture = '<img src="/'.$account->picture.'" height="100" width="100" border="0" alt="'.$account->name.'">';}
    else {$account->picture = '<img src="/files/pictures/KB/bodYou.gif" height="100" width="100" border="0" alt="no picture found">';}

  $fullname = $account->profile_firstname . " " . $account->profile_lastname;

  if ($account->profile_interests) {$interests = $account->profile_interests;}
  else {$interests = "No biography provided";}

  if ($account->profile_biolink) {$interests .= '<br><small><a href="' . $account->profile_biolink
                                         . '" target="_blank">' . $fullname . "'s web site</a></small>";}
  if ($account->profile_city) {$location = $account->profile_city . ", "
                                 . $account->profile_state . " " . $account->profile_zip;}
  else {$location = "No location provided";}
 
  if ($oddrow == 1) {print ('<tr class="odd">'); $oddrow = 0;}
  else {print ('<tr class="even">'); $oddrow = 1;}

  print ('<td align="center">' . $fullname . "<br>" . $account->picture . "<br>" . "</td> \n"
      . '<td align="center"><small>' . $location . "</small></td> \n"
      . "<td>Member since " . date('F Y', mktime(0, 0, 0, $account->profile_date_joined['month'],
                               $account->profile_date_joined['day'],
                               $account->profile_date_joined['year']))
      . ". " . $interests . "</td></tr> \n");
  print ($row);
}
}

print ("</table>\n");
?>
‹ Create Simple TablesupDeveloping a Module on a Windows System ›
»

Which file should i modify

Submitted by pantasmanik (not verified) on Mon, 06/16/2008 - 23:07.

Hi Nancy i dont know which file should modify?

»

New page

Submitted by admin on Mon, 07/21/2008 - 14:41.

You put this code into a PHPRecursive acronym for "PHP: Hypertext Preprocessor" - is a widely-used Open Source general-purpose scripting language that is especially suited for Web development and can be embedded into HTML. formatted page. There is no file to modify.

»