Database Code Generator

Database Code Generator Version 5 is here!

Up To Date to FIVE.1.0 on 8/2013

Updated to 5.0.4 on 6/2013

DBCG was built to save lots of time while working with a database. It robotically creates all kinds of outputs for you at the click on of a button! Even Ajax forms!! In a cliff-notes type here’s what this script does. It hooks into your database and generates HTML and PHP code that you simply can copy and paste into your challenge. in preference to having to write a sort – you'll be able to replica and paste one – custom designed on your database structure!! as opposed to having to put in writing the code to process your SUBMIT|GET|REQUEST request, you'll copy and paste it. in place of having to put in writing INSERT, UPDATE, or SELECT statements, you can copy and paste it. rather than… well, you get the picture.

Database Code Generator has over ONE HUNDRED different database interactions / operations on the contact of your palms. See the whole list at the bottom of the web page!

DBCG is tremendous easy to use! Just log in for your database and select your desired output and also you’re performed!!

Database Code Generator FIVE.0 is on the market for download!!

DBCG v5 is a complete rewrite. It has been written in a modular model so that you just can build your personal modules without being worried about a long term replace overwriting your custom paintings. if you happen to decide to have the “Quick Login” setup, you can easily switch between databases and tables with no need to log in each time you turn.

FIVE.0 is translatable!

It comes with English, German, Spanish, French, Italian, Dutch, Portuguese and Turkish languages all able to pass. [Current translations are done by machine and may contain mistakes.]

DBCG 5.0 is constructed atop Twitters Bootstrap

It's simple to customise should you feel the need to accomplish that!!

Database Data

While operating with the database, Database Code Generator FIVE.0 will display you some data in regards to the database like how much overhead the present desk has as opposed to how so much overhead all of the database has. It shows you the typical length of the rows in the present table besides as what number of rows the table has. It additionally shows you ways so much knowledge the table and database are the use of.

With DBCG I HAVE created complete applets by way of element-click-reproduction-paste!!

I HAVE created a couple of small applets without having to actually code any subsidized PHP! I just copied and pasted from DBCG and was once performed! It in fact took longer to do the front end layout than it did to do the backend capability!!

Nailed it!! – My Favorite Testimony:

Ajax Paperwork

Database Code Generator produces Ajax paperwork without a coding required!!! in the operations listing, scroll right down to the jQuery section and use certainly one of the two [insert|update] full pages.

Database Looking Out

Wish To placed a search shape to your site with as little effort as imaginable?

Pagination

No One likes coding pagination – however everyone loves the usage of it!

Database PDO

A thoughts-binder for some – just made simple!

Publish, Get, Request, Raw, Array – you title it!

DBCG now permits you to produce output in exactly approximately every way conceivable.

Why?

I’m an old skool developer. you already know how worrying it's whilst you’re chatting with any individual they usually try to end every of your sentences for you? Occasionally they get it proper, however such a lot of the time you've gotten to prevent them, say no, and start all over the place. Well, that’s the way in which i feel about IDE’s. I’ve tried using NetBeans, however we finally end up fighting more than operating. not only that, however I don’t follow common formatting conventions with my supply code and it seems to irritate the crap out of netbeans because it’s always doping up with some bubble or any other. I desire notepad – a blank white reveal and not using a interruptions!!! That being stated – I do a lot of repetitive coding. So, I evolved this script to avoid wasting myself some time – the reality that i can promote it here was once an advantage.

New Developers

This script was once by no means meant to be used by new builders. It used to be more of a brief cut for knowledgeable developers. My script turns out to be attracting a new developer crowd – that's cool – young blood brings new concepts!. DBCG has FIVE “full web page” operations. Relatively literally, you select considered one of the entire web page operations, copy and paste the code to a new web page to your server and give it a layout. the full web page operations have all of the code needed from the shape to PUT UP processing and placing/updating the database [see note below]. You Can use those five operations as building blocks!!

Integrated PHP Purposes

The integrated PHP functions need to be customized to fulfill your security wishes. they should work as they are for a controlled atmosphere – however i recommend customizing them in your particular person wishes. In other words, bring to mind them as hooks in preference to production able functions!!

Features

I in truth don’t have time for the glitz and glam in this one. i cannot most likely listing all of the options and why you must purchase it – but you must!

The Way To Use

Upload DBCG to the server you are creating on and log into the SQL Server with Step 1.

The script will pilfer your database and generate an inventory of tables for Step 2. Merely make a selection the desk you need to work with from the drop-down.

Step 3 will populate a drop-down record of all SIXTEEN 39 50 109 options you can use to save lots of your self time in development by copy and pasting the generated code into your script(s).

Forms

This script will look to see the “sort” of column that may be within the database to figure out the maxlength of the input fields. If the column is an INT or VarChar [or whatever] with a period of EIGHT then the maxlength of that exact enter field will also be EIGHT.

If the column sort is “textual content, mediumtext, longtext, blob, mediumblob, or longblob” as opposed to the use of a text enter, it'll use a textarea.

HTML5 Forms

This script will match up column names with HTML5 enter types to figure out the type of enter to use. for example: a sound enter type for HTML5 is “e mail” – so, if the name of the column within the database is named “e mail” this script will use that HTML5 input kind. ALTERNATIVELY, if the column identify is e_mail – the script will provide it a “text” input sort unless e_mail is a custom column name (see field underneath).

HTML5 Customized Bureaucracy Sorts

Edit the config report. on the most sensible you'll see a listing of arrays. Striking the identify of your column in the suitable array will cause that column to be identified as HTML5 sort whilst the “Custom Column” checkbox is checked.

Example: Permit’s say you've gotten a column named “telephone” that is used to store phone numbers, and also you need that enter box to be a HTML5 type of “number”.
$html5_number = array("telephone");
By Way Of adding “telephone” within the $html5_number array while you choose HTML5 from the Opt dropdown, any column with the title of telephone might be assigned the HTML5 enter form of “quantity” while the “Custom Column” checkbox is checked.

to peer the custom arrays in action:

in the reside demo I'VE a table called “demo”. In that table is a column named “notes” – it's a VarChar with a 128 persona restrict.
visit the are living demo and click Submit.
In Step 2 select the desk : “demo”
In Step THREE make a selection the operation : “Form – input”
watch for the consequences to show up and glance on the [last] enter named “notes”. you are going to understand that it's a textual content enter.
Now place a checkmark in the “customized columns” checkbox. [at the top of the page]
look ahead to the effects to replace and look on the [last] enter named “notes”. you will notice that it is now a textarea.

Whole Listing of Operations

• PHP Processing
  • Procedure Means
    • $_POST
    • $_GET
    • $_REQUEST
  • Database => Array
    • $key=>$val
    • $key
    • $val
    • Serialize
    • Unserialize
  • Database Echos
    • Echo Variables
• MySQL
  • Connect
    • Connect
    • Attach[alt]
  • Insert
    • Insert
    • Insert [alt]
  • Replace
    • Update
    • Replace[alt]
  • Select
    • Select One
    • Select Many
    • Choose All
    • Depend Rows
  • Search
    • Seek Left
    • Search Right
    • Seek Both
  • Delete
    • Delete
• Functions
  • Functions
    • Clean
    • sql_val
    • sql_key
    • reverb
    • print_x
• Records
  • Stats
    • Information
• Pages / Ajax
  • jQuery Supply
    • jQuery fallback
    • jQuery
    • jQuery UI fallback
    • jQuery UI
  • Ajax
    • Complete Web Page Ajaxed [Insert]
    • Full Web Page Ajaxed [Update]
  • HTML Pages
    • Full Web Page [Insert]
    • Complete Page [Update]
    • Full Page Commented
• Misc
  • Lists
    • Undeniable Textual Content Table Record
    • Undeniable Text Column Checklist[alt]
• Paperwork
  • HTML
    • HTML Form
    • HTML – Prefilled
  • HTML5
    • HTML5 Form
    • HTML5 Form – Prefilled
  • Obfuscation
    • HTML Shape – Obfuscated
    • HTML Form – Obfuscated [alt]

Further Plugins

• PDO Database Operations
  • Connect
    • Connect
    • Attach[alt]
  • Insert
    • Insert
    • Insert [alt]
  • Replace
    • Update
    • Replace[alt]
  • Make A Selection
    • Select One
    • Choose Many
    • Make A Selection All
  • Search
    • Seek Left
    • Search Right
    • Seek Both
  • Delete
    • Delete
• MySQL Adv
  • Miscellaneous
    • Reproduction Desk Construction
    • Drop Down Checklist of Tables
    • Drop Down List of Columns
    • Drop Down Record Generator
    • Find & Show Duplicates
    • Subsequent Car Increment – the safe approach
    • Next Vehicle Increment
    • Next Automobile Increment [alt]
    • Insert Into – On Reproduction – Replace
    • Insert Into – On Replica – Update [alt]
    • Pagination
• Opposite
  • Shape
    • Reverse Shape
  • Table
    • Reverse Desk

Historical Past

• Version FIVE.1 – Aug 19th 2013
  • More Than 2 dozen tweaks, bug fixes and enhancements
  • not requires Mod Rewrite
• Model 5.0 – Mar 3rd 2013
  • Process Operations
    • $_GET
    • $_REQUEST
  • MySQL Operations
    • Search [Left]
    • Seek [Right]
    • Seek [Both]
    • Rely Rows
  • Ajax Stuff
    • External Hosted jQuery
    • jQuery UI
    • Exterior Hosted jQuery UI
  • Records
    • Database & Desk Size
    • Database & Table Overhead
    • Database & Table Column Depend
    • Database & Table Row Rely
    • Database & Desk Average Row Period
  • Additional Plugins
    • PDO Database Operations
      • Connect
        • Attach
        • Attach[alt]
      • Insert
        • Insert
        • Insert [alt]
      • Replace
        • Replace
        • Update[alt]
      • Make A Choice
        • Choose One
        • Make A Choice Many
        • Select All
      • Seek
        • Seek Left
        • Seek Right
        • Search Both
      • Delete
        • Delete
    • MySQL Adv
      • Miscellaneous
        • Reproduction Table Structure
        • Drop Down Checklist of Tables
        • Drop Down Listing of Columns
        • Drop Down Checklist Generator
        • To Find & Show Duplicates
        • Next Automobile Increment – the safe way
        • Subsequent Vehicle Increment
        • Subsequent Vehicle Increment [alt]
        • Insert Into – On Replica – Update
        • Insert Into – On Replica – Update [alt]
        • Pagination
    • Opposite
      • Shape
        • Reverse Shape
      • Table
        • Opposite Desk
• Version 4.0 – Nov 20th 2012
• Version 3.0 – Jan 11th 2011
  • Create Desk
  • jQuery
  • jQuery Complete Web Page [Insert]
  • jQuery Full Web Page [Update]
  • To Find & Show Duplicates
  • Subsequent Vehicle Increment – the safe manner
  • Next Car Increment
  • Subsequent Auto Increment [alt]
  • Insert Into – On Duplicate – Update
  • Insert Into – On Replica – Update [alt]
  • Complete Page [Insert] Absolutely Commented
• Version 2.0 – Complete ReWrite – Nov second 2011
  • Choose All
  • Make A Choice All in a Table
  • Delete from database
  • PHP Array key=>$val
  • PHP Array $val
  • PHP Array key
  • PHP Array Serialize for DB
  • PHP Array UnSerialize from DB
  • if isset echo
  • if isset blank echo
  • if no longer empty echo
  • if now not empty blank echo
  • HTML Form – Obfuscated
  • HTML Form – Obfuscated alt
  • Drop Down List of Tables
  • Drop Down List of Columns
  • Make A Choice Generator
  • Complete Page Insert
  • Full Web Page Update
  • serve as sql_val()
  • function clean()
  • serve as reverb()
  • function print_x()
  • All purposes used
• Version 1.0 – Preliminary Liberate – Oct. 24th 2011
  • Database Connection
  • Database Connection alt
  • Choose One
  • Make A Selection Many
  • Insert Into Database
  • Insert Into Database alt
  • Replace Database
  • Update Database alt
  • Post
  • PHP Array
  • Form – Input
  • Form – Input prefilled
  • HTML5 Shape – Enter
  • HTML5 Shape – Enter prefilled
  • Plain Textual Content Column Record
  • Simple Textual Content Desk List

FULL DOWNLOAD