Haɗawa da Tambaya MySQL Database a cikin PHP

Haɗawa da tambayar bayanan MySQL a cikin PHP wani muhimmin sashi ne na ci gaban yanar gizo. PHP yana ba da ayyuka da hanyoyin da ke ba mu damar haɗi zuwa bayanan MySQL, yin tambayoyi, da yin hulɗa tare da bayanai.

Don haɗawa zuwa bayanan MySQL, muna amfani da mysqli_connect() ko mysqli aikin don kafa haɗin gwiwa kuma mu wuce cikin sigogi kamar sunan uwar garken, sunan mai amfani, kalmar sirri, da sunan bayanai. Da zarar an kafa haɗin, za mu iya aiwatar da tambayoyin SQL kamar su SELECT, INSERT, UPDATE, DELETE don dawo da sarrafa bayanai a cikin bayanan.

 

Haɗa zuwa MySQL database

<?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!";  
?>  

 

Tambayar MySQL Database a cikin PHP

Bayan haɗin kai cikin nasara, za mu iya yin tambayoyin bayanai ta amfani da mysqli_query() aikin. Ga misalin yadda ake yin tambayar SELECT a cikin 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);  
?>  

 

saka Data a cikin MySQL Database a cikin PHP

Don saka bayanai a cikin bayanan MySQL ta amfani da PHP, muna amfani da mysqli_query() aikin tare da sanarwar INSERT INTO. Ga misali:

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

 

Ana sabunta bayanai a cikin MySQL Database a cikin PHP

Don sabunta bayanai a cikin bayanan MySQL ta amfani da PHP, muna amfani da mysqli_query() aikin tare da bayanin UPDATE. Ga misali:

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

 

Share Data daga MySQL Database a cikin PHP

Don share bayanai daga bayanan MySQL ta amfani da PHP, muna amfani da mysqli_query() aikin tare da bayanin DELETE. Ga misali

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