3. A series of function questions, one at a time.

bluetonic

Last one for today.

Why doesn't this work? Rather, why can't I get the count of each value?
(This actually just prints the unaffected array)

$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
or die('Error connecting to MySQL server');
$query = "SELECT * FROM whitealbumreg.lps";

$result = mysqli_query($dbc, $query)
or die('Error querying database.');

$totals = array();
$totals = array_count_values($totals);
while ($row = mysqli_fetch_assoc($result))
{
$totals[] = $row;
}

echo "<pre>";
print_r($totals);
echo "</pre>";

laserlight

bluetonic wrote:
Why doesn't this work? Rather, why can't I get the count of each value?
(This actually just prints the unaffected array)

What do you mean? What exactly are you trying to do, and why do you use array_count_values() on an empty array?

By the way, please post PHP code in [noparse]

[/noparse] bbcode tags.

bluetonic

The answer to your question is that I don't know what I'm doing.

I thought $totals = array(); creates an array and then $totals = array_count_values($totals); takes that array and runs it through a function that should return a count of my values.

I am sure I am doing it wrong but I don't understand why.

NogDog

At the point where you execute the array_count_values() function, the $totals array is empty, as you have not yet assigned anything to it. Try moving the array_count_values() call to after the while() loop (where you are actually assigning elements to the array).

bluetonic

I get this message:
Warning: array_count_values() [function.array-count-values]: Can only count STRING and INTEGER values! in /Applications/MAMP/htdocs/untitled.php on line 25

<?php

error_reporting(E_ALL);
ini_set('display_errors', '1');


require_once('connect.php'); 

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



$query = "SELECT * FROM whitealbumreg.lps";

  $result = mysqli_query($dbc, $query)
    or die('Error querying database.');

$totals = array();
$totals = array_count_values($totals);
while ($row = mysqli_fetch_assoc($result))
{
    $totals[] = $row;
}
$totals = array_count_values($totals);
echo "<pre>";
print_r($totals);
echo "</pre>";
mysqli_close($dbc);

?>

mpb001

NogDog;10924318 wrote:
At the point where you execute the array_count_values() function, the $totals array is empty, as you have not yet assigned anything to it. Try moving the array_count_values() call to after the while() loop (where you are actually assigning elements to the array).

It won't work anyway as the array will be two dimensional as it is a table result set.

<?php
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
$results[] = array( 'id' => '1', 'name'=> 'album1' );
$results[] = array( 'id' => '2', 'name'=> 'album2' );

print_r( array_count_values( $results ) );
?>

I think it is important to ask what is trying to be achieved because a change in the query might be what is needed( eg. count combined with group by ).

bradgrafelman

Shouldn't a simple [man]count/man work?

bluetonic

Let me explain:
I have built a website using PHP for the first time. I am having a good amount of trouble understanding exactly how PHP works and am at the stage where I am trying to figure out what functions to what and when to use them.

Maybe there are some fundamental rules that have eluded me.

Most of the examples available on the internet use arrays that are sitting right there instead of how someone would actually use an array like pulling it out of a database.

What I am trying to do is pull several things out of a database and do mathematical operations with them. The goal is to pull out each item of an enum, find the total for each and then get the percentage of each compared to the whole. Additionally, I want to understand when I get it to work, why it works.

mpb001

"Most of the examples available on the internet use arrays that are sitting right there instead of how someone would actually use an array like pulling it out of a database."
Most of the php functions work with 1 dimensional arrays. What you are trying to do achieve is with 2 dimensional arrays( effectively table sets ) . This actually gets quite tricky, and usually if the data comes from the database and it is achievable to do as much of these calculations on the database( databases are designed to work with table sets and make it a lot easier ) then it is done there.

Someone might be able to help out if you give the table structure( don't use select * but name the columns ) and the expected result.

bluetonic

Some more background:

CREATE TABLE lps (
lp_id mediumint(8) unsigned NOT NULL auto_increment,
fk_member_id mediumint(9) NOT NULL,
lp_origin varchar(3) NOT NULL,
lp_style varchar(20) NOT NULL,
lp_number varchar(10) NOT NULL,
lp_load enum('Top','Side') default NULL,
lp_spine enum('Thick','Thin') default NULL,
lp_emi enum('With','Without') default NULL,
lp_audio enum('Mono','Stereo') default NULL,
lp_label enum('Domestic','Export') default NULL,
lp_factory enum('Scranton, PA','Los Angeles, CA','Jacksonville, IL','Winchester, VA') default NULL,
lp_banded enum('Banded','Not Banded') default NULL,
lp_side1 enum('Original','Corrected') default NULL,
lp_side4 enum('Original','Corrected') default NULL,
lp_img varchar(64) default NULL,
PRIMARY KEY (lp_id),
KEY fk_member_id (fk_member_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=152 ;

This is the code I am using, which is just a sample. It works for the most part. My problem is I will have a lot of statistical data to use and am trying to find a way to do it with out hit the database 50 times.

<?php
$member_id = $_SESSION['member_id'];

require_once('connect.php'); 

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



echo '<table  class="sample" width="600" border="0" cellpadding="2">';

//new row
echo '<tr><td>';
echo '<table class="innertable" width="300" border="1" cellpadding="2">';
echo ' <tr>';
echo '  <td>LP Origin</td>
';
echo '  <td style="text-align: center;" width="30">Total</td>
';
echo '  <td style="text-align: center;" width="35">Percent</td>
';
echo ' </tr>';

$query = "SELECT COUNT(lp_origin) total, lp_origin FROM whitealbumreg.lps GROUP BY lp_origin";

  $result = mysqli_query($dbc, $query)
    or die('Error querying database.');

$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. 

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) . '&#37;' . '</td>
';
     echo '  <tr>';
} 
echo '</tr>';

echo '</table>';

//new column
echo '</td><td>';

echo '<table class="innertable" width="300" border="1" cellpadding="2">';
echo ' <tr>';
echo '  <td>UK: Thin vs. Thick Spine</td>
';
echo '  <td style="text-align: center;" width="30">Total</td>
';
echo '  <td style="text-align: center;" width="35">Percent</td>
';
echo ' </tr>';


$query = "SELECT COUNT(lp_spine) total,lp_spine FROM whitealbumreg.lps WHERE lp_spine IS NOT NULL GROUP BY lp_spine";

  $result = mysqli_query($dbc, $query)
    or die('Error querying database.');

$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. 

foreach ($totals as $v)
{
   echo '  <tr>';
   echo '  <td>' . $v['lp_spine'] . '</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>';

echo '</table>';

echo ' </td></tr>';
//new row
echo ' <tr><td>';

echo '<table class="innertable" width="300" border="1" cellpadding="2">';
echo ' <tr>';
echo '  <td>UK: "An EMI recording"</td>
';
echo '  <td style="text-align: center;" width="30">Total</td>
';
echo '  <td style="text-align: center;" width="35">Percent</td>
';
echo ' </tr>';

$query = "SELECT COUNT(lp_emi) total,lp_emi FROM whitealbumreg.lps WHERE lp_emi IS NOT NULL GROUP BY lp_emi";

  $result = mysqli_query($dbc, $query)
    or die('Error querying database.');

$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. 

foreach ($totals as $v)
{
    echo '  <td>' . $v['lp_emi'] . '</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>';
} 

echo ' </tr>';
echo '</table>';

//new column
echo '</td><td>';

echo '<table class="innertable" width="300" border="1" cellpadding="2">';
echo ' <tr>';
echo '  <td>UK: Mono vs. Stereo</td>
';
echo '  <td style="text-align: center;" width="30">Total</td>
';
echo '  <td style="text-align: center;" width="35">Percent</td>
';
echo ' </tr>';
$query = "SELECT COUNT(lp_audio) total,lp_audio FROM whitealbumreg.lps WHERE lp_audio IS NOT NULL GROUP BY lp_audio";

  $result = mysqli_query($dbc, $query)
    or die('Error querying database.');

$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. 

foreach ($totals as $v)
{
    echo '  <td>' . $v['lp_audio'] . '</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>';
} 
echo ' </tr>';
echo '</table></td></tr>';

//end table with
echo '</table>';