PHP MYSQLI Examples

Programming Language: PHP

Class/Type: MYSQLI

Examples at hotexamples.com: 2

PHP mysqli is a package library that provides an interface to communicate with MySQL databases in PHP. It is an improved variant of the classic PHP mysql extension which provides support for prepared statements.

Example 1: Connection to the MySQL database

$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);
}

Example 2: Select query execution

$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.

PHP MYSQLI - 2 examples found. These are the top rated real world PHP examples of MYSQLI extracted from open source projects. You can rate examples to help us improve the quality of examples.

Frequently Used Methods

Show Hide

prepare(2)

Example #1

Show file

File: battlefield-process.php Project: smmcmanus/academic_work

    echo "Soldiers not entered";
    exit;
}
if (!isset($_POST['duration'])) {
    echo "Duration not entered";
    exit;
}
if (!isset($_POST['critique'])) {
    echo "Critique not entered";
    exit;
}
$ammo = (int) $_POST['ammo'];
$soldiers = (int) $_POST['soldiers'];
$duration = (double) $_POST['duration'];
$critique = $_POST['critique'];
$mysqli = new MYSQLI('localhost', 'root', '#WashUBears#', 'battlefield');
if ($mysqli->connect_errno) {
    printf("Connection Failed: %s\n", $mysqli->connect_error);
    exit;
}
$stmt = $mysqli->prepare("INSERT INTO reports (ammunition, soldiers, duration, critique) VALUES (?, ?, ?, ?)");
if (!$stmt) {
    printf("Query Prep Failed: %s\n", $mysqli->error);
    exit;
}
$stmt->bind_param('iids', $ammo, $soldiers, $duration, $critique);
if ($stmt->execute()) {
    header("location: battlefield-submit.html");
} else {
    echo "SQL Query Failed";
    exit;

Example #2

Show file

File: battlefield-analyze.php Project: smmcmanus/academic_work

	margin: 0 auto;
	padding: 0;
	font:12px/16px Verdana, sans-serif; /* default font */
}
div#main{
	background-color: #FFF;
	margin: 0;
	padding: 10px;
}
</style>
</head>
<body><div id="main">
 	<h1>Battlefield Analysis</h1>
 	<h2>Latest Critiques</h2>
 	<?php 
$mysqli = new MYSQLI('localhost', 'root', '#WashUBears#', 'battlefield');
if ($mysqli->connect_errno) {
    printf("Connection Failed: %s\n", $mysqli->connect_error);
    exit;
}
$stmt = $mysqli->prepare("select critique from reports order by posted limit 5");
if (!$stmt) {
    printf("Query Prep Failed: %s\n", $mysqli->error);
    exit;
}
$stmt->execute();
$stmt->bind_result($critique);
echo "<ul>";
while ($stmt->fetch()) {
    printf("\t<li>%s</li>\n", htmlspecialchars($critique));
    echo "</ul>\n";