298781 A simple 5 minute Perl script.

This is a very simple project and I don't have a lot of money so please be reasonable and VERY CHEAP. Don't worry, You will get a VERY good review from me if you do it correctly. To a person who knows Perl, DBI, and MySQL, then this should take you possibly 5 to 10 minutes. I am being as detailed as possible so if anything is unclear at all, please ask. While there might look to be a lot of information here, once you read this, you will see that its a very simple task. I am just being very specific and detailed in my project specification so there is no confusion as to what I want. I am trying to learn how to use Perl w/DBI & MySQL on my own. I am just a little confused about how to access the mysql database correctly to do some very simple things. Perl script must use the following: use strict use warnings use DBI If you don't know what those three things are you are wasting my time and should not bid. I have an HTML form called form1, which is on a web page called "[login to view URL]". On the form there are 3 items. item 1) Textbox named "username" item 2) Textbox named "password" item 3) Submit button Nothing fancy, just a couple of text boxes with the appropriate name next to it, and submit button under them. This is just to show me how to do it, I don't care if it looks good on the form. When the submit button is clicked it will submit the form information "username" and "password" to a script called [login to view URL] The perl script will access a mysql database and will check to see if there is a username that matches what was submitted, and if it finds the username, it will then check to see if the password is correct for it. If the username is blank the script should say "The username is blank". If the password is submitted blank, the script should say "the password is blank". If either of the fields were blank as stated above, then the script should not bother to look in the mysql database. The script can just exit. If both the username and the password text box has some data in it, then the following should take place. If it does not find the username in the database it will display in the browser a message. "This user is not in the database". (And then exit the script) If it does find the username but the password is wrong it will display in the browser a message. "The password is incorrect". (And then exit the script) If it does find the username and the password is correct, it will display in the browser a message. "Username and password are correct." "The last time you logged in was on: "(Display datestamp from database here) If the datastamp is empty in the database because this is the first login, then it should display: "This is your first login." instead of "The last time you logged in was on:"... If it does find the username and the password are correct, in addition to displaying the message as shown above, it should update a timestamp in a field called "lastlogin" showing the current date and time that it was matched. The mysql database should be called "thedatabase" The table should be called "users" The table fields are: Fieldname: ID index (auto-increment + Integer) Fieldname: username varchar (Length 20) Fieldname: password varchar (Length 20) Fieldname: lastlogin timestamp You will obviously need to populate the test database with a few usernames and passwords to test this and show me it works. You will need to DOCUMENT IN THE PERL SCRIPT EXACTLY WHAT EACH LINE DOES so that a complete newbie (yes ME...) will understand EXACTLY what you are doing and why. The target operating system is Linux. The target MySQL version is the current one. The target Perl version is 5.6.1 with the required modules for DBI and mysql. Don't offer to do this in some other language. Don't offer me some other alternative solutions. Don't give me some insane bid, because this should take you 5 to 10 minutes to do at the most if you know Perl. Don't try to explain to me why this should be done in PHP instead, because if you do, then you will obviously NOT have been paying attention to what I am asking for. I want this done in Perl with DBI and MySQL. (And of course HTML for the simple form.) Once you show me that the script is done and meets my exact specifications then I will send you payment via [login to view URL] and you can send me the fully documented script, and the html form in a zip file via email. I will not pay you in advance before seeing it work, however, I will pay you immediately upon showing me it works on your server, and you have confirmed with me that the script is fully documented so well that a complete newbie can understand it. I am an honest person, but my funds are very limited, so I cannot afford to get ripped off. And I think that's a reasonable request. I need this done within the next hour, so if you cannot do it quickly and for a cheap price please don't waste my time. This is just to help me learn how to do something. Do it correctly as I specified above, and get a GREAT review with a few dollars too! So if you are new to scriptlance like I am, this would be a really good way for us to both get started with a good review from each other.