Search

Guide for MySQL Database Handling in PHP

1 views
PHP, it becomes a powerful tool for web applications.

Prompt
CREATE DATABASE your_db_name;

Prompt
<?php $server = "your_server"; $username = "your_username"; $password = "your_password"; $db = "your_db_name"; // Connection $conn = new mysqli($server, $username, $password, $db); // Check if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Connected successfully"; ?>

Ensure your credentials are kept securely.

Prompt
$sql = "INSERT INTO table_name (column1, column2) VALUES (value1, value2)"; if ($conn->query($sql) === TRUE) { echo "Data inserted successfully"; } else { echo "Error: " . $sql . "<br>" . $conn->error; }

Prompt
$sql = "SELECT column1, column2 FROM table_name"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo "Column 1: " . $row["column1"]. " - Column 2: " . $row["column2"]. "<br>"; } } else { echo "0 results"; }

Prompt
$sql = "UPDATE table_name SET column1=value1 WHERE condition"; if ($conn->query($sql) === TRUE) { echo "Data updated successfully"; } else { echo "Error updating: " . $conn->error; }

Prompt
$sql = "DELETE FROM table_name WHERE condition"; if ($conn->query($sql) === TRUE) { echo "Data deleted successfully"; } else { echo "Error deleting: " . $conn->error; }

Prompt
$conn->close();

prepared statements for better security against SQL injection.

Prompt
$stmt = $conn->prepare("INSERT INTO table_name (column1, column2) VALUES (?, ?)"); $stmt->bind_param("ss", value1, value2); $stmt->execute(); $stmt->close();

phpMyAdmin, offer easy backup options.

Suggest a Correction

Found an error or have a suggestion? Let us know and we'll review it.

Share this article

Comments (0)

Please sign in to leave a comment.

No comments yet. Be the first to comment!