-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
help on validation before accepting user input
- Thread starter rongame
- Start date
- Status
Add the validations you need to your elements (Validation tab).
The data isn't submitted as long as there are validation errors.
In form settining you can set Ajax validation =yes (default is no), this will validate every field directly after the input.
http://fabrikar.com/forums/index.php?wiki/validation-plugins/
The data isn't submitted as long as there are validation errors.
In form settining you can set Ajax validation =yes (default is no), this will validate every field directly after the input.
http://fabrikar.com/forums/index.php?wiki/validation-plugins/
Hello,
I don't know about connecting to another database (you might need to change the way you will connect to the external database), but for validation i think you can add a php validation like this:
I don't know about connecting to another database (you might need to change the way you will connect to the external database), but for validation i think you can add a php validation like this:
Code:
$value = '{tablename___elementname}';
$db =JFactory::getDBO();
$query=("SELECT field FROM table where field = '$value'");
$db->setQuery($query);
$response = $db->loadResult();
if ($response == 'your condition') {
return true;
} else {
return false;
}thanks
Please clarify
BTW im not a coder friend. Given the following
Table 1=table1 (client will encode data key in this table)
keycode=element where in client will encode a datakey which is pre generated
sample validations:
1. can not leave empty
2. keycode is invalid
3. keycode is in use
activation form=form that has the list of elements that will be encoded into the databse once key is valid
= this form can be cancelled if your keycode is in valid.
Tabele 2=table2(table where key will be checked if already in use or the key entered is not valid)
Pre Generated keys=element that has the keys.
friend where will i insert the php code? how do i accomplish the above?
thanks so much
Please clarify
BTW im not a coder friend. Given the following
Table 1=table1 (client will encode data key in this table)
keycode=element where in client will encode a datakey which is pre generated
sample validations:
1. can not leave empty
2. keycode is invalid
3. keycode is in use
activation form=form that has the list of elements that will be encoded into the databse once key is valid
= this form can be cancelled if your keycode is in valid.
Tabele 2=table2(table where key will be checked if already in use or the key entered is not valid)
Pre Generated keys=element that has the keys.
friend where will i insert the php code? how do i accomplish the above?
thanks so much
I think all the validations will run before submitting the information, so just add validations to the "keycode" element. Go to the Validation Tab in element and add validations like this:
1. Notempty validation - included by default in Fabrik
2. Keycode is invalid- see the php code, if value from database: table2 = value added by user then return true else return false. To use the code, add PHP validation like in my example.
3. Also a php validation, but you have to detail what is mean "in use"? Has been already used? If yes, how you will determine this, you will register 1 for used and 0 for not used?
As i said, the form will not submit information if all validations will not meet the conditions added.
1. Notempty validation - included by default in Fabrik
2. Keycode is invalid- see the php code, if value from database: table2 = value added by user then return true else return false. To use the code, add PHP validation like in my example.
3. Also a php validation, but you have to detail what is mean "in use"? Has been already used? If yes, how you will determine this, you will register 1 for used and 0 for not used?
As i said, the form will not submit information if all validations will not meet the conditions added.
hi im getting "code does not exist" even do the code is correct. by the way im changing my requirement to just validation on tables created on fabrik and not an external database. i dont know what command should be called to make the connection.
table 1 = empenc_warranty //form table that will be used by the end user
table 2 = seak_keycode //form table that will have the keycodes
both list and forms are generated via fabrik
warranty_code = element of table 1 (user will encode) that will validate data from table 2
encrypted_keycodes = element of table 2 tha holds the keycodes.
$value = '{seak_keycode___encrypted_keycodes}'; // should this be may second table which i created using fabrik?
$db =JFactory::getDBO(); //Get a db connection.
$query=("SELECT warranty_code FROM empenc_warranty where warranty_code = '$value'"); //should the fields be from table 1
$db->setQuery($query); //Reset the query using our newly populated query object
$response = $db->loadResult();
if ($response == $value) //my condition is that $value == to $query
{
return true;
} else {
return false;
thanks
table 1 = empenc_warranty //form table that will be used by the end user
table 2 = seak_keycode //form table that will have the keycodes
both list and forms are generated via fabrik
warranty_code = element of table 1 (user will encode) that will validate data from table 2
encrypted_keycodes = element of table 2 tha holds the keycodes.
$value = '{seak_keycode___encrypted_keycodes}'; // should this be may second table which i created using fabrik?
$db =JFactory::getDBO(); //Get a db connection.
$query=("SELECT warranty_code FROM empenc_warranty where warranty_code = '$value'"); //should the fields be from table 1
$db->setQuery($query); //Reset the query using our newly populated query object
$response = $db->loadResult();
if ($response == $value) //my condition is that $value == to $query
{
return true;
} else {
return false;
thanks
$option = array(); //prevent problems
$option['driver'] = 'mysql'; // Database driver name
$option['host'] = ''; // Database host name
$option['user'] = ''; // User for database authentication
$option['password'] = ''; // Password for database authentication
$option['database'] = ''; // Database name
$option['prefix'] = ''; // Database prefix (may be empty)
$db = & JDatabase::getInstance( $option );
guys i tried the above. still nothing. when i hit save even do the code is correct the element vaidation error message is still being triggered.
$option['driver'] = 'mysql'; // Database driver name
$option['host'] = ''; // Database host name
$option['user'] = ''; // User for database authentication
$option['password'] = ''; // Password for database authentication
$option['database'] = ''; // Database name
$option['prefix'] = ''; // Database prefix (may be empty)
$db = & JDatabase::getInstance( $option );
guys i tried the above. still nothing. when i hit save even do the code is correct the element vaidation error message is still being triggered.
thanks for the reply, here it is:
table 1 = empenc_warranty //db table that will be used by the end user
table 2 = seak_keycode //db table that will have the keycodesboth list and forms are generated via fabrik
warranty_code = element of table 1 (user will encode) that will validate data from table 2
encrypted_keycodes = element of table 2 tha holds the keycodes.
by the way im no coder so im really just experimenting on the code above. i hope you can explain it so i get educated in the process.
thanks again
table 1 = empenc_warranty //db table that will be used by the end user
table 2 = seak_keycode //db table that will have the keycodesboth list and forms are generated via fabrik
warranty_code = element of table 1 (user will encode) that will validate data from table 2
encrypted_keycodes = element of table 2 tha holds the keycodes.
Code:
$value = '{empenc_warranty___warranty_code}';
$option = array();
$option['driver'] = 'mysql';
$option['host'] = 'localhost';
$option['user'] = 'userco_game';
$option['password'] = '123456';
$option['database'] = 'neco_game';
$option['prefix'] = 'zyz1_';
$db = & JDatabase::getInstance( $option );
$query=("SELECT * FROM seak_keycode where encrypted_keycodes = '$value' ");
$result=mysql_query($query);
if ($result == $query) {
return true;
} else {
return false;
}by the way im no coder so im really just experimenting on the code above. i hope you can explain it so i get educated in the process.
thanks again
rob
Administrator
PHP:
$value = '{empenc_warranty___warranty_code}';
$option = array();
$option['driver'] = 'mysql';
$option['host'] = 'localhost';
$option['user'] = 'userco_game';
$option['password'] = '123456';
$option['database'] = 'neco_game';
$option['prefix'] = 'zyz1_';
$db = JDatabase::getInstance( $option );
// Best to use Joomla's query builder:
$query = $db->getQuery(true);
// Use COUNT(*) to count the # of records matched
$query->select("COUNT(*)")->from('seak_keycode');
// ALWAYS use $db->quote() for user inputted values - otherwise is a major security risk
$query->where('encrypted_keycodes = ' . $db->quote($value));
// Set the query to the db
$db->setQuery($query);
// Run the query and return a single value (the # of records matched)
$matched = $db->loadResult();
if ($matched > 0) {
// We found some records so return true
return true;
} else {
// No records found - return false.
return false;
}hi rob
still nothing, i tried to redo the list and forms but still nothing.
i even replaced $value with just 1 and see if it will validate but it still says validation failed.
please help.
still nothing, i tried to redo the list and forms but still nothing.
Code:
$value = 1;
$option = array();
$option['driver'] = 'mysql';
$option['host'] = 'localhost';i even replaced $value with just 1 and see if it will validate but it still says validation failed.
please help.
hi guys
i found a similar unsolved thread.
http://fabrikar.com/forums/index.ph...t-current-database-records.34382/#post-174213
could i request someone to check it on their installations? something like sampling the conditions and requirements if it will work?
i really need this...Any help is appreciated...
thanks so much...
i found a similar unsolved thread.
http://fabrikar.com/forums/index.ph...t-current-database-records.34382/#post-174213
could i request someone to check it on their installations? something like sampling the conditions and requirements if it will work?
i really need this...Any help is appreciated...
thanks so much...
- Status