Simple demo app here using Vanilla JS - 8.3.4

1

Hi
I have started working on a simple app.

If there is any interest in it, we can build on this starting point.
The plan is to show how to retrieve data from a database (mySQL), add, edit data, etc.

App here:
https://raindrops.no/fw7test/test_index.html

All files here:
https://raindrops.no/fw7test/

3 Likes
2

Very cool! A few thoughts:

  • Ideally the data would go through a standardized API, your description of the project doesn’t need to mention MySQL. In fact, I’d suggest separating the API from the application altogether, and just go through some standardized API. Instead of https://raindrops.no/fw7test/database/getGamers.php, something like /api/gamers, with pagination and the ability to get details, sort, filter, etc.

This is a very basic one:

https://pokemon.survos.com/api

but there are lots like this, since it’s a built on json-ld and API Platform. Another project where the API endpoints already exist is GitHub - gothinkster/realworld: "The mother of all demo apps" — Exemplary fullstack Medium.com clone powered by React, Angular, Node, Django, and many more.

Since authentication is a pain, how about starting with a “show” page instead of an “edit” page? In particular, I’d like to see this because it gets into navigation – how do you “push” a page on the stack and activate the back link to return?

I’m happy to help with and even provide an API for this project.

Finally, what do you think about moving to github?

Tac

3

Show page (Gamers details) is now implemeted.
Working on “Swipeout”, swipe left to edit and delete records.

Thanks for your ideas, but there are so many solutions out there.
I like to keep it simple. I never use any external solutions. I need to understand and trust all codes. I have many sites running. No one linkes to other domains.
I even have my own authentication solution on all my projects LOL

But feel free to copy. I like to see other solutions :slight_smile:

4

What about using github so I can contribute? I have a lot of PHP experience, but my javascript is pretty basic.

5

Slide left to delete, ready

2025-02-23_225945
2025-02-23_230043

6

I have never had any use for git or github so I’m not familiar with how to use it. But maybe it’s time…
How do we get started?

7

You’ll need to set up an account, and if you want, I can push the existing code to a repo and then transfer it to you.

Like almost everything related to the internet, security makes the first time slow. You’ll need to set up an ssh key and upload it so that you can interact with the repository.

There are lots of tutorials, but for a project like this it should be fairly straightforward.

8

Ok, I made an account. Just push the code to a repo.
My username is: HenningJohnsen

9

Can you make your files available as a zip file?

10

I only have those files on the server.
Zip here:

https://raindrops.no/fw7test/

11

Ok, so I have it on my server now. I don’t have mysql installed. I would suggest using sqlite, so it can simply be included in the repo.

but really it would benefit from being a real API. I know you’re reluctant to have dependencies, how about instead using dummyjson or some other dummy API (which even have valid POST responses)?

The interesting part here is the fw7, there are tons of tools for APIs, but I really want to see what can be done with fw7. Thoughts?

I can move it to github, but really the issue is the API.

12

Sure, no problem. Find a good solution to build on :slight_smile: