RE: New to the group
At 02:43 PM 6/22/2006, Bartis, Robert M (Bob) wrote: If you will excuse my ignorance. I have no immediate need for this, but have often asked what the pros/cons there are writing a WEB based interface in PHP vs. say Perl. Do you have any insight into that? Thanks Bob Bob, Ok, so you don't want info on databases, but on which language to use to build a web site? You must sit down and determine what the site will be used for and what features you *must have* in your website. Find a website out there that has the features and style you're looking for. For example, do you want to build something like a Yahoo (page mode), or a store front like an Amazon (web application)? Once you know what type of web site you want to build, you can better determine what tools to use. For web applications (Amazon) take a look at Ajax applications. For plain page driven web sites look at PHP. Perl is more of a do everything type of language that can be used for writing applications as well as web pages, whereas PHP is more stripped down for speed and is intended for building web pages. You will get faster performance from PHP and is quite popular for building web sites. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: New to the group
At 02:43 PM 6/22/2006, Bartis, Robert M (Bob) wrote: If you will excuse my ignorance. I have no immediate need for this, but have often asked what the pros/cons there are writing a WEB based interface in PHP vs. say Perl. Do you have any insight into that? Thanks Bob Something else I should have mentioned, there are products out there like CodeCharge from YesSoftware.com that will generate the PHP/ASP/JSP code for you. It uses templates and will interface with MySQL and several other databases. It develops great looking applications but tends to use a lot more code that what you'd use if you wrote it manually. But it will get you up and running quite fast. They have a 30 day eval that you can try. There are also Ajax type development systems like Morfix (www.morfik.com) and Ruby On Rails http://www.rubyonrails.org/ and Lazslo on Rails http://wiki.openlaszlo.org/Laszlo_on_Rails that offers cutting edge development tools (that latter two are open source). These tools will deliver rich internet applications. Try some of the demos and see if you like it. :) Mike -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Thursday, June 22, 2006 3:39 PM To: mysql@lists.mysql.com Subject: Re: New to the group At 08:46 AM 6/22/2006, Nicholas Vettese wrote: Hello, My name is Nick, and I am a new MySQL user. My hope is not to become a PITA, so I will make sure that any question is straight and to the point with the information needed to answer the question. My skill in MySQL is pretty low, and I am looking to build a website for myself that will take information and save it to a database. At this time, I have a login, registration, change/lost password functionality working from a book that I read, but I am looking to expand my knowledge into more robust site. I am not looking to become the master programmer, just someone with enough knowledge and skill to accomplish his goals. Thanks, Nick Welcome Nick, You've come to the right place. There are a couple of books on MySQL that are quite good and I'd like to recommend. MySQL 3rd Edition by Paul Dubois and MySQL Cookbook by Paul Dubois (I think these guys are relatedvbg) If you are using PHP to build your website I found PHP and MySQL for Dynamic Web Sites : Visual QuickPro Guide (2nd Edition) (Visual Quickpro Guide) to be quite good and gets you going quite fast. There's not a lot of reading to do and they have you writing PHP code the first day. If you want a more thorough book on PHP MySQL there is: PHP and MySQL Web Development (3rd Edition) (Developer's Library) (Paperback) by Luke Welling, Laura Thomson There are also PHP/Mysql tutorials on the web but I don't know how good they are. You'll get up to speed faster by getting some of these books. Of course if you're not using PHP, then someone else can jump in with some reading suggestions. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: New to the group
[This is really OT for a MySQL list - sorry folks.] Forgive me if I'm telling you what you already know, but IMO the most importing thing to do when getting into web development is to learn how to build web sites securely. This might be a good starting point: http://www.owasp.org/index.php/OWASP_Top_Ten_Project Also I would recommend finding reading an overview of how web pages are requested via HTTP, so you have a clear idea of server-side versus client-side and understand the relationship between server-side code, HTML output and what is actually displayed in the browser window. Again I apologise if this obvious to you, but often people have difficulty programming and especially debugging web apps because they are not sure about this. There are probably at least a dozen fairly popular programming / scripting languages for building web sites, and dozens of others besides. Please don't ask which is best, otherwise this will probably end up being The Longest, Most Bitter Thread In History! Most people do not have extensive experience with multiple langauges and there's a lot of personal preference involved. If someone says that language X is best then what they really mean is that, of the languages they have used, they think X best suits the needs of their work and their personal preference. I'm afraid I don't really agree with the advice below about PHP's speed, because speed is affected by many variables other than just language choice (hardware, configuration, coding, database calls etc). Would a PHP solution be faster than a mod_perl solution? I don't know, but I doubt any difference would be worth worrying about. IMO the first consideration should be about what makes you most productive as a developer. (BTW, Ajax is a development technique, not a language. You still need a middleware language to do the server-side programming. To start trying to build sites using Ajax would be jumping in at the deep end, I think.) Personally I use something called Lasso (one of the 'dozens of others besides'). I've played with PHP a bit and with Perl a bit more, but have no intention of switching. Perl is cool and powerful, but I think if I was new to web development I would find PHP easier to learn. I think I would find Lasso easier still - I find its 'natural language' function names easier to remember. YMMV. Lasso is a commercial product, but with the latest version there is a free developer version. The biggest disadvantage IMO is that Lasso hosting is not that easy to find. http://www.omnipilot.com/index.html?section=Products%2fLasso%2fFree%20Trial Hmm - didn't intend to write such an essay on this! Hope it is of some use. James Harvard Ok, so you don't want info on databases, but on which language to use to build a web site? You must sit down and determine what the site will be used for and what features you *must have* in your website. Find a website out there that has the features and style you're looking for. For example, do you want to build something like a Yahoo (page mode), or a store front like an Amazon (web application)? Once you know what type of web site you want to build, you can better determine what tools to use. For web applications (Amazon) take a look at Ajax applications. For plain page driven web sites look at PHP. Perl is more of a do everything type of language that can be used for writing applications as well as web pages, whereas PHP is more stripped down for speed and is intended for building web pages. You will get faster performance from PHP and is quite popular for building web sites. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: New to the group
At 08:46 AM 6/22/2006, Nicholas Vettese wrote: Hello, My name is Nick, and I am a new MySQL user. My hope is not to become a PITA, so I will make sure that any question is straight and to the point with the information needed to answer the question. My skill in MySQL is pretty low, and I am looking to build a website for myself that will take information and save it to a database. At this time, I have a login, registration, change/lost password functionality working from a book that I read, but I am looking to expand my knowledge into more robust site. I am not looking to become the master programmer, just someone with enough knowledge and skill to accomplish his goals. Thanks, Nick Welcome Nick, You've come to the right place. There are a couple of books on MySQL that are quite good and I'd like to recommend. MySQL 3rd Edition by Paul Dubois and MySQL Cookbook by Paul Dubois (I think these guys are relatedvbg) If you are using PHP to build your website I found PHP and MySQL for Dynamic Web Sites : Visual QuickPro Guide (2nd Edition) (Visual Quickpro Guide) to be quite good and gets you going quite fast. There's not a lot of reading to do and they have you writing PHP code the first day. If you want a more thorough book on PHP MySQL there is: PHP and MySQL Web Development (3rd Edition) (Developer's Library) (Paperback) by Luke Welling, Laura Thomson There are also PHP/Mysql tutorials on the web but I don't know how good they are. You'll get up to speed faster by getting some of these books. Of course if you're not using PHP, then someone else can jump in with some reading suggestions. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: New to the group
If you will excuse my ignorance. I have no immediate need for this, but have often asked what the pros/cons there are writing a WEB based interface in PHP vs. say Perl. Do you have any insight into that? Thanks Bob -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Thursday, June 22, 2006 3:39 PM To: mysql@lists.mysql.com Subject: Re: New to the group At 08:46 AM 6/22/2006, Nicholas Vettese wrote: Hello, My name is Nick, and I am a new MySQL user. My hope is not to become a PITA, so I will make sure that any question is straight and to the point with the information needed to answer the question. My skill in MySQL is pretty low, and I am looking to build a website for myself that will take information and save it to a database. At this time, I have a login, registration, change/lost password functionality working from a book that I read, but I am looking to expand my knowledge into more robust site. I am not looking to become the master programmer, just someone with enough knowledge and skill to accomplish his goals. Thanks, Nick Welcome Nick, You've come to the right place. There are a couple of books on MySQL that are quite good and I'd like to recommend. MySQL 3rd Edition by Paul Dubois and MySQL Cookbook by Paul Dubois (I think these guys are relatedvbg) If you are using PHP to build your website I found PHP and MySQL for Dynamic Web Sites : Visual QuickPro Guide (2nd Edition) (Visual Quickpro Guide) to be quite good and gets you going quite fast. There's not a lot of reading to do and they have you writing PHP code the first day. If you want a more thorough book on PHP MySQL there is: PHP and MySQL Web Development (3rd Edition) (Developer's Library) (Paperback) by Luke Welling, Laura Thomson There are also PHP/Mysql tutorials on the web but I don't know how good they are. You'll get up to speed faster by getting some of these books. Of course if you're not using PHP, then someone else can jump in with some reading suggestions. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: New to the group
Well, php was designed basically from the ground-up as a replacement for CGI programming. AFAIK you can do similar things in PERL, but there is alot more to learn. php has an easy learning curve, and seems to be alot more suitable for server sided web programming than PERL. If you are an experienced PERL programmer then you may want to use the Apache PERL module, and do server sided programming with that. If you are new to server side programming then I would recommend starting with php, due to the easy learning curve. See http://www.php.net/manual/en/introduction.php for an intro to what php is, and what it can do. HTH Keith Roberts In theory, theory and practice are the same; in practice they are not. To unsubscribe from this list, please see detailed instructions already posted at: http://marc.theaimsgroup.com/?l=php-installm=114138567814319w=2 On Thu, 22 Jun 2006, Bartis, Robert M (Bob) wrote: To: 'mos' [EMAIL PROTECTED], mysql@lists.mysql.com From: Bartis, Robert M (Bob) [EMAIL PROTECTED] Subject: RE: New to the group If you will excuse my ignorance. I have no immediate need for this, but have often asked what the pros/cons there are writing a WEB based interface in PHP vs. say Perl. Do you have any insight into that? Thanks Bob -Original Message- From: mos [mailto:[EMAIL PROTECTED] Sent: Thursday, June 22, 2006 3:39 PM To: mysql@lists.mysql.com Subject: Re: New to the group At 08:46 AM 6/22/2006, Nicholas Vettese wrote: Hello, My name is Nick, and I am a new MySQL user. My hope is not to become a PITA, so I will make sure that any question is straight and to the point with the information needed to answer the question. My skill in MySQL is pretty low, and I am looking to build a website for myself that will take information and save it to a database. At this time, I have a login, registration, change/lost password functionality working from a book that I read, but I am looking to expand my knowledge into more robust site. I am not looking to become the master programmer, just someone with enough knowledge and skill to accomplish his goals. Thanks, Nick Welcome Nick, You've come to the right place. There are a couple of books on MySQL that are quite good and I'd like to recommend. MySQL 3rd Edition by Paul Dubois and MySQL Cookbook by Paul Dubois (I think these guys are relatedvbg) If you are using PHP to build your website I found PHP and MySQL for Dynamic Web Sites : Visual QuickPro Guide (2nd Edition) (Visual Quickpro Guide) to be quite good and gets you going quite fast. There's not a lot of reading to do and they have you writing PHP code the first day. If you want a more thorough book on PHP MySQL there is: PHP and MySQL Web Development (3rd Edition) (Developer's Library) (Paperback) by Luke Welling, Laura Thomson There are also PHP/Mysql tutorials on the web but I don't know how good they are. You'll get up to speed faster by getting some of these books. Of course if you're not using PHP, then someone else can jump in with some reading suggestions. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: New to the group
At 14:38 -0500 22/6/06, mos wrote: If you want a more thorough book on PHP MySQL there is: PHP and MySQL Web Development (3rd Edition) (Developer's Library) (Paperback) by Luke Welling, Laura Thomson I can't speak about the third edition, as I got started using what appears to be the first. It was indeed a nice quick way to get going, but I quite quickly realised that if you took it literally you ended up with some rather sloppy code - not so much sloppy PHP as PHP that generated sloppy HTML. I hope this has changed in subsequent editions, but it may be something to look out for. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Some speakers electrify their listeners, others only gas them. -- Sydney Smith -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]