PHP - Exploding Array And Adding Execution Timestamp For Each Bit Of Data In The Array

I need to explode data separated with text separators, like this:

banana|carrot|salmon|oak|tuna|apple|elm|pineapple

So far so good with this:

<?php
  $items = explode('|', $stuff);
  foreach($items as $key=>$value){
?>


But now I need a list, with categories from another table (column1=items, column2=corresponding categories) and order by categories (not worried about the order of the items under each category), like this:

FISH
   salmon
   tuna
FRUIT
   banana
   apple
   pineapple
TREE
   oak
   elm
VEGETABLE
   carrot

Any suggestions on an approach would be appreciated. I'm foggy about creating arrays, but I think I need one here?

Hello,
I have a variable called $Price, We are getting it through Mysql Database using While loop. We getting the data from database in ordered by ID.
Now then i have requirement to store that data into Low to High form ...

Like we are receiving $price
lke unordered form ..
50
14
35
25
00
145
52

Here i just want to store it in Low to high form like 00, 14,25,35 ... and so on ..
Please suggest me the appropriate code.
While($myrow=mysql_fetch_array($result, MYSQL_ASSOC))
{ 

some codes 


return value $price.  // want to store in array 

}
$array($price) // here want to store in Low to high with key value.

Here's the code:

Code: [Select]
$year_values = array('Any', 'N/A', '2000', '2001', '2002', '2003', '2004', '2005', '2006', '2007', '2008', '2009', '2010', '2011', '2012');
$db_year = explode(', ', $row['YEAR']);

foreach($year_values as $year_value)
{
    $selected_year = null;
    $year_label = $year_value;

    if(in_array($year_value, $db_year))
    {
        $selected_year = ' checked="checked"';
        $year_label = "<b>$year_value</b>";
    }

    echo '<input type="checkbox" name="year" value="' . $year_value . '"' . $selected_year . ' />' . $year_label . ' ';
}
?>
[/code

That pulls the data of the database and puts it in check boxes. The user can check/uncheck certain boxes but  the problem is when it goes to the verify page it has only one value from the array that was selected. On the verify page it just checks if a box was checked and then implodes the array before submitting it into the database.

[code]
$year_s=implode($year,", ");

So like I said there is only one value from the array when there should be as many as the user checks. So basically I believe the value isn't added to the array.

i need help with adding an integer into an array

something like this

$Loaded[count($Loaded)+1] = $To;

from what i understand from the coding... $form->getField('uri') is for the Sql table field (field uri) location and ->getValue() is the inputbox Value so ->setUri is grabbing the inputbox value and inserting it into Field 'uri' but what I need to do is combine getValue with the string/url profile.site.com/file?name=

Code: [Select]
$new_uri
    ->setUri($form->getField('uri')->getValue())
    ->setHost($form->getField('host')->getValue())
    ->setUser($user->isAuthorized() ? $user->getId() : 0)
    ->save();

Hi

I currently pass a URL to our website as follows: http://website.com/?nid=10 but want to extend this to include a keyword from google as well. For example http://website.com/?nid=10&kw={keyword}. However it may not always have a keyword so if it does not it needs to just use the nid array.

This is the current script, how do I go about changing it so that if it just contains a nid and no keyword it will do one search of the array and return the result, and if it does have a nid&keywordod it returns something different.

For example if it had nid=1 it would return 0844 000 0300 and if it had nid=1&kw=help it would return 0844 000 0350

Thats what I am looking to achieve. Is this possible and how do I change the array. I have had a little attempt but not sure what I am doing and just got coding errors.


<?php 
$GLOBALS['ct_get_parameter_name'] = 'nid'; 
$GLOBALS['ct_default_number_id'] = 0; 

// source_id => phone number 
$GLOBALS['numbers'] = array( 
    0 => '0844 000 3000', 
    1 => '0844 000 0300', 
    2 => '0844 000 0301', 
    3 => '0844 000 0302', 
); 
session_start(); 

if (array_key_exists($GLOBALS['ct_get_parameter_name'], $_REQUEST)) 
{ 
    $_SESSION['ct_source'] = $_REQUEST[$GLOBALS['ct_get_parameter_name']]; 
} 

function get_phone_number() 
{ 
    $numbers =& $GLOBALS['numbers']; 
    $default_number_id = $GLOBALS['ct_default_number_id']; 
     
    if (isset($_SESSION['ct_source'])) 
    { 
        if (array_key_exists($_SESSION['ct_source'], $numbers)) 
        { 
            return $numbers[$_SESSION['ct_source']]; 
        } 
        else 
        { 
            // otherwise return first number 
            return $numbers[$default_number_id]; 
        } 
    } 
    else 
    { 
        // return first number 
        return $numbers[$default_number_id]; 
    } 
} 
?> 




Many thanks in advance.

Roy

I've got a site running, and I would like to add up the totals from each location to one number, now I know it can be done, I just don't know how it'll work with my current code (see below)

<table summary="" border="1" width="1100">
<tr>
<td>Date</td>
<!-- <td>Employee</td> -->
<td>Store</td>
<td>Customers</td>
<td>Quotes</td>
<td>Phone Calls</td>
<td>Services In</td>
<td>Services Out</td>
<td>Invoices</td>
<td>Conversion</td>
<td>End of Day</td>
<td>Emails</td>
<td colspan=3>Notes</td>
</tr>
<?
 $x = 1; $y=1; $lastdate=0;
 while ($list = mysql_fetch_assoc($query)) {
$dateadd = $list['dateadd']; $dateb = strtotime($list['dateadd']); $date = date("M j Y", $dateb);$date2 = date("Y-m-d", $dateb); $firstname = $list['firstname'];$lastname = $list['lastname'];$store = $list['store'];$customers = $list['cust'];$sales = $list['sales'];$invoices = $list['invoices'];$sin = $list['servin'];$sout = $list['servout'];$eod = $list['eod']; $phone = $list['phone']; $notes = $list['notes']; $emails = $list['emails'];
if ($store == "1") {$storename = "Broadmead";} elseif  ($store == "2") {$storename = "Duncan";} elseif  ($store == "3") {$storename = "Surrey";} elseif  ($store == "4") {$storename = "Sooke";} elseif  ($store == "5") {$storename = "Nanaimo";} elseif  ($store == "6") {$storename = "Shelbourne";}



?>   <?php if ($lastdate == $date) { ?>

<tr>
<td width="125"><?=$date;?></td>
<!-- <td width="125"><?=$firstname;?> <?=$lastname;?></td> -->
<td width="100"><?=$storename;?></td>
<td width="71"><?=$customers;?></td>
<td width="71"><?=$sales;?></td>
<td width="80"><?=$phone;?></td>
<td width="80"><?=$sin;?></td>
<td width="90"><?=$sout;?></td>
<td width="71"><?=$invoices;?></td>
    <td width="71"><? $convbase = $sout+$sales; if (!$invoices==0 && !$customers==0) {$conv = $invoices / $customers * 100;} else {$conv=0;} echo money_format('%(#1n', $conv) . "\n"; ?>%</td>
<td width="71">$<?echo money_format('%(#1n', $eod) . ""; ?><td>
<td width="71"><?=$emails;?>&nbsp;</td>
<td width="150"><?if (!$notes==NULL){echo $notes;} else {echo "&nbsp;";}?></td>
</tr>
<?php } else { ?>
 <tr>
 <td colspan="9">Daily Total</td>
 <td><?echo money_format('%(#1n', $total) . ""; ?>&nbsp;</td>
 <td colspan="4">&nbsp;</td>
 </tr>
</table> 
<hr width="1100" align="left" color="0000ff">
 
 <table summary="" border="1" width="1100">
<tr>
<td width="125"><?=$date;?></td>
<!-- <td width="125"><?=$firstname;?> <?=$lastname;?></td> -->
<td width="100"><?=$storename;?></td>
<td width="71"><?=$customers;?></td>
<td width="71"><?=$sales;?></td>
<td width="80"><?=$phone;?></td>
<td width="80"><?=$sin;?></td>
<td width="90"><?=$sout;?></td>
<td width="71"><?=$invoices;?></td>
    <td width="71"><? $convbase = $sout+$sales; if (!$invoices==0 && !$customers==0) {$conv = $invoices / $customers * 100;} else {$conv=0;} echo money_format('%(#1n', $conv) . "\n"; ?>%</td>
<td width="71">$<?echo money_format('%(#1n', $eod) . ""; ?><td>
<td width="71"><?=$emails;?>&nbsp;</td>
<td width="150"><?if (!$notes==NULL){echo $notes;} else {echo "&nbsp;";}?></td>
</tr>
<?php } $lastdate = $date;
 } // end while    

?>
</table>

Any help would be appreciated.

Hi, after banging my head against the wall for a while thinking this would be a simple task, I'm discovering that this is more complicated than I thought.

Basically what I have is a link table linking together source_id and subject_id.   For each subject there are multiple sources associated with each.

I had created a basic listing of sources by subject... no problem.   I now need a way of having a form to create an ordered list in a user-specified way.  In other words, I can currently order by id or alphabetically (subject name lives on a different table), but I need the option of choosing the order in which they display.  I added another row to this table called order_by.  No problem again, and I can manage all of this in the database, however I want to create a basic form where I can view sources by subject and then enter a number that I can use for sorting.

I started off looping through each of the entries and the database (with a where), and creating a foreach like so (with the subject_id being grabbed via GET from the URL on a previous script)
Code: [Select]
while($row = mysqli_fetch_array($rs)) {


//update row order
if (isset($_POST['submit']))  {

//get variables, and assign order

$subject_id = $_GET['subject_id'];
$order_by = $_POST['order_by'];
$source_id = $row['source_id'];


//echo 'Order by entered as ' . $order_by . '<br />';

foreach ($_POST['order_by'] as $order_by) {

$qorder = "UPDATE source_subject set order_by = '$order_by'
WHERE source_id = '$source_id'
AND subject_id = '$subject_id'";

mysqli_query($dbc, $qorder)
or die ('could not insert order');

// echo $subject_id . ', ' . $order_by . ', ' . $source_id;
// echo '<br />';
} 
}
else {
$subject_id = $_GET['subject_id'];
$order_by = $row['order_by'];
$source_id = $row['source_id'];

}

And have the line in the form like so:
Code: [Select]
echo '<input type="text" id="order_by" name="order_by[]" size="1" value="'. $order_by .'"/>

(yes I know I didn't escape the input field... it's all stored in an htaccess protected directory;  I will clean it up later once I get it to work)

This, of course, results in every source_id getting the same "order_by" no matter what I put into each field.

I'm thinking that I need to do some sort of foreach where I go through foreach source_id and have it update the "order_by" field for each one, but I must admit I'm not sure how to go about this (the flaws of being self-taught I suppose;  I don't have anyone to go to on this).

I'm hoping someone here can help?

Thanks a ton in advance

I have the following multidimensional array where each sub-array represents quantity[0] and item #[1]:
  Array
(
    => Array
        (
            => 1 [1] => 12113
        )

    [1] => Array
        (
            => 2 [1] => 21200
        )

    [2] => Array
        (
            => 4 [1] => 10200
        )

    [3] => Array
        (
            => 1 [1] => yyyy
        )

    [4] => Array
        (
            => 20 [1] => xxxxx
        )

    [5] => Array
        (
            => 5 [1] => 21200
        )

I'm trying to consolidate like items.  For example I need to create a new array that reflects any duplicate part numbers with a combined quantity.
(ie.
...
=> 7 [1] => 21200
...

Hi im having some trouble when i try to add values to an array from a function. The added value will not stay saved.
fun1 will display both firstname and surname but when i call fun2 after calling fun1 i just get the firstname.

I would like to have it so the array is updated and stays updated untill it is cleared or over written.

Any help with this would be greatly appreciated. i am using codeigniter if that makes any difference.

Thanks



<?php

class Test extends Controller
{
    var $data1 = array(
    'firstname' => 'craig'
    );

    function fun1()
    {
        global $data1;
        $this->data1['surname'] = 'brute';
        echo "<pre>";
        print_r($this->data1);
    }

    function fun2()
    {
        global $data1;
        echo "<pre>";
        print_r($this->data1);
    }

}

I have an array of products. The array has an ID and price. I'd like to know the most efficient way of adding up all the same ID fields in the array.

Code: [Select]
<?php
$items[] = array(
'id' => 1,
'price' => 5.99,
);
$items[] = array(
'id' => 2,
'price' => 1.99,
);
$items[] = array(
'id' => 3,
'price' => 2.40,
);
$items[] = array(
'id' => 2,
'price' => 6.99,
);
$items[] = array(
'id' => 4,
'price' => 8,
);
$items[] = array(
'id' => 2,
'price' => 3,
);
$items[] = array(
'id' => 3,
'price' => 1,
);

function add_like_items($items)
{
//manipulation

return $sums;
}

//$sums would be an array like 
//$sum[1] = 5.99
//$sum[2] = 11.98
//$sum[3] = 3.40
//$sum[4] = 8 

?>
Anybody have suggestions on the best way to go about doing this?

Hey guys:

If I some multi-dimensional arrays, like so:

Code: [Select]


array {

array {
  [0]=>
     "Path1"
  [1]=>
   "10"
}

}

array {

array {
  [0]=>
     "Path2"
  [1]=>
   "16"
}

array {
  [0]=>
     "Path3"
  [1]=>
   "110"
}

}

How can I add all of the values of key 1? I know its a foreach loop,  but I can't figure it out... would it be this?

hello, how would i add the values off all results in the $pamount array?

Code: [Select]
$result2 = mysql_query("SELECT * FROM pobook WHERE jobnumber = '$jobid'");
while($row2 = mysql_fetch_array($result2))
{
$pamount=$row2['amount'];
 
  echo "<tr>";
  echo "<td>" . $pamount . "</td>";
  echo "</tr>";


  echo "<tr>";
  echo "<td>VALUE OF ALL RETURNED $pamount HERE</td>";
  echo "</tr>";

I am trying to add new elements to an empty array using a form and submit button and the code is not adding anything from it. Here is the code I use:

<!DOCTYPE html>
<html>
	<head>
		<title>
			
		</title>
	</head>
	<body>
		<div class="site">
			<div class="menu">
				
			</div>
			<div class="head">
				
			</div>
			<div class="content">
				<form>
					<input type="text" value="" name="add"/><br/>
					<input type="submit" value="Add" name="submit"/>
				</form>
			</div>
			<div class="footer">
				
			</div>
		</div>
	</body>
</html>
<?php
$submit = $_POST["submit"];
$field = $_POST["add"];
$list = array();
if($submit){
	$psh = array_push($list,$field);
	
	echo $list;
}
	
?>

Any idea why is it not working?