Databases
StackOverflow2013
Postsdbo
POSimple LDAP Search with PHP JQuery
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSimple LDAP Search with PHP JQuery
    primarykey
    data
    text
    <p>I want to do a simple ajax search of LDAP (or AD) using PHP and JQuery. I have read a number of tutorials that search mysql, such as:</p> <p><a href="http://www.codeforest.net/simple-search-with-php-jquery-and-mysql" rel="nofollow">http://www.codeforest.net/simple-search-with-php-jquery-and-mysql</a></p> <p>I want to replace the mysql connection with my ldap connection details details below. Could someone help me out in getting this to work as I cant get the results to display.</p> <p>Thanks</p> <p>LDAP Connection script</p> <pre><code> &lt;?php echo "&lt;?xml version='1.0' encoding='utf-8' ?&gt;" ?&gt;&lt;?php echo "&lt;ul class='LSRes'&gt;" ?&gt; &lt;?php if( isset($_GET['q']) &amp;&amp;!empty($_GET['q']) ){ // all your ldap code // Designate a few variables $host = "10.10.10.10"; // Add in your AD host name or IP $user = "DOMAIN\user"; // Add in your AD access account user name $pswd = "password"; // Add in your AD access account user name password $ad = ldap_connect($host) or die( "Could not connect!" ); // Set version number ldap_set_option($ad, LDAP_OPT_PROTOCOL_VERSION, 3) or die ("Could not set ldap protocol"); // Binding to ldap server $bd = ldap_bind($ad, $user, $pswd) or die ("Could not bind"); // Create the DN - Add in the OU of your AD $dn = "OU=accounts,DC=domain,DC=com"; // Specify only those parameters we're interested in displaying from AD $attrs = array("displayname","mail","samaccountname","telephonenumber","givenname", "title"); //$attrs = array("samaccountname"); // Create the filter from the search parameters //$filter = "(|(givenName=".$_GET['q']."*) (sn=".$_GET['q']."*) (displayname=".$_GET['q']."*) (samaccountname=".$_GET['q']."*) (telephonenumber=".$_GET['q']."*))"; $filter = "(|(givenName=".$_GET['q']."*) (sn=".$_GET['q']."*) (displayname=".$_GET['q']."*) (samaccountname=".$_GET['q']."*))"; $search = ldap_search($ad, $dn, $filter, $attrs) or die ("&lt;span class='LSstyle_noresults'&gt;&lt;strong&gt;Could not connect to AD&lt;/strong&gt;&lt;/span&gt;"); // Sort entries by last name ('sn') ldap_sort ( $ad, $search, 'sn' ) ; //ldap_sort ( $ad, $search, $samaccountname ) ; $entries = ldap_get_entries($ad, $search); if ($entries["count"] &gt; 0) { for ($i=0; $i&lt;$entries["count"]; $i++) { echo "&lt;span class='LSstyle'&gt;Name: &lt;strong&gt;&lt;a href=\"mailto:".$entries[$i]["mail"][0]."\"&gt;".$entries[$i]["displayname"][0]." ".$entries[$i]["sn"][0]."&lt;/a&gt;&lt;/strong&gt;&lt;/span&gt;&lt;br /&gt;"; echo "&lt;span class='LSstyle'&gt;Short name: &lt;strong&gt;".$entries[$i]["samaccountname"][0]."&lt;/strong&gt;&lt;/span&gt;&lt;br /&gt;"; echo "&lt;span class='LSstyle'&gt;Phone: &lt;strong&gt;".$entries[$i]["telephonenumber"][0]."&lt;/strong&gt;&lt;/span&gt;&lt;br /&gt;"; echo "&lt;span class='LSstyle'&gt;Title: &lt;strong&gt;".$entries[$i]["title"][0]."&lt;/strong&gt;&lt;/span&gt;&lt;br /&gt;"; echo "&lt;span class='LSstyle'&gt;Dept: &lt;strong&gt;".$entries[$i]["department"][0]."&lt;/strong&gt;&lt;/span&gt;&lt;/p&gt;"; } } else { echo "&lt;span class='LSstyle_noresults'&gt;&lt;strong&gt;No results found&lt;/strong&gt;&lt;/span&gt;"; } ldap_unbind($ad); } ?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USMat
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POSimple LDAP Search with PHP JQuery
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSimple LDAP Search with PHP JQuery
      1. UShawx
      1. VTFavorite
    3. VO
      singulars
      1. POSimple LDAP Search with PHP JQuery
      1. This table or related slice is empty.
      1. VTUpMod
    1. CONo soon have I posted and I solved it. In the script on codeforest.com it uses POST and instead of GET. Then just changed the 'search' string to q.
      singulars
      1. POSimple LDAP Search with PHP JQuery
      1. USMat
    2. COGood to hear you tracked it down! Please paste the solution in the answer box and mark the answer as accepted to drop the question out of the active list.
      singulars
      1. POSimple LDAP Search with PHP JQuery
      1. USquickshiftin
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload