[insert_php] $q=$_GET[‘q’]; define(‘DB_HOST’, ‘127.0.0.1:3306’); define(‘DB_USER’, ‘u352426919_69P0r’); define(‘DB_PASS’, ‘NJboSkz3h1’); define(‘DB_NAME’, ‘u352426919_vh1aT’); $con = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME); //Checking if any error occured while connecting if (mysqli_connect_errno()) { echo “Failed to connect to MySQL: ” . mysqli_connect_error(); } $sql=”SELECT * FROM single_registration WHERE pname like ‘%”.$q.”%'”; $result =$con->query($sql); $row = mysqli_fetch_array($result); echo “
| Pname | Gname | Mobno | Art1 | Art2 |
“; while ($row = mysqli_fetch_array($result)) { echo ““; echo “| ” . $row[‘pname’] . “ | “; echo “” . $row[‘gname’] . “ | “; echo “” . $row[‘mobno’] . “ | “; echo “” . $row[‘fafile’] . “ | “; echo “” . $row[‘safile’] . “ | “; echo “
“; } echo “
“; $con->close(); [/insert_php]