Exemplo n.º 1
0
<?php

$servername = "localhost";
$username = "";
$password = "";
$dbname = "test";
$username = "******"" . htmlspecialchars($_POST["name"]) . "\"";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
$sql = "SELECT * FROM loginTest WHERE name LIKE " . $username;
$result = $conn->QUERY($sql);
if ($result->num_rows > 0) {
    // out out data of each row
    while ($row = $result->fetch_assoc()) {
        echo "name : " . $row["name"];
    }
} else {
    echo "0 results";
}
$conn->close();