PHP - How To Get Value From Array/string/.../something

Hello,
I'm going to be sending emails to users from a community calendar showing events for the day or a time frame specified elsewhere.  The problem I'm having is turning results of DB query into a string when there are multiple results for the day.  It works just fine with single results.  I understand why it doesn't work but can't figure out how to solve the problem.  Don't worry about the $eventdate as that comes from the same array as the $event_id used to call the array shown below.  I tried foreach and implode but couldn't get it working so I'm starting over and asking for your guidance on how is the best way to pull this off.  Thanks for your help.


Code: [Select]
$getevent = mysql_query("SELECT title, description from ".$conf['tbl']['events']." WHERE event_id=$event_id AND private=0");
WHILE ($gtevent = mysql_fetch_array($getevent)) {
$event_title=$gtevent['title'];
$event_description=$gtevent['description'];

$message="<p><span style=\"font-size:24px\">$event_title</span><br />$eventdate</p><p>$event_description</p>";

}  

Hi all, i have this array

$str = array("apple is red", "banana is yellow", "pineaple is tropical fruit", "coconut is also tropical fruit", "grape is violet");

i want to find string "coconut" inside $str and put the whole string "coconut is also tropical fruit" into variable $coconut.

can i do this?

i don't want to use the this code

Code: [Select]
<?
$coconut = $str[3];
echo "$coconut";
?>

can someone help?

Thank you, Best Regards

Hi,
I know the problem that I am having is related to the change in PHP5 about strings and arrays, however I do not understand why my script is affected. It seems like I am not trying to add more variables to an array. I do not success in order solve the problem.
Help me please:





// Build View Array
    if ($view_result!=false) {
        $i=0;
        while ($view_row =@ mysql_fetch_array($view_result)){
            $i++;
            $view_rows[$i] = $view_row;

            // build view_comments array
            if ($viewcomments=="yes") {
                $sql = "SELECT * FROM blog_comments WHERE nBlogId=".$view_row["nIdCode"]." ORDER BY nIdCode DESC";

                $result = mysql_query($sql,$con);
                if ($result!=false){
                    $j=0;
                    while ($comment_row =@ mysql_fetch_array($result)){
                        $j++;
                        $view_comment_rows[$i][$j] = $comment_row;
                    }
                }
            }
        }
    } else {
        $problem = "2";
    }

    // increment view counter for either the single blog being shown
    // or ALL blogs being shown
//The problem is here   
if ($view_rows[1]["nIdCode"]!="" && strpos($_SERVER["PHP_SELF"],"admin.php")==false){
        if ($viewmode=="single"){
            $blogid = $view_rows[1]["nIdCode"];
            $sql = "UPDATE blog SET nViews=nViews+1 WHERE nIdCode=".$blogid;
        } else {
            for ($i=1;$i<=count($view_rows);$i++){
                $blog_array[$i] = $view_rows[$i]["nIdCode"];
            }
            $blogids = implode(",",$blog_array);
            $sql = "UPDATE blog SET nViews=nViews+1 WHERE nIdCode IN (".$blogids.")";
        }
        $result = mysql_query($sql,$con);
        if ($result==false){
            print "<li>Problem with SQL<br>[".$sql."]</li>\n";
        }
    }
}

Last edited by sbarros (2011-01-08 18:21:52)

How can I get rid of  "Notice:Array to string conversion on line 78" error from this code?  can i get a little help please? 

This is line 78 :         $table .= $columnValue;

Basically this code's supposed to do is to group the values from grpa, grpb of datatb to 4 different categories according to their value. and as end result, category index number  of each category is put into the html table.

Thanks.

 

<?php

 include ("configd.php");

  $sql = "SELECT grpa, grpb From datatb";
  $result = $conn->query($sql);
  
  //categories
  
  $cat = [
    4 => [1, 2, 3, 4],
    3 => [5, 6],
    2 => [7, 8],
    1 => [9, 10]
];
while ($row = $result->fetch_assoc()) {
    foreach ($cat as $catKey => $catValue) {
        $columns[$catKey] = array_filter($row, function ($col) use ($cat, $catKey) {
            if (in_array($col, $cat[$catKey])) {
                return true;
            }
        });
    }

    $output[] = $columns;
}


// the output 

$table = <<<EOT
<table class='maintable'>
    <tr><th>9:10</th></tr>
    <tr><th>7:8</th></tr>
    <tr><th>5:6</th></tr>
    <tr><th>1:4</th></tr>
</table>

EOT;


foreach ($output as $row) {
    $table .= "<table class='maintable'>";

    foreach ($row as $columnKey => $columnValue) {
        $table .= "<tr>";
        $table .= "<td>";
        $table .= $columnValue;
        $table .= "</td>";
    }

    $table .= "</tr>";
    $table .= "</table>";
}




echo $table;

?>

 

Edited June 30, 2020 by mattix
small additions.

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.
 

Hi everybody,

I need some help about how to convert string to array name. I have the following function which pass $_REQUEST type as parameter. It is not working because I don't know how to convert $method to $_GET or $_POST in a proper way. Do anybody know how?

Code: [Select]
function validateIfFilled($method, $fields)
{ 
    $exploded=explode(",",$fields);   
    foreach($exploded as $field){                             
        if(empty($method[trim($field)])){         
          return false;     
        }
    }
    return true;
};

if(!validateIfFilled('$_GET', "email, password, address"))
...
Thank you!

Hello
I am facing a problem which i can not handle. I appreciate for any help.

My Database is:
Code: [Select]
CREATE TABLE IF NOT EXISTS `shops` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `options` text,
  `user_name` varchar(250) NOT NULL ,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_name` (`user_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='user data stored' AUTO_INCREMENT=1 ;
And some sample data as below:
Code: [Select]
INSERT INTO `users` (`id`, `options`, `user_name`) VALUES
(1, 'apple-orange-grape-bmw-toyota-fig-', 'user1'),
(4, 'apple-tomato-pc-notebook-yellow-', 'user2'),
(5, 'blue-green-orange-cdrom-', 'user3'),
(6, 'orange-yellow-blue-pink-bread-', 'user4');
How can i display how many apples or green or any item selected by user?
So far i tried in_array, array_count_values but seems no one is working.

Regards

	<?php
    $srs = array();
    for ($section = 1; $section < 5; $section++) {
        for ($row = $section; $row < 10; $row++) {
            for ($seat = $row; $seat < 20; $seat++) {
                $srs[] = array(
                    'section_name' => $section,
                    'row_name' => $row,
                    'seat_name' => $seat);
            }
        }
    }
	
    output(convert_array($srs));
	// Converts the array
    function convert_array($input)
    {
	        return $input;
    }
	    function output($obj)
    {
        echo "<pre>";
        print_r($obj);
        echo "</pre>";
        die;
    }
?>
	

I'm trying to convert those array number to string, add implode() to make it happen, but seem PHP didn't recognize variable in $input. Like this implode("Section: ", $input) or (Section: ", $srs). Can you help me?

Thanks,

Gary

Edited October 16, 2019 by sigmahokies

I have in ONE MySQL database row a string of ID's like this:

Name of Row: Values: Post IDs 10 14 52 37
And now I want to fetch those ID's explode them (by the space) and then use them as an array, like this:


$array[] = explode(" ", $query);

echo $array[0]; // 10
echo $array[1]; // 14
echo $array[2]; // 52


Is this possible, if yes how can I do this?

I need to assign unknown array keys and their values to strings.

The code I am using is:
Code: [Select]
$cart = $_SESSION['cart'];
$items = explode(',',$cart);
$qty = array();


foreach ($items as $item) {
$qty[$item] = $qty[$item] + 1;
}
print_r($qty);
The keys change and are not ordered. I do not know what the key or it's value may be.  So as an example, I might have:
Code: [Select]
Array ( [2] => 5 [4] => 8 ) or in a different scenario, I might have:
Code: [Select]
Array ( [1] => 6 )
What those numbers represent is a product id (the key), and the quantity (the value of the key).

Can someone help me to assign these to a string?  I have been reading all morning, and not making any progress. 

Thank you!

Hi, I have an array key whose value is a line of html in quotes, the problem is , I don't know how to do it. Lol. Any help greatly appreciated because the below code is generating an error in my editor. Thank you. Derek

here is the line.

Code: [Select]
'level_1'=>"<img src='<img src='sundragon_environments/ocean/ocean1_FRAME.jpg'/>'",
EDIT:

actually I managed to fix the error adding a semicolon after the parenthesis. Is this array correct please?

Code: [Select]
$currentLocation = array
(
'teardrop_ocean_bg' => array
(
'level_1'=>"<img src='<img src='sundragon_environments/ocean/ocean1_FRAME.jpg'/>'"



)

);

it's not finished yet.

I have a variable and it contains a lot of strong data would I want to convert the string data into an array. What's the best way of doing because I know older versions of php will be slightly different?

I want to check if a string has any of words listed in array;
Code: [Select]
$array=array('word1', 'word2', 'word3');
$string="This is a sentence containing word2";
Now I want to make an 'if else' to check if the string contains any of the words listed in the array. Thanks 

hey guys, I apologize, as this stuff should be easy to figure out, but I am getting stumped again being a php rookie.  I have searched a lot for an answer before I bothered you all.  Here's the skinny:  I have a string coming in via post content that looks like:
name1\x1ddata1\x1ename2\x1ddata2\x1e ...
where the delimiters are 0x1e for the field/data pairs and 0x1d between the field/data .  there may be as many as 20 of these pairs in the string.  I have the string and I can store the pairs with explode in an array correctly, I just cant seem to get them all into one array.  it would be even more helpful if the first element of the pairs were the array keys.  Any guidance would be helpful.  Thanks
Code: [Select]
$raw_post_data=file_get_contents("php://input");
$records=explode("\x1e",$raw_post_data,-1);
    foreach($records as $data){
        $pairs=explode("\x1d",$data);}

I am writing a data scraping script but i am getting fatal error.Can someone please help me.

My code:-

Code: [Select]
<?php 
$con = mysql_connect("localhost","root","");
mysql_select_db("cakeshop", $con);
$test = '<form
                name="select"> 
                    <p><font color="#000000" size="3"><select
                    name="city" size="1"
                    onchange="self.location.href=this.options[this.selectedIndex].value"> 
                        
                    
                        <option value="xxxwi.htm">Wisconsin</option> 
                        <option value="xxxwy.htm">Wyoming</option> 
                       
                    </select><br clear="all"> 
                    </font><font color="#000000" size="2">Click
                    on the state below where you want to send
                    cake<br> 
                    or use the pull down menu above </font> 
                </form> ';
preg_match_all('~<option\s+value="(.*?)">(.*?)</option>~', $test, $out);
 
for($i=0;$i<=2;$i++)
{
$data = file_get_contents('http://xxx.com/'.$out[1][$i].'');
preg_match_all('~<option\s+value="(.*?)">(.*?)</option>~', $data, $city); 
//$klimit = sizeof($city);
$klimit = count($city[1]); 
for($k=2 ;$k < $klimit; $k++)
{
$data = file_get_contents('http://xxx.com/'.$city[1][$k].''); //Error on this line
$regex = '~<td\s+colspan="2"\s+width="350"><font\s+size="2">\s+<b>\s+(.*?)  <\/b><br>(.*?) <br>(.*?),\s+(.*?)\s+<br>(.*?), (.*?)\s+<BR><BR><font\s+size="2"><img\s+src="\.\.\/images\/phone1.gif"\s+align="left"\s+hspace="4"\s+alt\s+=(.*)>\s+-\s+Phone\s+#\s+(.*?)\s+<\/font>\s+<BR>\s+<font\s+size\s+="1">~';
preg_match_all($regex, $data, $final);
$jlimit = count($final[1]);
for($j=0 ;$j < $jlimit; $j++)
{
$name = $final[1][$j]; 
$name = mysql_real_escape_string($name);
$address =  $final[2][$j];
$address = mysql_real_escape_string($address);  
$city = $final[3][$j];
$city = mysql_real_escape_string($city); 
$state = $final[4][$j];
$state = mysql_real_escape_string($state); 
$pincode = $final[6][$j];
$pincode = mysql_real_escape_string($pincode); 
$telephone = $final[8][$j];
$telephone = mysql_real_escape_string($telephone); 
mysql_query("INSERT INTO cakeshop (name, address, city, state, pincode, telephone)
VALUES ('$name', '$address', '$city', '$state', '$pincode', '$telephone')");     
}
}
}
mysql_close($con);  
echo "Data scraping completed"; 
?>
Error message :-

Code: [Select]
Fatal error: Cannot use string offset as an array in C:\Users\Booone\AppData\Roaming\NuSphere\PhpED\projects\scraping1.php

Error is on this line "$data = file_get_contents('http://xxx.com/'.$city[1][$k].'');"