Code

Discussion on Formdoid - Advance PHP Database Form Builder

Discussion on Formdoid - Advance PHP Database Form Builder

Cart 125 sales

ddeveloper supports this item

Supported

61 comments found.

I like this component, but there is one thing I can’t figure out. Is it possible to send an e-mail after submitting a form and also store de data in the database?

Hi,

Right now, it allows either to send email or save it in the database. A little customization can be done to do that. Please note that Email part is still not mentioned in the feature of this component as it is still in beta testing. Thanks

Hi,

i planning to build a webapplication using php and mysql, whether this will for me in doing the application ???

Regards,

Hi. I like your module but have a query. I am creating a application which means I need to create 10-20 forms. A large number of these forms are going to pull values from other tables as options. I am trying to avoid a table for each configuration item, I would like to have a single table so to complete queries against the fieldDataBinding function so i can look for a certain subset inside there for the dropdown, is that possible? Thanks

Hi,

Field data binding binds a field to any table field or we can pass data as array. so if you want to bind multiple field to same table fields then it is also possible. You have write mapping for each field.

Thanks

Hello, Your demos are returning 500 Internal Server Errors.

Hi, I have just checked. It is showing properly. Might be temporary server error. Please check Thanks

Hi,

urls of demo changed already.

Please check below url

http://demo.digitaldreamstech.com/formdoid/documentation/formdoid/index.php

Thanks

Hi, here is the code of the callback function i’m using (posted on formdoid php function file), but i need to only update “latitud” and “longitud” field when “dir_google” field is modified. The functions works, but not only when “dir_google” is modified, works always. This function is executed on “before_update”

function f_bu_coordenadas_mapa($data, $this) { include_once(FormdoidABSPATH .”../../geocoder/vendor/autoload.php”); $adapter = new \Ivory\HttpAdapter\CurlHttpAdapter(); $geocoder = new \Geocoder\Provider\GoogleMaps($adapter);

if ($data"data"!=$this){    
    try {
     $direccion = $data"data";
     $direcciones = $geocoder->limit(1)->geocode($direccion);
     $data"data"=$direcciones->first()->getLongitude();
     $data"data"=$direcciones->first()->getLatitude();

} catch (NoResultException $e) { echo “No result was returned by the geocoder”; } catch (QuotaExceededException $e) { echo “We met our daily quota”; } catch (Exception $e) { echo “Error: ” . $e->getMessage(); } } return $data; }

I am not able to understand the code, might be it’s not formatted here properly. Can you please send it on my email. Thanks.

Hi, i need to appy a function to convert address to longitude,latitude (i’ve done the functions) only when a field is modified and not always as happens with “addcallbacks” functions, how can this be done? Thanks

Hi, you need to do this using callback function. First you need to check the old value and compare with new values to know whether changed or not.

i’ve tried to do this, but don’t work. I’ve compared the $datadata with $this variable on callback function, but don’t work, how can i make the compare?

Here, you need to get the old value first. Send me code via my profile, I will try to write that for you. Thanks

Is it possible that the field DataBinding method accepts a stored procedure? I have too many Fields that are binding form only one table (Category, OptionValue, OptionText, Order). So, i pass the “Category” parameter to fill it.

Databinding has some complex logic and I am getting that data using direct query so I don’t think it will be possible for this part. I will check once though. Thanks

Please write a sample for fill hidden fields.

Hello,

One quick question before buying: can I use a sqlite3 db?

Thanks!

Hi, yes, it works with sqlite3. Thanks

I need your help. I am creating a clubmembers form. I started off by creating a simple table members with just 2 text fields FirstName and LastName so as to get the hang of it. The script folder is store in a folder http://clubmembers.vanhosting.cloud. I put in the full db credentials in the config.php (hostname, db name, u/n, p/w and url as http://clubmembers.vanhosting.cloud/script. I created a members.php file with just 3 lines as follows:

<?php require_once ’../script/formdoid.php’; ?> $formdoid = new Formdoid(); echo $formdoid->dbTable(“Members”)->render();

I tried to run the script by executing: http://clubmembers.vanhosting.cloud/members.php

However, I just got this message: The clubmembers.vanhosting.cloud page isn’t working clubmembers.vanhosting.cloud is currently unable to handle this request. HTTP ERROR 500

In the same folder I have your form sign-up-form.php. However, how do I get it to run. Your documentation does seem to be clear an simple. Can you please help me on where I have gone wrong?

Thank you, it is now working. I uploaded the tables of your demo formdoid.sql into the same db successfully. I also uploaded your demo forms and the assets that came with the demo forms. How can I get your demo forms to work using the config.php?

I now understand the sample forms and they are working. Please ignore my last post. I will work with that I have and if needed get back to you.

Ok..great. I am here and always happy to help. Let me know. Thanks :)

PRE-SALE QUESTIONS: I am using WordPress and I need to put my form on a particular page. (1) Would your code enable me to do that and how easy would it be? (2) I have a mySQL db that has 25 fields. After I generate the form from your plugin, would I be able to customize the code to suit fields which are text, radio, check boxes and so on? (3) Would I be able to see and edit the full code to be customized?

1. Yes

2. Yes

3. Yes

Great. I will make the purchase now.

could I create a contact forms with email forwarding to user-email and to db-admin-email, and how ?

Hi, it is added in version 1.2 that will be released this weekend. You can wait till that time. Thanks

Thanks & Good Luck!

Hi, i have a problem using:
$formdoid->addCallback("before_update", "f_bu_coordenadas_mapa")
I get this error: SyntaxError: JSON.parse: unexpected character at line 1 column 1 of the JSON data var response = JSON.parse(responseText); on line 141 on comman.js file This is the function used on formdoid.php file:
function f_bu_coordenadas_mapa($data, $this) {

        include_once("lib/geocoder/vendor/autoload.php");
        $adapter     = new \Ivory\HttpAdapter\CurlHttpAdapter();
        $geocoder = new \Geocoder\Provider\GoogleMaps($adapter);

        $direccion = $data["data"]["direccion"];
        $direcciones = $geocoder
            ->limit(1)
            ->geocode($direccion);
            ;

        $data["data"]["coordenadas"]=$direcciones->first()->getLongitude();

    return $data;
}

The “geocoder” (geocoder-php lib) code works fine outside formdoid function

Hi, Please check code without callback, if it’s work then issue in the callback. Check the response coming from ajax using firefox console to know the error. This way, you can find error and fix it as this callback function codes are not part of script so you know better. Still in case of issue, you can contact me via profile, I will help.

Hi, is it possible to have Tabs for diferent groups of fields? This way we can have more fields in the same screen (on different tabs), and make them “clean” interface.

Hi, i have an small problem using your script. When i use the “edit/update” function to edit data stored in table and click on “save” button a green badge telling me the data have been saved is displayed, but the text on screen don’t refresh and still shows the same “old” text, and i have to click on reload button from browser to see the modified data How can i make to see the new data on screen when click on save button?

Thanks

do you have planned a release date for new version with “refresh” function? Or can you help me to add it into current version? Thanks

This is not feature of script as both of these things are independent. You can add code to trigger and reload the table data. I can help you to write that code but this is a different feature. Please contact via my profile. Thanks

Hi, i’ve added location.reload(true); in the function showResponse(responseText, statusText, xhr, jQueryform) function and now the data is refreshed when i click on “save” button, maybe there is a better way, but is working at least :)

Good Day, can this be used with a wysiwyg text field? I did not see any mention of it.

Hi, Yes, it works with wysiwyg also. I will upload an example with ckeditor.

Perfect, I am omw to purchase

sorry duplicated comment

hello

i want to save the checkbox selected items in this way [“a”,”b”,”c”] can you tell me how ?

because the normal save it in this way a,b,c

thanks

There may be problem in the function you have written. It is doing callback properly for another field as you have tested. Please check the function you are using. Thanks

i used your func :

function beforeInsertData($data, $this) { $cbData = $data“data”; $splitted = explode(”,”, $cbData ); $data“data” = json_encode($splitted); return $data; }

i just changed “Gen”

I have given example of how to write callback function. You can use print/echo to check what value coming and then you can modify accordingly. If you are not able to write that call back function then contact me via my profile.

could I create a survey forms, and how ?

Hi, Yes, you can create basic survey forms. You can create fields for each question and answer in database. Now in form, change the type to radio/checkbox and using fieldDatabinding, you can add appropriate values. Thanks

but I meant crate survey form not by cod, I meant, drag & drop

This is not drag and drop form builder script. It requires just 2-3 lines of code to generate form.

This looks very useful especially to combine with codecanyon xcrud.

Before I purchase, some questions:

(1) I think this was asked above but which function is used to pass php variables into the form e.g. to insert $client_id or $user_id into table as part of insert?

(2) Is it easy to trigger an email alert with custom message to some email address in order to alert someone that insert/update/delete has taken place?

(3) For file/image upload – can you specify the directory to save file to and limitations on upload e.g. file size or file type?

(4) Can you specify the page redirect to send the user to another page after form insert/update delete?

(5) Can the page redirect include parameters e.g. myprofile.php?id=$user_id?

(5) Can you specify a popup message to display on success/fail of form insert/update/delete before redirect?

I am glad you liked it.

(1) I think this was asked above but which function is used to pass php variables into the form e.g. to insert $client_id or $user_id into table as part of insert? - It is done using call back function addCallback

(2) Is it easy to trigger an email alert with custom message to some email address in order to alert someone that insert/update/delete has taken place? - In version 1.2, you will have complete email functionality. For now, you can add it using callback functions

(3) For file/image upload – can you specify the directory to save file to and limitations on upload e.g. file size or file type? - Yes, it’s in config.php, you can define upload and download folder path

(4) Can you specify the page redirect to send the user to another page after form insert/update delete? (5) Can the page redirect include parameters e.g. myprofile.php?id=$user_id? - In response, 3 parameters are coming (message, error and data). You can modify response data parameter using the callback functions and use this to redirect.

(6) Can you specify a popup message to display on success/fail of form insert/update/delete before redirect? - you can add javascript callback function to show message on popup.

Thanks.

Awesome concept !!!! Generating forms directly from DB ….

Good luck with sales :)

Thanks a lot :)

by
by
by
by
by
by

Tell us what you think!

We'd like to ask you a few questions to help improve CodeCanyon.

Sure, take me to the survey