Rapidshare dadabik

The field customers. It's worth mentioning that you are not limited to one linked field, you can add as many linked fields as you want. For additional options related to lookup fields, including cascade fields , filtered lookup and the possibility to add a new item to a list on the fly, please refer to the in-line helps available for each parameter in forms configurator.

Hiding a field from a form or from the results grid is very simple: let's say you have a field salary in a table employees and you want to show the field only to some of your users, the users belonging to the group human resources. If granular permissions are disabled, you can choose to hide a field directly from the forms configurator, in this case you set the presence of a field globally, for all the users. From config.

Please note that DaDaBIK automatically assigns a unique file name to the file the user uploads, that can be different to the original one.

You should also consider that some particular characters that have a special meaning in a file name can make PHP misinterprets the file name, e. You should protect the upload directory from public access, read the security chapter of this documentation file for further information.

Product Quantity Price. USB Key 2 Sometimes you want to show to your users a pre-filtered version of your data. If the table products is installed in DaDaBIK, it can be accessed from a menu item products and users can also execute search operations over it, for example, through the search form, they can ask to see only the products having a quantity value less than If you realize that such query is quite common, you might want to offer to your users a direct access to the products having a quantity value less than 10, without forcing them to perform a search operation every time.

A creative use of database views can help you in the process of creating very complex DaDaBIK applications. You can create a simple report in a couple of clicks by selecting the field you want to put on your X-axis and the field you want to put on your Y-axis. Normally you want to aggregate data according to a field, show each group of data on your X-axis and and show some information related to each group on your Y-axis.

For example you might want to see the age composition of your customers: in this case you would choose to aggregate data by age and to show, for each group, the number of customers having that age selecting the count option. A slightly more complicated example: you have a table sales containing, among the other information, the date of the order and the amount.

You want to see your revenues, month by month. If you need more freedom, you can use the advanced SQL reports: you can specify your own SQL query, include a where clause, joining several tables and so on.

The only constraints you have is: the query must be a SELECT statement where the first element you select will be used for the X-axis of the graph, the second element for the Y-axis. Please note that, if the report has been generated after a search, the search filter is not saved together with the link. If you need to store a report based on a stable search filter, the best way is to create a VIEW and generate the report starting from that view.

If you are in a details page, DaDaBIK will create a PDF document containing the information related to the record you are viewing; if you are in the results grid, DaDaBIK will create a PDF document containing the information related to all the records included in the current results set. If you launch the PDF generation without selecting a template or selecting "No PDF template" from the template dropdown menu, DaDaBIK will apply a standard template: for each record, a row containing the field label in bold and the field value will be displayed for each field you have in your details page or results grid.

You can, however, create your own template, choosing the position of the fields, adding graphic elements, text or any other content you might want to add to your PDF. If you want to create a custom template , you have to create a file having extension. For example, let's say we have an IT Help Requests application where users can add their help requests and we want to provide a printed version of each request, which includes our logo, some of the fields displayed in a tabular fashion and a signature request for the manager: here is a very simple template that could satisfy our needs:.

A template can be much more sophisticated and it can include internal CSS as well. If one of the fields you use in your template has content type: HTML or field type: rich editor, you can experience unpredictable results in the PDF produced.

The export to PDF feature applied to a record results set, in combination with the use of custom templates, guarantees results similar to the ones you can get using a typical "Mail Merge" feature available in Word Processors. Let's say for example that you want to send a paper mail to all your customers who live in a particular city: you can do it by searching the customers by city and export as PDF the results set, using a template that contains the letter and a name placeholder that will be automatically filled with the name of each of the customer.

Adding PHP code to your templates opens to many new possibilities, for example part of your template can change according to some conditions e. Here is an example of template with some PHP code. The first piece of code just adds the current date to the PDF, the second one adds a whole part of the template ONLY if the current logged user is part of the group having ID 2.

If you need PHP templates, remember to save your template file with a. If DaDaBIK finds in the templates folder two templates having the same name and different extensions one with. As we mention earlier, for each custom template you have to create a TemplateName. In the following example the function adds a custom logo in the top left corner coordinates 10,10 , after the execution of AddPage :.

In the following example the class overrides the Footer method, displaying - for the footer of every PDF page produced - a custom text in a 40x10 cell:. Finally you can set here the config. If you don't specify a name, the default one the name of the corresponding table will be used. You might need to produce a PDF representing some tabular data, for example a list of products, where each product is represented as a row of the table.

If you try to create a custom HTML template for this, you will fail: you can create the products. In these cases, when you need a template for each record and two additional templates that work as header and footer, you need to create three HTML templates; if you have a products.

What if you need this behaviour only for some templates? In case you experience problems with some UTF-8 characters which are not displayed correctly in PDF, you can fix the problems by using a font that is able to display all the UTF-8 characters the core TCPDF font used by default is not , for example freesans.

Sometimes you want to build two or more different DaDaBIK applications which work on the same data i.

For example, if we have two applications sharing the same database, here is an example of config. Authentication is enabled by default, which means that, in order to use an application created with DaDaBIK, you have to login.

Optionally, you can authenticate your users against an LDAP server. For each table each form and field , through the permissions manager, you can set which operations Read, Create, Edit, Delete and Details are allowed. If you disable the read permission for a table, the related item won't be displayed in the menu of the application. For example you can configure your application to allow the group "Managers" to read and modify all the forms while the group "Employees" to read all the forms and modify just some of them, or just some fields of them.

As we said for the basic permissions, if you disable the read permission for a table, the related item won't be displayed in the menu of the application.

If you set your own users and groups tables and tell DaDaBIK the names of the fields to use for authentication username, password, An owner permissions model is also available, it allows to set-up the application in a way such as users can:. Almost all the features we have seen so far don't require any coding no-code , and in fact you can build an entire Web application without any coding.

That's what we call low-code: you don't have to code your application from scratch, you can build most of the application without coding, using the form configurator, the permissions manager and the other tools provided by DaDaBIK and then you add your code to implement some peculiar aspect of your application.

In DaDaBIK you can inject your code in several different ways, for example through custom pages, custom buttons, hooks, calculated fields, custom validation functions and others. In the following chapters we'll cover each of them. Here, we'll see just some general guidelines you should use when you add custom PHP code. If you are new to DaDaBIK, it's probably better to read the next chapters first calculated fields, custom validation functions, Feel free to use the style you prefer, you should think about DaDaBIK as a framework that provides you, as a black box, some pre-built typical components; you build on the top of those components.

An important note related to spaces and tabs, though: when you define a custom function, don't add spaces or tabs in front of the definition:. Don't use unescape on values that have not been escaped. In your queries, each field and table name must be surrounded by quotes e.

This prevents conflicts and data loss. However, if, with your custom queries, you modify a record, there isn't any check related to locking, consider that when you create your custom code. We will provide in the future other tools that you can use in your custom code to check the lock status of a record and to check if someone changed a record since the last time the current user saw it.

For security reasons, it's important that you write there only function definitions. If you write additional code, external to your functions, such code could be executed by an attacker by directing calling the files. A calculated field is a form field whose value is not directly entered by the user but is calculated according to a function.

As you can see, we have checked if the input values are NULL or empty '' before performing the addition. For example, if a field is set as email , DaDaBIK will throw an error if a user tries to insert a non-valid email. However, you can write your own validation function and tell DaDaBIK, in form configurator, to use it for a specific field. DaDaBIK is such an excellent tool and it helped me to quickly design and convert our existing products without the pain of coding from ASP.

DaDaBik is an awesome powerful tool for front-end development. Your team fast-tracked my application development by months. Tom P. I take this message to congratulate for the fantatic responsive user interface which makes Lerici a fantastic product. Paolo Illing, Canada. So far, the most comprehensive, fast and easy to use solution for presenting your data online. No special knowledge needed, no coding.

Fast and friendly support. A verified customer's review on Hotscripts. An excellent solution for publishing data from a mySQL database. No coding required. Great forum and support even for a minor error caused by an old php-version on my webserver, they found a workaround very fast. I can't thank you enough to have put in so much hard work for this type of software.

It has really helped me out! James, Canada. Firstly, thanks for a great product! This is exactly what I was looking for. I set up the database for a political organization so that they would not have to use dozens of spreadsheets to keep track of the tens of thousands of contacts they have. They really like the search functionality, and the ability to export as a. CSV file. This helps them because they have only a few internet connected computers for 20 volunteers.

Nickolai, United States. Great stuff! Really makes rapid deployment a reality. Bill, Canada. Max number of applications Buying one license, you can create maximum 5, 10 or 30 active DaDaBIK applications, even for different customers. You can, however, generate as many test applications as you want. Any server that supports the minimum requirements see documentation is fine: from the cheap, shared, hosting solution to the most powerful dedicated server, or even your own laptop.

The applications you build with DaDaBIK are Web applications so you can use them from anywhere, with any modern Web browser, even on a mobile device. Users authenticated through Wordpress can also be automatically authenticated into DaDaBIK too, without doing the log-in again. You can use it as is or as a base to develop your own applications. Currently is only available for MySQL.

You can map file column names with DB field names, specify transformation rules and more. You can specify the fields that DaDaBIK uses to identify each row: if during the import DaDaBIK finds an already existing record, the existing record will be updated, otherwise the row will be inserted as a new record.

All three employ salting, stretching, and variable iteration counts. Granular permissions manager For each group you can choose a differnet permissions policy, both at table and field level.

For example you can decide that the group "Agents" can view the table "Customers" but can't delete or edit its records; futhermore, you can decide that the group "Agents" can see all the fields of the table while the group "Marketing" just a few. Permission copy Copy permissions from one users group to another in one click. The similarity threshold can be set according to your needs e.