Forum Moderators: mack

Message Too Old, No Replies

How to call up data from database in web page

Database, web page

         

aussiefemale

12:40 pm on Feb 14, 2008 (gmt 0)

10+ Year Member



I need help in where to start in creating a web page which is linked to a database. The database has information on names, contact details, location etc. I want to create a web page where it is possible to search for name or location, and all other fields for that record will be shown on the web page. I think what I need to do is create an ASP file, but I am stuck with where to start. Can someone give me a nudge in the right direction?
Thanks

mack

4:59 pm on Feb 15, 2008 (gmt 0)

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month



This can be done using PHP scripting. PHP is a programming language.

PHP is usually used in conjunction with a Mysql database. You mentioned asp, does this mean you are on a Windows server and querying an MS SQL database.

If you are on a Linux server then ASP wouldn't be an option. What server and operating environment are you using.

Mack.

patzblue

9:03 pm on Feb 15, 2008 (gmt 0)

10+ Year Member



As Mack mentions it depends on what OS you're hosted. Like he says PHP+mySQL works pretty well thought I can't help you much on that as I'm a Windows developper.

If you're hosted on Windows, then I will simply recommend :

1) Download VISUAL STUDIO 2005 (Web Developper version) . It's Microsoft but that one is ...... free !

2) go on www.asp.net and look at the "DATA TUTORIALS", there's a nice bunch of 45 tutorials by a guy at 4guysfromrolla and the tutorials there are GREAT. That's how I learned how to properly handle dynamic content with a database.

hope it helps .

aussiefemale

11:50 am on Feb 16, 2008 (gmt 0)

10+ Year Member



Thanks for that Mac & Patzblue.

The network I plan on loading this database on is running on Novell at present, but will be moving to Windows in the near future.

So from what you have said I guess I am best to use PHP. Is there some software I can use to create this?

When I am developing the database and web site does it have to be loaded on the server to test it, or can it be on a local machine?

Thanks again
Karen

mattli

10:00 pm on Feb 16, 2008 (gmt 0)

10+ Year Member



I would recommend then book 'Web Database Applications with PHP & mySQL' from O'Reilly it really got me going on developing my database driven web pages. Development can be done on a local machine running a webserver (eg IIS on windows). You can use phpmyadmin(www.phpmyadmin.net) to administer the database, and have to install PHP (www.PHP.net) on the local machine.

Good luck

patzblue

7:55 pm on Feb 19, 2008 (gmt 0)

10+ Year Member



Oooh Novell ... Haven't seen that OS since I finished school 14 years ago. lol.

I have no clue what web servers run on Novell though. Wouldn't be my first choice. Moving to Windows is a smart idea. Some people might flame me for that but hey ... I personally think it's easier to deploy for people with limited technical skills. Don't get me wrong, Apache/Linux are pretty good, but if you aren't a more-than-advanced administrator, it's a receipe for disaster.

Mattli's recommendation on PHP is pretty good though. So I guess it'll be your call. Let me just say that if you intend to go on a linux server, stay away from ASP and the opposite is also true, stay away from PHP on Windows. Better stay a purist as enabling them on the wrong platform is possible, but it adds extra layers of configuration.

hope it helps a bit !

Pat

rocknbil

7:18 pm on Feb 20, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Novell is a networking technology.

Web serving is well, web server technology. :-) I received a Novell tech certification back in the day, and don't think there was any serious integration between the networking and web services at the time. That may have changed (or I could be wrong) but for the sake of argument, let's keep the two in their respective cubicles.

Databases are . . . databases. :-) How you interface with them is a function of the web server or networking platform.

The point is you can have a database structure in say, mySQL or more likely MS SQL and both the Novell programs and web programs can interact with it. It's pretty likely the Novell network is already interacting with Windows workstations, so a good transition would probably be to install a IIS or other Windows based web server and construct applications in .asp. This would allow both the web apps and Novell apps interact with the same database.

aussiefemale

11:39 pm on Feb 25, 2008 (gmt 0)

10+ Year Member



Thank you everyone for the replies.
I have now got as far as determining that it is best that I use ASP.NET. I have spoken to the IT people from my organisation who suggested that this was the best way to go. BUT, they are unable to assist me with how to create the web pages, hence this posting.
I am simply wanting to create ONE additional page to our existing intranet site (this site is very simply html only). This one page I want to add is simply going to have two or three drop down boxes where you can scroll through the selections of peoples names or locations. Once you click or select one it will then bring up a range of data for that person eg. Full name, location, position. Is there a simple way of doing this, as I am getting very confused in where to start.
Thanks