Skip to main content

Posts

Showing posts with the label cakephp

Format MySQL Select into Associative Array in CakePHP

I like how CakePHP automatically loops through the results of MySQL queries and formats them in a nice map for you. Here's a sample query that I'm using: # Inside some model return $this->query(" SELECT Profile.id, SUM( IF( HOUR(Log.event_one) > 3, 1, 0 ) ) as EventOne FROM profiles Profile JOIN logs Log ON Log.id = Profile.log_id WHERE Profile.id = {$pUserId} "); CakePHP would return a map like the following as the result: array 0 array 'Profile' array 'id' => 23 '0' array 'EventOne' => 108 1 array 'Profile' array 'id' => 23 '0' array 'EventOne' => 42 2 ... What I'm trying to do is have the result be something like this: array 'Profile' array 'id' => 23 'Events' # ^ I want to be ab

Problems With installation of MeioUpload with cakephp 2.0

thanks for reading this, i am working with cakephp 2.0 and making a form to upload some kind of files (rar and zip). I searched a lot and Finally got some plugin named "MeioUpload" and reading this install guide (https://github.com/jrbasso/MeioUpload/blob/master/README.markdown) I did the first two steps without problem, but the third one says "Download an archive from github and extract it in app/Plugin/MeioUpload" I do not know what it means. Which file should i download i do not know could you please help me? I am using windows with github. Here is my model, controller, and view from my project (spanish content) Model <?php class Proyecto extends AppModel { var $name = 'Proyecto'; var $belongsTo = array('Usuario'); var $actsAs = array( 'MeioUpload.MeioUpload' => array('filename') ); var $validate = array( 'name' => array( 'rule' => 'notEmpty'