Populating a CakePHP Form with MySQL Default Values.

Sometimes it can be handy to fill a form with defaults.

Tagged with Web Development and CakePHP
Posted on 12/9/09 by Paul Herron

Here's a quick tip for populating a form with the MySQL defaults. Take the following schema, for example, of editions of an email newsletter:

DROP TABLE IF EXISTS editions;
 
CREATE TABLE editions (
        id int(8) NOT NULL AUTO_INCREMENT,
        title varchar(255) DEFAULT 'Coming up this week...',
        created datetime DEFAULT NULL,
        modified datetime DEFAULT NULL,
        PRIMARY KEY (id)
);

In this case, I'm taking the Edition.title field as one the user might want to change, but would most likely just use a default value for. Populating the form field with that default is simple using Model::create():

<?php class EditionsController extends AppController {       function add() {         if(empty($this->data)) {                         $this->data = $this->Edition->create();               } else {                   if($this->Edition->save($this->data)) {                     $this->Session->setFlash('Edition saved.');          } else {         $this->Session->setFlash('Sorry. That edition could not be saved.');                      }           }    } } ?>
  
	
Comments
	
 		
		
  
			Lina			wrote on 26/8/11:
		
		TYVM you've soveld all my problems 		
		
  
			iiykaf			wrote on 27/8/11:
		
		kt95dS , [url=http://mvhpoclemosj.com/]mvhpoclemosj[/url], [link=http://wsjatdwdzxze.com/]wsjatdwdzxze[/link], http://qgmzyxljysxc.com/ 		
		
  
			Taledin			wrote on 4/9/11:
		
		 http://www.medicationcosts.net/ how to get prescription accutane =OO http://www.gethealthonline.net/ seroquel cheap kqu  		
		
  
			4 card			wrote on 17/10/11:
		
		
I added your blog to my bookmarks and can return within the futureto your weblog. Keep up that exciting job, have 

an excellent daytime!
 		
		
 			ロレックス 偽物			wrote on 14/12/11:
		
		
 
だからあなたがヴィンテージによってヴィンテージハンドバッグを収集できないことを問題に出くわすでしょう。彼らは代わりに、機能のファッションデザインにもっと注意を払う。しかし私は人のこの種ではないが、私はそれらのコーチの愛好家に異なるリフレッシュハンドバッグをお勧めすることができます。 ロレックス 偽物 あなたのライフスタイルと個性のスタイルにマッチするハンドバッグの多くの安価なこのブランドがあります。 ロレックス 偽物 販売 ここには、手頃な価格のオンライン親愛なるコーチをしないようにするかというスタイルが見つかります。
あなたの名前がランダムな順序の選択からピックアップされた後、任意のコーチのアウトレット店でメールや手で表示されます。yienognoformy 
 		
		
  
			Biana			wrote on 24/12/11:
		
		Great inshigt. Relieved I'm on the same side as you. 		
		
  
			bhkltn			wrote on 24/12/11:
		
		qrok1v  qmxytutkuxav 		
		
 			penny			wrote on 27/12/11:
		
		
It is the time for you to find a good hair product to make you become distinguished in the crowd and the new GHD Boho Chic is your best choice. The new GHD green spring with the sexy but glossy  appearance is definitely the necessity of female's accessories. GHD Green are hoting sale in australia. They are also precious limited edition gift set for Christmas.If you buy those GHD Glamour during Christmas day.You can enjoy a lot of price preferential policies. GHD Pink Orchid has now appear to be accessible to guys and females all higher when compared with globe. So GHD New Wave may be the type synonymous, truly quite a few women are this sort of as  being the attractiveness and style hairstyle.I took two bites also GHD MK5 White wasnt that good; the 3rd bite was even even worse there could possibly be regarded as a humorous taste to GHD Pink Limited Edition  shop it. The actual curls playe a job inside surrounding GHD Purple Indulgence confront along with reflect the natural elegance of an girl.
 		
		
  
			cartier santos 100 watch			wrote on 28/12/11:
		
		
Hi I am visit your personal blogs in addition to research articles. Your website in addition to companies are incredibly great. I am truly astonished from your assistance.
 		
		
  
			ChaquetasBelstaff			wrote on 3/1/12:
		
		


Belstaff Bolsa Los datos más recientes mostraron China foreign exchange Trade Center, el 29 de noviembre, la tasa de paridad central de 6.3587 Yuan frente al dólar, una devaluación Belstaff Chaquetas Hombres del anterior período de sesiones 2 puntos de base, comparado Belstaff chaquetas Mujeres con el 31 de octubre tasa de paridad central de 6.3233 renminbi?os en el futuro el Yuan cayó frente al dólar, mostrar la devaluación del renminbi en las expectativas del mercado hacia adelante.Belstaff Chaquetas icon 　　"Depreciación MBT Zapatos actual renminbi debido principalmente a China en octubre representaron un crecimiento negativo de refugio deberá iniciar cierto nivel salida de capital a corto plazo. "Banco de comunicaciones, centro de investigación financiera investigador e Belstaff chaquetas Mujeres, pero los márgenes de ganancia en el mercado inmobiliario se más comprimirán, bajo la influencia de la turbulencia en los mercados financierosBelstaff Chaquetasinternacionales, en el mercado de valores de China masivos,. que a su vez afecta la tasa de cambio del Renminbi MBT Outlet

  
	
  
	
Leave a Comment
	
 
	

		 
		 
		
Your Name
 
		
Your Website
 
			 
	
Enter the characters shown in the image below 
Not case sensitive.[Refresh]
 
 
		
Your Comment
 
	
 
 
	
« Articles