Welcome, Guest
Username: Password: Remember me

TOPIC: using foreign key or another solution

using foreign key or another solution 01 Mar 2014 12:20 #12265

  • cannisar
  • cannisar's Avatar
  • Offline
  • Junior Member
  • Posts: 21
  • Karma: 0
1-) I have many tables A,B,C,D,E,F,G,H,İ, ... All of them personel informations.many of them only must show backand site.I build a table name generaliother tables are informations.The tables must call each other some fields.How can ı do that?

I added a record table general . table a must save taht too buy foreign key.But it did'nt do that.Please help me..Please say the solution step by step .not spesiphic.
The administrator has disabled public write access.

using foreign key or another solution 01 Mar 2014 14:43 #12267

  • admin
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
I think this is wrong coding.

You should NEVER copy paste code, or DB structure.
If all thoses tables are same structure, then it is VERY bad coded.
Coding is now a piece of cake
The administrator has disabled public write access.

using foreign key or another solution 01 Mar 2014 14:52 #12270

  • cannisar
  • cannisar's Avatar
  • Offline
  • Junior Member
  • Posts: 21
  • Karma: 0
not every same.
table A , B ,C,D,E,F all of them are different personal information.-for example only personal number and name is same.Now am ı clear? Now wrong coding too?!
(A table healty information, B work information table, C genereral healt politics ,D perforance ex.ex.ex.-) but not this ofcourse.if you want see ı can say the extension name ofcourse.
~ 90 infofrmation questions.What can ı do? one table 90 column?
Last Edit: 01 Mar 2014 14:54 by cannisar.
The administrator has disabled public write access.

using foreign key or another solution 01 Mar 2014 20:56 #12272

  • cannisar
  • cannisar's Avatar
  • Offline
  • Junior Member
  • Posts: 21
  • Karma: 0
Example.

Kimlik,Özlük,İrtibat,Kadro,Öğrenim,........Yurt Dışı Görev all have got other-other personal informations..
Last Edit: 02 Mar 2014 06:45 by cannisar.
The administrator has disabled public write access.

using foreign key or another solution 06 Mar 2014 13:47 #12284

  • admin
  • admin's Avatar
  • Online
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
I understand better now. If you have 90 fields related in 1:1 tables splits it is excellent coding.
Now I say the opposite... lol.

In facts, in this case, you have to update all tables and it can be only manual.
For the moment, Cook doesn't support 1:1. Joomla neither.

It is huge work to to manually.
My suggestion is to split in idependant forms in differents pages loading in modal could be cool. I know it is boring, and I am changing your idea, but it is to propose you a way that you can handle easily.

Another way, is to do the same, but to send the datas in ajax, so you do not need to load in modals or refresh/change page.

I love Ajax and step by step will try a way to propose it in Cook.
Some functions are already written and availables in your component.

For example, the form in modal IS using AJAX, because the page close ONLY is the result was OK.
You can search in the JDom Ajax asset, and also in the classes/ajax.php in your component.


Hope it helps.

By the way, if you find a good and easy way to solve 1:1 forms... I am very interressed, and as usual, the contributions are recognized.
Coding is now a piece of cake
The administrator has disabled public write access.
Time to create page: 0.113 seconds

Get Started