PHP Classes

PHP CRUD API Example: Example API to manipulate database table records

Recommend this page to a friend!
  Info   View files Example   View files View files (23)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 133 This week: 1All time: 9,298 This week: 560Up
Version License PHP version Categories
crud-php 1.0.0The PHP License5HTML, PHP 5, Databases
Description 

Author

This package provides an example API to manipulate database table records.

It provides a service class and other classes that implement the basic operations to create, retrieve, update, delete records from an example database table.

The package also provides view scripts that can display a Web interface to allow users to enter data and see the information of the database table that the service API class manipulates.

Picture of adriano123456
  Performance   Level  
Name: adriano123456 <contact>
Classes: 4 packages by
Country: Brazil Brazil
Age: 36
All time rank: 3634285 in Brazil Brazil
Week rank: 106 Up7 in Brazil Brazil Up
Innovation award
Innovation award
Nominee: 1x

Example

<?php

require_once 'Autoloader.php';
require_once
'Helper.php';

/**
 * Instanciamento de classes
 */
$db = new Conn("localhost", "crud_php", "root", "");
$cliente = new Cliente();
$objCliente = new ServiceCliente($db, $cliente);

/*
 * Add controller CRUD
 */

if(isset($_POST['action'] )){
   
    if(
$_POST['action'] == 'save_cliente'){
       
       
$cliente->setId ($_POST['id' ])
                ->
setNome ($_POST['nome' ])
                ->
setEmail($_POST['email']);
       
        if(
$_POST['id'] > 0){
            print
$objCliente->update();
                   
        }else{
           
$id = $objCliente->save();
           
$rst = $objCliente->find($id);
            print
json_encode($rst[0]);
        }
       
    }
   
    if(
$_POST['action'] == 'delete_cliente'){
       
       
$cliente->setId($_POST['id']);
        print
$objCliente->delete();
       
    }
   
}elseif(
$_GET != NULL){
   
   
$rst = $objCliente->find($_GET['id']);
    echo
json_encode($rst[0]);
   
}else{
   
   
Template::header();
   
Template::getFormCliente();
   
Template::getCliente($objCliente->show());
   
Template::footer();
   
}



  Files folder image Files  
File Role Description
Files folder imageapi (2 directories)
Files folder imagenbproject (2 files)
Files folder image_vendor (2 directories)
Plain text file Autoloader.php Class Class source
Plain text file Helper.php Class Class source
Accessible without login Plain text file index.php Example Example script

  Files folder image Files  /  api  
File Role Description
Files folder imagecore (5 files)
Files folder imageview (5 files)

  Files folder image Files  /  api  /  core  
File Role Description
  Plain text file Cliente.php Class Class source
  Plain text file Conn.php Class Class source
  Plain text file ICliente.php Class Class source
  Plain text file IConn.php Class Class source
  Plain text file ServiceCliente.php Class Class source

  Files folder image Files  /  api  /  view  
File Role Description
  Accessible without login Plain text file cliente_form.php Aux. Auxiliary script
  Accessible without login Plain text file cliente_listagem.php Aux. Auxiliary script
  Accessible without login Plain text file footer.php Aux. Auxiliary script
  Accessible without login Plain text file header.php Aux. Auxiliary script
  Plain text file Template.php Class Class source

  Files folder image Files  /  nbproject  
File Role Description
  Accessible without login Plain text file project.properties Data Auxiliary data
  Accessible without login Plain text file project.xml Data Auxiliary data

  Files folder image Files  /  _vendor  
File Role Description
Files folder imagecss (3 files)
Files folder imagejs (5 files)

  Files folder image Files  /  _vendor  /  css  
File Role Description
  Accessible without login Plain text file bootstrap.css Data Auxiliary data
  Accessible without login Plain text file custom.min.css Data Auxiliary data
  Accessible without login Plain text file style.css Data Auxiliary data

  Files folder image Files  /  _vendor  /  js  
File Role Description
  Accessible without login Plain text file bootstrap.min.js Data Auxiliary data
  Accessible without login Plain text file custom.js Data Auxiliary data
  Accessible without login Plain text file jquery.min.js Data Auxiliary data
  Accessible without login Plain text file popper.min.js Data Auxiliary data
  Accessible without login Plain text file scripts.js Data Auxiliary data

 Version Control Unique User Downloads Download Rankings  
 100%
Total:133
This week:1
All time:9,298
This week:560Up