PHP NWX_Database Examples

Example #1

File: lgr_screen_creatorV1.php Project: jlo26/Web-Applications

     print "<div class='container container-large'>";
     print "\t\t<div class='row well'>";
     print '      	' . $entryHeaderForm;
     print '		</div>';
     print "\t\t<div class='row well'>";
     print '     	' . $updateButton;
     print '		</div>';
     print "\t\t<div class='row'>";
     print '			<div class="table-responsive" style="overflow:auto;height:210px;border:0px solid #000">';
     print '         ' . $entryDetailDataTable;
     print '			</div>';
     print "\t\t</div>";
     print "</div>";
     break;
 case '2':
     $db_obj = new NWX_Database($servername, $username, $password, $dbname);
     $tableName = C_TABLELIST["TBS_05"];
     $tabHeader = $db_obj->nwx_dbc_get_table_columns($tableName);
     $tableDef = $db_obj->nwx_dbc_select($tableName);
     $tableAttrib = " id='' class='table table-striped' ";
     // $tableAttrib = " id='transScreenOpener' class='table table-striped' data-toggle='modal' data-target='#myModal' data-backdrop='static' ";
     // $trowAttrib  = ' id="transScreenOpener" data-toggle="modal" data-target="#mdl_headerModal" data-backdrop="static" ';
     // $trowAttrib  = ' id="transScreenOpener" data-toggle="modal" data-target="#mdl_detailModal" data-backdrop="static" ';
     $trowAttrib = ' ';
     // $trowAttrib  = '   ';
     print um_table_creator($tableDef, $tabHeader, $tableAttrib, $trowAttrib);
     break;
 case '3':
     $nav_obj = new NWX_NAVWebX($servername, $username, $password, $dbname);
     $tableID = C_TABLELIST[$nwxTableIndex];
     print $nav_obj->nwx_generate_sequence($tableID);

Example #2

File: test_table.php Project: jlo26/Web-Applications

<?php

require_once "../php/uf_utilities.php";
require_once "../class/NWX_Database.obj";
require_once "../config/db.config";
$db_obj = new NWX_Database($servername, $username, $password, $dbname);
$tableDef = $db_obj->nwx_dbc_select("nwx05_sales_header");
// $tableAttrib = 'id="example" class="table table-hover" cellspacing="0" width="100%" border="1"';
$tableAttrib = "id='example' class='table table-hover' cellspacing='0' width='100%' border='1'";
print um_table_creator($tableDef, $tableAttrib);
print "<br>\n<input type='text' name='numberDocument' id='txt_numberDocument' value=:V class=:C size='20' maxlength=20 placeholder=Document Number>";

Example #3

File: lgcrud_mt_save.php Project: jlo26/Web-Applications

<?php

//error_reporting(0);
include_once "../../config/db.config";
include_once "../../config/constant.config";
include_once "../../class/NWX_Validation.cls.php";
include_once "../../class/NWX_Database.cls.php";
$maintenance_variables = $_POST;
$tableInitial = $_POST["ZZ_tableID"];
// print "<pre>";
// print_r($maintenance_variables);
$validation_obj = new NWX_Validation();
$A_validated = $validation_obj->nwx_mtv_initialize($_POST);
if ($A_validated) {
    $db_obj = new NWX_Database($servername, $username, $password, $dbname);
    $tablePrefix = $tableprefix . $tableInitial;
    $tableName = $db_obj->nwx_dbc_get_table_withinitial($tablePrefix);
    /* 
    	print_r($db_obj->nwx_dbc_create_sequence($tableName));
    	print JSRET_SUCCESS_CREATE.$db_obj->s_lastInsertId;	
    	//Create the record;
    	$db_obj->nwx_dbc_create($tableName,$A_validated);
    	if($db_obj->s_transSucceeded==1){
    		print JSRET_SUCCESS_CREATE.$db_obj->s_lastInsertId;	
    	}else{
    		print JSRET_ERROR_CREATE;
    	}//end else
    */
    $db_obj->nwx_dbc_update_pk($tableName, $A_validated);
    print JSRET_SUCCESS_CREATE . $db_obj->s_lastInsertId;
} else {

Example #4

File: test.php Project: jlo26/Web-Applications

<?php

error_reporting(0);
include_once "../../config/db.config";
include_once "../../obj/NWX_Validation.obj";
include_once "../../obj/NWX_Database.obj";
$tableInitial = '09';
$db_obj = new NWX_Database($servername, $username, $password, $dbname);
// print_r($db_obj->nwx_dbc_query("show tables from $dbname"));
print_r($db_obj->nwx_dbc_get_table_withinitial($tableprefix . $tableInitial));