Skip to main content

Dev Notes

Dev Notes

Search This Blog

Pages

Home
Helpful Links

Showing posts from March, 2013

Posts

CakePHP: COUNT data and GROUP BY date

on March 26, 2013

+

Get link
Facebook
X
Pinterest
Email
Other Apps

CakePHP : Load Model from other Controller

on March 06, 2013

+

Get link
Facebook
X
Pinterest
Email
Other Apps

Sherwin Robles

Archives

2020 4
- June 2
- May 2

2018 1
- February 1
2017 9
2016 3
- November 1
- May 1
- March 1
2015 2
- April 1
- March 1
2014 8
- December 1
- November 1
- August 1
- June 1
- April 2
- March 1
- January 1
2013 6
2012 6
- December 2
- November 4

Show more Show less

Labels

Ajax
Android
Apache
Blogging
CakePHP
Free Stuffs
JQuery
LAMP
Marketing
MySQL

PhalconPHP
PHP
Security
SEO
Traffic
Ubuntu
Web Design
Web Development

Show more Show less

Popular Posts

CakeAdminLTE is based on AdminLTE Theme for CakePHP 2.4+

CakeAdminLTE v.1.0 CakeAdminLTE is based on Twitter Bootstrap 3.0+ and AdminLTE Theme for CakePHP 2.4+ AdminLTE Dashboard and Control Panel Template Responsive admin template Free & open source Built with Bootstrap 3 Easy to customize Quick Start Download the .zip file Extract the files into your CakePHP folder To enable your theme add the following to your "app/Controller/AppController.php" class: public $theme = " CakeAdminLTE " ; IMPORTANT: If you would like to bake your app, please make sure you have enabled the theme before baking. DOWNLOAD: CakeAdminLTE

CakePHP: COUNT data and GROUP BY date

Easily deploy an SSD cloud server on @DigitalOcean in 55 seconds. Sign up using this link and receive $100 in cloud credits: https://m.do.co/t/335732d1df0b Goal: Count Tip Offs created per day for a month to use for graph Problem: created field name is in datetime format: Y-m-d H:i:s Solution: format SQL Query date: DATE_FORMAT(TipOff.created, '%Y-%m-%d') Inside the function of controller <?php $ tipOffsMonthly = $ this -> TipOff -> find( ' all ' , array ( ' conditions ' => array ( ' AND ' => array ( ' TipOff.electric_cooperatives_id ' => AuthComponent :: User ( ' electric_cooperatives_id ' ) , ' TipOff.created BETWEEN ? AND ? ' => array ( $ first_day , $ last_day ) ) ) , ...

CakePHP: Calling function from other controller

Easily deploy an SSD cloud server on @DigitalOcean in 55 seconds. Sign up using this link and receive $100 in cloud credits: https://m.do.co/t/335732d1df0b Import Controller of the function you want to use. Once you imported the controller you can call any function of this controller. <?php //Import controller App : : import ( 'Controller' , 'SmsOutgoings' ) ; class ReportsController extends AppController { public function add ( ) { $message = "Notification: New report submitted!" ; //Instantiation $SmsOutgoings = new SmsOutgoingsController ; //Call a method from SmsOutgoingsControllerwith parameter $SmsOutgoings - > notify_user ...

CakePHP: Export / Download Database Code

/** * Dumps the MySQL database that this controller's model is attached to. * This action will serve the sql file as a download so that the user can save the backup to their local computer. * * @param string $tables Comma separated list of tables you want to download, or '*' if you want to download them all. */ public function db_mysql_dump($tables = '*') { $return = ''; $modelName = $this->modelClass; $dataSource = $this->{$modelName}->getDataSource(); $databaseName = $dataSource->getSchemaName(); // // Do a short header $return .= '-- Database: `' . $databaseName . '`' . "\n"; $return .= '-- Generation time: ' . date('D jS M Y H:i:s') . "\n\n\n"; if ($tables == '*') { $tables = array(); $result = $this->{$modelName}->query('SHOW TABLES'); foreach($result as $resultKey =...

CakePHP : Updating the session user data after edit

<?php //users controller if ($this -> User -> save($this -> request -> data)) { if ($this -> request -> data[ 'User' ][ 'id' ] == AuthComponent :: User( 'id' )){ //if current logged in user update user session data $this -> Session -> write( 'Auth.User.first_name' , $this -> request -> data [ 'User' ] [ 'first_name' ]); //updating first_name only $this -> Session -> write( 'Auth.User.username' , $this -> request -> data [ 'User' ] [ 'username' ]); //updating username only $this ...

Installing Phalcon Developer Tools 1.3.1 in Ubuntu 13.10 / 14.04

Installing developer tools requires slightly more effort. Download phalcon-developer-tools package here: https://github.com/phalcon/phalcon-devtools Extract it to some convenient path. Via git : git clone git://github.com/phalcon/phalcon-devtools.git Install and create a phalcon symlink: cd phalcon-devtools sudo ./phalcon.sh Create a symbolink link to the phalcon.php script, replace this with the right path: alias phalcon="/home/sherwinrobles/phalcon-devtools/phalcon.php" Remember to restart the console to reload the environment variables. Let’s try it out by listing available commands. phalcon commands Gives me this error: PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20121212/phalcon.so' - /usr/lib/php5/2...

CakePHP | URL Rewrites on IIS7 (Windows hosts / Azure)

IIS7 does not natively support .htaccess files. While there are add-ons that can add this support, you can also import htaccess rules into IIS to use CakePHP’s native rewrites. To do this, follow these steps: 1. Create a new file in your CakePHP root folder, called Web.config. /site/wwwroot/ or /site/wwwroot/cakefolder/ or outside of your app directory 2. Paste this rule to your Web.config. <? xml version = "1.0" encoding = "UTF-8" ?> < configuration > < system . webServer > < rewrite > < rules > < clear /> < rule name = "Imported Rule 0" stopProcessing = "true" > < match url = "^(img|css|files|js)(.*)$" ></ match > < action type = "Rewrite" url = "app/webroot/{R:1}{R:2}" appendQueryString = "false" ></ act...

Setup Basic Apache Web Server in Ubuntu 18.04+ ( LAMP : Linux Apache MySQL PHP)

Update all repository and install all updates :~$ sudo apt-get update && sudo apt-get upgrade Install LAMP ( Linux Apache MySQL PHP) SERVER :~$ sudo apt-get install lamp-server^ select *apache Ubuntu 16.04 below you will be prompted to create mysql password . After this continue to phpmyadmin installation. Ubuntu 18.04 check this tutorial : MySQL in Ubuntu 18.04 :~$ sudo service apache2 restart Server should now be accesible in your browser via http://yourip or http:// localhost Install PHPMyAdmin :~$ sudo apt-get install phpmyadmin For Ubuntu 16.04 below you will be prompted to supply mysql password and supply phpmyadmin user password. For Ubuntu 18.04 you need to create mysql user and password for phpmyadmin. See how here : https://www.digitalocean.com/community/tutorials/how-to-create-a-new-user-and-grant-permissions-in-mysql For Ubuntu 9.10++ and Apache2, the corresponding setting is located in the file /etc/apache2/con...

Installing PhalconPHP in Ubuntu 13.10 / 14.04

Here's how I install PhalconPHP On Linux you can easily compile and install the extension from source code. Requirements We need some packages previously installed: LAMP PHP 5.x development resources GCC compiler sudo apt-get install php5-dev php5-mysql gcc Compilation 1. To create the extension from C source follow these steps: If you dont have git installed you can install it with this command sudo apt-get install git git clone --depth=1 git://github.com/phalcon/cphalcon.git cd cphalcon/build sudo ./install It gives me error: In file included from /usr/include/php5/ext/spl/spl_iterators.h:27:0, ...

Powered by Blogger

Sherwin Robles 2022