I've read some tutorials on the subject, and I've been working on getting my own site up. There are still a few things that are confusing me, and I think the fastest way for me to figure them out would be to look through someones old and discontinued database site. If any of you have one lieing around on your hard drive somewhere I would really appreciate if you could send it over this way. I'l only be using it for research purposes, and will trade you some ++ reps.
Help Needed - Setting up an sql database site.
- Thread starter jargle27
- Start date
What is a database site? You mean a site that uses a database? If so you can find DOZENS on line for free. First u got to tell us what language your targeting (I strongly suggest ASP.net/msSQL) and what type of app your looking to make so we can link u to something similar to it... Example forums u can download VBulletin, Wiki site Wikipedia is open source, Blogging would be wordpress, affiliate program would be Post Affiliate, and shopping cart would be ecommerce
I strongly suggest NOT using Asp.net/msSQL when there are plenty FOSS languages at your hands. You have PHP, python, perl, etc for languages. You have PostgreSQL, mySQL, etc for the databases.
Jar: Unless he can give you a good reason not to use ASP.net, don't just take that opinion. The problem is people who don't use ASP.net daily have the same stupid grips as mac computer users. They hear something and believe it, and stick by it die hard.
I have programmed PHP for over 10 years now, and ASP.net for about 3, and PHP can not compare to what ASP.net can do. I use PHP daily, just as much as ASP.net, but if I were to suggest which to start for a programmer, ASP.net is the way to go. Oh and BTW open source is not always as good as it sounds. AKA you have intellectual property on your box in PHP coding and someone gets access to your box, they now have access to all of your coding... Compiled coding such as C++, C#, VB.net can be compressed to a point where it is almost impossible to get any useable coding back. (note: their are scripts to scamble your PHP coding too)
I have programmed PHP for over 10 years now, and ASP.net for about 3, and PHP can not compare to what ASP.net can do. I use PHP daily, just as much as ASP.net, but if I were to suggest which to start for a programmer, ASP.net is the way to go. Oh and BTW open source is not always as good as it sounds. AKA you have intellectual property on your box in PHP coding and someone gets access to your box, they now have access to all of your coding... Compiled coding such as C++, C#, VB.net can be compressed to a point where it is almost impossible to get any useable coding back. (note: their are scripts to scamble your PHP coding too)
Its an mysql database, and im trying to learn how to set it up and page it with php. For the sake of an example lets say it is a Lyrics database. On one table I have the lyric's Individual ID, The ID which correlates to the author,The lyric itself. In the other table I have the Name of the Author of the lyric's, The authors Id to which all his/her lyrics respond to, and the Authors Date of birth.
Now I want to set it so I have the 20,000 Lyrics split up two ways. One way is A-Z, and the other way is by authors date of birth.
Now the info I just laid out is only an example. I have been reading Build Your Own Database Driven Web-Site Using Php. My original plan was to use php to solve this problem, and right now thats where I am at. I already have my databases I'm just trying to figure out how to get them onto a website.
Now I want to set it so I have the 20,000 Lyrics split up two ways. One way is A-Z, and the other way is by authors date of birth.
Now the info I just laid out is only an example. I have been reading Build Your Own Database Driven Web-Site Using Php. My original plan was to use php to solve this problem, and right now thats where I am at. I already have my databases I'm just trying to figure out how to get them onto a website.
I actually doubt you have been programming PHP for 10 years considering your answer in another thread - well that or your just post whoring. Make up your mind.
OP the easiest way to start would probably be using PHP + MySQL, as it's widely used and available at pretty much every host out there. PHP is a fairly easy language to learn and has probably more documentation out there than any other server side scripting language. Believe me that's a huge advantage over any other language.
.Net really has no advantage over any other more open language like PHP or Perl or Rails and is generally just reserved for Microsoft fanboies.
Again, people who bash .net simply have not used it enough to know better and repeat what others say. Case in point, rage's post. I believe their is an exact copy of PHP's documentation for the .net platform called MSDN, which is one of the biggest online documentation libraries, but lets look one step farther and see what else microsoft offers, for free at that:
- ASP.NET QuickStart Tutorial - Full examples of how to use every single control microsoft offers out of the box, including downloadable examples
- Learn : The Official Microsoft ASP.NET Site - Literally DOZENS AND DOZENS of free videos covering everything from installing ASP.net to building a full database driven site, including topics on everything such as LINQ, Advanced Cache, Databasing, and proper coding standards...
- Starter Kits and Community Projects : The Official Microsoft ASP.NET Site - Full free starter kits showing you example how to code many of the top sites you might want to code.
PHP does not come close to offering no where near as much learning material from the creators of PHP itself as ASP.net has to offer by Microsoft. That not even touching any of the countless websites out there to help learn it.
And yes, I started to code PHP when I was about 13, and I am now 23. As I said, I do code it daily, and it does have it's strong points but for a beginner if you actually are experienced in both (which based off your response it appears you are not) it's almost a no brainer which has more to offer
- ASP.NET QuickStart Tutorial - Full examples of how to use every single control microsoft offers out of the box, including downloadable examples
- Learn : The Official Microsoft ASP.NET Site - Literally DOZENS AND DOZENS of free videos covering everything from installing ASP.net to building a full database driven site, including topics on everything such as LINQ, Advanced Cache, Databasing, and proper coding standards...
- Starter Kits and Community Projects : The Official Microsoft ASP.NET Site - Full free starter kits showing you example how to code many of the top sites you might want to code.
PHP does not come close to offering no where near as much learning material from the creators of PHP itself as ASP.net has to offer by Microsoft. That not even touching any of the countless websites out there to help learn it.
And yes, I started to code PHP when I was about 13, and I am now 23. As I said, I do code it daily, and it does have it's strong points but for a beginner if you actually are experienced in both (which based off your response it appears you are not) it's almost a no brainer which has more to offer
Jag: If you have a database already full then the book you are using is likely a good place to start. What you need to do is learn how to do basic calls to mySQL and them build from there. First build a page that will select the top 100 normally and display it in a table, then grow your coding to do more of what you want.
An example of a basic select of all rows can be found at: PHP MySQL Select
Also under the mysql section of the PHP documentation.
An example of a basic select of all rows can be found at: PHP MySQL Select
Also under the mysql section of the PHP documentation.
If videos are better for you you might want to check out [http://www.phpvideotutorials.com/free]. I havn't actually watched them but they offer some PHP / mySQL videos for free. They also have development of full database driven scripts from start to finish for extremely cheap, so that might also be worth the investment. Hope that helps =]
Anyone claiming any language has "no advantages" over another is obviously a noob.
All languages have their pros and cons, the trick is understanding your own needs and deciding which technology is the best fit for you. Many companies spend a lot of money with consultants and managers trying to figure this out, it is not always easy.
Well i've already learned some parts of it. What I have found really confusing is building paging. The book i've been reading seems to be geared towards starting a website which thrives off of user contribution.. which isn't exactly what im trying to set up right now. I'm just looking to learn how to deploy a simple database website like the one's eli talks about in SEO Empire.
1. reading everything you say gives me a headache. learn to speak english better please.
2. if you think ASP can do anything PHP cannot, you're misled. don't say threading. DON'T FUCKING SAY IT.
3. i cannot imagine how learning a statically typed mvc framework on a closed/proprietary software stack (from kernel to IDE) would be easier for someone with no programming skills than writing "echo $hello_world;" in a text editor on any operating system of their choice.
I've developed in both ASP/MSSql and PHP/MySQL, I'll tell you this much, unless you are actually using microsoft technologies and plan on taking advantage of some of the features reserved to those tools, its generally better to stick with PhP/MySQL, you already have a MySQL database, which is going to be more easily and natively accessed with PHP as opposed to getting an ODBC wrapper for MySQL. Also if you're penny pinching the hosting, most cheaper host fully support PHP and MySQL better.
Generally speaking if you're not a programmer, your'e going to get far more outside support trying to get something up and running in PHP.
.Net is like ColdFusion in my opinion... you usually have to have a specific reason or roadmap for using it.
PHP/MySQL can be run from multiple OSes instead of just one (well you could run ASP/ASP.net from linux or OSX using Mono, but for most avid end users, thats a too much of a bitch to deal with when you could just get it done with PHP)
Generally speaking if you're not a programmer, your'e going to get far more outside support trying to get something up and running in PHP.
.Net is like ColdFusion in my opinion... you usually have to have a specific reason or roadmap for using it.
PHP/MySQL can be run from multiple OSes instead of just one (well you could run ASP/ASP.net from linux or OSX using Mono, but for most avid end users, thats a too much of a bitch to deal with when you could just get it done with PHP)
Well, I guess if you want to get technical, I didn't say "hello wor(k?)ld". I said $hello_world.
In that case, technically, <?php echo $hello_world; ?> will process, it just won't have any output, but <% response.write hello_world %> throws an undeclared variable exception. You've gotta declare it first -- and that's when you hit the whorish ugly MVC/MV-VC mangled overtop the festering plague of a codebase that is .Net. If there's a single approach to framework design that is WORSE than PHP's philosophy of seperating everything by underscores [module_package_function_name()], then it's .Net's philosophy of splitting everything up into ten million classes like this is Java or something... oh, fuck, I forgot, MS totally stole all of .Net's "philosophy" from Sun's Java (along with half of Java's crappiest coders) when they "shut down" the Microsoft JVM project and "started" .Net over a decade ago. I can't wait for 4.0, because judging by what we've seen as of 3.5, I'm pretty confident my homies in redmond have managed to completely reinvent a square wheel out of paper towels, and when it comes around and arbitrarily "fixes" things that already worked, I'll laugh from my armchair as you pour through pages of bug changes written by misers and sadists, looking for why "return true" now returns false. Take it from me personally, the only thing more painful than reading Microsoft's documentation for ANYTHING is... well, being the guy that writes that documentation.
But no, seriously, your point is moot, because PHP is still a procedural scripting language, and ASP.Net is still a complex and convoluted web stack with a much steeper relative learning curve.
No if you want to get technical, you keep saying PHP is easier to learn and I simply said ASP.net has more to offer a person. As firepacket said, each language has it's own specific use and everyone will find them different. Which is better is a matter of opinion, which is why this convo, on top of your cocky attitude is completely pointless.
As kb said, being that he already has a mySQL database, PHP is likely the route to go (though ASP.net isn't to bad once you have the mySQL driver installed with the dataset DLL). But to relate to what I said, not what you keep assuming I said, if you were to start from scratch, learning ASP.net will give you a lot more option in the long run.
Trust me, it's an extremely nice feeling to develop a whole web site, then be able to reuse the coding for that web site on a whole separate website by adding another solution (aka a separate admin area that uses all the same classes and DALs), then using all that logical coding in a desktop application relating to the website (Such as say spiders), all in 1 solution set. Till you actually do it, you have no clue the difference in headache and not to mention it's not a point of debate since it is an OPINION meaning each persons will be different.
Also another big issue is that most beginners tend to forget to use mysql_escape_string leaving them open to vast SQL injects, where if they use a ASP.net dataset, everything is done for them to prevent it. Sure theirs a bit more work for a starter script but in the long run the vast options open to you using ASP.net is unbelievable (lets not forget you can even use PHP with your ASP.net scripts, not vise versa)
As kb said, being that he already has a mySQL database, PHP is likely the route to go (though ASP.net isn't to bad once you have the mySQL driver installed with the dataset DLL). But to relate to what I said, not what you keep assuming I said, if you were to start from scratch, learning ASP.net will give you a lot more option in the long run.
Trust me, it's an extremely nice feeling to develop a whole web site, then be able to reuse the coding for that web site on a whole separate website by adding another solution (aka a separate admin area that uses all the same classes and DALs), then using all that logical coding in a desktop application relating to the website (Such as say spiders), all in 1 solution set. Till you actually do it, you have no clue the difference in headache and not to mention it's not a point of debate since it is an OPINION meaning each persons will be different.
Also another big issue is that most beginners tend to forget to use mysql_escape_string leaving them open to vast SQL injects, where if they use a ASP.net dataset, everything is done for them to prevent it. Sure theirs a bit more work for a starter script but in the long run the vast options open to you using ASP.net is unbelievable (lets not forget you can even use PHP with your ASP.net scripts, not vise versa)
Arrgg.. Damn programmers... PHP is no better than ASP is no better than PHP.
A good PHP programmer is better than a bad ASP programmer or the other way. It is the coder not the code who is better.
Anyways.. for the OP, I might have a lot of databases. How may I send you?
Will recipes do? or Lyrics?
:moon: OS is better than MS
A good PHP programmer is better than a bad ASP programmer or the other way. It is the coder not the code who is better.
Anyways.. for the OP, I might have a lot of databases. How may I send you?
Will recipes do? or Lyrics?
:moon: OS is better than MS
Blogspot, each language does have it's ups and downs. I am a VB.net programmer and I hate things such as I need to end EACH line, can't just do a 6 line string by starting and ending with a " (2010 will end that =]). Also it's case insensative, something I do not like. My only point is that ASP.net offers so much more than PHP can (maybe not easier, but more worth the time learning), and for anyone who has enough knowledge in both, knows that is true. Even if they prefer PHP, which sometimes I do (especially for ease of arrays by string), ASP.net just offers you more from knowing 1 platform.
I'm not trying to argue or prove my point with them, just hoping anyone who potentially reads this and wants to learn explores the true options at hand. Learning ASP.net over PHP will surely give you more long term options in your field. While there's a milestone list of reasons, the fact you can make both websites, but also desktop applications for the same language (c# or vb.net) is just one of many reasons.
I started coding at 9 and if it wasn't for people giving me unbiased opinions I would have never got where I am. I am just trying to help others make educated choices to begin with, like people have for me.
I'm not trying to argue or prove my point with them, just hoping anyone who potentially reads this and wants to learn explores the true options at hand. Learning ASP.net over PHP will surely give you more long term options in your field. While there's a milestone list of reasons, the fact you can make both websites, but also desktop applications for the same language (c# or vb.net) is just one of many reasons.
I started coding at 9 and if it wasn't for people giving me unbiased opinions I would have never got where I am. I am just trying to help others make educated choices to begin with, like people have for me.
Now that you've shouted and debated the finer points of PHP vs ASP for half the posts in this thread, how do you go about pulling records from a database, displaying them nicely, and making the whole site build itself with any of the above languages?
Although there is a large dose of sarcasm in my words, I'll probably listen to what you have to say on the matter, especially if it makes some sense, rather than just shouting jargon and how much you know.
Although there is a large dose of sarcasm in my words, I'll probably listen to what you have to say on the matter, especially if it makes some sense, rather than just shouting jargon and how much you know.