Search found 26 matches

by landrea
2019-04-05 14:09
Forum: Getting Started
Topic: sql export help
Replies: 4
Views: 254

Re: sql export help

If the data on localhost is fake/test data, you don't need to dump it to SQL and move to the server. When AppGini setup script is run on the server, it will create the database there with no need for an SQL file. I need another help, I make an error in two fields, one is integer instead need to be ...
by landrea
2019-04-05 13:56
Forum: Getting Started
Topic: sql export help
Replies: 4
Views: 254

Re: sql export help

thanks for the asnwer, I had two projects on local host, one with real datas and one with fakes, I tested exportation with fakes datas, I needed real datas because project is quite complicate Now I moved sql exportation and everything went well, I didn't get errors I made these steps 1) move everyth...
by landrea
2019-03-26 16:09
Forum: Getting Started
Topic: sql export help
Replies: 4
Views: 254

sql export help

I need to move all the data in a server (I'm in localhost) there are options to select looking the sql of the northwind example I think I need to leave everything by default and check only "add istruction DROP TABLE /veiw / procedure / function ... etc.. " and "add IF NOT EXISTS" or I have to leave ...
by landrea
2019-03-24 22:12
Forum: Getting Started
Topic: get right options with hooks
Replies: 2
Views: 193

Re: get right options with hooks

I moved on, I wrote simple a note to compile the field only if otpion is "printer", I wanted to put a validation or hide the filed, etc.. this is simpler with list, because with list you have input hidden field with the value inside the problem was that in the option list the value associated is 1, ...
by landrea
2019-03-24 10:30
Forum: Getting Started
Topic: SQL JOIN HELP
Replies: 2
Views: 146

Re: SQL JOIN HELP

thanks, I was able do to it, you need to select also the foreign key field using the structure "table.field" in your select, before the join declaratioon sql worked, but I didn't see the value, bacuase you need to write it in the select or ou simply continue to get the foreign key now, I have to do ...
by landrea
2019-03-22 20:31
Forum: Getting Started
Topic: get right options with hooks
Replies: 2
Views: 193

get right options with hooks

I'm working a hook using js files it works, but it's only a concidence because I dont' have enough datas inside, so at the moment the option1 is correctly what i need to check, but this can change with other datas the problem is the value inside the option is not the foreign key as I thought (i made...
by landrea
2019-03-22 19:43
Forum: Getting Started
Topic: SQL JOIN HELP
Replies: 2
Views: 146

SQL JOIN HELP

I need help optimize the sql I'm in a custom page, I'm getting this array of result from a sql call $res = sql("SELECT tipologia_intervento, COUNT(*) FROM dt_reg_interventi GROUP BY tipologia_intervento", $eo); tiplogia_intervento is a foreign key so, then I need to make a for lop of the array resul...
by landrea
2019-03-21 12:56
Forum: Getting Started
Topic: SQL OPTION IN LOOKUP
Replies: 3
Views: 144

Re: SQL OPTION IN LOOKUP

the sql simply create this: when you select a elements from the list and you associate one to these 3 tables (I separated in 3 tables because they have notihng to do each others, but this element), next time the element is not in the list any more, for doing this I simple added another filed where y...
by landrea
2019-03-20 19:58
Forum: Getting Started
Topic: SQL OPTION IN LOOKUP
Replies: 3
Views: 144

Re: SQL OPTION IN LOOKUP

ok, I think i wrong field, i need to look the descritpion, sorry, the concept wasn't wrong SELECT `dt_inventario`.`id_inventario`, `dt_inventario`.`num_inventario`, `dt_inventario`.`descrizione_inv` FROM `dt_inventario` LEFT JOIN `dt_tip_inventario` as dt_tip_inventario1 ON `dt_tip_inventario1`.`id_...
by landrea
2019-03-20 19:45
Forum: Getting Started
Topic: SQL OPTION IN LOOKUP
Replies: 3
Views: 144

SQL OPTION IN LOOKUP

I have a lookup field in a table, this lookup is connected 3 tables what I want to do is reduce the list if one of these tables already selected a value from the list I added a field in the lookup table called decrizione_inv and in my idea this field is empty or null if noone of these 3 tables have ...
by landrea
2019-03-17 12:38
Forum: Getting Started
Topic: how to return a row from database and get it
Replies: 5
Views: 182

Re: how to return a row from database and get it

ok thanks , I rewrite better, in this way I can adapt the script also situation I can have more rows and not only a row, I'm probably going to use the template for many works at the moment I dont' have the real form for testing the ajax, I still have to do it, but I dont' think I'm going to have pro...
by landrea
2019-03-17 11:56
Forum: Getting Started
Topic: how to return a row from database and get it
Replies: 5
Views: 182

Re: how to return a row from database and get it

at the moment I made this, I'm checking without the ajax, I'm sending parameter directly in the url I dont' know if have a sense, it seems working, i added makesafe for security reason, pheraps is not necessary in this case, I think I'm ok at the moment I added a header to test better the data, I do...
by landrea
2019-03-17 10:13
Forum: Getting Started
Topic: how to return a row from database and get it
Replies: 5
Views: 182

how to return a row from database and get it

I have a theorical problem, I probably will need to do a ajax call to a php file in my hooks folder this time I probably will need to retrun a row from the database and not a single value, I think I can't echo an array like I can echo a simpe string with a a value, I'm not sure because I sometimes c...
by landrea
2019-03-15 15:39
Forum: Getting Started
Topic: change value in a filed when select another field
Replies: 6
Views: 305

Re: change value in a filed when select another field

I share the last version, in case people have same need or people want suggest something to do it better, I added an onlick function that show the modal if the field is empty, so dont' store data if the delay still is working and user fast push save button dt_aule-dv.js // ==========================...
by landrea
2019-03-15 15:22
Forum: Getting Started
Topic: change value in a filed when select another field
Replies: 6
Views: 305

Re: change value in a filed when select another field

at the moment I changed in this way, adding a deley of 2 seconds, then I'm going to add a required field there with jquery or directly in the software menu of appgini, so you can't submit if is still empty, I woudl prefer another soluction, even though in my test 2 seconds are probably sufficient to...
by landrea
2019-03-15 15:00
Forum: Getting Started
Topic: change value in a filed when select another field
Replies: 6
Views: 305

Re: change value in a filed when select another field

ok, I made it, I have a problem because that's not a real select ajax call is ok so I don't post it If I look the html code in console the value of the field connected the select is ok, it change correctly, but when I console.log (in my script onchange jquery) I'm getting alwasy the precedent select...
by landrea
2019-03-14 18:45
Forum: Getting Started
Topic: change value in a filed when select another field
Replies: 6
Views: 305

Re: change value in a filed when select another field

thanks very much, I think is in section 10 of the course I need to adapt a little the example probably because had to do with calculation, more or less the select should fire a ajax cal and then I write the value in the field with jquery, I need a php file inside hook that create the sql so, it's qu...
by landrea
2019-03-14 18:21
Forum: Getting Started
Topic: change value in a filed when select another field
Replies: 6
Views: 305

change value in a filed when select another field

I made the hook course only I forget lot of things because I don't use the software often I need a little help to remember best techinique to do it I have a table with a lookup filed point into another table, this filed is a select now in the next field it's readonly field i need to store something ...
by landrea
2019-02-09 13:19
Forum: Getting Started
Topic: question new version AppGini 5.73 and 74
Replies: 1
Views: 216

question new version AppGini 5.73 and 74

Hello, I have right to upgrade my appgini to the new version, I have two questions 1) log report say we have now a new password system (more secure) question is if I can still copy the database from local host mysql to online mysql (I mean with the function you export and import slq file) or with th...
by landrea
2018-11-25 09:21
Forum: Getting Started
Topic: help for structure of an application
Replies: 6
Views: 538

Re: help for structure of an application

I pheraps need to have a fied in computer is foreigh key to offices and a field in office is foregn key to computers so I need probably to change it automatically if something change and setup a read only field with jquery in one of the two tables I though a way to join tables, source code is too co...
by landrea
2018-11-22 15:29
Forum: Getting Started
Topic: help for structure of an application
Replies: 6
Views: 538

Re: help for structure of an application

thanks jsetzer I probably need to think careful application more than I thought, your post help me I was searching about join tables in the forum and in the main guide and there are not specific examples I know how to write the sql, but I don't get how I will serve the data inside a table I didn't c...
by landrea
2018-11-22 13:48
Forum: Getting Started
Topic: help for structure of an application
Replies: 6
Views: 538

Re: help for structure of an application

Thanks balfons, surelly app gini is perfect for this application, since I don't have trilion of data, we speak of 200/250 computers and we need to fit the technical part of the law about privacy in europe (that unfortunatly it's the same for a corporation with 10.000 professionists and a no profit o...
by landrea
2018-11-16 16:22
Forum: Getting Started
Topic: help for structure of an application
Replies: 6
Views: 538

help for structure of an application

Hello, I need help in order to think how strcture a application. What I need is create a table for offices and create a table for computers are in these offices I want to know if there are computers not associate to the offices, so tables need to be separated and for this porpouse I see in the guide...
by landrea
2018-08-06 12:54
Forum: Advanced Customizations > Others
Topic: multi choice
Replies: 13
Views: 1878

Re: multi choice

Thanks Yesterday i made some test It's not important what you write in the app gini interface since if you put a csv file this ovverride simply your original list (this behaviour is in the php code of root/tablename_dml.php) csv file need the following name: table.field.csv and you need to put it in...
by landrea
2018-08-04 16:27
Forum: Advanced Customizations > Others
Topic: multi choice
Replies: 13
Views: 1878

Re: multi choice

i'm new user and still i'm studying the software i was looking for a solution like the question of the topic i'm intrested your solution, so i ask help to get it better i think i get the php file you posted I create a specific table that i use for the list options when someone update the table (for ...