Skip to content

Tag: php

How do I increment a value with mysql update query (php)

I have a query that looks like this: I want to increment the value as easily as possible. I have tried: I don’t get error messages, but the value in my db does not increase either. Answer If you use the single quotes ‘, you’re telling the enclosed value to be interpreted as a string You were…

Create link in PHP with Get Parameters

php

This page is quite configurable with different parameters. So, it may be called like: Now my question is, what is the idiom for generating a link to the current page but with one parameter changed? For example, I’d like to change foo to 5, what’s the easiest way to generate a link like: I can loop…

Execute raw SQL using Doctrine 2

I want to execute raw SQL using Doctrine 2 I need to truncate the database tables and initialize tables with default test data. Answer I found out the answer is probably: A NativeQuery lets you execute native SQL, mapping the results according to your specifications. Such a specification that describes how an…

Static class initializer in PHP

I have an helper class with some static functions. All the functions in the class require a ‘heavy’ initialization function to run once (as if it were a constructor). Is there a good practice for achieving this? The only thing I thought of was calling an init function, and breaking its flow if it has already …

Replacing a specific part of a query string PHP

I use $_SERVER[‘QUERY_STRING’] to get the query sting. A example would be a=123&b=456&c=789 How could I remove the b value from the query string to obtain a=123&c=789 where b can be any value of any length and is alpha numeric. Any ideas appreciated, thanks. Answer The value is going t…