PHP - Counting Unique Value In An Array

Right now I have an array of zipcodes with open invitations; I want to loop over the array of zipcodes, query the database and get the name of each zipcode and then remove duplicate names.

So if 90210, 90211 and 90212 are in the array with the first 2 being City A and the last one being City B, I just want City A and City B, not City A, City A, City B.

Right now I'm doing this:
Code: (php) [Select]
foreach($invitation_Zipcodes as $key => $value){
echo 'Key: '.$key.' Value: '.$value.'<br/>';

$csaname_sql = "SELECT CBSA_Name FROM ZIPCodes WHERE ZipCode = '$value'";
$csaname_result = mysql_query($csaname_sql);
$csaname_array[] = mysql_fetch_assoc($csaname_result);

}

//$csaname_array = array_unique($csaname_array);

print_r($csaname_array);
echo '<hr/>';
print_r($invitation_Zipcodes);
exit;
That outputs this:
Quote

Array
(
    => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

    [1] => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

    [2] => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

    [3] => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

    [4] => Array
        (
            [CBSA_Name] => Pensacola-Ferry Pass-Brent, FL
        )

)
<hr/>Array
(
    => 32548 [1] => 32579
    [2] => 32578
    [3] => 32580
    [7] => 32501
)

If I uncomment the unique call, it outputs this:
Quote

Array
(
    => Array
        (
            [CBSA_Name] => Crestview-Fort Walton Beach-Destin, FL
        )

)
<hr/>Array
(
    => 32548 [1] => 32579
    [2] => 32578
    [3] => 32580
    [7] => 32501
)

What am I doing wrong? Why is it losing "Pensacola-Ferry Pass-Brent, FL" ?

Good morning!

I have a two dimensional array, basically a table (see code below). I want to get a value from the array using two methods:
1) Using the row's key:  $NewValue = $MyArray[$UniqueKey];
2) Using the row's index (row number, so to speak): $NewValue = $MyArray[$RowNumber];

The second print statement in the code below does not work. Both print statements should output the same value. Is there an easy way to do this? The table has hundreds of rows and I will not know the key value of row 879 nor can I generate it. So I cannot use array_keys(). And I DO NOT want to start at the first row and count up to the 879th row.

Any clever ideas to share and enlighten?
Thanks!

<?php
// Initialize the array keys and values
$MyArray = array();
$MyArray['first']['col1'] = 'abc'; $MyArray['first']['col2'] = 'def'; $MyArray['first']['col3'] = 'ghi';
$MyArray['second']['col1'] = 'jkl'; $MyArray['second']['col2'] = 'mno'; $MyArray['second']['col3'] = 'pqr';
$MyArray['third']['col1'] = 'stu'; $MyArray['third']['col2'] = 'vwx'; $MyArray['third']['col3'] = 'yz';
$MyArray['fourth']['col1'] = 'a1a'; $MyArray['fourth']['col2'] = 'b2b'; $MyArray['fourth']['col3'] = 'c3c';
$MyArray['fifth']['col1'] = 'ddd'; $MyArray['fifth']['col2'] = 'eee'; $MyArray['fifth']['col3'] = 'fff';
// Two methods to get a value. Second one does nothing.
print"{$MyArray['third']['col2']}</br>";
print"{$MyArray[2]['col2']}</br>";
?>

Hi I am new this forum and looking for some much appreciated help with something that has me stumped.

I have extracted regions from image names in a directory.

example: 'edinburgh_castle_(Edinburgh).jpg' (Extracted Edinburgh from in-between the brackets)

So I have a list of Regions, extracted from all the various image names in the directory which I want to populate into a dynamic drop down menu for filtering purposes.

Here's my issue...

I want there to be only one 'Edinburgh' option appearing in my drop down menu. I don't want duplicates.
  Here is my code so far.
  php: [Select]

I have an array that looks like this:

 

array(5642) {

[0]=> string(19) "2021-02-10 09:04:48"

[1]=> string(19) "2021-02-10 09:04:54"

[2]=> string(19) "2021-02-10 09:05:00"

[3]=> string(19) "2021-02-10 09:05:06"

[4]=> string(19) "2021-02-10 09:05:12"

[5]=> string(19) "2021-02-10 09:05:18"

[6]=> string(19) "2021-02-10 09:06:18"

[7]=> string(19) "2021-02-10 09:06:24"

}

 

I need to group the instances any time there is more than a 6 second gap between elements. So 0 =>5 would be one array and 6 and 7 would be a new array.

 

Ive been able to produce the following but its not ideal

 

array(5642) {

[0]=> string(19) "2021-02-10 09:04:48"

[1]=> string(19) "2021-02-10 09:04:54"

[2]=> string(19) "2021-02-10 09:05:00"

[3]=> string(19) "2021-02-10 09:05:06"

[4]=> string(19) "2021-02-10 09:05:12"

[5]=> string(19) "2021-02-10 09:05:18"

[6]=> string(19) "end"

[7]=> string(19) "2021-02-10 09:06:18"

[8]=> string(19) "2021-02-10 09:06:24" }

 

$burner_time = array();

foreach($Burner_Control_Alm as $new_burner){ $burner_time[] = strtotime($new_burner); }

$repl = 'end'; for ($i=1; $i<count($burner_time); $i++) { $value_second = $burner_time[$i]; $value_first = $burner_time[$i-1] === $repl ? $burner_time[$i-2] : $burner_time[$i-1]; if ($value_second > $value_first + 6) {

array_splice($burner_time, $i++, 0, $repl);

}

print_r($burner_time);

}

Hi all,

I have a situation where I need to remember what check boxes where checked over pagination, I have managed to do this via the use of this:

http://jamesfunk.com/wordpress/?p=65

The problem is that as the code stood:

Code: [Select]
<input type="checkbox" name="compare" value="<?php echo $list['jobseeker_id'];?>" class="remember_cb"/>
It was treating one ticked checkbox as them all because they all have the same name and are in the a while loop!

I countered this by changing the code to:

Code: [Select]
<input type="checkbox" name="compare<?php echo $list['jobseeker_id']?>" value="<?php echo $list['jobseeker_id'];?>" class="remember_cb"/>
Which effectively now makes the checkbox name unique... i.e. compare{id}.

The problem with this is that I can now no longer process it. This is my processing code:

$jobseekers = $_POST['compare'];
$i = 0;
for($i; $i<count($jobseekers); $i++){
$query = "SELECT * FROM jobseekers WHERE jobseeker_id = '$jobseekers[$i]'";
$result = mysql_query($query) or die (mysql_error());

while ($row = mysql_fetch_array($result)) {
// Spit out the required data
}
}

As you can see I am trying to get the data from $_POST['compare'], which will obviously now be blank as I have had to make the name unique.... the trouble is I'm not sure how to actually process this.

Can anyone help me out here? any help or advice would be greatly appreciated!

many thanks,

Greens85

I have a mysql table which will store users email addresses (each is unique and is the primary field) and a timestamp. 
I have added another column called `'unique_code' (varchar(64), utf8_unicode_ci)`.

What I would very much appreciate assistance with is;

a) Generating a 5 digit alphanumeric code, ie: 5ABH6 
b) Check all rows the 'unique_code' column to ensure it is unique, otherwise re-generate and check again 
c) Insert the uniquely generated 5 digit alphanumeric code into `'unique_code'` column, corresponding to the email address just entered. 
d) display the code on screen.

What code must I put and where?


**My current php is as follows:**

Code: [Select]
    require "includes/connect.php";
   
    $msg = '';
   
    if($_POST['email']){
   
    // Requested with AJAX:
    $ajax = ($_SERVER['HTTP_X_REQUESTED_WITH']  == 'XMLHttpRequest');
   
    try{
    if(!filter_input(INPUT_POST,'email',FILTER_VALIDATE_EMAIL)){
    throw new Exception('Invalid Email!');
    }
   
    $mysqli->query("INSERT INTO coming_soon_emails
    SET email='".$mysqli->real_escape_string($_POST['email'])."'");
   
    if($mysqli->affected_rows != 1){
    throw new Exception('You are already on the notification list.');
    }
   
    if($ajax){
    die('{"status":1}');
    }
   
    $msg = "Thank you!";
   
    }
    catch (Exception $e){
   
    if($ajax){
    die(json_encode(array('error'=>$e->getMessage())));
    }
   
    $msg = $e->getMessage();
    }
    }

Hi im trying to make it so the time says how many hows left, not how many hours past. i have the right idea but it shows a negative number under "$time"

              $hours = number_format(($diffrence / 60 / 60));
              $time = number_format(($hours - 24));

I have a table in my database named order, and i want to count the quantity sold.  i have the basic query already setup like:

Code: [Select]
$sql = "SELECT SQL_CALC_FOUND_ROWS deal.id, deal.title, deal.min_qty, deal.start_date, deal.end_date, deal.status,
deal.secondary, count(o.id) as orders_cnt
FROM deals as deal
LEFT JOIN orders as o on o.d_id = deal.id
WHERE start_date >= '".$beg."' AND start_date <= '".$end."'
GROUP BY o.d_id, deal.id ORDER BY start_date LIMIT ".AwsPager::getCurrentIndex().", ".AwsPager::getLimit();


Which would theoretically work, but in the orders table, there is a column named quantity, and its those numbers that i need to add together and store in the array as orders_cnt.. any clue how i can do that?

ok my code is below but i want to count how many $sname or ['member_name'] there is as if there is 4 or more i want it to add a marquee to it  have that sorted but im having trouble getting it to count can you help me?


$query = "SELECT * FROM `ibf_members` WHERE member_group_id = '4' or member_group_id = '6' or member_group_id = '17' or member_group_id = '18' or mgroup_others = '4' or mgroup_others = '6' or mgroup_others = '17' or mgroup_others = '18' "; 

$result99 = mysql_db_query("pbf99_backup", $query);
$staff1 = mysql_num_rows($result99);
if ($result99) 
{  
while ($r = mysql_fetch_array($result99)) { // Begin while 
$sid = $r["member_id"];
$smgid = $r["member_group_id"];


$query2 = "SELECT * FROM `ibf_sessions` WHERE member_id = '$sid'"; 
$result2 = mysql_db_query("pbf99_backup", $query2); 
if ($result2) 
{  
while ($r2 = mysql_fetch_array($result2)) { // Begin while 
$sname = $r2["member_name"]; 

$query3 = "SELECT * FROM `ibf_groups` where g_id = '$smgid'"; 
$result3 = mysql_db_query("pbf99_backup", $query3); 
if ($result3) 
{  
while ($r3 = mysql_fetch_array($result3)) { // Begin while 
$ssuffix = $r3["suffix"];
$sprefix = $r3["prefix"];

echo "<a href='$host$sid' target='_parent'>$sprefix$sname$ssuffix$stafff</a><br><br>";
}}}}}}

?>

Hiya peeps,

I have a mysql database with a record of all the images a customer uploads on my site, these images are displayed on there account. I can get this to work but the problem I'm facing is I need a minimum of 5 images displayed so if they only upload 2 images for instance I need to detect that and add my "No Image Uploaded" image. But if they have uploaded 5 or more I need to just let them be displayed without adding the "No Image Uploaded" picture.

Does anyone have any ideas as I'm very stuck!

Many thanks

James.

I know how to count the files:
<?php
$dir = $_SERVER[DOCUMENT_ROOT]."/api/sigs/cache/".$i[id]."/";
$files = scandir($dir);
$result = count($files);

printf("$result Signatures Generated");
?> 

But i'm trying to make it so it only counts the files that were modified recently (That Day).

I have a page that displays a list of retail locations (est. 100-150 locations).

I have my layout setup to fit 3 columns side by side. Ex:

<div class="col"></div>
<div class="col"></div>
<div class="col"></div>

.. with the "col" class having a specific width and float: left.

Basically, I want to print out the locations in the column and when a column reaches a certain number of locations, it closes that div and starts a new one and continues printing the rest of the locations.

How would I go about making sure that once a column has reached a certain number of locations, it closes the div and starts the new one?

One more question to ask. I'm trying to do a count of total logins that have happened in the last 5 months including the current one so far.

My users_logins table has the following structu users_id, session_id, login_date(datetime), last_activity(datetime).

What the end result is going to be is:

<tr>
    <td></td>
    <th scope="col"><?php echo date("M", strtotime("-4 month")); ?></th>
    <th scope="col"><?php echo date("M", strtotime("-3 month")); ?></th>
    <th scope="col"><?php echo date("M", strtotime("-2 month")); ?></th>
    <th scope="col"><?php echo date("M", strtotime("-1 month")); ?></th>
    <th scope="col"><?php echo date("M"); ?></th>
</tr>
<tr>
    <th scope="row">Logins</th>
    <td>94</td>
    <td>53</td>
    <td>124</td>
    <td>92</td>
    <td>105</td>
</tr>

Where the first td would be May and the last td would be September. Do I have to do this in 4 separate queries. If so here's what I have for the first query. I'm not sure what woudl go for the WHERE.

$four_months_ago_query = "SELCT COUNT(date_login) FROM users_logins WHERE ? ";

Hello,
I'm creating a program that analyzes information that is exported by another program. That program exports it in this way:
Value1 Value2 Value3 Value4
Value1 Value2...

In order to insert them in the database, I first have to know how many lines are inserted. They get send through HTML post. I already tried:
$lines = explode("\n", $string);
$number_lines = count($lines);

But this always results in 1. How do I fix this?

Regards,
Chris

I am getting the result I expected with ORDER BY/GROUP BY queries WITH a troubling EXCEPTION: the data is being IN ORDER from 0 thru 9, but 10 (which in this test sample is my LARGEST quantity) is being inserted between the ONE and 2 quantity. 
Not sure if this will occur with ALL teen values, as well as hundreds.
The column is a SMALLINT field (not sure if that makes a difference)>
Is there a solution for this situation?