Website that pulls info from database?

**beckster2001** · 03-19-2006 05:06 PM

I would like to create a website with a list of addresses/names/phone numbers for different categories. Kind of like a directory. I would like to pull this information from a database if possible. Is there any way to do this?

**TheBearMay** · 03-19-2006 05:09 PM

Sure, just need a database on the server and a server side language - ASP, ASP.Net, PHP, Java, or JSP are fairly common.

**beckster2001** · 03-19-2006 05:54 PM

That sounds difficult. The only thing I know is html. Do you know of any tutorial that could help me out?

**NogDog** · 03-19-2006 06:25 PM

Originally Posted by beckster2001

That sounds difficult. The only thing I know is html. Do you know of any tutorial that could help me out?

Start by determining what server-side language(s) and database(s) your web host supports. That will narrow down the selection.

If PHP is an option, take a look at http://www.zend.com/php/beginners/index.php to get started.

**beckster2001** · 03-19-2006 07:43 PM

OK. So I am working on antiquesinva.com . On the index page I have a pull down menu. I'm trying to get the first option "Portsmouth" to work. The portsmouth.asp page comes up, but is not displaying the information I had hoped. I created portsmouth.asp hoping to pull information from a database. The database is called antiquesdb, but the table is called stores. I can't get any info from the database to show. Help please!!

**JPnyc** · 03-19-2006 08:14 PM

This isn't a quick and easy thing to explain. What's in this asp file you created? 1st you need to make a connection to the database, and you need to know the connection string for that database. You need a SQL statement, such as:

SELECT blah FROM tableName WHERE someCondition = someValue;

I assume you plan to use vbscript as the scripting language.

**beckster2001** · 03-19-2006 08:20 PM

In the portsmouth.asp file it says:
<%@ Language="VBScript" %>
<% Option Explicit %>
and in the body of the html it says:
SELECT store_name, store_address, store_city, store_phone
FROM stores
WHERE store_city = 'Portsmouth'
ORDER BY store_name;

But when the website loads it just displays all my code! How do I get the database to load?

**ray326** · 03-19-2006 09:51 PM

Problems so far.

Your host doesn't support ASP.
You don't have a database named stores or if you do you haven't made a connection to it.
You don't have any code that creates or reads a record set that would be returned by your SQL query.

**JPnyc** · 03-19-2006 10:13 PM

But that's not close to a complete asp file. There's no connection to the db, there's no loop, there's no variables to hold the data, surrounded by the displaying elements for the html.

**beckster2001** · 03-20-2006 06:01 PM

Here is the entire code I have:
<%@ Language="VBScript" %>
<% Option Explicit %>

<HTML>
<HEAD>
<TITLE>Portsmouth Antiques</TITLE>
</HEAD>

<BODY>
SELECT store_name, store_address, store_city, store_phone
FROM stores
WHERE store_city = 'Portsmouth'
ORDER BY store_name;
</BODY>
</HTML>

I know my server does support ASP. I got a test page to work on it. I use godaddy.com. My database is called "antiquesdb", but the actual table I want to use is called "stores". Can someone give me the code I need to connect to my database? I really, really want to learn how to do this. I hope you all have patience to work with me.

**ray326** · 03-20-2006 10:44 PM

Back in the day I found http://asp101.com/ very handy.

**TheBearMay** · 03-21-2006 07:23 AM

Here's a slightly modified example from the Samples directory that comes with the IIS install:

Code:

<%@ LANGUAGE = VBScript %>
<%  Option Explicit		%>

<HTML>
    <HEAD>
        <TITLE>Simple ADO Query</TITLE>
    </HEAD>

    <BODY BGCOLOR="White" topmargin="10" leftmargin="10">

		<!-- Display Header -->

		<font size="4" face="Arial, Helvetica">
		<b>Simple ADO Query with ASP</b></font><br>
    
		<hr size="1" color="#000000">

		<%
			Dim oConn
			Dim oRs
			Dim filePath
			Dim Index


			' Map database to physical path
			filePath = Server.MapPath("antiquesdb.mdb")


			' Create ADO Connection Component to connect
			' with sample database


			
			Set oConn = Server.CreateObject("ADODB.Connection")
			oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath

			
			' Execute a SQL query and store the results
			' within recordset
			
			Set oRs = oConn.Execute("SELECT store_name, store_address, store_city, store_phone FROM stores WHERE store_city = 'Portsmouth' ORDER BY store_name;")
		%>


		<TABLE border = 1>
		<%
			Do while (Not oRs.eof) %>

				<tr>
					<% For Index=0 to (oRs.fields.count-1) %>
						<TD VAlign=top><% = oRs(Index)%></TD>
					<% Next %>
				</tr>

				<% oRs.MoveNext 
			Loop
		%>


		</TABLE>


		<%
			oRs.close
			oConn.close
		%>

	</BODY>
</HTML>

Thread: Website that pulls info from database?

Thread Tools

Display

Website that pulls info from database?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions