PHP - String Could Not Be Parsed As Xml

I am using this PHP code with a MySQL query.
PHP parses the PHP fine, but the MySQL query is not having any effect on the database. Can anyone see an error in my code? I can't.

$query = "UPDATE `products` set `id` = '".$_POST['id']."' where `id` = '".$_POST['id']."'";

MOD EDIT: Changed PHP manual link tags to [php] . . . [/php] tags.

I'm a new PHP users needing some help. I've got two code snippets that run a CURL post to a syslog server grabbing specific records that I then parse with regex. Both are similar differing in the specific CURL URL and Regex. One works does not. The failing program seems to fail the regex parse creating a null array. What I've done thus far. Tested the regex on regex101 (works fine, using PCRE). Dumped and echoed the CURL created variable and then rechecked against regex101. ( again all good) Created a static variable in the code of the CURL return string (regex works fine). 

So the CURL is working, the variable string is working appearing as expected and the regex works. But the variable feels like's it null when passed directly from the CURL to the regex. No error logs, but this is where I'm stuck I don't know what to pick at next.  Here's a version of the code. Appreciate any thoughts. 

<?php

//DHCP URL Setup
$login = 'testuser';
$password = 'xxxxxxx';
$headers = array( 
                 "Cache-Control: no-cache", 
                );
$url = 'https://xxx.xxx.xxx:8089/services/search/jobs/export';
$post2 = "search=search sourcetype=infoblox:dhcp dhcp_type=DHCPACK \"e4:f8:9c:82:66:8a\" earliest=-7d | head 1";
$chain = "C:\\apps-su\\wamp64\\apps\\phpmyadmin4.9.2\\libraries\\certs\\splunk-syr-edu-chain.pem";
// curl begins
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, 'https://splunk.syr.edu:8089/services/search/jobs/export');
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_FRESH_CONNECT, TRUE);
curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, $post2);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_ANY);
curl_setopt($ch, CURLOPT_USERPWD, "$login:$password");

$str = curl_exec($ch);
curl_close($ch);

// curl steps ends

echo '<p>Match After CURL </p>';
echo '<p>' . $str . '</p>';
echo "<br>";
var_dump ($str)
// Regex Routine

//$str = '_bkt _cd _indextime _kv _raw _serial _si _sourcetype _time dhcp_type host index linecount source sourcetype splunk_server Configuration initialization for /opt/splunk/etc took 17ms when dispatching a search (search ID: 1591198882.902292) Your search was restricted by ( ( index=nat OR index=network OR index=radius ) OR ( source=/data/syslog/security/ipblocker ) ) base lispy: [ AND 66 82 8a 9c dhcpack e4 f8 sourcetype::infoblox:dhcp [ OR index::nat index::network index::radius source::/data/syslog/security/ipblocker ] ] search context: user="testuser", app="search", bs-pathname="/opt/splunk/etc" Your timerange was substituted based on your search string network~978~07708B5A-37B1-4315-8EFA-70B96D12856C 978:118251396 1591198398 1 Jun 3 11:33:15 128.230.100.36 dhcpd[21353]: DHCPACK on 10.1.0.19 to e4:f8:9c:82:66:8a (ITS-NDD-BOA-T01) via bond0 relay bond0 lease-duration 7200 0 its-splunk-idx2.syr.edu network infoblox:dhcp 2020-06-03 11:33:15.000 EDT DHCPACK 128.230.100.36 network 1 /data/syslog/network/dhcp infoblox:dhcp its-splunk-idx2.syr.edu';
$regex2 = '/(DHCPACK on )(?<IP>(((25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)))( to )(?<mac>([0-9A-Fa-f]{2}[:-]){5}([0-9A-Fa-f]{2}))(( \(([^)(]*?)\) via))/';
if (preg_match_all($regex2, $str $matches)) {
    //  regex expression matches 
    echo "<h1>Found a match!</h1>";
    
    echo "<br>";
    echo '<p>Device ' . ' " ' . $matches[13][0] .  ' " ' . ' ( MAC  = ' . $matches[8][0] . ' ) ' .  '  authenticated with IP  = ' . $matches[3][0] .  '</p>';
    echo "<br>";
} else {
    // Regex Does Not Match
        echo "<h1>The regex pattern does not match.<h2>";{
        if (preg_last_error() == PREG_BACKTRACK_LIMIT_ERROR) {
    print 'Backtrack limit was exhausted!';
        } else {
            // some other error_get_last
        echo "<h1>Due to unknown error.<h2>";
        }
}
}
 ?>

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

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!

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
}
}
}
}

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.

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

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

I am looking for a date within larger string, lets say the date is December 4, 2010.
To find it I use pattern and function below:

$Pattern='/[(January|February|March|April|May|June|July|August|September|October|November|December)] \d, \d\d\d\d/i';
preg_match_all($Pattern, $String, $Matches, PREG_OFFSET_CAPTURE, $NumberPosition);

The function finds the dates within the string but to my supprise the result I get in $Matches is: r 4, 2010
What I would like to get is: December 4, 2010 but don't know how it should be fixed. I thought that with the pattern I am using but obviously that is not the case.

Hello guys i am trying to figure out how to fwrite a string for example "Recommended Settings for Service Pack" under "Current Settings for Service Pack: 5.1.2600ServicePack3Build2600". I figure i cant use line number as an argument because the file report may be dynamic so i will need to use Current Settings as an argument. Please guide me if you have any ideas..thanks:) !

auditreport 
table
ServicePackSetting
Service Pack Requirement: Fail
Current Settings for Service Pack: 5.1.2600ServicePack3Build2600   
MajorAuditandAccountPolicies   
Maximum Password Age Requirement: Fail
Current Settings for Maximum Password Age Requirement: 42   
Minimum Password Length: Fail
Current Settings for Minimum Password Length Requirement: 0

 hey guys just a simple one...im trying to replace {$name}  but i dont think ive got the right prefix in the str_replace function...if anyone could tell me where i am going wrong please

$content = str_replace("{/$".$variable."}", $value, $content);
{$name}