dhanesh
Jul 17 2006, 11:44 AM
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.
Comment/Reply (w/o sign-up)
dhanesh
Jul 18 2006, 05:04 PM
Arggggg ...  Is the no one who can help this little code troubled .. frustrated .. irritated .. kid !  Regards Dhanesh.
Comment/Reply (w/o sign-up)
souradipm
Jul 18 2006, 06:00 PM
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
Comment/Reply (w/o sign-up)
dhanesh
Jul 18 2006, 07:01 PM
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
Comment/Reply (w/o sign-up)
souradipm
Jul 18 2006, 07:43 PM
OK dhanesh, I found a good database class library compatitable with access: http://www.databasejournal.com/features/ph...cle.php/2222651It uses PHP. Sorry if I was rude to you or anything, souradipm
Comment/Reply (w/o sign-up)
dhanesh
Jul 20 2006, 08:10 PM
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 Regards Dhanesh.
Comment/Reply (w/o sign-up)
(G)faulkj
Apr 25 2009, 08:43 AM
ACCESSdb Java
MS Access DB To Webpage Connection ?
You are able to connect to
Microsoft Access using JavaScript when the HTML file is run locally and
The 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 I
Wrote a JavaScript library to simplify the process. I had a great deal
Of difficulty finding information or examples of how to connect to
Access, so I decided to share my codewith the world...
The library is called ACCESSdb and you can get it here!
-reply by faulkj
Comment/Reply (w/o sign-up)
Similar Topics
Keywords : ms, access, db, webpage, connection
- Database Access On Remote Server W/jsp
(2)
Accessing Ms Access Database From A Centralized Location?
(10) Hi I am a manager at a trading/wholesaling company (and have no programming background). I
customized the Northwind sample access database to make invoices and keep accounts for my company.
We now opening another office at a distant location. So, the order entry will be done at two
points(we plan to use the same Access database). I am not able to figure out how to access the same
MS Access database from two different location(as LAN can't be used). Moreover, we can't
afford to pay huge sums to the software developers. Can intranet or uploading the database t....
I Have An Error With My Mysql Connection
mysql connection error (7) ok so here's my web page... http://lacrossems.t35.org/ it only lags cause its trying to
connect to the my sql server...i followed this guide
http://forum.ragezone.com/showthread.php?t=387249 and when i edit my config.php to my host and
login info i always get the error cannot connect to the database here is my config.php if you can
help me CODE $host = 'CENSORED'; // my host $host =
'righto'; // my database username $host = 'CENSORED'; // my database
password $host = 'odinms'; // my datab....
Integrate Access Database Onto Intranet Site
Looking to integrate access database into my intranet site (5) Hey guys, im new here and am looking for answers /tongue.gif" style="vertical-align:middle"
emoid=":P" border="0" alt="tongue.gif" /> Firstly, i have designed a database using M$ access, it
consists of multiple forms which i plan to host on an intranet website, i need to be able to add
records directly from the form on the intranet website aswell as being able to edit/review current
entries on forms in the database. My question is, how would i go about integrating these forms onto
the intranet website? i plan on keeping the database and the intranet site on the same d....
Lost Connection To Mysql ,..., System Error: 111 In
(3) While I was trying to connect to my database or even create one using PhP mySQL I was given the
followoing error: Lost connection to MySQL server at 'reading initial communication
packet', system error: 111 in Has somebody encontered a similar report? I have my database
created using the cpanel together with a user name and password. I wonder if it is a server issue?
What can you do if you have not access to the configuration files?....
Access 97 To Access 2003
(15) I need to convert a database that is in Access 97 to Access 2003 but every time i do it using the
Convert tools of Access 2003 i got some errors and can't change or add any of the objects
-tables, querys, etc- of the converted database. All the errors i got are related to the user
priviligies and permissions of the database, is there exists a way or procedure that allows me to
reset this permissions??? Best regards,....
Access
Is this easy to make a login/password? (17) I was looking to make a site where people need to create an account, and log in to view the main
pages. Is it easy, or do-able, to use msoft access to make a database where people are able to sign
up with a username and password via my website?....
Public Access Oracle Db?
(5) This may be the stupidest question ever, I don't know, but frankly if this exists it would help
me out a lot haha. What I'm looking for is an oracle database set up somewhere that has an open
uname/password for the public to use for testing or anything really. I'm just developing
something that needs to connect to our oracle db here but we don't want the computers to be
required to have the oracle client installed. Currently though all the computers I have access to
here DO have it installed and need it to stay for the time being, and I can't access o....
MS Access Validation Rule
Desperate help needed (4) I have to create a whole project using Microfost Access. I have a field which will eventaually
contain details of a a list of people's DOBs. I have added an input mask, so that it it displays
the place holder __/__/____ However, how can I validate this field. For example, not it is possible
to type 30/10/1991 . How can this be changed so that it validates it correctly?....
Access -> Mysql
Converter (8) I have a problem. Is any program wchich converts database Access to Mysql ??....
Read/Write Issues After Copying An Access .mdb File
(4) Alright, I'm currently creating an interface program for a MS Access database. I've only
used Access once in the past but used other DB's a handful of times so I didn't have any
trouble getting the general program created. My issue arose when I tried to make it so that the
users needing to use the program can just copy the .exe and the .mdb files and use it. The program
doesn't require users to share the database but to store their OWN programs information in their
OWN database, so basically each needs to have their own database with the exact same d....
Help With Registration Page, Access Denied.
(10) I'm coming up with an error that I can't figure out in my registration page. Below I've
given the error message and the code. QUOTE Warning: mysql_connect(): Access denied for user:
'nobody@localhost' (Using password: NO) in /home/lonebyrd/public_html/db_connect.php on line
33 Access denied for user: 'nobody@localhost' (Using password: NO) CODE $Host =
"localhost"; // define host name (default: localhost) $User = "$lonebyrd_razmo"; // define database
username $Password = "$****"; // define database password $Database = "$lonebyrd....
PHP-MySQL On IIS 5.1 Problem
A connection problem between PHP 5 and MySQL 5 (6) Hello, I am currently testing my site on my on PC which I am using as a testing server. I am
experiencing problems with my database connection between PHP 5 and MySQL 5. Does anyone know how to
solve this problem? If you need any more info about my problem feel free to ask. Thanks Chris....
Help Me With My MS-Access Program
(2) Hi anyone can help me with making a form. These are the case; I am using Ms. Access XP, and a
database for using as a admission database for new students. And using couple table for the base,
however I want that when the operator is trying to add a students (add button), a form will came up,
and asking for his/her ID and password and Cliking the LOGIN button and lookup for the ID and
Password which stored in a "user" table on the database. When the ID and Password 're correct
the function for adding students can be processed, but when the ID and Password uncorrect....
I Have A Question About MySQL Access & Quotas
(1) On my previous web host, I surpassed my MySQL quota limit. At least, that's what they told me.
The following message is the error I get. phpBB : Critical Error Error creating new session
DEBUG MODE SQL Error : 1044 Access denied for user: 'darnem_trials@65.98.98.74' to database
'darnem_trials' INSERT INTO phpbb_sessions (session_id, session_user_id, session_start,
session_time, session_ip, session_page, session_logged_in) VALUES
('7719681862d0a4bfc392929af1357326', 2, 1125023783, 1125023783, '18d160ac', 0, 1)
Line : 168 File : ....
MySQL Connection Strings
Not just MySQL...all other dbs thrown in (0) Hi all, I had posted this same message in the General Programmng Section earlier but though
it would be more related here.... so here it goes again. For anyone dabbling in mysql and .net,
or learning mysql - either to develop software or asp.net web apps - this site is extremely useful
and handy as a reference: http://www.connectionstrings.com - the site contains one of the most
comprehensive and well covered lists of the database conneciton strings used by vb/c#/asp.net to
connect to any of the relational databases. The page lists connections strings for ....
Logic To Break Down An Access Tabbe To SQL
what is the easiest way to split this? (1) I have 3 differen tables in this database that are basically repeating the same data. How can I
split it up and still use it. This is the horse project /smile.gif" style="vertical-align:middle"
emoid=":)" border="0" alt="smile.gif" /> the 3 tables are called Horse, Dam, Sire . the Horse table
should be enough for all the data. (at least that is what I'm thinking) the Dam & Sire are
used to track lineage and are setup Like this: CODE SireID; Horse; Sire; Dam; SireSire;
SireDam; DamSire: DamDam; SireSireSire; SireSireDam; SireDamSire; SireDamDam; DamSireSire;D....
Access
Lesons (0) The HP Learning center offers very good free lessons on creating databases with step by step
instructions. You can access the learing center at HP Learing Center ....
Access To MySQL Remotely
(2) i am using a software to access to mysql remotely but it display error!(Access denied for
myusername@my ip address) please help me....
Is php supports MS Access
Ms Access Database (7) I want to know that is php supports MS Access databases. And could anyone told me the complete php
installation. I have little bit problem during installation.....
How To Transition The Database
transition the database to access (2) i want to transition the records in SQL7 to ACCESS in the condition of VF 6.0 how i can?....
How To Access a Remote MySQL
(1) I try to access to a remote mysql owned by my friend , I have the IP and username and password. but
I always got this information: Fatal error: Maximum execution time of 30 seconds exceeded in
XXXXXXXXXXXXXXXX....
How To Dump .SQL File to MS-Access
(3) Is there any way to convert a mySQL dump (.sql file) to an access file? Problem is, I downloaded and
installed the mySQL server and ran it. But I couldn't restore the dump - it kept complaining
about charsets and even the guy who created the dump didn't know what was up. So I'm
looking for another way to access the contents of the database. Help anyone?....
Looking for ms, access, db, webpage, connection
|
See Also,
*SIMILAR VIDEOS*
Searching Video's for ms, access, db, webpage, connection
|
advertisement
|
|
