Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 466353" data-attributes="member: 36373">You are using $_POST on your server, which means your form should do a POST request.A few other things I am going to point out:1) Your table should be normalized. You are storing data in here multiple times. What happens if someone changes their username?Table 1: Associated_Users[ID] [USERNAME]Here you can change the username column without affecting the other tablesTable 2: [ID] [PAID_ASSOC_USER] [PAYEE_ASSOC_USER] [MESSAGE]Sample Records would be:Table 1-[1] [Revali][2] [Caitlin][3] [Jess!][4] [Nick]Table 2-[1] [1] [3] [20SC and 2T] (Jess paid Revali)[2] [2] [3] [20 SC and 2T] (Jess paid Caitlin)[3] [2] [4] [4t/5sc] (Nick paid Caitlin)If you change your posts to $_GET[''] and then you do a URL request by doing:submit.php?name=Test&amp;message=Testing&amp;payee=Test2Does it add it to the record? My suggestion is to get it working with the GET request, then swap them to POST, if it doesn't work it's an issue with ur form.On your PHP side, I would like to see the full PHP code as well. There is no brackets, which means if you load this page up it's going to execute regardless if you have submitted the form or not, and ur not checking if those values are set or verifying the inputs before you use them. You're not sanitizing them either.</blockquote>

[QUOTE="JayC, post: 466353, member: 36373"] You are using $_POST on your server, which means your form should do a POST request. A few other things I am going to point out: 1) Your table should be normalized. You are storing data in here multiple times. What happens if someone changes their username? Table 1: Associated_Users [ID] [USERNAME] Here you can change the username column without affecting the other tables Table 2: [ID] [PAID_ASSOC_USER] [PAYEE_ASSOC_USER] [MESSAGE] Sample Records would be: Table 1- [1] [Revali] [2] [Caitlin] [3] [Jess!] [4] [Nick] Table 2- [1] [1] [3] [20SC and 2T] (Jess paid Revali) [2] [2] [3] [20 SC and 2T] (Jess paid Caitlin) [3] [2] [4] [4t/5sc] (Nick paid Caitlin) If you change your posts to $_GET[''] and then you do a URL request by doing: submit.php?name=Test&message=Testing&payee=Test2 Does it add it to the record? My suggestion is to get it working with the GET request, then swap them to POST, if it doesn't work it's an issue with ur form. On your PHP side, I would like to see the full PHP code as well. There is no brackets, which means if you load this page up it's going to execute regardless if you have submitted the form or not, and ur not checking if those values are set or verifying the inputs before you use them. You're not sanitizing them either. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members