Quote from Linda Rainey on January 22, 2023, 11:34 pm

Luis...

Yes.. Yes.. Yes.. It works... and a log is included...

BUT!.. I can't login using the login I had with Config.php .. how do I make it login..

And don't be sorry for the inconveniences.  .. you are using your time on a day off to help me....

Linda

Quote from Linda Rainey on January 23, 2023, 3:00 pm

Hello Luis...

The android compile and build is working great with no issues at VoltB.. but I can't sign in when downloading the app to try ... it is in a Debug APK I asked George someone like you if they did this at their end (voltB) and this was their reply... so I am at a loss to sort it...

Regards

Linda..

 

Quote from luishp on January 23, 2023, 6:46 pm

@linda-rainey

Linda, if you use Volt Builder, instead of pwabuilder.com, it's important to understand how it works:

Your project is compiled into an Android .apk or .bundle file. It embeds all of your HTML, CSS, JavaScript and image files to be installed into the final user device. BUT it can't embed nor execute server side scripting files like .php files. As you have used neoPhp, you need to execute .php files. That's possible, but you need to do that in your remote server. So, your final user downloads and install the compiled app, but your app connects to your remote server in order to ask for permission to access. You must use the command neoPhpSetPath to configure your app to connect to your remote host whenever a neoPhp execution is required. Of course the database is not in the final user device, but in your web hosting.

If you use pwabuilder.com to generate the .apk or .bundle Android app instead, things are quite different. All the files, including HTML, CSS, JavaScript and image files are hosted in your own server and are downloaded and cached into the user device. In this case you don't need to use neoPhpSetPath as all files have the come from the same location.

Note that PWA's doesn't need to be compiled into Android apps. They are already installable. That's just for convenience in case you whant to publish them into the App Stores.

I know this is confusing at first. This is because there are many options for app deployment.

Let me know if you have any doubts.

Luis

Quote from Linda Rainey on January 23, 2023, 8:40 pm

Luis.. as always well described..

My 1st reason for using VisNeo was for PWA webs run on any phone... which your VisNeo does with ease..

I went down the Android way as a last resort so each apk install has the same database on each user and is kept on their phone...

all fine if you only need an occasional app residing on your own website..

However in my case I make apps to sell.. my "Hobby3000" Range has over 135... made in Adalo (when apps were unlimited)  and the problem with a PWA on your own hosted site is one app "Detector3000" (shall use this one as a demo)... it has one database.. with a login... great for just one user.. or for any users who want to share that database with the same login...

In my case I want the same... but many users to use the one "Detector3000" and its database .. BUT! all users have their own Login.. and database is private to each user (Not Shared) all from the one "Detector3000" PWA...

If that makes sense to you.. your NeoCms seems to be able to do what I think I mean... Like Adalo.. a new user for the one app above has to register before they can use that app even though the app has only 1 database.. but when registered they can enter whatever user name and pass they want... But they are all using the same database which was made with the app... no matter how many users use it...  is that right.. if so.. how do I do it ...

Best Regards

Linda...

 

Quote from luishp on January 23, 2023, 10:44 pm

I went down the Android way as a last resort so each apk install has the same database on each user and is kept on their phone.

@linda-rainey I think you don't need neoPhp nor a shared remote database then!
Please take a look at neoLocalStore to store local data and neoSQL to use SQL querys on JSON data (neoSqlJson command).
This way you can store JSON data on each user device and use it as a real database. It should work as a classic WebApp, PWA, pwabuilder.com compiled PWA or VoltBuilder compiled PWA. Or even as a Desktop app using neoEdge!

Regards.

Luis.

Quote from Linda Rainey on January 24, 2023, 10:04 am

WoW! Luis.. That is a Must to check out.. I am all in favour for any that stores data in whatever they using.. Last thing is on my web hosting.. even with unlimited Bandwidth..

I will check this out this morning...

and let you know...

Super Regards

Linda..

Quote from Linda Rainey on January 24, 2023, 11:08 am

"Strooth" Luis..

That is all above my head... I have looked at all samples .. but the samples expect you to know how to get to the samples...

So!.. Time to call this a day and go back to my Delphi/Rad

as I can't find an actual simple demo from start to finish to play with... that will work on my existing "Detector3000" PWA app

with a few fields in.. like below... I can make... that the user can add.. delete.. update

1)item Name.. = "Ides of March"  ...

2) Item Found ... = "Roman Coin" ...

3) Item Found Where ... = "Hadrians Wall"

Regards

Linda..

 

Quote from Linda Rainey on February 2, 2023, 9:45 pm

Hello Anyone..

Update Pen is not updating record in Database...

It says it is "Updating" and does while in the session going back and next still what was updated is still there..

But shut down and restart it has gone.. in fact it is there for 2 seconds and then goes.. what you updated in the field..

I have checked all now for over 5 days and can't see what is wrong .. the apps I am making and made 12 so far are all ready to go to downloading service etc but this is part of the system an I am "Baffled" if I can spot the problem.. Unfortunately all my apps are above the 5mgs limit so can't .zip an upload for any for anyone to see if it can be sorted..

Clicking the "Pen" icon for Update Record..

.UPDATE users SET A = ?, B = ?, C = ?, D = ?, E = ?, F = ?, G = ?, H = ?, I = ?, J = ?, K = ?, L = ?, M = ?, N = ?, O = ?, P = ?, Q = ?, R = ?, S = ?, T = ?, U = ?, V = ?, W = ?, X = ?, Y = ?, Z = ?, ZA = ?, ZB = ?, ZC = ?, ZD = ?, ZE = ?, ZF = ?, ZNotes = ?, Pic1 = ? WHERE id = ?
neoPhpExecSql "db1" "update" "[id]::[A]::[B]::[C]::[D]::[E]::[F]::[G]::[H]::[I]::[J]::[K]::[L]::[M]::[N]::[O]::[P]::[Q]::[R]::[S]::[T]::[U]::[V]::[W]::[X]::[Y]::[Z]::[ZA]::[ZB]::[ZC]::[ZD]::[ZE]::[ZF]::[ZNotes]::[Pic1]" "updated"..

Regards

Linda...

 

Quote from Linda Rainey on February 3, 2023, 11:34 am

Hello Everyone...

Have now sorted it out... and why it did not work....

Corrected... proper [id] position in script..

The [id] was in the wrong place I had it at the beginning of the script... as you see now it is at the end of the script!

.UPDATE users SET A = ?, B = ?, C = ?, D = ?, E = ?, F = ?, G = ?, H = ?, I = ?, J = ?, K = ?, L = ?, M = ?, N = ?, O = ?, P = ?, Q = ?, R = ?, S = ?, T = ?, U = ?, V = ?, W = ?, X = ?, Y = ?, Z = ?, ZA = ?, ZB = ?, ZC = ?, ZD = ?, ZE = ?, ZF = ?, ZNotes = ?, Pic1 = ? WHERE id = ?
neoPhpExecSql "db1" "update" "[A]::[B]::[C]::[D]::[E]::[F]::[G]::[H]::[I]::[J]::[K]::[L]::[M]::[N]::[O]::[P]::[Q]::[R]::[S]::[T]::[U]::[V]::[W]::[X]::[Y]::[Z]::[ZA]::[ZB]::[ZC]::[ZD]::[ZE]::[ZF]::[ZNotes]::[Pic1]::[id]" "updated"

 

Wrong [id] position in script below..

The [id] was in the wrong place I had it at the beginning of the script... 

.UPDATE users SET A = ?, B = ?, C = ?, D = ?, E = ?, F = ?, G = ?, H = ?, I = ?, J = ?, K = ?, L = ?, M = ?, N = ?, O = ?, P = ?, Q = ?, R = ?, S = ?, T = ?, U = ?, V = ?, W = ?, X = ?, Y = ?, Z = ?, ZA = ?, ZB = ?, ZC = ?, ZD = ?, ZE = ?, ZF = ?, ZNotes = ?, Pic1 = ? WHERE id = ?
neoPhpExecSql "db1" "update" "[id]::[A]::[B]::[C]::[D]::[E]::[F]::[G]::[H]::[I]::[J]::[K]::[L]::[M]::[N]::[O]::[P]::[Q]::[R]::[S]::[T]::[U]::[V]::[W]::[X]::[Y]::[Z]::[ZA]::[ZB]::[ZC]::[ZD]::[ZE]::[ZF]::[ZNotes]::[Pic1]" "updated"..

So it is important to make sure the [id] is always the last entered in script for "Update" when The "Pen" is ticked...

Linda..

Quote from Linda Rainey on February 3, 2023, 12:46 pm

Hello Everyone..

Here is just one of my new PWA's made here in VisualNeo-web..

"Omnibus3000"  it is made entirely with the "Telephone Listings Demo" (php) in samples...

it show how to use a simple demo as Telephone Listing Demo.. to make a delightful pleasing to use for all ages app...  that will be available for all in that hobby later today...

And only for Luis's striving help..  I could not have achieved this.. I have a unique system that I can produce these Hobby3000 apps in 45 mins... so able now to catch up and get them done to replace the 45 Adalo's unreliable apps.. and costing mega money per month to do so...

I always make a "Demo" of all my apps for anyone to try out.. (save giving back any refunds and scammers) and this is one of them...

https://hobby3000.uk/BusDemo/BusPwa/Bus-Web/index.html#!/login

Please try it out.. I hope for any feedback  Good or Bad.. it is a Shared Database so is only good for a Demo... when buyer buys one they will have a new version sent with their own preferred Login Details... from my VCL server...

This stops "Jack the lad" downloading one and not paying for it or to scam to sell on...

Username =  demo

Password =   BusDemo

Regards

Linda...

 

 

Quote from luishp on February 3, 2023, 9:13 pm

Hi Linda @linda-rainey

Congratulations! :)
Just consider using FitAppToScreen command in Project > Events

FitAppToScreen false "top" "center"

This way your app size will fit the device screen size whatever it's.

My best wishes.

 

Quote from Linda Rainey on February 3, 2023, 9:52 pm

Luis..

Can certainly depend on you .. as you are my inspiration on getting my apps transferred to your system...

I love the system.. so easy to make and so Reliable...

So now Bashing" on with my apps..

Thanks Again for all your Help!..

Best Regards

Linda..

Quote from Linda Rainey on February 10, 2023, 10:55 am

Hello Luis...

Is there a way to get the user of a PWA Mobile app (like pics below) to "Self Register" their login details... I have looked but the NeoCMS reg is not suitable because of its size and I can not adapt it for mobile..

Regards

Linda

 

Quote from luishp on February 11, 2023, 8:13 am

@linda-rainey neoPhp allows to insert new users in the database (neoPhpUserInsert) Note that you need to define the users database in config.php file.
The users database can be the same as your app database or a different one, so all your apps can share the same users database.
This is just an example of a config.php file that includes user management:

//--------------Users database-------------------------------------------------------
//Database to store and retrieve application users.
//If it doesn't exist, and it's a SQLite database, it will be created if necessary.

//SQLite sample
$usersDb="users.db";

//Allow self registration as user
$allowSelfRegistration=true;
$selfRegistrationLevel=3;

Note that it's important to set $allowSelfRegistration to true.
The $selfRegistrationLevel allows you to define your own access level for new users.
When a users Logs In, you get all the user information, including the access level, so you can define a level for users registered but they can be blocked or limited until you change their access level.

I hope it's understandable enough :)

Quote from Linda Rainey on February 11, 2023, 10:48 am

Hello Luis..

Yes Thank you for that info...

I can see the purpose of how it works ... in my case I don't want them to share so I have a very powerful VPS X11 Server and as each one sells I can keep them in a separated folder belonging to the one app that has sold.... each app is easy to clone in seconds.. with their login details added..

otherwise my other alternative was to send them the 7 day Demo... and then ask them to send me the login details unique to them when they liked it... and add the login into the clone back to them... which was a rubbish process at best..

with the self reg system I will already know what it is and clone the demo replacement with their info... as I have the PWA app on my system and can check anyone at any time...

I shall start to tinker with it today...

As Always "Prof! you keep looking after me...

Linda..

 

 

Quote from Linda Rainey on February 13, 2023, 6:56 pm

Hello Luis..

Well Now!.. Not just as easy as altering "False to True" for Self Registering... have to mess around with subroutines etc.. I have used the "Table Editor sample" for registering but does not show you how to set it up... you still have to use "admin = "admin" to get in..

No way I can work this out... Did you ever make a demo for Mobile that show how any user can simply login with the "admin" =  user and "admin"=  password to get them into the app.. and then be able to change both "user" and "Password" to what they want for next time they login... none of my apps need to have any "Super" login Security sytems ...

This is the system I use on all my apps .. but it wont work here because it is Php.. and not a separate little database for user as another table.. that resides in the app

Unless there is a way to access the config.php top bit only by some kind of field linked to user credentials..

//User credentials

$adminName="admin";

$adminPass="admin";

and then they can enter what they want...

this is holding me up and until I can get past this where a user simply registers and and enters the app... I am using the "telephone listing demo" from start to finish to make my apps... my 12 apps I have re-made up to now are absolutely perfect except for this problem..

No doubt you will a a "Minefield" of answers which are so simple for you... But for me hard to grasp..

Best Regards

Linda..

 

 

Quote from luishp on February 13, 2023, 8:47 pm

@linda-rainey I need to understand your setup. Are you cloning the whole app for each user?
What you want is your app user to set-up his own user and password the first time he enters the app and then the app gets locked to those credentials?
Is that what you intent to do?
If so, I can create a custom script just for you.

Regards.

Quote from Linda Rainey on February 13, 2023, 9:31 pm

Luis..

In an ideal world .. the one database app whether it is your Telephone demo or any of my Hobby3000 aps... I would like that any user of the app to be able to  register and use the one database because it is set not to be shared...

Now I know that is possible but too complex as it would normally be used for any admin to keep check on their users... Me.. Not interested in any info that a user puts into it etc..

So I have designed my own system which I am trying and does work... there is a flaw to this... is to make a demo of the app.. e:g "Railway3000"

That app is a Demo for me to sell on eBay etc.. so as to try before they buy... with a login of .... Username = demo and Password = RailDemo..

and when any buyers buy one and it can be more than one at a time... each will have a app that shares its database .. which is  "rail.db"

when they are happy with it 7 day trial they will send me their personal login details so as I can copy the "Railway3000" demo and make a new folder for it with their login detail .. and every one I sell will have its own folder with each app in it and the login details of the buyer.. in the config.php

it is very easy to copy and make each app "Railway3000" simply by copying the whole folder it is in.. renaming the web folder to "Rail3000" and in the folder renaming all in it to "Rail-web  .. Rail.db.. Rail-test.. Rail.neoapp".. and it works fine Not Sharing if I get their login details to replace the "demo and RailDemo password... which is in config.php in the Demo to their new login details.. The tricky bit is for them buyers to send me their logins they want to use...

What helps is.. I am known the World Over .. with over a million Likes.. and more than 7 million downloads of what I do besides apps ... 3D model. maker ..

To summarise ..

Yes!... to your answer.. I am cloning each app for the user... to enter his own credentials so only he can use that app... and the database in the app will only be for what he has entered..

If you are able to do this for me I will "TicketyBoo" with enjoyment...

My best as always ..

Linda

 

 

Quote from CDY@44 on February 13, 2023, 11:35 pm

Hello Luis,
I would be interested in this possibility too!

regards,

Denis