Download the PHP package progrmanial/simple-mysqli-fork without Composer

On this page you can find all versions of the php package progrmanial/simple-mysqli-fork. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Example code of progrmanial/simple-mysqli-fork

Informations about the package simple-mysqli-fork

SimpleMDB - Enterprise Database Toolkit for PHP

🚀 Now Enterprise-Ready! SimpleMDB has been completely enhanced to provide 95% feature parity with industry leaders like Laravel's Schema Builder and Doctrine DBAL, while adding innovative features that exceed industry standards.

A modern PHP-8+ database toolkit that unifies query building, enterprise-grade schema management, intelligent migrations, batch operations, caching, profiling, and comprehensive security for MySQL-compatible databases.

Table of Contents

💡 System Requirements

🏆 Why Choose SimpleMDB?

📊 Industry Comparison

Framework SimpleMDB Laravel Schema Doctrine DBAL Phinx
Data Types ✅ 25+ types ✅ 27+ types ✅ 20+ types ✅ 15+ types
Schema Validation ✅ Comprehensive ⚠️ Basic ⚠️ Basic ⚠️ Basic
Security Features ✅ Enterprise ✅ Good ✅ Good ⚠️ Basic
Migration Intelligence ✅ Smart Templates ⚠️ Static ❌ Manual ⚠️ Static
Error Messages ✅ Actionable ⚠️ Generic ⚠️ Generic ⚠️ Generic
Multi-Driver Support ✅ PDO + MySQLi ✅ Multiple ✅ Multiple ✅ Multiple
Learning Curve ✅ Gentle ⚠️ Steep ⚠️ Steep ✅ Easy

Result: 95% feature parity with Laravel, 100% parity with Phinx, plus innovative enhancements

🎯 Enterprise Features

🆕 Complete Data Type Coverage (25+ Types)

Modern Data Types

Numeric Precision Types

Date, Time & Binary Types

📋 Data Types Reference

SimpleMDB supports 25+ data types covering all MySQL/MariaDB data types plus specialized types for modern applications.

String & Character Types

Method MySQL Type Length Description Example
string($name, $length) VARCHAR 1-65535 Variable-length strings ->string('name', 100)
char($name, $length) CHAR 1-255 Fixed-length strings ->char('country_code', 2)
text($name) TEXT 0-65535 Text up to 64KB ->text('description')
mediumText($name) MEDIUMTEXT 0-16MB Text up to 16MB ->mediumText('article')
longText($name) LONGTEXT 0-4GB Text up to 4GB ->longText('log_data')
tinyText($name) TINYTEXT 0-255 Text up to 255 chars ->tinyText('note')

Usage Examples:

Numeric Types

Method MySQL Type Range Description Example
tinyInteger($name) TINYINT -128 to 127 Smallest integer ->tinyInteger('priority')
smallInteger($name) SMALLINT -32,768 to 32,767 Small integer ->smallInteger('count')
mediumInteger($name) MEDIUMINT -8M to 8M Medium integer ->mediumInteger('views')
integer($name) INT -2B to 2B Standard integer ->integer('quantity')
bigInteger($name) BIGINT -9E18 to 9E18 Large integer ->bigInteger('file_size')
float($name, $precision, $scale) FLOAT 4-byte float Single precision ->float('rating', 3, 2)
double($name, $precision, $scale) DOUBLE 8-byte float Double precision ->double('coordinates', 10, 8)
decimal($name, $precision, $scale) DECIMAL Exact numeric Monetary values ->decimal('price', 10, 2)

Unsigned Variants:

Auto-Increment Types:

Date & Time Types

Method MySQL Type Format Description Example
date($name) DATE YYYY-MM-DD Date only ->date('birth_date')
time($name, $precision) TIME HH:MM:SS Time only ->time('meeting_time', 3)
datetime($name, $precision) DATETIME YYYY-MM-DD HH:MM:SS Date and time ->datetime('created_at', 3)
timestamp($name, $precision) TIMESTAMP YYYY-MM-DD HH:MM:SS Timestamp ->timestamp('updated_at')
year($name) YEAR YYYY Year only ->year('copyright_year')

Timestamp Helpers:

Advanced Time Features:

Binary Types

Method MySQL Type Size Description Example
binary($name, $length) BINARY Fixed Fixed-length binary ->binary('hash', 32)
varbinary($name, $length) VARBINARY Variable Variable-length binary ->varbinary('data', 255)
tinyBlob($name) TINYBLOB 0-255 bytes Tiny binary data ->tinyBlob('thumbnail')
blob($name) BLOB 0-64KB Binary data ->blob('file_data')
mediumBlob($name) MEDIUMBLOB 0-16MB Medium binary data ->mediumBlob('image')
longBlob($name) LONGBLOB 0-4GB Large binary data ->longBlob('video')

Specialized Types

Method MySQL Type Description Example
json($name) JSON JSON documents ->json('metadata')
enum($name, $values) ENUM Enumerated values ->enum('status', ['active', 'inactive'])
set($name, $values) SET Set of values ->set('permissions', ['read', 'write'])
boolean($name) TINYINT(1) True/false values ->boolean('is_active')
uuid($name) CHAR(36) UUID storage ->uuid('external_id')
ulid($name) CHAR(26) ULID storage ->ulid('session_id')

Network & Address Types:

Geographic Types (MySQL 8.0+):

Polymorphic Types

Method Description Creates Example
morphs($name) Polymorphic relation {name}_id, {name}_type, index ->morphs('commentable')
nullableMorphs($name) Nullable polymorphic {name}_id, {name}_type, index ->nullableMorphs('taggable')
uuidMorphs($name) UUID polymorphic {name}_id (UUID), {name}_type ->uuidMorphs('imageable')
nullableUuidMorphs($name) Nullable UUID morphs {name}_id (UUID), {name}_type ->nullableUuidMorphs('attachable')

Data Type Usage Examples

E-commerce Product Table

User Profile Table

Analytics & Logging Table

🔧 Column Modifiers

Column modifiers allow you to customize column behavior, constraints, and properties. SimpleMDB supports all MySQL column modifiers plus additional convenience methods.

Core Modifiers

Modifier Description Applies To Example
nullable() Allow NULL values All types ->string('name')->nullable()
default($value) Set default value All types ->integer('count')->default(0)
comment($text) Add column comment All types ->string('email')->comment('User email')
unsigned() Only positive values Numeric types ->integer('age')->unsigned()
autoIncrement() Auto-increment Numeric types ->integer('id')->autoIncrement()

Positioning Modifiers

Modifier Description Example
after($column) Position after column ->string('middle_name')->after('first_name')
first() Position as first column ->string('priority')->first()

String & Character Modifiers

Modifier Description Example
columnCharset($charset) Set column charset ->string('name')->columnCharset('utf8mb4')
columnCollation($collation) Set column collation ->string('name')->columnCollation('utf8mb4_unicode_ci')

Timestamp Modifiers

Modifier Description Example
useCurrent() DEFAULT CURRENT_TIMESTAMP ->timestamp('created_at')->useCurrent()
useCurrentOnUpdate() ON UPDATE CURRENT_TIMESTAMP ->timestamp('updated_at')->useCurrentOnUpdate()

MySQL 8.0+ Modifiers

Modifier Description Example
invisible() Hidden from SELECT * ->string('internal_id')->invisible()

Advanced Modifier Examples

Complete Column Customization

Numeric Column with All Modifiers

Timestamp Columns with Automatic Values

Text Columns with Charset/Collation

Invisible Columns (MySQL 8.0+)

Modifier Combination Rules

Compatible Modifiers

Incompatible Modifiers

Practical Modifier Patterns

User Table with Complete Modifiers

Product Catalog with Advanced Modifiers

🔧 Advanced Column Modifiers

🧠 Intelligent Migration System

SimpleMDB analyzes your migration names and generates context-aware templates:

Generated Template Example:

🛡️ Enterprise Security Features

100% SQL Injection Prevention

Comprehensive Input Validation

📦 Installation

Method 1: Composer (Recommended)

Method 2: Manual Installation

Method 3: Git Clone

Verify Installation

⚙️ Configuration

Database Connection Configuration

Basic Configuration

Advanced Configuration

Environment-Based Configuration

Multiple Database Connections

🚀 Quick Start Guide

1. Basic Database Connection

2. Create Your First Table

3. Insert Data

4. Query Data

5. Update Data

6. Your First Migration

🏗️ Schema Builder

The Schema Builder is SimpleMDB's powerful database schema management system that provides enterprise-grade features for creating, modifying, and managing database tables.

Core Concepts

1. Schema Builder Instance

2. Creating Tables

3. Modifying Tables

4. Table Operations

Advanced Schema Features

1. Constraints and Relationships

2. Indexes and Performance

3. Advanced Column Types

Schema Validation and Security

1. Column Name Validation

2. Data Type Validation

3. Modifier Compatibility

Performance Optimization

1. Efficient Schema Building

2. Index Strategy

Basic Schema Building Example

🔄 Migration System

SimpleMDB's migration system provides intelligent, context-aware database schema management with automatic template generation and comprehensive rollback support.

Core Migration Concepts

1. Migration Manager

2. Creating Migrations

3. Running Migrations

4. Migration Status

Intelligent Template Generation

SimpleMDB analyzes migration names and generates context-aware templates automatically.

Pattern Recognition Examples

1. Create Table Pattern

Generated Template:

2. Add Column Pattern

Generated Template:

3. Add Index Pattern

Generated Template:

4. Modify Table Pattern

Generated Template:

Smart Type Detection

SimpleMDB automatically detects appropriate column types based on column names:

Column Name Pattern Detected Type Example
*_id unsignedInteger user_id → unsignedInteger('user_id')
*_uuid uuid external_uuid → uuid('external_uuid')
*_at timestamp created_at → timestamp('created_at')
*_on date born_on → date('born_on')
is_* boolean is_active → boolean('is_active')
has_* boolean has_premium → boolean('has_premium')
*_count unsignedInteger view_count → unsignedInteger('view_count')
*_price decimal unit_price → decimal('unit_price', 10, 2)
*_amount decimal total_amount → decimal('total_amount', 10, 2)
*_email string contact_email → string('contact_email', 150)
*_url string website_url → string('website_url', 500)
*_ip ipAddress client_ip → ipAddress('client_ip')
*_mac macAddress device_mac → macAddress('device_mac')
*_data json config_data → json('config_data')
*_metadata json user_metadata → json('user_metadata')

Advanced Migration Features

1. Rollback Support

2. Migration Status and History

3. Batch Operations

4. Migration Seeding

Migration File Structure

Standard Migration Template

Advanced Migration with All Features

Migration CLI Commands

Command Examples

Best Practices

1. Migration Naming

2. Safe Migration Practices

3. Rollback Safety

Intelligent Migrations

Advanced Query Building

📚 Complete Feature Matrix

Category Features
🏗️ Schema Builder 25+ data types, 9+ modifiers, intelligent validation, polymorphic support
🔄 Migrations Smart templates, up/down migrations, rollback, status tracking, auto-discovery
🔍 Query Builder SELECT/INSERT/UPDATE/DELETE, CTEs, window functions, JSON operations, unions
🔗 Connections PDO + MySQLi drivers, SSL/TLS, connection pooling, health checks, failover
⚡ Performance Redis/Memcached caching, query profiling, batch operations, retry logic
🛡️ Security SQL injection prevention, input validation, reserved word detection
🧪 Development Query debugging, error analysis, fake data generation, comprehensive logging
📊 Monitoring Query profiling, performance analysis, execution timing, memory tracking

🔧 Advanced Examples

Polymorphic Relationships

Complex Schema with All Features

Migration with Intelligent Features

📖 Documentation Roadmap

We're planning comprehensive documentation to match our enterprise status:

Phase 1: Core Documentation (Coming Soon)

Phase 2: Advanced Guides (Planned)

Phase 3: Multi-Database Support (Future)

🤝 Contributing

SimpleMDB is now an enterprise-grade framework, and we welcome contributions that maintain our high standards:

📜 License

MIT License - Use SimpleMDB in any project, commercial or open source.

SimpleMDB is now production-ready for enterprise applications. Join the growing community of developers who choose SimpleMDB for its combination of power, security, and developer experience.

🌟 Star us on GitHub if SimpleMDB helps you build better applications!

All versions of simple-mysqli-fork with dependencies

PHP Build Version
Package Version
Requires php Version >=8.0
ext-mysqli Version *
ext-pdo Version *
ext-json Version *
ext-mbstring Version *
psr/log Version ^3.0
psr/event-dispatcher Version ^1.0
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package progrmanial/simple-mysqli-fork contains the following files

Loading the files please wait ....