Tag: mysql

Doctrine – How to print out the real sql, not just the prepared statement?

We’re using Doctrine, a PHP ORM. I am creating a query like this: and then in the function I’m adding in various where clauses and things as appropriate, like this Later on, before execute()-ing that query object, I want to print out the raw SQL in order to examine it, and do this: However that on…

Tracking the views of a given row

doctrine mysql php symfony1

I have a site where the users can view quite a large number of posts. Every time this is done I run a query similar to UPDATE table SET views=views+1 WHERE id = ?. However, there are a number of disadvantages to this approach: There is no way of tracking when the pageviews occur – they are simply increm…

MySQL datetime fields and daylight savings time — how do I reference the “extra” hour?

datetime dst mysql php timestamp

I’m using the America/New York timezone. In the Fall we “fall back” an hour — effectively “gaining” one hour at 2am. At the transition point the following happens: it’s 01:59:00 -04:00 then 1 …

Duplicate a record in MySQL

mysql php sql

I have a table and I want to duplicate specific rows in the table. I know this is not the best way to do things but we are looking for a quick solution. Here’s something harder than I initially thought, all I need to do is copy an entire record to a new record in an auto-increment table in MySql

MySQL: Join query across multiple databases located on different servers

mysql php

In SQL Server there is a way to join tables from multiple sql servers by using link tables. I wonder whether is it possible to do the same? I am using PHP, does PHP provides this kind of facilities? Answer It isn’t necessarily easy, nor pretty, but this article gives some solutions to your problem: http…

Create PHP array from MySQL column

arrays mysql php

mysql_fetch_array will give me an array of a fetched row. What’s the best way generate an array from the values of all rows in one column?

PDO looping through and printing fetchAll

database fetchall mysql pdo php

I’m having trouble getting my data from fetchAll to print selectively. In normal mysql I do it this way: In PDO, I’m having trouble. I bound the params, then I’m saving the fetched data into $rs like above, with the purpose of looping through it the same way.. Now comes the trouble part. Wha…

Mysql transactions within transactions

mysql php transactions

In a PHP script working with a mysql database, I recently had the need to use a transaction at a point that happened to be inside another transaction. All my tests seem to indicate this is working out fine, but I can’t find any documentation on this usage. I want to be sure – are transactions with…

Invoking a PHP script from a MySQL trigger

mysql php triggers

Is there any way how to invoke a PHP page / function when a record is inserted to a MySQL database table? We don’t have control over the record insertion procedure. Is there a trigger mechanism which can call a PHP script back? Answer The trigger is executed on the MySQL server, not on the PHP one (even…