• Monday , 19 November 2018

DaDaBIK tutorial (OLD), first episode, create a PHP MySQL CRUD front-end without coding

Code Canyon



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

3d Ocean

Related Posts

24 Comments

  1. Michael Both
    October 20, 2018 at 21:13

    Looks very promising

  2. Tor Sverre Rimehaug
    October 20, 2018 at 21:13

    Too bad this is the ONLY Tutorial here from DaDaBIK.

  3. Mauro Bergamaschi
    October 20, 2018 at 21:13

    Complimenti, il video è stato illuminante per capire alcune cose fondamentali.
    Non sono previste puntate future? Sarebbe un peccato!

  4. MatizEV
    October 20, 2018 at 21:13

    Yes, that is what I need to do, thanks for your help.

  5. DaDaBIK
    October 20, 2018 at 21:13

    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.

  6. MatizEV
    October 20, 2018 at 21:13

    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).

  7. DaDaBIK
    October 20, 2018 at 21:13

    Hi,
    the last part (the listbox in D) is not very clear, can you explain it better, maybe with a real-world example?
    Cheers.

  8. MatizEV
    October 20, 2018 at 21:13

    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.

  9. DaDaBIK
    October 20, 2018 at 21:13

    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).

  10. alfasessenta
    October 20, 2018 at 21:13

    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?

  11. DaDaBIK
    October 20, 2018 at 21:13

    Thanks Azian. I used MySQL Workbench.
    Cheers.

  12. Azlan Kassim
    October 20, 2018 at 21:13

    hi may i know what software u using to create the database. I just bought the dadabik. Wonderful application.

  13. Virginio Fanelli
    October 20, 2018 at 21:13

    grazie per la tua risposta
    ci sentiamo

  14. DaDaBIK
    October 20, 2018 at 21:13

    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.

  15. Virginio Fanelli
    October 20, 2018 at 21:13

    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

  16. DaDaBIK
    October 20, 2018 at 21:13

    Yes I am.

  17. Benet Garcia
    October 20, 2018 at 21:13

    Are you available for a little consulting on your dadabik application?

  18. DaDaBIK
    October 20, 2018 at 21:13

    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.

  19. Alex Summer
    October 20, 2018 at 21:13

    Very nice application! I was wondering if it is possible to easily modify the dadabik frontend with css. thsk!

  20. DaDaBIK
    October 20, 2018 at 21:13

    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.

  21. Kudo Markos
    October 20, 2018 at 21:13

    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.

  22. Anton Hinxman
    October 20, 2018 at 21:13

    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.

  23. DaDaBIK
    October 20, 2018 at 21:13

    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!

  24. ratkinsonuk69
    October 20, 2018 at 21:13

    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.

Leave A Comment

You must be logged in to post a comment.