Em Andamento

Small coding project in PHP

Job Description:

Hi,

I'm looking for someone to help me on two things:

1) To read a plain text file (about 300-400 lines) and extract Username, email and Join date to a MySQL Table called FST_User_Progress in a database called 'FST'.

The MySQL Table has fileds (Firstname=Firstname, Lastname=Lastname, username = username, email = email, pos1date = Join date)

The format of the plain text file is as shown below:

Ulterium password Firstname Lastname emailATdomainDOTcom Members Active 0 2003-07-29 2003-07-29

So need to take the 1st, 3rd, 4th, 5th and 9th values. The values are seperated by Tabs.

The code should be able to check if a value already exists in the table and not create duplicates.

To have this run as a Cron job would be nice (if it's possible).

2) This is for an online course...

Have a next button on a web page, go to a validation page.

The validation page asks the user to enter their email address.

It then looks up that email address in the MySQL table as well as the 'pos1date'.

If the email does not exist, show a result page that this email address cannot be recognised.. please re-try.

After a valid email is entered, it checks the current date is >140 days after pos1date (from the MySQL table).

If FALSE ---> then responds with a web page 'Please take your time to complete each lesson. It is recommended to take 1 week per lesson.'. Also to send an automatic email to ' to say 'Firstname Lastname' has tried to reach this page. The previous date = pos1date.

If TRUE ----> then updated pos2date in MySQL table with the current date. Redirect the user to the next page of the online course.

For testing purpose we can change the >140 days to be >1 days etc..

What I will be supplying:

For 1.. The user database (made anonymous).

For 2.. example web pages.

Content of email.

For the response messages there will be a page layout to follow and will also provide this.

With Thanks,

BKKSerpent

Habilidades: PHP

Sobre o Cliente:
( 52 comentários ) Lumpini, Pathumwan,, Thailand

ID do Projeto: #935033

22 freelancers estão ofertando em média $96 nesse trabalho

eperfections

We can do this mysql php assignment. Please check INBOX!

$100 USD in 2 dias
(186 Comentários)
7.0
Sphinks

Let's do it. Regards, Sphinks!

$150 USD in 2 dias
(89 Comentários)
6.7
prasy8

Hi, please check p.m Thanks!

$90 USD in 7 dias
(18 Comentários)
5.4
yancy

I have experience working on php-mysql. Can get this done in few hours.

$75 USD em 1 dia
(18 Comentários)
5.0
chiuaua27

Check PMB ! :)

$150 USD in 3 dias
(14 Comentários)
4.3
brzias

Hi, please check PM, thanks.

$95 USD in 2 dias
(11 Comentários)
3.5
madhavan03

I am very good expertise in web technologies but new to freelancer. I can finish this project efficiently. Check PM.

$120 USD in 10 dias
(6 Comentários)
3.6
anthonymiller

Hi! I have experience working with mysql and php.

$40 USD in 3 dias
(5 Comentários)
3.5
TheFootOnline

I am ready to start. Please check your PM.

$100 USD in 4 dias
(2 Comentários)
3.2
amsak

Placing bid

$80 USD in 12 dias
(6 Comentários)
3.4
belginfish

Hey, I believe I can do this job fairly easily and quickly :) Check your PMB

$75 USD em 1 dia
(1 Comentário)
2.6
CheapGoodWork

I can do this! pay when satisfied with the work! Thanks!

$50 USD in 2 dias
(3 Comentários)
2.7
saurabhkackar

Hello sir, i would require only 1% of the total cost of the project initially. If you wish then you can pay the money after completion of work, i don't have any issue. Thanks.

$100 USD in 7 dias
(4 Comentários)
2.7
m4it

Please check PMB.

$90 USD in 4 dias
(2 Comentários)
2.5
adevelopers

Hello, Please view PM.

$80 USD in 2 dias
(0 Comentários)
0.0
olanrewaju111

Please your PIM

$200 USD in 2 dias
(0 Comentários)
0.0
indusfish

We have Passionate technology engineers having strong grips on PHP and Flash, Jquery, Ajax, Facebook app. development, google API integration and more. Additionally I have experience of customizing, skinning and t Mais

$150 USD in 30 dias
(0 Comentários)
0.0
gianoneil18

I've been an application developer for a year and worked most on php/mysql projects. I can start on this application immediately.

$100 USD in 6 dias
(0 Comentários)
0.0
pr1987

Please check PM sir.

$50 USD in 2 dias
(0 Comentários)
0.0
ankitlifepunk

i want to take this project and possibly i will complete this project before time !

$90 USD in 4 dias
(0 Comentários)
0.0