PHP - Building An Attributes Function Without Late Static Binding

I have the following static method:
public static function query($query){
self::$num_queries++;
return mysql_query($query)or die(mysql_error());
}

I then call it like this:
$oql = Mysql::query("SELECT first FROM members WHERE member_id = '{$this->owner}'");
$rql = mysql_fetch_assoc($oql);

I then get the following error:
Quote

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /incl/php/classes/Photo.php on line 13


Why am I getting this error?

I'm trying to build a search function that will search all columns in a table. Here is what I've got:

Code: [Select]
if (isset($_POST['submitted'])) {
$q = "SELECT * FROM children ";

if(isset($_POST['query'])) {
$q .= "WHERE ";

$all = "SELECT * FROM children WHERE 1";
$r_all = mysqli_query($dbc, $all);

while ($field = $r_all->fetch_field()) { // Get field headers for building query
$f_name = "{$field->name} LIKE {$_POST['query']},:"; // Build query with search string
$fn = explode(":",$f_name); // Need to convert $f_name to an array but this does not convert it to a single array but multiple arrays

$q .= implode("OR", $fn); // Need to insert OR for the db query

} // End while ($field = $r_all->fetch_field())

} // End if(isset($_POST['query']))

} // End if (isset($_POST['submitted']))

The explode function is what is not working for me. It gives me this (sam is the search string I entered into the form):

Code: [Select]
Array ( [0] => child_id LIKE sam, [1] => ) Array ( [0] => first_name LIKE sam, [1] => ) Array ( [0] => second_name LIKE sam, [1] => ) Array ( [0] => last_name1 LIKE sam, [1] => ) Array ( [0] => last_name2 LIKE sam, [1] => ) Array ( [0] => gender LIKE sam, [1] => ) Array ( [0] => dob LIKE sam, [1] => )

so instead of getting one array with each string being a value I get multiple arrays. Any ideas?

I have 2 php files. I am unable to get B's global variable from A's static method:

A.php
Code: [Select]
class c_A
  { public static function f_A()
      { include_once( "B.php" ) ;
        print f_B() ;
      }
  }
c_A::f_A( ); // only prints "B : "

B.php
Code: [Select]
$gvs = "global variable from B" ;

function f_B()
  { return "B : " . $GLOBALS[ "gvs" ] ;
  }


any thoughts?


thanks,
Shannon

Hi,

this, i think, is a 'php in firefox' issue despite me mentioning css in the title so please read on!..

please have a look, using firefox, at http://www.laureleroch.com/gallery.php...

As you can see, when choosing different images via clicking on the thumbnails the page reloads and there's an amount of time where we see the page loaded without css applied..., however doesn't seem to be happening in IE9, opera, chrome, or safari. It IS happening in firefox on W7 and OSX.

the file gallery.php has...


<?php
session_start();
ob_start();
include("scripts/php/gallery_display.php");
include("scripts/php/file_reader.php");


...as its start...and...

 
</body>
</html>
<?php ob_flush() ?>

..at its end.

I can post all the code from the includes if required. I'd say there's a fair bit of processing done by these includes but really, not THAT much, plus other browsers seem to be doing ok with it.

Also, the background images are big. That's a fact. The site will be in this way and I plan to use a preloader once I get the main build sorted...nearly there.

One other thing...I really am a coding newbie. I've been toying with it for years, first with actionscript in flash, then html/css and now I'm getting really into php, however I'm sure my coding is pretty inefficient here and there thru nothing other than pure, undiluted ignorance...good, eh?!

so, if anyone got some pointers that would be really brilliant... any other info required - please shout.

cheers,

Scott

Hi I am adapting Jeffery Ways Mysql class to accept multiple where statements however I have got stuck on the final hurdle.
It is when I try to do the bind_results() and I pass in the parameter types and the parameters. Here is that part of the code:

if ($this->_where)
            $values = array_values($this->_where);

         $str = "'";
             $str .= implode('\', \'', $values);
            $str .= "'";
            // echo $str;
         $count = count($this->_where);

         foreach($this->_where as $key => $value){
             $key = $value;
         }
         $user = 'matt25';
         $pass = '6722853cacc4a9649dc75abc852f23c35b1f75cb';

         $stmt->bind_param($this->_paramTypeList, $user, $pass);
      }

It works how it is by setting the parameters as variables, but that obviously isn't practical. as you can see I also tried to make a string with the values from the array which brought up the error:
 Warning: mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of elements in type definition string doesn't match number of bind variables in C:\wamp\www\trick_tips\admin\includes\MysqlDb.php on line 260,

the same as when I try to put the array into there.

So I need some way of setting each value in the array as a variable to then put into the function, or another Idea that I have completely missed.

Any help would be much appreciated.

Cheers,
Matt

I have an application that uses the PHP LDAP library to connect to the Windows Active Directory:

$ds = ldap_connect($ini['ad_server']) or die("Could not connect");
$admin = $ini['ad_user'];
$passwd = $ini['ad_password'];
$passwd = base64_decode($passwd);
$dn = $ini['ad_basedn'];

ldap_set_option($ds, LDAP_OPT_PROTOCOL_VERSION, 3);
ldap_set_option($ds, LDAP_OPT_REFERRALS, 0);
$rInTouch = ldap_bind($ds, $admin, $passwd);

I am wondering if anyone knows if this upcoming patch "2020 LDAP channel binding and LDAP signing" coming from Microsoft will break any PHP applications that are using this ldap library.

Thanks in advance,

 

M

$_POST['select'] permits me access to the selected value of my combo box named 'select'.

are any other attributes of the box accessible? in particular, index # ... etc.?

thanks in advance for any light you might shed on the topic.

I have a site that allows members to create pages. These pages consist of small sections some of which HTML can be entered. To keep visitors from straying away from the site, any outside urls are brought up in a modal window. Using inline attributes, a class has to be created (or added to), and the title tag requires some special characters. I can probably get around this by inserting an onclick or something, but there must be a way to replace attributes, and I am at a loss.
The text segments are stored in a database. What I want to do is change the <a> tag attributes as the page is created. So I have a segment of text "$TheText" and I want to change or replace the attribute values.
For instance,
If $TheText contains an 'a' tag that looks like this:
Code: [Select]
<a class="MyClass" title="Godzilla" href="http://www.godzillaslair.com">Godzilla</a>I would want to change it to
Code: [Select]
<a class="MyClass Lightview" title="Godzilla :: {Lightview's parameters}">Godzilla</a>Or even just replace the attributes entirely, so it would look like
Code: [Select]
<a class="Lightview" title="{Inserted Title} :: {Lightview's parameters}">Godzilla</a>
In other words, just replacing the attribute values.

Of course, I need to see if the attributes exist. I know how to do that and how to get their values. But all that tells me is that I have an 'a' tag in the text with those values for those attributes. I cannot, for example, then do a str_replace in the first example, because there may be another tag in the text with the "MyClass" class.  I can iterate character by character between <a and </a> but there must be a better way.
I'm no good at regex, so I haven't even attempted that.

Any suggestions would certainly be appreciated.

Context.

Class AbstractTenantEntity's purpose is to restrict access to data to the tenant (i.e. account, owner, etc) that owns the data.  Any entity which extends it will have the TenantId added when created and the TenantId in the WHERE clause for all other requests.

Tenant typically does not have collections of the various entities which extend AbstractTenantEntity, but does for a few of them do.  When using annotation, I handled it by applying Doctrine's AssociationOverride annotation to the extended classes which should have a collection in Tenant.

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity()
 */
class Tenant
{
    /**
     * @ORM\OneToMany(targetEntity=Asset::class, mappedBy="tenant")
     */
    private $assets;

    // Other properties and typical getters and setters
}

 

use Doctrine\ORM\Mapping as ORM;

abstract class AbstractTenantEntity implements TenantInterface
{
    /**
     * inversedBy performed in child where required
     * @ORM\ManyToOne(targetEntity=Tenant::class)
     * @ORM\JoinColumn(nullable=false)
     */
    protected ?Tenant $tenant = null;

    // Typical getters and setters
}

 

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity()
 * @ORM\AssociationOverrides({
 *     @ORM\AssociationOverride(name="tenant", inversedBy="assets")
 * })
 */
class Asset extends PublicIdTenantEntity
{
    // Various properties and typical getters and setters
}

 

So, now I am changing from annotations to attributes, and modified AbstractTenantEntity as follows:

use Doctrine\ORM\Mapping\ManyToOne;
use Doctrine\ORM\Mapping\JoinColumn;

abstract class AbstractTenantEntity implements TenantInterface
{
    /**
     * inversedBy performed in child where required
     */
    #[ManyToOne(targetEntity: Tenant::class)]
    #[JoinColumn(nullable: false)]
    protected ?Tenant $tenant = null;

    // Typical getters and setters
}

Next I went to modify Asset and realized that there didn't appear to be an attribute for AssociationOverride.  I found a little discussion on the topic on github but couldn't find any resolution.

Question

Can inheritance be used with PHP 8 attributes where the property is defined in the parent class and the attribute is applied in the child class?  Googling php 8 attributes inheritance didn't provide anything and thus I expect the answer is no but thought I'd ask.

Thanks

 

EDIT.  Maybe Doctrine does have an attribute version: https://github.com/doctrine/orm/blob/2.9.x/lib/Doctrine/ORM/Mapping/AttributeOverride.php

EDIT2.  Actually don't think so

Edited July 30 by NotionCommotion

I cant get my head around this. I m trying to add product attributes into this script.

I have products tables and product_extras

product.id and product_extras.id are same. How can I add this to cart. Is there any easy way to do this.

Any help would be  much appreciated!

Quote

cart.php

Code: [Select]
<?php
// Include MySQL class
require_once('inc/mysql.class.php');
// Include database connection
require_once('inc/global.inc.php');
// Include functions
require_once('inc/functions.inc.php');
// Start the session
session_start();
// Process actions
$cart = $_SESSION['cart'];
$action = $_GET['action'];
switch ($action) {
case 'add':
if ($cart) {
$cart .= ','.$_GET['id'];
} else {
$cart = $_GET['id'];
}
break;
case 'delete':
if ($cart) {
$items = explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($_GET['id'] != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
$cart = $newcart;
}
break;
case 'update':
if ($cart) {
$newcart = '';
foreach ($_POST as $key=>$value) {
if (stristr($key,'qty')) {
$id = str_replace('qty','',$key);
$items = ($newcart != '') ? explode(',',$newcart) : explode(',',$cart);
$newcart = '';
foreach ($items as $item) {
if ($id != $item) {
if ($newcart != '') {
$newcart .= ','.$item;
} else {
$newcart = $item;
}
}
}
for ($i=1;$i<=$value;$i++) {
if ($newcart != '') {
$newcart .= ','.$id;
} else {
$newcart = $id;
}
}
}
}
}
$cart = $newcart;
break;
}
$_SESSION['cart'] = $cart;
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>products</title>
<link rel="stylesheet" href="css/styles.css" />
</head>

<body>

<div id="shoppingcart">

<h1>Your Shopping Cart</h1>

<?php
echo writeShoppingCart();
?>

</div>

<div id="contents">

<h1>Please check quantities...</h1>

<?php
echo showCart();
?>

<p><a href="index.php">Back to products...</a></p>

</div>

</body>
</html> Quote

functions.php


Code: [Select]
<?php
function writeShoppingCart() {
$cart = $_SESSION['cart'];
if (!$cart) {
return '<p>You have no items in your shopping cart</p>';
} else {
// Parse the cart session variable
$items = explode(',',$cart);
$s = (count($items) > 1) ? 's':'';
return '<p>You have <a href="cart.php">'.count($items).' item'.$s.' in your shopping cart</a></p>';
}
}

function showCart() {
global $db;
$cart = $_SESSION['cart'];
if ($cart) {
$items = explode(',',$cart);
$contents = array();
foreach ($items as $item) {
$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
}
$output[] = '<form action="cart.php?action=update" method="post" id="cart">';
$output[] = '<table>';
foreach ($contents as $id=>$qty) {
$sql = 'SELECT * FROM products WHERE id = '.$id;
$result = $db->query($sql);
$row = $result->fetch();
extract($row);
$output[] = '<tr>';
$output[] = '<td><a href="cart.php?action=delete&id='.$id.'" class="r">Remove</a></td>';
$output[] = '<td>'.$title.'</td>';
$output[] = '<td>&pound;'.$price.'</td>';
$output[] = '<td><input type="text" name="qty'.$id.'" value="'.$qty.'" size="3" maxlength="3" /></td>';
$output[] = '<td>&pound;'.($price * $qty).'</td>';
$total += $price * $qty;
$output[] = '</tr>';
}
$output[] = '</table>';
$output[] = '<p>Grand total: <strong>&pound;'.$total.'</strong></p>';
$output[] = '<div><button type="submit">Update cart</button></div>';
$output[] = '</form>';
} else {
$output[] = '<p>You shopping cart is empty.</p>';
}
return join('',$output);
}
?>

Hi,

Im trying to grab some data from a XML generated by an external server.
I know how to grab from XML without attributes, but I cant seem to wrap my head around the structure of this file.
What would be easiest way to get the value of  the "dbnr" field?

Part of the XML file:

Code: [Select]
<data>
 <location>
   <field name="id" format="Long">xxxxxx</field>
   <field name="dbnr" format="Long">xxxxxx</field>
   <field name="jobnr" format="Long">xxxxxx</field>
   <field name="job_type" format="String" maxlen="50">xxxxxx</field>
   <field name="job_category" format="String" maxlen="50">xxxxxx</field>
 </location>
</data>

I am making a project by designing my own MVC model. In this the user accesses controller class which further calls model class which accesses the database by $dbh attiribute defined public. My View is a script which calls different pages. In the constructor of model I'm establishing connection with the database. Firstly I construct the model object when the user accesses i.e. in the controller class to check in the databse then if the username is not present in the dtaabse I want to insert his info in the database for that I again calla model class but this time I again have to establish connection. Is the $dbh firstly constructed is lost like dangling pointers in C++. Do I have to  worry about it. If yes how can I solve this problem.

Hi all,

I'm sure I'm making this far more difficult than I need to...

I've got an xml document...

<library id="1">
<lname>Lib1</name>
<book id="1">
<title>book 1</title>
<author>Author 1</author>
</book>
<book id="2">
<title>book 2</title>
<author>Author 2</author>
</book>
</library>

I can access the nested elements using xpath like :

$result = $xml->xpath('//book');

    foreach($result as $books) {
        echo $books->title;
    }

How would I do this for the attributes? If I specify I want the attributes in the xpath query I can't get at the elements...

I'm trying to turn this xml file into a simple relational database... A library table and a book table.

So I need the library id (attribute) and the name(nested element) for one insert query - and the book id, title, author and the library id for the other.


Anyone got any idea?

Cheers

John

How can I print the attributes of a child node?
I have been trying and looking and cant get it.
I need the attributes of subfield printed after datafield
so a line would look like
datafield plus attributes plus subfield attributes plus subfield

=906 __$a0$bcbc$corignew etc...

<?php
//child nodes http://www.w3schools.com/php/php_xml_dom.asp
//http://books.google.com/books?id=ygQRKDEsLecC&pg=PA196&lpg=PA196&dq=print+php+xml+child+node+attributes&source=bl&ots=TCAhH4kpCt&sig=yJUPXesIkRUrNXdNE9Yr5ul7Wdw&hl=en&ei=U51kTeKQKsL48AbN4MDTBg&sa=X&oi=book_result&ct=result&resnum=10&ved=0CF4Q6AEwCQ#v=onepage&q=print%20php%20xml%20child%20node%20attributes&f=false
//http://stackoverflow.com/questions/4598409/printing-content-of-a-xml-file-using-xml-dom

$doc = new DOMDocument();
$doc->preserveWhiteSpace = FALSE;

$doc->load( 'loc.xml' );
$root = $doc->documentElement;
$type = $root->nodeType;
//print $doc->nodeName."\n";
//print $root->nodeName."\n";
//print $doc->nodeValue."\n";
//print $root->nodeValue."\n";


$librecords = $doc->getElementsByTagName( "record" );

foreach( $librecords as $record ){

   $leader = $record->getElementsByTagName( "leader" );
   $controlfields = $record->getElementsByTagName( "controlfield" ); 
   $datafields = $record->getElementsByTagName( "datafield" ); 
   $subfields = $record->getElementsByTagName( "subfield" );

   $leader = $leader->item(0)->nodeValue;  
   echo '=LDR '.$leader.'<BR>';

   foreach( $controlfields as $controlfield ){
      $tag = $controlfield->getAttribute('tag');  
      $cf_value = $controlfield->firstChild->nodeValue;
      echo "=".$tag." ".$cf_value.'<BR>';  }

   foreach( $datafields as $datafield ){
      $tag = $datafield->getAttribute('tag');  
      $ind1 = $datafield->getAttribute('ind1'); 
      $ind2 = $datafield->getAttribute('ind2'); 
      if ($ind1 ==" ") {$ind1 = "_";}
      if ($ind2 ==" ") {$ind2 = "_";}
      echo "=".$tag." ".$ind1.$ind2; 

      //if($datafield->hasChildNodes()){echo 'This node has children!<br />';}
      foreach ($datafield->childNodes AS $item)  {  
      //  $arr = $item->attributes; 
        print $arr;
      print 'nodeName '.$item->nodeName . " = " . $item->nodeValue." | " ;} //. "<br />";  }
  
  //   foreach ($datafield->children() as $node) {
  //      $arr = $node->attributes();   // returns an array
  //      print ("code=".$arr["code"]);     // get the value of this attribute
 //       print ("  Company=".$node->subfield);
//        print ("<p><hr>");
//}
 //     foreach( $subfields as $subfield){
      
 //     foreach($subfield->attributes as $attr){

     // $attributes = $subfield->attributes;

     
  //      print $attr->nodeName;
    //    print $attr->nodeValue;
   //     //print $attributes->nodeName;
        //print $attributes->nodeValue;

   //    print $subfield->nodeName;
    //   print $subfield->nodeValue;

//}}
    
   // print $item->nodeValue  ;  
 //       print $item->attributes("code");
   //       $valueID = $item->getAttribute('code'); 
   //      print $item->nodeName->attributes("code");
//          echo $item->nodeValue.getAttribute("code");
      //      print $item->getAttribute('code')
//http://www.devshed.com/c/a/PHP/Accessing-Attributes-and-Cloning-Nodes-with-the-DOM-XML-Extension-in-PHP-5/1/
 
      echo '<BR>'; 
     
     }





   foreach( $subfields as $subfield ){
      $code = $subfield->getAttribute('code');  
      $sf_value = $subfield->firstChild->nodeValue;
      echo '$'.$code.$sf_value.'<BR>'; }

echo '<BR>';

}
?>

   

Code: [Select]
  <leader>01026ngm a22002773a 4500</leader>
  <controlfield tag="001">16429180</controlfield>
  <controlfield tag="005">20100823131409.0</controlfield>
  <controlfield tag="007">vffcjaho|</controlfield>
  <controlfield tag="008">100823s2010    xxu060            mleng  </controlfield>
  <datafield tag="906" ind1=" " ind2=" ">
    <subfield code="a">0</subfield>
    <subfield code="b">cbc</subfield>
    <subfield code="c">orignew</subfield>
    <subfield code="d">u</subfield>
    <subfield code="e">ncip</subfield>
    <subfield code="f">20</subfield>
    <subfield code="g">y-movingim</subfield>
  </datafield>
  <datafield tag="955" ind1=" " ind2=" ">
    <subfield code="b">qm12 2010-08-23</subfield>
  </datafield>

Hi, I am new to xml parsing and I just want to know how to check whether a node has attributes:

Here is my xml file to use:
=================
Code: [Select]
<?xml version="1.0" encoding="ISO-8859-1"?>
<email>
<message>
<to>
<toFirstName>Tove</toFirstName>
<toLastName toType="common" style="swag">Smith</toLastName>
</to>
<from>
<fromFirstName>Jani</fromFirstName>
<fromLastName fromType="unique">Dravison</fromLastName>
</from>
<heading>Reminder</heading>
<body>
<prologue>Tis the night before Xmas...</prologue>
<paragraph1>Don't forget me this weekend!</paragraph1>
<paragraph2>Jump the gun!</paragraph2>
<epilogue>The end of the world.</epilogue>
</body>
</message>

<message>
<to>employees</to>
<from>CEO</from>
<heading>Power Lunch</heading>
<body>
<prologue></prologue>
<paragraph1>Year over year data</paragraph1>
<paragraph2>Downsizing</paragraph2>
<epilogue>The end.</epilogue>
</body>
</message>
</email>

Here the simple script that I cannot get to work:
==================================
Code: [Select]
<?php
$simpleXMLObj=simplexml_load_file("email.xml");

if($simpleXMLObj->to[0]->toLastName[0]->attributes()->getName)
print "YES: this node has attributes!";
else
        print "NO:";
?>

Please I really need help, it is simple I know but I am new to xml parsing and mixed up.