PHP code example of javanile / hamper

1. Go to this page and download the library: Download javanile/hamper library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php.
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

    

javanile / hamper example snippets




use Javanile\Hamper\Hamper;

$hdb = Hamper::getInstance();

// Execute simple query
$hdb->query("SET NAMES utf8");

// Execute prepare query
$hdb->query("UPDATE vtiger_users SET language = ? WHERE user_name = ?", ["en_us", "admin"]);

// Execute simple query
$hdb->query("SET NAMES utf8");

// Execute prepare query
$hdb->query("UPDATE vtiger_users SET language = ? WHERE user_name = ?", ["en_us", "admin"]);

// Execute simple query
$hdb->query("SET NAMES utf8");

// Execute prepare query
$hdb->query("UPDATE vtiger_users SET language = ? WHERE user_name = ?", ["en_us", "admin"]);

$crmId = $hdb->fetchValue("SELECT crmid FROM vtiger_crmentity WHERE setype=? AND deleted=0", [$module]);

$adb = \PearDatabase::getInstance();
$result = $adb->pquery("SELECT tabid FROM vtiger_tab WHERE name=?", [$setype]);
$tabId = $adb->query_result($result, 0, "tabid");

// Execute simple query
$hdb->query("SET NAMES utf8");

// Execute prepare query
$hdb->query("UPDATE vtiger_users SET language = ? WHERE user_name = ?", ["en_us", "admin"]);

// Execute simple query
$hdb->query("SET NAMES utf8");

// Execute prepare query
$hdb->query("UPDATE vtiger_users SET language = ? WHERE user_name = ?", ["en_us", "admin"]);

// Execute simple query
$hdb->query("SET NAMES utf8");

// Execute prepare query
$hdb->query("UPDATE vtiger_users SET language = ? WHERE user_name = ?", ["en_us", "admin"]);

// Execute simple query
$hdb->query("SET NAMES utf8");

// Execute prepare query
$hdb->query("UPDATE vtiger_users SET language = ? WHERE user_name = ?", ["en_us", "admin"]);

// Execute simple query
$hdb->query("SET NAMES utf8");

// Execute prepare query
$hdb->query("UPDATE vtiger_users SET language = ? WHERE user_name = ?", ["en_us", "admin"]);

// Execute simple query
$hdb->query("SET NAMES utf8");

// Execute prepare query
$hdb->query("UPDATE vtiger_users SET language = ? WHERE user_name = ?", ["en_us", "admin"]);
bash
$ make tdd take=tests/HamperDatabaseTest.php