ajaxCRUD.com
» a PHP API to create / read / update / delete from a database table using AJAX
Define Allowable Values Example
Consider the following table:
CREATE TABLE tblDemo(
pkID INT PRIMARY KEY AUTO_INCREMENT,
fldField1 VARCHAR(40),
fldField2 VARCHAR(40),
fldField3 VARCHAR(40),
fldCertainFields VARCHAR(40),
fldLongField TEXT
);
| fldField1 | fldField2 | fldCertainFields | fldLongField | Action |
|---|---|---|---|---|
| NEW Value | ||||
| 555 | NEW Value | 978 | ||
| 6 | 454 | |||
| This is another Value | ||||
| ffff | fffffff | This is another Value | ffffff99 | |
| 1234 | trssd | NEW Value | dffggg | |
| a | a | NEW Value | a | |
| My Awesome Value |
Class Implementation:
#include the class
include ('ajaxCRUD.class.php');
#this one line of code is how you implement the class
$tblDemo = new ajaxCRUD("New Item", "tblDemo", "pkID");
$tblDemo->omitPrimaryKey();
$allowable_vals = array("My Awesome Value",
"This is another Value",
"NEW Value", "OLD Value");
$tblDemo->defineAllowableValues("fldCertainValues",
$allowable_vals);
#actually show to the table
$tblDemo->showTable();
View Example by Itself
Click here to view example outside of the template.
Recent Feedback
"I got a problem, russion input text now work cortctly
after submiting form i get like something :
%u0442%u0435%u0441%u0442 %u0435%u0441%u0442
Help! =)
" - Posted by Yuri on Sunday Jul 27th, 2008 at 9:54am
after submiting form i get like something :
%u0442%u0435%u0441%u0442 %u0435%u0441%u0442
Help! =)
" - Posted by Yuri on Sunday Jul 27th, 2008 at 9:54am
" Any/all issues/bugs/questions will be answered in the only forum: http://www.ajaxcrud.com/forum/viewforum.php?f=2" - Posted by Sean Dempsey on Monday Oct 6th, 2008 at 12:45am
"ldakympvg vucxh ubysm sonb ukgtms bniptexf bkvz" - Posted by fzsr huzebk on Tuesday Sep 23rd, 2008 at 8:51pm
"
Great api. Really love the demo.
I`ve just spent the better part of the morning installing it for use in my application. So far, so good.
There is a problem with the input saving to my database however. It calls up my database table fields fine, I enter the information but it doesn`t save to my database and the webpage shows a broken/empty icon where my information should be displayed.
Can you help me with this issue, please." - Posted by Ade on Tuesday Nov 11th, 2008 at 8:42am
Great api. Really love the demo.
I`ve just spent the better part of the morning installing it for use in my application. So far, so good.
There is a problem with the input saving to my database however. It calls up my database table fields fine, I enter the information but it doesn`t save to my database and the webpage shows a broken/empty icon where my information should be displayed.
Can you help me with this issue, please." - Posted by Ade on Tuesday Nov 11th, 2008 at 8:42am
Leave a Comment
(did you have this years ago...? haha)" - Posted by Jake on Wednesday Jul 16th, 2008 at 10:08pm