PHP - Build Color Palette With Loops

Is it overkill to use PHP/MySQL to query my database, retrieve the universe of Questions, and then dynamically build a Form?

I have a "Q&A Form" with a whopping 10 Questions.

I suppose dynamically building the Form has the advantage that I always have the most up-to-date Questions and Question Text, but them again, if there is a database issue, I have a larger issue...

Thoughts?   


Debbie

Hello.  I would like to build a survey that I can use on an iPad so that I can go out in the field and gather data from people.

What would be the best way to accomplish this?

I'm not sure what limitations even exist on an iPad - like can you have a webserver like MAMP?

It seems to me that using something like Angular or whatever might make sense since you can build a working app all in one, but then I don't even know traditional Javascript.

Just looking for a quick way to build something to allow me to survey people without making this a major project.\

Thanks.

Hello again, guys!

I'm trying to do this:

Get $user_ID -> SELECT FROM favorites WHERE user="$user_ID" -> Now I should create an array with the ID of all the results of the previous command ->
SELECT FROM books WHERE genre="$favorites_ID" -> populate a html table.

The part I've no idea about how to do is building an array with the results and then using the SELECT command, find in the other tables the match.

Could you please give me a hand - one more time?

Hiya peeps!

I can't seem to build a preg_match pattern that works.

This is what I need to do.

"[" . $errorID . "]='HERE IS WHAT I NEED TO DISPLAY';"

Does anyone have any ideas on how I would build this regex string?

Many thanks,

James.

OK here is what I have going on right now. Currently I'm trying to build a excel spread sheet into a dynamic form via php. The results are basically questions and are stored each week so for one section they may be asking how many visitors, employee's , etc.. now some of these values that are being entered are going to be used in another question per-say but the result may come from other values that were already submitted so these questions would not be shown in the form that needs to be made later on. The form I'm having trouble with is the initial form to help generate the formula's for these different questions. So what I was going to start doing was have it list all the questions with a check box next to the question if the formula for said question was something like add these two questions and the divide by this set of questions or a whole number then it would display a list of questions for adding together and the get the total from that set and then do a expression afterwards like adding, subtracting, multiplying or dividing. So I was thinking I should list like a set of buttons I think in the beginning. What is the first task at hand Totaling, Adding, Subtracting, Dividing, Multiplying and then when they click on this it would refresh the page and bring up a box that lists all the different questions for them. Then saving the values as which ever button they clicked and once they do this. Then they could either click on say a more button which would pass the values as a array back to the page and continue on or they could click submit and pass the values into a db field as a formula but this is my first concept and would like to know if there may be a better way of doing it.

How could I build an interactive text system?
 It should work like this:
 Text is displayed.
 1-3 options (a situational amount of them) to answer displayed.
 Example:
 Are you male?
 Yes
 No

 You choose yes or no and it leads you to another questions based from your previous answer.
 Example: (a follow up to the 1st one)
 So you're male. Do you like cars then?
 Answers.
 And it goes on and on.

 The thing I need help with is the answers. I need to show them based by the previous answer but don't know how, any help?

So, I need to build a table based on this table:
Code: [Select]
create temporary table downline (
depth int,
member_id int,
full_name varchar(50),
level int,
referrer_id int,
country char(2)
);
I need to make a table to show each members downline (the people they referred to the site), it needs to be unlimited levels deep, and we have some members that have 25+ levels in their downline, where level 20 has 15,000+ people.

Level 1 = your downline
Level 2 = your donwline's downline
Level 3 = your downline's downline's downline
ect.

I have this loop (after the temp table is built) which needs to build a table on the page.


So, I can not get this table display right for the members downline, any suggestions?

// Build the current users downline and add it to the temporary table
$downline = mysql_query("select * from downline order by depth");
while($row = mysql_fetch_assoc($downline)){

if($row['depth'] != $depth){

$depth_id = $row['depth'];

$content .= "<tr id='main_lvl_$depth_id' class='hiddenInfo' onclick='showHide(this);'><td style='text-align: center;color:#4d53c1;font-weight: bold;' class='w_border'><span class='signs_s'>".$this->dict['mLevels_Level']." $depth_id : </span><span class='signs'>".count($down)." ".$this->dict['mLevels_Members']." </span></td></tr><tr id='lvl_$depth_id' style='display:none;'><td class='w_border' style='text-align: center;'><table style='width:100%;'>";

$i = 0;

$content .= "<tr>

<th>Member ID (Sponsor ID)</th>

<th>Member Name</th>

<th>Country</th>

<th>Member Level</th>

</tr>";

}

$class = ($i%2) ? 'color1NL' : 'color2NL';

$content .= "<tr id='_{$key}_' class='$class'><td class='width33'><a name='_".$row['member_id']."'></a><a href='?mid={$row['member_id']}'>#{$row['member_id']}</a> (<a href='?mid=".$row['referrer_id']."'>#".$row['referrer_id']."</a>)</td><td class='width33'>".$row['full_name']."</td><td>".$row['country']."</td><td class='width33'>".$row['level']."</td></tr>";

$i++;

if($row['depth'] != $depth){

$content .= "</table></td></tr>";

}

$depth = $row['depth'];
}

The following attachment has a working copy. The reason we don't stay with this is because it doesn't work with members who have large downlines, we run out of memory in php, and this hopefully will solve this problem.

Hey PF. I'm trying to build some better coding habits, so what tips do you guys have? Of course there are obvious things such as well-commented code, neat structure, etc...

But I'm looking for some more "TECHNICAL" tips that might be unspoken. For example, when is a good time to use a variable, opposed to a constant? I notice that a lot of programmers define their database settings with define(), while others just use a $variable. Is this personal preference or maybe its something I'm missing?

I'm looking for ALL tips. Any information that you have, please share it. It will help make me (And anyone else reading this), a better coder.
Thanks in advance.

and if this is not the proper forum, please move it! =]

Ok so I'll try to explain what I'm trying to do the best I can. I want to build an array that allows me to add/remove/modify the variables used at any point in time without having to rebuild or rewrite a ton of new code.

For example, below is an example list of variables I'd like to use in the array, followed by the code I would like to be automatically repeated.

Example Variables: $materialName1, $materialName2, $materialName3, $materialName4, $materialName5, $materialName6 etc etc etc
Example Code to repeat:
Code: [Select]
echo "<tr><td>Material: $materialName1</td><td>Rate: $materialName1Rate</td><td>Weight: $materialName1Weight</td></tr>";

Hopefully that makes sense. As always, very appreciated.

I'm trying to build an array in a foreach loop, but when I got to echo the results it only displays the first character of the string, but if I do a print_r on the array it show the data fine.


$msgColor1 = array();
foreach ($playerName1 as $value) {    
            $msgColor1['name'] .= $value[$i];
            $i = $i + 1;            
        }


print_r show the data but when i do


foreach ($msgColor1 as $test) {
            echo $test['name'];
}

Only shows the first character in the string

I'm confused how to get the chat object to work with the pushes/pulls, and don't know where I'm going wrong.  Here's the basics of what I need to know without reloading the page: how do I push new data to the server how do I push new data to the client how do I not rebuild the data client has every time   I may need to know more, but that's what I know I need to be able to do so far.

This topic has been moved to Installation in Windows.

http://www.phpfreaks.com/forums/index.php?topic=358758.0

Hi,

I am trying to recursively build another array based on the one I get back from our CRM api.  The array I get back looks like this:

Code: [Select]
[1] => stdClass Object
        (
            [description] => Description Text
            [label] => Product
            [name] => Product
            [sobject] => KnowledgeArticleVersion
            [topCategories] => stdClass Object
                (
                    [childCategories] => Array
                        (
                            [0] => stdClass Object
                                (
                                    [childCategories] => Array
                                        (
                                            [0] => stdClass Object
                                                (
                                                    [childCategories] => Array
                                                        (
                                                            [0] => stdClass Object
                                                                (
                                                                    [label] => Apple
                                                                    [name] => Apple
                                                                )

                                                            [1] => stdClass Object
                                                                (
                                                                    [label] => Orange
                                                                    [name] => Orange
                                                                )

                                                            [2] => stdClass Object
                                                                (
                                                                    [label] => lemon
                                                                    [name] => lemon
                                                                )

                                                        )

                                                    [label] => Templates
                                                    [name] => Templates
                                                )

                                            [1] => stdClass Object
                                                (
                                                    [label] => Connector
                                                    [name] => Connector
                                                )

                                            [2] => stdClass Object
                                                (
                                                    [label] => AeroView
                                                    [name] => AeroView
                                                )

                                        )

                                    [label] => AeroWare
                                    [name] => AeroWare
                                )

                            [1] => stdClass Object
                                (
                                    [label] => BackOffice
                                    [name] => BackOffice
                                )

                            [2] => stdClass Object
                                (
                                    [label] => OutWare
                                    [name] => OutWare
                                )

                            [3] => stdClass Object
                                (
                                    [childCategories] => Array
                                        (
                                            [0] => stdClass Object
                                                (
                                                    [label] => ERA
                                                    [name] => ERA
                                                )

                                            [1] => stdClass Object
                                                (
                                                    [label] => Kairos
                                                    [name] => Kairos
                                                )

                                        )

                                    [label] => InWare
                                    [name] => InWare
                                )

                        )

                    [label] => All
                    [name] => All
                )

        )

The child categories could be any level deep.  I would like put it in an array something like this:
Code: [Select]
Array
(
    [label] => Cat 1
    [level] => 0
    [children] => Array
        (
            [label] => Sub Cat 1
            [level] => 1
            [children] => Array
                (
                    [label] => Sub Sub Cat 1
                    [level] => 2
                )

        )

)

I have tried so many things but I just can't get it right.  Any assistance would be greatly appreciated.

Thanks
Peter

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=346015.0