RE: [PHP-DB] Why use MySQL with PHP
Hmm it's not PHP functionality that makes html ugly as shown at validator.w3.org. It's the person's html/php coding ability to avoid coding mistakes. Basically, PHP gives functionality. A part of that functionality is for the php programmer to make correct HTML as output so the browser will render a page as output correctly. If the php programmer is a real bonehead and he/she can't instruct php to return good HTML that doesn't make a HTML validator from coughing up errors, it's not PHP's fault, it's the coders. I've been programming PHP for quite a while now and I can't think of a single regular thing in PHP that'd cause any browser (Netscape or IE) to hang. Any time that I've had problems, it's because I didn't know the limits of what I was coding to try and do something that is outside the possibilities. Whether it's storing information in a database, retrieving information from a database, sending PHP headers to redirect to another page or sending PHP headers to set a cookie, etc. You have to know when you can do things in PHP and when you can't. If web pages hang in a browser, it's the buggy PHP code that is interpreted that's causing the problems. Not PHP itself. It's like putting gasoline w/ water in a gas tank. It's not the engine's fault it's spitting and sputtering. It's the fuel supply. Tyler Nally [EMAIL PROTECTED] American Legion Website -Original Message- From: Sheridan Saint-Michel [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 6:02 PM To: B. van Ouwerkerk; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Why use MySQL with PHP Tell me about it. You ever try running php.net through http://validator.w3.org ? It's not pretty. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: B. van Ouwerkerk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 12:28 PM Subject: Re: [PHP-DB] Why use MySQL with PHP I just remembered, the only bad thing I can think of about MySQL... their website locks up Netscape =) PHP qualifies for this too. www.php.net looks pretty messy in NS. By the way, both doesn't break NS.. Bye, B. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Why use MySQL with PHP
Oh PHP itself isn't to blame at all, and I never intended to infer that. If you point the W3C validator at www.foxjet.com you will get a clean rating and that page is generated via PHP. Someone mentioned that they got errors in Netscape and I was just pointing out that for some reason the people who built www.php.net didn't make the page W3C compliant. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: Nally, Tyler G. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 16, 2001 8:36 AM Subject: RE: [PHP-DB] Why use MySQL with PHP Hmm it's not PHP functionality that makes html ugly as shown at validator.w3.org. It's the person's html/php coding ability to avoid coding mistakes. Basically, PHP gives functionality. A part of that functionality is for the php programmer to make correct HTML as output so the browser will render a page as output correctly. If the php programmer is a real bonehead and he/she can't instruct php to return good HTML that doesn't make a HTML validator from coughing up errors, it's not PHP's fault, it's the coders. I've been programming PHP for quite a while now and I can't think of a single regular thing in PHP that'd cause any browser (Netscape or IE) to hang. Any time that I've had problems, it's because I didn't know the limits of what I was coding to try and do something that is outside the possibilities. Whether it's storing information in a database, retrieving information from a database, sending PHP headers to redirect to another page or sending PHP headers to set a cookie, etc. You have to know when you can do things in PHP and when you can't. If web pages hang in a browser, it's the buggy PHP code that is interpreted that's causing the problems. Not PHP itself. It's like putting gasoline w/ water in a gas tank. It's not the engine's fault it's spitting and sputtering. It's the fuel supply. Tyler Nally [EMAIL PROTECTED] American Legion Website -Original Message- From: Sheridan Saint-Michel [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 6:02 PM To: B. van Ouwerkerk; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Why use MySQL with PHP Tell me about it. You ever try running php.net through http://validator.w3.org ? It's not pretty. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: B. van Ouwerkerk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 12:28 PM Subject: Re: [PHP-DB] Why use MySQL with PHP I just remembered, the only bad thing I can think of about MySQL... their website locks up Netscape =) PHP qualifies for this too. www.php.net looks pretty messy in NS. By the way, both doesn't break NS.. Bye, B. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Why use MySQL with PHP
Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Why use MySQL with PHP
Personally I prefer Sybase on Linux, version 11_0_3 is free for production use and easy to install. Sybase 11_0_3 is still a very powerful DBMS although a bit dated by now, Sybase just released version 12.5. Why everyone is using MySQL I don't know, could it be that mod_php is compiled with MySQL support? MySQL is free and there is a lot of support from the community since so many are using it. How would one go about making a mod_php with Sybase support also? Regards //Richard -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 15, 2001 9:34 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Why use MySQL with PHP
My reasons: 1) Heard of Oracle, didnt know it was a database program 2) Never heard of PostgreSQL 3) MySQL is the most talked about, from what I've seen, so there's plenty of people to get help from 4) It's free. 5) It runs in Windows 5) NASA uses it, or so their site says 6) It works! So I've no need to switch to anything else 7) Most PHP webhosting services offer only MySQL. 8) Gotta love that lil dolphin! søren eriksen wrote: Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- From PHPGalaxy.com, earn up to $10 per order selling our PHP Scripts and Software on your Site. http://www.phpgalaxy.com/aff/ Also, get a fast free POP3 email account, you @php.la at http://www.phpgalaxy.com/search/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Why use MySQL with PHP
The main reasons are possibly later on its drawbacks - basically, its main attraction is the ease of use, as it's so simple! MySQL and PHP fit together so well and for people just learning scripting with databases, there's not much that's as easy to pick up quickly and produce basic database driven websites with. Obviously due to this, it's actually got no massive depth in terms of stored procedures (you can't), and won't be as effective or useful for running massive, complex sites that attract millions of visitors (something like SQL server would probably be better) but for most websites, it's free, it's easy, and it does the job! -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 20:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Why use MySQL with PHP
*laugh* I was reading this and thought to reply simply for the fact Søren is fellow danish guy, but refrained momentarily till I got this one... There are many alternatives to mySQL and much more commercial too... Try get your hotshot boss to belive in mySQL rather from business buzzword Oracle (by know, I think 95% know Oracle is the major db engine - especially on the ridiculus pricetag it comes with), but MSSQL, Sybase, PostgreSQL, Informix, Paradox ect ect ect. Okay, I am a bit colored by my short but exiting experience over 4 years pro. Since the zend guys came into the picture with the rewriting of php engine they worked quite close with monty and the boyz over at mySQL... The integration between these two systems is one of the closest and seemlessly I have seen to date, with experience from IPerForm/MSSQL6.5(later 7.0) - if you dont know IPerForm, be happy about it and never think of it - JSP/Servlet/Oracle and latest PHP/mySQL. It is unique, fast and never a problem needless what platform it runs on (though I advice noone to do Windowshosting with PHP/mySQL *ouch* can already feel I'm being dragged outside and beaten upon - Windows if for testing and development only, I always run on FreeBSD or Linux servers and it ruuuns smth) Hmm, about the Nasa part, I never conducted business quite like the guys at Nasa so I presume my needs is quite different - prefer to find the optimal solution... Heck, there are alot of bigshot sites out there running ASP *www* does that mean it is the optimal solution ? Wasn't it Ratschiller / Gerken (sorry if I got the names wrong) who had an entire chapter about the PHP / mySQL tieup - well, check their book out, I dont agree with it in full but it has its great parts... :) Enough storytelling, goodluck on your assignment / Lars PS. Søren, skriv hvis der er noget... Jeg har arbejdet de sidste par år med PHP / mySQL for firmaer som TDC KabelTV og lign. -Original Message- From: PHPGalaxy.com [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:38 To: søren eriksen Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Why use MySQL with PHP My reasons: 1) Heard of Oracle, didnt know it was a database program 2) Never heard of PostgreSQL 3) MySQL is the most talked about, from what I've seen, so there's plenty of people to get help from 4) It's free. 5) It runs in Windows 5) NASA uses it, or so their site says 6) It works! So I've no need to switch to anything else 7) Most PHP webhosting services offer only MySQL. 8) Gotta love that lil dolphin! søren eriksen wrote: Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- From PHPGalaxy.com, earn up to $10 per order selling our PHP Scripts and Software on your Site. http://www.phpgalaxy.com/aff/ Also, get a fast free POP3 email account, you @php.la at http://www.phpgalaxy.com/search/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Why use MySQL with PHP
Sure, the big guys run ASP, but its common knowledge to stay aay from that =) Actually, the reaosn I brought it up is cuz I'm sure they have some pretty big databases, for whatever they use it for, and wellanything that's gonna support a huge DB without crashing is a plus in my book =)I tried to host some php sites on my Win2k computer, and it worked out well..until people actually started visiting the site =) Thus, great for testing, bad for hosting. =) I do use it though to build databases. I have a number of different types of search engine spiders that index sites, and I find it easier to do it here than on my php web host. =) I just realized, I could talk about PHP and MySQL all day...or until my fingers fall off... so I'll end this here =) Lars B. Jensen wrote: *laugh* I was reading this and thought to reply simply for the fact Søren is fellow danish guy, but refrained momentarily till I got this one... There are many alternatives to mySQL and much more commercial too... Try get your hotshot boss to belive in mySQL rather from business buzzword Oracle (by know, I think 95% know Oracle is the major db engine - especially on the ridiculus pricetag it comes with), but MSSQL, Sybase, PostgreSQL, Informix, Paradox ect ect ect. Okay, I am a bit colored by my short but exiting experience over 4 years pro. Since the zend guys came into the picture with the rewriting of php engine they worked quite close with monty and the boyz over at mySQL... The integration between these two systems is one of the closest and seemlessly I have seen to date, with experience from IPerForm/MSSQL6.5(later 7.0) - if you dont know IPerForm, be happy about it and never think of it - JSP/Servlet/Oracle and latest PHP/mySQL. It is unique, fast and never a problem needless what platform it runs on (though I advice noone to do Windowshosting with PHP/mySQL *ouch* can already feel I'm being dragged outside and beaten upon - Windows if for testing and development only, I always run on FreeBSD or Linux servers and it ruuuns smth) Hmm, about the Nasa part, I never conducted business quite like the guys at Nasa so I presume my needs is quite different - prefer to find the optimal solution... Heck, there are alot of bigshot sites out there running ASP *www* does that mean it is the optimal solution ? Wasn't it Ratschiller / Gerken (sorry if I got the names wrong) who had an entire chapter about the PHP / mySQL tieup - well, check their book out, I dont agree with it in full but it has its great parts... :) Enough storytelling, goodluck on your assignment / Lars PS. Søren, skriv hvis der er noget... Jeg har arbejdet de sidste par år med PHP / mySQL for firmaer som TDC KabelTV og lign. -Original Message- From: PHPGalaxy.com [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:38 To: søren eriksen Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Why use MySQL with PHP My reasons: 1) Heard of Oracle, didnt know it was a database program 2) Never heard of PostgreSQL 3) MySQL is the most talked about, from what I've seen, so there's plenty of people to get help from 4) It's free. 5) It runs in Windows 5) NASA uses it, or so their site says 6) It works! So I've no need to switch to anything else 7) Most PHP webhosting services offer only MySQL. 8) Gotta love that lil dolphin! søren eriksen wrote: Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- From PHPGalaxy.com, earn up to $10 per order selling our PHP Scripts and Software on your Site. http://www.phpgalaxy.com/aff/ Also, get a fast free POP3 email account, you @php.la at http://www.phpgalaxy.com/search/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- From PHPGalaxy.com, earn up to $10 per order selling our PHP Scripts and Software on your Site. http://www.phpgalaxy.com/aff/ Also, get a fast free POP3 email account, you @php.la at http://www.phpgalaxy.com/search/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list
RE: [PHP-DB] Why use MySQL with PHP
Stored procedures is missing in mySQL correct but is scheduled with the exiting launch of the mySQL 4 family. mySQL has it's drawbacks, but main force is it's performance, for certain tasks also with quite large datasets (few million rows) I had mySQL outperform major players as Microsoft SQL Server 7 and Oracle8i. I sadly never had my hands on PostgreSQL yet. Again, it all comes down to make the optimal site for the job, not the hardest technological. To revert a saying, why jump the fence where it is the highest ? (thereby not saying we gotta jump where it is lowest, but where it is appropriate to the task). So, with experience and knowledge from major sites running daily thousands of sessions and millions of pageviews I know mySQL is capable of the trick, and with the mySQL 4 coming out, I for one is awaiting it with anticipation. Especially the stored procedures which totally would eliminate my need for Microsoft SQL Server. / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:45 To: 'søren eriksen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP The main reasons are possibly later on its drawbacks - basically, its main attraction is the ease of use, as it's so simple! MySQL and PHP fit together so well and for people just learning scripting with databases, there's not much that's as easy to pick up quickly and produce basic database driven websites with. Obviously due to this, it's actually got no massive depth in terms of stored procedures (you can't), and won't be as effective or useful for running massive, complex sites that attract millions of visitors (something like SQL server would probably be better) but for most websites, it's free, it's easy, and it does the job! -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 20:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Why use MySQL with PHP
sounds wonderful - do you know when (roughly) it's gonna be released? I thought that one of the reasons it was so fast was that the DB engine wasn't cluttered with procedures? (which is why it's so damn good for not-so-complicated sites)? i'm no expert at all, but won't mySQL 4 therefore be slower? -Original Message- From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 12:19 To: matt stewart Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP Stored procedures is missing in mySQL correct but is scheduled with the exiting launch of the mySQL 4 family. mySQL has it's drawbacks, but main force is it's performance, for certain tasks also with quite large datasets (few million rows) I had mySQL outperform major players as Microsoft SQL Server 7 and Oracle8i. I sadly never had my hands on PostgreSQL yet. Again, it all comes down to make the optimal site for the job, not the hardest technological. To revert a saying, why jump the fence where it is the highest ? (thereby not saying we gotta jump where it is lowest, but where it is appropriate to the task). So, with experience and knowledge from major sites running daily thousands of sessions and millions of pageviews I know mySQL is capable of the trick, and with the mySQL 4 coming out, I for one is awaiting it with anticipation. Especially the stored procedures which totally would eliminate my need for Microsoft SQL Server. / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:45 To: 'søren eriksen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP The main reasons are possibly later on its drawbacks - basically, its main attraction is the ease of use, as it's so simple! MySQL and PHP fit together so well and for people just learning scripting with databases, there's not much that's as easy to pick up quickly and produce basic database driven websites with. Obviously due to this, it's actually got no massive depth in terms of stored procedures (you can't), and won't be as effective or useful for running massive, complex sites that attract millions of visitors (something like SQL server would probably be better) but for most websites, it's free, it's easy, and it does the job! -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 20:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Why use MySQL with PHP
Well, need to hook up on mysql.com to check it out... 4.0 is already out on development, but even I tend to tell my clients I am on the cutting-edge *laugh* yeah, I know - bullshit buzzword - I prefer it to be stable releases before relying even remotely on these. mySQL 4.1 will become VERY exciting with the fulltext indexing (more than a mere OR search), Stored Procedures and even they promise an performance increase... hmm, our buddies at mySQL seem to make alot of promises, lets just hope they are not like politicians and actually will put a product behind the words to back it up. Monty and co. got my confidence, I look forward playing with a new toy. Refs : http://www.mysql.com/products/mysql-4.0/index.html And : http://www.mysql.com/news/article-81.html / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 21:32 To: 'Lars B. Jensen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP sounds wonderful - do you know when (roughly) it's gonna be released? I thought that one of the reasons it was so fast was that the DB engine wasn't cluttered with procedures? (which is why it's so damn good for not-so-complicated sites)? i'm no expert at all, but won't mySQL 4 therefore be slower? -Original Message- From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 12:19 To: matt stewart Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP Stored procedures is missing in mySQL correct but is scheduled with the exiting launch of the mySQL 4 family. mySQL has it's drawbacks, but main force is it's performance, for certain tasks also with quite large datasets (few million rows) I had mySQL outperform major players as Microsoft SQL Server 7 and Oracle8i. I sadly never had my hands on PostgreSQL yet. Again, it all comes down to make the optimal site for the job, not the hardest technological. To revert a saying, why jump the fence where it is the highest ? (thereby not saying we gotta jump where it is lowest, but where it is appropriate to the task). So, with experience and knowledge from major sites running daily thousands of sessions and millions of pageviews I know mySQL is capable of the trick, and with the mySQL 4 coming out, I for one is awaiting it with anticipation. Especially the stored procedures which totally would eliminate my need for Microsoft SQL Server. / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:45 To: 'søren eriksen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP The main reasons are possibly later on its drawbacks - basically, its main attraction is the ease of use, as it's so simple! MySQL and PHP fit together so well and for people just learning scripting with databases, there's not much that's as easy to pick up quickly and produce basic database driven websites with. Obviously due to this, it's actually got no massive depth in terms of stored procedures (you can't), and won't be as effective or useful for running massive, complex sites that attract millions of visitors (something like SQL server would probably be better) but for most websites, it's free, it's easy, and it does the job! -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 20:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail
Re: [PHP-DB] Why use MySQL with PHP
I just remembered, the only bad thing I can think of about MySQL... their website locks up Netscape =) I recently installed MySQL4 dev on one of the Win2k computers and it seems to work well...I havent stress-tested it much, or do anything complex with it (I'm still a beginner anyways), but I invite anyone else to try =) 65.7.204.217 - root/no password - the computer nor MySQL gets used for anything else, so go nuts with it! I'm kinda curious anyways to see what people do to/with it. oh yeah, phpmyadmin is on there at http://65.7.204.217:81/sql/ =) Lars B. Jensen wrote: Well, need to hook up on mysql.com to check it out... 4.0 is already out on development, but even I tend to tell my clients I am on the cutting-edge *laugh* yeah, I know - bullshit buzzword - I prefer it to be stable releases before relying even remotely on these. mySQL 4.1 will become VERY exciting with the fulltext indexing (more than a mere OR search), Stored Procedures and even they promise an performance increase... hmm, our buddies at mySQL seem to make alot of promises, lets just hope they are not like politicians and actually will put a product behind the words to back it up. Monty and co. got my confidence, I look forward playing with a new toy. Refs : http://www.mysql.com/products/mysql-4.0/index.html And : http://www.mysql.com/news/article-81.html / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 21:32 To: 'Lars B. Jensen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP sounds wonderful - do you know when (roughly) it's gonna be released? I thought that one of the reasons it was so fast was that the DB engine wasn't cluttered with procedures? (which is why it's so damn good for not-so-complicated sites)? i'm no expert at all, but won't mySQL 4 therefore be slower? -Original Message- From: Lars B. Jensen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 12:19 To: matt stewart Cc: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP Stored procedures is missing in mySQL correct but is scheduled with the exiting launch of the mySQL 4 family. mySQL has it's drawbacks, but main force is it's performance, for certain tasks also with quite large datasets (few million rows) I had mySQL outperform major players as Microsoft SQL Server 7 and Oracle8i. I sadly never had my hands on PostgreSQL yet. Again, it all comes down to make the optimal site for the job, not the hardest technological. To revert a saying, why jump the fence where it is the highest ? (thereby not saying we gotta jump where it is lowest, but where it is appropriate to the task). So, with experience and knowledge from major sites running daily thousands of sessions and millions of pageviews I know mySQL is capable of the trick, and with the mySQL 4 coming out, I for one is awaiting it with anticipation. Especially the stored procedures which totally would eliminate my need for Microsoft SQL Server. / Lars -Original Message- From: matt stewart [mailto:[EMAIL PROTECTED]] Sent: 15. november 2001 20:45 To: 'søren eriksen'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Why use MySQL with PHP The main reasons are possibly later on its drawbacks - basically, its main attraction is the ease of use, as it's so simple! MySQL and PHP fit together so well and for people just learning scripting with databases, there's not much that's as easy to pick up quickly and produce basic database driven websites with. Obviously due to this, it's actually got no massive depth in terms of stored procedures (you can't), and won't be as effective or useful for running massive, complex sites that attract millions of visitors (something like SQL server would probably be better) but for most websites, it's free, it's easy, and it does the job! -Original Message- From: søren eriksen [mailto:[EMAIL PROTECTED]] Sent: 15 November 2001 20:34 To: [EMAIL PROTECTED] Subject: [PHP-DB] Why use MySQL with PHP Hi everybody I'm writing a synopsis about PHP and mySQL. I'm hoping someone can help me, and tell me why the combination og PHP and MySQL is so common. What makes MySQL such a good choice when using PHP? What seperates MySQL from others dbms? -Søren Eriksen- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295 / Virus Database: 159 - Release Date: 01/11/01 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.295
Re: [PHP-DB] Why use MySQL with PHP
I just remembered, the only bad thing I can think of about MySQL... their website locks up Netscape =) PHP qualifies for this too. www.php.net looks pretty messy in NS. By the way, both doesn't break NS.. Bye, B. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Why use MySQL with PHP
I use PHP/MySQL for a few reasons.
1) Ease of Use - I am a Computer Science student and a Web Programmer. As
such have been exposed to a wide variety of programming languages and
environments. PHP/MySQL is one of the easiest to work with and learn, and
is THE easiest to do Web related things with (and yes, I have used and am
including ASP in that statement).
2) Availability - By this I mean not only that both PHP and MySQL are free
(which is a big factor for us starving student types), but that they setup
very easily on a variety of platforms. This means I can test scripts on a
copy of the MySQL DB from my Linux Server on my windows box before uploading
them.
3) Support - Both PHP and MySQL have very good Manuals which are very easily
accessable (both online and downloadable). In addition, I have received
extremely valuable help from the PHP mailling lists on both PHP and MySQL
questions. In most cases I have gotten faster and better responses than I
get from professors at school (who I am asking things concerning their
class...not PHP =P ) who I am paying to teach me. That alone is quite a
strong arguement.
4) Good Balance between Flexibility and Readability - In PERL they have a
saying There's More Than One Way To Do It. I think this is a good
philosophy, but PERL takes this to more of an extreme than I like (this is
not to say that this extreme is not right for some people). When I read
through a 50 line program in a language that I am fairly skilled at I
shouldn't have to refer to the manual more than say a dozen times...right?
In Perl I often find myself having to refer to manuals a dozen times for two
or three lines! For example:
perl -we '$_ = q ?4a75737420616e6f74686572205065726c204861636b65720as?;??;
for (??;(??)x??;??)
{??;s;(..)s?;qq ?print chr 0x$1 and \161 ss?;excess;??}'
Any idea what that one does? Without running it? Paste it into a
terminal... it should run as is (does on my Linux box with PERL 5 anyway).
On the other hand, having to write in languages where you have strict types
(You want to treat a variable as an int and then as a string?!?!?!?) and
very structured design is just as distasteful to me. PHP strikes a very
good balance between the two even when working with MySQL (I won't paste any
of the kludge needed to interface with CGI and DB in other languages... but
if you have some free time look some of these programs up).
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: søren eriksen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 15, 2001 2:34 PM
Subject: [PHP-DB] Why use MySQL with PHP
Hi everybody
I'm writing a synopsis about PHP and mySQL.
I'm hoping someone can help me, and tell me why
the combination og PHP and MySQL is so common.
What makes MySQL such a good choice when using PHP?
What seperates MySQL from others dbms?
-Søren Eriksen-
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Why use MySQL with PHP
I wrote this a few month ago for the db comparaison. It's simple and you can
easily add to it:
http://zc8.com/zc8/ZC8news/shownews.php?articleid=571
As for PHP my reasons are:
* No need to typecast which makes it easier to code.
* You can have multi-dimensional multi-cast arrays which in many case can do
instead of objects.
* It's nothing to learn if you already know a modular language (pascal, c,
java...).
* It types easily within your html code and it is extremelly readable
(although you can put some effort into making it hard to read).
* No need to compile.
* It's open source
* You can compile it with Apache and with your specs.
* Many interesting module available (like Ming)
* It's very portable.
* It's widely present on web server.
* It has easy communications with databases, ftp, remote ip files, mail...
* It has great support and online reference.
* It is very well maintained.
* Lot's of sample code on the web to look at.
And I probably forget a lot
On Thursday 15 November 2001 12:53 pm, Sheridan Saint-Michel wrote:
I use PHP/MySQL for a few reasons.
1) Ease of Use - I am a Computer Science student and a Web Programmer. As
such have been exposed to a wide variety of programming languages and
environments. PHP/MySQL is one of the easiest to work with and learn, and
is THE easiest to do Web related things with (and yes, I have used and am
including ASP in that statement).
2) Availability - By this I mean not only that both PHP and MySQL are free
(which is a big factor for us starving student types), but that they setup
very easily on a variety of platforms. This means I can test scripts on a
copy of the MySQL DB from my Linux Server on my windows box before
uploading them.
3) Support - Both PHP and MySQL have very good Manuals which are very
easily accessable (both online and downloadable). In addition, I have
received extremely valuable help from the PHP mailling lists on both PHP
and MySQL questions. In most cases I have gotten faster and better
responses than I get from professors at school (who I am asking things
concerning their class...not PHP =P ) who I am paying to teach me. That
alone is quite a strong arguement.
4) Good Balance between Flexibility and Readability - In PERL they have a
saying There's More Than One Way To Do It. I think this is a good
philosophy, but PERL takes this to more of an extreme than I like (this is
not to say that this extreme is not right for some people). When I read
through a 50 line program in a language that I am fairly skilled at I
shouldn't have to refer to the manual more than say a dozen times...right?
In Perl I often find myself having to refer to manuals a dozen times for
two or three lines! For example:
perl -we '$_ = q ?4a75737420616e6f74686572205065726c204861636b65720as?;??;
for (??;(??)x??;??)
{??;s;(..)s?;qq ?print chr 0x$1 and \161 ss?;excess;??}'
Any idea what that one does? Without running it? Paste it into a
terminal... it should run as is (does on my Linux box with PERL 5 anyway).
On the other hand, having to write in languages where you have strict types
(You want to treat a variable as an int and then as a string?!?!?!?) and
very structured design is just as distasteful to me. PHP strikes a very
good balance between the two even when working with MySQL (I won't paste
any of the kludge needed to interface with CGI and DB in other languages...
but if you have some free time look some of these programs up).
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: søren eriksen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, November 15, 2001 2:34 PM
Subject: [PHP-DB] Why use MySQL with PHP
Hi everybody
I'm writing a synopsis about PHP and mySQL.
I'm hoping someone can help me, and tell me why
the combination og PHP and MySQL is so common.
What makes MySQL such a good choice when using PHP?
What seperates MySQL from others dbms?
-Søren Eriksen-
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Why use MySQL with PHP
I mostly agree, although I prefer PostgreSQL for the transactions, better row locking, and server side cursors. It also does better with lotsa users (if the data isn't just used for the web, this is important). I have used many languages for this stuff, and the one with the best balance of functionality, extensibility, and ease of use is PHP (I have used CF, ASP, Miva/HTMLScript, PERL, C, COBOL, Shell also) BTW, COBOL on the web is weird. ASP is the worst of them all. Sheridan Saint-Michel wrote: I use PHP/MySQL for a few reasons. snip/snip On the other hand, having to write in languages where you have strict types (You want to treat a variable as an int and then as a string?!?!?!?) and very structured design is just as distasteful to me. PHP strikes a very good balance between the two even when working with MySQL (I won't paste any of the kludge needed to interface with CGI and DB in other languages... but if you have some free time look some of these programs up). Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Why use MySQL with PHP
Tell me about it. You ever try running php.net through http://validator.w3.org ? It's not pretty. Sheridan Saint-Michel Website Administrator FoxJet, an ITW Company www.foxjet.com - Original Message - From: B. van Ouwerkerk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 15, 2001 12:28 PM Subject: Re: [PHP-DB] Why use MySQL with PHP I just remembered, the only bad thing I can think of about MySQL... their website locks up Netscape =) PHP qualifies for this too. www.php.net looks pretty messy in NS. By the way, both doesn't break NS.. Bye, B. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
