dhanesh1405241511 0 Report post Posted July 17, 2006 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: Now .. I have a HTML page that shows this : 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 : 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
dhanesh1405241511 0 Report post Posted July 18, 2006 Arggggg ... Is the no one who can help this little code troubled .. frustrated .. irritated .. kid ! :unsure:RegardsDhanesh. Share this post Link to post Share on other sites
souradipm 0 Report post Posted July 18, 2006 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
dhanesh1405241511 0 Report post Posted July 18, 2006 (edited) 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 .. 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 Edited July 18, 2006 by dhanesh (see edit history) Share this post Link to post Share on other sites
souradipm 0 Report post Posted July 18, 2006 (edited) OK dhanesh,I found a good database class library compatitable with access:http://forums.xisto.com/no_longer_exists/It uses PHP.Sorry if I was rude to you or anything,souradipm Edited July 18, 2006 by souradipm (see edit history) Share this post Link to post Share on other sites
dhanesh1405241511 0 Report post Posted July 20, 2006 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
iGuest 3 Report post Posted April 25, 2009 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
iGuest 3 Report post Posted April 12, 2011 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
iGuest 3 Report post Posted January 21, 2013 your explanation good but i need the coding to connect html to access Share this post Link to post Share on other sites
yordan 10 Report post Posted January 21, 2013 your explanation good but i need the coding to connect html to accessyou should say "please" if you want people to be kindly answer your request Share this post Link to post Share on other sites