$servername = "localhost"; $username = "myusername"; $password = "mypassword"; $dbname = "mydatabase"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); }
$sql = "SELECT * FROM users WHERE age > ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $age); $stmt->execute(); $result = $stmt->get_result(); while ($row = $result->fetch_assoc()) { echo $row["name"] . " / " . $row["email"] . "In both examples, we make use of the mysqli package library to connect and execute select queries on a MySQL database.
"; }