PHP - Switch From Single To Double Quoted And Reversed The Entity, And Now It Doesn't

I'm so sorry for this question but I not really know how to play with single and double quote.

If I have a query like this:

Code: [Select]
  mysql_query('UPDATE table SET Status=1,Sending=Done WHERE ID IN ('.implode(',', $done).')');
And I wish to add Code: [Select]
SentAt='$date' in the query as well , and I try this:

Code: [Select]
  mysql_query('UPDATE table SET Status=1,Sending=Done,SentAt='$date' WHERE ID IN ('.implode(',', $done).')');
Not working...how should I write it?

Thank you.

I have a navigation list displaying which is a mix of html and php, everything is working fine however now I want to convert this block of code into a function but am having major problems with quotes.

The line of code I currently have is 

$data = $db->query("SELECT * FROM menu")->fetchAll(PDO::FETCH_ASSOC);

foreach ($data as $row) { ?>
     <li><a href="<?php echo $row['url']; ?>" title="<?php echo $row['title']; ?>"><?php echo $row['icon'] . ' ' . $row['header']; ?></a></li>

<?php
	}
?>

As I say everything works using the above but now I am trying to echo the full li out and am having major issues with single and double quotes.

I currently have 

echo "<li><a href='#' title='the title'><i class='fas fa-user site-nav--icon'></i> Help</a></li>";

Now I am trying to use the $row['url'], $row['title'], $row['icon'] & $row['header'] as per the top example but I cannot get the combination of quote marks correct, whether to use double, single or a combination.

I would be grateful if someone could suggest the correct syntax for the a tag then I can work through the rest.

Thanks

Hello everyone!  This is my first post.  I am very new to php and mysql and coding in general.  It has not been made 100% clear to me as to when I should use single quotes, double quotes, and {}.  From what I gather you use single quotes for literal interpretation...  so if you put something like a variable in single quotes and echoed it, it would literally echo it as it is written and not the value of the variable.  in double quotes, I gather that it will echo the value of the variable.  as for {} I am unclear as to when to use the curly brackets for a variable.  I am assuming if you had a statement in single quotes and you put a variable in curly brackets you would get the value of the variable?
Edited by LazerOrca, 25 November 2014 - 11:20 PM.

I don't think I've asked this before have I??  can someone give me an internet KB that gives me all scenarios that warrant using singles or doubles?  as in, wrapping values, variables, and why I need to do either, and when, etc, etc....?

thanks

Edited March 29 by ajetrumpet

This code only works in firefox
<a onMouseout='hidetooltip()' onMouseover='tooltip(\"<img src=img/heroes/$hero.gif\")' href='hero.php?hero=$hero'>Text</a>
Btw, I use this in echo (php).
How to get quotes (triple) on <img src=
?
I also have tried
<img src='img/heroes/$hero.gif'
But only works on FireFox

Hello,
I've created a little script that fetches all dates from the database and puts it into a select list. The problem is that the today date is at the bottom, so a lot of scrolling to do if you need that date. That's why I need it reversed. I got this:

while($d_dailystatistics = mysql_fetch_array($d_getdailystatistics)) {

And here I'm stuck, I've tried to use array_reverse, with no result. Googling wasn't really helping either and W3Schools is offline for me (I know it's on, just a provider issue).

Thanks,
NLCJ

This topic has been moved to PHP Regex.

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

Hi, all... have a basic question here as a newbie that I am...

Many times, in some scripts I see (I think, if not mistaken), places where within a echo sentence I see variables echoed like this with no quotes:

echo "First Name: $firstName and Last Name: $lastName"; 
as opposed to like one would expect:
echo "First Name: " . $firstName . " and Last Name: " . $lastName"; 

Sometimes I see that also when variables are used in select/update statements I think.. like this:
$query = mysql_query("SELECT FROM table WHERE column = $columnname");
Instead of like this within quotes:
$query = mysql_query("SELECT FROM table WHERE column = '$columnname'");


Is it because some of these values may be numbers (numeric) as opposed to "strings"??
Not sure if I make sense... appreciate teh feedback,
Thanks!

Hello,   I'm having a huge issue right now decoding a zip file from an attachment with a content-encoding of quoted-printable.  I have tried a couple different methods (such as decoding the entire attachment or decoding it line by line), but none have produced a valid file when saved.  What I don't understand is that I can download and open the file in Outlook fine, so there must be something wrong with the decoder.  Here is a code snippet of my recent attempt:

                            elseif ($transferEncoding == 'quoted-printable'){
                                $fileError = true;
                                $attachmentParts = explode("\n", $currentPart->getContent());
                                $attachmentArray = array();
                                foreach ($attachmentParts as $line){
                                    array_push($attachmentArray, quoted_printable_decode($line));
                                }
                                $attachment = implode("", $attachmentArray);
                                file_put_contents($unzipPath . '.zip', $attachment);
                            }
                            $unzipper = new Decompress(array(
                                'adapter' => 'Zip',
                                'options' => array(
                                    'target' => $unzipPath,
                                )
                            ));
                            $unzipper->filter($unzipPath . '.zip');
                            unlink($unzipPath . '.zip');

I'm using Zend Framework 2 methods for unzipping the file when it's done, but there is a CRC error because the file is getting corrupted during the decode.   This is how the file compares to the original (using Beyond Compare 3):   So it is finding the hex for CLRF and removing it from the file.   Any ideas on this would be greatly appreciated as I have been trying to solve this for about a month now.   Thanks, -mcfloyd

I am using API-Platform, Doctrine, and Symfony with entities that utilize class type inheritance to extend an abstract entity.

I've been running into one issue after another primarily related to the serialization process (serialization groups, parent annotations not propagated to the child, etc), and while I am sure user error on my part is part of the culprit, it appears that API-Platform and potentially Symfony and Doctrine don't fully support entity inheritance.  My reason for thinking so is the incredibly sparse amount of documentation on the subject and remarks on quite a few github issues posts and other blogs how it is "bad practice".

For instance, say I have Mouse, Cat, and Dog which all extend AbstractAnimal, and each has a bunch of common properties such as birthday, weight, etc, and methods such as eats(), sleeps(), etc.  Sorry in advance for using hypothetical entities but I don't think doing so distracts.  I like how inheritance allows me to keep all common properties in a single table, but can let that go.  More importantly, the subset mouse, cat, and dog table shares an ID from the animal table allowing me to associate all animals to some other table (i.e. many-to-one to person whether they are their pet or many-to-many to country whether they are native to a country), and to retrieve a list of animals and filter by some property or type as needed without a bunch of unions.

To me, this sounds like inheritance, but if the products I am using don't support it very well, it doesn't matter.

First question.  Is entity inheritance considered bad practice?  And even if not, is it common for frameworks to limit their level of support for them?

If so, what can I do about it?  Maybe favor composition over inheritance?  Okay, great, I now have a single animal table which makes all my SQL concerns issues go away and I am pretty confident that my serialization issues will also go away. All I need to do is inject each animal with some "thing" to make them a mouse, cat, or dog.

But what do I call this thing?  I've struggled with this topic for a while and asked the same question regarding how to deal with BarCharts, PieCharts, GaugeCharts, LineCharts, etc all being charts but all acting slightly differently, and never really came to any conclusion.

For a non-hypothetical scenario, I have BacnetGateway and ModbusGateway which extend AbstractGateway.  Okay, this one is easy and I change to just having a Gateway and inject either BacnetProtocol or ModbusProtocol.

For another non-hypothetical scenario, I have PhysicalPoint which represents some real environmental parameter, VirtualPoint which represents combining one or more PhysicalPoints or VirtualPoints, and TransformedPoint (feel free to provide a better name) which represents performing some time function such as integrating over a given time.  Currently, they all extend AbstractPoint, but if I was trying to do so with composition, I could inject PointType but don't think doing so makes sense.

For my hypothetical scenario, do I make a DNA interface and inject an Animal with DogDNA to get a dog?

I really need to get my head around this once and for all.  Thanks

I can create a one-to-one relationship between two tables by placing a unique constraint on the foreign key and making it NOT NULL, and make it one-to-at-most-one by removing the NOT NULL constraint.

My question is what criteria should one use to determine which table holds the foreign key?

For instance, I have the Car and Motor entities as shown below where one Car has one Motor, and conversely one Motor is used by one Car.

AbstractPart
- id (Auto Inc)
- discriminator (car, motor, etc)
- serialNumber (unique for given discriminator)
- manufacturerId
- weight
- cost
- countryOfOrigin
- etc

Car extends AbstractPart
Motor extends AbstractPart

What reasoning should one use to determine whether the Car table contain the Motor ID or should the Motor table contain the Car ID?

Is there a way to make it How can I go about removing a $_SESSION entity if certain array values of it equal a specific value? I am thinking something along the lines of this:

if (isset($_SESSION['cart']['content'][$_POST['id']])) = array ('sizes' => 0, 'sizem' => 0, 'sizel' => 0, 'sizexl' => 0) {
// remove $_SESSION['cart']['content'][$_POST['id']]
}

PHP script return 20 UL LIST values like,

< ul >

A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T

< /ul >

How to display UL LIST into row wise 5 columns like

A B C D
E F G H
I J K L
M N O P
Q R S T (20 ITEMS)

Edited December 7, 2019 by aveeva

Hello

I am working on my graduation project and I have a critical problem with my php code and I am just beginner in php coding.

I am reading from text file IDs of papers and want to link between the ID that I read form my text file and the XML file so that is my code :
<?php
$file = fopen("abstract/Temp_id.txt","r");
$ids;
while(!feof($file))
{
    $ids = fgets($file);
   
    $xml = simplexml_load_file("abstract/$ids");//abstract is the folder which I save my files and //read from it
   
    $title="bibliomisc =".$xml->articleinfo[0]->bibliomisc;

    echo $title;
    echo"<a href=abstract/$ids title='Click to open '>$ids</a>";
}
fclose($file);
?>

BUT I worked on openssl and it is working if I give it the name of ID e.g.
$xml = simplexml_load_file("abstract/8104317");//it is working but if I read from file I got that error


Warning: simplexml_load_file() [function.simplexml-load-file]: I/O warning : failed to load external entity "8104317.xml " in /opt/lampp/htdocs/GP/xml_test.php on line 9

Notice: Trying to get property of non-object in /opt/lampp/htdocs/GP/xml_test.php on line 12

Notice: Trying to get property of non-object in /opt/lampp/htdocs/GP/xml_test.php on line 12
bibliomisc =
8104317.xml
Warning: simplexml_load_file() [function.simplexml-load-file]: I/O warning : failed to load external entity "" in /opt/lampp/htdocs/GP/xml_test.php on line 9

Notice: Trying to get property of non-object in /opt/lampp/htdocs/GP/xml_test.php on line 12

Notice: Trying to get property of non-object in /opt/lampp/htdocs/GP/xml_test.php on line 12
bibliomisc =

help please thanks

I am using PHP and Doctrine to store and manipulate Highchart objects such as the following:

{
    "chart": {
        "type": "bar"
    },
    "xAxis": {
        "categories": ["Africa", "America", "Asia", "Europe", "Oceania"]
        }
    },
    "series": [{
        "name": "Year 1800",
        "data": [107, 31, 635, 203, 2]
    }, {
        "name": "Year 1900",
        "data": [133, 156, 947, 408, 6]
    }, {
        "name": "Year 2000",
        "data": [814, 841, 3714, 727, 31]
    }, {
        "name": "Year 2016",
        "data": [1216, 1001, 4436, 738, 40]
    }]
}

My DB schema is:

BarChart
-id (PK)
-name (string)

BarChartSerie
-id (PK)
-barChartId (FK)
-name (string)
-position (int)

BarChartCategory
-id (PK)
-barChartId (FK)
-name (string)
-position (int)

BarChartNode
-barChartSerie (FK)
-barChartCategory (FK)
-value (decimal)

The chart entity has a collection of serie and category, and  the serie and category entities both contain a reference to the shared node.

I wish to clone the chart entity and thus use __clone() to set the chart, category, and serie entity's' PK to NULL, however, am running into issues as the node entity still has the original entitiy's PKs.

I think maybe I should be creating the entities differently.

Any suggestions how these objects should be created?  Maybe instead have my series contain a collection of nodes and have each of these nodes contain a reference to the applicable category?

Thanks