modx revo snippet variable in query

Posted by Meddie on Stack Overflow See other posts from Stack Overflow or by Meddie
Published on 2012-06-29T09:25:32Z Indexed on 2012/06/29 15:16 UTC
Read the original article Hit count: 216

Filed under:

query

|

code-snippets

|

modx-revolution

I noticed something weird when using a query in a snippet. When I have a query like this:

$sql = 'SELECT * FROM table WHERE colomn = ' . $variable;

And I echo $sql, the query reads:

SELECT * FROM table WHERE colomn = <code class="php plain">2</code>

.. wich will result in an error because the sql is no longer valid. So for now I use strip_tags to remove the code tag, but I find it not a very clean method.

I couldnt find anything about this, so maybe someone can shed some light on this for me?

© Stack Overflow or respective owner

Related posts about query

sort mysql query by filtered query

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two mysql queries: $sql = "SELECT * FROM content WHERE threadName LIKE '%$filter%' ORDER BY lastUpdated desc"; and $sql = "SELECT * FROM content ORDER BY lastUpdated desc"; The end result is to have all rows returned from a particular table 'content' but have those that match the variable… >>> More
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query

as seen on Stack Overflow - Search for 'Stack Overflow'
How to use PHPunit's Database Test Case Methods of Query to compare with doctrine query i m using phpunit with doctrine framework .. i want to test my doctrine query with phpunit query with using phpunit framework methods.. any buddy with Doctrine Query and PhpUnit Query plz Contact... //Bhavin… >>> More
Converting sql query to EF query - nested query in from

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys Just wondering how the following sql query would look in linq for Entity Framework... SELECT KPI.* FROM KeyPerformanceIndicator KPI INNER JOIN ( SELECT SPP.SportProgramPlanId FROM SportProgramPlan PSPP INNER JOIN SportProgramPlan ASPP … >>> More
Sql Query - Limiting query results

as seen on Stack Overflow - Search for 'Stack Overflow'
I am quite certain we cannot use the LIMIT clause for what I want to do - so wanted to find if there are any other ways we can accomplish this. I have a table which captures which user visited which store. Every time a user visits a store, a row is inserted into this table. Some of the fields are shopping_id… >>> More
hql equivalent query to this sql query

as seen on Stack Overflow - Search for 'Stack Overflow'
Select top 1 from <tablename> what is hql query for the above ? >>> More

Related posts about code-snippets

Five C# Code Snippets

as seen on Dot net Slackers - Search for 'Dot net Slackers'
A snippet is a small section of text or source code that can be inserted into the code of a program. Snippets provide an easy way to implement commonly used code or functions into a larger section of code. Instead of rewriting the same code over and over again, a programmer can save the code [...] Related… >>> More
Multiple CodeSnippet in an XML .snippet file

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm attempting to supplement the help features for my code by providing other developers with code snippets. These produce skeletons of code which demonstrate how to use/call my classes or methods. I've created a .snippet file and have placed it in the "%Visual Studio Folder%\Code Snippets\Visual… >>> More
Fixing the #mvvmlight code snippets in Visual Studio 11

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
If you installed the latest MVVM Light version for Windows 8, you may encounter an issue where code snippets are not displayed correctly in the Intellisense popup. I am working on a fix, but for now here is how you can solve the issue manually. The code snippets MVVM Light, when installed correctly… >>> More
Sphinx, reStructuredText show\hide code snippets

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I've been documenting a software package using Sphinx and reStructuredText. Within my documents, there are some long code snippets. I want to be able to have them hidden as default, with a little "Show\Hide" button that would expand them (Example). Is there a standard way to do that? If not… >>> More
storing code snippets in a database

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey everyone, I want to make a code snippet database web application. Would the best way to store it in the database be to html encode everything to prevent XSS when displaying the snippets on the web page? Thanks for the help! >>> More