Tag: arrays

PHP – Multiple OR operators in if statement

I am working with getters and setters within my Symfony project. I have to use if() statement to check if status field does not have specific values before changing other field. Code: I defined constants and also using OR operator. I was wondering if there is more elegant solution than this. Maybe is_array() …

Showing duplicate keys in associative array in PHP

arrays php reference

I have an array of numbers: [Note: $arrNum is dynamic. It’s created using rand(). So every time the values will be different. It’s not fixed values.] Now there’ll will be an associative array named $arrNumDouble. The key of $arrNumDouble is the value of $arrNum and the value corresponding to…

Add the results from a PHP array into a SQL Select for each Result to be procesed

arrays mysql php

I am a newbie so I want to know if what I am asking is possible. I have a SQl Select query that returns a While loop and I convert the results (peoples names)to a php Array. In a another SQL Query …

How to display a column of data when the parent variable might not be declared?

arrays codeigniter conditional-operator null-coalescing-operator php

I am generating some dynamic content in the view layer of my codeigniter project. The trouble is, I am getting the following error in my ternary expression: Parse error: syntax error, unexpected token “foreach” How can I display the looped category_name data separated by <br/> tags without g…

How can i reformat array this array?

arrays php

So i have this database table From that table i want to achievie this (My Expected result) I don’t know the best way to handle this, so for now i create two query. My first query SELECT * FROM ( …

From database via join to REST how does it work?

arrays mariadb mysql php

I have a database with two tables (orders & orderProducts) with 1:n-Relation. I would like to combine this two tables to give a JSON to my REST-Tool. For this I have the following SQL-Query: $…

How to display unique results from an array with two conditions

arrays database php unique

In $data I have the following values: Result I want unique results for id and id_orders. I want 3 out of these 9 results. I have tried this, but it helps on one id_orders condition. PHP code Do you know how it can be different to make it work for two? Answer You can do it by keeping track of

Get JSON value which change everytime using php

arrays json php

I have a JSON file { “status”: “ok”, “data”: { “files”: { “4d7cc5ec-2aef-48ec-9ebf-f811d4c77a5d”: { “mimetype”: “…

How to change this array into keys and values

arrays multidimensional-array php

I have this array… [ [ [ “name” => “Initials” “value” => “ROR” ], [ “name” => “Awards” “value” =&…

foreach array wise multi SQL query not working in PHP

arrays foreach pdo php sql

I am trying to execute multiple queries with the multiple selected checkbox value-wise in PHP. I am facing trouble that my code is executing only one checkbox value-wise query and the rest is denied. I checked on StackOverflow about this issue and I got lots of threads about foreach loop but in my case, it is…