compPHP HTML Components: Generate HTML elements linked to database data

Recommend this page to a friend!

Download .zip

Info

Example

Screenshots

View files (24)

Download .zip

Reputation

Support forum

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not enough user ratings				Total: 143		All time: 9,165 This week: 455

Version		License		PHP version		Categories
`components` 1.0		GNU Free Document...		7		HTML, PHP 5, Databases

Description

Author

Rene Gonzalez

This package can generate HTML elements linked to database data.

It provides classes that can connect to a database using PDO and execute queries to access data from that database.

The package also provides classes that use the database data and display or edit that data in a convenient way for the application. Currently it provides classes for controls like displaying data in tables, render forms with buttons, list boxes, text inputs, combo boxes, etc..

Rene Gonzalez

Name:	Rene Gonzalez `<contact>`
Classes:	1 package by Rene Gonzalez
Country:	Mexico
Age:	???
All time rank:	4289	52 in Mexico
Week rank:	295	6 in Mexico

Example




<?php



require_once '../Connection.php';

require_once '../DataAccess.php';



#Open connection

#Create instance of Connection

$conn = new Connection('localhost', 'test', 'root', '');

#Create simple connection

$link = $conn->SimpleConnectionPDO();



//********************************************************************************************************************* */



#Execute query

#Create instance of DataAccess

$exec = new DataAccess();



#Pass parameter Connection

$exec->SetConn($link['obj_']);



#CRUD Create, Read, Update, Delete

#======================================================================================================



$exec->setQuerycmd("Read");

$exec->setQuerycrud("SELECT id, val1, val2, val3 FROM pruebas;");



$dats = $exec->ExecuteCommand();



#======================================================================================================



require_once '../DataTable.php';



$dt = new DataTable();

#LINK $dats['obj_'] to ComboBox

$dt->SetDataSource($dats['obj_']);

#[OPTIONAL SetHeader()]

$dt->SetHeader(array('Id', 'Brand', 'Type', 'Item'));

$dt->SetID('dtSmartPhones');

$dt->SetClass('table table-dark');

$dt->SetStyle('#dtSmartPhones{font-size:18px; width:65%;}');

$dt->SetBtnSelect(array('show'=>true,

                        'name'=>'Seleccionar',

                        'onclick'=>'SelectRow()',

                        'class' => 'btn btn-success',

                        'param'=>'id',

                        'colname'=>'Seleccionar'));

$dt->SetBtnEdit(array('show'=>true,

                        'name'=>'Editar',

                        'onclick'=>'alert()',

                        'class' => 'btn btn-warning',

                        'param'=>'id',

                        'colname'=>'Editar'));

$dt->SetBtnDelete(array('show'=>true,

                        'name'=>'Delete',

                        'class' => 'btn btn-danger',

                        'onclick'=>'console.log()',

                        'param'=>'id',

                        'colname'=>'Eliminar'));



$dt->SetScript('function SelectRow(id) { document.getElementById("Msg").innerHTML = "You have selected row: " + id; } ');



?>



<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <meta name="viewport" content="width=device-width, initial-scale=1.0">

    <meta http-equiv="X-UA-Compatible" content="ie=edge">

    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">

    <title>Document</title>

</head>

<body style="margin:1em;">



    <?php

        echo '<style>.Table{ border-style: dotted; }</style>';

        echo $dt->CreateDataTable();

    ?>

    <br><div id="Msg"></div>



</body>

</html>

Screenshots

Files

File	Role	Description
`.vscode` (1 file)
`demos` (4 files)
`BSCard.php`	Class	Class source
`BSNav.php`	Class	Class source
`Button.php`	Class	Class source
`ComboBox.php`	Class	Class source
`Connection.php`	Class	Class source
`DataAccess.php`	Class	Class source
`DataTable.php`	Class	Class source
`DateIntervalFunc.php`	Class	Class source
`Form.php`	Class	Class source
`ListBox.php`	Class	Class source
`Login.php`	Class	Class source
`MSFooter.php`	Class	Class source
`MSNav.php`	Class	Class source
`QueryCreator.php`	Class	Class source
`Select.php`	Class	Class source
`StringQueryCreator.php`	Class	Class source
`TextArea.php`	Class	Class source
`TextBox.php`	Class	Class source
`WrapControl.php`	Class	Class source

Files

.vscode

File	Role	Description
`launch.json`	Data	Auxiliary data

Files

demos

File	Role	Description
`DemoComboBox.php`	Example	Example script
`DemoConnectionDataAccess.php`	Example	Example script
`DemoDataTable.php`	Example	Example script
`DemoStringQueryCreator.php`	Example	Example script