[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]
