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.