SQL to PHP Converter

About SQL to PHP Converter

Convert SQL database dumps (CREATE TABLE and INSERT statements) to PHP code with support for indexed arrays, associative arrays, stdClass objects, and JSON strings. Perfect for web development, testing, seeding databases, and API development.

Key Features

• Multiple Output Formats: Associative arrays, indexed arrays, objects, and JSON
• Automatic Type Detection: Detects integers, floats, booleans, strings, and null values
• PHP Tags: Optional PHP opening and closing tags
• Code Comments: Descriptive comments for better code readability
• Variable Sanitization: Ensures valid PHP variable names
• File Download: Save as .php file for direct use in PHP projects

How to Use

1. Input SQL Data: Paste your SQL CREATE TABLE and INSERT statements or upload a .sql file
2. Choose Output Format: Select associative arrays, indexed arrays, objects, or JSON
3. Configure Options: Toggle PHP tags and comments inclusion
4. Copy or Download: Use the Copy or Download button to save your PHP code
5. Use in PHP: Include the code in your PHP application or script

Output Formats

Associative Arrays (Recommended):

• Array of arrays with named keys
• Easy to access values by column name
• Most common format in PHP applications
• Perfect for database result simulation

$products = [
    ['id' => 1, 'name' => 'Laptop', 'price' => 999.99],
    ['id' => 2, 'name' => 'Mouse', 'price' => 24.99]
];

Indexed Arrays:

• Array of arrays with numeric indices
• Includes header row as first element
• Compact representation
• Useful for CSV-like data structures

$products = [
    ['id', 'name', 'price'],
    [1, 'Laptop', 999.99],
    [2, 'Mouse', 24.99]
];

stdClass Objects:

• Array of stdClass objects
• Object-oriented approach
• Access properties with arrow notation
• Mimics database result objects

$products = [
    (object) ['id' => 1, 'name' => 'Laptop', 'price' => 999.99],
    (object) ['id' => 2, 'name' => 'Mouse', 'price' => 24.99]
];
// Access: $products[0]->name

JSON String:

• JSON-encoded string with decode example
• Perfect for API responses
• Easy to store and transmit
• Compatible with JavaScript

Example Conversion

SQL Input:

CREATE TABLE products (
  id INT,
  name VARCHAR(100),
  price DECIMAL(10,2)
);

INSERT INTO products VALUES (1, 'Laptop', 999.99);
INSERT INTO products VALUES (2, 'Mouse', 24.99);

PHP Output (Associative Arrays):

<?php

// products data
// Array of associative arrays
$products = [
    [
        'id' => 1,
        'name' => 'Laptop',
        'price' => 999.99
    ],
    [
        'id' => 2,
        'name' => 'Mouse',
        'price' => 24.99
    ]
];

// Usage example
// echo count($products); // Number of rows
// echo $products[0]['id']; // First row, first column
// foreach ($products as $row) { print_r($row); }

?>

Type Detection

The converter automatically detects and converts data types:

• Integers: 1, 42, -10 → PHP int
• Floats: 3.14, 99.99, -0.5 → PHP float
• Booleans: true, false → true, false
• Strings: 'text', "value" → 'text', 'value'
• NULL: NULL, null, empty → null

Common Use Cases

• Testing: Create test data for unit tests and integration tests
• Database Seeding: Seed development databases with sample data
• API Development: Mock API responses during development
• Data Migration: Transfer data between systems
• Configuration Files: Store configuration data in PHP arrays
• Fixtures: Create fixtures for PHPUnit tests

Working with Arrays

Once you have the PHP array, you can perform various operations:

// Count rows
$count = count($products);

// Access specific row
$firstProduct = $products[0];

// Access specific value
$productName = $products[0]['name'];

// Loop through rows
foreach ($products as $product) {
    echo $product['name'] . ': $' . $product['price'] . "\n";
}

// Filter rows
$expensive = array_filter($products, function($p) {
    return $p['price'] > 100;
});

// Map values
$names = array_map(function($p) {
    return $p['name'];
}, $products);

// Sort by price
usort($products, function($a, $b) {
    return $a['price'] <=> $b['price'];
});

Working with Objects

When using stdClass objects:

// Access properties
echo $products[0]->name;
echo $products[0]->price;

// Loop through objects
foreach ($products as $product) {
    echo $product->name . ': $' . $product->price . "\n";
}

// Convert to array
$productArray = (array) $products[0];

// Convert to JSON
$json = json_encode($products);

JSON Usage

When using JSON format:

// Decode to associative array
$products = json_decode($products_json, true);

// Decode to objects
$products = json_decode($products_json);

// Send as API response
header('Content-Type: application/json');
echo $products_json;

// Save to file
file_put_contents('products.json', $products_json);

Integration Examples

Laravel Seeding:

// database/seeders/ProductSeeder.php
public function run()
{
    $products = [
        ['id' => 1, 'name' => 'Laptop', 'price' => 999.99],
        ['id' => 2, 'name' => 'Mouse', 'price' => 24.99]
    ];
    
    DB::table('products')->insert($products);
}

PHPUnit Testing:

// tests/ProductTest.php
public function testProductData()
{
    $products = [
        ['id' => 1, 'name' => 'Laptop', 'price' => 999.99],
        ['id' => 2, 'name' => 'Mouse', 'price' => 24.99]
    ];
    
    $this->assertCount(2, $products);
    $this->assertEquals('Laptop', $products[0]['name']);
}

API Response:

// api/products.php
header('Content-Type: application/json');
$products = [
    ['id' => 1, 'name' => 'Laptop', 'price' => 999.99],
    ['id' => 2, 'name' => 'Mouse', 'price' => 24.99]
];
echo json_encode($products);

Best Practices

• Use Associative Arrays: Most flexible and commonly used format
• Include Comments: Makes code more maintainable
• Validate Data: Always validate data before using in production
• Use Type Hints: Add type hints in PHP 7.4+ for better code quality
• Consider Performance: For large datasets, consider database queries instead

Privacy & Security

All conversions happen locally in your browser. Your SQL data is never uploaded to any server, ensuring complete privacy and security.