Skip to content

Releases: nielsoffice/PHPCrud

PHPCrud Vanilla v1.3.1.0 compatible w/ PHPWine >= v1.3.1.0 (update naming convention)

20 May 13:14
Compare
Choose a tag to compare

PHPCrud Vanilla v1.3

What's new?

// Installing functions Vanilla since v1.3 [ OLD ]
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_API_WINE;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_WINE;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_CREATE;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_FETCH;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_UPDATE;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_DELETE;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_EXTRACT;

// [ NEW ]
// Installing functions Vanilla since v1.3.1.0
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VanillaApiWine;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VanillaWine;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VanillaCreate;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VanillaFetch;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VanillaUpdate;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VanillaDelete;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VanillaExtract;
    // PHPCrud Vanilla : Installing insert function version 
    new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_CREATE;

    // Defined: 
    wine_creates( string $db_table, array $query = [], string $dataType = null, array $values = null, bool $debug = false);
  
    // CRUD functions version 
    if( !empty( $create = wine_creates('crud' , [ 
                    
         'friend_name'   => '?',
         'friend_mobile' => '?',
         'friend_email'  => '?'

         ] , "sss" , array(
                
           'name value',
           'mobile value',
           'email value'

        )))) { 

    echo  "Last_id : " . $create . " Added new record! ";
        
    } 
  /**
   * Defined : CRUD multi server or switch to databases
   * @since wine v1.3.1.1
   * @since vanilla v1.3.0.0
   * @since 04.30.2022
   **/ 
 wine_multi_server( object $db , vanilla|string $flag, array $method = [] );

// Incase of Create / Insert data to database switch db features Vanilla CRUD since v1.3 
if(isset($_REQUEST['insertData']) == true ) {

     if( $wine_create = wine_multi_server( new mysqli('localhost','root','','multiserver'), $this->vanilla::MAKE, ['query' => [ 
        
         'mixed' => ['  SQL goes here ']
                  
         ], 'dataType' => 'sss', 'values'=> array(
                      
          // value goes here
              
         ), 'debug' => false ] ) ) {
          
        echo "Last_id : " . $wine_create . " Added new record! ";

       } 
  }
  /**
   * Defined : CRUD api_wine_multi_server / multi server or switch to databases
   * @since wine v1.3.1.1
   * @since vanilla v1.3.0.0
   * @since 04.30.2022
   **/ 
  api_wine_multi_server( new mysqli('localhost','root','','multiserver'), [ 'api_wine_makes' => function() {
      
    return [

      'debug' => false,
      'query' => ['mixed' => [ "SQL goes here" ] ] 
      
    ];

   }], function() { ...  }
  
  );

Full Changelog: v1.3...v1.3.1.0

PHPCrud Vanilla v1.3 compatible w/ PHPWine >=+ v1.3.1.0

02 May 21:44
Compare
Choose a tag to compare

PHPCrud Vanilla v1.3

What's new?

// Installing functions Vanilla since v1.3
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_API_WINE;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_WINE;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_CREATE;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_FETCH;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_UPDATE;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_DELETE;
new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_EXTRACT;
    // PHPCrud Vanilla : Installing insert function version 
    new \PHPWineVanillaFlavour\Plugins\PHPCrud\Crud\Wine\VANILLA_CREATE;

    // Defined: 
    wine_creates( string $db_table, array $query = [], string $dataType = null, array $values = null, bool $debug = false);
  
    // CRUD functions version 
    if( !empty( $create = wine_creates('crud' , [ 
                    
         'friend_name'   => '?',
         'friend_mobile' => '?',
         'friend_email'  => '?'

         ] , "sss" , array(
                
           'name value',
           'mobile value',
           'email value'

        )))) { 

    echo  "Last_id : " . $create . " Added new record! ";
        
    } 
  /**
   * Defined : CRUD multi server or switch to databases
   * @since wine v1.3.1.1
   * @since vanilla v1.3.0.0
   * @since 04.30.2022
   **/ 
 wine_multi_server( object $db , vanilla|string $flag, array $method = [] );

// Incase of Create / Insert data to database switch db features Vanilla CRUD since v1.3 
if(isset($_REQUEST['insertData']) == true ) {

     if( $wine_create = wine_multi_server( new mysqli('localhost','root','','multiserver'), $this->vanilla::MAKE, ['query' => [ 
        
         'mixed' => ['  SQL goes here ']
                  
         ], 'dataType' => 'sss', 'values'=> array(
                      
          // value goes here
              
         ), 'debug' => false ] ) ) {
          
        echo "Last_id : " . $wine_create . " Added new record! ";

       } 
  }
  /**
   * Defined : CRUD api_wine_multi_server / multi server or switch to databases
   * @since wine v1.3.1.1
   * @since vanilla v1.3.0.0
   * @since 04.30.2022
   **/ 
  api_wine_multi_server( new mysqli('localhost','root','','multiserver'), [ 'api_wine_makes' => function() {
      
    return [

      'debug' => false,
      'query' => ['mixed' => [ "SQL goes here" ] ] 
      
    ];

   }], function() { ...  }
  
  );

PHPCrud Vanilla v1.3.0.0 compatible w/ PHPWine >=+ v1.3.1.1

01 May 14:29
Compare
Choose a tag to compare

What's new?

  /**
   * Defined : multi server or switch to databases
   * @since wine v1.3.1.1
   * @since vanilla v1.3.0.0
   * @since 04.30.2022
   **/ 
 wine_multi_server( object $db , vanilla|string $flag, array $method = [] );
  
 // Incase of Create 
 wine_multi_server( object $db , Vanilla::MAKE, [ 'query' => [] , 'dataType' => '', 'values' => [] debug => false ] );
 
 // Incase get inserted last id 
 $wine_multi_db = wine_multi_server( object $db , Vanilla::MAKE, [ 'query' => [] , 'dataType' => '', 'values' => [] debug => false ] );
  
 if($wine_multi_db ) :  echo "Sucessfull inserted last ID ".$wine_multi_db ; endif;
   
   
 // Incase of Read 
 wine_multi_server( object $db , Vanilla::FETCH, [ 'query' => [] , 'fetch_request' => function() { ... }, debug => false ] );
 
 // Incase of Update 
 wine_multi_server( object $db , Vanilla::PUT, [ 'query' => [] , 'put_request' => function() { ... }, debug => false ] );
 
 // Incase of Delete 
 wine_multi_server( object $db , Vanilla::DELETE, [ 'query' => [] , 'delete_request' => function() { ... }, debug => false ] );
 
  
   // v1.3 Pre-released
 
  /**
   * Defined : Create api_wine_multi_server / multi server or switch to databases
   * @since wine v1.3.1.1
   * @since vanilla v1.3.0.0
   * @since 04.30.2022
   **/ 
  api_wine_multi_server( new mysqli('localhost','root','','multiserver'), [ 'api_wine_makes' => function() {
      
    return [

      'debug'          => false,
      'query'          => ['mixed' => [ "SQL goes here" ] ] 
      
    ];

  }], function() { ...  }
  
  );
 /**
   * Defined : Read api_wine_multi_server / multi server or switch to databases
   * @since wine v1.3.1.1
   * @since vanilla v1.3.0.0
   * @since 04.30.2022
   **/   
  api_wine_multi_server( new mysqli('localhost','root','','multiserver'), [ 'api_wine_fetch' => function() {
      
    return [

      'debug'          => false,
      'query'          => ['mixed' => [ "SQL goes here" ] ]
    
    ];
    
  }], function() { ...  }
  
  );   
  /**
   * Defined : Update api_wine_multi_server / multi server or switch to databases
   * @since wine v1.3.1.1
   * @since vanilla v1.3.0.0
   * @since 04.30.2022
   **/ 
  api_wine_multi_server( new mysqli('localhost','root','','multiserver'), [ 'api_wine_put' => function() {
      
    return [

      'debug'          => false,
      'query'          => ['mixed' => [ "SQL goes here" ] ]
      
    ];

  }], function() { ...  }
  
  );   
  /**
   * Defined : Delete api_wine_multi_server / multi server or switch to databases
   * @since wine v1.3.1.1
   * @since vanilla v1.3.0.0
   * @since 04.30.2022
   **/ 
  api_wine_multi_server( new mysqli('localhost','root','','multiserver'), [ 'api_wine_delete' => function() {
      
    return [

      'debug'          => false,
      'query'          => ['mixed' => [ "SQL goes here" ] ]
    
    ];

  }], function() { ...  }
  
  );   

PHPCrud_RESTAPI-Template Multi Server for API
PHPCrud Vanilla Multi Server

PHPCrud Vanilla v1.1.0.0 compatible w/ PHPWine >=+ v1.3.1.0

13 Apr 03:20
Compare
Choose a tag to compare

Integrate Callable function PHP Database CRUD Features

Enjoy! v1.1.0.0

PHPCrud (Vanilla ) support wine v1.3.0.2

27 Mar 11:59
Compare
Choose a tag to compare
v1.0.0.2

Update support Winev1.3.0.2

PHPCrud v1.0.0.1 retain (plugin)

04 Mar 12:54
Compare
Choose a tag to compare

PHPCrud is a CRUD System designed to extend PHPWine functionality crud features. ( [ Optional ] Support PHPWine v1.2.0.9)

  • Implement Abstract Database Class
  • Database and error handler

Full Changelog: v1.0.0.0...v1.0