At 5:18 PM -0700 3/17/10, Tommy Pham wrote:
-snip-
Below is how I'd do the db structure:
tbl_survey_questions:
questionId = int / uid << your call
languageId = int / uid / char << your call if you intend to I18n it ;)
question = varchar << length is your requirement
PK > questionId + languageI
On Sat, Mar 13, 2010 at 11:10 AM, tedd wrote:
> Hi gang:
>
> I just completed writing a survey that has approximately 180 questions in it
> and I need a fresh look at how to store the results so I can use them later.
>
> The survey requires the responder to identify themselves via an
> authorizati
Op 3/14/10 11:45 AM, Ashley Sheridan schreef:
> On Sun, 2010-03-14 at 12:25 +0100, Rene Veerman wrote:
>
>> On Sun, Mar 14, 2010 at 12:24 PM, Rene Veerman wrote:
>>>
>>> I'd love to have a copy of whatever function you use to filter out bad
>>> HTML/js/flash for use cases where users are allowed
On Sun, 2010-03-14 at 12:25 +0100, Rene Veerman wrote:
> On Sun, Mar 14, 2010 at 12:24 PM, Rene Veerman wrote:
> >
> > I'd love to have a copy of whatever function you use to filter out bad
> > HTML/js/flash for use cases where users are allowed to enter html.
> > I'm aware of strip_tags() "allow
On Sun, Mar 14, 2010 at 12:24 PM, Rene Veerman wrote:
>
> I'd love to have a copy of whatever function you use to filter out bad
> HTML/js/flash for use cases where users are allowed to enter html.
> I'm aware of strip_tags() "allowed tags" param, but haven't got a good list
> for it.
>
oh, and e
On Sun, Mar 14, 2010 at 12:13 PM, Ashley Sheridan
wrote:
>
> I have to deal with a lot of CMS's, so I expect the users to enter some
> HTML code through a rich-text editor, and they expect to be able to.
>
I'd love to have a copy of whatever function you use to filter out bad
HTML/js/flash for us
On Sun, 2010-03-14 at 12:14 +0100, Rene Veerman wrote:
>
>
>
> On Sun, Mar 14, 2010 at 11:16 AM, Ashley Sheridan
> wrote:
>
>
>
>
> That function won't always work. You're using a PHP version
> check for mysql_real_escape_string() when the most likel
On Sun, Mar 14, 2010 at 11:16 AM, Ashley Sheridan
wrote:
> That function won't always work. You're using a PHP version check for
> mysql_real_escape_string() when the most likely failure point for it is if
> no database connection has been opened.
>
I never call it without an open db connection.
On Sun, 2010-03-14 at 11:15 +0100, Rene Veerman wrote:
> On Sun, Mar 14, 2010 at 7:18 AM, Paul M Foster
> wrote:
> >
> > Tedd's perfectly capable of speaking for himself, but I can tell you
> > he's been on this list for a long time, and his skills are plenty
> > adequate for this task. He's jus
On Sun, Mar 14, 2010 at 8:22 AM, Jochem Maas wrote:
>
> first off - wasn't there a cut'n'dried piece of survey software out there
> that did the job? don't know off hand what the 'market' currently offers but
> I'm pretty sure there are a number of candidate php-based wotsits.
>
> as such they mig
On Sun, Mar 14, 2010 at 7:18 AM, Paul M Foster wrote:
>
> Tedd's perfectly capable of speaking for himself, but I can tell you
> he's been on this list for a long time, and his skills are plenty
> adequate for this task. He's just asking for second opinions.
>
Wouldn't someone with adequate DB ski
Hi Tedd,
just a few thoughts that might help ...
Op 3/13/10 6:10 PM, tedd schreef:
> Hi gang:
>
> I just completed writing a survey that has approximately 180 questions
> in it and I need a fresh look at how to store the results so I can use
> them later.
first off - wasn't there a cut'n'dried
On Sat, Mar 13, 2010 at 09:04:46PM +0100, Rene Veerman wrote:
>
> and the OP may not have good db design skills yet.
> for a noob, it's one timeconsuming thing to build a datamodel, but
> it's harder to get it efficient yet simple.
>
>
> OP: if you need a mysql datamodel for reports, i'm w
On Sat, Mar 13, 2010 at 02:45:37PM -0500, Phpster wrote:
> I'd go with a mysql data modelled approach as it will allow mysql to
> do lots of the heavy lifting during analysis as you've mentioned. If
> there are a lot of entries, it's gonna get complex and expensive
> memory-wise to manage XML or s
the OP may not need such fanciness.. it depends on the amount of
reports he wants to store, the types of searches (if any) done by
browsers, and the amount of searches to expect.
and the OP may not have good db design skills yet.
for a noob, it's one timeconsuming thing to build a datamodel, but
i
I'd go with a mysql data modelled approach as it will allow mysql to
do lots of the heavy lifting during analysis as you've mentioned. If
there are a lot of entries, it's gonna get complex and expensive
memory-wise to manage XML or session based datasets.
Plus having each question as it's o
+1, but it also kinda depends on what you want to do with it later,
and how much.
if you want to re-use filled-in reports on the javascript end, you may
want to use json_encode() instead of serialize().
if you plan to have many (say >5000) reports filled in and want users
to be able to search qui
On Sun, Mar 14, 2010 at 2:10 AM, tedd wrote:
> Hi gang:
>
> I just completed writing a survey that has approximately 180 questions in
> it and I need a fresh look at how to store the results so I can use them
> later.
>
> The survey requires the responder to identify themselves via an
> authoriza
18 matches
Mail list logo
