[ad_1]
To get this product on 50 % contact me on this link
Database Code Generator Version 5 is right here!
Updated to six.Zero on 1/2017 – transformed to MySQLi
Updated to five.1.Zero on 8/2013
Updated to five.0.Four on 6/2013
DBCG was constructed to save lots of time when working with a database.
It mechanically creates all types of outputs for you on the click on of a button! Even Ajax varieties!!
In a cliff-notes vogue right here’s what this script does. It hooks into your database and generates HTML and PHP code which you can copy and paste into your mission. Instead of getting to put in writing a type – you possibly can copy and paste one – personalized to your database construction!! Instead of getting to put in writing the code to course of your POST|GET|REQUEST request, you possibly can copy and paste it. Instead of getting to put in writing INSERT, UPDATE, or SELECT statements, you possibly can copy and paste it. Instead of… effectively, you get the image.
Database Code Generator has over 100 totally different database interactions / operations on the contact of your fingers.
See the total record on the backside of the web page!
DBCG is tremendous easy to make use of! Just log in to your database and choose your required output and also you’re accomplished!!
Database Code Generator 5.Zero is out there for obtain!!
DBCG v5 is an entire rewrite. It has been written in a modular vogue with the intention to construct your personal modules with out worrying a couple of future replace overwriting your customized work.
If you select to have the “Quick Login” setup, you possibly can simply swap between databases and tables with out having to log in every time you turn.
5.Zero is translatable!
It comes with English, German, Spanish, French, Italian, Dutch, Portuguese and Turkish languages all able to go. [Current translations are done by machine and may contain mistakes.]
DBCG 5.Zero is constructed atop Twitters Bootstrap
It is straightforward to customise must you really feel the necessity to take action!!
Database Statistics
When working with the database, Database Code Generator 5.Zero will present you some statistics concerning the database like how a lot overhead the present desk has versus how a lot overhead the complete database has. It exhibits you the typical size of the rows within the present desk in addition to what number of rows the desk has. It additionally exhibits you the way a lot knowledge the desk and database are utilizing.
With DBCG I’ve created total applets by point-click-copy-paste!!
I’ve created a number of small applets with out having to truly code any backed PHP! I simply copied and pasted from DBCG and was accomplished! It truly took longer to do the entrance finish design than it did to do the backend performance!!
Nailed it!! – My Favorite Testimony:
Ajax Forms
Database Code Generator produces Ajax varieties with no coding required!!! In the operations record, scroll right down to the jQuery part and use one of many two [insert|update] full pages.
Database Searching
Want to place a search type in your web site with as little effort as attainable?
Pagination
Nobody likes coding pagination – however everybody loves utilizing it!
Database PDO
A mind-binder for some – simply made simple!
Post, Get, Request, Raw, Array – you title it!
DBCG now permits you to produce output in nearly each approach possible.
Why?
I’m an old-fashioned developer. You know the way annoying it’s if you’re speaking to somebody they usually attempt to end every of your sentences for you? Sometimes they get it proper, however more often than not you must cease them, say no, and begin throughout. Well, that’s the best way I really feel about IDE’s. I’ve tried utilizing NetBeans, however we find yourself combating greater than working. Not solely that, however I don’t comply with widespread formatting conventions with my supply code and it appears to annoy the crap out of netbeans as a result of it’s at all times popping up with some bubble or one other. I desire notepad – a clear white display with no interruptions!!! That being mentioned – I do quite a lot of repetitive coding. So, I developed this script to save lots of myself a while – the truth that I can promote it right here was a bonus.
New Developers
This script was by no means meant for use by new builders. It was extra of a brief reduce for skilled builders. My script appears to be attracting a brand new developer crowd – which is cool – younger blood brings new concepts!. DBCG has 5 “full page” operations. Quite actually, you choose one of many full web page operations, copy and paste the code to a brand new web page in your server and provides it a design. The full web page operations have all of the code wanted from the shape to POST processing and inserting/updating the database [see note below]. You can use these 5 operations as constructing blocks!!
Included PHP Functions
The included PHP capabilities must be personalized to satisfy your safety wants. They ought to work as they’re for a managed setting – however I like to recommend customizing them on your particular person wants. In different phrases, consider them as hooks slightly than manufacturing prepared capabilities!!
Features
I actually don’t have time for the glitz and glam on this one. I can’t probably record all of the options and why you can purchase it – however you need to!
How To Use
Upload DBCG to the server you’re growing 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. Simply choose the desk you need to work with from the drop-down.
Step Three will populate a drop-down record of all 16 39 50 109 choices you need to use to save lots of your self time in growth by copy and pasting the generated code into your script(s).
Forms
This script will look to see the “type” of column that’s within the database to find out the maxlength of the enter fields. If the column is an INT or VarChar [or whatever] with a size of Eight then the maxlength of that exact enter subject will even be 8.
If the column sort is “text, mediumtext, longtext, blob, mediumblob, or longblob” as a substitute of utilizing a textual content enter, it is going to use a textarea.
HTML5 Forms
This script will match up column names with HTML5 enter sorts to find out the kind of enter to make use of. For instance: A legitimate enter sort for HTML5 is “email” – so, if the title of the column within the database is known as “email” this script will use that HTML5 enter sort. HOWEVER, if the column title is e_mail – the script will give it a “text” enter sort except e_mail is a customized column title (see field under).
HTML5 Custom Forms Types
Edit the config file. At the highest you will note an inventory of arrays. Putting the title of your column within the acceptable array will set off that column to be acknowledged as HTML5 sort when the “Custom Column” checkbox is checked.
Example: Let’s say you’ve a column named “phone” that’s used to retailer telephone numbers, and also you need that enter subject to be a HTML5 sort of “number”.
$html5_number = array("phone");
By including “phone” within the $html5_number array when you choose HTML5 from the Opt dropdown, any column with the title of telephone might be assigned the HTML5 enter sort of “number” when the “Custom Column” checkbox is checked.
To see the customized arrays in motion:
In the stay demo I’ve a desk known as “demo”. In that desk is a column named “notes” – it’s a VarChar with a 128 character restrict.
Go to the stay demo and click on Submit.
In Step 2 choose the desk : “demo”
In Step Three choose the operation : “Form – input”
Wait for the outcomes to point out up and have a look at the [last] enter named “notes”. You will discover that it’s a textual content enter.
Now place a checkmark within the “custom columns” checkbox. [at the top of the page]
Wait for the outcomes to replace and have a look at the [last] enter named “notes”. You will discover that it’s now a textarea.
Complete List of Operations
- PHP Processing
- Process Method
- $_POST
- $_GET
- $_REQUEST
- Database => Array
- $key=>$val
- $key
- $val
- Serialize
- Unserialize
- Database Echos
- Echo Variables
- Process Method
- MySQL
- Connect
- Connect
- Connect[alt]
- Insert
- Insert
- Insert [alt]
- Update
- Update
- Update[alt]
- Select
- Select One
- Select Many
- Select All
- Count Rows
- Search
- Search Left
- Search Right
- Search Both
- Delete
- Delete
- Connect
- Functions
- Functions
- Clean
- sql_val
- sql_key
- reverb
- print_x
- Functions
- Statistics
- Stats
- Statistics
- Stats
- Pages / Ajax
- jQuery Source
- jQuery fallback
- jQuery
- jQuery UI fallback
- jQuery UI
- Ajax
- Full Page Ajaxed [Insert]
- Full Page Ajaxed [Update]
- HTML Pages
- Full Page [Insert]
- Full Page [Update]
- Full Page Commented
- jQuery Source
- Misc
- Lists
- Plain Text Table List
- Plain Text Column List[alt]
- Lists
- Forms
- HTML
- HTML Form
- HTML – Prefilled
- HTML5
- HTML5 Form
- HTML5 Form – Prefilled
- Obfuscation
- HTML Form – Obfuscated
- HTML Form – Obfuscated [alt]
- HTML
Additional Plugins
- PDO Database Operations
- Connect
- Connect
- Connect[alt]
- Insert
- Insert
- Insert [alt]
- Update
- Update
- Update[alt]
- Select
- Select One
- Select Many
- Select All
- Search
- Search Left
- Search Right
- Search Both
- Delete
- Delete
- Connect
- MySQL Adv
- Miscellaneous
- Copy Table Structure
- Drop Down List of Tables
- Drop Down List of Columns
- Drop Down List Generator
- Find & Show Duplicates
- Next Auto Increment – the protected approach
- Next Auto Increment
- Next Auto Increment [alt]
- Insert Into – On Duplicate – Update
- Insert Into – On Duplicate – Update [alt]
- Pagination
- Miscellaneous
- Reverse
- Form
- Reverse Form
- Table
- Reverse Table
- Form
History
- Version 5.1 – Aug 19th 2013
- More than 2 dozen tweaks, bug fixes and enhancements
- No longer requires Mod Rewrite
-
Version 5.0 – Mar 3rd 2013
- Process Operations
- $_GET
- $_REQUEST
- MySQL Operations
- Search [Left]
- Search [Right]
- Search [Both]
- Count Rows
- Ajax Stuff
- External Hosted jQuery
- jQuery UI
- External Hosted jQuery UI
- Statistics
- Database & Table Size
- Database & Table Overhead
- Database & Table Column Count
- Database & Table Row Count
- Database & Table Average Row Length
-
Additional Plugins
- PDO Database Operations
- Connect
- Connect
- Connect[alt]
- Insert
- Insert
- Insert [alt]
- Update
- Update
- Update[alt]
- Select
- Select One
- Select Many
- Select All
- Search
- Search Left
- Search Right
- Search Both
- Delete
- Delete
- Connect
- MySQL Adv
- Miscellaneous
- Copy Table Structure
- Drop Down List of Tables
- Drop Down List of Columns
- Drop Down List Generator
- Find & Show Duplicates
- Next Auto Increment – the protected approach
- Next Auto Increment
- Next Auto Increment [alt]
- Insert Into – On Duplicate – Update
- Insert Into – On Duplicate – Update [alt]
- Pagination
- Miscellaneous
- Reverse
- Form
- Reverse Form
- Table
- Reverse Table
- Form
- PDO Database Operations
- Process Operations
- Version 4.0 – Nov 20th 2012
- Version 3.0 – Jan 11th 2011
- Create Table
- jQuery
- jQuery Full Page [Insert]
- jQuery Full Page [Update]
- Find & Show Duplicates
- Next Auto Increment – the protected approach
- Next Auto Increment
- Next Auto Increment [alt]
- Insert Into – On Duplicate – Update
- Insert Into – On Duplicate – Update [alt]
- Full Page [Insert] Fully Commented
- Version 2.0 – Complete ReWrite – Nov 2nd 2011
- Select All
- Select 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 clear echo
- if not empty echo
- if not empty clear echo
- HTML Form – Obfuscated
- HTML Form – Obfuscated [alt]
- Drop Down List of Tables
- Drop Down List of Columns
- Select Generator
- Full Page [Insert]
- Full Page [Update]
- operate sql_val()
- operate clear()
- operate reverb()
- operate print_x()
- All capabilities used
- Version 1.0 – Initial Release – Oct. 24th 2011
- Database Connection
- Database Connection [alt]
- Select One
- Select Many
- Insert Into Database
- Insert Into Database [alt]
- Update Database
- Update Database [alt]
- Post
- PHP Array
- Form – Input
- Form – Input [prefilled]
- HTML5 Form – Input
- HTML5 Form – Input [prefilled]
- Plain Text Column List
- Plain Text Table List
[ad_2]
To get this product on 50 % contact me on this link
