PHP - Problem Calling Objects Parsed From 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.

Hi all

I have a question about how to store parsed data into a multidimensional arrays -- I can store items into an array, but multidimensional arrays mystify me a bit.  Any help would be greatly appreciated. 

I'm storing the images in a table, grouped according to their table and their descriptions, so that later when I call the images, I can display them accordingly. I'm using the Simple HTML DOM Parser.  So say I have two tables, one with three images, and another with one.  I'd like the resulting to array to look like:

Code: [Select]
Array
(
    [0] => Array
        (
            [0] => image1.jpg
            [1] => 1st Variation Description
        )

    [1] => Array
        (
            [0] => image2.jpg
            [1] => image3.jpg
            [2] => image4.jpg
            [3] => 2nd Variation Description
        )

)

This is what I have so far:
Code: [Select]
$html = str_get_html($vartables);   
$varinfo = array();
foreach($html->find('table') as $table){
        $varinfo[] = $table->innertext;
}
print_r($varinfo);

Which yields:

Code: [Select]
Array
(
    [0] =>
 <tr>
  <td width=150>
Description1
 </td>

 <td><a href="image1.jpg">
<img src="image1" height=100 border=1></a>
  </td>
 </tr>

    [1] =>
 <tr>
  <td width=150>
Description2
  </td>

<td><a href="image2.jpg">
<img src="image2.jpg" height=200 border=1></a>
  </td>
  <td><a href="image3.jpg">
<img src="image3.jpg" height=200 border=1></a>

  </td>
 <td><a href="image4.jpg">
<img src="image4.jpg" height=200 border=1></a>
  </td>
 </tr>

)

I'd like to strip out the html and keep the .jpg's and descriptions together in a multidimensional array...unfortunately my newbness is getting the better of me there, I'm researching but running into a roadblock.  Thanks in advance for any help.

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,

Using arabic characters,

I have a project, in the admin panel, where i am trying to change the value in the text box(ajax) on onblur js function.
Firefox simply working great but i am getting square brackets in the text box in the browser ie.

I simply guessing the value from the text box is not in the form of utf-8 encoding, i am calling the external javascript file, this is the code am using..

Code: [Select]
// JavaScript Document



var xmlhttp;
//function namechange(name_fieldvalue)


function namechange(name_fieldvalue,name_fieldname,id_val,id_fieldname,table_name)
{
/*
alert(name_fieldvalue);

alert(name_fieldname);
alert(id_val);
alert(id_fieldname);
alert(table_name);
*/

if (name_fieldvalue.length==0)
  {
  document.getElementById("txtHint").innerHTML="";
  return;
  }
xmlhttp=GetXmlHttpObject();
if (xmlhttp==null)
  {
  alert ("Your browser does not support XMLHTTP!");
  return;
  }
var url="ajax_namechange.php";
url=url+"?name_fieldvalue="+name_fieldvalue;
url=url+"&name_fieldname="+name_fieldname;
url=url+"&id_val="+id_val;
url=url+"&id_fieldname="+id_fieldname;
url=url+"&table_name="+table_name;
xmlhttp.onreadystatechange=stateChanged;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}



function stateChanged()
{
if (xmlhttp.readyState==4)
  {
  document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
  }
}



function GetXmlHttpObject()
{
if (window.XMLHttpRequest)
  {
  // code for IE7+, Firefox, Chrome, Opera, Safari
  return new XMLHttpRequest();
  }
if (window.ActiveXObject)
  {
  // code for IE6, IE5
  return new ActiveXObject("Microsoft.XMLHTTP");
  }
return null;
}





Anyone has the idea on this, please help me.

Thanks,


 

I have the following three tables (and also delta_point and hist_point which are purposely left out and just mentioned for context).  Before going down the Doctrine ORM long curvy road, aggrType was just used to restrict possible values so that I didn't need to use MySQL's ENUM, but now I am thinking there may be value to making it an entity and include some methods (and a second reason because I still can't figure out how to make Doctrine create a FK constraint yet not populate the parent entity with a AggrType object).

point
-id (int PK)
-data
-dType /* descriminator.  Options are AggregatePoint, DeltaPoint, and HistoricPoint */

aggr_point
-id (int PK, FK to point)
-aggrType (char FK to aggrType)
-data

aggrType
-type (char PK) /* there are about five types */

I have a service to create a new point based on the provided desired type and user data.  I don't like the switch statement to determine which type of point to create, but don't know a better way.  Also my entity is responsible to provide the appropriate validation rules for the given point type which might not be considered proper but it seems to work for me.  Any constructive criticism is welcomed.

<?php
namespace NotionCommotion\PointMapper\Api\Point;
use NotionCommotion\PointMapper\Domain\Entity\Point;
class PointService
{
    public function create(string $type, array $params):integer {
        $class=[
            'aggr'=>'AggregatePoint',
            'delta'=>'DeltaPoint',
            'hist'=>'HistoricPoint',
        ][$type];
        //$class='Point\\'.$class;  //This doesn't seem to be possible and I needed to use the fully qualifed name without the short cut used namespace.
        $class='\\Greenbean\Datalogger\Domain\Entity\Point\\'.$class;
        $point=new $class();
        $validator=$this->getValidator($point);
        $params=$validator->sanitize($params);
        $validator->validate($params);
        $point->setAccount($this->account);
        $point->populate($params, $this->em); //Will be addressed later
        $this->em->persist($point);
        $this->em->flush();
        $point->setIdPublic($this->em->getRepository(Point\Point::class)->getPublicId($point->getId()));
        return $point->getIdPublic();
    }
}

Now, this is the part I am struggling with the most.  I only have one service to create any type of point, so I do wish to put a bunch of if/thens in it and instead move logic to the individual point type being created.  The AggrPoint in question requires a sub-point and I don't think it is appropriate to inject the entity manager into a point entity and as an alternative solution find an existing point which is associated with the account which resides in the new AggrPoint.  Maybe not appropriate, but it works.  This type of point also has a sub-object AggrType as discussed at the very beginning of this post, so I first attempt to create a new one from scratch, but that doesn't work and I need to set $aggrType with an existing one.  As an alternative, I passed the entity the entity manager, but as stated I think this is a bad idea.

Any recommendations where to go from here?  Thank you

namespace NotionCommotion\PointMapper\Domain\Entity\Point;
class AggregatePoint extends Point
{
    public function populate(array $params, \Doctrine\ORM\EntityManager $em):\NotionCommotion\PointMapper\Domain\Entity\Entity{
        $criteria = \Doctrine\Common\Collections\Criteria::create()
        ->where(\Doctrine\Common\Collections\Criteria::expr()->eq("id_public", $params['pointId']));
        if(!$subpoint = $this->getAccount()->getPoints()->matching($criteria)->current()){
            throw new \Exception("Invalid subpoint ID $params[pointId]");
        }
        $this->setSubpoint($subpoint);

        //This won't work since I must use an existing AggregateType and not create a new one
        $aggrType=new AggregateType();
        $aggrType->setType($params['aggrType']);

        //This just seems wrong and I shouldn't be passing the entity manager to an entity
        $aggrType=$em->getRepository(AggregateType::class)->findOneBy(['type'=>$params['aggrType']]);

        $this->setAggregateType($aggrType);

        unset($params['pointId'], $params['aggrType']);
        // parent::populate($params) not shown, but it basically calles appropriate setters based on the property name
        return parent::populate($params);
    }

    public function getValidatorRules():array
    {
        return $this->filesToArr(['/point/base.json', '/point/aggr.json']);
    }

}

 

 

My script has 3 classes (that are relevant to this discussion): DB, User and Validate. They are all in independent files and loaded automatically, when required, by an autoloader.
Both the User class and the Validate class have a private variable $_db which is instantiated by their class constructor: $this->_db = DB::getInstance();
At the top of the script I declare new instances: $user = new User(); and $validate = new Validate();
I then call a method in $user: $found = $user->findInUsers ( .... )
From within the findInUsers method I then want to call the query method in the DB class. My problem is that I can't find a way to do this that works.
I have tried $this->_db->query( ... ), $_db->query( ... ), but neither works.

The error messages I am getting a
An error occurred in script '/srv/http/classes/User.php' on line 42: Undefined variable $_db
Uncaught Error: Call to a member function query() on null in /srv/http/classes/User.php:42

Any pointers as to what I am doing wrong, or what I should be doing, would be most welcome.

Hi I am new to PHP and I need to create an array and add both books to the array and than loop through the array this is where I am having trouble if the price of a book is less than $20.00 output the book’s name and price if the book’s title comes after the letter R in the alphabet output the book’s title.

I am getting these error:

Notice: Trying to get property 'price' of non-object in C:\xampp\htdocs\PHP objects\books.php on line 45

Notice: Trying to get property 'title' of non-object in C:\xampp\htdocs\PHP objects\books.php on line 49

Notice: Trying to get property 'price' of non-object in C:\xampp\htdocs\PHP objects\books.php on line 50

Fatal error: Uncaught Error: Call to a member function get_first_char() on string in C:\xampp\htdocs\PHP objects\books.php:52 Stack trace: #0 {main} thrown in C:\xampp\htdocs\PHP objects\books.php on line 52

My code is:

<?php
class Book {
  // Properties
  public $price;
  public $title;
  public function get_first_char() {
    $titleArray = str_split($this->title);
    return reset($titleArray);
}

  // Methods
  function set_price($price) {
    $this->price = $price;
  }
  function get_price() {
    return $this->price;
  }
  function set_title($title) {
    $this->title = $title;
  }
  function get_title() {
    return $this->title;
  }
  
}

$first_book = new Book();
$first_book->set_price('$13.95');
$first_book->set_title('Moby Dick');
echo "Price: " . $first_book->get_price();
echo "<br>";
echo "Title: " .  $first_book->get_title();
echo "<br>";
$second_book = new Book();
$second_book->set_price('$23.99');
$second_book->set_title('Wuthering Heights');
echo "Price: " . $second_book->get_price();
echo "<br>";
echo "Title: " .  $second_book->get_title();
echo "<br>";
$book = array("Moby Dick", "Wuthering Heights");
echo "Book Titles: " . $book[0] . ", "  . " and " . $book[1] . ".";

foreach ($book as $bookItem) {
    $price = $bookItem->price;
    // Right now $price is a string ('$xx.xx'), we need it to be numeric
    $price = (float) substr($price, 1);
    if ($price < 20) {
        echo $bookItem->title;
        echo $bookItem->price;
    }
    if (ord(strtoupper($bookItem->get_first_char())) > ord('R')) {
        echo $bookItem->title;
    }
}
 ?>

Any help will be very much appreciated

Thank you

In a relational database, you "link" tables together.  For example, Customer (parent) ---> Product (child)

How do you do that with Objects?

I have a "User" class and an "AddressBook" class.  A User can have zero or more Addresses (in their AddressBook).

If I create a User object and an AddressBook object, I need a way to link them up similar to how they are linked up in the database.

Make sense?!


TomTees

I found it helpful to configure all my objects in one or several bootstrap scripts.  Before doing so, I would often find myself forgetting that I already had written some class which is located deep in some script and recreating it for some other need (granted, composer definitely helped in this regard, but using it wasn't always applicable).

<?php

$c=new Pimple\Container(getMySettings());

$c['pdo'] = function ($c) {
    $db = $c['settings']['mysql'];
    return new \PDO(bla);
};

$c['foo'] = function ($c) {
    return new Foo(
        $c->get('pdo')
    );
};

$c['bar'] = function ($c) {
    return new Bar(
        $c->get('foo')
    );
};

It is all good until I find myself needing to create some new instance of some class instead of just passing some common instance to whoever needs it.

class Foo
{
    private $pdo;

    public function __construct(\PDO $pdo)
    {
        $this->pdo=$pdo;
    }

    public function getSomething():SomeClass
    {
        return new SomeClass($this->getAllDataFromDB($GET['id']));
    }
}

class SomeClass
{
    private $arr;

    public function __construct(array $records)
    {
        foreach($records as $record) {
            $arr[]=new SomeOtherClass($record);
        }
    }
}

I've read that one shouldn't create new objects in a given class's constructor, and while I could instead do so in some class's method and pass the object to the given class's constructor, to me it seems to really be the same thing.  The three issues I have with this scenario a

Needing to remember that these classes exist as they are hidden deep in some classes. Makes it more difficult to replace one of the classes with some other class in the future. Some duplication of code.

Are there other compelling reasons not to do so?  Is it worth the effort to do differently?

If so, how would you recommend doing so?  My thoughts would either to use Pimple's factory() method are create my only factory which also relies on anonymous functions.  Maybe something else?

$c['someClass'] = $c->factory(function (array $record, Container $c) {
    return new SomeClass($record);
});

Thanks

Hi all,   I am working with the following 2 page script: https://github.com/k...hi/php-riot-api. All works well and the data is pulled via the API as intended. However, depending on the data I'm trying to display on screen, the object contains multiple values.   For example:

$r = $test->getSummoner($summoner_id,'name');
print_r($r);

outputs their ID and name: {"585897":"TheirName"}   Just as the following:

$r = $test->getSummonerByName($summoner_name);
print_r($r);

outputs username, ID, Name, profile icon ID, level, and timestamp: {"theirname":{"id":585897,"name":"TheirName","profileIconId":642,"summonerLevel":30,"revisionDate":1405652924000}}   Depending on which function I am calling (on example.php), I would like to be able to split the values so I can echo them throughout a page:   Name: <value> ID: <value> Level: <value> etc...   Any guidance would be appreciated.

I took an object, and saved it into a database serialized.

Code: [Select]
$object_here = serialize($theobject);
Then later on, I go and I get that data from a database, and try to unserialize it..

Code: [Select]
$objecthere = unserialize($row->theobject)

And it throws the following error...any advice?
Quote

Warning: unserialize() [function.unserialize]: Node no longer exists in /path/to/file on line 20

I know it is often frivolous, but sometimes I can't help trying to optimize things, and use the following two methods to create either an object injected with a string or one of a set of objects.  For both cases, the class has no setters so there is no chance that the object will later be changed.  I first stated doing this in continuously running server applications which I believe makes sense, however, it has leaked over to standard HTTP requests.

Please commit good or bad on this approach. Thanks

 

    public static function create(string $unit):self
    {
        static $stack=[];
        if(!isset($stack[$unit])) {
            $stack[$unit] = new self($unit);
        }
        return $stack[$unit];
    }

    public static function create(string $class):FunctionInterface
    {
        static $stack=[];
        if(!isset($stack[$class])) {
            $stack[$class] = new $class;
        }
        return $stack[$class];
    }

 

Hello, i been making a site to learn some PHP. I been always searching about what's the best way of using the PHP functions, classes and objects but i have a small question that i couldnt found the awnser by my self. so far i m inicializing an PHP class like this:

1st case
Code: [Select]
$themeobj = new theme();
Today i found an tuturial that used an other way of calling an function inside the class:

2nd case
Code: [Select]
theme::loadTheme;
I understand that the way i m doing, your iniciating the variable $themeobj as an object of the class theme and that the theme:loadTheme just calls the function loadTheme inside the theme class (please correct me if i m wrong), but here's where is where i need abit of enlightment. Using the 2nd case will "skip" the loading of the __construct function? when should you use the 1st case or the 2nd case? Every time i needed an function from theme i would use $themeobj->loadTheme($param) its safe to use theme::loadTheme($param)?

Thanks in advance

I have a page in which the print_r ($session) displays the following:

Array
(
    [securityToken] => 23b1f22bffd9f5097878618da57b14a2
    [cartID] => 
    [cart] => shoppingCart Object
        (
            [contents] => Array
                (
                )

            [total] => 0
            [weight] => 0
            [cartID] => 
            [content_type] => 
            [free_shipping_item] => 0
            [free_shipping_weight] => 0
            [free_shipping_price] => 0
        )

    [navigation] => navigationHistory Object
        (
            [path] => Array
                (
                    [0] => Array
                        (
                            [page] => index
                            [mode] => NONSSL
                            [get] => Array
                                (
                                    [cPath] => 2_9_843_845_852_856_858_863
                                )

                            [post] => Array
                                (
                                )

                        )

                    [1] => Array
                        (
                            [page] => product_info
                            [mode] => NONSSL
                            [get] => Array
                                (
                                    [cPath] => 2_9_843_845_852_856_858_863
                                    [products_id] => 2299
                                    [action] => add_product
                                )

                            [post] => Array
                                (
                                )

                        )

                    [2] => Array
                        (
                            [page] => shopping_cart
                            [mode] => NONSSL
                            [get] => 
                            [post] => Array
                                (
                                )

                        )

                    [3] => Array
                        (
                            [page] => checkout_shipping
                            [mode] => NONSSL
                            [get] => 
                            [post] => Array
                                (
                                )

                        )

                    [4] => Array
                        (
                            [page] => checkout_payment
                            [mode] => NONSSL
                            [get] => 
                            [post] => Array
                                (
                                )

                        )

                    [5] => Array
                        (
                            [page] => checkout_confirmation
                            [mode] => NONSSL
                            [get] => 
                            [post] => Array
                                (
                                )

                        )

                    [6] => Array
                        (
                            [page] => checkout_process
                            [mode] => NONSSL
                            [get] => 
                            [post] => Array
                                (
                                )

                        )

                    [7] => Array
                        (
                            [page] => checkout_success
                            [mode] => NONSSL
                            [get] => 
                            [post] => Array
                                (
                                )

                        )

                )

            [snapshot] => Array
                (
                )

        )

    [check_valid] => true
    [language] => english
    [languages_id] => 1
    [languages_code] => en
    [currency] => USD
    [today_is] => 2010-11-26
    [updateExpirations] => 1
    [session_counter] => 1
    [new_products_id_in_cart] => 2299
    [valid_to_checkout] => 1
    [cart_errors] => 
    [customer_id] => 2
    [customer_first_name] => test
    [customer_default_address_id] => 2
    [customer_country_id] => 223
    [customer_zone_id] => 2
    [customers_authorization] => 0
    [messageToStack] => 
    [payment_attempt] => 1
)
What I need to do is loop through the navigationHistory Object , grab the product id, and then get the cPath for that particular product id.  I have worked with sessions a lot, but I cannot seem to ever get the session object and loop thing down.  At this point I am ripping out my hair trying to figure out what is most likely a simple solution to this - can anyone help me?