Hi All I have DFV2 connected to an external MySQL as a service so I can do a lot with API calls. But I want to add the user account both internally (so as to get the security features of DF) and externally so I can add more fields such as profile and chat logs. The solution I believe is a post POS…

Hi @charliefinale , if I understand what you’re saying, you will need a Custom Script that receives the POST of your PHP code. The routine is: PHP -> Script DF -> Save to DF Users -> Save to MySql Users So, what you could do is: Make your PHP code call the DF user/register with the user data to …

Also I must to say that in the requisition: platform.api.post('my-db-service/users?fields=id,name,email,login', user_data); the “fields”, in get params, is the fields that will return after the requisition is done.

Sorry for the slowness in thanking you, this is extremely helpful and I will be working on this today.

OK This is what I have tried var user_data = { “Login”: params.login, “MobHeroID” , params.id , “Email”: params.email, “LastName”: params.name , Password: { expression: ‘MD5("’ + params.password + ‘")’ }, RegDate: { expression: ‘NOW()’ }, UpdateDate: { expression: ‘NOW()’ } }; var new_…

Hi @charliefinale , [image] charliefinale: To my surprise I got a 200 OK Success but no record was added to the external DB. umm, this “MobileHeroDB” service, have SCRIPT permission access Role? [image] charliefinale: Also I am foggy on the MD5 part. Do I need to hold the password twice?…

To answer you first question, probably not because I do not know how to do this. Could you show me how? To answer you second, it appears you are creating a password to be held in the remote database. Since the remote database can be accessed using the internal password, is it necessary? i cannot s…

Can anyone out there give me just one simple example of a script written in PHP that can post to an external MySQL database (registered with DF). Any help would be much appreciated. Kimpatro was kind enough to get me started in jsv8, but the code did not work so I am a bit stuck. There are no PHP ex…

Oh man, really sorry not replying, I was on vacation. Hope you had resolved that issue.

Thanks for your consideration…I mainly solved the problem and will post back my solution for other users in a short while.But it was based on your help so thanks.

PHP scripting to POST to external MySQL for new registrations

Server-Side Scripting

formerstaff January 4, 2016, 1:22pm 9

Here is all the PHP scripting info currently available: https://community.dreamfactory.com/t/best-way-to-familiarize-with-df/1858/2

Topic		Replies	Views
Why does this really simple script fail to add a MySQL record? Server-Side Scripting	3	1864	April 24, 2016
Add record using mysql service with php Server-Side Scripting	1	1860	March 14, 2016
Copy user data upon registering Server-Side Scripting	9	2568	March 30, 2017
Post to DF mongoDB from custom v8js script Server-Side Scripting	0	1328	March 31, 2016
DF 2.4.1 Add extra information upon open registration Server-Side Scripting	8	4112	February 22, 2017

PHP scripting to POST to external MySQL for new registrations

Related topics