Need variable help

[bluetonic]

Here's what I am trying to do:

If you do a while or for loop, is possible to create a variable for individual values?
For example, if I employed a loop to pull out all the cities in an address table, is it then possible to take the result and then be able to create something like $atlanta or $macon or $augusta.

From my limited experience I can get the loop to output everything but all I know is to echo those results. My goal is to use each variable for math in a different table cells. Currently all I can accomplish is putting them all in one cell b/c the echo is doesn't allow me to put <table>'s, <tr>'s and <td>'s between results.

MY gut tells me I should be using some kind a array with a foreach or while loop.

Below is how I was able to achieve what I wanted: I actually have 40 queries on my database with each query producing the variable I need to use in the table.

This is the end result: http://whitealbumregistry.com/stats.php

$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
   or die('Error connecting to MySQL server');

$query1 = "SELECT * FROM whitealbumreg.lps";
  $result1 = mysqli_query($dbc, $query1)
    or die('Error querying database.');

$query2 = "SELECT * FROM whitealbumreg.lps WHERE lp_origin='uk'";
  $result2 = mysqli_query($dbc, $query2)
    or die('Error querying database.');

$query3 = "SELECT * FROM whitealbumreg.lps WHERE lp_origin='us'";
  $result3 = mysqli_query($dbc, $query3)
    or die('Error querying database.');

....

$lps = mysqli_num_rows($result1);
$uk = mysqli_num_rows($result2);
$us = mysqli_num_rows($result3);




echo "<br />\n"; 
echo "<table width='616' border='0' cellpadding='2'>\n";

// New Row
echo "<tr>\n";
echo "  <td>\n";
echo "   <table width='607' border='1' cellpadding='2'>\n";
echo "     <tr>\n";
echo "       <td><font size='4'>Registered copies of the Beatles White Album</font></td>\n";
echo "       <td class='center' width='30'>Total</td>\n";
echo "       <td class='center' width='35'>Percent</td>\n";
echo "       <td class='center' width='120'>Percent of Total Release*</td>\n";
echo "     </tr>\n";
echo "      <tr>\n";
echo "       <td>UK</td>\n";
echo "       <td class='center'>" . $uk . "</td>\n";
echo "       <td class='center'>" . round(($uk / $lps) * 100) . "%" . "</td>\n";
echo "       <td class='center'>" . (($uk / 100000) * 100) . "%" . "</td>\n";
echo "     </tr>\n";
echo "      <tr>\n";
echo "        <td>US</td>\n";
echo "        <td class='center'>" . $us . "</td>\n";
echo "        <td class='center'>" . round(($us / $lps) * 100) . "%" . "</td>\n";
echo "        <td class='center'>" . (($us / 3200000) * 100) . "%" . "</td>\n";
echo "      </tr>\n";
echo "   </table>\n";
echo "   <table width='607'>\n";
echo "      <tr>\n";
echo "        <td class='right'>* - based on 3,200,000 US and 100,000 UK copies</td>\n";
echo "       </tr>\n";
echo "   </table>\n";
echo "  </td>\n";
echo "</tr></table>\n";

echo "<table width='600' border='0' cellpadding='2'>\n";

//new row
echo " <tr><td>\n";

echo "<table width='300' border='1' cellpadding='2'>\n";
echo " <tr>\n";
echo "  <td>UK: Side vs. Top Load</td>\n";
echo "  <td class='center' width='30'>Total</td>\n";
echo "  <td class='center' width='35'>Percent</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo "  <td>Side</td>\n";
echo "  <td class='center'>" . $side . "</td>\n";
echo "  <td class='center'>" . round(($side / $uk) * 100) . "%" . "</td>\n";
echo " </tr>\n";
echo " <tr>\n";
echo "  <td>Top</td>\n";
echo "  <td class='center'>" . $top . "</td>\n";
echo "  <td class='center'>" . round(($top / $uk) * 100) . "%" . "</td>\n";
echo " </tr>\n";
echo "</table>\n";

 

[bluetonic]

Puh-leese, someone help me with this as it as consumed almost three weeks of my life.

[dagon]

bluetonic;10923096 wrote:

If you do a while or for loop, is possible to create a variable for individual values?

yes either as an array

while($row=..){
$new[]=$row['??'];
}

or, variable variables

while($row=..){
$$row[??]=$row[??];
}

[bluetonic]

i don't know what this means:
while($row=..){
$new[]=$row['??'];
}

$row = what

[dagon]

deleted my example. cahva's example is better.

[cahva]

You dont have to do separate queries for every country. Heres an example that you can use:

$sql = "SELECT COUNT(*) total,lp_origin FROM whitealbumreg.lps GROUP BY lp_origin";
$result = mysqli_query($sql);

$totals = array();
while ($row = mysqli_fetch_assoc($result))
{
	$totals[] = $row;
}
echo '<pre>'.print_r($totals,true).'</pre>'; // Just to show you what kind of data you have in the array.

Tat will give you totals of every country. You can add ORDER BY if you want to sort the results in a different way(eg. by totals)

[bluetonic]

The problem is I need to store that variable so I can use it in a table. echo the results don't help me.

[dagon]

its all in the $totals array in cahva's example, you can use that array any way you like

[bluetonic]

One more thing. I need to do math with the results.
I know I have 17 lps from US, 12 from UK.
I need to know
1. the total (add them together?)
2. divide the US# by total
3. divide the UK# by total

and then put this the results of each in a tablecell

[bluetonic]

Maybe I wasn't clear.

Ok. Let's say I want this:
echo "There are" . [some code/$variable] . "copies from the UK.";

Base on the array, what goes in [some code/$variable] so that it equals 17?

[bluetonic]

This is what is tripping me up.
I understand $friends = array("Rachel", "Monica", "Phoebe", "Joey", "Chandler", "Ross");

but, what if the names are in the database?
How do you do something lik $friends = array($firstname);
Is this even possible?

Using $totals[] = $row; I can maniputlate the $row by adding [lp_origin] or [total]. Any changes to $totals[] produces the same thing (totals[0] or totals[1] or total[total] all result in something like:
Array
([1] => Array ([total] => 12 [lp_origin] => us))

[bluetonic]

I have yet to find someone that can answer this question for me or at least help me understand how to accomplish my goal. What would you recommend me doing next?

[cahva]

$sql = "SELECT firstname FROM friends";
$result = mysqli_query($sql);

$friends = array(); // Initialize array

// Cycle through friends and add it to $friends array
while ($row = mysqli_fetch_assoc($result))
{
    $friends[] = $row['firstname'];
}

For the earlier question, you can get the whole total for the results like this:

$totals = array();
$total = 0;
while ($row = mysqli_fetch_assoc($result))
{
    $totals[] = $row;
    $total += $row['total'];
}
// Now you can find the total of all results in $total.

I think you are having problems understanding how arrays work(I had too back in the days).

Ok. Now when the results are in the $totals array, you can iterate them with foreach afterwards:

foreach ($totals as $v)
{
    echo $v['lp_origin'].' has total of '.$v['total'].'<br />';
}

[bluetonic]

You are right about my understanding of arrays. Based on the print_r, I could see that everything I needed was there, I just couldn't figure out how to pull out the bits I needed.

I also wanted to clarify some things.
1. the $v is arbitrary, correct? (In the sense it could have been $r or $x)
2. This whole is based on
$sql = "SELECT COUNT() total,lp_origin FROM whitealbumreg.lps GROUP BY lp_origin";
--One of the problems I am having is that my 'lps' table has 15 columns. For example, one column is lp_origin with UK and US as option. Another is lp_style with 8 different options, etc. So, does that mean to get everything out of this table, do I have to query the database for each column or is it possible to do something like a SELECT FROM lps and use the php code to separate and use?

[bluetonic]

One other thing:
Is it possible to insert something unique while do loops?
For example, if i have a table with 6 rows & 2 columns. In the 2nd column, I want the php generated results, but in the 1st I want each row to have a different image.

Is that possible with php?

[mblack0508]

bluetonic;10923383 wrote:

One other thing:
Is it possible to insert something unique while do loops?
For example, if i have a table with 6 rows & 2 columns. In the 2nd column, I want the php generated results, but in the 1st I want each row to have a different image.

Is that possible with php?

I'm not sure what you're asking here, but if you're looking to get a list of cities in your example, you could do something like...

$cities = array();
$city = $row["city"];
$cities[$city] = null;

What that does is creates an associated array with the cities as the keys of the array, which prevents duplicates assuming that the information is the same or made the same (trim/strtolower/etc).

So if I wanted to get a list of the cities I could then do this

$keys = array_keys($cities);
foreach($keys as $key) {
  echo $key . "\n";
}

[Bjom]

You can either use the unpopular but fast and versatile for loop where you have a counter that you can check.

Or you can insert a counter in your foreach and check it:
This example would output 'insert some stuff' only on the

$i=1;
$checkmark = 3;
foreach (...) {
  //do the "special' stuff here
  //check $i, then increase its value by one (++)
  if ($i++ == $checkmark) {
    echo 'insert some stuff';
  }
  //do your regular foreach stuff here
}

Or you can check the key for a certain value and then react to it....

[bluetonic]

Here is what I am trying to do:
I have the following in the database to represent cities, ('pa', 'ca', 'il', 'va')

foreach ($totals as $v)
{
    echo '  <td>' . $v['lp_origin'] . '</td>';
    echo '  <td style="text-align: center;">' . $v['total'] . '</td>';
    echo '  <td style="text-align: center;">' . ROUND(($v['total'] / $total += $row['total']) * 100) . '%' . '</td>';
     echo '  <tr>';
} 

The result of this process would be 'pa', 'ca', 'il', 'va', but is it possible to get it to read:
Scranton, PA
Los Angeles, CA
Jacksonville, IL
Winchester, VA

[Bjom]

Yes, add another field with the proper names, query it alongside the tags, use strtoupper on the tags.

[bluetonic]

Do you mean add another field to the database?