PHPBuilder - Create an LDAP Address Book Page 3



RSS Twitter
Articles Php Functions

Create an LDAP Address Book - Page 3

by: Dannie Stanley
|
February 6, 2001

Format Output

When an LDAP search is performed, the data is returned in whatever sequence it is found. In other words, there is not an easy way to sort the data like with a common SQL ORDER BY statement. As well, many public LDAP directories do not have standard capitalization. Since the sort is based on the ASCII value of the strings, we must format the strings with all lowercase letters to appropriately alphabetize our output.
It is important to note, that an LDAP result set is returned as a multi-dimensional array. Thus, at this point in our script $result_array contains something like this:
$result_array[0]["cn"]       [0] = "Dannie Stanley"
                ["dn"]       [0] = "uid=dannie,dc=spinweb.net"
                ["givenname"][0] = "Dannie"
                ["sn"]       [0] = "Stanley"
                ["mail"]     [0] = "danSPAM@spinweb.net"
$result_array[1]["cn"]       [0] = "Michael Reynolds"
                ["dn"]       [0] = "uid=michael,dc=spinweb.net"
                ["givennam""][0] = "Michael"
                ["sn"]       [0] = "Reynolds"
                ["mail"]     [0] = "michaelSPAM@spinweb.net"     
The data is stored in this format because each attribute may have more than one value (IE a tree structure). For example, if my name is 'Dannie,' yet everyone knows me as 'Dan,' I could add an attribute to LDAP to store both representations of my given name like this:
$result_array[0]["cn"]       [0] = "Dannie Stanley"
                ["dn"]       [0] = "uid=dannie,dc=spinweb.net"
                ["givenname"][0] = "Dannie"
        		["givenname"][0] = "Dan"
                ["sn"]       [0] = "Stanley"
                ["mail"]     [0] = "danSPAM@spinweb.net"
For this search, we are only worried about the first value of every attribute so we will be using 0 as the index for each attribute, except for dn (Distinguished Name), which contains only one value. Here is a brief list of attributes and their meaning:
cn
Common Name
dn
Distinguished Name
givenname
First Name
sn
Last Name
mail
Email Address

<?php

//Sort results if search was successful
if($result_array)
  {
  for(
$i=0$i<count($result_array); $i++)
    {
    
$format_array[$i][0] = strtolower($result_array[$i]["cn"][0]);
    
$format_array[$i][1] = $result_array[$i]["dn"];
    
$format_array[$i][2] = strtolower($result_array[$i]["givenname"][0]);
    
$format_array[$i][3] = strtolower($result_array[$i]["sn"][0]);
    
$format_array[$i][4] = strtolower($result_array[$i]["mail"][0]);
    }

  
//Sort array 
  
sort($format_array"SORT_STRING");

  for(
$i=0$i<count($format_array); $i++)
    {
    
$cn $format_array[$i][0];
    
$dn $format_array[$i][1];
    
$fname ucwords($format_array[$i][2]);
    
$lname ucwords($format_array[$i][3]);
    
$email $format_array[$i][4];

    if(
$dn && $fname && $lname && $email)
      {
      
$result_list .= "<A HREF=\"ldap://$LDAP_SERVER[$SERVER_ID]/$dn\">$fname $lname</A>";
      
$result_list .= " &lt;<A HREF=\"mailto:$email\">$email</A>&gt;<BR>\n";
      }
    elseif(
$dn && $cn && $email)
      {
      
$result_list .= "<A HREF=\"ldap://$LDAP_SERVER[$SERVER_ID]/$dn\">$cn</A>";
      
$result_list .= " &lt;<A HREF=\"mailto:$email\">$email</A>&gt;<BR>\n";     
      }
    }
  }
else
  {
  echo 
"Result set empty for query: $ldap_query";
  }

  
?>
In our example, $format_array is our new array which contains the query results in a format optimized for output. First, we loop through every element of the $result_array and assign it to a two-dimensional array for sorting purposes. At the same time we are using the strtolower() function to make all values lower-case.
Second, we sort the array using a handy little search algorithm provided by PHP called sort(). The first argument is the array. The second is what type of sorting to perform, as defined by the PHP documentation. Since we are sorting by string, we use "SORT_STRING".
Third, we loop through the newly formatted array and assign it to an output string named $result_list that contains the HTML representation of the data. It is important to note that I have used the ldap URL format for the hyper-links. An example of this looks something like this: HREF="ldap://ldap.domain.net/uid=dannie,dc=domain.net".

Close Connection

Now that we have all of our data contained in $result_list, we can safely disconnect from the LDAP connection.

<?php

//Close Connection
ldap_close($connect_id);

?>

« Previous Page
1
|
2
|
3
|
4
Next Page »

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:
Dannie Stanley

Comment:



Comment:

(Maximum characters: 1200). You have characters left.