FishDataBase Idea

I'm new here (well, sort of.... I was a semi-regular a few years back), but, this thread caught my eye. I pretty much develop websites for a living. .NET though... no PHP. And, databases are databases...

Based on what you have posted here, your intial design was a good starting point. Have you made any major changes? Best way to approach this would be to keep it simple! IMHO, this should NOT be difficult anyway (the programming part). Data collection is another story....

Anyway, I'd be glad to help... but, I can't promise any major time commitments (job, wife, kid tend to take up most of my time :) ).

Oh... again, IMHO, there has to be a way to get data from Excel into MySQL and back. To get data into MySQL from Excel... just export the data into a csv format then import into MySQL. To get it out... create a page that loads data (just like any you've done before), but change the content type to Excel. Not that it matters, I'm just commenting on your reply about getting an Excel report.

Good luck! :D
 
Well, MySQL should be able to do what's needed. Again, I don't think this is terribly complicated, so, the main focus (above anything else) should be to keep it simple... very simple!

:dance2:
 
IceCreMan said:
I'm new here (well, sort of.... I was a semi-regular a few years back), but, this thread caught my eye. I pretty much develop websites for a living. .NET though... no PHP. And, databases are databases...

Based on what you have posted here, your intial design was a good starting point. Have you made any major changes? Best way to approach this would be to keep it simple! IMHO, this should NOT be difficult anyway (the programming part). Data collection is another story....

Anyway, I'd be glad to help... but, I can't promise any major time commitments (job, wife, kid tend to take up most of my time :) ).

Oh... again, IMHO, there has to be a way to get data from Excel into MySQL and back. To get data into MySQL from Excel... just export the data into a csv format then import into MySQL. To get it out... create a page that loads data (just like any you've done before), but change the content type to Excel. Not that it matters, I'm just commenting on your reply about getting an Excel report.

Good luck! :D
Click to expand...

Yeah trust me i would rather do this in .NET with MS SQL. But i like php also but man do i really miss some of the little pieces of .NET. And i dont want to run my webserver through windows, i leave that to my linux computer.

The database design has changed alittle bit since i started seeing the bigger picture of the project. The other major changes were that i created a class to contain all my functions and calls to make things alot eaiser. I would be more than happy to share the code and database design with you or anyone if you would like to comment, or suggest anything. Granted you said you dont know php but if you know any kind of c/c++ the structure is extremely similiar. Who knows maybe ill develop another attempt in .NET one day.. I would love to be able to use foreign keys and stored procedures in ms sql.

But seriously even if you wanted to come up with a better html design i would love it. As you can tell by the site im a programmer not an artist.. :)
 
I understand your concern with hosting anything on windows!

MySQL doesn't support stored procedures yet? I thought I heard that it did... guess that shows you how little I know about MySQL!!!

In regards to better html design... I'm like you, I'm a programmer! I work with graphic designers who come up with the look and feel of the sites I work on. Plus, from what I saw, your site looked fine. :)
 
You must log in or register to reply here.
AquariaCentral.com
Top Bottom