PHP Classes

File: app_run_bean.php

Recommend this page to a friend!
  Classes of Saro Carvello   MySQL Class Generator   app_run_bean.php   Download  
File: app_run_bean.php
Role: Example script
Content type: text/plain
Description: Example script
Class: MySQL Class Generator
Generate classes to access MySQL as objects
Author: By
Last change: Refactoring of GUI

Now you can auto generate PHP classes by using a GUI
Date: 6 years ago
Size: 4,618 bytes
 

Contents

Class file image Download
<?php
/**
 * Demo usage of the generated class by mysqlreflection tools
 * Generated bean used: BeanSinglePkDate
 *
 */

error_reporting(E_ALL);
header('Content-Type: text/html; charset=utf-8');

include_once(
"beans/bean.config.php");
include_once(
"beans/BeanSinglePkDate.php");


// INSERT a new row and show result
$bean = new BeanSinglePkDate();
$bean->setIdDate("10/10/1950");
$bean->setFieldDate("10/10/1951");
$bean->setFieldDateTime("10/10/1952 10:11:12");
$bean->setFieldInt(100);
$bean->setFieldDecimal(100.35);
$bean->setFieldString('STRING with apho\'s and accènt');
$bean->setFieldText("TEXT with apho's and accènt");
$result = $bean->insert();
$lastInserted = $bean->getIdDate();

showBeanOperationResult("INSERT",$bean,$bean->affected_rows,false);
echo
$lastInserted . " last inserted<br/>";
$bean->close();

// SELECT previously inserted row and show result
$bean = new BeanSinglePkDate($lastInserted);

showBeanOperationResult("SELECT",$bean,$bean->affected_rows);
$bean->close();

// UPDATE previously inserted row and show result
$bean = new BeanSinglePkDate($lastInserted);
$bean->setFieldDate("10/10/1952");
$bean->setFieldDecimal(200.45);
$bean->setFieldInt(200);
$bean->setFieldString("This is a new STRING with apho's and accènt");
$bean->setFieldText("This is a new TEXT with apho's and accènt");
$result = $bean->updateCurrent();

showBeanOperationResult("UPDATE",$bean,$result,true);
$bean->close();

// DELETE previously updated row and show result
$bean = new BeanSinglePkDate($lastInserted);
$result = $bean->delete($lastInserted);

showBeanOperationResult("DELETE",$bean,$result);
$bean->close();

// Select after deletion and show result
$bean = new BeanSinglePkDate($lastInserted);

showBeanOperationResult("SELECT AFTER DELETION",$bean,$bean->affected_rows);
$bean->close();

/**
 * Support functions to show result
 */

/**
 * Show Sale bean information and the MySQLi result for the current object operation
 * @param string $operation the class operation
 * @param mixed $bean current object
 * @param mysqli $result the mysql result for the operation
 * @param bool $ddl if true show the DDL
 */
function showBeanOperationResult($operation, BeanSinglePkDate $bean,$result,$ddl = false)
{
    echo
"<br/><b>BEGIN</b> application operation: <b>$operation</b><br/>";
   
showBean($bean,$operation,$ddl);
   
showMySqlResult($result);
    echo
"<b>END</b> application operation: <b>$operation</b><br/><br/><br/>";
}

/**
 * Shows some information about current sales agent object
 * @param mixed $bean
 * @param string $operation the class operation
 * @param bool $showDdl
 */
function showBean(BeanSinglePkDate $bean = null, $operation, $showDdl = false)
{
   
// If no errors
   
if ($bean && !$bean->isSqlError()) {
        echo
"<br/>";
        echo
"<b>Bean information:</b>:<hr>";
        echo
"field_id : {$bean->getIdDate()}<br/>";
        echo
"field_date : {$bean->getFieldDate()}<br/>";
        echo
"field_date_time : {$bean->getFieldDateTime()}<br/>";
        echo
"field_int : {$bean->getFieldInt()}<br/>";
        echo
"field_decimal : {$bean->getFieldDecimal()}<br/>";
        echo
"field_string : {$bean->getFieldString()}<br/>";
        echo
"field_text : {$bean->getFieldText()}<br/>";
        echo
"<br/>";
       
// Shows sql statements
       
echo "<div style='background: lightgrey'>";
        echo
"<sup>Executed SQL statemtent:</sup><br/>";
        echo
$bean->lastSql() . "<br/>";
        echo
"</div>";
    }

   
// If errors
   
if ($bean && $bean->isSqlError()) {
        echo
"<br/>";
        echo
"<b>Error Unable to show bean object information:</b>";
        echo
"<hr>";
        echo
"<div style='background:indianred'>";
        echo
"Error:" . $bean->lastSqlError();
        echo
"<br/>";
        echo
$bean->lastSql();
        echo
"</div>";
    }

   
// If DDL info requested and no error
   
if ($bean && $showDdl){
        echo
"<br/>";
        echo
"<br/><sup>You requested to see DDL information:</sup><br/>";
        echo
"<div style='background: yellowgreen'>";
        echo
"<pre>";
        echo
$bean->getDdl();
        echo
"</pre>";
        echo
"</div>";
    }

}

/**
 * Show MySql Result
 * @param mixed MySql $result
 */
function showMySqlResult($result){
    echo
"<br/>";
    echo
"<div style='background: lightcyan'>";
    echo
"<sup>MySQL result for operation:</sup>";
   
var_dump($result);
    echo
"</div>";
}