Get a Freelance Job

My MySQL load is bogging down my sites system. I can’t download files as fast from my server anymore and when I log into the server’s WHM I can see under “CPU/Memory/MySQL Usage” that the MySQL is in RED and is at like 42.25

I need this optimized so the MySQL doesn’t bog down the system. Most likely the User side and the Admin side.

I would like this to be started on immediately! Any questions, please ask.

I am looking for a very quick and good PHP and MySQL programmer to program a user interface with a signup and login HTML form for an adult social network web site by Thursday night, EST.

We already have a web page created and designed and just need someone to design the PHP scripts and MySQL database with fields that we provide you.

The scripts you create will be a user signup/register form and a login form.

The project will be straight PHP 5.0 and MySQL 5.0. Users will register for an account with email confirmation and log in afterwards to check their information and update their personal information. They will fill out a simple HTML form (that you design),
which will then save their information to the database. The program should work like this:

1. Most fields in the database will be mandatory with PHP, not Javascript validation.

2. Two password fields for validation…

3. The program will need to check that the username is not already taken in the database, of course.

4. Upon signup, users will need to confirm their membership by email with a random key that gets emailed to them and stored in the database, something like http://www.domainname.com/users/confirm.php?k=T5sg87H2938e052909112302 (the last 12 numbers are the date and time to the second in the format MMDDYYHHMMSS. During development, www.hotwebideas.com/pynkster will be used in place of pynkster.com.
5. Users will not be able to log in until they confirm the email
confirmation with the key. In that case, a status field in the MySQL DB will need to be tripped from the default of “pending” (on signup) to “active” (after email confirmation).

6. Once users confirm by email, they will be able to log in. We also need a Forgot Password link as well.

7. We will provide the selected programmer the MySQL fields to design.

When users log in, they will see a welcome message and be able to change their information at any time. A PHP session variable will keep track of their login status to prevent the need to constantly log in. We will need to add a login form at the upper right hand corner of the web page and it will change to “Log Out” after
successful login. The logout link will destroy all session variables.

The programmer we select must have no problem working with adult web sites.

Very important: Please use straight PHP or object oriented PHP. No frameworks of any kind can be used on this project.

You MAY use AJAX, Javascript, XML.