In the future, please keep unrelated assignments in different questions. The only reason you did not receive the Apartment question update hours ago is because you added the ldap assignment.
I will send you want I have for the LDAP assignment, but I cannot guarantee that it will work. As far as the apartment project goes or the database goes, I am a certified professional. Literally, I am a Zend Certified Engineer with many years of experience.
LDAP is a network administration thing, and I know nothing about it. So installing OpenLDAP and testing these scripts is beyond my expertise. I'm certain that you probably received or have access to exhaustive instructions through your course about setting up your localhost for Open LDAP. But I don't have those and setting up an LDAP server on your computer is not a programming task or a task that most programmers would be familiar with. It it is a task usually handled by network/system administrators. And that is not my expertise whatsoever.
So, I'm just saying. I did not successfully get LDAP set up on my computer and could not test these scripts. As far as part two goes, you are not correct about needing that script. The code that you need was provided in the word document that you sent me. It uses an LDAP server on your school's network, which is the jist of #2. Also, the point of this is to pass the username and password XXXXX from a form. I have successfully created those forms for you, but, again, I have not tested. Honestly, I would never take on a question concerning LDAP, but you bundled it with a project I was already working with you on.
Here are the files for that one. I don't know if you have OpenLDAP successfully installed on your computer or not. But without the instructions that are undoubtedly provided through your course, it is a massive pain (it is probably a massive pain with the instructions too). Oh, and LDAP functions will not work in WAMP unless you do a bunch of stuff to get it to work. Simply turning onthe module will not work. You have to move some DLL files around. But perhaps you run everything on your school server and are not expected to run your own LDAP server and worry about all the things that i had to worry about. In which case, it is another reason why I cannot test this.
Now for the Apartment assignment, which is a subject in which I am an actual expert (Database-driven web applications). You can download the updated site here:
Within the zip file, you will find a file called alter.sql. You need to run these alter statements in your database. I mad these changes so that it would be easier to display the data on the web site.
Within the files, open up Database.class.php
At the top, you will find four constant definitions. These are your database connection parameters. You can see that it currently is set up to use localhost, a user name of root, and no password. If your system uses different credentials, then change them here. You should not change anything else in this file.
The one comment about the email address field being highlighted red is simply silly. That functionality is part of the browser, not your validation code. That filed is an HTML5 email field. IE will turn it red. If your instructor does not like receiving a red box with no message, he should contact Microsoft and complain about their implementation of HTML5. If you attempt to submit the form with a bad email address, a message is displayed.
Per the requirements, you can view all offered apartments and requested apartments. This is all assuming that your database is set up correctly. If not, the page will throw errors and you can let me know so that we can work it out.
Let me know if you have any questions about any of the Apartment project functionality. I would be happy to explain anything.
I apologize that I couldn't be more help with the LDAP assignment, but I never work woth LDAP. I've worked with dozens of programmers, and not one of them has ever worked with LDAP. I would have opted out of the assignment had it not been bundled with the apartment project that you and I have been working on together. I hope the files work for you, but I certainly wouldn't take my word for it. I hope you understand.
I do believe that your instructor will be impressed with your PHP database implementation. I'm certain he will come up with some unnecessary criticism, as he apears to enjoy that. But you should receive a good grade nonetheless.
Please remember to rate my answer, at least based on the work done for the apartment project. You may come back here and asked follow up questions at any time, before or after leaving a rating.