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

Setting up Virtual Host in Local machine (Wamp Server)

Hi !!! Today i am going to share how to set up the virtual host in local machine with the Apache Server.  In my tutorial i have used WAMP server. What is Virtual Host? Virtual Host is a method for hosting multiple domain names (with separate handling of each name) on a single server (or pool of servers). This allows one server to share its resources, such as memory and processor cycles, without requiring all services provided to use the same host name. How to setup Virtual Host in Server? 1. Add Host to your Hosts file. For adding you have to locate below file, C:\Windows\System32\drivers\etc\hosts Open "hosts" file in notepad and add below line after 127.0.0.1 Localhost 127.0.0.1       yourwebsite.local Here "yourwebsite.local" will point to your server on local machine. 2. Next step is to enable vhosts in apache. Open your httpd.conf file which is located under, C:\wamp\bin\apache\apache2.2.22\conf  Here, You have to uncomment below...
Read more

Get Android version using Javascript

Hi! Today i am going to share how to get android version using Javascript. Here is the code, <script> function getAndroidVersion(ua) {     var ua = ua || navigator.userAgent;     var match = ua.match(/Android\s([0-9\.]*)/);     return match ? match[1] : false; }; getAndroidVersion(); //"4.2.1" parseInt(getAndroidVersion(),10); //4 parseFloat(getAndroidVersion()); //4.2 </script> Hope you got it. Any queries please leave a comment.
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