This tutorial refers to DaDaBIK 4 and it is quite old, see the most recent tutorial, related to DaDaBK 8 Lerici, here https://youtu.be/TXraN_5extw *** This is the first …
Original source
DaDaBIK tutorial (OLD), first episode, create a PHP MySQL CRUD front-end without coding
24 responses to “DaDaBIK tutorial (OLD), first episode, create a PHP MySQL CRUD front-end without coding”
Looks very promising
Too bad this is the ONLY Tutorial here from DaDaBIK.
Complimenti, il video è stato illuminante per capire alcune cose fondamentali.
Non sono previste puntate future? Sarebbe un peccato!
Yes, that is what I need to do, thanks for your help.
So basically in D you need a cascade listobx that, according to the value in bankRef, change giving in the Nameid listbox just the names of the people related to that bankRak. If I have well understood, no, this on-the-fly cascade listboxes at the moment are not supported.
I want to record payments made by club members. Payments are automatically paid into bank. Every month I get a statement with individual amounts and references. Some of the payment are for more than one member. So table A has bank ref, B has member names and foreign key to A. C records the bank transaction (bank ref, date, amount) and this is the tricky part, when I enter a bank ref in C I then need a list of related names to enter into table D (bankRef, NameId, amount).
Hi,
the last part (the listbox in D) is not very clear, can you explain it better, maybe with a real-world example?
Cheers.
I have a database with 4 tables, let's call them A, B, C, D. A has a 1 to many (1-n) with B, C (1-n) D, A (1-n) C, and B (1-n) D. So A and B already have data in them. I need to insert new data into C and D on a single form. 'A' would provide a list box for C and then I need a list box for D that would use my selection from C to grab a list from B. I hope this makes sense and if it does will dadabik handle this. Thanks.
Hello alfasessanta,
that is not how licensing legally work. If you own the copyright of the code, you can release under as many different licenses as you want. Furthermore, software released under a GPL license can also be sold (pay download).
Eugenio, your work is excellent, but why did you deleted ALL the old, free versions from sourceforge? Do you realise that, if you are using a SINGLE line from your old code (Which you released under GNU license back then) on your new, paid only versions (>4.4) you are obliged to release the source code and provide free downloads, otherwise you will be violating that very GNU license you agreed and enforced yourself in the past?
Thanks Azian. I used MySQL Workbench.
Cheers.
hi may i know what software u using to create the database. I just bought the dadabik. Wonderful application.
grazie per la tua risposta
ci sentiamo
Ciao e grazie per i complimenti, Virginio.
I campi calcolati per ora non ci sono ma sono nella to do list e potrebbero gia' essere disponibili dalla prossima versione visto che me li hanno gia' richiesti parecchie volte.
Per ora si puo' sopperire a questa mancanza usando una stored procedure o una vista lato DB.
Grande lavoro, Eugenio.
È possibile fare degli calcoli come per esempio addizionare il valore di 2 campi numerici ?
Nel tua table album avere il calcolo del prezzo con l'IVA ?
Grazie
Virginio
Yes I am.
Are you available for a little consulting on your dadabik application?
Thanks Alex.
Yes it is, the CSS is quite detailed. We are also working on a sort of template version which will allow an extreme customization of the application.
Very nice application! I was wondering if it is possible to easily modify the dadabik frontend with css. thsk!
I got what you meant: adding multiple filters to the same field. Honestly I have never thought about that but it could be a nice enhancement.
Fanstastic!! It will be an excelent tool. I've a question about next releases. It would be possible "several combos select" for foreign keys? I mean, in this example.. artist table has several 'names' and every name another field 'Country' for example.. ANd i need to choose 'Amanda' from 'Switzerland' and not 'Amanda' from 'Kenya'. I hope you understand me, my english is very bad. Thanks.
Excellent, the beauty of this approach comes from its simplicity. Even if you do many other fancy things you do not loose the need to have a simple CRUD administration system.
Hi Rob, thanks for the appreciation, I would like to publish another video tutorial soon, I'm not sure if I will cover that part in the second episode but thanks for the idea!
Eugenio, very good tutorial. It would be good to see how we can embed the CRUD user interface into existing PHP pages next.
Thanks, Rob.