PHP - String Concatenate...

This topic has been moved to MySQL Help.

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

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?

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.

Although I am deciding on the best route to go on this, I was hoping for any feedback or ideas on the best and simplest approach to the below problem:


Here is my table structu

old_code_1
old_code_2

new_code_1
new_code_2

prod_code_1
prod_code_2

Each of the following fields has 5 digits e.g. 00045, 12654, etc.

What I need to achieve is this:

Concatenate each set (of the 3 sets above) data into one variable e.g. old_code_1 + old_code_2 = 0004512654. So old_code_1 & old_code_2 would become a combined data and the same for the othe 2 sets.

Then. Once concatenated, I need to compa prod_code_1+prod_code_2 with old_code_1+old_code_2 and replace prod_code_1+prod_code_2 with new_code_1+new_code_2 where matches are found.

The new_code_1 & 2 are in the same row as the old_code 1 & 2. So the data is in alignment that way for comparison.

Thanks for any insight or suggestions on how to make this happen in the simplest form possible.

Hi,

I am trying to make some adjustments to uploadify.php which comes with the latest version of uploadify (3.0 beta), so that it works with a session variable that stores the login username and adds it to the path for uploads.  Here is uploadify.php as it currently looks:

Code: [Select]
<?php
session_name("MyLogin");
session_start();

$targetFolder = '/songs/' . $_SESSION['name']; // Relative to the root

if (!empty($_FILES)) {
$tempFile = $_FILES['Filedata']['tmp_name'];
$targetPath = $_SERVER['DOCUMENT_ROOT'] . $targetFolder;
$targetFile = rtrim($targetPath,'/') .'/'. $_FILES['Filedata']['name'];

// Validate the file type
$fileTypes = array('m4a','mp3','flac','ogg'); // File extensions
$fileParts = pathinfo($_FILES['Filedata']['name']);

if (in_array($fileParts['extension'],$fileTypes)) {
move_uploaded_file($tempFile,$targetFile);
echo '1';
} else {
echo 'Invalid file type.';
}
}

echo $targetFolder;

?>
I added Code: [Select]
echo $targetFolder; at the bottom so that I could make sure that the string returned was correct, and it is, i.e. '/songs/nick'.  For some reason though, uploads are not going to the correct folder, i.e. the username folder, but instead are going to the parent folder 'songs'.  The folder for username exists, with correct permissions, and when I manually enter Code: [Select]
$targetFolder = '/songs/nick';all works fine.  Which strikes me as rather strange.  I have limited experience of using php, but wonder how if the correct string is returned by the session variable, the upload works differently than with the manually entered string.

Any help would be much appreciated.  It's the last issue with a website that was due to go live 2 days ago!

Thanks,

Nick

This topic has been moved to PHP Regex.

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

Hey there,

Thanks for taking the time to read my thread. My issue is that I can't think of a way to edit a XML file using PHP's XML functionality and then assign the edited contents to a string instead of saving the file. Because my issue is that I have to edit the XML file based upon a string brought from a remote location then give it back to that remote location using a string again, to be exact I am doing it via Linux command line utilizing SSH2.

This is what I managed to complete on my own.


function CheckIVMPConfig($ServerID)
{
global $Panel;

if(is_numeric($ServerID) && $this->IsValidServer($ServerID))
{
// We select the game server that the FTP account was created for.
$Servers = mysql_query("SELECT * FROM control_servers WHERE server_id = '".mysql_real_escape_string($FTPAccount['ftp_server'])."'");
$Server = mysql_fetch_array($Servers);

// Here we select the Box ID that the game server is on.
$Boxs = mysql_query("SELECT * FROM control_machines WHERE machine_id = '".$Server['server_machine']."'");
$Box = mysql_fetch_array($Boxs);

// Now we select the required package for the box.
$Packages = mysql_query("SELECT * FROM control_packages WHERE package_id = '".$Server['server_package']."'");
$Package = mysql_fetch_array($Packages);

// Retrive the file.
$Config = $CProtocol->exec("cat /home/{$Server['server_id']}/{$Package['package_config']}");

$Parse = SimpleXMLElement($Config);

foreach($Parse as $Entry) // loop through our books
{
if($Entry->port != $Server['server_port'])
{
// edit the value
}
else if($Entry->maxplayers > $Server['server_slots'])
{
// edit the value
}
}
}
}

Hello all,

I'm trying to change the end of a javascript call based on the end of the url string. The common part of all the url strings is sobi2Id=, I'm trying to do this with strstr but am having no luck. I'm new to php so my syntax knowledge is terrible!

at the moment i've got

Code: [Select]
<?php

       $url = $_SERVER['REQUEST_URI'];

     $tag = strstr ($url, 'sobi2Id=');

       echo $tag; 
?>
but this returns an unexpected T_STRING, expecting ',' or ';'

Can anyone debug this? I may well be being really silly!

hey guys im trying to find a string inside a string which could be made up of different things eg...

{$test}, {$test1}, {$test2}   
etc (but the varable inside could be called anything hence maybe using regex im not sure?)
is this possible?...i hope you guys understand....thanks

I have the following function, which takes a string with commas in it and attempts remove those commas. The way I have it here is that I use explode to take out the commas, which makes an array, and then iterate through that array to put a string back together without the commas.

function tags_to_sort_by( $sortMeta ) {      
   $sortByArray = explode(",", $sortMeta);
   $sortByCount = count($sortByArray);
   for ($i = 0; $i < $sortByCount; $i++) {
      $sortByString += $sortByArray[$i];
   }
   return $sortByString;
}

What does not work is the following line:
$sortByString += $sortByArray[$i];
Somehow that outputs a 0, which I don't understand. It should output something like: arrayItem1 arrayItem2 array3 etc.

My question is if there either is an easier way to remove the commas from the original string or what I am doing wrong in this line:
$sortByString += $sortByArray[$i];  // I am trying to concatenate each part of the array back into the string.

Thanks a lot for help with this!

In PHP Version 8.0 shows error as :
PHP Fatal error:  Uncaught TypeError: Unsupported operand types: string * string 
String is as under :
$TAXVALUE= round($QNTY*($PRICE- ($PRICE*$DISC/100)),2);

In previous versions of PHP it does not show any error.

Please resolve the issue.

I need to know if a string exists within a string.

I've tried using STRIPOS() but it returns zero or false if what I'm looking for is the first part of the string.

I don't care what function I use, but I need to get a "true" when the needle string is present anywhere in the haystack string, even at location zero.

Is there some way to set up the STRIPOS() statement?

I've tried:


if ((stripos($title, 'needle') > 0 )
if ((stripos($title, 'needle') = true )
and even
if ((stripos($title, 'needle') >= 0 )
which returns true for everything, even when the needle string is NOT present.

Any help appreciated.

thanks,
Tom

Ok... I had typed this post out ONCE already and when I clicked REFRESH IMAGE to get a diff captcha it ERASED MY POST

LMAO this is not my night....


What I need help with is probably more simple then I can even think right now - ive been digging at this for 3 hrs now and im out of time for the night

I have a DB Record storing ID's between PIPES |

when the initial entry is made in DB it stores it like so
|47|      NOTE: the number could be different these are ID's number doesnt matter its just between Pipes

When the second entry is added its added like so

|47||67|

say we have a total of 5 Entries

|47||67||82||55||69|

I need to find ID 82 in that string and it has to be between Pipes
Find 82 in data between | and return that ID 82

I am putting between pipes because the ID's can be duplicate digits in different lengths
so say I have 8 as my ID and down the string i have another id as 88  -- I cant possibly find the correct ID without some sort of seperation character so i used Pipes

soo my end goal is the ability to search and if true or false do action

if ($result == $find_id){
echo "ID is there";
}else{
echo "NOT THERE -- Adding it";
}
Any help is appreciated guys
Thanks
SangrelX