Forums
This topic is locked
integrating a simple sql database in dreamweaver
01 Feb 2005 17:57:18 Steve K posted:
ok this is a total newbie question. i'm on a group project and what we need to do is to integrate a very simple database in sql with a webpage in dreamweaver. we can only connect to the database through oracle. queries should be embedded in buttons and results displayed in some other text boxes or in plain html format. how is this done?what should we use (php? javascript?)? any ideas?thanx
Replies
Replied 01 Feb 2005 21:49:32
01 Feb 2005 21:49:32 Chris Charlton replied:
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>...i'm on a group project and what we need to do is to integrate a very simple database in sql with a webpage in dreamweaver. we can only connect to the database through oracle...<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
That's standard for DW MX/MX2004, so no real issues there - maybe Oracle wouldn't be my first choice of "small" database (MySQL/Access would be best in my choices for small).
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>...queries should be embedded in buttons...<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
You mean you will be making pre-defined Queries? or you just mean use form buttons to run the queries?
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>... and results displayed in some other text boxes or in plain html format. how is this done?what should we use (php? javascript?)? any ideas?<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
If you choose to use PHP, then you can do all you are asking with PHP. Same with ASP, CFML, JSP. As for JavaScript, that will be more for client-side stuff - form validations, DHTML, etc.
As for "how is it done"... well, that's more than one forum posting, so you might want to read what you can in DMXzones' Premium Articles (www.dmxzone.com/categories.asp?TypeId=28), Tutorials (www.dmxzone.com/categories.asp?TypeId=2), and FAQ (www.dmxzone.com/categories.asp?TypeId=7) sections. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
That's standard for DW MX/MX2004, so no real issues there - maybe Oracle wouldn't be my first choice of "small" database (MySQL/Access would be best in my choices for small).
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>...queries should be embedded in buttons...<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
You mean you will be making pre-defined Queries? or you just mean use form buttons to run the queries?
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>... and results displayed in some other text boxes or in plain html format. how is this done?what should we use (php? javascript?)? any ideas?<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
If you choose to use PHP, then you can do all you are asking with PHP. Same with ASP, CFML, JSP. As for JavaScript, that will be more for client-side stuff - form validations, DHTML, etc.
As for "how is it done"... well, that's more than one forum posting, so you might want to read what you can in DMXzones' Premium Articles (www.dmxzone.com/categories.asp?TypeId=28), Tutorials (www.dmxzone.com/categories.asp?TypeId=2), and FAQ (www.dmxzone.com/categories.asp?TypeId=7) sections. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>