niche

Sure.  A javascript function could easily handle that. 

EDIT:

the function could have a 

https://www.w3schools.com/jsref/jsref_match.asp

and a 

https://www.w3schools.com/jsref/jsref_match.asp

https://www.w3schools.com/html/html_form_elements.asp

see "selection"

https://stackoverflow.com/questions/3632075/mysqli-giving-commands-out-of-sync-error-why

see first answer

EDIT:

suggest you use a sub query or simply use two different queries 

a few  more facts pls

https://stackoverflow.com/questions/27088849/how-to-insert-a-calculated-sum-in-a-table

see the 2nd answer 

here's how you do an INSERT:

https://www.w3schools.com/sql/sql_insert.asp

when i was a beginner I'd do two INSERTS.  One to INSERT the original data and one to UPDATE (do the calcs)

here's how you do an UPDATE:

https://www.w3schools.com/sql/sql_update.asp

what does your INSERT look like?

EDIT:

here's a link that I refer to from time to time that might help:

https://stackoverflow.com/questions/11754781/how-to-declare-a-variable-in-mysql

still need to see your INSERT 

EDIT EDIT:

why no ID in your table?

Gotcha on that open {

BTW, I've seen editors that have a hot key that auto formats pasted code.  is that what you used?  if so, which editor do you use?

if not, returning manually formatted code is above and beyond.

either way, great work.  

let me know about your editor.

thx again dsonesuk 

wouldn't have got that.

thx dsonesuk

EDIT

Does your text editor have a function to test for an open curly bracket? 

looks like you need a ; at the end of this line:

$mbox = IMAP stream, $mid = message id  

pls post with the code tags <>

might as well post your code so we can see what's actually on line 73

Try using value ="some data" instead of placeholder. 

 value =" ' . <?php $var ?> . ' "

or

value =" ' . <?php $var['columnName']  ?> . ' "

depending on situation if I'm understanding your question 

create a variable for everything inside the parens.   

Do you need procedural or OO code?

Please post the relevant file content or a sample.

just put commas between the words.

else, you'll need to use something like php if you have a lot of them.

Where's the relevant part of your code?

My understanding is that PDO does the sanitation for you.

Validation is a different issue.

Bingo:

https://www.w3schools.com/php/php_mysql_create.asp

This will help too:

http://www.developphp.com/video/PHP/PDO-Prepared-Statements-PHP-Tutorial

These will get you started

Also, remember that google is your friend.  Always consider googling your topic.  A good google will always produce plenty of likely answers.  That's especially helpful when almost everyone's asleep.

This will get you started: https://www.w3schools.com/php/php_forms.asp

The answer to your specific question is you'd use a $_GET or $_POST method.

You probably have a problem when you bindParam especially when you expect a different row count. 

Is :voor really an INT?

http://php.net/manual/en/pdostatement.bindparam.php

Also, you need to use try/catch for errors.

dsonesuk's example is much simpler than the one I found: https://codepen.io/quasimondo/pen/lDdrF

https://www.w3schools.com/css/css_rwd_intro.asp

I use file filezilla for ftp client to upload.