niche
-
Posts
3,671 -
Joined
-
Last visited
-
Days Won
17
Content Type
Profiles
Forums
Events
Everything posted by 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
-
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.
