PHP Classes

PHP MySQL Manager: Perform common MySQL database access operations

Recommend this page to a friend!
  Info   View files Example   View files View files (94)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not yet rated by the usersTotal: 171 All time: 8,806 This week: 109Up
Version License PHP version Categories
php-project-structur 0.01The PHP License5PHP 5, Databases, Web services
Description 

Author

This package is specific mainly for applications used in India India .

This class can perform common MySQL database access operations.

It can connect to a MySQL database server using MySQLi. The database server details and access credentials are defined in a constants scripts.

The perform SQL queries of type SELECT, INSERT, UPDATE and DELETE using parameter values that define tables, fields, field values, condition clauses, etc..

Picture of Parag Yelonde
Name: Parag Yelonde <contact>
Classes: 1 package by
Country: India India
Age: ???
All time rank: 4227290 in India India
Week rank: 312 Up22 in India India Up

Example

<?php
/**
 * Created by PhpStorm.
 * User: parag
 * Date: 23/9/19
 * Time: 11:29 AM
 *
 */

include '../config/MySQLManager.php';
$manager = new MySQLManager();

$data = json_decode(file_get_contents('php://input'), true);

if (
$_GET['page'] == 'get_all_info') {
   
get_all_infos($manager);
}
if (
$_GET['page'] == 'get_single_info') {
   
$info_id = $_GET['info_id'];
   
get_single_info($manager, $info_id);
}
if (
$data['page'] == 'add_new_info') {
   
add_new_info($manager, $data);
}
if (
$data['page'] == 'update_info') {
   
update_info($manager, $data);
}
if (
$data['page'] == 'restore_info') {
   
restore_info($manager, $data);
}
if (
$data['page'] == 'delete_info') {
   
delete_info($manager, $data);
}
if (
$_POST['page'] == 'upload_info_image') {
   
upload_info_image($manager, $_POST, $_FILES);
}
if (
$_POST['page'] == 'send_mail') {
   
send_mail($manager, $data);
}


// get all infos
function get_all_infos($manager)
{
    try {
       
$result = $manager->select("info_master", [
           
"is_active" => 1
       
]);

        echo
json_encode(array(['res_code' => 1, 'data' => $result]));
    } catch (
Exception $e) {
    }
}

// get single info
function get_single_info($manager, $info_id)
{
    try {
       
$result = $manager->select("info_master", [
           
"is_active" => 1
       
]);

       
$result[0]['images'] = get_info_related_images($manager, $info_id);

        echo
json_encode(array(['res_code' => 1, 'data' => $result[0]]));
    } catch (
Exception $e) {
    }
}

//add_new_info
function add_new_info($manager, $data)
{
    try {
       
$first_name = $data['first_name'];
       
$last_name = $data['last_name'];
       
$email = $data['email'];
       
$password = $data['password'];
       
$role = $data['role'];
       
$is_active = 1;

       
$result = $manager->insert("info_master", [
           
"first_name" => $first_name,
           
"last_name" => $last_name,
           
"email" => $email,
           
"password" => $password,
           
"role" => $role,
           
"is_active" => $is_active,
           
"created_at" => date('Y-m-d H:i:s'),
           
"modified_at" => date('Y-m-d H:i:s')
        ]);

        if (
$result) {
           
$res = array(['res_code' => 1, 'data' => $result]);
        } else {
           
$res = array(['res_code' => 0]);
        }
        echo
json_encode($res);
    } catch (
Exception $e) {
    }
}

//update_info
function update_info($manager, $data)
{
    try {
       
$first_name = $data['first_name'];
       
$last_name = $data['last_name'];
       
$email = $data['email'];
       
$password = $data['password'];
       
$role = $data['role'];

       
$result = $manager->update("info_master", [
           
"first_name" => $first_name,
           
"last_name" => $last_name,
           
"email" => $email,
           
"password" => $password,
           
"role" => $role,
           
"modified_at" => date('Y-m-d H:i:s')
        ], [
           
"id" => $data['info_id']
        ]);

        if (
$result) {
           
$res = array(['res_code' => 1, 'data' => $result]);
        } else {
           
$res = array(['res_code' => 0]);
        }
        echo
json_encode($res);
    } catch (
Exception $e) {
    }
}

//restore_info
function restore_info($manager, $data)
{
    try {
       
$result = $manager->update("info_master", [
           
"is_active" => 1,
        ], [
           
"id" => $data['info_id']
        ]);

        if (
$result) {
           
$res = array(['res_code' => 1, 'data' => $result]);
        } else {
           
$res = array(['res_code' => 0]);
        }
        echo
json_encode($res);
    } catch (
Exception $e) {
    }
}

//delete_info
function delete_info($manager, $data)
{
    try {
       
$result = $manager->update("info_master", [
           
"is_active" => 0,
        ], [
           
"id" => $data['info_id']
        ]);

        if (
$result) {
           
$res = array(['res_code' => 1, 'data' => $result]);
        } else {
           
$res = array(['res_code' => 0]);
        }
        echo
json_encode($res);
    } catch (
Exception $e) {
    }
}

//upload image
function upload_info_image($manager, $info_data, $files)
{
    try {

       
$result = $manager->upload_file($files['image'], "../uploads/images/infos/"); //parameters image file and location where to save image file.

       
if ($result[0]['res_code']) {
            echo
json_encode($info_data);
           
$result = $manager->update("info_master", [
               
"image_url" => $result[0]['file_name'],
               
"modified_at" => date('Y-m-d H:i:s')
            ], [
               
"id" => $info_data['info_id']
            ]);
            if (
$result) {
               
$res = array(['res_code' => 1, 'data' => $result]);
            } else {
               
$res = array(['res_code' => 0]);
            }

        } else {
           
$res = array(['res_code' => 0]);
        }
        echo
json_encode($res);

    } catch (
Exception $e) {
    }
}

//get info related images
function get_info_related_images($manager, $info_id)
{
    try {
       
$result = $manager->select("info_images", [
           
"info_id" => $info_id,
        ]);

        return
$result;
    } catch (
Exception $e) {
    }
}


function
send_mail($manager, $data)
{
   
$isMailSend = $manager->send_mail($data['email_to'], $data['subject'], $data['message']);
    echo
json_encode($isMailSend);
}


Details

php_project_structure

/Author Parag Yelonde/

This Project cotain PHP Basic Project Structure


  Files folder image Files  
File Role Description
Files folder imageconfig (2 files, 2 directories)
Files folder imageExample (1 file)
Accessible without login Plain text file README.md Doc. Documentation

  Files folder image Files  /  config  
File Role Description
Files folder imageMailer (6 files)
Files folder imagespout (1 directory)
  Accessible without login Plain text file constants.php Aux. Auxiliary script
  Plain text file MySQLManager.php Class Class source

  Files folder image Files  /  config  /  Mailer  
File Role Description
  Plain text file class.php Class Class source
  Plain text file class.phpmailer.php Class Class source
  Plain text file class.phpmaileroauth.php Class Class source
  Plain text file class.phpmaileroauthgoogle.php Class Class source
  Plain text file class.smtp.php Class Class source
  Accessible without login Plain text file PHPMailerAutoload.php Aux. Auxiliary script

  Files folder image Files  /  config  /  spout  
File Role Description
Files folder imagesrc (1 directory)

  Files folder image Files  /  config  /  spout  /  src  
File Role Description
Files folder imageSpout (4 directories)

  Files folder image Files  /  config  /  spout  /  src  /  Spout  
File Role Description
Files folder imageAutoloader (2 files)
Files folder imageCommon (1 file, 3 directories)
Files folder imageReader (5 files, 5 directories)
Files folder imageWriter (4 files, 6 directories)

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Autoloader  
File Role Description
  Accessible without login Plain text file autoload.php Example Example script
  Plain text file Psr4Autoloader.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Common  
File Role Description
Files folder imageEscaper (4 files)
Files folder imageException (5 files)
Files folder imageHelper (4 files)
  Plain text file Type.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Common  /  Escaper  
File Role Description
  Plain text file CSV.php Class Class source
  Plain text file EscaperInterface.php Class Class source
  Plain text file ODS.php Class Class source
  Plain text file XLSX.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Common  /  Exception  
File Role Description
  Plain text file EncodingConversionException.php Class Class source
  Plain text file InvalidArgumentException.php Class Class source
  Plain text file IOException.php Class Class source
  Plain text file SpoutException.php Class Class source
  Plain text file UnsupportedTypeException.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Common  /  Helper  
File Role Description
  Plain text file EncodingHelper.php Class Class source
  Plain text file FileSystemHelper.php Class Class source
  Plain text file GlobalFunctionsHelper.php Class Class source
  Plain text file StringHelper.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Reader  
File Role Description
Files folder imageCSV (4 files)
Files folder imageException (6 files)
Files folder imageODS (4 files, 1 directory)
Files folder imageWrapper (3 files)
Files folder imageXLSX (4 files, 1 directory)
  Plain text file AbstractReader.php Class Class source
  Plain text file IteratorInterface.php Class Class source
  Plain text file ReaderFactory.php Class Class source
  Plain text file ReaderInterface.php Class Class source
  Plain text file SheetInterface.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Reader  /  CSV  
File Role Description
  Plain text file Reader.php Class Class source
  Plain text file RowIterator.php Class Class source
  Plain text file Sheet.php Class Class source
  Plain text file SheetIterator.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Reader  /  Exception  
File Role Description
  Plain text file IteratorNotRewindableException.php Class Class source
  Plain text file NoSheetsFoundException.php Class Class source
  Plain text file ReaderException.php Class Class source
  Plain text file ReaderNotOpenedException.php Class Class source
  Plain text file SharedStringNotFoundException.php Class Class source
  Plain text file XMLProcessingException.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Reader  /  ODS  
File Role Description
Files folder imageHelper (1 file)
  Plain text file Reader.php Class Class source
  Plain text file RowIterator.php Class Class source
  Plain text file Sheet.php Class Class source
  Plain text file SheetIterator.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Reader  /  ODS  /  Helper  
File Role Description
  Plain text file CellValueFormatter.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Reader  /  Wrapper  
File Role Description
  Plain text file SimpleXMLElement.php Class Class source
  Plain text file XMLInternalErrorsHelper.php Class Class source
  Plain text file XMLReader.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Reader  /  XLSX  
File Role Description
Files folder imageHelper (5 files, 1 directory)
  Plain text file Reader.php Class Class source
  Plain text file RowIterator.php Class Class source
  Plain text file Sheet.php Class Class source
  Plain text file SheetIterator.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Reader  /  XLSX  /  Helper  
File Role Description
Files folder imageSharedStringsCaching (4 files)
  Plain text file CellHelper.php Class Class source
  Plain text file CellValueFormatter.php Class Class source
  Plain text file SharedStringsHelper.php Class Class source
  Plain text file SheetHelper.php Class Class source
  Plain text file StyleHelper.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Reader  /  XLSX  /  Helper  /  SharedStringsCaching  
File Role Description
  Plain text file CachingStrategyFactory.php Class Class source
  Plain text file CachingStrategyInterface.php Class Class source
  Plain text file FileBasedStrategy.php Class Class source
  Plain text file InMemoryStrategy.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Writer  
File Role Description
Files folder imageCommon (1 file, 2 directories)
Files folder imageCSV (1 file)
Files folder imageException (6 files)
Files folder imageODS (1 file, 2 directories)
Files folder imageStyle (3 files)
Files folder imageXLSX (1 file, 2 directories)
  Plain text file AbstractMultiSheetsWriter.php Class Class source
  Plain text file AbstractWriter.php Class Class source
  Plain text file WriterFactory.php Class Class source
  Plain text file WriterInterface.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Writer  /  Common  
File Role Description
Files folder imageHelper (3 files)
Files folder imageInternal (3 files)
  Plain text file Sheet.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Writer  /  Common  /  Helper  
File Role Description
  Plain text file AbstractStyleHelper.php Class Class source
  Plain text file CellHelper.php Class Class source
  Plain text file ZipHelper.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Writer  /  Common  /  Internal  
File Role Description
  Plain text file AbstractWorkbook.php Class Class source
  Plain text file WorkbookInterface.php Class Class source
  Plain text file WorksheetInterface.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Writer  /  CSV  
File Role Description
  Plain text file Writer.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Writer  /  Exception  
File Role Description
  Plain text file InvalidColorException.php Class Class source
  Plain text file InvalidSheetNameException.php Class Class source
  Plain text file SheetNotFoundException.php Class Class source
  Plain text file WriterAlreadyOpenedException.php Class Class source
  Plain text file WriterException.php Class Class source
  Plain text file WriterNotOpenedException.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Writer  /  ODS  
File Role Description
Files folder imageHelper (2 files)
Files folder imageInternal (2 files)
  Plain text file Writer.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Writer  /  ODS  /  Helper  
File Role Description
  Plain text file FileSystemHelper.php Class Class source
  Plain text file StyleHelper.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Writer  /  ODS  /  Internal  
File Role Description
  Plain text file Workbook.php Class Class source
  Plain text file Worksheet.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Writer  /  Style  
File Role Description
  Plain text file Color.php Class Class source
  Plain text file Style.php Class Class source
  Plain text file StyleBuilder.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Writer  /  XLSX  
File Role Description
Files folder imageHelper (3 files)
Files folder imageInternal (2 files)
  Plain text file Writer.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Writer  /  XLSX  /  Helper  
File Role Description
  Plain text file FileSystemHelper.php Class Class source
  Plain text file SharedStringsHelper.php Class Class source
  Plain text file StyleHelper.php Class Class source

  Files folder image Files  /  config  /  spout  /  src  /  Spout  /  Writer  /  XLSX  /  Internal  
File Role Description
  Plain text file Workbook.php Class Class source
  Plain text file Worksheet.php Class Class source

  Files folder image Files  /  Example  
File Role Description
  Accessible without login Plain text file exaple_api.php Example Example script

 Version Control Unique User Downloads Download Rankings  
 100%
Total:171
This week:0
All time:8,806
This week:109Up