Overview Version History Q & A Rating & Review
🧩 Epsilon Snippets – PHP MySQLi (Procedural)
Epsilon Snippets is a Visual Studio Code extension that provides ready-to-use PHP snippets for working with MySQL databases using the procedural MySQLi approach — no OOP, no unnecessary complexity.
Perfect for developers who prefer clean, straightforward PHP with mysqli_*
functions.
🚀 Installation
Open Visual Studio Code
Go to the Extensions view (Ctrl+Shift+X
)
Search for: Epsilon Snippets
Click Install
⚙️ Usage
Open any .php
file
Start typing a snippet prefix (e.g., mysqli-conn
)
Select the suggestion from the autocomplete menu
Press Tab
or Enter
to insert the snippet
📋 Available Snippets
Prefix
Description
mysqli-conn
Connect to a MySQL database (procedural)
mysqli-query
Run a SELECT query and loop through results
mysqli-insert
Insert data into a table
mysqli-prepare-select
Use a prepared SELECT statement (procedural)
mysqli-close
Close the MySQL connection
💡 Example
Typing mysqli-query
generates:
$sql = "SELECT * FROM table";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result)) {
echo "Column: " . $row["column"] . "<br>";
}
} else {
echo "0 results";
}