Insert Database Not Working

Design for small screen devices but deploy also (without changes) in larger devices like tablets.

DecSoft HTML Compiler include a convenient Command Line Compiler, so you can compile your apps from the console.

DecSoft NeoPlugins put your VisualNeo projects into another level with +1,000 new actions for your apps.

Save time, resources and money creating apps for Android, iOS and more with the same base of code.

DecSoft App Builder include a convenient Command Line Compiler, so you can compile your apps from the console.

Create modern HTML apps and games at another level making things impossible to do even by modern HTML apps and games.

DecSoft HTML Compiler is easy to use: set your project's options and compile your apps and games in a nutshell.

Take a look at our YouTube channel and subscribe to be notified about new videos!

Create multiplatform apps with DecSoft App Builder, including Android and iOS with the same base of code.

Save money by purchasing our NeoPlugins bundles. Five, Ten and even the complete NeoPlugins collection at an incredible price!

DecSoft NeoPlugins are available in both runtime and designtime flavours to keep your apps as small as possible.

DecSoft App Builder integrates an Open AI assistant in order to assist you while developing your apps.

Apache Cordova's official plugins are supported out of the box and there are hundreds of plugins ready to use.

Create apps and expand their capabilities by using the world's popular programming language: Javascript.

Take a look at some frequently asked questions about us and our products!

Compile, convert your modern HTML apps and games into Microsoft Windows executable programs without dependencies.

Danny Cheah

Dear All,

I need help. My php script works on its on but when I run it via AB it does not insert. I've check and could not detect what is wrong. I'm not sure where the error is on my php script.

<?php

// Initialize our environment
require 'Initialize.php';

// By default, return a request error
$result = false;

$Email = \filter_input(INPUT_POST, 'Email', \FILTER_SANITIZE_STRING);
//$Email = 'test@gmail.com';
if ($Email === null || $Email === false) {
\http_response_code(400);
// echo ("Test1");
exit;
}

$Password = \filter_input(INPUT_POST, 'Password', \FILTER_SANITIZE_STRING);
//$Password = 'test';
if ($Password === null || $Password === false) {
\http_response_code(400);
// echo ("Test2");
exit;
}

$dic = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890';
$newToken = \substr(\str_shuffle($dic), 0, 50);

// $Email = substr($Email, 0, 100);
// $Password = substr($Password, 0, 100);

$passwordHash = \hash('sha512', $Password);
$result = Database::insert ('users', array('login' => $Email, 'password' => $passwordHash, 'token' => $newToken));


if (!$result) {
http_response_code(400);
}

Thank you.

Best regards,

Danny Cheah

DecSoft

Hello Danny,

May can be difficult to help in this case, even when we are happy to do it when possible. Taking a look there is no syntax errors in the script, so, they must work, at least in order to see what happen. Since you are using the stuff provided by the Database app sample, look at the "Initialization.php" script, and, change the below lines:

error_reporting(0);
ini_set('display_errors', 0);

... by the below lines:

error_reporting(E_ALL);
ini_set('display_errors', 1);

Doing that we are ready to receive any possible PHP error. But that's what we can do... debug the HTTP call to see what happen, place some "echo" in the script that can help us to see what happen, in few words: debug the script...

Check that the database connection is OK, look for the HTTP call response (is the Error event of the HTTP client fired?). Do it in a brower like Firefox with the Console Developer open: this offer to us lot of information about the HTTP call, what code response we get, what response text, etc.

Please, try the above, and, post here what happen, if you get an specific error message, etc.

Purchase one or more licenses of our products if they are useful to you!

Danny Cheah

Hi David,

I have already make the changes for the following in my Initialize.php

error_reporting(E_ALL);
ini_set('display_errors', 1);

Now to test it, do I run the script from my brower and not from my AB right?

// Initialize our environment
require 'Initialize.php';

// By default, return a request error
$result = false;

$Email = \filter_input(INPUT_POST, 'Email', \FILTER_SANITIZE_STRING);
$Email = 'test@gmail.com';
if ($Email === null || $Email === false) {
\http_response_code(400);
echo ("Email Error");
exit;
}

$Password = \filter_input(INPUT_POST, 'Password', \FILTER_SANITIZE_STRING);
$Password = 'test';
if ($Password === null || $Password === false) {
\http_response_code(400);
// echo ("Password Error");
exit;
}

echo ("Email & Password Correct");

$dic = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890';
$newToken = \substr(\str_shuffle($dic), 0, 50);

// $Email = substr($Email, 0, 100);
// $Password = substr($Password, 0, 100);

$passwordHash = \hash('sha512', $Password);
$result = Database::insert ('users', array('login' => $Email, 'password' => $passwordHash, 'token' => $newToken));

 


//if (!$result) {
// http_response_code(400);
//}

Thank you.

Best regards,

Danny Cheah

Danny Cheah

Hi David,

I ran the script from the browser and it was successful. It managed to insert into the database.

Thank you.

Best regards,

Danny Cheah

DecSoft

Hello Danny,

Please, use the "code" HTML tag when you post code or console outputs, etc. About your last question, in fact it's not important if the script is called outside of AB or not, that is, the script expect certain arguments (comming from the POST input), and therefore they do their work. That is, except if you setup one, talking about this specific script, we no need to call it from AB in order to put it working.

But maybe the above is not what matter here... what matter here is that you can / must debug the script, and to do this you can call to the script using AB or another tool: probably it's better to call it using AB, so you are not only debugging the server script, but also the client side. But it's completely up to you how you debug the script. What I recommend is that you use a browser like Firefox with the Console developer opened, that is, launch the app (from AB) in Firefox or other browser.

Purchase one or more licenses of our products if they are useful to you!

DecSoft

Hello Danny,

Sorry, I see now your latest post. If the script works in an "alone" way, there is no reason to work calling it from AB, if you provide to the script the right arguments, of course. But, if something is wrong, if some argument is missing, then the script must provide the right response, so the client side (the AB app) can know what happen and what to do.

But remember: there is no differences between a call to the script "alone" and a call to the script "from AB"... in both cases we are talking about HTTP calls, that must include the right arguments, etc. If the AB calling to the script don't work... then something is wrong and you must investigate what happen.

Purchase one or more licenses of our products if they are useful to you!

Danny Cheah

Hi David,

I have check the call from AB and my code as per below. I don't see any problem with the code:

// Prepare our insert new Email & Password HTTP post request
HttpClearData "HttpClientSignUp"
HttpSetData "HttpClientSignUp" "Email" "[NewEmail.Value]"
HttpSetData "HttpClientSignUp" "Password" "[NewPassword.Value]"

// Execute the insert new note HTTP post request (see the NewClient events)
HttpExecute "HttpClientSignUp"

Thank you.

Best regards,

Danny Cheah

DecSoft

Hello Danny,

Please, please, use the HTML code tag when post code... in other case I must do it for you! About your question, certainly, the code that you shown appear correct, so, the point is what happen... for that reason I told you to use the Firefox Developer Console... after you made the HTTP call using your AB code, something must happen... the request must end... successfully or not... may you can see some other error, etc.

Purchase one or more licenses of our products if they are useful to you!

Danny Cheah

Hi David,

Sorry I don't quite understand what you mean by use HTML code tag. Can you explain more. Sorry for being a pain as I'm try to learn as much as I can.

Also,

Thank you.

Best regards,

Danny Cheah

DecSoft

Hello Danny,

No problem! (sorry if I appear rude, that's not my intention at all!) When you write your posts here in this forum, you use some "p" HTML tags to define paragraphs. Ok, just in the same way use the "code" HTML tag, and place inside that HTML code tags the code that you wanted. Look here for more information about the "code" tag.

Purchase one or more licenses of our products if they are useful to you!

Danny Cheah

Hi David,

You are not rude. It's me that I am very new that makes it hard for you.

I thought I use the html code to post my question becuase I'm using this link to compose my message https://html-online.com/editor/

I must not have work. I will study the html code then.

Sorry for all the incovenience caused.

By the way, I managed to solve my script problem. I have a spelling mistake under the HTML properties URL.

Thank you.

Best regards,

Danny Cheah

DecSoft

No problem at all! Glad to know that you finally catch the problem :-)

Purchase one or more licenses of our products if they are useful to you!

Everybody can read the DecSoft support forum for learning purposes, however only DecSoft customers can post new threads. Purchase one or more licenses of some DecSoft products in order to give this and other benefits.