Page 1 of 1
Fox pe web
Posted: 09 Dec 2024, 19:59
by ionv
Nu e chiar Fox, e doar SQL;
https://sql-page.com - puteti realiza simplu si rapid aplicatii web-based cu acest framework. Nu e pentru pretentiosi, desi pretentiosii care stiu JS il pot customiza dupa cum isi doresc.
P.S. Nu e reclama, nu am actiuni acolo

. Daca considerati ca nu e locul potrivit aici, mutati topicul.
Re: Fox pe web
Posted: 10 Dec 2024, 11:09
by ionv
Si un mic exemplu - codul de mai jos face un form pentru adaugare inregistrari in baza de date si afiseaza datele intr-un tabel cu functii de cautare si sortare
index.sql
Code: Select all
CREATE TABLE IF NOT EXISTS salariati (
id INTEGER PRIMARY KEY AUTOINCREMENT,
cnp TEXT NOT NULL UNIQUE ,
nume TEXT NOT NULL,
prenume TEXT NOT NULL,
salariu INTEGER);
SELECT 'form' AS component, 'Adauga salariat' AS title;
SELECT 'cnp' AS name,'CNP' as label,TRUE as required,3 as width;
SELECT 'nume' AS name,'Nume' as label,TRUE as required;
SELECT 'prenume' AS name,'Prenume' as label,TRUE as required;
SELECT 'salariu' AS name,'Salariu' as label,TRUE as required,2 as width,'number' as type;
INSERT INTO salariati(cnp,nume,prenume,salariu) SELECT :cnp,:nume,:prenume,:salariu WHERE :cnp IS NOT NULL;
SELECT 'table' AS component,
TRUE as sort,
TRUE as search;
SELECT cnp,nume,prenume,salariu FROM salariati;
Rezultatul in imagine
Re: Fox pe web
Posted: 12 Dec 2024, 13:09
by hd56fox
Este interesant. Multumesc. Chiar mi-ar place sa-l folosesc. Probabil dupa ce ies din SFT-ul asta nebun.