Displaying SQL query result from user input via wpdb
use this snippet it works <?php if(isset($_POST[“ICNo”])) { global $wpdb; $name = $_POST[“ICNo”]; $resultsap = $wpdb->get_results( $wpdb->prepare( “SELECT * FROM wp_apelc_users WHERE icno = %s”, $name ) ); foreach ($resultsap as $row) { echo ‘Name: ‘ . $row->name; } } ?> <form method=”post”> <div> Your IC No: <input type=”text” name=”ICNo”> <input type=”submit” name=”submit” value=”Submit” > … Read more