Consider the following table:
CREATE TABLE tblDemo( pkID INT PRIMARY KEY AUTO_INCREMENT, fldField1 VARCHAR(45), fldField2 VARCHAR(45), fldCertainFields VARCHAR(40), fldLongField TEXT );
|CRUD Saving...||jljkljlkjkl Saving...|
|CRUD Saving...||cvccccccfze555123 Saving...|
|Allowable Value2 Saving...||kkkk Saving...|
|Allowable Value 1 Saving...||retzefezro Saving...|
|CRUD Saving...||bcvhngff Saving...|
|-- Saving...||-- Saving...|
#required file and class require_once ('preheader.php'); include_once ('ajaxCRUD.class.php') #this one line of code is how you implement the class $tblDemo = new ajaxCRUD("Item", "tblDemo", "pkID"); $tblDemo->omitPrimaryKey(); #define our checkboxes $tblDemo->defineCheckbox('fldField1','on','off'); $tblDemo->defineCheckbox('fldField2','on','off'); #show header checkboxes $tblDemo->showCheckboxAll('fldField1', true); $tblDemo->showCheckboxAll('fldField2', true); #for heck of it, only certain fields are allowed for fldCertainFields $allowableValues = array("Allowable Value 1", "Allowable Value2", "Dropdown Value", "CRUD"); $tblDemo->defineAllowableValues("fldCertainFields", $allowableValues); #disallow adding and deleting rows $tblDemo->disallowDelete(); $tblDemo->disallowAdd(); #actually show the table $tblDemo->showTable();
Read API Documentation on this function here.
Click here to view example outside of the template.
Plan to use ajaxCRUD™ on a business/commercial website? You must purchase a license.
You are allowed to use this product or part(s) of it on a single web site only, belonging to either you or your client. You have to purchase the same product again if you want to use the same product in connection with another or other projects.
Any analysis of the program, embedded data or license files by any means and by any entity whether human or otherwise and including but without limitation to discover details of internal operation, to reverse engineer, to de-compile object code, or to modify for the purposes of modifying behavior is forbidden.
Any analysis of encoded files by any means and by any entity whether human or otherwise and including but without limitation to discover details of file format or modification for the purposes of modifying behavior or scope of their usage is forbidden.
All imagery and fonts used in this product are an integral part of the product. You can use images and fonts only as a part of the web site you build using this product. You can use imagery and fonts to develop one project only. Any kind of separate usage or distribution is strictly prohibited.
You are authorized to make necessary modifications to this product to fit your purposes in accordance with this license.
The product is property of Tania Alekova. You shall not offer this product or part(s) of it, modified or unmodified, for redistribution or resale of any kind. You shall not sub-license, assign, or transfer this product or part(s) of it to any entity.
THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDER AND CONTRIBUTOR "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
If your organization makes a profit, you are a for-profit company. A commercial site is one created for a business, for which purpose is generating revenue or cash flow of any type (and that isn't under a non-profit organization). So if you're selling a product, selling advertisement, selling a service, or just marketing a commercial business, your site is commercial. A company website is commercial even if it doesn't sell anything on the site, as it's purpose is to market/promote a commercial company.