PHP - Print Array Of Results

If I wanted to print a string that contains a variable that also contains an array, how would I do so? I want to put the resulting echo into a log file.

Example: “These are the books: $userArray and these are the pages: $pagesArray”;

With just an array, I can use print_r($array, true) to get an array formatted for use in a string (which works well for my purposes) but this doesn’t work with two arrays unless I do this manually. (Such as setting the $user_array = print_r($userArray). But I want to write a function that will take a string, potentially containing arrays  (as variables), and interpolate/make them legible for  humans. (Some of the arrays are also multidimensional.)

But it looks like I can't even concatenate a string and an array. $string = $string . $array. gives an error, array to string conversion.


I don’t understand PHP very well so please explain what is going on here. and the best way to record something like the Example above.
 

You can ignore my previous thread: Xpath help. I made it needlessly complicated!

Here's my problem:

My array $selected contains:
Array 
( 
[0] => SimpleXMLElement Object 
( 
[@attributes] => Array 
( 
[buildingName] => EiffelTower 
[code] => lM 
[type] => building 
) 
[requiredLevel] => 5 
[cost] => 5000 
[built] => 03/31/1889 
[storageType => SimpleXMLElement Object 
( 
[@attributes] => Array 
( 
[itemClass] => EiffelTower_construct 
) 
) 
[defaultItem] => SimpleXMLElement Object 
( 
[@attributes] => Array 
( 
[amount] => 1 
[name] => iron 
) 
) 
[finishedReward] => iron 
[image] => Array 
( 
[0] => SimpleXMLElement Object 
( 
[@attributes] => Array 
( 
[loadClass] => mc 
[name] => construct_0 
[url] => /buildings/eiffel_tower.swf 
) 
) 
[1] => SimpleXMLElement Object 
( 
[@attributes] => Array 
( 
[loadClass] => mc 
[name] => construct_1 
[url] => /buildings/eiffel_tower.swf 
) 
) 
[2] => SimpleXMLElement Object 
( 
[@attributes] => Array 
( 
[loadClass] => mc 
[name] => built_0 
[url] => /buildings/eiffel_tower.swf 
) 
) 
[3] => SimpleXMLElement Object 
( 
[@attributes] => Array 
( 
[name] => icon 
[url] => buildings/eiffel_tower.png 
) 
) 
[4] => SimpleXMLElement Object 
( 
[@attributes] => Array 
( 
[name] => startIcon 
[url] => /buildings/eiffel_tower.png 
) 
) 
[5] => SimpleXMLElement Object 
( 
[@attributes] => Array 
( 
[name] => halfIcon 
[url] => /buildings/eiffel_tower.png 
) 
) 
[6] => SimpleXMLElement Object 
( 
[@attributes] => Array 
( 
[name] => completeIcon 
[url] => /buildings/eiffel_tower.png 
) 
) 
) 
[constructionUI] => /buildings/Construct_eiffel_tower.swf 
[countryCard] => france 
)
)

I have the following code:
echo "<td>".$selected[0]['name']."</td>";
echo "<td>".$selected[0]['code']."</td>";
echo "<td>".$selected[0]['type']."</td>";
echo "<td>".$selected['requiredLevel']."</td>";

This line of that code does not work:
echo "<td>".$selected['requiredLevel']."</td>";

I've tried:
echo "<td>".$selected[0]['requiredLevel']."</td>";
which also does not work.

Can anyone help me figure out why?[/code]

Hi all


This is probably the easiest question ever , but I am not familiar with arrays , so hope somebody can help me


User post this checkbox form (array):

<input type="checkbox" name="type[0][]" value="1" >
<input type="checkbox" name="type[0][]" value="2" >
<input type="checkbox" name="type[0][]" value="3" >

I need to get all checked values and print them ...
How can I do this?


I tried the code below, but it only returns me one value

Code: [Select]

$values = array($_POST["type"]);

foreach ($values as $item){

     echo $item;

}



Any help???



Thanks!!

Dear all, 

Kindly help with this code I have written, it is not returning the array I created. It is a very small script but I have been looking for a very long time but I couldn't see why it went wrong.

$duration = 2;
$start='01-01-2019';
$month =date('n', strtotime($start));
$year =date('Y', strtotime($start));
$mon = 12-$month+1;
$remainingMonth = $duration*12;

$years_arr = array("$year");
$residue_arr = array("$remainingMonth");
$years_arr = process($remainingMonth,$year,$mon,$years_arr,$residue_arr);

print_r($years_arr); //<output

function process($remainingMonth,$year,$mon,$years_arr,$residue_arr){
    $residue = $remainingMonth - $mon;//$D$18-D20
    if($residue != 0){
        $new_year = $year+1;
        array_push($years_arr, $new_year);
        array_push($residue_arr, $residue);
        
        if($residue > 12 ){
            $mon = 12;
        } else {
            $mon = $residue;
        }
        echo "<br>";
        process($residue,$new_year,$mon,$years_arr,$residue_arr);
    } else {
        print_r($years_arr);
        return $years_arr;
    }
}//end of process(..)

The objective is to add a year to the $years_arr array and then print it put, yet I notice that nothing get's printed out. Please assist, if you need more info from my side, please do ask. Thank you very much in advance.

I am trying to break down an array to make it easier to read. An array that looks like Array ( => 0 [1] => 0 [2] => 0 [3] => 0012844 1 [4] => 37 [5] => 1 etc...) I want to display it like: Code: [Select]
[0] => 0
[1] => 0
[2] => 0
etc...
how can this be accomplished.

[ Newbie Alert ]   
Hi

i have an array of 39 arrays. Only 5 are shown below so that you have an idea before i ask my question.

<?
array(39) 
{
 [0]=> array(3) { [0]=> string(18) "unit name 1" [1]=> string(9) "category name 1" [2]=> string(20) "Course 1" }

 [1]=> array(3) { [0]=> string(54) "unit name 2" [1]=> string(15) "category name 2" [2]=> string(20) "Course 1" }
 
[2]=> array(3) { [0]=> string(29) "unit name 3" [1]=> string(15) "category name 2" [2]=> string(20) "Course 1" } 

[3]=> array(3) { [0]=> string(64) "unit name 4" [1]=> string(30) "category name 3" [2]=> string(20) "Course 2" }

[4]=> array(3) { [0]=> string(57) "unit name 5" [1]=> string(24) "category name 1" [2]=> string(20) "Course 1" }

[5]=> array(3) { [0]=> string(50) "unit name 6" [1]=> string(24) "category name 4" [2]=> string(20) "Course 2" }
}


i want a php solution to print category names in table headers , unit names in table rows and course name(s) in table caption.I have tried foreach loop but how to remove duplicate entries as you can see category name 1 and 2 will become two separate headers instead of one and same is the case with Course 1 and 2.
i have googled but could'nt find any solution. i don't want to remove duplicate entries , all i want to display them once in a table as described above.

Hi the above title explains it all.How to output a post array which has been given input using forms.I know you can do it my echo but what about print()
Thanks

Hello,   I am fairly new to PHP and I found some php code to print an array of numbers that create a combination - however, its slams all the numbers together without a space or a comma separator.   How can I separate the numbers in this array with the given code?  Ive attached a photo of the code.

 

 

 

 

Hi there i have an array that catches all appropriate records from my database and selects a random row which is then outputted as a hyperlink.

Code: [Select]
$colname_Class3 = "3";
$colname_Ships3 = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_Ships3 = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_Ships3 = sprintf("SELECT * FROM ships WHERE PlayerName = %s AND Class=%s AND Template='1'", GetSQLValueString($colname_Ships3, "text"),
GetSQLValueString($colname_Class3, "int"));
$Ships3 = mysql_query($query_Ships3, $swb) or die(mysql_error());
$totalRows_Ships3 = mysql_num_rows($Ships3);

$count = 0;
while ($row = mysql_fetch_assoc($Ships3)){
$array[$count]['ShipID'] = $row['ShipID'];
$array[$count]['ShipName'] = $row['ShipName'];
$array[$count]['Class'] = $row['Class'];
$count++;
}

$total3 = count($array3);
$random3 = rand(0,$total3 - 1);
$random_ship3 = $array3[$random3];
$ShipID3 = $random_ship3['ShipID'];
$url3 = '<a href="add_ship.php?recordID='.$ShipID3.'">Test3</a>';
echo '<span style="color: #009900">';
echo $url3;}

This all worked fine until i added another similar query:
Code: [Select]
$colname_Class4 = "4";
$colname_Ships4 = "-1";
if (isset($_SESSION['MM_Username'])) {
  $colname_Ships4 = (get_magic_quotes_gpc()) ? $_SESSION['MM_Username'] : addslashes($_SESSION['MM_Username']);
}
mysql_select_db($database_swb, $swb);
$query_Ships4 = sprintf("SELECT * FROM ships WHERE PlayerName = %s AND Class=%s AND Template='1'", GetSQLValueString($colname_Ships4, "text"),
GetSQLValueString($colname_Class4, "int"));
$Ships4 = mysql_query($query_Ships4, $swb) or die(mysql_error());
$totalRows_Ships4 = mysql_num_rows($Ships4);

$count = 0;
while ($row = mysql_fetch_assoc($Ships4)){
$array[$count]['ShipID'] = $row['ShipID'];
$array[$count]['ShipName'] = $row['ShipName'];
$array[$count]['Class'] = $row['Class'];
$count++;
}

$total4 = count($array4);
$random4 = rand(0,$total4 - 1);
$random_ship4 = $array4[$random4];
$ShipID4 = $random_ship4['ShipID'];
$url4 = '<a href="add_ship.php?recordID='.$ShipID4.'">Test4</a>';
echo $url4;}

On first look it seems fine, however once the page is refreshed the parsed recordID's both become the same number,
e.g: Test3 recordID 8 Test4 recordID 24
then after refreshed: Test3 recordID 24 Test4 recordID 24

Is there anything wrong with my code??

Thanks

How do I access objects inside an array of database results? I have a method that returns MySQL results as an array "$projects". Running print_r($projects) gives me this:

array(1) (
    "projects" => object Database_MySQL_Result(6) {
        protected _internal_row => integer 0
        protected _query => string(875) "SELECT [skipping remainder of long query]"
        protected _result => resource(mysql result)
        protected _total_rows => integer 53
        protected _current_row => integer 0
        protected _as_object => string(13) "Model_Project"
    }
)

If I do this: foreach($projects as $project)
{
   echo $project->PROJECT_NAME;
}

I get "Undefined property: Database_MySQL_Result::$PROJECT_NAME"

If I do this:

foreach($projects as $project)
{
   echo $project[0];
}

the browser will display projects.id for the first returned row *only*

echo $project[1] returns the project.id for the second row only. And so on.

Each returned row contains over a dozen cells.

It's almost as if I'm referring to the array incorrectly, or referring to the wrong array. I feel as though I'm making a very simple (and perhaps dumb) mistake here, but can't quite figure out what it is. Thanks.

I'm having trouble getting all of the results out of a query array, as it is I only get the first result and nothing else.
Here's the basic code I'm working with:
Code: [Select]
$query = "SELECT data_txt FROM jos_servicedirectory_fields_data WHERE fieldid = 19 AND itemid = $item->itemid";
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
$listtags = $row['data_txt'];
$tags = "$listtags,&nbsp;";

$title = "<div class='servicedirectoryItemTitle'><table class=\"sdlistingitemtitle\" cellspacing=\"5\"><tbody><tr>$listingimage<td style=\"vertical-align:top;width:690px;\">$listingbasicicon<span class=\"$listingtitleclass\">$listinglogo<a href=\"{$href}\" {$onClick} title=\"{$item->title}\">{$item->title}</a></span><br /><span class=\"listingdescription\">$listingdescription</span></td><td style=\"vertical-align:top;\">$featuredribbon$moreinfobasic</td></tr></tbody></table><div class=\"listingbottom\">Tags:<span class=\"listingtags\">  $tags </span></div></div>"; }

I've also tried using a foreach loop thinking that would pop all of the results but I end up not getting anything at all then. I'm guessing I'm setting the foreach loop up wrong. Here's how I'm trying to do it:
Code: [Select]
foreach($listtags as $value) {
$tags = $value;
}

Does it have something to do with sticking the $tags variable in the $title variable? I wouldn't think that would matter, but the strange thing is I use this exact same query in a different part of this component and just echo it directly and it works fine.

//First I'm assigning a $variable ($emailzipmatch) to query a database table called(repzipcodes) and having it pull and display 1 to 3 records based on matching up a customer's zip code (RepZipCode = $CustomerZipMatch) with 1 to 3 other people (GROUP BY RepId HAVING COUNT(1) <= 3") that want that customer's information from that particular zip code. <This code works fine>

// CODE WORKS BELOW
Code: [Select]
<?php
    $emailzipmatch = mysql_query("SELECT * FROM repzipcodes WHERE RepZipCode = $CustomerZipMatch GROUP BY RepId HAVING COUNT(1) <= 3") or die(mysql_error());

    $recipients = array();
    while($row = mysql_fetch_array($emailzipmatch)) 
    { 
    $recipients[] = $row['RepEmail'];

    echo "Agent's Email Address: ";
 
    echo 'font color="#FF7600"',$row['RepEmail'], '/font';
 
    echo '<br />'; 

    echo "Rep's ID: "; 
    echo '<br />';
    echo 'font color="#FF7600"',$row['RepId'], '/font';
    echo '<br />';
    echo 'hr align="left" width="50%" size="2" /';
    }


//MY PROBLEM BELOW

// For the NEXT step of the process above I would take $row['RepEmail'] and $row['RepId'] which can have 1 to 3 results and assign the 1 to 3 results a new $variable so it can be inserted into a different db table so I can track the results of the query ($emailzipmatch = ) from the top of the page: ie..

    <New Variable>   <Listed from above>
    $SentRepId 0   = RepId (results from above echo area)
    $SentRepId 1   = RepId (results from above echo area)
    $SentRepId 2   = RepId (results from above echo area)


// Below I'd like to insert the above results into a new database

    $?Variable??? = mysql_query("INSERT INTO sentemail 
   (SentRepId0, SentRepId1, SentRepId2,SentDateTime
   ) VALUES (
   '$_SESSION[RepId]', // ?????
   '$_SESSION[RepId]', // ?????
   '$_SESSION[RepId]', // ?????
    NOW()
     )") or die(mysql_error());

Thank ahead of time for any help you guys can give me. Please respond with ANY question if my coding or request isn't clear or if I've been confusing due to my lack of experience with PHP and MySQL.


MOD EDIT: code tags added.

I am writing a CRON job that will execute daily.  First it will identify from a MySql table the date in a field 'FAPforSale_repost35'  If the date is the today date it will then execute commands to delete photo images in a directory, delete the directory, and finally remove the record from the database.   I am on step one which is to build the array of records that match the days date.  When I run the code, there are no errors but I am not getting results even though the records in the test table are set for today.  Below is the select

<?php

 define( "DIR", "../zabp_employee_benefits_processor_filesSm/", true );
 
 require( '../zipconfig.php' );
 require( DIR . 'lib/db.class.php' );
 require_once( $_SERVER['DOCUMENT_ROOT'] . '/_ZABP_merchants/configRecognition.php' );
 require_once( $_SERVER['DOCUMENT_ROOT'] . '/_ZABP_merchants/libRecognition/MailClass.inc' );
 
 
 
$todayRepost35 = date("Y-m-d");
echo $todayRepost35;



function repostEndSelect()
 
      {
        
        global $db;
            
    $this->db = $db;
        
            
     $data = $this->db->searchQuery( "SELECT `FAPforSale_IDnumber`,  `FAPforSale_image1`,  `FAPforSale_image2`,  `FAPforSale_image3`,  `FAPforSale_repost35`  FROM  `FAP_forSaleTest` Where `FAPforSale_repost35` = '$todayRepost35' ");
    
    
         $this->FAPforSale_IDnumber = $data[0]['FAPforSale_IDnumber'];
        $this->FAPforSale_image1 = $data[0]['FAPforSale_image1'];
        $this->FAPforSale_image2 = $data[0]['FAPforSale_image2'];
        $this->FAPforSale_image3 = $data[0]['FAPforSale_image3'];
        $this->FAPforSale_repost35 = $data[0]['FAPforSale_repost35'];
        
        echo $this->FAPforSale_IDnumber;
        echo $this->FAPforSale_image1;
        echo $this->FAPforSale_image2;
        echo $this->FAPforSale_image3;
        echo $this->FAPforSale_repost35;
        
    } // ends function...
        
echo( ' Finished...' );

?>

Thanks in advance for any suggestions or direction.  Chapter two will be when I start testing the commands to delete.

I am running a script to retrieve numerical value from a webpage, the script echoes the numbers. However I need to add all the numbers to an array or txt file and then have them sorted from highest value to lowest value. Any hints or tips to how I would achieve this?

I can't get the COUNT of the matching results? Please help.


$SomeVar = myname;
$queryU =  "SELECT * FROM adxone WHERE username = '".$SomeVar."'";
$resultU = mysql_query($queryU);
while($scoreP = mysql_fetch_array($resultU))
{
$scoreP['roundzAa'];
$scoreP['roundzAb'];
$scoreP['roundzAc'];
$scoreP['roundzAd'];
$scoreP['roundzAe'];
$scoreP['roundzAf'];
$scoreP['roundzAg'];
$scoreP['roundzAh'];
}


$WinV = 'resultA';
$query =  "SELECT * FROM acs WHERE resultx = '".$WinV."'";
$result = mysql_query($query);
while($scoreUsr = mysql_fetch_array($result))
{
$scoreUsr = $scoreM1['winxa'];  
$scoreUsr = $scoreM1['winxb']; 
$scoreUsr = $scoreM1['winxc']; 
$scoreUsr = $scoreM1['winxd']; 
$scoreUsr = $scoreM1['winxe']; 
$scoreUsr = $scoreM1['winxf']; 
$scoreUsr = $scoreM1['winxg']; 
$scoreUsr = $scoreM1['winxh']; 
}

$count1 = count( array_intersect($resultU, $result) );
echo($count1);

mysql_query("UPDATE comp SET id=$count1 WHERE username = '".$SomeVar."'");
?>