⚡ PHP DB Helper

Useful snippets for modern PHP development with support for:

• Database connections (PDO and MySQLi)
• Secure transactions
• File uploads
• Quick debugging
• Connection closing
• New: HTML snippets for PHP files

Perfect for those who don't want to memorize repetitive code!

✨ Features

• 🔌 Database connections (PDO and MySQLi)
• 🔒 Secure prepared queries
• 📂 File upload snippet with validation
• ⚙️ Transactions and error handling
• 🐞 Debugging snippets (print_r, var_dump)
• 🌐 HTML snippets for PHP files
• 📄 Clean, clear, and reusable code

🚀 How to use

Requirements

-   Visual Studio Code `^1.90.0`
-   PHP `^7.4` or higher

1. Install the extension from the Marketplace or as .vsix
2. Open a .php or .html file
3. Type one of the following prefixes and press Tab or Enter:

📚 Snippet list

PDO

MySQLi

Files

Debugging

HTML in PHP

💡 Usage examples

PDO Connection

// Type: pdo-conn
$host = '127.0.0.1';
$dbname = 'database_name';
$user = 'root';
$password = '';
$port = '3306';
$charset = 'utf8mb4';

try {
    $conn = new PDO("mysql:host=$host;dbname=$dbname;port=$port;charset=$charset", $user, $password);
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    echo 'Connection successful';
} catch (PDOException $e) {
    echo 'Connection error: ' . $e->getMessage();
    exit();
}

File Upload

// Type: php-upload-file
if (isset($_FILES["filename"]) && $_FILES["filename"]["error"] === UPLOAD_ERR_OK) {
    $fileTmpPath = $_FILES["filename"]["tmp_name"];
    $fileName = $_FILES["filename"]["name"];
    $fileSize = $_FILES["filename"]["size"];
    $fileType = $_FILES["filename"]["type"];

    $fileExtension = strtolower(pathinfo($fileName, PATHINFO_EXTENSION));
    $newFileName = uniqid("file_") . '.' . $fileExtension;

    $uploadDir = __DIR__ . "/uploads/";
    $destPath = $uploadDir . $newFileName;

    if (!is_dir($uploadDir)) {
        mkdir($uploadDir, 0755, true);
    }

    if (move_uploaded_file($fileTmpPath, $destPath)) {
        echo 'File uploaded successfully: ' . $newFileName;
    } else {
        echo 'Error moving the uploaded file.';
    }
}

HTML in PHP

<!-- Type: echo-var-html -->
<?= $variable ?>

📞 Contact

For questions, support, or collaboration, please contact:

• Andrés Gutiérrez Hurtado
• Email: andres52885241@gmail.com
• LinkedIn: Andrés Gutiérrez
• GitHub: @AndresGutierrezHurtado
• Portfolio: Portfolio link

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.