Question from a new guy.
Posted: Fri Aug 15, 2008 4:20 am
Hey all
I'm quite new to the whole PHP scripting, so please don't assume i know stuff
Basic info:
Database name: parcvx
Database tables:
"parcv1table"
columns: id | servername | selectproject | typeserver | cabinet | aantalru | publicpoort | privatepoort | notes | ipnummer
(id = auto incr.)
and
"parcv2table"
columns: id | opleverid | checklist | value
(id = auto incr.)
--------------------------------------------------------------------------------------
The files i'm working with:
Here are the 3 files i created:
Index.html = the form that has to be filled in and send to "verwerken.php"
verwerken.php = Checking if the form has been filled in properly + inserting info into database
uitvoeren.php = printing the choices made in the form.
----------------------------------------------------------------
Here is where i get stuck:
Problem #1:
the column "opleverid" (within table "parcv2table") has to contain the "id" from the entry that has been made and inserted into the database that session. So someone fills in the form, mysql creates an "id" automaticly, that id has to be inserted/copied to the column "opleverid"
Problem #2:
the column "value" (within table "parcv2table") has to contain a simple "Y" or "N" depending on what has been selected within the "radiobutton-area" on the form.
Problem #3:
the column "checklist" (within table "parcv2table") has to contain the text for the proper value.
I.E:
someone selected "Yes" for "bsmtp", so it should be insterted into the database like:
---------------------------------------------------------------
This is where my knowledge stops, I hope i didn't scare you guys off with this long Openings post.
Thanks in advance for the help that i might get.
Salut!
I'm quite new to the whole PHP scripting, so please don't assume i know stuff
Basic info:
Database name: parcvx
Database tables:
"parcv1table"
columns: id | servername | selectproject | typeserver | cabinet | aantalru | publicpoort | privatepoort | notes | ipnummer
(id = auto incr.)
and
"parcv2table"
columns: id | opleverid | checklist | value
(id = auto incr.)
--------------------------------------------------------------------------------------
The files i'm working with:
Here are the 3 files i created:
Code: Select all
http://www.uploading.com/files/ZFNRQZIS/index.html.html
http://www.uploading.com/files/R9RGACUB ... n.php.html
http://www.uploading.com/files/JCYOVU6B ... n.php.html
verwerken.php = Checking if the form has been filled in properly + inserting info into database
uitvoeren.php = printing the choices made in the form.
----------------------------------------------------------------
Here is where i get stuck:
Problem #1:
the column "opleverid" (within table "parcv2table") has to contain the "id" from the entry that has been made and inserted into the database that session. So someone fills in the form, mysql creates an "id" automaticly, that id has to be inserted/copied to the column "opleverid"
Problem #2:
the column "value" (within table "parcv2table") has to contain a simple "Y" or "N" depending on what has been selected within the "radiobutton-area" on the form.
Problem #3:
the column "checklist" (within table "parcv2table") has to contain the text for the proper value.
I.E:
someone selected "Yes" for "bsmtp", so it should be insterted into the database like:
Code: Select all
| id | opleverid | checklist | value |
| 30 | 5 | bsmtp | | Y |
This is where my knowledge stops, I hope i didn't scare you guys off with this long Openings post.
Thanks in advance for the help that i might get.
Salut!