The following warnings occurred:

Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux) File Line Function /global.php 783 errorHandler->error /printthread.php 16 require_once Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux) File Line Function /global.php 783 errorHandler->error /printthread.php 16 require_once Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.31 (Linux) File Line Function /global.php(841) : eval()'d code 40 errorHandler->error /global.php 841 eval /printthread.php 16 require_once Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.31 (Linux) File Line Function /global.php 909 errorHandler->error /printthread.php 16 require_once Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.31 (Linux) File Line Function /inc/functions.php 5024 errorHandler->error /global.php 909 build_theme_select /printthread.php 16 require_once Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.31 (Linux) File Line Function /inc/functions.php 7162 errorHandler->error /inc/functions.php 5044 is_member /global.php 909 build_theme_select /printthread.php 16 require_once Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (Linux) File Line Function /inc/functions.php 1415 errorHandler->error /inc/functions.php 1370 fetch_forum_permissions /printthread.php 76 forum_permissions Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 160 errorHandler->error Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 165 errorHandler->error Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 160 errorHandler->error Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux) File Line Function /printthread.php 165 errorHandler->error

Searching the database-PHP help - Printable Version +- Form Tools (https://forums.formtools.org) +-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1) +--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5) +--- Thread: Searching the database-PHP help (/showthread.php?tid=16798)

Searching the database-PHP help - jgold723 - Oct 31st, 2016 I've been using FT for several years to create databases and push data into them. Works great. I was able to build a pretty simple static PHP script to query the database for a set of criteria (field1=X AND field2=Y), extract data and display it. Now I'd like to build a more dynamic search form to allow users to search multiple fields in the database and I seem to be stumped. I understand the basics of building the form and pointing it at the script, etc. But for some reason I'm not getting any results. Anyway, I'm wondering if someone can point me to a resource that would be helpful for developing this? Thanks, John RE: Searching the database-PHP help - alexh - Oct 31st, 2016 Hey John, Are you looking to have text input fields, or will this be a drop down with preformatted queries? This should get you on the right track: http://www.pontikis.net/blog/dynamically-bind_param-array-mysqli I think the most important thing to think about is preventing MySQL injection through the user's input. I hope this helps.. if not let me know. I'm on mobile right now otherwise I'd see what resources I have bookmarked. Alex