stajnert

SELECT table_schema,
CONCAT(ROUND(SUM(data_length/(1024*1024)),2),'M') data,
CONCAT(ROUND(SUM(index_length/(1024*1024)),2),'M') idx,
CONCAT(ROUND((SUM(data_length+index_length)/(1024*1024)),2),'M')  total_size
FROM information_schema.tables
GROUP BY table_schema
ORDER BY data_length+index_length  DESC;

SHOW TABLE STATUS FROM etracker;

stajnert

#Gzip
<ifmodule mod_deflate.c>
AddOutputFilterByType DEFLATE text/text text/html text/plain text/xml text/css application/x-javascript application/javascript text/javascript
</ifmodule>
#End Gzip

stajnert

<?php
$this->locations = Doctrine_Core::getTable('location')
                ->createQuery('l')
                ->orderBy("CASE url_slug WHEN :slug THEN '' ELSE name END")
                ->execute(array('slug' => 'london'));

>?

stajnert

<?php
// connect with other database
// $instance - object with new database data
new sfDoctrineDatabase(array(
  'name' => 'instance',
  'dsn' => 'mysql:host=' . $instance->getInstanceDbHost() . ';dbname=' . $instance->getInstanceDbName(),
  'username' => $instance->getInstanceDbUser(),
  'password' => $instance->getInstanceDbPassword(),
));

stajnert

<script type="text/javascript">
$.ajax({
            type: 'POST',
            cache: false,
            data: 'params=' + escape(JSON.stringify(structure)).replace(new RegExp("\\+", "g" ),"%2B"),
            url: '/adm.php/sendregexp',
            success: function(response) {
                var result = jQuery.parseJSON(response);

                if (result.code == 300) {

stajnert

<?php
$values = $request->getParameter($form->getName());
$values['yourdate'] = NEW MODIFIED DATE VALUE;
$form->bind($values, $request->getFiles($form->getName()));
$o = $form->getObject();
$o->save(); 
?>