If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > How do I link web page to mysql database?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-30-07, 14:39
Antkin Antkin is offline
Registered User
 
Join Date: Dec 2007
Posts: 2
Question How do I link web page to mysql database?

I'm using Nvu wysiwyg editor on linux and would like to add to my web page a link to mysql database. I am a newbie to this forum.
Reply With Quote
  #2 (permalink)  
Old 12-30-07, 15:38
healdem healdem is online now
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,262
the editor itself is irrelevant

does you web server support some form of scripting technology (usually PHP, ASP, Coldfusion, CGI etc...). if your web server supports scripting then you can use one of those scripting langauges to manipulate data from to and from the db.

that's be my first stopping off point

having done that then you can worry about whether your editor can connect to MySQL.. my guess would be it can't..because its not part of editing process to do that, unless you have some whizzy editor which does incremental backups in some form of versioning software. editign a script is usually a text editor, providign you know the magic words to drive the script any editor should handle it, although personally Im quite impressed with Chamisofts HTML kit editor for freeware & Macromedia for when I get a job that warrants it.
Reply With Quote
  #3 (permalink)  
Old 12-30-07, 15:56
Antkin Antkin is offline
Registered User
 
Join Date: Dec 2007
Posts: 2
Thanks for that. My web host is streamline.net I have phpmyadmin. I've used a ready made script called sln-mysql-connect.php which is in cgi-bin folder

Path for Scripting: \\iis691\domains\a\aperkin.co.uk\user\
I don't know what to do with that I've tried it as a link in my web page but it comes up file not found html error 404
Reply With Quote
  #4 (permalink)  
Old 12-31-07, 02:42
healdem healdem is online now
Jaded Developer
 
Join Date: Nov 2004
Location: out on a limb
Posts: 9,262
so does your web account actaully include PHP, or some other scripting language?

the fact you have access to PHPMyAdmin is I suspect a red herring.. That is provided by your ISP to allow you to talk to their database for maintenance of the database NOT it has nothing to do with using it in a web application.

to use a database in a web page you need to be using a scripting language that runs on the server which handles database interactions. Effectively you call for a page from the server, the server notices the file extension and invokes the appropriate scripting engine based on the that extension. So a file ending .ASP would be handled by Active Server Pages, PHP by a PHP parser and so on, HTML/HTM is handled by the HTM parser (effectivley the server sends the file for HTML, and the output/the reulst of the script(s) to the client browser.

So to use a database within your site you will need to write pages in a scripting language, as your server is IIS then the native support for scripting will probably be ASP, but PHP may be available.

Your current 'database' code points to the location: \\iis691\domains\a\aperkin.co.uk\user\
which doesn't actually do anything.. the reason why you are getting errors is that there is no valid html file in that location that the server can access. I'd guess the server isn't allowed for security reasons to render a page from that directory. but as you haven't explicitly stated what file you want the server to retrieve it may be attempting to load the default file index.htm

The best thing to do is to talk to your ISP and find out what scripting languages they provide, what scripting language(s) are available on your account. It sounds to me as if you are just starting on the database backed web development route, in which case you are probably going to get more value form a site like www.w3schools.com may be more useful, until you start hitting db problems that is
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On