PHP Classes

AED: Add, List, Edit and Delete records in MySQL tables

Recommend this page to a friend!
     
  Info   Example   Demos   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 227 All time: 8,188 This week: 57Up
Version License PHP version Categories
aed 1.0.0Freely Distributable5HTML, PHP 5, Databases
Description 

Author

Vishv Sahdev

This package can add, list, edit and delete records in MySQL tables.

It can connect to a MySQL database using MySQLi and generate listing of records of a database table with support to paginate the listings with a limited amount of records.

The listing may have links that trigger actions to add, edit, and delete records of the given table.

Picture of Vishv Sahdev
  Performance   Level  
Name: Vishv Sahdev <contact>
Classes: 13 packages by
Country: India India

Level 5 StarStarStarStarStar

 Innovation award
Innovation award
Nominee: 7x

Example

<?php
/**
 * PHP ADD EDIT DELETE EXAMPLE
 * @author admin@v23.in - http://v23.in
 * @version 1.0.0
 * @date October 21, 2015
*/

require "aed-class.php";
require "aed-pager-class.php";
require "aed-config.php";
// chage only aed-config.php file --------------------------------------------
//-------------- no need to change -------------------------------------------
$db = new aed(DB_HOST, DB_USER, DB_PASS, DB_NAME);


// page = PAGE NUmBER Default value page = 1;

if(isset($_GET['page']))
$page = $_GET['page'];
else
$page = 1;

if(empty($page) || $page < 1)
$page = 1;

// LIMIT 1, perPage Display
$start=($page - 1) * $perPageDiaplay;
$totalRow = $db->totalPage($table);

// Filename, Page =p , total Row, Current Page Value - Default 1, Per Page Display - Default 12
//$output['pager']=pager("$filename?","page=",$totalRow,$page,$perPageDiaplay);
$output['pager'] = "";
if($totalRow > 0){
$pager = new pager($filename,$totalRow,$page,$perPageDiaplay);
$output['pager'] = $pager->DisplayCenter();
}

$ar = $db->makeTTArray($table);
$error="Welcome!";
if(isset($_POST['Action']) && isset($_GET['ip']) && ($_POST['Action'] == $_GET['ip'])){
    foreach($ar as $k=>$v){
    if(isset($_POST[$k]))
    $arr[$k]=$_POST[$k];
   
    }

        if(isset($_POST['route']) && ($_POST['route'] == "add" || $_POST['route'] == "Create") ){
        $error=$db->check($table,$arr);
        if(!$error)
        $error = $db->insert($table,$arr);
        }
        elseif(isset($_POST['route']) && $_POST['route'] == "edit"){
        $error = $db->update($table,$arr,"`$primeryKEY`=".$_POST['CusID']." LIMIT 1");
        }
        elseif(isset($_POST['route']) && $_POST['route'] == "del"){
        $error = $db->delete($table,"`$primeryKEY`=".$_POST['CusID']." LIMIT 1");
        }
}
$output['error']='<p class="bg-info">'.$error.'</p>';
if(isset($_GET['c']) && isset($_GET['id'])){
$cc=$_GET['c'];
$id=$_GET['id'];
$ar = $db->query2row("SELECT * from $table where $primeryKEY = $id LIMIT 1");
}
else{
$cc="Create";
$id=0;
}

if($fieldRequire == 'ALL'){
$output['foo']=$ar;
unset($output['foo'][$primeryKEY]);
}
else
{
$o=explode(",",$fieldRequire);
$output['foo']=array_flip($ar);
}

$output['page']=$page;
$output['timeid'] = microtime(true);
$output['filename']=$filename;
$output['cc']=$cc;
$output['id']=$id;
$output['row']=$ar;

$field = implode(", ", array_keys($output['foo']));

$sql="SELECT $primeryKEY, $field from $table ORDER BY $primeryKEY DESC LIMIT ".$start.",".$perPageDiaplay;

$row=$db->query($sql);
if($row->num_rows > 0){
while($result = $row->fetch_assoc()){
$result['command']="<a href='$filename?id=".$result[$primeryKEY]."&c=add&page=$page'><span class=\"glyphicon glyphicon-check\" aria-hidden=\"true\"></span></a> <a href='$filename?id=".$result[$primeryKEY]."&c=edit&page=$page'><span class=\"glyphicon glyphicon-edit\" aria-hidden=\"true\"></span></a> <a href='$filename?id=".$result[$primeryKEY]."&c=del&page=$page'><span class=\"glyphicon glyphicon-trash\" aria-hidden=\"true\"></span></a> ";
$output['row'][]=$result;
}


}
else
$output['row']=array();
echo render_temp("aed-template.htm",$output);
$db->close();
?>

  DemoExternal page  

Open in a separate window

  Files folder image Files (6)  
File Role Description
Plain text file aed-class.php Class AED Class File
Plain text file aed-config.php Conf. AED Config File
Plain text file aed-example.php Example Example File
Plain text file aed-pager-class.php Class AED Pagination File
Plain text file aed-template.htm Aux. aed-Template
Plain text file aed.sql Data SQL File

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadaed-2015-10-23.zip 5KB
Downloadaed-2015-10-23.tar.gz 4KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:227
This week:0
All time:8,188
This week:57Up

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.