Allow user to add the new fields in the tables

dilipmathi
Member • Jun 30, 2011

Allow user to add the new fields in the tables

Hi to all

How can we allow the user to add the new fields on the tables , with out do any application code change ? (meaning after they add the new field i don't want to change the application code to read that new fields)

How to achieve this?

Please help me

Thanks

Dilip

Replies

Howdy guest!

Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.

Replies

dilipmathi

Member • Jul 3, 2011

Hi

Any suggestions?

Thanks

Dilip

Are you sure? This action cannot be undone.
Cancel
PraveenKumar Purushothaman

Member • Jul 3, 2011

If you have a numeric read of fields, then your code itself is wrong... In case of PHP and MySQL, what I do is,

$res = mysql_query("SELECT * FROM `table`"); while ($dat = mysql_fetch_row($res)) // Display the rows.
This way, it iterates through all the possible fields... 😀 Not just a set of fields you hard-coded... 😀

Are you sure? This action cannot be undone.
Cancel
dilipmathi

Member • Jul 3, 2011

Hi

Thank you so much for your reply.

When the user adding the new fields changing the table structure is a good idea?

Or any other ways to achieve it?

Please help me

Thanks

Are you sure? This action cannot be undone.
Cancel
PraveenKumar Purushothaman

Member • Jul 3, 2011

Changing the table structure is the WORST idea... BTW, what is your scenario, so that I can guide you... 😀

Are you sure? This action cannot be undone.
Cancel
dilipmathi

Member • Jul 3, 2011

Hi

Thanks again for your reply

If let say we have an contact information table with the following fields (First name , Last name) . The user wants to add an new field called Address.

How to achieve the above scenario?

Thanks

Dilip

Are you sure? This action cannot be undone.
Cancel
PraveenKumar Purushothaman

Member • Jul 3, 2011

Use joins... Have you heard of tags??? And BTW, for your particular query, I have sent you a link in your VM... How to use tags and stuff in database... 😀 Enjoy... 😀

Are you sure? This action cannot be undone.
Cancel
dilipmathi

Member • Jul 3, 2011

I have sent you a link in your VM... How to use tags and stuff in database... 😀 Enjoy... 😀
How can i find it?

Thanks

Are you sure? This action cannot be undone.
Cancel
PraveenKumar Purushothaman

Member • Jul 4, 2011

Go to your profile... #-Link-Snipped-# And see the link.

Are you sure? This action cannot be undone.
Cancel
dilipmathi

Member • Jul 4, 2011

Hi

Thank you much for your help. I got an idea to do that.

Can you please share your ideas on this thread?

#-Link-Snipped-#

Thanks in advance

Dilip

Are you sure? This action cannot be undone.
Cancel
PraveenKumar Purushothaman

Member • Jul 4, 2011

Sure Dilip! 😀

Are you sure? This action cannot be undone.
Cancel
PraveenKumar Purushothaman

Member • Jul 4, 2011

Dilip I posted there. Do check it out... And also, please read this excellent tutorial by GF... 😀
#-Link-Snipped-# 😀

Are you sure? This action cannot be undone.
Cancel
PraveenKumar Purushothaman

Member • Jul 4, 2011

I will be posting more information about CRM in my blog soon... 😀

Are you sure? This action cannot be undone.
Cancel