biscofil / bicami_db Goto Github PK
View Code? Open in Web Editor NEWProgetto Basi di Dati
License: MIT License
Progetto Basi di Dati
License: MIT License
A PHP Error was encountered
Severity: Notice
Message: Undefined offset: 1
Filename: controllers/Voli.php
Line Number: 42
Backtrace:
File: /wwwstud/fbisconc/progettodb/application/controllers/Voli.php
Line: 42
Function: _error_handler
File: /wwwstud/fbisconc/progettodb/index.php
Line: 274
Function: require_once
[{"codice":"PLA2","cod_compagnia":1,"aeroporto_partenza":"TRE","durata_volo":3520,"prezzo_business":"400","prezzo_economy":"234","tipo_aeroplano":1,"aeroporto_arrivo":"MAR"}]
{"sEcho":9,"iTotalRecords":66,"iTotalDisplayRecords":66,"aaData":[[2,"PLA1","2016-12-26 00:00:00",3,1003,0,"0","0"],[3,"PLA1","2016-11-23 00:00:00",1,50,1,"0","0"],[4,"PLA2","2016-11-16 00:00:00",1,2000,0,"0","0"],[5,"PLA2","2016-11-30 00:00:00",1,2,0,"0","0"],[6,"PLA2","2016-11-30 00:00:00",1,0,0,"16","8"],[7,"PLA1","2016-11-25 00:00:00",2,20,0,"4","0"],[8,"PLA2","2016-11-15 00:00:00",5,0,0,"0","0"],[10,"PLA2","2016-11-30 00:00:00",3,5,0,"2","0"],[11,"PLA2","2016-10-31 18:00:00",2,0,0,"5","0"],[18,"PLA2","2016-11-08 12:42:00",7,18,0,"0","0"]]}
{"result":0,"error":" duplicate key value violates unique constraint "pk_codice_volo"\nDETAIL: Key (codice)=(PLA2) already exists.\n","data":"SQLSTATE[23505]: Unique violation: 7 ERROR: duplicate key value violates unique constraint "pk_codice_volo"\nDETAIL: Key (codice)=(PLA2) already exists.\nCONTEXT: SQL statement "UPDATE voli\r\n SET codice = upper(modifica_volo.codice),\r\n cod_compagnia = modifica_volo.cod_compagnia,\r\n aeroporto_partenza = modifica_volo.aeroporto_partenza,\r\n aeroporto_arrivo = modifica_volo.aeroporto_arrivo,\r\n durata_volo = modifica_volo.durata_volo,\r\n prezzo_economy = modifica_volo.prezzo_economy,\r\n\tprezzo_business = modifica_volo.prezzo_business,\r\n tipo_aeroplano = modifica_volo.tipo_aeroplano\r\n \r\n WHERE voli.codice = upper(modifica_volo.old_codice)"\nPL/pgSQL function modifica_volo(text,text,integer,character varying,character varying,integer,real,real,integer) line 4 at SQL statement"}
{"result":0,"error":false,"data":"SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "Lamia""}
ma non riesco a reistrare un nuovo utenete con i dati:
Nome uno
Cognome due
Indirizzo tre
Telefono 4444444444444444
Carta di credito 555555555555555555
Username sei
Password: password
Ripeti password: password
An uncaught Exception was encountered
Type: PDOException
Message: SQLSTATE[22001]: String data, right truncated: 7 ERROR: value too long for type character varying(15) CONTEXT: SQL statement "INSERT INTO utenti(nome,cognome,indirizzo,telefono,carta_credito,username,passwd,user_level) VALUES (nuovo_utente.nome,nuovo_utente.cognome,nuovo_utente.indirizzo,nuovo_utente.telefono,nuovo_utente.carta_credito, LOWER(nuovo_utente.username),nuovo_utente.passwd,nuovo_utente.user_level)" PL/pgSQL function nuovo_utente(character varying,character varying,character varying,character varying,character varying,character varying,character varying,integer) line 5 at SQL statement
Filename: /wwwstud/fbisconc/progettodb/application/libraries/Mypghelper.php
Line Number: 413
Backtrace:
File: /wwwstud/fbisconc/progettodb/application/libraries/Mypghelper.php
Line: 413
Function: execute
File: /wwwstud/fbisconc/progettodb/application/controllers/Login.php
Line: 58
Function: registraUtente
File: /wwwstud/fbisconc/progettodb/index.php
Line: 274
Function: require_onc
ma funiona con numero di telefono normale quindi è perfetto
italian.json:
{
"sEmptyTable": "Nessun dato presente nella tabella",
"sInfo": "Vista da START a END di TOTAL elementi",
"sInfoEmpty": "Vista da 0 a 0 di 0 elementi",
"sInfoFiltered": "(filtrati da MAX elementi totali)",
"sInfoPostFix": "",
"sInfoThousands": ".",
"sLengthMenu": "Visualizza MENU elementi",
"sLoadingRecords": "Caricamento...",
"sProcessing": "Elaborazione...",
"sSearch": "Cerca:",
"sZeroRecords": "La ricerca non ha portato alcun risultato.",
"oPaginate": {
"sFirst": "Inizio",
"sPrevious": "Precedente",
"sNext": "Successivo",
"sLast": "Fine"
},
"oAria": {
"sSortAscending": ": attiva per ordinare la colonna in ordine crescente",
"sSortDescending": ": attiva per ordinare la colonna in ordine decrescente"
}
}
..
{"sEcho":1,"iTotalRecords":8,"iTotalDisplayRecords":8,"aaData":[["PLA1","Easy Jet","MAR","TRE",120,"Charter"],["PLA10","Easy Jet","UOI","UOI",3003,"747"],["PLA11","Alitalia","VCE","TRE",200,"Airbus"],["PLA13","Alitalia","PSA","UOI",50,"747"],["PLA2","Alitalia","TRE","MAR",3520,"Charter"],["PLA4","Alitalia","MAR","VEN",101,"Airbus"],["PLA7","Alitalia","VEN","MAR",10,"Charter"],["PLA9","Alitalia","ABC","TES",3,"Cesna"]]}
{"result":0,"error":" function nuova_prenotazione(timestamp without time zone, unknown, unknown, unknown, unknown) does not exist\nLINE 1: SELECT * FROM nuova_prenotazione(localtimestamp,$1,$2,$3,$4)\n ^\nHINT: No function matches the given name and argument typ","data":"SQLSTATE[42883]: Undefined function: 7 ERROR: function nuova_prenotazione(timestamp without time zone, unknown, unknown, unknown, unknown) does not exist\nLINE 1: SELECT * FROM nuova_prenotazione(localtimestamp,$1,$2,$3,$4)\n ^\nHINT: No function matches the given name and argument types. You might nee
d to add explicit type casts."}
A PHP Error was encountered
Severity: Notice
Message: Undefined offset: 1
Filename: controllers/Voli.php
Line Number: 42
Backtrace:
File: /wwwstud/fbisconc/progettodb/application/controllers/Voli.php
Line: 42
Function: _error_handler
File: /wwwstud/fbisconc/progettodb/index.php
Line: 274
Function: require_once
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.