Jump to content
xisto Community
dhanesh1405241511

MS Access DB To Webpage Connection ?

Recommended Posts

ok .. i have this little problem i am going through ... Leme explain this project of mine first .

 

I have a MS Access DB of student fields like ID no, Name, Marks .. etc .. This one Access DB would be updated by just adding more rows and would be done on the server. It looks sumthing like this:

 

Posted Image

 

Now .. I have a HTML page that shows this :

Posted Image

 

I would enter the ID number of a student (no authentication .. anyone can access anybodys marks), and when i hit submit .. I would be taken to a page that gets the values from the ID specified and shows it in the next page. The page design would be the same .. just the values comming in will depend on the ID number inputed in the previous screen.

 

The result should be something like this :

 

Posted Image

 

Is it possible to make a system like this ? To test this .. i will be using my own asta account .. so i guess if it works here .. then this system can be accessed from anywhere. Secondly, what language would be used ? HTML, PHP or ASP .. i'd preffer HTML .. but since HTML doesnt allow dynamic updating .. i am fine with PHP. But it would be nice if someone helped me out with this.

 

I think ..

Page1 : Enter ID ---> HTML

Page2 : Show results ---> PHP

DB : MS Access ..

 

Hope i didnt confuse, if so please let me know .. i'll try to explain in a better way if i can.

 

Regards

Dhanesh.

Share this post


Link to post
Share on other sites

First of all, please do not double post. Second, you could put this data in a MySQL database and have a php page which downloads and checks information.

 

How the script should work:

 

A page called main.php (or whatever filename you want) should check if the student id exists, then go to results.php (or whatever filename you want). Then it should download the data from the database and show the details. Then it checks if the marks are higher then 75(or the pass level) and it displays "PASS!" or "FAIL!".

 

I suggest you google a good mysql and php tutorial.

 

Hope this helps,

souradipm

Share this post


Link to post
Share on other sites

With much due respect (which by the way, u didnt have) , it wasent a double post with an intention to spam. A double post is considered ONLY if someone makes a consecutive post in a span of say 1 hr or 2 .. depending on the forum rules.

 

Now, for the post you made, it was EXACTLY the same thing i asked as a question. I know how it would work, I just need some code to get me started. And yes, i have gone to php sites and searched for this, but i was unable to get a decent tutorial.

 

Well, so next time please do not repeat the posts in your own words to gain points :unsure: ..

 

Regards

Dhanesh.

 

Edit: I know it can be done in MySQL, and i have a working model, but my specifics include an MS Access DB :D

Edited by dhanesh (see edit history)

Share this post


Link to post
Share on other sites

Ok well i decided to go with PHP since access was not a good idea ... i created a few things in php and mysql .. but it shure hell is driving me nuts .. will post a new topic with my experiments :unsure:RegardsDhanesh.

Share this post


Link to post
Share on other sites
ACCESSdb JavaMS Access DB To Webpage Connection ?

You are able to connect toMicrosoft Access using JavaScript when the HTML file is run locally andThe Access .Mdb file is accessible to the file system.  In rare cases, this can be a very cool thing...

I had a situation where this functionality was actually useful, so IWrote a JavaScript library to simplify the process. I had a great dealOf difficulty finding information or examples of how to connect toAccess, so I decided to share my codewith the world... The library is called ACCESSdb and you can get it here!

-reply by faulkj

 

Share this post


Link to post
Share on other sites
regarding the DB access.............MS Access DB To Webpage Connection ?

Hi Dhanesh,

I'm srinivas. I'm expecting the codes to access datas from the same DB you are currently using... Also need the codes for writing the datas to the same database.. Could you pls provide me the datails.

This is my ID : malu_siva123@yahoo.Com

I'm expecting your reply. Pls help me here!

-reply by srinivas

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | 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.