Breezing forms - Get datas from database

Copy the below code in your breezing forms by selecting your form,

Go to Advanced -> More options -> Select "Form scripts" -> After Form or Before form its up to your requirement.

// load the standard form creation utilities
$this->execPieceByName('ff_InitLib');

//set globals
global $record;

//query db
 $rows = ff_select("select * from `#__users`");

$html = '';
foreach ($rows as $row) $html .= "<div style='display:block'>
<input type='text' name='$row->user_id' id= '$row->user_id' value='$row->user_id' />
 </div>";
return $html;

It will return all the values from the users table.

Comments

Post a Comment

Popular posts from this blog

Birthdate validation for less than 18 in PHP

Here is the code to validate for birthdate, //Validate for users below 18 only function birthdate($then, $min) {   // $then will first be a string-date   $then = strtotime($then);   //The age to be less than 18   $min = strtotime('+18 years', $then);    if(time() < $min)   {      return false;   }   else {      return true;   } }
Read more

Memcache Installation in PHP (Wamp Server)

what is Memcache? Memcache is a caching system used to speed up web applications by holding small pieces of arbitrary data, it could be broadly compared to the $_SESSION variable in PHP, but memcache works across the whole application not just on a per user basis and has been successfully proven to make great gains in speed increases on web applications. Memcache was designed with Linux in mind and not windows, so it has posed some installation issues because Windows users are not so familiar with having to compile code from source as memcache does not come with any installation software. Installation: - Download this package, here - Unzip Memcached application in C:/memcached folder - Open command prompt, Type below command to install C:\memcached>memcached.exe -d install  - Now its time to start the Memcache server  C:\memcached>memcached.exe -d start (or)  C:\memcached>net start memcached The memcached service was started successfully. Hope ...
Read more

Array to JSON

To display array values in JSON format, you need to use json_encode(). For eg: $arr = array('username' => 'test','userid' =>'1', 'password' => 'test123'); // Use json_encode to return in json format echo json_encode($arr); Output: {"username":"sham dhar","userid":"36","password":"test123"}
Read more