PHP - Repeated Assoc Array

Hey all, first post to this site. I'm somewhat new to PHP, so bear with me - this might be an easy question, it might not be. Just looking for a little help.

Basically, I have a query which takes commands from a form through AJAX (day, time, time1). The query executes a wildcard on a table named sip_data, searches for linked $id (so if $id=3, for example in multiple tables, it spits out the $name, $zip in a div).

Here's the code:

Code: [Select]
<?php
$dbhost = "localhost";
$dbuser = "";
$dbpass = "";
$dbname = "";

//Connect to MySQL Server
$link = mysql_connect($dbhost, $dbuser, $dbpass);

//Select Database
mysql_select_db($dbname) or die(mysql_error());

// Retrieve data from Query String
$id = $_GET['id'];
$name = $_GET['name'];
$zip = $_GET['zip'];
$server_url = $_GET['server_url'];
$day = $_GET['day'];
$time = $_GET['time'];
$time1 = $_GET['time1'];

// Escape User Input to help prevent SQL Injection
$id = mysql_real_escape_string($id);
$name = mysql_real_escape_string($name);
$zip = mysql_real_escape_string($zip);
$server_url = mysql_real_escape_string($server_url);
$day = mysql_real_escape_string($day);
$time = mysql_real_escape_string($time);
$time1 = mysql_real_escape_string($time1);
//build query

$query = "SELECT * FROM $day,sip_data WHERE $day.id=sip_data.id AND $day$time<=>$day$time1 ORDER BY zip ASC";

//Execute query
$qry_result = mysql_query($query) or die(('No Results'));

//Build Result String
while($row = mysql_fetch_array($qry_result))

{
echo "<table id=query_result align=left>";
echo "<tr>";
    if($zip = $row[zip]); 
echo "<th><b>$row[zip]</b></th>";
echo "</tr>";
echo "<tr>";
echo "<td><a href=$row[server_url] rel=ajaxDiv>$row[name]</a></td>";
echo "</tr>";
echo "</table>";
}
echo $display_string;




?>





Basically, my issue with this is that some of the results within the sip_data DB will have zip codes that repeat. The current code prints out each results with the zip code and name - here's an image of a sample result:



What I would like to do is avoid repeating the zip code and just group the results under each zip code, kinda like this:

55408           55412        55423
---------     ------------    ----------
example      example       example
example                         example
example

Any help would be greatly appreciated. I feel like I'm so close to the answer, but just need a little guidance. Who knows, I might be way off.

Thanks in advance!

Hello All,   I've encountered one more problem (with the first WebApp I'm building), and I have no idea how to fix it. I've tried something, but it doesn't seem to work, so I'd appreciate some help in getting it fixed.   Here's what's happening:   So after I perform an operation (let's say "ADDing a record")...the records gets added correctly, but then, if/when I press [F5] in my browser window (or click on the Refresh/Reload icon), the same input details are being used and a second identical record is being added. I believe the same thing happens for some (or perhaps all) of the other CRUD operations.   What do I need to do to disable that behavior?   The only thing I could think of is to set the $functionSelected variable to blank ("") - which I've done towards the bottom of my code (shown below) - but that doesn't seem to be doing anything...the problem persists.

if(isset($_POST['action']))

    {                        

        $functionSelected = $_POST["action"];

    }



if(isset($functionSelected)){

    switch($functionSelected){

        case "insert":

            $initialize_flag = "N";

            // Store POST(ed) user-entered values into memory variables

            $store_name = $_POST['store_name'];    

            $item_description = $_POST['item_description'];    

            $qty_pkg = $_POST['qty_pkg'];    

            $pkg_of = $_POST['pkg_of'];    

            $price = $_POST['price'];    

            $flyer_page = $_POST['flyer_page'];    

            $limited_time_sale = $_POST['limited_time_sale'];    

            $flyer_date_start = $_POST['flyer_date_start'];    

            $nos_to_purchase = $_POST['nos_to_purchase'];    

                                    

            // Setup customized query

            $sql = "INSERT INTO shoplist

                        (store_name, item_description, qty_pkg, pkg_of, price, flyer_page, limited_time_sale, flyer_date_start, nos_to_purchase, shopper1_buy_flag, shopper2_buy_flag, purchased_flag, purchase_later_flag)

                    VALUES

                        (:store_name, :item_description, :qty_pkg, :pkg_of, :price, :flyer_page, :limited_time_sale, :flyer_date_start, :nos_to_purchase, :shopper1_buy_flag, :shopper2_buy_flag, :purchased_flag, :purchase_later_flag)";



            try {

                $statement = $conn->prepare($sql);

                                    

                $statement->bindParam(':store_name', $store_name);

                $statement->bindParam(':item_description', $item_description);

                $statement->bindParam(':qty_pkg', $qty_pkg);

                $statement->bindParam(':pkg_of', $pkg_of);

                $statement->bindParam(':price', $price);

                $statement->bindParam(':flyer_page', $flyer_page);

                $statement->bindParam(':limited_time_sale', $limited_time_sale);

                $statement->bindParam(':flyer_date_start', $flyer_date_start);

                $statement->bindParam(':nos_to_purchase', $nos_to_purchase);

                $statement->bindParam(':shopper1_buy_flag', $initialize_flag);

                $statement->bindParam(':shopper2_buy_flag', $initialize_flag);

                $statement->bindParam(':purchased_flag', $initialize_flag);

                $statement->bindParam(':purchase_later_flag', $initialize_flag);                                        



                // Execute the query

                $statement->execute();                            

                $statement->closeCursor();

                $functionSelected = "";     // WILL THIS STATEMENT NOT SERVE TO INITIALIZE/RESET THE OPERATION???

                break;

            } catch (PDOException $e) {

                print "Error!: " . $e->getMessage() . "<br/>";

            }

        case "update-delete":    

            ...

            ...

            ...

Thanks.  

NOTE - Please read the information first as it contains important information to understand the problem.

Rules →

• There are 9 Columns(C1,C2,C3,C4,C5,C6,C7,C8,C9) [ Max columns will be 9]

• The number of Rows can vary from 3,6,9,12,15,18 (Max). In this case Number of Rows shall be 12

Number of Rows = No of Tickets (Max Allowed 6) x Rows Per Ticket (Max Allowed 3). Thus, Max Rows can be 18

• Each Row is required to have 4 Blank Spaces and 5 Filled with Numbers

• All numbers available in the Column Array have to be utilized

• This configuration of an shall create a matrix of 9 Columns & 12 Rows (3 x 4 Tickets), which is 108 MATRIX BLOCKS where only a maximum of 60 numbers can be filled out of 108 available blocksrandomly with the above conditions being met 100%.

• The numbers in column must be arranged / sorted in ASCENDING ORDER (For coding logic purpose, as soon as the number is assigned to the new MATRIX MAP use array_shift() or unset() the number so as to avoid repetition

Example - Row 1 and Column 1 shall generate a MATRIX BLOCK - R1C1

Row 3 and Column 7 shall generate a MATRIX BLOCK - R3C7

Matrix Block can also be termed as Matrix Cell for your ease (if needed)

MASTER SET OF ARRAY WITH NUMBERS

array( "C1"=> array( 1, 2, 3, 5, 6, 7, 9 ), //7 Numbers "C2"=> array( 13, 14, 15, 17, 18, 19 ), //6 Numbers "C3"=> array( 21, 22, 23, 24, 25, 26, 30 ), //7 Numbers "C4"=> array( 31, 33, 34, 36, 37, 38, 39 ), //7 Numbers "C5"=> array( 41, 42, 46, 47, 48, 49, 50 ), //7 Numbers "C6"=> array( 51, 52, 53, 54, 55, 57, 58 ), //7 Numbers "C7"=> array( 61, 62, 64, 65, 69, 70 ), //6 Numbers "C8"=> array( 71, 74, 75, 76, 77, 78 ), //6 Numbers "C9"=> array( 82, 83, 85, 87, 88, 89, 90 ) //7 Numbers );

The above array has 60 Numbers to be filled out of 108 MATRIX BLOCK / CELL which meets the condition that for a FULL BLOCK containing 4 MINI BLOCKS WITH 3 ROWS (max. allowed) EACH

I have been able to generate this without any issue meeting all the conditions of the Columns

My Allocation Matrix Array will look like

array( "R1"=> array( "C1"=> true, // Means that MATRIX BLOCK R1C1 will be NOT EMPTY "C2"=> false, // Means that MATRIX BLOCK R1C2 will be EMPTY "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> false, "C7"=> true, "C8"=> true, "C9"=> false ), "R2"=> array( "C1"=> false, "C2"=> true, "C3"=> false, "C4"=> true, "C5"=> false, "C6"=> true, "C7"=> true, "C8"=> true, "C9"=> false ), "R3"=> array( "C1"=> true, "C2"=> true, "C3"=> true, "C4"=> true, "C5"=> false, "C6"=> false, "C7"=> false, "C8"=> false, "C9"=> true ), "R4"=> array( "C1"=> true, "C2"=> true, "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> false ), "R5"=> array( "C1"=> false, "C2"=> false, "C3"=> false, "C4"=> false, "C5"=> true, "C6"=> true, "C7"=> true, "C8"=> true, "C9"=> true ), "R6"=> array( "C1"=> true, "C2"=> true, "C3"=> false, "C4"=> true, "C5"=> false, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> true ), "R7"=> array( "C1"=> false, "C2"=> false, "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> false, "C7"=> true, "C8"=> true, "C9"=> true ), "R8"=> array( "C1"=> true, "C2"=> false, "C3"=> false, "C4"=> true, "C5"=> false, "C6"=> false, "C7"=> true, "C8"=> true, "C9"=> true ), "R9"=> array( "C1"=> true, "C2"=> false, "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> true ), "R10"=> array( "C1"=> false, "C2"=> true, "C3"=> true, "C4"=> true, "C5"=> true, "C6"=> false, "C7"=> true, "C8"=> false, "C9"=> false ), "R11"=> array( "C1"=> false, "C2"=> true, "C3"=> false, "C4"=> true, "C5"=> true, "C6"=> true, "C7"=> false, "C8"=> true, "C9"=> false ), "R12"=> array( "C1"=> true, "C2"=> false, "C3"=> true, "C4"=> true, "C5"=> false, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> true ) );

In the above array R stands for Row, C for Column, TRUE/FALSE (Boolean) means that if TRUE a Number can be filled in the resulting MATRIX BLOCK / CELL ( Row[Number]Column[Number] ) else if FALSE the MATRIX BLOCK / CELL shall be EMPTY

The result for the above shall be

PROBLEM : 

I am unable to understand what should possibly be the logic & loop used here for creating a MATRIX ALLOCATION MAP as shown above

I have tried while, foreach & for but unable determine the perfect combination which would meet the conditions.

(Tried all of the above with Nested Loops also)

Edited May 1, 2020 by AlphaMike
Tags

hi i am trying to make a payroll calculator script that takes employee info, calculates pay, displays submitted info in a table, stores info in an array, and updates the array when new info is submitted. i have most of these accomplished, i am having trouble with the "store into an array, and update the array when new info is submitted" parts of the project. i am still not very fluent in php so there may be easier ways to achieve what i have so far. any pointers would be a great help, this part has got me stumped.

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 am having some problems getting a query correct. Basically I have two tables, one with listings and another with categories. In the listings table I have a column called shortdescription.

I am trying to pull the shortdescription from the listings table with the query

$shortdesc = array_shift(mysql_fetch_row(mysql_query("select shortdescription from links where category = '".$scat->id."' ")));

The shortdecription display properly on the pages display the listings, however I am getting the following error on any pages that only display the parent categories


Warning: array_shift() [function.array-shift]: The argument should be an array in /home/...path/file.php on line 1462

The listings id numbers begin at 75+ because the initial parent category id ends at 74. The query seems to be searching for listing ids below 75 and spitting out an error because it is not finding them.

Any ideas on how to eliminate this error and/or stop the query from looking for non-existant data?

How can i save array from inputs, witch is $igraci and it have 5 values, to mysql base, i tryed but in mysql it shows Array.
This is form:
        <form action="dodaj_klan.php" method="post" >
            <p>
            <label>Naziv klana:</label>
            <input name="naziv" type="text" size="20%" />
            <label>Web Sajt:</label>
            <input name="website" type="text" size="20%" />
            <label>E-Mail:</label>
            <input name="email" type="text" size="20%" />
            <br /><br />
            <label>Igraci klana(5):</label>
            <input name="lider" type="radio" value="1" />
            <input name="igraci[]" type="text" size="20%" /><br />
            <input name="lider" type="radio" value="2" />
            <input name="igraci[]" type="text" size="20%" /><br />
            <input name="lider" type="radio" value="3" />
            <input name="igraci[]" type="text" size="20%" /><br />
            <input name="lider" type="radio" value="4" />
            <input name="igraci[]" type="text" size="20%" /><br />
            <input name="lider" type="radio" value="5" />
            <input name="igraci[]" type="text" size="20%" />
            <label><i>(obelezi lidera klana)</i></label>
            <br /><br />
            <input class="button" type="submit" name="submit" value="Dodaj" />&nbsp;&nbsp;
            </p>
        </form>
Now i wonna save this igraci[] array in mysql, i tried like this but it doesn't work:
$igraci = $_POST['igraci'];
$query = "INSERT INTO klanovi (naziv, website, email, igraci) VALUES ('{$naziv}', '{$website}', '{$email}', '{$igraci}')";
$result = mysql_query($query, $connection);

How can i do this?
Thanks..

I need a help in the following :
I have an admin page from where the admin attaches an gif image.This attached image should be shown to the user as a scrolling image.
The code for the scrolling image is done through javascript.
So my actual problem is getting the name of the attached gif image to the javascript array which is used for scrolling horizontally.

Hello all,

I have yet again trouble finding a logical solution to my problem.
I'm fetching an array which can hold 1 or more values.
The problem is, I want these values to ouput in my json_encode function, but this also needs to happen dynamically depending on the amount of values.

I can't explain it further, so here's the code so far:

Code: (php) [Select]
$files = mysql_fetch_array($get_files);

$a = count($files);

$i = 1;
while ($files) {
$variablename = 'fileName' . $i;
$$variablename = $files['fileName'];
$i++;
}

$output =  array( OTHER VALUES , 'fileName1' => $fileName1, 'fileName2' => $fileName2, 'fileName3' => $fileName3, ............); // How do I add the fileNames dynamically depending on how many there are?


This got me thinking, I also need to dynamically GET the values with jQuery. How would I do that, when the above eventually works?

Thank you.

I have mysql select query shown below retrieving data from a database:

$sql = "
SELECT 
	student, sum( test_score ) as score
FROM 
	test
INNER JOIN 
	level 
ON 
	test.level_id = level.level_id
GROUP BY 
	student"
$result = $mysqli->query($sql, MYSQLI_STORE_RESULT);
if($result)
{
      while ($row = $result->fetch_array(MYSQLI_ASSOC))
       {
	    var_dump($row);
       }
}

On inspection of the retrieved array with var_dump(), i have these result below:

array (size=2)
  'John' => string 'English' (length=2)
  'Score' => string '20' (length=3)

array (size=2)
  'Mary' => string 'Math' (length=3)
  'Score' => string '35' (length=3)

array (size=2)
  'Samuel' => string 'Physics' (length=3)
  'Score' => string '5' (length=3)

 How do I get at and print out the highest score from this set of array values within this context.
 I tried this echo max($row['count']) but i understandably got this feedback:
Warning: max(): When only one parameter is given, it must be an array   Thanks.

Hi there,

Basic question, but I can't seem to find a page in the PHP docs that answers (though I'm sure such a one exists, I just can't seem to think up the right search terms - anyway)

My question is: is there a short-hand way to use a value from an associative array as the key in another associative array?

So for example, given this array:

$the_array = array(0 => array('name': 'the_name', 'value' : 'the_value'), 1 => etc....);

then this kind of foreach loop doesn't work

Code: [Select]
$new_data = array();
foreach($the_array as $element){
$new_data[$element['name']] = $element['value'];
}

Obviously I can just save out the values, like $name = $element['name'] --- but I was just wondering if there was a more efficient way to do it?

Cheers,

PS. I tried encapsulating with {} - i.e. $new_data[{$element['name']}] --- but that also fails.

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=344127.0

So I'm trying to create an Array from a comma separated string containing array{s}. How can I take a string full of comma separated hex values such as : 

<?php
    $myStr = (
        "00ffff", "00cccc", "009999", 
        "007777", "004444", "001111", 
        "01ffff", "01cccc", "019999"
    );
?>

& turn it into 3 separated arrays like : 

<?php
    $myNewArrs = [
        Array1 ( 3 ), 
        Array2 ( 3 ), 
        Array3 ( 3 ), 
    ];
?>

which REALLY looks like : 

<?php
    $myNewArrs = [
        Array ( "00ffff", "00cccc", "009999" ), 
        Array ( "007777", "004444", "001111" ), 
        Array ( "01ffff", "01cccc", "019999" ), 
    ];
?>

?

Any assistance is most-definitely appreciated!

Thank you & have a great afternoon!

 

 

Edited May 27 by AquariaXI

Hi, I am very new to PHP and apologies if this question has already been answered in another thread.   I am trying to extract the information from one array into another when some search criteria is matched.   Here is an example array ($original): Array ( [ 1234567 ] => Array ( [name] => john ) [ 3456 ] => Array ( [name] => johnny ) [ 45673 ] => Array ( [name] => james ) [ 987 ] => Array ( [name] => jamie ) [ 5628721 ] => Array ( [name] => Simon ))   So if I searched for the string john, jo, joh then the new array ($filtered) should be as follows: Array ( [ 1234567 ] => Array ( [name] => john ) [ 3456 ] => Array ( [name] => johnny ))   I was trying to do this using array_search & preg_match but have been struggling.   Any help would be much appreciated!  

I have a associative array and I need to compare it to a normal array.

Code: [Select]
associative will have anywhere from 2-8 of these
['name']
['color']
['uid']

Code: [Select]
normal array will have anywhere from 1-8 names
['name']

What I need to do is get the name of the people that are in the associative array that are not in the normal array.

I've tried all sorts of different loops and what not and I cant seam to get anything to work in every case.