CodeCanyon Database Code Generator 699415

CodeCanyon Database Code Generator 699415

CodeCanyon Database Code Generator 699415
PHP Script \ Database Abstraction
Generator \ Mysql \ Phpmyadmin \ Html \ Code \ Form \ Database



PHP Script - Database Code Generator 699415 by CodeFusion @ CodeCanyon

PHP Script \ Database Abstraction

Last Update: 12 January 12; Compatible Browsers: IE8, IE9, Firefox 4, Safari 5, Opera, Chrome; Software Version: PHP 4.x, PHP 5.x, PHP 5.0 - 5.2, PHP 5.3, MySQL 4.x, MySQL 5.x; High Resolution: No; Files Included: PHP.

Version 4 is in the works
I am working on version 4 right now. If you have any requests, get them in!
Version 4.0 Preview [teaser image]

If you would like to test 4.0 Alpha, verified purchasers can download it though my support center . My support center seems to randomly dislike people, so if it gives you problems, send me your Envato username and purchase code and I’ll get updated in the support center.
Database Code Generator : Version 3.0 Beta
Introduces many new operations.
Now includes the ability to produce ajax forms.
My Favorite Testimony.
Cmarenburg Said.
I have tried a few other programs before (a lot more expensive like 30X as much!) This is what i needed! I am a moderate coder, this just boasts production time, i can easily edit the code to fit my needs! Read More
Ajax Forms
Version 3.0 beta introduces the ability to produce ajax forms. In the operations list, scroll down to the jQuery section and use one of the two [insert|update] full pages.
Features
I honestly don’t have time for the glitz and glam on this one. I cannot possibly list all the features and why you should buy it – but you should!
In a cliff-notes fashion here’s what this script does. It hooks into your database and generates HTML and PHP code that you can copy and paste into your project. Instead of having to write a form – you can copy and paste one – customized to your database structure!! Instead of having to write the code to process your POST request, you can copy and paste it. Instead of having to write INSERT, UPDATE, or SELECT statements, you can copy and paste it. Instead of… well, you get the picture.
Why?
I’m an old school developer. You know how annoying it is when your talking to someone and they try to finish each of your sentences for you? Sometimes they get it write, but most of the time you have to stop them, say no, and start all over. Well, that’s the way I feel about IDE’s. I’ve tried using NetBeans, but we end up fighting more than working. Not only that, but I don’t follow popular formatting conventions with my source code and it seems to irritate the crap out of it because its always popping up with some bubble or another. I prefer notepad – a clean white screen with no interruptions!!! That being said – I do a lot of repetitive coding. So, I developed this script to save myself some time – the fact that I can sell it here was a bonus.
New Developers
Version 2.0 should be a bigger help! This script was never intended to be used by new developers. It was more of a short cut for experienced developers. My script seems to be attracting a new developer crowd – which is cool – young blood brings new ideas!. Version 2.0 has two “full page” operations. Quite literally, you select one of the full page operations, copy and paste the code to a new page on your server and give it a design. The full page operations have all the code needed from the form to POST processing and inserting/updating the database [see note below]. You can use these two operations as building blocks!! Future versions will give more help to new developers.
Included PHP Functions
The included PHP functions should be customized to meet your security needs. They should work as they are for a controlled environment – but I recommend customizing them for your individual needs. In other words, think of them as hooks rather than production ready functions!!
How To Use
Upload a single file to the server you are developing on and log into the SQL Server with Step 1.

The script will pilfer your database and generate a list of tables for Step 2. Simply select the table you want to work with from the drop-down.

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

In step 3; if you select a form operation, a button will be available at the end of the results box where you can preview your form.
Forms
This script will look to see the “type” of column that is in the database to determine the maxlength of the input fields. If the column is an INT or VarChar [or whatever] with a length of 8 then the maxlength of that particular input field will also be 8.

If the column type is “text, mediumtext, longtext, blob, mediumblob, or longblob” instead of using a text input, it will use a textarea.
HTML5 Forms
This script will match up column names with HTML5 input types to determine the type of input to use. For example: A valid input type for HTML5 is “email” – so, if the name of the column in the database is called “email” this script will use that HTML5 input type. HOWEVER, if the column name is e_mail – the script will give it a “text” input type unless e_mail is a custom column name (see box below).
HTML5 Custom Forms Types
Edit the php file. At the top you will see a list of arrays. Putting the name of your column in the appropriate array will trigger that column to be recognized as HTML5 type when the “Custom Column” checkbox is checked.
Example: Lets say you have a column named “phone” that is used to store phone numbers, and you want that input field to be a HTML5 type of “number”.

$html5_number = array("phone");

By adding “phone” in the $html5_number array when you select HTML5 from the Opt dropdown, any column with the name of phone will be assigned the HTML5 input type of “number” when the “Custom Column” checkbox is checked.

To see the custom arrays in action.
In the live demo I have a table called “demo”. In that table is a column named “notes” – it is a VarChar with a 128 character limit.

Go to the live demo and click Submit.

In Step 2 select the table : “demo”

In Step 3 select the operation : “Form – input”

Wait for the results to show up and look at the [last] input named “notes”. You will notice that it is a text input.

Now place a checkmark in the “custom columns” checkbox. [at the top of the page]

Wait for the results to update and look at the [last] input named “notes”. You will notice that it is now a textarea.
Complete List of Operations

- Database Connection

- Database Connection [alt]

- Select One

- Select Many

- Select All

- Select All in a Table

- Insert Into Database

- Insert Into Database [alt]

- Update Database

- Update Database [alt]

- Delete from database

- Create Table

- Post

- 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 clean echo

- if not empty echo

- if not empty clean echo

- Form – Input

- Form – Input [prefilled]

- HTML5 Form – Input

- HTML5 Form – Input [prefilled]

- Full Page [Insert]

- Full Page [Update]

- Full Page [Insert] Fully Commented

- function sql_val()

- function clean()

- function reverb()

- function print_x()

- All functions used

- HTML Form – Obfuscated

- HTML Form – Obfuscated [alt]

- Drop Down List of Tables

- Drop Down List of Columns

- Drop Down List Generator

- Plain Text Table List

- Plain Text Column List

- jQuery

- jQuery Full Page [Insert]

- jQuery Full Page [Update]

- Find & Show Duplicates

- Next Auto Increment – the safe way

- Next Auto Increment

- Next Auto Increment [alt]

- Insert Into – On Duplicate – Update

- Insert Into – On Duplicate – Update [alt]

History

- Version 3.0 – Jan 11 th 2011

- Create Table

- jQuery

- jQuery Full Page [Insert]

- jQuery Full Page [Update]

- Find & Show Duplicates

- Next Auto Increment – the safe way

- 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 2 nd 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 clean echo

- if not empty echo

- if not empty clean 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]

- function sql_val()

- function clean()

- function reverb()

- function print_x()

- All functions used

- Plain Text Column List

- Version 1.0 – Initial Release – Oct. 24 th 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

Code Repository | Snippet Manager; Randomator Database Stuffit Generator; Server & Website Monitor - Platinum; CraigsList Listing Tool; PHP Version Finder.htaccess Builder; MobiOpt.

Keywords: code, database, form generator, generator, html5, mysql, phpmyadmin.



Tags: Generator, Database, Phpmyadmin, Mysql

Premium CodeCanyon Database Code Generator 699415 WordPress Themes, Website Templates, Mobile Themes, Flash Templates & Scripts from creative professional designers. Full details of CodeCanyon Database Code Generator 699415 for digital design and education. CodeCanyon Database Code Generator 699415 desigen style information or anything related.

Comments:

Name:*
E-Mail:*
Add Comments:
Enter Code: *