90 likes | 223 Vues
This agenda outlines essential procedures for integrating PHP/MySQL with images, LDAP access, and jQuery for seamless web applications. It emphasizes database management, granting permissions, and executing scripts for document handling. Key examples demonstrate LDAP logins and jQuery functionalities, focusing on event handling, document traversal, and AJAX interactions. The document provides links to additional resources including JavaScript libraries and guides for mobile app development. Follow this structured approach to enhance your web development skills effectively.
E N D
Miscellaneous Week 13 INFM 603
Agenda • Images PHP/MySQL • LDAP • jQuery
Images in with PHP/MySQL • Before running following example make sure • Drop table “docs” in database myDB; • grant all on myDB.docs to student@localhost identified by “goodbyeWorld”; • Example: (ImagesEx1 Folder) • Execute scripts in the following order: • creatingDocumentsTable.php, • insertingDocument.php, • retrievingDocument.php • Example: (ImagesEx2 Folder) • Access retrievingDocumentForm.html
LDAP Access • Campus ldap logins • http://www.cs.umd.edu/faq/ldaphtaccess.html • Example: • http://www.cs.umd.edu/~nelson/LDAP/
jQuery • JavaScript library that allows • Event Handling • HTML document traversing • Ajax Interactions • Main site • http://jquery.com/ • Example from JQuery site • $("p.neat").addClass("ohmy").show("slow"); • You can execute it by visiting the jQuery site
jQuery Fundamentals • You need access to the jQuery library by either downloading it or relying on other mechanism (e.g. Google’s CDN) • Next statement allow us to wait until the document is ready to be manipulated (DOM is fully loaded) $(document).ready(function() { // this is the ready event }); • The above code should appear in a .js file that is included the main html file • Example: jQueryBasics.html
jQuery • List of events • http://api.jquery.com/category/events/ • Shortcut for $(document).ready • http://docs.jquery.com/Tutorials:Multiple_%24%28document%29.ready%28%29 • General documentation • http://docs.jquery.com/Main_Page
JQuery User Interfaces • JavaScript library based on Jquery • http://jqueryui.com/ • Example: DatePicker.html • See Demos • http://jqueryui.com/demos/
Additional Info • http://jquerymobile.com/ • References (via Safari online) • iPhone Apps • http://proquest.safaribooksonline.com/book/programming/iphone/9781449380236 • Android Apps • http://proquest.safaribooksonline.com/book/programming/android/9781449399122