Nyambung lan Query Database MySQL ing PHP

Nyambung lan takon database MySQL ing PHP minangka bagean penting saka pangembangan web. PHP nyedhiyakake fungsi lan cara sing ngidini kita nyambung menyang database MySQL, nindakake pitakon, lan sesambungan karo data.

Kanggo nyambung menyang database MySQL, kita nggunakake mysqli_connect() utawa mysqli fungsi kanggo nggawe sambungan lan pass ing paramèter kayata jeneng server, jeneng pangguna, sandi, lan jeneng database. Sawise sambungan digawe, kita bisa nglakokake pitakon SQL kayata SELECT, INSERT, UPDATE, DELETE kanggo njupuk lan ngapusi data ing basis data.

 

Nyambung menyang database MySQL

<?php  
$servername = "localhost";  
$username = "your_username";  
$password = "your_password";  
$database = "your_database";  
  
// Connect to MySQL database  
$conn = mysqli_connect($servername, $username, $password, $database);  
  
// Check connection  
if(!$conn) {  
    die("Connection failed: ". mysqli_connect_error());  
}  
  
echo "Connected successfully!";  
?>  

 

Njaluk MySQL Database ing PHP

Sawise kasil nyambungake, kita bisa nindakake pitakon database nggunakake mysqli_query() fungsi kasebut. Iki minangka conto carane nindakake pitakon SELECT ing PHP:

<?php  
$sql = "SELECT * FROM users";  
$result = mysqli_query($conn, $sql);  
  
if(mysqli_num_rows($result) > 0) {  
    // Loop through records and display data  
    while($row = mysqli_fetch_assoc($result)) {  
        echo "ID: ". $row["id"]. "- Name: ". $row["name"]. "<br>";  
    }  
} else {  
    echo "No records found.";  
}  
  
// Free memory of query result  
mysqli_free_result($result);  
  
// Close database connection  
mysqli_close($conn);  
?>  

 

nglebokake Data menyang Database MySQL ing PHP

Kanggo nglebokake data menyang database MySQL nggunakake PHP, kita nggunakake fungsi mysqli_query() karo statement INSERT INTO. Iki contone:

<?php  
$name = "John Doe";  
$email = "[email protected]";  
$age = 30;  
  
$sql = "INSERT INTO users(name, email, age) VALUES('$name', '$email', '$age')";  
  
if(mysqli_query($conn, $sql)) {  
    echo "Data inserted successfully!";  
} else {  
    echo "Error: ". mysqli_error($conn);  
}  
?>  

 

Nganyari Data ing Database MySQL ing PHP

Kanggo nganyari data ing database MySQL nggunakake PHP, kita nggunakake fungsi mysqli_query() karo statement UPDATE. Iki contone:

<?php  
$id = 1;  
$newEmail = "[email protected]";  
  
$sql = "UPDATE users SET email='$newEmail' WHERE id=$id";  
  
if(mysqli_query($conn, $sql)) {  
    echo "Data updated successfully!";  
} else {  
    echo "Error: ". mysqli_error($conn);  
}  
?>  

 

Mbusak Data saka Database MySQL ing PHP

Kanggo mbusak data saka database MySQL nggunakake PHP, kita nggunakake fungsi mysqli_query() karo statement DELETE. Punika conto

<?php  
$id = 1;  
  
$sql = "DELETE FROM users WHERE id=$id";  
  
if(mysqli_query($conn, $sql)) {  
    echo "Data deleted successfully!";  
} else {  
    echo "Error: ". mysqli_error($conn);  
}  
?>