SunQuest
           Beginner Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsOtherBeginner Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old June 7th, 2001, 10:33 PM
belindaj belindaj is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2001
Location: Kansas City, MO area
Posts: 10 belindaj User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question Access conversion to MySql for use in FrontPage Web on Linux

I am moving my FrontPage webs to a dedicated Cobalt RaQ Server which has Chilisoft installed and configured. Little did I know that Linux/Cobalts don't "speak" Access" database language - so now I am faced with conversion and learning to use MySql. Is there anyone here who is familiar with this process or can recommend some specific resources to get me going the right direction? My existing asp coding is ultra-basic - I have done just very basic functions overall - all done through the WYSIWYG interface of FrontPage 2000 - and up to now on NT servers. Thanks very much for any and all help/suggestions.

A specific example that I need an immediate resolution for:
http://www.bestofbuck.com - the Hall of Fame petition page. It is an extremely basic set of three asp pages - the submit form, the confirmation form, and the view results page - and of course the access97 database where the results currently reside. Super simplistic - but I have no idea where to start with changing over to MySql so that it can live at the new server.

Belinda

Reply With Quote
  #2  
Old June 8th, 2001, 08:16 AM
Pressly Pressly is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2001
Posts: 48 Pressly User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 8
Thumbs up MySQL & PHP

Here's a tutorial on PHP, showing how it makes an excellent interface for your MySQL database. Here's the whole MySQL manual and PHP manual. In addition, MySQL & mSQL by O'Reilly is an excellent primer and reference.

Reply With Quote
  #3  
Old June 8th, 2001, 09:43 AM
belindaj belindaj is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2001
Location: Kansas City, MO area
Posts: 10 belindaj User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
thanks - but...

I definately USE written references and appreciate the links. (I'm printing madly right now). But in skimming through as I read - I still am hoping for some step by step - how to get an existing Access database (and asp database connection) from a working, live website to a MySql database & connection.

To elaborate slightly and specifically - the example I gave in my original post:
http://www.bestofbuck.com/petition.asp (this is the working Access database)
http://66.33.90.36/petition.asp (this is the Linux/Cobalt server where the Access database is NOT working and shows the error)

To show my absolute beginner knowledge or lack thereof - WHAT is the correlation between php & MySql (why are they hand-in-hand, do I have to use php with it, etc) - is php to html as xml is to html or is that simplifying way too much?

Reply With Quote
  #4  
Old June 8th, 2001, 11:02 AM
Pressly Pressly is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2001
Posts: 48 Pressly User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 8
Thumbs up Hand-in-hand

Basicly, MySQL is a database server and PHP is an embedded scripting language which works within an HTML page. Each of these could be used independently of each other, but they each have features that facilitate using them together to build interactive web pages that can access and manage your database.

I must admit I'm still new to PHP, but so far have found it to be excellent! If you are at all familiar with Perl, PHP has some similarities, with the advantage of embedding the script in the HTML page rather than as a seperate CGI script.

Reply With Quote
Reply

Viewing: Dev Shed ForumsOtherBeginner Programming > Access conversion to MySql for use in FrontPage Web on Linux


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway