Securised backend
Integrity constraints, multiplicity relationships, picture database, java applet, etc.
php generator
- By coders for coders !
- Adapt to your database
- Easier than phpnuke
- Very fast processor
- Automatic Pictures management
- Big files management (+500Mb)
- Securised, session management
- Elements contained in other using id_table
- Choose the ftp or the http version
- Address database with id_address
- HTML editor integrated, start your field name with html_
- Use nomenclature rules within your database and generate back-end
- Automatic date management
- Recursive data structures (self-reference possible)
- Complementary products: search engine and project manager
- Complete publishing validation system
One-to-many in mysql, integrity constraint
|
Reparation
|
MySQL is a light database system and lack of features that are needed for managing your complex databases. To express the 'has-a' relationship, you need a link to be established between 2 related tables. This link, called 'integrity constraint', is impossible in mysql. SQLmyAdmin is not any better for this, it cannot associate data of different tables together. It presents all the data in the brut form. Our system is an attempt to compensate all this. |
create table news
(
id_news int(11) auto_increment,
title varchar(255),
date_edition date
);
|
<— X |
create table news_article
(
id_news_article int(11) auto_increment,
id_news int(11),
html_text blob,
author varchar(255)
);
|
|
One-to-many
|
Our systems is built on top of the most widely used database software (for web databases) to compensate problems, to ameliorate it. It allows to associate data to other data, to make the articles really contained in a letter and to manage it. It imply that our navigation system allows to navigate from a letter to the articles it contains, and to come back to the parent letter. |
- It allows also to create a new article into this letter, by using the navigation menus.
- It also manage the integrity constraint by deleting all sub-entities when an entities is destroyed (except the recursive ones.).
- To except a relationship from the integrity constraint, just don't follow the nomenclature rule for the table name:
name the tables: collection and drawing instead of collection_drawing
- In that case, if you name a field id_drawing in the collection table, a selector is given in the collection form to choose one of the existing drawing. In case of the collection deletion, the drawing survive.
- You can download models forms ready at htmlforms
generator.com/ - No more backend coding...
- Use it for a special purpose: baby pictures, portfolio, client files, inventory, etc.
- Free sample ! for evaluation