sql - Modify $select to allow for searching in php -
how modify $select function allow searching database when customer types in search text , clicks "search"? i'd able type in form field, , php automatically updates page form data dynamically , able define field search upon in database! this letting me view customers table: $select = $db->query("select * customers order id desc"); <?php if (!$select->num_rows) { echo '<p>', 'no records', '</p>'; }else{ ?> <table border="1" width="100%"> <thead> <tr> <th>first name</th> <th>last name</th> </tr> </thead> <tbody> <?php while ($row = $select->fetch_object()) { ?> <tr> <td><?php ec...