virgiliopontes/autowheremysql

With this package, it's easy to create visions where your users become more powerful. You give them the power to filter fields all fields in a query, without the need to create each field separately.

Auto Where MySQL for PHP

This package to create the where part of your MySQL queries from a simple form submission, and everything automatically., _(*1)

Install

composer require virgiliopontes/autowheremysql

Examples

The Hello World example.

Go to the examples directory in the root of the repository (vendor/virgiliopontes/autowheremysql/examples)., _(*2)

Open the index.php with your favorite text editor and take a look at the source code., _(*3)

Open the browser

Navigate to the directory where the index.php is allocated., _(*4)

Exemple, _(*5)

http://127.0.0.1/vendor/virgiliopontes/autowheremysql/

Note: You need to replace 127.0.0.1 with the machine address where the example is, _(*6)

Installation

Composer

Install Composer if you don't have it., _(*7)

composer require virgiliopontes/autowheremysql

Or in your composer.json file add:, _(*8)

{
    "require": {
        "virgiliopontes/autowheremysql": "~2",
    }
}

And the just run:, _(*9)

composer update

and thats it., _(*10)

Using

Uses in Controller by adding use AutoWhere/AutoWhereMysql after namespace, _(*11)

<?php
namespace App\Controllers;

use AutoWhere\AutoWhereMysql; //<--- Here

class YourClass
{
    //...

    public function YourMethod()
    {        
        $autoWhereMysql = new AutoWhere\AutoWhereMysql();
        if(isset($_POST['campofiltro'])){
            $where = $autoWhereMysql->make_where($_POST['campofiltro'],$_POST['operador'],$_POST['valorfiltro']);
            echo $where;
        }

    }
}    

Questions?

Call me on Twitter @virgiliopontes., _(*12)

License

MIT, _(*13)