Package:
Summary:
MySQL database access wrapper
Groups:
Author:
Description:
This class implements a MySQL database access wrapper. It can:
- Establish connections to a given MySQL server host
- Create databases and tables
- Execute SQL queries
- Retrieve query results as arrays, objects, JSON and XML
Package:
Summary:
Generate Excel spreadsheets from templates
Groups:
Author:
Description:
This class can be used to generate Excel spreadsheets from templates.
It can load a template spreadsheet file, replace some template values and generate the merged Excel file.
The resulting Excel file can be protected with a password and served as the
current script output or saved to a given file.
This class requires the PHPExcel classes for reading and writing Excel XLS files.
Package:
Summary:
Resize images
Groups:
Author:
Description:
This class is usefull for resize of particular image and saved into a folder
Package:
Summary:
Resize GIF, JPEG and PNG images
Groups:
Author:
Description:
This class can be used to resize GIF, JPEG and PNG images.
It can read a GIF, JPEG or PNG image and scale the image to a given width and height.
The class can resize the image to the exact given dimensions, keep the image proportions, or crop to the width or height that exceeds the given width or height.
The resized image can be saved to a given file also in GIF, JPEG or PNG formats.
Package:
Summary:
Generate SQL from data imported CSV files
Groups:
Author:
Description:
This class can be used to generate SQL from data imported CSV files.
It can open a CSV file and generate SQL statements to create a table and insert the data read from the CSV file into a SQL database.
The name of the database to be created and populated is configurable.
Package:
Summary:
Query MySQL database from parameter lists
Groups:
Author:
Description:
This class can be used to query MySQL database from parameter lists.
It can connect to a MySQL database server and execute SQL SELECT, INSERT, UPDATE and DELETE from parameters that define tables, fields, field values, and conditions clauses.
Package:
Summary:
Manipulate and convert dates
Groups:
Author:
Description:
This class can be used to manipulate and convert dates.
It can parse dates in different formats and extract the year, month, day and week day.
The class can also compute the number of days between dates and add or subtract days to a date.
The code and comments are in Portuguese.
In Portuguese:
Essa é uma classe simples de manipulação de datas no formato Timestamp, SQL para o formato brasileiro e vice-versa. Além de realizar algumas operações de adição e subtração de dias.
Package:
Summary:
Get statistics and beautify text strings
Groups:
Author:
Description:
This class can be used to get statistics and beautify text strings.
It can analyze a given text string and get the total length, the number of non-whitespace characters, number of letters, number of spaces and tabs, number of symbol characters, number of words and number of sentences.
The class can also beautify the text by removing exceeding spaces, punctuation and line breaks.
Package:
Summary:
Validate and process file uploads
Groups:
Author:
Description:
This class can be used to validate and process file uploads.
It can check if the uploaded files have one of the allowed file name extensions and MIME types, and does not exceed the allowed file limits.
Image files are opened to verify they really contain image data of the determined format.
The class can move the uploaded files to a given directory if it exists and has write permissions.
The idiom of the error messages is configurable from a list of supported idioms.
Package:
Summary:
Read and sort CSV file data into array
Groups:
Author:
Description:
This class can be used to read and sort CSV file data into array.
It can open a CSV file and read its data into a bidimensional array.
The retrieved data array can also be sorted.
In Portuguese:
Uma classe simples para a conversão de arquivos CSV para array.
Os arquivos CSV devem conter os cabeçalhos.
