|
|
Author
|
Topic: Need help with web database application
|
Oscar Neundorfer
Master Film Handler
![](http://www.film-tech.com/ubbmembers/458.jpg)
Posts: 275
From: Senoia, GA
Registered: May 2000
|
posted 09-12-2007 12:38 PM
I need some help from all the web/database gurus on the forum. I am about to build a web site for a client which will stretch my abilities to the breaking point. In other words, I have a LOT to learn, and a short time to learn it. I will be creating a real estate website with a search function for real estate listings.
I can go with Linux hosting and MySQL, or Windows hosting with MS SQL Server 2005. If I go with the Linux hosting, I will be using PHP to create the search engine. For Windows hosting, I will be using ASP to create the search engine.
In consideration of my limited abilities to program in either PHP or ASP, what would you recommend I go with in terms of being easy to learn and to use?
Also, do you have opinions on whether MySQL or MS SQL Server 2005 would be better suited to my needs.
Lastly, the database needs to be updated daily. I want this to be done automatically. It involves downloading a delimited text file with all the database info, extracting the data I need for my purposes, and inserting the data into the web database. With the Linux hosting, I can do CRON jobs, but I am not certain how to do scheduled tasks with the Windows hosting. In fact, how to accomplish the automatic daily update part of the project is still very unclear to me at this point.
I am determined to get this all to work, and any advice and helpful hints would be greatly appreciated. Thanks in advance.
Oscar Neundorfer
| IP: Logged
|
|
|
Mark J. Marshall
Film God
![](http://www.film-tech.com/ubbmembers/1388b.jpg)
Posts: 3188
From: New Castle, DE, USA
Registered: Aug 2002
|
posted 09-12-2007 01:47 PM
There is an excellent excellent book on MySQL called "MySQL" by Paul DuBoise. Find it and buy it if you don't have it. It will help you immensely in learning SQL syntax and other MySQL stuff. (The SQL syntax part will even help you if you decide to use MS SQL.) The latest version that I have has a purple cover and covers version 5.
Other than that, I agree with Dennis that MS may be easier to learn. I'm not sure though because I've never messed with the .Net visual development stuff. I develop everything with Dreamweaver, but I don't use any of the "visual drag and drop" features in it. All of the programming I do is coding by hand. Dreamweaver makes it easier by color coding the code so it's easier to read, and basically organizes my files for me and shows me what the page sort of looks like before I push it up.
Some say that PHP is not a very good language to program in, or that it lends itself to sloppy programming, which is bull crap. You can write excellent bullet proof code in PHP if you know what you're doing, and you can write sloppy code if you don't know what you're doing. But then, both of those statements are true of any language.
I have written an automatic MySQL updater program in PHP before. It basically looked at a comma delimited file, read it partially to determine what MySQL table it belonged to, and then updated that table with the data in the file. After that it sent an email stating that an update was just completed, and finally archived the file. It could also identify ZIP files, unzip them, and update MySQL with the resulting files in order of dependency. I thought it was pretty cool.
Good luck!
| IP: Logged
|
|
|
|
|
|
|
|
|
All times are Central (GMT -6:00)
|
|
Powered by Infopop Corporation
UBB.classicTM
6.3.1.2
The Film-Tech Forums are designed for various members related to the cinema industry to express their opinions, viewpoints and testimonials on various products, services and events based upon speculation, personal knowledge and factual information through use, therefore all views represented here allow no liability upon the publishers of this web site and the owners of said views assume no liability for any ill will resulting from these postings. The posts made here are for educational as well as entertainment purposes and as such anyone viewing this portion of the website must accept these views as statements of the author of that opinion
and agrees to release the authors from any and all liability.
|