advanced php and mysql programmer needed

I've got a youtube/google video like website where videos are being displayed from google video and youtube.

I need a CRUD (Create, update, delete) page that will allow a administrator to manage the categories and videos in the mysql database. This single CRUD page should validate user input according to the datamodel and also populate the form based on auto retrieving information from youtube and google video.

Payment is $30 AFTER delivery via paypal. You should expect approximately 3 reviews. The task must be complete a week after start, therefore each draft delivery must be provided every 2 days.

The website is run on the following database schema:
Code:

mysql> describe wc_category;
+----------------+--------------+------+-----+-------------------+----------------+
| Field          | Type         | Null | Key | Default           | Extra          |
+----------------+--------------+------+-----+-------------------+----------------+
| category_id    | smallint(6)  |      | PRI | NULL              | auto_increment |
| topcategory_id | smallint(6)  | YES  |     | NULL              |                |
| name           | varchar(255) |      |     |                   |                |
| sort           | tinyint(4)   |      |     | 1                 |                |
| timecreated    | timestamp    | YES  |     | CURRENT_TIMESTAMP |                |
+----------------+--------------+------+-----+-------------------+----------------+
5 rows in set (0.00 sec)

mysql> describe wc_entry;
+-------------+--------------+------+-----+-------------------+----------------+
| Field       | Type         | Null | Key | Default           | Extra          |
+-------------+--------------+------+-----+-------------------+----------------+
| entry_id    | smallint(6)  |      | PRI | NULL              | auto_increment |
| category_id | smallint(6)  |      |     | 0                 |                |
| name        | varchar(255) |      |     |                   |                |
| description | text         |      |     |                   |                |
| image       | varchar(255) | YES  |     | NULL              |                |
| url         | varchar(255) |      |     |                   |                |
| x_pixels    | smallint(6)  |      |     | 0                 |                |
| y_pixels    | smallint(6)  |      |     | 0                 |                |
| custompage  | text         | YES  |     | NULL              |                |
| deadlink    | tinyint(4)   |      |     | 0                 |                |
| timecreated | timestamp    | YES  |     | CURRENT_TIMESTAMP |                |
+-------------+--------------+------+-----+-------------------+----------------+
11 rows in set (0.00 sec)

Code (markup):

I need a new page "admin.php" which will allow creating new videos and updating existing videos.

This admin page will get a parameter "entryId" which is the primary key for wc_entry table if it is a edit. If the page is called without this parameter then it is a create.

The page should have html form equal to the columns in the tables. It should also have a button "Get from youtube" and "Get from Google Video", where you can enter the youtube/google URL and it will fetch as much information as it can and add into the html form. Then the user can correct & fill out the remaining fields and then create/update.

 

Ok, I can do it! I will PM u!

 

Let me know if not done.

 

Sup, I am a student from Norway looking for small projects just like this one. I can do this for you pretty easily and I have done much similiar work.

Contant me on MSN: anton_abilov(@)hotmail(dot)com
Skype: andodo007
Or e-mail to my MSN

Looking forward to hearing back from you