0 registered (),
60
Guests and
3
Spiders online. |
Key:
Admin,
Global Mod,
Mod
|
|
|
#626564 - 11/01/05 08:49 AM
Re: Web based database access?
|
Anonymous
Unregistered
|
Have you tried using MySql...?
|
Top
|
|
|
|
#626566 - 11/01/05 12:38 PM
Re: Web based database access?
|
Member
Registered: 04/02/03
Posts: 809
Loc: In a Bar near YOU!
|
If your familiar with Java you can use the JDBC driver to access and control a databse through java. Not sure if that helps or not but thats how i do it.
_________________________
.:SpaceMonkeyMafia:.
Alcohol Tobacco and Firearms should be a convenience store not a government agency
99% of democrats give the rest a bad name
Liberals are constantly Inflaming the culture war. They seem to forget which side has all the guns.
|
Top
|
|
|
|
#626567 - 11/01/05 12:58 PM
Re: Web based database access?
|
Member
Registered: 20/12/01
Posts: 4932
Loc: Fort Worth, TX
|
If you want simple, and have a newer version of access, you can create web forms in it to access the data with. If it is a simple app this should work fine.
_________________________
Redsox1113: F*** Iran, the only thing that ever came out of iran was the iron sheik, and hulk hogan whipped his ass. F'em
|
Top
|
|
|
|
#626569 - 12/01/05 08:31 AM
Re: Web based database access?
|
Member
Registered: 08/08/00
Posts: 7759
Loc: Arizona
|
php
if the server is not "set up" for asp then it sounds like a *nix box, php is the way to go in that instance.
|
Top
|
|
|
|
#626572 - 17/01/05 04:23 AM
Re: Web based database access?
|
Member
Registered: 27/11/00
Posts: 1147
Loc: Montclair, NJ
|
|
Top
|
|
|
|
#626573 - 17/01/05 12:07 PM
Re: Web based database access?
|
Member
Registered: 30/04/03
Posts: 757
Loc: Omaha, Nebraska
|
Originally posted by Xterrian: Can anyone suggest a basic tutorial for MySQL and PHP? The database and webpages won't be on the actual internet. They will be in a folder on the server and accessed there. Everytime I click on an asp page on the server it opens Frontpage instead of IE. I don't know diddly about php or MySQL. I need a website that tells me how they work from the most basic level. I hope I don't have too much trouble doing this. I wrote my first app in Cold Fusion the first weekend I got it. It was very easy. Hopefully these other two aren't much harder to pick up. Thanks! The reason you're having problems with ASP pages opening in frontpage instead of IE, is ASP pages must be served up by a IIS or another web server with ASP processing cabability. You cannot directly open them with IE, they have to be processed by the server to work. A very highlevel overview is this... When you write an ASP page, you enclose the ASP code in <% %> tags, which can be intermixed with standard HTML... <HTML>
<HEAD><TITLE>EXAMPLE</TITLE></HEAD>
<BODY>
<%
Dim sHello
sHello = "Hello World!"
Response.Write "<B>" & sHello & "</B>"
%>
</BODY>
</HTML> When the webserver gets the request for this file, it knows to process it with the ASP engine, which looks for the <% %> tags, processes the contents, and generates the output, which should be pure HTML... What results would be this, no more ASP code. <HTML>
<HEAD><TITLE>EXAMPLE</TITLE></HEAD>
<BODY>
<B>Hello World!</B>
</BODY>
</HTML> PHP (and coldfusion for that matter) work very much in the same way. You will be required to be running a webserver on the machine to serve up the files, and won't be able to just go into a folder to open them. PHP is pretty easy to learn with cold fusion experience. Setting up connections to your DB is a bit more work because they aren't defined at the server level like in coldfusion, they have to be defined in each page. You also use more standard for or while loops when working with returns from your querys instead of the tag.
If you're continuing to use Access, you won't use MySQL. MySQL is a database, like Access is. It's a very good free DB, but does not have the same pretty desktop interface that Access has. Unless you're willing to move your DB to MySQL and re-engineer your forms, macros and reports in PHP, MySQL isn't part of the equation for you.
|
Top
|
|
|
|
|