PHP - How To Merge Two Xml Files?

i want to preserve the numeric keys.  When i print the array this is the result

Code: [Select]
Array ( [0] => one [1] => two [2] => three )
it should be

Code: [Select]
Array ( [0] => two [1] => one [2] => three )
Code: [Select]
$test1[2] = "one";

$test2[1] = "two";
$test2[3] = "three";

$test = array_merge($test1,$test2);

print_r($test);

How do i solve this?

How can I merge the array, but I keep in mind that I only need to merge userlocation and the usercity arrays.

Current output...

Code: [Select]
Array
(
    [0] => Array
        (
            [0] => userlocation
            [1] => 19
        )

    [1] => Array
        (
            [0] => credentials
            [1] =>
        )

    [2] => Array
        (
            [0] => specialties
            [1] =>
        )

    [3] => Array
        (
            [0] => usercity
            [1] => place1
        )

)

Desired output...
Code: [Select]
Array
(
    [0] => Array
        (
            [0] => userlocation
            [1] => 19
            [2] => usercity
            [3] => place1
        )

    [1] => Array
        (
            [0] => credentials
            [1] =>
        )

    [2] => Array
        (
            [0] => specialties
            [1] =>
        )
)

How can this be done?  The array is dynamic.

For example:

class People{
    var $them = array();
    
    function groupPeople(){
      foreach($this->them as $him){
           echo $him.", ";
      }
   }
}

$people  = new People;
$people->them = array('Harry','Todd');

$people->them = array('Tom','Jerry');
$people->groupPeople(); // result: Tom, Jerry,


I think this code is working. However, I need to merge those array above, array('Harry','Todd') and array('Tom','Jerry') So I can get array('Harry','Todd','Tom','Jerry') and a list of names as a result. Maybe I should use array_merge, but how? A little help would be appreciated.

Thank you in advanced,
ayok

The queries merge ok and results are correct except I get a notice: "Notice: Use of undefined constant UNION - assumed 'UNION' in...." But is UNION a constant or is the context wrong?

$query = $query1." ".UNION." ".$query2;

$result = mysqli_query($dbcon, $query) or die('Error getting data');
$num_rows = mysqli_num_rows($result);

I am using pieces of an array like this:

$data['0'];
$data['2'];
$data['3']; and so on...I think up to around $data['70'];

I need to take the values of $data['29'] through $data['64'] and combine them. (stumped)

On top of that I have to comma separate those now combined values (stumped).

Actuall Code:


$handle = fopen("test.csv", "r");

while (($data = fgetcsv($handle, 5000, ",")) !== FALSE){

            $needed = $data['29'] .", ". $data['30'] .", ".$data['31']; // ALL THE WAY TO $data['65']
        
         }



I know how to do it the long way, could someone help me shorten my work?

Thank you for your help.

Hi.

I have two arrays:

$one =  array('a', 'b', 'c');
$two = array('123', '456', '789');

My desired output is:

$output = array('123a', '123b', '123c', '456a', '456b', '456c', '789a', '789b', '789c' )

How can this be achieved, I have looked into functions such as array_merge() but it doesnt seem to do the job.

Help greatly appreciated!

I'm using a upload class that works with $_FILES, but have a couple of reasons to need the content of php://input:

1) When submitting PDF forms as a complete form, the form is available in php://input.

2) An ajax uploader I'd like to use submits the file making it only available in php://input.

I know I could use an if statement to check $_FILES else php://input, but I'm concerned about security, and being able to identify the filetype, get the size, etc. I'm skipping over some other details, because I need to leave in 5 minutes.

I've not seen any classes that merge the two ( $_FILES and php://input ), and really haven't seen any that are specifically for php://input. Can anyone offer advice or point me in the right direction?

I have a successful select query, where I'm looping and building a row for getting parameters which works correctly

    while ($row = $orderDetailCheck->fetch(PDO::FETCH_ASSOC)) {

                $params = [
                ":INVOICE_NUMBER" => $row["INVOICE_NUMBER"],
                ":CUSTNM" => $row["CUSTNM"],
                ":SELLINGN" => $row["SELLINGN"],
                ":GROUP" => $row["GROUP"],
                ":DTL12" => $row["DTL12"],
                ":DTL13" => $row["DTL13"],
                ":QUANTITY" => $row["QUANTITY"],
                ":COUNT_PLMN_1" => $row["COUNT_PLMN_1"],
                ":LAST_DATE" => $row["LAST_DATE"],
            ];

    }

My issue now is that, for each row, I need to perform two merges because the data from that select is going to be split into two tables in db2. Some values are truly split between the tables but some values are shared between the two. I'm not sure the best way to perform these two merges because if the first one (products table) inserts, then it creates an ID that I need as a foreign key basically, to insert into the orders table. So on insert I need to grab that newly created ID and use it for ```product_id``` in the second merge. If the first merge performs the update when matched, then I need to grab the existing ID for that record so that I can update the proper record in the orders table.

My two merge statements:

    /*products table*/
    MERGE INTO products AS P
        USING(VALUES(

            :GROUP,
            :DTL12,
            :DTL13,
            :CUSTNM,
            :SELLINGN,
            :COUNT_PLMN_1,
            :LAST_DATE

            )
        )

    AS S(GROUP,DTL12,DTL13,CUSTNM,SELLINGN,COUNT_PLMN_1,LAST_DATE)
    ON s.GROUP = p.GROUP and s.DTL12 = p.DTL12 and s.DTL13 = p.DTL13 and s.CUSTNM = p.CUSTNM 

    WHEN MATCHED
        THEN UPDATE SET LAST_DATE = s.LAST_DATE

    WHEN NOT MATCHED
        THEN INSERT VALUES (s.GROUP,s.DTL12,s.DTL13,s.CUSTNM,s.SELLINGN,s.COUNT_PLMN_1,s.LAST_DATE)

    /*ORDERS Table*/
    MERGE INTO ORDERS AS PO
        USING(VALUES(

            /*need foreign key, which is id from products table*/
            :QUANTITY,
            :LAST_DATE,
            :INVOICE_NUMBER
        ))

    AS S(PRODUCT_ID,quantity_ordered,LAST_DATE,invoice_number)
    ON s.PRODUCT_ID = po.id

    WHEN MATCHED
        THEN UPDATE SET LAST_DATE = s.LAST_DATE, quantity_ordered = s.quantity_ordered, invoice_number = s.invoice_number

    WHEN NOT MATCHED
        THEN INSERT VALUES (s.PRODUCT_ID, s.quantity_ordered, s.LAST_DATE, s.invoice_number)

Examples:

If my ROW Returns

    INVOICE  |  CUSTNM  |  SELLINGNUM  |  GROUP  |  DTL12  |  DTL13  |  QUANTITY  |  COUNT_PLMN_1  |  LAST_DATE
    ==================================================================================================================
    1122        123         321         995        1452       12        13              5               '2018-12-14'

Then my insert into products would be 

    products

        ID      |  GROUP  |  DTL12  |  DTL13  |  CUSTNM  |  SELLINGNUM  |  COUNT_PLMN_1  |  LAST_DATE
    ==========================================================================================================
    1                995        1452       12       123         321             5               '2018-12-14'

and my insert to orders:

    ORDERS

    PRODUCT_ID  |  QUANTITY_ORDERED  |  LAST_DATE   |  INVOICE
    ============================================================
    1                       13           '2018-12-14'    1122    

But if my next record matched on my unique qualities with a new invoice, quantity and date

ROW Returns

    INVOICE  |  CUSTNM  |  SELLINGNUM  |  GROUP  |  DTL12  |  DTL13  |  QUANTITY  |  COUNT_PLMN_1  |  LAST_DATE
    ==================================================================================================================
    1133        123         321           995        1452       12        4              5               '2018-12-18'

Then I would update products like so:

    products

        ID      |  GROUP  |  DTL12  |  DTL13  |  CUSTNM  |  SELLINGNUM  |  COUNT_PLMN_1  |  LAST_DATE
    ==========================================================================================================
    1                995        1452       12       123         321             5               '2018-12-18'

and update orders like so:

    ORDERS

    PRODUCT_ID  |  QUANTITY_ORDERED  |  LAST_DATE   |  INVOICE
    ============================================================
    1                       4            '2018-12-18'    1133    

I guess the main question is: How can I get the ID of a record from the products table (whether it's an existing match OR newly created in the merge) and once I get it, how can I use it for the 2nd merge?

I have 2 GD images, one is a JPG, the other is a gd created image.

Code: [Select]
<?php
header("content-type: image/png");

$img = imagecreatefromjpeg("./real/soldier.jpg");

$img2 = imagecreatetruecolor(300, 300);
imagesavealpha($img2, true);
$color = imagecolorallocatealpha($img2, 255, 0, 0, 75);
imagefill($img2, 0, 0, $color);

$final = imagecreatetruecolor(300, 300);
imagecopymerge($final, $img, 0, 0, 0, 0, 300, 300, 100);
imagecopymerge($final, $img2, 0, 0, 0, 0, 300, 300, 100);


imagepng($final, null, 9);
I am trying to place the gd created image (Red image) on top of the other (soldier.jpg), but for some reason I can not figure out why the red is a solid red when I told it to have transparency to it (75).

So basically how do I create images like this with saved alpha?

So basically I have two lines that generate an image from png and then preserve the transparency of said png.
Code: [Select]
$bub1 = imagecreatefrompng ("Energy/$energy1b.png");

imageSaveAlpha($bub1, true);This works by itself when generating just this image.
But when combined with another image:
Code: [Select]
imagecopymerge($image, $bub1, 680, 40, 0, 0, 50, 50, 100);It fills in the back ground around the image and the transparency is not preserved. 
Why is this and how can i fix it?

I have two arrays, as follows:

$array1 = (1, 2, 3);
$array2 = (4, 5, 6);

Is there a function to combine the two without having to do a loop?  I'd like to create:

$array3 = (1, 2, 3, 4, 5, 6);

I have a task that seems to be complex.   Short Description:  currently users of the application I am hired to develop have two steps to do when using the app: 1.  Select a Product Line (A, B, C, D) 2.  Select input parameters for that product line - all product lines have simlar "Main" input parameters, but also each line has its own special features that can be selected. 3.  Selections for that product line are shown - the result is a long table or options for that particular product line.  Things like price, discounts, product specifications, etc.   What the users want now is this: 1.  Select input parameters (not sure how to handle individual product lines special parameters yet) 2.  Selections for all product lines are shown   The code base is legacy code, with code thrown around everywhere.  One idea me and my coworkers have been considering is a complete rewrite, since it will help us with writing tighter code, and do what the customer wants.  But that will also take time, and there is no spec.  The spec is in the code mess.   Another one is I am considering now is a "merge".  Somehow merge the product lines, since we have the separate product modules (A, B, C, D), there must be a way to consider maybe extending one to include the others, or somehow get me to the end result -- allow users to see selections for all product lines.   Do you have any experience, any suggestions on how to do this?  I know this needs details, and details are in my code that you don't see, and most likely won't have the time to read and understand anyway.    But I am looking for any ideas or encouragement though that may help.  And my question is -- is there any kind of procedure or technique or something to deal with the problem I am facing -- merging several separate yet similar modules into one single merged module.  How do I approach this, what are some things that could help, etc.  That's what I'm looking for.

Hi,

Have a question regarding array handling / changes.  I have the below posted array.  I need to consolidation the "categoryId" & "categoryName" where the "id" have the same value e.g. 66, then remove the duplicates but keep the merged data.  The new merged data could be stored under a key e.g.

[categories] => Array (
[categoryId] = 28
     [categoryName] = Game Drive
[1]
      [categoryId] = 29
      [categoryName] = Game Drive

etc.



Code: [Select]
Array
(
    [0] => Array
        (
            [id] => 66
            [name] => Person Name
            [description] => Test Desc
            [webUrl] => www.nish.co.za
            [emailAddress] => abc@abc.co.za
            [telNumber] => 123123
            [provinceId] => 3
            [cityId] => 2
            [creationDate] => 2010-09-27 17:42:55
            [activated] => Y
            [categoryId] => 28
            [provinceName] => Gauteng
            [cityName] => Johannesburg
            [categoryName] => Game Drives
        )

    [1] => Array
        (
            [id] => 66
            [name] => Person Name
            [description] => Test Desc
            [webUrl] => www.nish.co.za
            [emailAddress] => abc@abc.co.za
            [telNumber] => 123123
            [provinceId] => 3
            [cityId] => 2
            [creationDate] => 2010-09-27 17:42:55
            [activated] => Y
            [categoryId] => 29
            [provinceName] => Gauteng
            [cityName] => Johannesburg
            [categoryName] => Nature Reserve
        )

    [2] => Array
        (
            [id] => 66
            [name] => Person Name
            [description] => Test Desc
            [webUrl] => www.nish.co.za
            [emailAddress] => abc@abc.co.za
            [telNumber] => 123123
            [provinceId] => 3
            [cityId] => 2
            [creationDate] => 2010-09-27 17:42:55
            [activated] => Y
            [categoryId] => 34
            [provinceName] => Gauteng
            [cityName] => Johannesburg
            [categoryName] => Rehabilitation Centre
        )

    [3] => Array
        (
            [id] => 65
            [name] => Person Name
            [description] => This is the true test
            [webUrl] => http://www.klil.com
            [emailAddress] => abc@abc.co.za
            [telNumber] => 12311231
            [provinceId] => 3
            [cityId] => 2
            [creationDate] => 2010-09-26 19:33:14
            [activated] => Y
            [categoryId] => 28
            [provinceName] => Gauteng
            [cityName] => Johannesburg
            [categoryName] => Game Drives
        )

    [4] => Array
        (
            [id] => 65
            [name] => Test Multiple Categ
            [description] => This is the true test
            [webUrl] => http://www.klil.com
            [emailAddress] => abc@abc.co.za
            [telNumber] => 12311231
            [provinceId] => 3
            [cityId] => 2
            [creationDate] => 2010-09-26 19:33:14
            [activated] => Y
            [categoryId] => 29
            [provinceName] => Gauteng
            [cityName] => Johannesburg
            [categoryName] => Nature Reserve
        )

    [5] => Array
        (
            [id] => 65
            [name] => Person Name
            [description] => Description Text
            [webUrl] => http://www.test.com
            [emailAddress] => abc@abc.co.za
            [telNumber] => 12311231
            [provinceId] => 3
            [cityId] => 2
            [creationDate] => 2010-09-26 19:33:14
            [activated] => Y
            [categoryId] => 34
            [provinceName] => Gauteng
            [cityName] => Johannesburg
            [categoryName] => Rehabilitation Centre
        )

    [6] => Array
        (
            [id] => 64
            [name] => Person Name
            [description] => Description Text
            [webUrl] => www.tree.com
            [emailAddress] => abc@abc.co.za
            [telNumber] => 1123123123
            [provinceId] => 3
            [cityId] => 1
            [creationDate] => 2010-09-26 12:10:56
            [activated] => Y
            [categoryId] => 28
            [provinceName] => Gauteng
            [cityName] => Alexandra
            [categoryName] => Nature Walks
        )

    [7] => Array
        (
            [id] => 64
            [name] => Person Name
            [description] => Description Text
            [webUrl] => www.tree.com
            [emailAddress] => abc@abc.co.za
            [telNumber] => 1123123123
            [provinceId] => 3
            [cityId] => 1
            [creationDate] => 2010-09-26 12:10:56
            [activated] => Y
            [categoryId] => 29
            [provinceName] => Gauteng
            [cityName] => Alexandra
            [categoryName] => Nature Reserve
        )

    [8] => Array
        (
            [id] => 64
            [name] => Person Name
            [description] => Description Text
            [webUrl] => www.tree.com
            [emailAddress] => abc@abc.co.za
            [telNumber] => 1123123123
            [provinceId] => 3
            [cityId] => 1
            [creationDate] => 2010-09-26 12:10:56
            [activated] => Y
            [categoryId] => 34
            [provinceName] => Gauteng
            [cityName] => Alexandra
            [categoryName] => Rehabilitation Centre
        )

    [9] => Array
        (
            [id] => 63
            [name] => Person Name
            [description] => Description Text
            [webUrl] => www.test.com
            [emailAddress] => abc@abc.co.za
            [telNumber] => 123123
            [provinceId] => 5
            [cityId] => 3
            [creationDate] => 2010-09-26 09:58:41
            [activated] => Y
            [categoryId] => 29
            [provinceName] => Limpopo
            [cityName] => Bandelierkop
            [categoryName] => Nature Reserve
        )
)


Thanks in advance,
Peter

I'd like to merge the following function into my main download page but can't figure out how to do it. I've modified the main download page to do the actual downloads but how to manage making the database entries for each download is the problem. I guess I could use a case statement at the end of download.php to set $l_filename then run the pdo sql code.

mydownloader.php - Currently located in download directory

<?php

$php_scripts = '../../php/';
require $php_scripts . 'PDO_Connection_Select.php';
require $php_scripts . 'GetUserIpAddr.php';
function mydloader($l_filename=NULL)

{
$ip = GetUserIpAddr();
if (!$pdo = PDOConnect("foxclone_data"))
{    
    exit;
}
*/    if( isset( $l_filename ) ) {  
        header('Content-Type: octet-stream');
        header("Content-Disposition: attachment; filename={$l_filename}");
        header('Pragma: no-cache');
        header('Expires: 0');        
        readfile($l_filename);    /*

        $ext = pathinfo($l_filename, PATHINFO_EXTENSION);
        $stmt = $pdo->prepare("INSERT INTO download (address, filename,ip_address) VALUES (?, ?, inet_aton('$ip'))");
        $stmt->execute([$ip, $ext]) ; 

        $test = $pdo->query("SELECT lookup.id FROM lookup WHERE inet_aton('$ip') >= lookup.ipstart AND inet_aton('$ip') <= lookup.ipend");
        $ref = $test->fetchColumn();
        $ref = intval($ref);

        $stmt = $pdo->prepare("UPDATE download SET lookup_id = '$ref' WHERE address = '$ip'");
        $stmt->execute() ;         
      }
        
    else {
        echo "isset failed";
        }  
}
mydloader($_GET["f"]);
exit;

download.php - Currently located in public_html directory of website

  <?PHP require_once("header.php"); ?>
</head>
 <body>
  <?PHP require_once("navbar.php"); ?>

<!--==================================================================== 
                              Download
 =======================================================================-->
<?php
$php_scripts = '../php/';
require $php_scripts . 'PDO_Connection_Select.php';

if (!$pdo = PDOConnect("foxclone_data"))
{    
    exit;
}
   $test = $pdo->query("SELECT filename FROM files WHERE id =1");
   $isoname = $test->fetchColumn();
    
   $test = $pdo->query("SELECT md5 FROM files WHERE id =1");
   $md5file = $test->fetchColumn();

   $test = $pdo->query("SELECT filename FROM files WHERE id =2");
   $pdfname = $test->fetchColumn();

   $test = $pdo->query("SELECT filename FROM files WHERE id =3");
   $debname = $test->fetchColumn();

   $test = $pdo->query("SELECT md5 FROM files WHERE id =3");
   $debmd5 = $test->fetchColumn();

   $test = $pdo->query("SELECT filename FROM files WHERE id =4");
   $srcname = $test->fetchColumn();

   $test = $pdo->query("SELECT md5 FROM files WHERE id =4");
   $srcmd5 = $test->fetchColumn();

   $test = $pdo->query("SELECT filename FROM files WHERE id =5"); 
   $debfile = $test->fetchColumn();
?>

  <div class="head__h1">FoxClone Download Page</div>
    <div class ="download">
          <div class="down__row">
         <div class="down__column" style="background-color:#ddd;">
                <div class="part__head">Get the "<?php echo "{$isoname}";?>"  file (approx. 660MB)</div><br>
                      <a href="download/{$isoname}";?>"><center><img src="images/download.png" style="height:44px; width:144px;"  alt="download iso"> </center></a> <br />                 
            <div class="part__head">The MD5sum is:  <?php echo "{$md5file}";?> </div> <br/>
            
                          <hr>                                           
               <div class="part__head">Read or Download the Installation and Use Instructions </div><br>
               <a href="<?php echo "download/{$pdfname}";?>"><center><img src="images/download.png" style="height:44px; width:144px;" alt="download manual"></center></a><br>                          
                         <hr>
               <div class="part__head">How To Install To A USB/CD</div>
                 <div class="down__text">1. Download the iso file <br />
                                2.<span class="tab">a. If burning to a USB stick use the USB image writer that comes with your distribution. </span> <br />
                     <span class="tab3">b. If burning to a CD, there are many Linux utilities, xfburn is one of the simplest. Install from your software 
manager/centre if not installed.</span>
                 </div>
               
                      <hr>
               <div class="part__head">How To Boot The USB/CD</div>
                 <div class="down__text">At the manufacturer’s splash screen, press the key to get into the boot menu. This key varies across PCs, as an example for a Lenovo Thinkpad it is F12. Consult your user manual to find out what the key is or google. Do not confuse the boot menu with the boot priority order       settings in BIOS. The boot menu is a one time selection for the device to use to boot the PC. It overrides the normal boot priority order. The next time you boot, the PC will revert to the normal boot order. Virtually all BIOSs support this feature, they just do it differently. 
                 </div>
               </div>
                 
            <div class="down__column" style="background-color:#ddd;">                  
               <div class="part__head">Get the "<?php echo "{$debname}";?>" file (approx. 7MB) </div><br>
                  <a href="download/{$debname}";?>"><center><img src="images/download.png" style="height:44px; width:144px;"  alt="download deb file"> </center></center></a> <br />                 
               <div class="part__head">The MD5sum is:  <?php echo "{$debmd5}";?> </div>
                 <div class="down__redtext"><br>WARNING - FOR EXPERT USE ONLY !!!</div>
                   <div class="down__text"><br>This .deb file is designed to be installed on a large USB drive, typically 
                        1TB or greater, that already has an operating system installed and is intended as a backup drive.<b> For more information <a href="/download/deb_file.pdf" style="color:#ff0099">Click Here.</a></b></h3>
                   </div>      
                          <hr>                                 
               <div class="part__head">Get the "<?php echo "{$srcname}";?>" Source file (approx. 6MB) </div><br>
                 <a href="download/{$srcname}";?>"><center><img src="images/download.png" style="height:44px; width:144px;"  alt=""></center> </a> <br>
               <div class="part__head">The MD5sum is:  <?php echo "{$srcmd5}";?> </div>  
                 <div class="down__text"><br />This contains the files used to build Foxclone itself. It is provided to meet the terms of the GNU General Public License.</div>                            
               </div>
            </div>
          </div>


  <?PHP require_once("footer.php"); ?>

Thanks in advance

Edited December 28, 2020 by foxclone