PHP - Jobba med databaser

Läs från MySQL-databas (Mysqli)

Procedural stil

Spar exempelkoden nedan i en fil med filändelsen .php

Exempelkod:

<?php
// connect
$host = "127.0.0.1";
$user = "db_username";
$password = "password for db_username"; 
$database = "db_name";
$conn = mysqli_connect($host, $user, $password, $database, 3306);

//check connection
if(mysqli_connect_errno()){
echo "Connect failed";
exit();
}

echo "Connected to database";

$query = "SELECT FirstName, LastName FROM users";
$result = mysqli_query($conn, $query);

foreach($result as $row){
 echo $row["FirstName"]." ".$row["LastName"]."<br>";
}

// close connection
mysqli_close($conn);
?>

Objekt-orienterad stil

Spar exempelkoden nedan i en fil med filändelsen .php

Exempelkod:

<?php
// connect
$host = "127.0.0.1";
$user = "db_username";
$password = "password for db_username"; 
$database = "db_name";
$mysqli = new mysqli($host, $user, $password, $database, 3306);

// check connection
if($mysqli->connect_errno){
 printf("Connect failed: %s\n", $mysqli->connect_error);
 exit();
}
 
echo "Connected to database";

$query = "SELECT FirstName, LastName FROM users";
$result = $mysqli->query($query);

foreach($result as $row){
 echo $row["FirstName"]." ".$row["LastName"]."<br>";
}

// close result set
$result->close();

// close connection
$mysqli->close();
?>

Till toppen