Peruttu

PHP +MYSQL +NMS FORMMAIL

A project to take the input of a web form + get ipaddress of sender.

Save form information in MySQL database, based on rules change boolean flags in the database.

Send via nms formmail (NMS FORMMAIL ONLY) send email with certain columns as subject & body.

Initial database looks like this (db1)

------------From FORM

varchar FName

varchar LName

varchar Email

varchar City

varchar country

varchar Type

varchar Code

varchar indicator

--------------- END FROM FORM

varchar ip

Date Date

bool send

bool diff

bool wrongtype

bool already

bool incomplete

bool override

bool overridden

Second table (db2)

int code

varchar country

bool flag

third table (db3)

varchar indicator

varchar type

check country logic

if ip(db1)>code>country != db1 country

diff=true

else

diff=false

check indicator

if indicator(db1) not in type(db3)

wrong=true

else

wrong=false

if Fname<2

incomplete=true

else

incomplete=false

if FName=LName

incomplete=true

else

incomplete=false

if Fname[1]=Fname[2]=Fname[3] for len of fname

incomplete=true

else

incomplete=false

if LFname<2

incomplete=true

else

incomplete=false

if LName=FName

incomplete=true

else

incomplete=false

if Lname[1]=Lname[2]=Lname[3] for len of fname

incomplete=true

else

incomplete=false

if email in select email from db1

already=true

else

already=false

table 3 needs to be created from [url removed, login to view], they have php (needs to be 5) api to do the country check.

it needs to be put in a sql table, not as a disk file. Take a look at maxmind.

when the above checks are done, then it needs to call nms formmail with the subject

"send"

OR "diff"

OR "wrongtype"

OR "already"

OR "incomplete"

because the logic should mutually exclude each type

body containing three lines

1 sender (email)

2 type

3 code

Also a php script that allows to view the complete database from IE, in the form of column data, text boxes & check boxes for the bool options. that I can change the check boxs of, and when i click submit, it updates the database and calls again NMS formmail as above, but no rules are done, and ONLY for the override=true items, once sent it changes the state of override to false and overridden to true.

I hope thats complete enough for you, any questions ask.

STEVEN

Taidot: Linux, PHP

Näytä lisää: php nms, nms formmail mysql, subject php, sql get date, php send email script, mysql questions, mysql city state database, int i, city hope, nms formmail sql database, nms formmail database, nms php, php nms formmail, nms formmail flags, php end script, db2 like, get php, true, steven, sql mysql, php mysql database, php linux, php click, mysql, len

About the Employer:
( 0 reviews ) CAPE TOWN, South Africa

Projektin tunnus: #41140