Jump to content

I want to create an Access like interface


aeroswat

Recommended Posts

I want to be able to create an access like interface where I have textboxes and drop down boxes on the screen that are able to be typed into and then the results are displayed through the same thing. So say you have a database with 6 text fields in it and you want to search by field 3. You would type in a string in textbox 3 and click the search button. It would then store the resulting rows in an array and display the first one in the text/drop down boxes. From there you could press a forward button or backward button to cycle through the rows just like you would in access. Has this been done many times before? Is there a tutorial on going about what I want to accomplish out there or can anyone help me get started please? :)

Link to comment
Share on other sites

You'll need JavaScript and Ajax to achieve the dynamic modification. Because access works with multiple databases you'll also need PDO or ODBC on the server side. JSON or XML for communication between client and server. Because today most JS libraries incorporate Design Patterns (UI) like on YDN(1) you will be able to create a rather complex UI quite easily. Adding the appropriate functionality (js user functions) creates your Access clone.

 

Happy Coding ;)

 

1. http://developer.yahoo.com/ypatterns/

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.