Adding More Fields to "Telephone Listing Database" PHP/SqLite Demo.. - Page 2 - Forum - VisualNEO. Cross-platform App Development Tool for Windows

#21 · January 13, 2023, 8:12 pm

@fkapnist it works fine for me. Can you see any error message on the Console?
Regards.

#22 · January 16, 2023, 10:57 pm

Hello Luis...

I have made a sample demo app.. ( usually would have 5 tables in) but then they are hosted on the cloud.. and as this is only SqLite then what I have made will probably around its limit...

I have read all there is on publishing PWA... (not interested in android or ios) or Play Stores ... never use them).. I can't figure it out to get it hosted.. although I have HostPapa for all my Webs and DNS ... so if when you get time glance over it and give me some of your "Much Appreciated" opinion of how it should be done... I know if anyone can then you can!...

Lyn..

Uploaded files:

You need to login to have access to uploads.

#23 · January 17, 2023, 8:11 am

Hi Linda (@linda-rainey)

I have made a sample demo app.. ( usually would have 5 tables in) but then they are hosted on the cloud.. and as this is only SqLite then what I have made will probably around its limit...

A SQLite database can store many many tables and Gigabytes. Anyway you can use MySQL or Microsoft SQL Server too.
More information here: https://www.sqlite.org/whentouse.html

I have read all there is on publishing PWA... (not interested in android or ios) or Play Stores ... never use them).. I can't figure it out to get it hosted.. although I have HostPapa for all my Webs and DNS ... so if when you get time glance over it and give me some of your "Much Appreciated" opinion of how it should be done... I know if anyone can then you can!...

Publishing a PWA is extremely simple in VisualNEO Web. Just be sure to check these points:

Go to Project > Properties > Platform Options > Web and check Progressive Web App
Go to Project > Properties > General and write all the required app information. Also use an icon at least 512x512px
Compile the project
Upload your compiled files to any web hosting with an SSL certificate (https:// protocol)

If you are not uploading your project to your hosting root path (ie: https://domain.com or https://subdomain.domain.com) and you prefer uploading into a subfolder (ie: https://domain.com/subfolder) then be sure to add it in Project > Properties > Platform Options > Web > Scope Directory PWA (ie: /subfolder/)

Thats all!

Linda Rainey has reacted to this post.

#24 · January 17, 2023, 8:59 am

Thank you..

Just to clarify .. I can use my own web host I have been using for 20 years "HostPapa"..

I have a domain named "hobby3000.digital" using "HostPapa" would I just upload my "Zip" file of Detector3000.zip" to it...

include HostPapa "SSL Certificate"... for same...

and the web address would be something like...

http://www.detector3000/hobby3000.digital

Sorry to sound "Dim" over this But all this is done for me...

Lyn...

#25 · January 17, 2023, 10:22 am

@linda-rainey yes, just remember to unzip the file once uploaded.
The web address depends on where you opload the application. If you do it in a subfolder (remember, you need to add it in Project > Properties > Platform Options > Web > Scope Directory PWA (ie: /detector3000/)

https://hobby3000.digital/detector3000

If you can create a subdomain and you upload the content there, then the final URL will be (no need to indicate Scope Directory PWA):

https://detector3000.hobby3000.digital

Note that https is mandatory (it can't be http)
Remember to install LightHouse plugin in your browser so you can check everything is right with your PWA.
Once uploaded let us know the final URL so we can check if everything is right.

Regards.

Linda Rainey has reacted to this post.

#26 · January 17, 2023, 10:41 am

Luis..

Here is what I have done so far...

1).. Gone to my "Hostpapa" domain hobby3000.uk..

2).. Made a new folder and called it "Detector3000Neo" (just to try it out)..

3).. Uploaded "Detector3000.Zip"

4).. Extracted "Zip" in new folder..

5).. Opened "Detector3000-web" folder and went to "Index" and copied address.. as below...

https://hobby3000.uk/Detector3000Neo/detector3000-Web/index.html#!/login

SSL Certificates are automatically made for that domain...

Tried it and on my Desktop computer ... Works Perfectly and all record add.. update.. delete etc.. User is "admin"... Password is "admin"

I have not tried it on a Smart phone yet..

is it working for you...

and maybe you could check it on a phone for me...

Believe it or not.. I don't use any mobile phones only for emergencies... to many scams and flooded with adverts... which is something I never use in any of my 187 apps...

Regards

Lyn...

#27 · January 17, 2023, 11:35 am

@linda-rainey It works fine on my mobile phone but you should use TopCenterApp command on Project > Events, as the app is centered by default and it's cropped in the upper side (at least on my phone). On the other side it's not recognized as a PWA. It lacks a PNG icon of at least 512px.

Linda Rainey has reacted to this post.

#28 · January 17, 2023, 12:34 pm

Luis..

Great thanks for help .. I am changing it now...

Tried it on my phone using address on Google.. but does not work.. (can't find address)

any idea why??

one reason why I don't use phones...

Lyn

#29 · January 17, 2023, 12:40 pm

Tried it on my phone using address on Google.. but does not work.. (can't find address)

@linda-rainey sorry, I don't understand this sentence. Do you mean Google can't find your new site address? If so, it takes time for Google to find and index it. More information here: https://ahrefs.com/blog/submit-website-to-google/

You can test your app by writing directly the app URL within the URL web browser field.

#30 · January 17, 2023, 1:21 pm

Luis .. you are right... although the Detector3000.uk is registered with Google Web Tools this one is not .. so I will add the URL to the main one and add some google verification text into the index page in the new app so to find it easier .. and fill-in some tags...

But!.. All this is to me as only Joined your WebNeo 10 days ago.. and now I have made a Web app that will be on many phones etc.. Worldwide for £1.95 with No Adds or Scams...

And how was this Possible...

Because you were my as it where "Personal ..one-to-one Tutor" and could not have done this in anywhere near the timeframe .. or at all... so give yourself a good Pat on the Back for dealing with it...

Once I have tweaked it I can easily make all my 49 Hobby3000 PWA Adalo and Delphi Rad apps usually 2 per day...

Regards

Lyn..

Darbdenral has reacted to this post.

#31 · January 17, 2023, 1:45 pm

@linda-rainey great to know! I do enjoy helping our users :)
Your success is my success. Please, if you have some time, take a moment to rate our company and VisualNEO Web itself:

SinLios Soluciones Digitales:
https://g.page/r/CR-tuX7ScD0LEBM/review

VisualNEO Web:
https://visualneo.com/product/visualneo-web

Thank you very much in advance!

Luis

Darbdenral has reacted to this post.

#32 · January 17, 2023, 2:16 pm

Luis.. I will Pleased to do so....

Best Regards Always

Lyn...

#33 · January 17, 2023, 4:31 pm

Luis...

Site now working on Google search... But there is a question I have wanted to ask for some time now...

"The Login Page"

if you change default "admin" to a different user and password.. (more secure) as Chrome won't let you use the app properly or won't open database as it should.. in mobile..

Is the config.php form where you do it...

And.. if you only have one set of login details when you distribute the app e.g:- User: LynPod Pass: PODDey 3345 and I sold 5 to different users .. when they log in with User / Password.. User: LynPod Pass: PODDey 3345 given at time of purchase through my downloading service... and they start filling in records... will each of the users only see the records they have entered.. or is it shared with all users... (because they have used the same login details)..

Does my website store there individual SQLite database entries or does their phone do that...

To Summarise ... if I put a more secure User/Pass in config.php and distribute the apps to whoever and how many... will the User/Pass secure one... keep users entries secret to all others who have that same app...

It's got me beat at the moment..

P.S. is there a Mobile size that is compatible with most phones or an adjustment to fit all...

Regards

Lyn..

#34 · January 17, 2023, 8:22 pm

@linda-rainey I think you have developed a single user app.

If you want multiple users to access the same online intallation and keep each user data independent you should create a multiuser app.
That's a bit more complicated because you have to store every user data related to its user id and only retrieve the data related to the currently logged-in user.
VisualNEO Web includes an option to add multiple users in a database using neoPhpUserInsert. You may need to create a register screen, to configure the users database (it can be the same where you store the data if you want) and allow self registration, including the user level access (to manage permissions) in config.php

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

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

A multiple user app is a bit more difficult to code.

This sample app (source code included with VisualNEO Web) shows how to do it using neoCms instead of neoPhp (a completely different approach)
Once registered you can use other apps that use the same users database like this one

Regards.

Linda Rainey has reacted to this post.

#35 · January 17, 2023, 9:05 pm

Luis.. I was thinking the same lines.. as I made this app from your "Telephone Listing" and it is not likely to be a "multi" ..

Yes.. I have seen your Reg Form.. and if this was for any Business I would use it... But!.. we are dealing with the basic "Hobbyist" and they would not want to be registered.. Bearing in mind that even a basic Collector.. or just a "Detectorist" can find a 20 million pound hoard... and not want to disclose it...

I have "Toyed" with the idea of saving the copied database as a simple code name e,g,- "Det1.db" .. and adding it into the -web folder with the mydatabase.db that is already there.. and change the config.php database to "Det1.db to instead of mydatabase.db... then admin password to a new user/pass for each matching database... when the 2nd user logs in using the same web address it will pickup the corresponding database from list in folder... it means storing all sold databases on my server for all my new apps ... could easily end up with hundreds...

your idea is much better so I will tinker around with it to make it not as obvious they are registering ...

Regards

Lyn..

#36 · January 18, 2023, 8:11 am

@linda-rainey I think you can create an independent user management app to insert, modify and delete users. This app would be managed just by you.
All your apps will use that independent database to allow users to sign-in.

Regards.

Luis.

Linda Rainey has reacted to this post.

#37 · January 18, 2023, 8:55 am

Luis that sounds a bit more like it... for me to host my own on "Hobby3000.uk" would cost £380 per month.. (out the question)..

I could go the Android/io way but did that years ago... but not as successful as PWA...

adding users more than databases is the route to go... I will have to look into it and see if anyone has done this on the Forum and can give an example..

if you have made a demo it would be here in you reply... probably not much call for it as it seems most of the Neo clientele just want one for them selves..

Regards

Lyn

#38 · January 22, 2023, 7:43 pm

Hello Luis...

I am using VoltBuider for android etc... and any that you use to make one in your VoltBuilder Link Panel will not work (it is out of date)

they have asked me to tell you to add a bit to it to bring it up to date.. (a simple fix for someone like you)...

Regards

Lyn..

Uploaded files:

You need to login to have access to uploads.

#39 · January 22, 2023, 9:56 pm

Hi @linda-rainey,

Please download this executable and replace the current one in this location (C:\Program Files (x86)\VisualNeoWeb):
https://visualneo.com/filedownloads/beta/VisualNeoWeb.exe

I have updated the config.xml file.
Let me know if it works now.

Thank you!

Linda Rainey has reacted to this post.

#40 · January 22, 2023, 10:46 pm

Luis..

I have replaced the old exe file in Program (C:\Program Files (x86)\VisualNeoWeb): as you asked..

It is much better.. but the compiled zip file for android upload to Volt still fails... (previously there was at least 7 actionable tasks: 7 executed)

FAIL

<pre "="">UserError: FAILURE: Build failed with an exception. * What went wrong: Execution failed for task ':app:processDebugMainManifest'. > Manifest merger failed : uses-sdk:minSdkVersion 14 cannot be smaller than version 21 declared in library [androidx.core:core-splashscreen:1.0.0-rc01] /root/.gradle/caches/transforms-3/7c26442ee087d1f53354e5224cef36f5/transformed/jetified-core-splashscreen-1.0.0-rc01/AndroidManifest.xml as the library might be using APIs not available in 14 See log for full details.