[titanalive]

Ok this time its related to creating a web site.

I am creating a web site for a college project of mine. So fra i have made a few forms for the site. My problem is that i donot know how to take the data from the web site and store it in a database. I have been racking my head and scouring the net but have been unsuccessful in finding anything relevent . Any help on what i can do to resolve this problem would be the most appreciated. Itsjust that i am nearing he deadline for submission and am unable to proceed ahead.

Thanks a lot

[Rockn]

Taking the data from someone else's web site? Unless you have a custom parser to strip off everything but the data you are looking for it ain't gonna work.

[Regicide]

You need to use a language other than HTML to be able to parse the data. Two options off the top of my head are PHP and JSP. If you use JSP, you can use a framework called Hibernate to access the database.

If this is going to be a Windoze based server, you could look into ASP. I am pretty sure that ASP can access databases out of the box.

I would personally choose the JSP route as queries can be automated with Hibernate. It really takes the headache out of coming up with the correct queries.

[Rockn]

Sounds like you are trying to make something similar to an email address harvester for spamming purposes. What kind of data are you looking to scavenge from other people's web sites?

[titanalive]

Ok i guess i should have been more clear when i put up the post. I am not trying to salvage information from any one elses site i am trying make a comments form on my own web site and what i planned to do was store the information entered by the user in that form in tables in SQL Server.
I guess i wasnt clear enough on my post and i apologise for that but thanks anyway guys

[titanalive]

One more question though its well sort of a confusion i am trying to clear. Does jsp coding require java enterprise edition installed as i have only jdk 1.5 installed and could not find the latest version of the enterprise edition

Thanks

[Chicon]

Originally Posted by titanalive

... Does jsp coding require java enterprise edition installed as i have only jdk 1.5 installed ...

No ! A good Java IDE provided with tools designed to build Web applications like NetBeans or Eclipse is sufficient. Personally, I use NetBeans as it has a inner built Apache Tomcat emulator and therefore, I don't have to install any Web applications server on my computer to test my servlets.

[dsartain]

Personally, I think that you'll do better with PHP and MySQL...

With PHP/MySQL you would use a basic HTML page as a form (can also use .php extension), and then PHP would process the information and send to the MySQL database. Installing both the DB Server and PHP is very easy.

You can use ASP/ASP.NET, but ASP isn't as versatile as PHP, and if you're doing this for a college project, and have taken computer programming classes before, they will most likely have been C-based, so PHP will be easier to understand. Let me know if you have any other questions about it, because this type of thing is very easy once you get the format down...

[titanalive]

Well you got me there. I am currently doing a computer course and they were C programing related. Sorry for the late post though. But the problem with me currently is that though i any be able to code with jsp as i have done java programing in the past so i guess jsp should not be tough but as far as php is concerned i have zero experience using it. But anything that speeds up the process is welcome so i would just like to ask one thing though that should i put some time aside and learn php or should i just go ahead with jsp as at this point of time too it may take me about a week or so before i may gey the hang of jsp as i have no experience with that too but since it is java it may be easier. Please advice

Thank You

[titanalive]

And yes thanks for the advice about netbeans. i have the setup file but never installed it as i did not understand its worth at that time. That definitely saves me time about sitting and downloading j2ee.

[dsartain]

Well, first, I don't know JSP, so I can't compare the two languages. Second, it all depends on what you want to do with this web app. Is it just pull information and display it off a server? Next, do you have to use MSSQL, or can you use MySQL?

The question which may narrow this down rather quickly, is does your web server support PHP currently, or do you have privileges to install it.

Setting it up isn't all that hard, and there is good documentation for installation at www.php.net.

In your reply to this post (if you're still interested in PHP), why don't you type out a list of things you need the app to accomplish, and any coding restrictions you have...if this is for a class, is it for a programming class where you need to use a specific language, or is this something you want to do as an extra credit project that the prof won't care about, etc?

Once we have more of an idea as to what you need, we'll be able to better help you.

[titanalive]

OK as far as your concern for any restructions goes there are no restrictions. The web server that i am using supports php as such but even if i have to install it there are no issues and no restrictions. And as far as my intrest in php is concerned anything that speeds up the process of finishing the website is welcome.
As far as the database is concerned what i need to do is display data both ways ie store as well as retieve data form the database. The only reason i was using MSSQl is that i currently have it installed on my pc for MySQl i will have to acquire the software. Acquiring the software is not a problem so assume that i have the software as while i am writing this post i am ordering it as well.

And yes the project is a live project that i am doing for a small firm that actually wants to implement it. Although the college is monitoring each step of the way and marks us accordingly.
So as you see its a do whatever you have to but get a running website kinda project.
I hope this is some help.
i apologise for anything that this may not clarify . thanks

[dsartain]

First, you can download the MySQL server for free from mysql.com

The first thing you'll need to do, if you haven't already, is build the database and the HTML form (or whatever you're using to collect the data).

Collecting information isn't all that hard, nor is displaying it, but what type of information are you collecting?? Images, contact data, generic text on a web page???

[titanalive]

Will Be collecting contact details from the page

[titanalive]

Ok i got how to do this i used java servlets and used j2ee server 1.3.1 for the job. What we need to do is take the information into temp variables using javascript. And use the get or post method to forward the details by calling the java servlet. Store the details passed in variables. Establish a connection with the server and pass the information to each row by implementing a counter. Close the connection following database update