You are here: Re: [PHP] serialize « PHP « IT news, forums, messages
Re: [PHP] serialize

Posted by "Gustav Wiberg" on 09/25/05 08:01

----- Original Message -----
From: "blackwater dev" <blackwaterdev@gmail.com>
To: <php-general@lists.php.net>
Sent: Sunday, September 25, 2005 4:17 AM
Subject: [PHP] serialize


I have an app that stores evaluation scores so I have 30+ values all
within a certain range, currently in the db, each of these values has
it's own column:

Table test
id
user_id
motivation
caring
personal_characteristics
creativity,
...etc.

If the client decides they want to trap more characteristics, it
requires changes to the table structure and the table quickly gets
large with 30+ columns. I was thinking of just compacting all of
these down to one column and then using serialize/unserialize and
storing an array of the test scores....is this the best way??

Thanks!

Hi!

It doesn't seem like "good" db-practise to set all the values in one field.
You shouldn't be forced to change database-structure just because the user
inputs more information.

You may reconsider using several tables and do relations between the
tables..

/G
http://www.varupiraten.se/

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация