PHP Classes

Packages of René Mansveld

Recommend this page to a friend!
  All class groups  >  All authors  >  Packages of René Mansveld (3)  >  Mission progress status  >  Reputation  
Picture of René Mansveld
Name: René Mansveld is available for providing paid consulting. Contact René Mansveld .
Classes: 3
Country: Germany Germany
Age: 61
All time rank: 3531198 in Germany Germany
Week rank: 195 Up8 in Germany Germany Up
All time users: 406
Week users: 0
Innovation award
Innovation award
Nominee: 1x

Winner: 1x
 
  A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z  
  Files folder image DBUpdater  
Generate and execute MySQL database update files
The update tool for MySQL databases between development and production system.

This tool transfers the structure of one MySQL database to another.

Use this tool to read the database structure on the development system, then upload the transport file to the productive system and use this tool to update the database structure there.

Only missing columns and tables are added to the target database, and nothing is deleted.

Nothing changes in the data either, neither in the source nor in the target database.

To use this tool, do the following:

The transfer takes place in 2 steps: reading out and updating.

Read out

- Copy the script to a web server with access to the source database,

- Call the script in the browser,

- Enter the requested data and click on the "Read out" link.

The name of the transport file can be freely selected.

Optimally, no path is specified for this, and the file is stored in the same directory where the script is located.

Update

- Copy the script and the transport file to a web server with access to the target database

- Use this tool in the browser

- Enter the requested data and click on the "Update" link.

Logically, the name of the transport file must be the same as that specified in the "Read out" step.

No path must be specified if the file is in the same directory as the tool (recommended).

The tool has been tested with some databases. Nevertheless, it can, of course, happen that the tool does not work correctly.

For this reason, it is recommended (as always with structural changes) to create a backup before executing.
Not yet rated by the users

  Files folder image PHP HTML5 Form  
Display and validate a form that uses HTML5
This package can display and validate a form that uses HTML5.

It provides functions to add different types of form fields, buttons, or additional HTML tags.

Currently, it supports the field types: bic, checkbox, checkbox group, color, credit card, currency, date, email, file, float, hidden, IBAN, integer, IP, name, password, radio, radio group, range, select, tel, text, textarea, time, URL, zip code.

It also supports button types: submit, reset, and button.

HTML tags are of any type you need to insert into your form, for example, HTML code for a multi-column form or JavaScript to get the visitor's position coordinates.

The HTML generated by this package for the form uses JavaScript to validate the input on-the-fly but also works when the browser does not enable JavaScript support. In this case, the validation will happen only using the rules specified by the generated HTML tags.

The generated JavaScript code assigns the input fields validated by a CSS class that can be either wrong or correct. Developers can define these CSS classes in the stylesheet to show the validation state of each input to the site user.

After the form is submitted, the class can take the submitted form input values to validate the form on the server side. The class returns either 'true' for a completely valid form or an array with the names of the non-valid fields.
Not enough user ratings

  Files folder image PHP MySQL Copy Database  
PHP Programming Innovation award winner
September 2021
Winner


Prize: One official elePHPant Plush Mascott
Copy MySQL tables from one database to another
This class can copy MySQL tables from one database to another.

It provides a Web page script and a class that extends the PHP MySQLi to connect to a given MySQL database server.

The script executes queries using the class to copy all table records from one database in one server to another in the same server or a different server.

It copies 100 table records at a time if those records are not damaged.

The origin and destination MySQL servers can run different versions of MySQL.

Notice that if the origin MySQL server crashes, you should restart the server before you use this class to copy the records.

If the process of reading from damaged tables takes longer, you should set the PHP execution time limit option to at least 2 minutes (120 seconds).
Not yet rated by the users


  A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z