|
PHP - Php Array Concatenate Values
Hello I have an array where i want the join values (not sum) where the date are the same This my array(var_export)
array (
0 =>
array (
0 =>
array (
0 =>
array (
'dataAula' => '2020-09-21',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 4,
),
),
1 =>
array (
1 =>
array (
'dataAula' => '2020-09-22',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 8,
),
),
2 =>
array (
2 =>
array (
'dataAula' => '2020-09-28',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 12,
),
),
3 =>
array (
3 =>
array (
'dataAula' => '2020-09-29',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 16,
),
),
4 =>
array (
4 =>
array (
'dataAula' => '2020-10-06',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 20,
),
),
5 =>
array (
5 =>
array (
'dataAula' => '2020-10-12',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 24,
),
),
6 =>
array (
6 =>
array (
'dataAula' => '2020-10-13',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 28,
),
),
7 =>
array (
7 =>
array (
'dataAula' => '2020-10-19',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 32,
),
),
8 =>
array (
8 =>
array (
'dataAula' => '2020-10-20',
'tempos' => 1,
'tempos2' => 'Terça',
'total' => 33,
),
),
),
1 =>
array (
0 =>
array (
0 =>
array (
'dataAula' => '2020-10-20',
'tempos' => 3,
'tempos2' => 'Segunda',
'total' => 3,
),
),
1 =>
array (
1 =>
array (
'dataAula' => '2020-10-27',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 7,
),
),
2 =>
array (
2 =>
array (
'dataAula' => '2020-11-02',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 11,
),
),
3 =>
array (
3 =>
array (
'dataAula' => '2020-11-03',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 15,
),
),
4 =>
array (
4 =>
array (
'dataAula' => '2020-11-09',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 19,
),
),
5 =>
array (
5 =>
array (
'dataAula' => '2020-11-10',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 23,
),
),
6 =>
array (
6 =>
array (
'dataAula' => '2020-11-16',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 27,
),
),
7 =>
array (
7 =>
array (
'dataAula' => '2020-11-17',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 31,
),
),
8 =>
array (
8 =>
array (
'dataAula' => '2020-11-23',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 35,
),
),
9 =>
array (
9 =>
array (
'dataAula' => '2020-11-24',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 39,
),
),
10 =>
array (
10 =>
array (
'dataAula' => '2020-11-30',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 43,
),
),
11 =>
array (
11 =>
array (
'dataAula' => '2020-12-07',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 47,
),
),
12 =>
array (
12 =>
array (
'dataAula' => '2020-12-14',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 51,
),
),
13 =>
array (
13 =>
array (
'dataAula' => '2020-12-15',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 55,
),
),
14 =>
array (
14 =>
array (
'dataAula' => '2021-01-04',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 59,
),
),
15 =>
array (
15 =>
array (
'dataAula' => '2021-01-05',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 63,
),
),
16 =>
array (
16 =>
array (
'dataAula' => '2021-01-11',
'tempos' => 4,
'tempos2' => 'Segunda',
'total' => 67,
),
),
),
2 =>
array (
0 =>
array (
0 =>
array (
'dataAula' => '2021-01-12',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 4,
),
),
1 =>
array (
1 =>
array (
'dataAula' => '2021-01-18',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 8,
),
),
2 =>
array (
2 =>
array (
'dataAula' => '2021-01-19',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 12,
),
),
3 =>
array (
3 =>
array (
'dataAula' => '2021-01-25',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 16,
),
),
4 =>
array (
4 =>
array (
'dataAula' => '2021-01-26',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 20,
),
),
5 =>
array (
5 =>
array (
'dataAula' => '2021-02-01',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 24,
),
),
6 =>
array (
6 =>
array (
'dataAula' => '2021-02-02',
'tempos' => '4',
'tempos2' => 'Terça',
'total' => 28,
),
),
7 =>
array (
7 =>
array (
'dataAula' => '2021-02-08',
'tempos' => '4',
'tempos2' => 'Segunda',
'total' => 32,
),
),
8 =>
array (
8 =>
array (
'dataAula' => '2021-02-09',
'tempos' => 1,
'tempos2' => 'Terça',
'total' => 33,
),
),
),
)[]
So, for example i have repeated the date 2020-10-20, one with "tempos =1" and another with "tempos=3" I'm looking to have only one date with concatened tempos field Example
array (
'dataAula' => '2020-10-20',
'tempos' => 1+3,
'tempos2' => 'Terça',
'total' => 33,
),
So what i have now is this code but not getting what i need
foreach ($finalCronograma as $sub) {
$row = current($sub);
if (isset($result[$row[0]['dataAula']])) {
$result[$row[0]['dataAula']]['tempos'] .= '+' . $row[0]['tempos'];
} else {
$result[$row[0]['dataAula']] = $sub;
}
}
any help? Similar TutorialsHello, I am trying insert the values of csv file into a table. I want to concatenate the values of some columns of csv into one String column of table by delimiting them my commas. $im="INSERT into TB1 (col1, col2 ) values ('$a[2]','$a[3]')"; $b = ""; $b=".'$a[6]'."||".'$a[7]'."||".'$a[8]'."||".'$a[9]'."; $im1=$im+"UPDATE TB1 set latlng=.'$aline'."; mysql_query($im1) OR die(mysql_error()); I need to enter the value of $a[6] till $a[9] into a string column with delimiters and insert into the column col3 of TB1 with value as $a[4]. I am stuck up here could anyone help me with this issue. Hi all, I'm a first time poster here and I would really appreciate some guidance with my latest php challenge! I've spent the entire day googling and reading and to be honest I think I'm really over my head and need the assistance of someone experienced to advise the best way to go! I have a multi dimensional array that looks like (see below); the array is created by CodeIgniter's database library (the rows returned from a select query) but I think this is a generic PHP question as opposed to having anything to do with CI because it related to working with arrays. I'm wondering how I might go about searching the array below for the key problem_id and a value equal to a variable which I would provide. Then, when it finds an array with a the matching key and variable, it outputs the other values in that part of the array too. For example, using the sample data below. How would you recommend that I search the array for all the arrays that have the key problem_id and the value 3 and then have it output the value of the key problem_update_date and the value of the key problem_update_text. Then keep searching to find the next occurrence? Thanks in advance, as above, I've been searching really hard for the answer and believe i'm over my head! Output of print_r($updates); CI_DB_mysql_result Object ( [conn_id] => Resource id #30 [result_id] => Resource id #35 [result_array] => Array ( ) [result_object] => Array ( ) [current_row] => 0 [num_rows] => 5 [row_data] => ) Output of print_r($updates->result_array()); Array ( [0] => Array ( [problem_update_id] => 1 [problem_id] => 3 [problem_update_date] => 2010-10-01 [problem_update_text] => Some details about a paricular issue [problem_update_active] => 1 ) [1] => Array ( [problem_update_id] => 4 [problem_id] => 3 [problem_update_date] => 2010-10-01 [problem_update_text] => Another update about the problem with an ID of 3 [problem_update_active] => 1 ) [2] => Array ( [problem_update_id] => 5 [problem_id] => 4 [problem_update_date] => 2010-10-12 [problem_update_text] => An update about the problem with an ID of four [problem_update_active] => 1 ) [3] => Array ( [problem_update_id] => 6 [problem_id] => 4 [problem_update_date] => 2010-10-12 [problem_update_text] => An update about the problem with an ID of 6 [problem_update_active] => 1 ) [4] => Array ( [problem_update_id] => 7 [problem_id] => 3 [problem_update_date] => 2010-10-12 [problem_update_text] => Some new update about the problem with the ID of 3 [problem_update_active] => 1 ) ) 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. 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. I have an array created to control the down states of the my buttons in my navigation. Which is working well. This array will have quite a few strings in it before I'm done. I then want to conditionally load a CSS file for all the files in that array with the exception of two, is this possible? In plain in english I want to say If in array apart from these values then load my css file. My array (will have more values when complete) Code: [Select] $otherTitles = array('Product Selector', 'Avon Range', 'Knightsbridge Range', 'Kingston Range' ); My code to load a css file Code: [Select] <?php if (in_array($title, $otherTitles)) { ?> <link rel="stylesheet" type="text/css" href="homepage.css"/> <?php } ?> I want all titles in the otherTitles array to get this CSS file apart from two Product Selector and Avon Range. Thanks Richard I have the following array structu Code: [Select] [0] => Array ( [id] => Array ( [$t] => http://www.google.com/mate/ ) [updated] => Array ( [$t] => 2011-08-31T11:43:05.942Z ) [category] => Array ( [0] => Array ( [scheme] => http://schemas.google.com/g/ [term] => http://schemas.google.com/contact/ ) ) [title] => Array ( [type] => text [$t] => Name ) [link] => Array ( [0] => Array ( [rel] => http://schemas.google.com/contacts/2008/rel#edit-photo [type] => image/* [href] => https://www.google.com/mate/feeds/photos/media/ ) [1] => Array ( [rel] => self [type] => application/atom+xml [href] => https://www.google.com/mate/feeds/contacts ) [2] => Array ( [rel] => edit [type] => application/atom+xml [href] => https://www.google.com/mate/feeds/ ) ) [gd$email] => Array ( [0] => Array ( [rel] => http://schemas.google.com/g/2005#other [address] => email_address@gmail.com [primary] => true ) ) ) I am tried to display name and email address. I am using following method, can anyone tell me is there any better way? Thank u 4u help. NAME $name=( $emp_det[0]['title'][t]); $email =( $emp_det[0]['gdemail'][0][address]); I need to some how pull comma separated images $data[23] from this $data array and then put them into there own array so I can insert them into separate rows in a database. This is the provided array: $data[0] => VIN $data[1] => StockNumber ...(all the other number here) $data[23] => Image_URLs (comma seperated) $data[24] => Equipment // I need something like this (obviously doesn't work?!@#) $delimiter = ","; $img = explode($delimiter, $data[23]); foreach($img as $pic){ $sqlPic = "insert into class_prodimages (pid image rank) values('".$LastId['id']."', '$pic', '".rand(1,20)."')"; } Any help here? Why won't '../stuff.com' concatenate? Code: [Select] <?php echo '<img src="', '../stuff.com'.getUserAvatar($post['username']), "\" class=\"avatar small\" title=\"${displayName}\" alt=\"${displayName}\" />"; ?> I know that usually when we concatenante in PHP we use the period . to concatenate but I have been watching a few videos and they seems to use a comma , instead of .
I didn't know about the comma before and if I didn't hear it wrong the video says both would work just depend on the way you work.
So I tried using comma for testing such as
echo '<pre>' , print_r($var) , '</pre>';which works fine but when I use it in a function for fun such as
function dd($var){
return '<pre>' , print_r($var) , '</pre>';
}
this gives me errors about the comma but if I use period as concatenate the page would not return as html tag <pre>
I know that I can just use var_dump and I tried searching things like difference between , and . in php or something similiar I couldn't find a page to explain the major difference.
Can someone give me a hand? Sorry if this question is too stupid though.
Hello there again!
I have the following construct of array now (schematics):
array[0] array[id] = "1" array[title] = "title" array[1] array[id] = "3" array[title] = "another title"Now what i want to do, is to assign the parent-array keys to the IDs of it's contents. This is what it should look like: array[1] array[id] = "1" array[title] = "title" array[3] array[id] = "3" array[title] = "another title"How do I do that again? I know I did this some years ago, but I can not remember how. I have the variables $cap and $url If the $cap contains any of the strings ".jpg,.JPG,.gif,GIF" I have to concatenate $url.$cap I need to put this inside of a p tag so I can change some properties but everything I've tried doesn't work and just shows nothing.
I've tried this:
printf('<p style="text-align: left; width: 500px;">', htmlspecialchars($fetch['shout'], ENT_QUOTES, 'UTF-8'), '</p>');
This is what I need to be wrapped in p tags:
htmlspecialchars($fetch['shout'], ENT_QUOTES, 'UTF-8');EDIT: I've noticed the code below works but when I style it inside of the tag the text won't show, should I include a CSS file on the PHP file? echo "<p>".htmlspecialchars($fetch['shout'])."</p>\n";EDIT: I just needed to create the CSS for the p tags in the index and it worked perfectly fine. Sorry for the pointless thread. Edited by Alanay, 18 December 2014 - 09:14 AM. First project in php and mysql, I've searched but can't find the answer to stringing together two numbers and a "-" without php giving me the results as it thinks I'm creating an equation. I need the string as text. Example, I need the following as a text string, id_have (INT) and id_have (INT) joined together as id_have-id_want, or, as they will be numbers, 23-45. When I use this; $havewant = $id_have . "-" . $id_have; The result will be $id_have (23) minus $id_want (45), I get -22, not what I'm looking for!!! I need the text string of "23-45" to store in a table. Thanks! This topic has been moved to MySQL Help. http://www.phpfreaks.com/forums/index.php?topic=313826.0 I'm trying to get a php script working to download the latest CNN news podcast each hour. CNN names the file based on the year, month, day, and time. Here's what I'm trying: Code: [Select] <?php $year = date('Y'); $month = date('m'); $day = date('d'); $now = date('Y-m-d-h'); $hour = date('gA'); $hourplus1 = ($hour + 1); $hourminus1 = ($hour - 1); $ampm = date('A'); $url = "http://podcasts.cnn.net/cnn/services/podcasting/newscast/" . "audio/" . "$year" . "/" . "$month" . "/" . "$day" . "/CNN-News-" . "$month" . "-" . "$day" . "-" . "$year" . "-" . "$hourplus1" . "$ampm" . ".mp3"; echo $url; echo system('wget "$url"'); ?> When running from the shell, I get an "http://: invalid hostname" error. The echo of $url looks right...but it won't run from shell. Any ideas? I have the following mysql query: Code: [Select] $lead_query=$this->db->query(" SELECT `first_name`, `last_name` , `state` FROM leads WHERE `lead_id`='$lead_id' "); $this->view->lead_query=$lead_query->fetchALL(); Now when I retrieve the above details I need to return the first_name last_name together(separated as space) and the name of the key as client_name in the array. I need it that way because when i return a json_encode($lead_query), I want to return the first_name.last_name as client_name. Hi, I have this $_POST array coming from a paypal transaction Code: [Select] Array ( [address_city] => San Jose [address_country] => United States [address_country_code] => US [address_name] => Test User [address_state] => CA [address_status] => confirmed [address_street] => 1 Main St [address_zip] => 95131 [business] => test1_biz@gmail.com [charset] => windows-1252 [custom] => [first_name] => Test [item_name1] => Product Name 1 [item_name2] => Product Name 6 [item_name3] => Product Name 8 [item_number1] => 1 [item_number2] => 6 [item_number3] => 8 [last_name] => User [mc_currency] => USD [mc_fee] => 0.82 [mc_gross] => 18.00 [mc_gross_1] => 14.00 [mc_gross_2] => 2.00 [mc_gross_3] => 2.00 [mc_handling] => 0.00 [mc_handling1] => 0.00 [mc_handling2] => 0.00 [mc_handling3] => 0.00 [mc_shipping] => 11.00 [mc_shipping1] => 11.00 [mc_shipping2] => 0.00 [mc_shipping3] => 0.00 [notify_version] => 3.4 [num_cart_items] => 3 [payer_email] => test_biz@gmail.com [payer_id] => TRCLJTHLNCJ7Q [payer_status] => verified [payment_date] => 22:52:56 Jan 27, 2012 PST [payment_fee] => 0.82 [payment_gross] => 18.00 [payment_status] => Completed [payment_type] => instant [protection_eligibility] => Eligible [quantity1] => 1 [quantity2] => 1 [quantity3] => 1 [receiver_email] => test_biz@gmail.com [receiver_id] => 74PV23B8KSK84 [residence_country] => US [tax] => 0.00 [tax1] => 0.00 [tax2] => 0.00 [tax3] => 0.00 [test_ipn] => 1 [transaction_subject] => Shopping CartProduct Name 1Product Name 6Product Name 8 [txn_id] => 7BS85664SB906284D [txn_type] => cart [verify_sign] => AJ2IuqHp8G0lIxhedAqrwRQbv8fVA4-Gum9e7DMZmEWIFrljEwFCJDfP ) 1 as you can see, there are key value pairs like this, Code: [Select] [items_name1] => Product Name 1 [items_name2] => Product Name 2 [items_name3] => Product Name 3 those keys aren't constant, I mean, it came from a shopping cart, so the item name depends on how many items were placed in the shopping cart to be purchased.. now my question is, How to loop to that post array, and get only the item_names plus their corresponding values ?, because I need them and save in a db table I am working in wordpress and things are going good. I made a form, filled it with values and have been able to store those values in a database using a wordpress function. Now my issue is that I want learn how to write them into an array and store them that way. I have been looking at several different ways but can't figure out how to code it. This is my code now Code: [Select] function add_slider_box(){ global $post; $imageurl = get_post_meta( $post->ID, 'imageurl', true ); $imagelink = get_post_meta( $post->ID, 'imagelink', true ); $imagecap = get_post_meta( $post->ID, 'imagecap', true ); ?> <div style="width: 50%" class="sliderbox"> <p><label for="imageurl">Image Url: <br /> <input type="text" class="widefat" id="imageurl" name="imageurl" value="<?php if( $imageurl ) { echo $imageurl; } ?>" /></label></p> <p><label for="imagelink">Image Link: <br /> <input type="text" class="widefat" id="imagelink" name="imagelink" value="<?php if($imagelink) { echo $imagelink; }?>" /></label></p> <p><label for="imagecap">Image Caption: <br /> <input type="text" class="widefat" id="imagecap" name="imagecap" value="<?php if( $imagecap ) { echo $imagecap; } ?>" /></label></p> <button class="remove_slide button-secondary">Remove This Slide</button> </div> <?php } function bigBusiness_save_slider_options($post_id){ global $post; if( $_POST ) { update_post_meta( $post->ID, 'imageurl', $_POST['imageurl'] ); update_post_meta( $post->ID, 'imagelink', $_POST['imagelink']); update_post_meta( $post->ID, 'imagecap', $_POST['imagecap'] ); } } so the update_post_meta function is what is saving the information into the database. How do I put that into an array? I was thinking Code: [Select] foreach($_POST as $slides) $slides[] = array( 'imageurl' => '$_POST['imageurl'], 'imagelink' => $_POST['imagelink'], 'imagecap' => $_POST['imagecap']; ); I have been able to use the data out of the database by creating a function Code: [Select] function get_half_slider_slides() { global $post; $imageurl = get_post_meta( $post->ID, 'imageurl', true ); $imagelink = get_post_meta( $post->ID, 'imagelink', true ); $imagecap = get_post_meta( $post->ID, 'imageurl', true ); return array( $imageurl, $imagelink, $imagecap ); } and then calling that function in my code like this $slide = get_half_slider_slides(); I thought since it returned an array that I would be able to do this $slides['imagelink'] $slides['imageurl'] but it doesn't work. What I am trying to do is populate the nivo-slider ( http://nivo.dev7studios.com ) with images from the database. I have been following a tutorial but since the license on the tutorial doesn't cover reusing the code, I am trying to rewrite it in a way that doesn't violate the license agreement. This code is so far is hacked together but completely different from the tut. Can you help? Thanks I'm trying to split a url into segments so that a url would be stored in an array. Example: A url like this http://localhost/application/blog/view/Test-Blog-Entry/1 Would look like this in an array: Code: [Select] array('blog', 'post', 'Test-Blog-Entry', '1'); It's an MVC url so 'blog' would be controller, 'post', would be method and the last two would be variables. I want to display the variable values of the array. Is there an easy way to do this? |
|||||||