PHP - Dynamically Adding Dimensions To An Array Using For Loop

Friends,

I have a PHP script that populates a calendar based on an array as follows:

$days = array(2=>array('javascript:showWhatsOnText(2);','linked-day'),
3=>array('javascript:showWhatsOnText(3);','linked-day'),
4=>array('javascript:showWhatsOnText(4);','linked-day'));
echo generate_calendar(2011, 4, $days, 1, '#');


where, for instance, the 2, 3 4 are the days of the month,

By extracting a series values from a MySQL database how would I generate this array dynamically.
E.g I have startday, startmonth, name and text fields in the database and would need to loop through them all to create the array.

I tried playing around with something like this without any luck:

$queryCat1 = "SELECT * FROM $dbCalendarEvents ORDER BY id ASC"; // WHERE visible = '1'
         $result1 = mysql_query($queryCat1) or die (mysql_error());
         $num1 = mysql_num_rows($result1);
         $i=0;
         $daysArray = array();
         while ($i < $num1) {
            $startday=mysql_result($result1,$i,"startday");
            $startmonth=mysql_result($result1,$i,"startmonth");
            $name=mysql_result($result1,$i,"name");
            $name=mysql_result($result1,$i,"name");
            $copy=mysql_result($result1,$i,"copy");

            $daysArray[$i] = $startday=>array('/weblog/archive/2004/Jan/02','linked-day');
       
            $i++;
         }

Your help is appreciated.

I have a slideshow that I am having to modify for my needs. The data file uses an array and i need this to be dynamic. I need to loop through all images in a directory and create the array. I have the directory being stored in a variable already. Now i just need to loop though all images in that directory to create the array like you see in the below code. You can also see the directory variable at the top. Can someone give me a hand with this please?

Code: [Select]
<?php

echo $slideimagefolder;  //http://localhost:82/images/groupphotos/1/1/

$slides = array(
// --- Start slide list ---



// slide elements
array(
"slidelink" => "http://www.frontpageslideshow.net",
"title" => "Frontpage Slideshow 1.7",
"category" => "About Frontpage Slideshow",
"tagline" => "Image taken from the movie \"Shoot 'em up\"",
"text" => "\"Frontpage SlideShow\" is the most eye-catching way to display your featured articles, stories or even products in your php based website or CMS, like Time.com, Joost.com or Yahoo! Movies do. \"Frontpage SlideShow\" creates an uber-cool slideshow with text snippets laying on top of images. These \"slides\" are being rotated one after the other with a nice fade effect. The slideshow features navigation and play/pause buttons, so the visitor has complete control over the slideshow's \"playback\"! And best of all, Frontpage Slideshow can be skinned!",
"slideimage" => "ao4.jpg"
),

// slide elements
array(
"slidelink" => "http://www.frontpageslideshow.net",
"title" => "Use Frontpage Slideshow on any PHP based site!",
"category" => "About Frontpage Slideshow",
"tagline" => "Image taken from the movie \"The Kingdom\"",
"text" => "JoomlaWorks has developed this modification of Frontpage Slideshow to work on every website that supports PHP as a minimum requirement. We call this modification the \"Static PHP\" version of Frontpage Slideshow. It's ideal for use on non-Joomla!/Mambo websites, like for example your corporate PHP based website or your Wordpress blog or Drupal website! You can obviously use this version on any CMS that is based on PHP!",
"slideimage" => "the_kingdom_20070820114258369.jpg"
),

// slide elements
array(
"slidelink" => "http://www.frontpageslideshow.net/content/view/14/37/",
"title" => "FPSS is Search Engine Friendly!",
"category" => "About Frontpage Slideshow",
"tagline" => "Image taken from the movie \"Invaders\"",
"text" => "Unlike Flash based slideshows, Frontpage Slideshow uses unobtrusive javascript and some CSS wizardry only. The content of the slides is laid out as html code, which means it can be \"read\" by search engines. The proper usage (and order) of h1, h2, p (and more) tags will make sure Google (or any other search engine) regularly \"scans\" your latest/featured items.",
"slideimage" => "TVD_TR_02183_2.jpg"
),

// slide elements (***TIP***: copy this data block and paste it below itself to add more slides)
array(
"slidelink" => "http://www.joomlaworks.gr",
"title" => "About JoomlaWorks",
"category" => "",
"tagline" => "Image taken from the movie \"Transformers\"",
"text" => "JoomlaWorks is a team of professional web designers and developers dedicated to delivering high-quality extensions and templates for Joomla! (the most popular open source Content Management System (CMS) worldwide) and Mambo (award winning CMS). JoomlaWorks has established a solid reputation in the Joomla! & Mambo communities, having developed some of the most popular and innovative free & commercial extensions & templates, since 2006.",
"slideimage" => "2007_transformers_014_1.jpg"
),



// --- End slide list ---
);

?>

I need to fill an array dynamically with all the data in the users table. Any help will be appreciated, thanks!

Using curl_multi, I have loaded up 3 url's and then printed the array.

1) How can I also set a timestamp on output to let me know when each url was run?

2) How can I explode the array to only display the data and timestamp, excluding the text "Array ( =>", "[1] =>", "[2] =>" and " )"? Code

<?php

function multiRequest($data, $options = array()) {

  // array of curl handles
  $curly = array();
  // data to be returned
  $result = array();

  // multi handle
  $mh = curl_multi_init();

  // loop through $data and create curl handles
  // then add them to the multi-handle
  foreach ($data as $id => $d) {

    $curly[$id] = curl_init();

    $url = (is_array($d) && !empty($d['url'])) ? $d['url'] : $d;
    curl_setopt($curly[$id], CURLOPT_URL,            $url);
    curl_setopt($curly[$id], CURLOPT_HEADER,         0);
    curl_setopt($curly[$id], CURLOPT_RETURNTRANSFER, 1);

    // post?
    if (is_array($d)) {
      if (!empty($d['post'])) {
        curl_setopt($curly[$id], CURLOPT_POST,       1);
        curl_setopt($curly[$id], CURLOPT_POSTFIELDS, $d['post']);
      }
    }

    // extra options?
    if (!empty($options)) {
      curl_setopt_array($curly[$id], $options);
    }

    curl_multi_add_handle($mh, $curly[$id]);
  }

  // execute the handles
  $running = null;
  do {
    curl_multi_exec($mh, $running);
  } while($running > 0);

  // get content and remove handles
  foreach($curly as $id => $c) {
    $result[$id] = curl_multi_getcontent($c);
    curl_multi_remove_handle($mh, $c);
  }

  // all done
  curl_multi_close($mh);

  return $result;
}



$data = array(array(),array());

$data[0]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Pearl+Jam&output=json';
$data[1]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Black+Eyed+Peas&output=json';
$data[2]['url']  = 'http://search.yahooapis.com/VideoSearchService/V1/videoSearch?appid=YahooDemo&query=Nirvana&output=json';

$r = multiRequest($data);

print_r($r);

?>

Output

Array ( => Pearl Jam [1] => Black Eyed Peas
        [2] => Nirvana )

Preferred Output

01:00:01 Pearl Jam
01:00:02 Black Eyed Peas
01:00:03 Nirvana

I'm telling it to add 1 each time through the while loop but its not and not sure why.

Code: [Select]
<fieldset class="answerLeg">
        <legend>Edit Poll Answers</legend>
        <?php
        $j = 0;
        while($row2 = mysqli_fetch_array ( $pollAnswersResult, MYSQL_ASSOC )) { 
        ?>
            <div class="field required answers">
                <label for="answer<?php echo ($j + 1)?>">Answer #<?php echo ($j + 1)?></label><input type="text" class="text" name="answer<?php echo ($j + 1)?>" id="answer<?php echo ($j + 1)?>" title="Answer <?php echo ($j + 1)?>" value="<?php echo $row2['answer']; ?>"/>
                <span class="required-icon tooltip" title="Required field - This field is required, it cannot be blank, and must contain something that is different from emptyness in order to be filled in. ">Required</span>     
            </div>
        <?php } ?>
    </fieldset>

hello, i have created a table that desplays perticulars, price per person and number of people. the fees is then calculated by multiplying price per person with number of people. till now everything is good. but the problem is when i try to calculate the total fees.
here is an example to explain you better:
Perticulars Price Per Person Number of people Amount something 10 100 1000 something else 20 100 2000 Total 3000

Code: [Select]
$pert_query = mysql_query ("SELECT * FROM `perticulars` WHERE `invoice` =$invoice") or die(mysql_error());
$i = 1;
$sum = 0 + $_SESSION['sum'];
while($perticulars = mysql_fetch_array($pert_query, MYSQL_ASSOC)) {
?>
<tr>
      <td style="border-collapse: collapse"><div align="center"><?php echo $i;
  $i++; 
   ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['perticulars']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['ppc']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $perticulars['nop']; ?></div></td>
      <td style="border-collapse: collapse"><div align="center">
        <?php $amount = $perticulars['ppc'] * $perticulars['nop']; echo $amount; $_SESSION['sum'] = $sum+$amount;?>
      </div></td>
    </tr><?php 
} ?>
    <tr>
      <td colspan="4" style="border-collapse: collapse"><div align="center">Total</div></td>
      <td style="border-collapse: collapse"><div align="center"><?php echo $sum; ?></div></td>
    </tr>
  </table>
From the above code you can see that i am getting the amount form $amount = $perticulars['ppc'] * $perticulars['nop'];
by this each row has its own amount which i got by multiplying the data from mysql.
the problem is how do i find out the Total. i know i am suppose to add up $amount but how?
i even tired using sessions to store the amount and add the new amount to get total but the problem in using sessions is it messes up my next page, no using session is a very bad idea.

I'm having an issue with building a multidimensional array via a for (....)
the array should look like the example
any help would be much, much appreciated
thanks siouxx
   
array   
["username"] = "steve"
   array
      ["item"] = "12345"
      array
         "model" = "some model"
         "quantity" = "36.2"
         "details"
         array
            0 = "detail 1"
            1 = "detail 2"
            2 = "detail 3"

["username"] = "steve"
   array
      ["item"] = "000257"
      array
         "model" = "some other model"
         "quantity" = "77.8"
         "details"
         array
            0 = "detail 1"
            1 = "detail 2"

["username"] = "bob"
   array
      ["item"] = "45678"
      array
         "model" = "other model"
         "quantity" = "99.5"
         "details"
         array
            0 = "detail 1"
            1 = "detail 2"
            2 = "detail 3"
            3 = "detail 3"

the array return by sql looks like this
Array
(
    => Array
        (
            [id_prod] => 6
            [id_tipo] => CPT
            [marca] => HP
            [modello] => Pavilion p6-200
            [prezzo] => 599.00
            [desc] => Computer da Tavolo
            [chiave] => 32
            [utente] => steve
            [qta] => 1
            [indata] => 2011-10-10 16:32:20
            [dettaglio] => HD 320GB - RAM 4GB - Scheda audio 5.1
        )

    [1] => Array
        (
            [id_prod] => 6
            [id_tipo] => CPT
            [marca] => HP
            [modello] => Pavilion p6-200
            [prezzo] => 599.00
            [desc] => Computer da Tavolo
            [chiave] => 31
            [utente] => steve
            [qta] => 1
            [indata] => 2011-10-10 16:32:20
            [dettaglio] => Intel Core i3-550 (3.20GHz, 4MB L3)

I'm trying to convert a one dimensional array into a multidimensional array by grouping matching parts of the keys, i.e. array('onetwothreefour'=>'value',                 'onetwothreesix'=>'value2') would become array('onetwothree'=>array('four'=>'value',                                              'six'=>'value2'));   Essentially I'm trying to convert XML to YML and have a one dimensional array of the XML with index => value.   I've been staring at it for a while now and have tried a few recursive functions to build it though I've come to a few dead ends and would appreciate any words of wisdom if someone can spot the answer easier than I
Edited by joel24, 23 May 2014 - 09:51 AM.

Hello,

I have a database that contains a column with a int value for number of slots reserved, and what I want to do is fetch the value of each column and add them together to create one whole number. For example, in my database under preserved I have two separate values of 2 and 4.. I would like to take those two values and add them up into 6 through php... here is what I have so far:


$slots = mysql_query("SELECT * FROM treservations WHERE reservation_date='$reservation_date' AND reservation_hour='$reservation_hour'") or die(mysql_error());
while ($row = mysql_fetch_assoc($slots)) {
     $row["preserved"];
}

mysql_free_result($slots);

Any help would be GREATLY appreciated.. if I need to add additional code please let me know. Thank you!

hi i have got the following issues i am using the following code.

Code: [Select]
<?php

//DB CONNECTION

$ROWS = "id,firstname,lastname";

// explode at the comma and insert into an array
$test = explode("," , $ROWS);

//adds array test to the var sam
$sam = array($test);

// querys the database
$new = mysql_query("SELECT * FROM {$DB_TABLE}");

// while loop to loop through selected fields
while ($row = mysql_fetch_array($new)) {

foreach ($sam[0] as $v) {

echo $row[$v] . $DELIMITER . "<br />";

}

}
?>
i get the following results.

834(|)
Steph(|)
Thompson(|)
835(|)
Lucy(|)
kim(|)
836(|)
Iwan(|)
Will(|)
837(|)
Sarah (|)
Good(|)

The problem i have is the br tag where do i put it because i need it to output like this. like it shows in the $ROWS variable above "$ROWS = "id,firstname,lastname";";


834(|)Step(|)Thompson(|)
835(|)Lucy(|)kim(|)
836(|)Iwan(|)Will(|)
837(|)Sarah (|)Good(|)

Where do i add the br tag???

Any Help PLease

Hey guys,

I am trying to input data into a mysql database from data thats been added by a jquery form with cloned fields. It is working however it adds the first row correctly then a blank row and then the rest of the rows correctly

The code is this

$x=0;

do {
$fga=$_POST['ID'.$x.'fga'];
$fgm=$_POST['ID'.$x.'fgm'];
$fta=$_POST['ID'.$x.'fta'];
$ftm=$_POST['ID'.$x.'ftm'];
$tpa=$_POST['ID'.$x.'tpa'];
$tpm=$_POST['ID'.$x.'tpm'];
$fta=$_POST['ID'.$x.'fta'];
$ftm=$_POST['ID'.$x.'ftm'];
$stl=$_POST['ID'.$x.'stl'];
$trb=$_POST['ID'.$x.'trb'];
$ast=$_POST['ID'.$x.'ast'];
$blka=$_POST['ID'.$x.'blka'];
$blkf=$_POST['ID'.$x.'blkf'];
$tovr=$_POST['ID'.$x.'tovr'];

mysql_query("INSERT INTO stats (gameId, fga, fgm, tpa, tpm, fta, ftm, ast, stl, trb, blka, blkf, tovr) VALUES ('$gameId', '$fga', '$fgm', '$tpa', '$tpm', '$fta', '$ftm', '$ast', '$stl', '$trb', '$blka', '$blkf', '$tovr')")or die("<div class='errmsg'>Insert Error: ".mysql_error()."</div><br /> \n");

$x++;

Can anyone see what ive done wrong?

Thanks

Hi,

I have a database with some rows. in each row there is a number such as: 0.0023 or 0.0135...

I have the following code to loop though them and add the numbers up but it always returns 0?

Code: [Select]
$sql="SELECT * FROM tickets WHERE `round` = '$round' AND `confirmed` = 'yes' ORDER BY id ASC";
$result=mysql_query($sql);
$row=mysql_fetch_array($result);

while($row = mysql_fetch_array( $result )) {
   $balance = $balance + $row['amount'];
}

mysql_query("update pupils set record='running' where pid !='$testing[0]' 

Hope someone can help, I am trying to add up all the values of a variable in a PHP while loop and have tried several approaches but none seem to work. Hopefully someone can point out what the correct method is.

I've set up some code to pull the pay rate from a MySQL table, and then calculate that person's earnings based on the amount of time they spend on a particular job. That works fine:

           while ($row = $getrate->fetch_assoc()) {

              $staffrate = $row["Rate"];

              $earnings = ($staffrate/3600) * $jobeventtimeseconds;

              $earningsformatted = number_format($earnings, 2);

           }

However there may be a number of jobs for different people with different rates, so I want to add all of these up and output the total. So for example if I had values of 125.00, 35.50 and 22.75 I want to show 183.25 as the total.

So I tried a few things I found on forums on the subject:

$totalearnings = 0;

foreach($earningsformatted as $key => $value) {

   $totalearnings += $value;

}

echo $totalearnings;

That didn't work so I tried another method that someone suggested:

$total=array($earningsformatted);

echo array_sum($total);

The 2nd method outputted just the last individual value, the 1st method didn't work at all. Does anyone have a working method that can be used to do this?

Thanks

Hi I have currently written some code which uses of the Twitter API and extracts the information required to display my most current tweet on my website. This is all working perfectly but at the minute it is only displaying one tweet and I would like it to display as many as the variable $limit is set to.

I have tried numerous count with while loops but just cannot seem to get my head around the logic of it.

Here is the code im currently using which displays one tweet.


            <?php

$username = "my_twitter_username";
$limit = "2";
$twitter_url = "http://twitter.com/statuses/user_timeline/$username.xml?count=$limit";

$buffer = file_get_contents($twitter_url);
$xml = new SimpleXMLElement($buffer);

$status_item = $xml -> status;
$status_id = $xml -> status -> id;
$user_item = $xml -> status -> user;
$user_id = $xml -> status -> user -> screen_name;
$description =  $status_item -> text;
$status_time =  $status_item -> created_at;
$status_img = $user_item -> profile_image_url;

$description = preg_replace("#(^|[\n ])([\w]+?://[\w]+[^ \"\n\r\t< ]*)#", "\\1<a href=\"\\2\" target=\"_blank\">\\2</a>", $description);
        $description = preg_replace("#(^|[\n ])((www|ftp)\.[^ \"\t\n\r< ]*)#", "\\1<a href=\"http://\\2\" target=\"_blank\">\\2</a>", $description);
        $description = preg_replace("/@(\w+)/", "<a href=\"http://www.twitter.com/\\1\" target=\"_blank\">@\\1</a>", $description);
        $description = preg_replace("/#(\w+)/", "<a href=\"http://search.twitter.com/search?q=%23\\1\" target=\"_blank\">#\\1</a>", $description);

echo "
<div class='tweet-wrapper'>
<div class='tweet-img'>
<a href='http://www.twitter.com/la__academia' target='_BLANK'><img src='$status_img' alt='La Academia Twitter' style='width:30px height:30px;' /></a>
</div><!-- tweet-img -->
<div class='tweet-text'>
<p class='tweet-p'>$description</p>
<p class='tweet-time'>$status_time . <a href='http://twitter.com/?status=@$user_id%20&in_reply_to_status_id=$status_id&in_reply_to=$user_id' target='_BLANK' class='tweet-reply'>Reply</a></p>
</div><!-- tweet-text -->
<div class='cleaner'></div>
</div><!-- tweet-wrapper -->
";

?>

Thanks for any help.