how do i connect a webpage to a database during web development?

Question

web development code for dynamic databases

Answer 1

In order to connect to a database, you have to use a server side technology like ASP .NET, ColdFusion, PHP, JSP, etc. Strictly HTML and Javascript won't be able to achieve that. So, this is the first step.

The second step is to set up an ODBC connection on the server.

The third step is the syntax. Each server side technology has its own syntax. I am a certified ColdFusion developer. In ColdFusion, the syntax is as follows,

SELECT *
FROM My_Table

In order to do this, you will need to write your own SQL statement. SQL is a database language for you to create queries.

I am a web developer by trade. If you have any questions, please feel free to contact me.

Answer 2

it's going to depend on what you are using for the database - but in general you will need to create a connection string. This will define what database engine is being used, and the location of the database and the type of connection.

The website below gives some good examples.

Answer 3

Flash is notably stable to precise time-commemorated for info superhighway progression, yet i don't comprehend if its that considerable for a occupation. Databases will constantly be considerable to the worldwide, and there could be a baseline call for for directors available. internet progression is a fulfillment or bypass over interest, and that i in my view would not throw plenty weight interior the returned of that when there are 12 3 hundred and sixty 5 days olds doing it for loose all day long. the two way, you're arranged to concentration on a decision and stick to it. it is going to take it sluggish to make your self marketable in any new occupation.

Answer 4

You haven't given us enough information to properly answer. What database are you using (Oracle, Access, Informix, Sybase, MySQL, MS SQL, etc...)? What web server (Apache, IIS, or an application server http server) and application container (JBoss, WebLogic, JRun, IIS, WebSphere, Tomcat, etc...) are you using? Are you looking to script (VBScript, JScript, JavaScript, etc...) this or use a compiled/interpreted language (C#, Java, VB, C, C++)?

Answer 5

Using PHP and MySQL, you would do something like:

$conn = mysql_connect($dbHost, $dbUser, $dbPass) or die ('Error connecting to mysql');
mysql_select_db($dbName) or die ('Could not select database "'.$dbName.'"');

//Do something with the database here...

mysql_close($conn);


___________________
Hope that helps, Adam
My website: http://www.cygnetgames.co.uk