<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-2718725303768725971</id><updated>2024-11-05T19:00:54.821-08:00</updated><category term="tips and tricks"/><category term="PHP"/><category term="Windows"/><category term="Codeigniter"/><category term="MYSQL"/><category term="Linux"/><title type='text'>Obinote</title><subtitle type='html'>just want to share about my knowledge</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>14</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-8662679655738866735</id><published>2012-07-22T03:22:00.000-07:00</published><updated>2012-07-22T03:24:43.778-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips and tricks"/><category scheme="http://www.blogger.com/atom/ns#" term="Windows"/><title type='text'>Show Hidden Files and Folder</title><content type='html'>&lt;div align=&quot;justify&quot;&gt;
Read Indonesian Version &lt;a href=&quot;http://adfoc.us/364237189547&quot; target=&quot;_blank&quot;&gt;Here&lt;/a&gt;&lt;br /&gt;
&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;Have&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;you&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;ever had&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;an&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;empty&lt;/span&gt; flashdisk&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;or&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;some&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;folder&lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;/&lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;file&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;disappear&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;when&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;viewed&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;using&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;Windows Explorer&lt;/span&gt;, &lt;span class=&quot;hps&quot;&gt;but&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;when&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;use &quot;&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;right-clicked&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt; &lt;/span&gt;&lt;span class=&quot;hps&quot; style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;--&lt;/span&gt;&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;&amp;gt; &lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;Properties&lt;/span&gt;&quot;&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;there is a&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;space&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;that is used&lt;/span&gt;. &lt;span class=&quot;hps&quot;&gt;Well&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;..&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;if&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;you are&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;experiencing&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the same problem&lt;/span&gt;, &lt;span class=&quot;hps&quot;&gt;do not&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;format&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the flashdisk,&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;because chances are&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;your data&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;is&lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;hidden&lt;/span&gt;&lt;span class=&quot;&quot;&gt;.&lt;/span&gt;&lt;/span&gt; &lt;/div&gt;
&lt;div align=&quot;justify&quot;&gt;
&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;I try to&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;share&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;a little&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;knowledge to&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;all&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;to&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;deal with&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;this&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;problem&lt;/span&gt;. &lt;span class=&quot;hps&quot;&gt;OK&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;just&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;do like this&lt;/span&gt;&lt;span class=&quot;&quot;&gt;.&lt;/span&gt;&lt;/span&gt; &lt;/div&gt;
&lt;div&gt;
&lt;/div&gt;
&lt;ol&gt;
&lt;li&gt;   &lt;div align=&quot;justify&quot;&gt;
Open your Windows Explore, enter to &lt;b&gt;&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;Tools --&amp;gt; Folder Options --&amp;gt; View&lt;/span&gt;&lt;/b&gt;. Then Select&amp;nbsp; &lt;b&gt;&lt;i&gt;Hidden files and Folders&lt;/i&gt;&lt;/b&gt; chose &lt;i&gt;&lt;a href=&quot;http://obinote.blogspot.com/2012/07/show-hidden-files-and-folder.html&quot; target=&quot;_blank&quot;&gt;&lt;b&gt;Show Hidden files and Folders&lt;/b&gt;&lt;/a&gt;. click&lt;/i&gt; &lt;b&gt;OK&lt;/b&gt;. &lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;If this&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;can&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;not&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;display the&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;file&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;/&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;folder&lt;/span&gt;, &lt;span class=&quot;hps&quot;&gt;let&#39;s do the second way.&lt;/span&gt;&lt;/span&gt;

&lt;/div&gt;
&lt;/li&gt;
&lt;div align=&quot;center&quot;&gt;
&lt;img border=&quot;0&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPgZUA95-j-VN3gYnhIagiHv_pm43DJP-rnErEqK-s8iDIJgvtw_cUFMf91GiraeBrsUhLKMdQynIleeFoaPZWJTjFhPngsTTj97D_Cy4_PnaT0Dj3vD6Av2L4ww_VxnWq6-6X9K8u7og/s1600/folder-opt.gif&quot; /&gt;

&lt;/div&gt;
&lt;div&gt;
&lt;/div&gt;
&lt;div align=&quot;center&quot;&gt;
&lt;img border=&quot;0&quot; height=&quot;118&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEisEWQIZMBWM7sy6wKAf8aQOuBVjhUCX9b-okDT8C3QQ6DT4PpcMkuJ9BJ79J6C8cCT1PVXanNO9d6Xgwfg-PxiAeoY0vF0lEFTfh88Uy2TNiM7DymLY30bzzss6SHG1pCgGqryXRV6IB0/s320/show-hidden1.gif&quot; width=&quot;320&quot; /&gt;

&lt;/div&gt;
&lt;li&gt;   &lt;div align=&quot;justify&quot;&gt;
The second way is using Command Prompt. &lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;This method can&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;be an alternative.&lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;ul&gt;
&lt;li&gt;         &lt;div align=&quot;justify&quot;&gt;
First Open Commang Prompt from &lt;b&gt;run &lt;/b&gt;(&lt;i&gt; &lt;b&gt;Window + R&lt;/b&gt;&lt;/i&gt; ) then press &lt;b style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;CMD&lt;/b&gt; and Enter. &lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;When the&lt;/span&gt; window&amp;nbsp;&lt;span class=&quot;hps atn&quot;&gt;&lt;/span&gt;console &lt;span class=&quot;hps&quot;&gt;is out&lt;/span&gt;, type the &lt;span class=&quot;hps&quot;&gt;name of the&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;drive&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;to&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;position&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;your flashdisk&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;example&lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt; &lt;span class=&quot;hps atn&quot;&gt;&quot;&lt;/span&gt;H:&quot; &lt;span class=&quot;hps&quot;&gt;and press&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;Enter&lt;/span&gt;&lt;/span&gt;. &lt;/div&gt;
&lt;/li&gt;
&lt;div align=&quot;center&quot;&gt;
&lt;img border=&quot;0&quot; height=&quot;242&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh8deK2U-9iMyCFLi8AAYkwqDLuo28b4UoYSVeylCKvlkKGCIWipVNbIVjBebDkUMGBbcseTnj4ZPk-SNn5cCOS08Yh_M216lQ7kOWKnJTbQ4xR3wvH4URafCaVCZkJmDfukmiCV_Q27xA/s400/untitled.JPG&quot; width=&quot;400&quot; /&gt;      &lt;/div&gt;
&lt;li&gt;         &lt;div align=&quot;justify&quot;&gt;
&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;When you have entered&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;on the H drive&lt;/span&gt;, &lt;span class=&quot;hps&quot;&gt;like&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the picture above&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;type &lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;i style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;attrib -r -h -s /s /d&lt;/i&gt;&lt;/b&gt;&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt; and press&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;Enter&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;so that it becomes&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;as&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;follows&lt;/span&gt;&lt;/span&gt;.&lt;/div&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;div align=&quot;justify&quot;&gt;
&lt;blockquote&gt;
&lt;div align=&quot;center&quot;&gt;
&lt;b&gt;&lt;i style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;H:\&amp;gt;attrib -r -h -s /s /d&lt;/i&gt;&amp;nbsp;&lt;/b&gt;&lt;/div&gt;
&lt;/blockquote&gt;
&lt;/div&gt;
&lt;/div&gt;
&lt;div align=&quot;justify&quot;&gt;
&lt;ul&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;Wait until the &lt;b&gt;&lt;i style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;H:\&amp;gt;_&lt;/i&gt;&lt;/b&gt; shown, and this the simple way to show hidden file / folder.&lt;/li&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;Change the &lt;b&gt;&quot;&lt;span style=&quot;font-family: &amp;quot;Courier New&amp;quot;,Courier,monospace;&quot;&gt;-&lt;/span&gt;&quot; &lt;/b&gt;into &quot;+&quot; if you want to set hide back .&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;/li&gt;
&lt;/ol&gt;
&lt;div align=&quot;center&quot;&gt;
&lt;h3&gt;



  &lt;b&gt;***Good Luck***&lt;/b&gt;&lt;/h3&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/8662679655738866735/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/07/show-hidden-files-and-folder.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/8662679655738866735'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/8662679655738866735'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/07/show-hidden-files-and-folder.html' title='Show Hidden Files and Folder'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPgZUA95-j-VN3gYnhIagiHv_pm43DJP-rnErEqK-s8iDIJgvtw_cUFMf91GiraeBrsUhLKMdQynIleeFoaPZWJTjFhPngsTTj97D_Cy4_PnaT0Dj3vD6Av2L4ww_VxnWq6-6X9K8u7og/s72-c/folder-opt.gif" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-1027564795657804340</id><published>2012-07-10T07:07:00.000-07:00</published><updated>2012-07-23T07:08:42.836-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Codeigniter"/><category scheme="http://www.blogger.com/atom/ns#" term="tips and tricks"/><title type='text'>Upgrade Codeigniter Version 2.1.0 to 2.1.2</title><content type='html'>&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;Read Indonesian version &lt;a href=&quot;http://adfoc.us/364237491838&quot; target=&quot;_blank&quot;&gt;here &lt;/a&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;A few weeks&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;ago&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;codeigniter&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;was&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;release&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the newest&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;version&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;2.1.2&lt;/span&gt;&lt;span&gt;.&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;Then how do we&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;upgrade&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;CodeIgniter&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;version&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;2.1.0&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;or&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;2.1.1&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;to version&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;2.1.2&lt;/span&gt;&lt;span&gt;.&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;Here are&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;step&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;by step&lt;/span&gt;&lt;span class=&quot;&quot;&gt;.&lt;/span&gt;&lt;/span&gt; &lt;br /&gt;
&lt;ol&gt;
&lt;li&gt;Download newest version &lt;a href=&quot;http://adfoc.us/364236052484&quot; target=&quot;_blank&quot;&gt;here&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;Set your site into offline mode&lt;/li&gt;
&lt;li&gt;Create backup from your file/folder.&lt;/li&gt;
&lt;li&gt;Replace all file in folder &quot;system&quot; and replace file index.php, with new file has been downloaded (codeigniter versi 2.1.2)
    &lt;br /&gt;Note : If you have any custom file in this folder, copy and paste it from backup.&lt;/li&gt;
&lt;li&gt;Replace file mime.php located on the config/mime.php&lt;/li&gt;
&lt;li&gt;&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;To&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;get support&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;IPv6&lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt;&lt;span&gt;,&lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt;&amp;nbsp;&lt;span class=&quot;hps&quot;&gt;upgrade &lt;/span&gt;&lt;/span&gt;field IP_address&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;to 45&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;characters&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;&lt;/span&gt;&lt;/span&gt;&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps alt-edited&quot;&gt;for example.&lt;/span&gt;&lt;/span&gt;
    &lt;br /&gt;ALTER TABLE ci_sessions Ganti IP_address IP_address varchar (45) standar &#39;0 &#39;NOT NULL
    &lt;/li&gt;
&lt;li&gt;If you have codeigniter version 2.1.1 &lt;span class=&quot;short_text&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;just&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;go to step&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;no. 3&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;/ol&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/1027564795657804340/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/07/upgrade-codeigniter-version-210-to-212.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/1027564795657804340'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/1027564795657804340'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/07/upgrade-codeigniter-version-210-to-212.html' title='Upgrade Codeigniter Version 2.1.0 to 2.1.2'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-1232309098488530063</id><published>2012-06-29T06:32:00.000-07:00</published><updated>2012-07-03T06:39:27.025-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Codeigniter"/><category scheme="http://www.blogger.com/atom/ns#" term="PHP"/><title type='text'>Create View on CodeIgniter</title><content type='html'>&lt;div style=&quot;text-align: justify;&quot;&gt;
Read The &lt;a href=&quot;http://adfoc.us/364236846154&quot; target=&quot;_blank&quot;&gt;Indonesian Version&lt;/a&gt;&lt;br /&gt;
&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;This time the&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;authors would like to&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;share&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;a little&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;knowledge&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;about&lt;/span&gt; using&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;MVC model&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;in&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;CodeIgniter&lt;/span&gt;, &lt;span class=&quot;hps&quot;&gt;for&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;this example&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;we&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;try&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;to&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;discuss how to &lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;Create&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;View&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;on&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;CodeIgniter&lt;/span&gt;. &lt;span class=&quot;hps&quot;&gt;Before starting&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;make sure you have&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the required below&lt;/span&gt;&lt;/span&gt; &lt;/div&gt;
&lt;ul&gt;
&lt;li&gt;Codeigniter versi 2.1.0 can download &lt;a href=&quot;http://adfoc.us/364236845929&quot; target=&quot;_blank&quot;&gt;here&lt;/a&gt;&lt;/li&gt;
&lt;li&gt;Create database with name &quot;latihan&quot; &lt;/li&gt;
&lt;/ul&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
For the first create Table &quot;user&quot; :&lt;/div&gt;
&lt;pre class=&quot;brush:php&quot;&gt;&amp;nbsp;
id (int 4) autoincrement

username (varchar 30)

access (varchar 10) 
&amp;nbsp;
&lt;/pre&gt;
and insert into table, min 2 record.&lt;br /&gt;
&lt;br /&gt;
Next create file &quot;view.php&quot; put on application-&amp;gt;controller&lt;br /&gt;
&lt;pre class=&quot;brush:php&quot;&gt;&amp;nbsp;
&amp;lt;?php if ( ! defined(&#39;BASEPATH&#39;)) exit(&#39;No direct script access allowed&#39;);

class View extends CI_Controller{

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; function __construct(){

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; parent::__construct();

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $this-&amp;gt;load-&amp;gt;model(&quot;crud&quot;);
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; function index(){

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $data[&#39;title&#39;]=&quot;View User&quot;;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $data[&#39;header&#39;]=&quot;View User&quot;;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $data[&#39;query&#39;]=$this-&amp;gt;crud-&amp;gt;view();

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $this-&amp;gt;load-&amp;gt;view(&#39;view&#39;,$data);

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; }
?&amp;gt;
&amp;nbsp;
&lt;/pre&gt;
Then create file &quot;view.php&quot;, at this time place on application-&amp;gt;view
&lt;br /&gt;
&lt;pre class=&quot;brush:html&quot;&gt;&amp;nbsp;
&amp;lt;table&amp;gt;

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;thead&amp;gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;tr&amp;gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;th&amp;gt;No&amp;lt;/th&amp;gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;th&amp;gt;User&amp;lt;/th&amp;gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;th&amp;gt;Access&amp;lt;/th&amp;gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/tr&amp;gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/thead&amp;gt;

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;tbody&amp;gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;?php
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $no = 1;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; foreach($query as $row){
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp; ?&amp;gt; 
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;tr&amp;gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp; &amp;lt;td&amp;gt;&amp;lt;?php echo $no;?&amp;gt;&amp;lt;/td&amp;gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp; &amp;lt;td&amp;gt;&amp;lt;?php echo $row-&amp;gt;username;?&amp;gt;&amp;lt;/td&amp;gt;
&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp; &amp;lt;td&amp;gt;&amp;lt;?php echo $row-&amp;gt;access;?&amp;gt;&amp;lt;/td&amp;gt; &amp;nbsp; 
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/tr&amp;gt;
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;?php $no ++; &amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; } 
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; ?&amp;gt; 
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;lt;/tbody&amp;gt;

&amp;lt;/table&amp;gt;

&amp;nbsp;&lt;/pre&gt;
For the last, create file &quot;crud.php&quot; place it on application-&amp;gt;model

&lt;br /&gt;
&lt;pre class=&quot;brush:php&quot;&gt;&amp;nbsp;
&amp;lt;?php if ( ! defined(&#39;BASEPATH&#39;)) exit(&#39;No direct script access allowed&#39;);

class Crud extends CI_Model{

&amp;nbsp;&amp;nbsp;&amp;nbsp; function view_user(){
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; #Table Properties
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $tabel = &quot;user&quot;;

&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; #Query
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; $query = $this-&amp;gt;db-&amp;gt;select(&quot;*&quot;)-&amp;gt;from($tabel)-&amp;gt;get();
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; if ($query-&amp;gt;num_rows() &amp;gt; 0) {
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp; return $query-&amp;gt;result();
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; } else {
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp; return array();
&amp;nbsp;&amp;nbsp;&amp;nbsp; &amp;nbsp;&amp;nbsp;&amp;nbsp; }
&amp;nbsp;&amp;nbsp;&amp;nbsp; }
}
?&amp;gt;&amp;nbsp;&lt;/pre&gt;
type on address bar www(dot)example(dot)com/index(dot)php?/view</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/1232309098488530063/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/07/create-view-on-codeigniter.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/1232309098488530063'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/1232309098488530063'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/07/create-view-on-codeigniter.html' title='Create View on CodeIgniter'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-4017298484624423582</id><published>2012-06-08T05:25:00.000-07:00</published><updated>2012-07-03T06:15:22.543-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Codeigniter"/><category scheme="http://www.blogger.com/atom/ns#" term="PHP"/><title type='text'>Introduction to Codeigniter</title><content type='html'>&lt;style type=&quot;text/css&quot;&gt;
    #c{
        text-align: center;
    }
    #j{
        text-align: justify;
    }
    #cd{
        font-family: cursive;
    }
&lt;/style&gt;
&lt;br /&gt;
&lt;div&gt;
&lt;div id=&quot;j&quot;&gt;
&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;Read The &lt;a href=&quot;http://adfoc.us/364236672264&quot; target=&quot;_blank&quot;&gt;Indonesian Version&lt;/a&gt;&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
CodeIgniter is open source PHPFramework. It&#39;s free to use and manipulate as you wish. CodeIgniter uses MVC (Model View Controller) model programming. MVC is a programming concept where logic and layout are separated, so that the programmers and designers can do their job in focus. Codeigniter can download &lt;a href=&quot;http://adfoc.us/364236052484&quot; target=&quot;_blank&quot;&gt;here&lt;/a&gt;.&lt;/div&gt;
&lt;div id=&quot;j&quot;&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7aFaZelo7oO1FH6NFlxHj7Xh8SXDmQMT73Lzi3uDLnFSdpCKwfZYcFHpQkIWb2KpYQkcOwgk7Eh5VMX-7FG1Q1c9pv8ZvEvmthqYA9fjAfLlPCpjCDtrMKtYRgrO2Xgab3CDLV-9GmcP2/s1600/ash-mvc-architecture.gif&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;274&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7aFaZelo7oO1FH6NFlxHj7Xh8SXDmQMT73Lzi3uDLnFSdpCKwfZYcFHpQkIWb2KpYQkcOwgk7Eh5VMX-7FG1Q1c9pv8ZvEvmthqYA9fjAfLlPCpjCDtrMKtYRgrO2Xgab3CDLV-9GmcP2/s320/ash-mvc-architecture.gif&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
&lt;span class=&quot;short_text&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;P&lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;icture&lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;MVC&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;model &lt;/span&gt;&lt;/span&gt;&lt;span class=&quot;short_text&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;programming&lt;/span&gt; &lt;/span&gt;&lt;/div&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div id=&quot;j&quot;&gt;
&lt;b&gt;Model&lt;/b&gt; &lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;Used to process the&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;database&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;in this case is&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;CRUD&lt;/span&gt;&lt;/span&gt; (Create, Read, Update, Delete)&lt;/div&gt;
&lt;div id=&quot;j&quot;&gt;
&lt;b&gt;Controller&lt;/b&gt; &lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;Class&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;and&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;/&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;or&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;function&lt;/span&gt; &lt;span class=&quot;hps alt-edited&quot;&gt;that will&lt;/span&gt; &lt;span class=&quot;hps alt-edited&quot;&gt;be called on&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the browser&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;address bar&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;and&lt;/span&gt; &lt;span class=&quot;hps alt-edited&quot;&gt;use&lt;/span&gt; &lt;span class=&quot;hps alt-edited&quot;&gt;to get&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;query results&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;from the model&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;and then&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;display it on the&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;view&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div id=&quot;j&quot;&gt;
&lt;b&gt;View&lt;/b&gt; &lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;Here is&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;WEB&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;design&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;area&lt;/span&gt;, &lt;span class=&quot;hps&quot;&gt;here&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;they are working&lt;/span&gt; &lt;span class=&quot;hps alt-edited&quot;&gt;enhance&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the data&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;display&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;query&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;results&lt;/span&gt;, &lt;span class=&quot;hps&quot;&gt;by adding the&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;CSS&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;and&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;JS&lt;/span&gt;&lt;/span&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;For the begining let us give instance, how to create &quot;Hello PHP&quot; with controller and view.&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;div ig=&quot;j&quot;&gt;
&lt;span class=&quot;short_text&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;Create&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;a&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;php&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;file&lt;/span&gt; &lt;span class=&quot;hps alt-edited&quot;&gt;and rename it&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;with&lt;/span&gt;&lt;/span&gt; &lt;span id=&quot;cd&quot;&gt;c_hello.php&lt;/span&gt;, copy this following code &lt;/div&gt;
&lt;pre class=&quot;brush:php&quot;&gt;&amp;nbsp;
&amp;lt;?php if ( ! defined(&#39;BASEPATH&#39;)) exit(&#39;No direct script access allowed&#39;);
class C_hello extends CI_Controller{
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 
   function __construct(){
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 
     parent:: __construct();
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 
   }
&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; 
   function index(){ 
     $data[&#39;hello&#39;] = &quot;Hello PHP&quot;;
     $this-&amp;gt;load-&amp;gt;view(&#39;v_hello&#39;,$data);
   }
}
?&amp;gt;
&amp;nbsp; &lt;/pre&gt;
&lt;div ig=&quot;j&quot;&gt;
Second create view and named it with v_hello&lt;span id=&quot;cd&quot;&gt;.php&lt;/span&gt;, copy this following code&lt;/div&gt;
&lt;pre class=&quot;brush:php&quot;&gt;&amp;nbsp;
&amp;lt;?= $hello; ?&amp;gt;
&amp;nbsp;&lt;/pre&gt;
&lt;/div&gt;
&lt;div ig=&quot;c&quot;&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
** GOOD LUCK **&lt;/div&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/4017298484624423582/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/06/introduction-to-codeigniter.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/4017298484624423582'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/4017298484624423582'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/06/introduction-to-codeigniter.html' title='Introduction to Codeigniter'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7aFaZelo7oO1FH6NFlxHj7Xh8SXDmQMT73Lzi3uDLnFSdpCKwfZYcFHpQkIWb2KpYQkcOwgk7Eh5VMX-7FG1Q1c9pv8ZvEvmthqYA9fjAfLlPCpjCDtrMKtYRgrO2Xgab3CDLV-9GmcP2/s72-c/ash-mvc-architecture.gif" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-3057038819692596434</id><published>2012-05-18T20:48:00.001-07:00</published><updated>2012-06-07T07:30:36.411-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips and tricks"/><category scheme="http://www.blogger.com/atom/ns#" term="Windows"/><title type='text'>Create Page Number Different Format In One File Ms. Word 2007</title><content type='html'>&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;Read The &lt;a href=&quot;http://adfoc.us/364235580649&quot; target=&quot;_blank&quot;&gt;Indonesian Version&lt;/a&gt;&lt;/span&gt;&lt;/span&gt;

&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;In the past&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;when I&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;make a&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;proposal&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;regarding the&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;final project&lt;/span&gt;.&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;I was looking&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;on the internet&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;about&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;how&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;to&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;create&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;different&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;page&lt;/span&gt; number &lt;span class=&quot;hps&quot;&gt;format.&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;The first&lt;/span&gt; &lt;/span&gt;&lt;span class=&quot;short_text&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;numeral&lt;/span&gt;&lt;/span&gt;&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;and the second&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;decimal.&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;Finally &lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;I&lt;/span&gt;&amp;nbsp;&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;found&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the article&lt;/span&gt; &quot;&lt;/span&gt;&lt;i&gt;Menyisipkan Format Nomor Halaman yang Berbeda dalam Satu File Word 2007&lt;/i&gt;&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&quot; &lt;span class=&quot;hps&quot;&gt;on&lt;/span&gt;&lt;/span&gt; &lt;a href=&quot;http://arihdyacaesar.wordpress.com/&quot;&gt;Arihdya Caesar&#39;s Blog&lt;/a&gt;.&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;&quot;&gt;&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;Here are the&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;steps&lt;/span&gt; by&lt;span class=&quot;hps&quot;&gt; step&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;that&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;I do from&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the reference&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;article&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;
&lt;ol&gt;
&lt;li&gt;Open your file that will be given page number&lt;/li&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;Give&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the page&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;with&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the roman numeral&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;format&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;on all&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;pages&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;&quot;&lt;/span&gt;&lt;/span&gt;&lt;b&gt;Insert-&amp;gt;Page Number-&amp;gt;Format Page Number&quot;&lt;/b&gt;, on &lt;b&gt;Number Format&lt;/b&gt; choose the roman numeral then press &lt;b&gt;OK&lt;/b&gt;&lt;/li&gt;
&lt;br /&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;img border=&quot;0&quot; height=&quot;228&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZLS1YWon6oX-C_IV7R8HG99RuU7io1VEL3T7DCqQ5O8QarcL9dQPjL42uvI0AoF96zU9lw3YIjGTFcorYKVNjt4NKIiiQ0O3Pqkeuk9dMGRIXGzdCmt8cYFo8tULQ_cs5htB16vVv4iI/s1600/Untitle-1.jpg&quot; width=&quot;320&quot; /&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;Set &lt;b&gt;Page Number&lt;/b&gt; depend on the &lt;b&gt;Bottom of Page&lt;/b&gt;, &lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;actually&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;up to you&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;to&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;put&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;where&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;depends on your taste&lt;/span&gt;&lt;/span&gt;&lt;/li&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span class=&quot;short_text&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;Next&lt;/span&gt; &lt;span class=&quot;hps alt-edited&quot;&gt;specify&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;on&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;number of&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;pages will placed the&lt;/span&gt;&lt;/span&gt;&lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;decimal numbers&lt;/span&gt;&lt;/span&gt;&lt;b&gt;&lt;/b&gt;. &lt;span class=&quot;&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;In this case&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;I&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;chose&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;the&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;sixth pages as the first of &lt;/span&gt;&lt;span class=&quot;hps&quot;&gt;&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;decimal&lt;/span&gt;&lt;/span&gt;.&lt;/li&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;Place the kursor in front of the first letter, and then choose menu &lt;b&gt;Page Layout-&amp;gt;Breaks-&amp;gt;Next Page&lt;/b&gt;&lt;/li&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;img border=&quot;0&quot; height=&quot;228&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiwb3CQ5PTZD8osxirWYmvnmbkLysrv5PDiFFhwPd3cNa7D33km2RDhdIJQSbLtTGZORqS-4Iw-mh0iebkOX-ZcM8qsc5coHBW7Bp5TKrEoAVPIbH5mL6zaJ3ewtzGPu2fwPD6U9HzxlUM/s1600/Untitled-1.jpg&quot; width=&quot;320&quot; /&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;For the next step do &lt;span class=&quot;short_text&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;do&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;step number&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;2&lt;/span&gt;&lt;/span&gt;,&lt;span class=&quot;short_text&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt; this time&lt;/span&gt; &lt;span class=&quot;hps&quot;&gt;change&lt;/span&gt;&lt;/span&gt; &lt;b&gt;Page Number Format&lt;/b&gt; to number 1, 2, 3,...&lt;/li&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;&lt;span class=&quot;short_text&quot; id=&quot;result_box&quot; lang=&quot;en&quot;&gt;&lt;span class=&quot;hps&quot;&gt;And see the results on the sixth&lt;/span&gt;&lt;/span&gt;&lt;i&gt;&lt;/i&gt; &lt;b&gt;Page Number Format&lt;/b&gt; turn into decimal number.&lt;/li&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;To set the &quot;sixth&quot; into &quot;first&quot; &lt;b&gt;Double klick&lt;/b&gt; on &quot;4&quot;-&amp;gt;select&lt;b&gt; Page Number Format&lt;/b&gt; set &lt;b&gt;Page Numbering-&amp;gt;Start at&lt;/b&gt; fill with &quot;1&quot; and see the &quot;6&quot; turn into &quot;1&quot;.&lt;/li&gt;
&lt;/ol&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
**GOOD LUCK**&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/3057038819692596434/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/05/create-page-number-different-format-in.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/3057038819692596434'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/3057038819692596434'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/05/create-page-number-different-format-in.html' title='Create Page Number Different Format In One File Ms. Word 2007'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZLS1YWon6oX-C_IV7R8HG99RuU7io1VEL3T7DCqQ5O8QarcL9dQPjL42uvI0AoF96zU9lw3YIjGTFcorYKVNjt4NKIiiQ0O3Pqkeuk9dMGRIXGzdCmt8cYFo8tULQ_cs5htB16vVv4iI/s72-c/Untitle-1.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-4857867507087507165</id><published>2012-05-17T03:41:00.000-07:00</published><updated>2012-05-18T19:28:21.733-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips and tricks"/><category scheme="http://www.blogger.com/atom/ns#" term="Windows"/><title type='text'>Create Table of Content Using Ms. Office 2007</title><content type='html'>&lt;div style=&quot;text-align: justify;&quot;&gt;
Read The &lt;a href=&quot;http://adfoc.us/364235575082&quot; target=&quot;_blank&quot;&gt;Indonesian Version&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
A table of contents, is a list of the parts of a book or document organized in the order in which the parts appear. The contents usually includes the titles or descriptions of the first-level headers, such as chapter titles in longer works, and often includes second-level or section titles within the chapters as well, and occasionally even third-level titles. The depth of detail in tables of contents depends on the length of the work, with longer works having less. The table of contents usually appears after the title page, copyright notices, and, in technical journals, the abstract; and before any lists of tables or figures, the foreword, and the preface.

How do We make it?. We just practice how to make a clean table of contents using &lt;b&gt;&lt;u&gt;Tab&lt;/u&gt;&lt;/b&gt; and &lt;b&gt;&lt;u&gt; Ruler&lt;/u&gt;&lt;/b&gt;
&lt;/div&gt;
&lt;ol&gt;
&lt;li&gt;Prepared Ms. Office 2007&lt;/li&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;Open Ms. Word, if you first use the Ms. Word, you must enable &lt;b&gt; Ruler &lt;/b&gt;. Located at view menu and check the &lt;b&gt; Ruler &lt;/b&gt;&lt;/li&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;Next type all the points - points that will be placed in the table of contents, such as: Title of page, Abstract, Certification Sheet, Chapter I, Chapter II, etc.&lt;/li&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://www.blogger.com/blogger.g?blogID=2718725303768725971#&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;229&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiSUlKf0veXuV8DClr8Hgwg9hnFWNjNCrOX4I8qydbwYGfxwwtFLTm-YboBvzO01gNgxutIJxp97a3v0OfPhg0DkgjD412GVRTtJxbxX8eE3FyH4ggSev7SYeDWyykZt0wyN6z-kmoWhg/s1600/Untitled-1.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;Block all typed list of contents and click on the ruler right on the far right position, or whatever you like. when you already have a tab mark. double click the sign.&lt;/li&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://www.blogger.com/blogger.g?blogID=2718725303768725971#&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;129&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEio3-n13ZP9ZT_oOopDPY1wAIBxh1DVjNY3hcG_iAC1RL5-pUJR4QMESWnRSKN59SoPvDovRl5RtBYDJ-yaCoGUsCoLmV4owtABO7UV6c4MfVlhQYZT6dj98OKdz366LIDpDIs9MPPDTEE/s1600/Untitled-2.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;li&gt;After the Tab Form appears, Change the settings as shown below&lt;/li&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://www.blogger.com/blogger.g?blogID=2718725303768725971#&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;226&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6HeQJbNvL_StK2nmfty2JieIAfxioLDKV6CFkozxgybPDEEH0fHpDoDgWFq3hW90GuBQCZcgXt_NDDx_im8RHaDbRFbxSBiHEdU_QHke9eFFNeb1HPpk-MCCvNo5BnEGVKbJUXn0FBRM/s1600/Untitled-3.jpg&quot; width=&quot;320&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;li style=&quot;text-align: justify;&quot;&gt;When finished click OK, and use the tab to fill the page. place the cursor at the position at the end of every sentence, press Tab on the keyboard and automatically point will be formed by itself, and so will type at page where the points are located.&lt;/li&gt;
&lt;/ol&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
**Good luck** &lt;/div&gt;
&lt;ol&gt;&lt;/ol&gt;
Ref : &lt;br /&gt;
&lt;a href=&quot;http://adfoc.us/364235542710&quot; title=&quot;Table of Content&quot;&gt;Wikipedia&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/4857867507087507165/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/05/create-table-of-content-using-ms-office.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/4857867507087507165'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/4857867507087507165'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/05/create-table-of-content-using-ms-office.html' title='Create Table of Content Using Ms. Office 2007'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhiSUlKf0veXuV8DClr8Hgwg9hnFWNjNCrOX4I8qydbwYGfxwwtFLTm-YboBvzO01gNgxutIJxp97a3v0OfPhg0DkgjD412GVRTtJxbxX8eE3FyH4ggSev7SYeDWyykZt0wyN6z-kmoWhg/s72-c/Untitled-1.jpg" height="72" width="72"/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-3413362660207565775</id><published>2012-05-16T07:30:00.000-07:00</published><updated>2012-05-17T06:51:34.437-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="MYSQL"/><title type='text'>DISTINCT Optimization</title><content type='html'>&lt;br /&gt;
&lt;code class=&quot;literal&quot;&gt;DISTINCT&lt;/code&gt; combined with &lt;code class=&quot;literal&quot;&gt;ORDER
          BY&lt;/code&gt; needs a temporary table in many cases.
        &lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Because &lt;code class=&quot;literal&quot;&gt;DISTINCT&lt;/code&gt; may use &lt;code class=&quot;literal&quot;&gt;GROUP
          BY&lt;/code&gt;, you should be aware of how MySQL works with
          columns in &lt;code class=&quot;literal&quot;&gt;ORDER BY&lt;/code&gt; or
          &lt;code class=&quot;literal&quot;&gt;HAVING&lt;/code&gt; clauses that are not part of the
          selected columns. See
          &lt;a href=&quot;http://adfoc.us/364235542643&quot; title=&quot;11.15.3. GROUP BY and HAVING with Hidden
        Columns&quot;&gt;Section&amp;nbsp;11.15.3, “GROUP BY and HAVING with Hidden        Columns”&lt;/a&gt;.
        &lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
In most cases, a &lt;code class=&quot;literal&quot;&gt;DISTINCT&lt;/code&gt; clause can be
          considered as a special case of &lt;code class=&quot;literal&quot;&gt;GROUP BY&lt;/code&gt;.
          For example, the following two queries are equivalent:
        &lt;/div&gt;
&lt;pre class=&quot;programlisting&quot;&gt;&amp;nbsp;&lt;/pre&gt;
&lt;pre class=&quot;programlisting&quot;&gt;SELECT DISTINCT c1, c2, c3 FROM t1
WHERE c1 &amp;gt; &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;const&lt;/code&gt;&lt;/i&gt;;

SELECT c1, c2, c3 FROM t1
WHERE c1 &amp;gt; &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;const&lt;/code&gt;&lt;/i&gt; GROUP BY c1, c2, c3;
&lt;/pre&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Due to this equivalence, the optimizations applicable to
          &lt;code class=&quot;literal&quot;&gt;GROUP BY&lt;/code&gt; queries can be also applied to
          queries with a &lt;code class=&quot;literal&quot;&gt;DISTINCT&lt;/code&gt; clause. Thus, for
          more details on the optimization possibilities for
          &lt;code class=&quot;literal&quot;&gt;DISTINCT&lt;/code&gt; queries, see
          &lt;a href=&quot;http://adfoc.us/364235542612&quot; title=&quot;7.3.1.8. GROUP BY Optimization&quot;&gt;Section&amp;nbsp;7.3.1.8, “&lt;code class=&quot;literal&quot;&gt;GROUP BY&lt;/code&gt; Optimization”&lt;/a&gt;.
        &lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
When combining &lt;code class=&quot;literal&quot;&gt;LIMIT
          &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;row_count&lt;/code&gt;&lt;/i&gt;&lt;/code&gt; with
          &lt;code class=&quot;literal&quot;&gt;DISTINCT&lt;/code&gt;, MySQL stops as soon as it finds
          &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;row_count&lt;/code&gt;&lt;/i&gt; unique rows.
        &lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
If you do not use columns from all tables named in a query,
          MySQL stops scanning any unused tables as soon as it finds the
          first match. In the following case, assuming that
          &lt;code class=&quot;literal&quot;&gt;t1&lt;/code&gt; is used before &lt;code class=&quot;literal&quot;&gt;t2&lt;/code&gt;
          (which you can check with
          &lt;a href=&quot;http://adfoc.us/364235542568&quot; title=&quot;12.7.2. EXPLAIN Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;EXPLAIN&lt;/code&gt;&lt;/a&gt;), MySQL stops reading
          from &lt;code class=&quot;literal&quot;&gt;t2&lt;/code&gt; (for any particular row in
          &lt;code class=&quot;literal&quot;&gt;t1&lt;/code&gt;) when it finds the first row in
          &lt;code class=&quot;literal&quot;&gt;t2&lt;/code&gt;:
        &lt;/div&gt;
&lt;pre class=&quot;programlisting&quot;&gt;&amp;nbsp;&lt;/pre&gt;
&lt;pre class=&quot;programlisting&quot;&gt;SELECT DISTINCT t1.a FROM t1, t2 where t1.a=t2.a;&lt;/pre&gt;
&lt;pre class=&quot;programlisting&quot;&gt;&amp;nbsp;&lt;/pre&gt;
&lt;pre class=&quot;programlisting&quot;&gt;Ref :&lt;/pre&gt;
&lt;pre class=&quot;programlisting&quot;&gt;&lt;a href=&quot;http://adfoc.us/364235533040&quot;&gt;Dev.Mysql&lt;/a&gt; &lt;/pre&gt;</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/3413362660207565775/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/05/distinct-optimization_4370.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/3413362660207565775'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/3413362660207565775'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/05/distinct-optimization_4370.html' title='DISTINCT Optimization'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-2460042075237733012</id><published>2012-05-15T21:14:00.000-07:00</published><updated>2012-05-18T07:50:19.028-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="PHP"/><title type='text'>PHP Cookies</title><content type='html'>&lt;h2&gt;
&lt;span style=&quot;font-size: small; font-weight: normal;&quot;&gt;Read the &lt;a href=&quot;http://adfoc.us/364235574927&quot; target=&quot;_blank&quot;&gt;Indonesian Version&lt;/a&gt;&lt;/span&gt; &lt;/h2&gt;
&lt;h2&gt;
&amp;nbsp;What is a Cookie? &lt;/h2&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
A cookie is often used to identify a user. A cookie is a small file that the 
server embeds on the user&#39;s computer. Each time the same computer requests a 
page with a browser, it will send the cookie too. With PHP, you can both create 
and retrieve cookie values.&lt;/div&gt;
&lt;hr /&gt;
&lt;h2&gt;


How to Create a Cookie?&lt;/h2&gt;
The setcookie() function is used to set a cookie.&lt;br /&gt;
&lt;b&gt;Note:&lt;/b&gt; The setcookie() function must appear BEFORE the &amp;lt;html&amp;gt; tag. &lt;br /&gt;
&lt;h3&gt;


Syntax&lt;/h3&gt;
&lt;div&gt;
&lt;code&gt;setcookie(name, value, expire, path, domain);&lt;/code&gt;
&lt;/div&gt;
&lt;h3&gt;


Example 1&lt;/h3&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
In the example below, we will create a cookie named &quot;user&quot; and assign the 
value &quot;Alex Porter&quot; to it. We also specify that the cookie should expire after 
one hour:&lt;/div&gt;
&lt;code&gt;
&lt;/code&gt;&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;
&lt;code&gt;&amp;lt;?php&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;setcookie(&quot;user&quot;, &quot;Alex Porter&quot;, time()+3600);&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;?&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&lt;br /&gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;lt;html&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;.....&amp;nbsp;&lt;/code&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;code&gt;
&lt;/code&gt;
&lt;b&gt;Note: &lt;/b&gt;The value of the cookie is automatically URLencoded when 
sending the cookie, and automatically decoded when received (to prevent 
URLencoding, use setrawcookie() instead).&lt;/div&gt;
&lt;h3&gt;


Example 2&lt;/h3&gt;
You can also set the expiration time of the cookie in another way. It may be 
easier than using seconds.&lt;br /&gt;
&lt;code&gt;
&lt;/code&gt;&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;
&lt;code&gt;&amp;lt;?php&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;$expire=time()+60*60*24*30;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;setcookie(&quot;user&quot;, &quot;Alex Porter&quot;, $expire);&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;?&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&lt;br /&gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;lt;html&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;.....&amp;nbsp;&lt;/code&gt;&lt;/div&gt;
&lt;code&gt;
&lt;/code&gt;
In the example above the expiration time is set to a month (&lt;i&gt;60 sec * 60 
min * 24 hours * 30 days&lt;/i&gt;).&lt;br /&gt;
&lt;hr /&gt;
&lt;h2&gt;


How to Retrieve a Cookie Value?&lt;/h2&gt;
The PHP $_COOKIE variable is used to 
retrieve a cookie value. &lt;br /&gt;
&lt;br /&gt;
In the example below, we retrieve the value of the cookie named &quot;user&quot; and 
display it on a page:&lt;br /&gt;
&lt;code&gt;
&lt;/code&gt;&lt;br /&gt;
&lt;div&gt;
&lt;code&gt;&amp;lt;?php&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;// Print a cookie&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;echo $_COOKIE[&quot;user&quot;];&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&lt;br /&gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;// A way to view all cookies&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;print_r($_COOKIE);&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;?&amp;gt;

&lt;/code&gt;&lt;/div&gt;
&lt;code&gt;
&lt;/code&gt;
In the following example we use the isset() function to find out if a cookie 
has been set:&lt;br /&gt;
&lt;code&gt;
&lt;/code&gt;&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;
&lt;code&gt;&amp;lt;html&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;lt;body&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&lt;br /&gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;lt;?php&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;if (isset($_COOKIE[&quot;user&quot;]))&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;nbsp;&amp;nbsp;echo &quot;Welcome &quot; . $_COOKIE[&quot;user&quot;] . &quot;!&amp;lt;br /&amp;gt;&quot;;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;else&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;nbsp;&amp;nbsp;echo &quot;Welcome guest!&amp;lt;br /&amp;gt;&quot;;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;?&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&lt;br /&gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;lt;/body&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;lt;/html&amp;gt;

&lt;/code&gt;&lt;/div&gt;
&lt;code&gt;
&lt;/code&gt;
&lt;br /&gt;
&lt;hr /&gt;
&lt;h2&gt;


How to Delete a Cookie?&lt;/h2&gt;
When deleting a cookie you should assure that the expiration date is in the 
past.&lt;br /&gt;
Delete example:&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;
&lt;code&gt;&amp;lt;?php
// set the expiration date to one hour ago

setcookie(&quot;user&quot;, &quot;&quot;, time()-3600);
?&amp;gt;

&lt;/code&gt;
&lt;/div&gt;
&lt;br /&gt;
&lt;hr /&gt;
&lt;h2&gt;


What if a Browser Does NOT Support Cookies?&lt;/h2&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
If your application deals with browsers that do not support cookies, you will 
have to use other methods to pass information from one page to another in your 
application. One method is to pass the data through forms (forms and user input are described 
earlier in this tutorial).&lt;/div&gt;
The form below passes the user input to &quot;welcome.php&quot; when the user clicks on 
the &quot;Submit&quot; button:&lt;br /&gt;
&lt;code&gt;
&lt;/code&gt;&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;
&lt;code&gt;&amp;lt;html&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;lt;body&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&lt;br /&gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;lt;form action=&quot;welcome.php&quot; method=&quot;post&quot;&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;Name: &amp;lt;input type=&quot;text&quot; name=&quot;name&quot; /&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;Age: &amp;lt;input type=&quot;text&quot; name=&quot;age&quot; /&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;lt;input type=&quot;submit&quot; /&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;lt;/form&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&lt;br /&gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;lt;/body&amp;gt;&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&amp;lt;/html&amp;gt;

&lt;/code&gt;&lt;/div&gt;
&lt;code&gt;
&lt;/code&gt;
&lt;code&gt;
Retrieve the values in the &quot;welcome.php&quot; file like this:


&amp;lt;html&amp;gt;&lt;br /&gt;
&amp;lt;body&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Welcome &amp;lt;?php echo $_POST[&quot;name&quot;]; ?&amp;gt;.&amp;lt;br /&amp;gt;&lt;br /&gt;
You are &amp;lt;?php echo $_POST[&quot;age&quot;]; ?&amp;gt; years old.&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/body&amp;gt;&lt;br /&gt;
&amp;lt;/html&amp;gt;&lt;br /&gt;
&lt;br /&gt;
Ref :&lt;/code&gt;&lt;br /&gt;
&lt;code&gt;&lt;a href=&quot;http://adfoc.us/364235532880&quot;&gt;W3school&lt;/a&gt;&amp;nbsp;&lt;/code&gt;</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/2460042075237733012/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/05/php-cookies_15.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/2460042075237733012'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/2460042075237733012'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/05/php-cookies_15.html' title='PHP Cookies'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-8718222376188079012</id><published>2012-05-14T21:16:00.000-07:00</published><updated>2012-05-18T06:58:26.391-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="MYSQL"/><title type='text'>Create Trigger Syntax</title><content type='html'>&lt;div class=&quot;section&quot; lang=&quot;en&quot; style=&quot;text-align: justify;&quot;&gt;
&lt;h3 class=&quot;title&quot;&gt;
&lt;span style=&quot;font-size: small; font-weight: normal;&quot;&gt;Read the &lt;a href=&quot;http://adfoc.us/364235574265&quot; target=&quot;_blank&quot;&gt;Indonesian Version&lt;/a&gt; &lt;/span&gt;&lt;/h3&gt;
&lt;h3 class=&quot;title&quot;&gt;
&amp;nbsp;Syntax&lt;/h3&gt;
&lt;a class=&quot;indexterm&quot; href=&quot;http://www.blogger.com/blogger.g?blogID=2718725303768725971&quot; name=&quot;id738528&quot;&gt;&lt;/a&gt;&lt;a class=&quot;indexterm&quot; href=&quot;http://www.blogger.com/blogger.g?blogID=2718725303768725971&quot; name=&quot;id738537&quot;&gt;&lt;/a&gt;&lt;br /&gt;
&lt;pre class=&quot;programlisting&quot;&gt;CREATE
    [DEFINER = { &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;user&lt;/code&gt;&lt;/i&gt; | CURRENT_USER }]
    TRIGGER &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;trigger_name&lt;/code&gt;&lt;/i&gt; &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;trigger_time&lt;/code&gt;&lt;/i&gt; &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;trigger_event&lt;/code&gt;&lt;/i&gt;
    ON &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;tbl_name&lt;/code&gt;&lt;/i&gt; FOR EACH ROW &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;trigger_body&lt;/code&gt;&lt;/i&gt;
&lt;/pre&gt;
This statement creates a new trigger. A trigger is a named
      database object that is associated with a table, and that
      activates when a particular event occurs for the table. The
      trigger becomes associated with the table named
      &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;tbl_name&lt;/code&gt;&lt;/i&gt;, which must refer to a
      permanent table. You cannot associate a trigger with a
      &lt;code&gt;TEMPORARY&lt;/code&gt; table or a view.
      &lt;code class=&quot;literal&quot;&gt;CREATE TRIGGER&lt;/code&gt; was added in MySQL
      5.0.2.
    &lt;br /&gt;
In MySQL 5.0 &lt;code class=&quot;literal&quot;&gt;CREATE
      TRIGGER&lt;/code&gt;requires the
      &lt;a href=&quot;http://adfoc.us/364235406359&quot; title=&quot;Super Privilege&quot;&gt;&lt;code class=&quot;literal&quot;&gt;SUPER&lt;/code&gt;&lt;/a&gt; privilege.
    &lt;br /&gt;
The &lt;code class=&quot;literal&quot;&gt;DEFINER&lt;/code&gt; clause determines the security
      context to be used when checking access privileges at trigger
      activation time. It was added in MySQL 5.0.17. See later in this
      section for more information.
    &lt;br /&gt;
&lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;trigger_time&lt;/code&gt;&lt;/i&gt; is the trigger action
      time. It can be &lt;code class=&quot;literal&quot;&gt;BEFORE&lt;/code&gt; or
      &lt;code class=&quot;literal&quot;&gt;AFTER&lt;/code&gt; to indicate that the trigger activates
      before or after each row to be modified.
    &lt;br /&gt;
&lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;trigger_event&lt;/code&gt;&lt;/i&gt; indicates the kind of
      statement that activates the trigger. The
      &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;trigger_event&lt;/code&gt;&lt;/i&gt; can be one of the
      following:
    &lt;br /&gt;
&lt;div class=&quot;itemizedlist&quot;&gt;
&lt;ul&gt;
&lt;li&gt;&lt;a href=&quot;http://adfoc.us/364235420313&quot; title=&quot;INSERT Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;INSERT&lt;/code&gt;&lt;/a&gt;: The trigger is
          activated whenever a new row is inserted into the table; for
          example, through &lt;a href=&quot;http://adfoc.us/364235420313&quot; title=&quot;INSERT Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;INSERT&lt;/code&gt;&lt;/a&gt;,
          &lt;a href=&quot;http://adfoc.us/364235420343&quot; title=&quot;Load Data&quot;&gt;&lt;code class=&quot;literal&quot;&gt;LOAD DATA&lt;/code&gt;&lt;/a&gt;, and
          &lt;a href=&quot;http://adfoc.us/364235420445&quot; title=&quot;REPLACE Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;REPLACE&lt;/code&gt;&lt;/a&gt; statements.
        &lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://adfoc.us/364235420497&quot; title=&quot;UPDATE Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;UPDATE&lt;/code&gt;&lt;/a&gt;: The trigger is
          activated whenever a row is modified; for example, through
          &lt;a href=&quot;http://adfoc.us/364235420497&quot; title=&quot;UPDATE Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;UPDATE&lt;/code&gt;&lt;/a&gt; statements.
        &lt;/li&gt;
&lt;li&gt;&lt;a href=&quot;http://adfoc.us/364235420534&quot; title=&quot;DELETE Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;DELETE&lt;/code&gt;&lt;/a&gt;: The trigger is
          activated whenever a row is deleted from the table; for
          example, through &lt;a href=&quot;http://adfoc.us/364235420534&quot; title=&quot;DELETE Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;DELETE&lt;/code&gt;&lt;/a&gt; and
          &lt;a href=&quot;http://adfoc.us/364235420445&quot; title=&quot;REPLACE Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;REPLACE&lt;/code&gt;&lt;/a&gt; statements. However,
          &lt;a href=&quot;http://adfoc.us/364235420581&quot; title=&quot;DROP TABLE Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;DROP TABLE&lt;/code&gt;&lt;/a&gt; and
          &lt;a href=&quot;http://adfoc.us/364235420616&quot; title=&quot;TRUNCATE TABLE Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;TRUNCATE TABLE&lt;/code&gt;&lt;/a&gt; statements on
          the table do &lt;span class=&quot;emphasis&quot;&gt;&lt;i&gt;not&lt;/i&gt;&lt;/span&gt; activate this trigger,
          because they do not use &lt;a href=&quot;http://adfoc.us/364235420534&quot; title=&quot;DELETE Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;DELETE&lt;/code&gt;&lt;/a&gt;.
          See &lt;a href=&quot;http://adfoc.us/364235420616&quot; title=&quot;TRUNCATE TABLE Syntax&quot;&gt;Section 13.1.21, “&lt;code class=&quot;literal&quot;&gt;TRUNCATE TABLE&lt;/code&gt; Syntax”&lt;/a&gt;.
        &lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
It is important to understand that the
      &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;trigger_event&lt;/code&gt;&lt;/i&gt; does not represent a
      literal type of SQL statement that activates the trigger so much
      as it represents a type of table operation. For example, an
      &lt;a href=&quot;http://adfoc.us/364235420313&quot; title=&quot;INSERT Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;INSERT&lt;/code&gt;&lt;/a&gt; trigger is activated by not
      only &lt;a href=&quot;http://adfoc.us/364235420313&quot; title=&quot;INSERT Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;INSERT&lt;/code&gt;&lt;/a&gt; statements but also
      &lt;a href=&quot;http://adfoc.us/364235420343&quot; title=&quot;Load Data&quot;&gt;&lt;code class=&quot;literal&quot;&gt;LOAD DATA&lt;/code&gt;&lt;/a&gt; statements because both
      statements insert rows into a table.
    &lt;br /&gt;
A potentially confusing example of this is the &lt;code class=&quot;literal&quot;&gt;INSERT
      INTO ... ON DUPLICATE KEY UPDATE ...&lt;/code&gt; syntax: a
      &lt;code class=&quot;literal&quot;&gt;BEFORE INSERT&lt;/code&gt; trigger will activate for every
      row, followed by either an &lt;code class=&quot;literal&quot;&gt;AFTER INSERT&lt;/code&gt; trigger
      or both the &lt;code class=&quot;literal&quot;&gt;BEFORE UPDATE&lt;/code&gt; and &lt;code class=&quot;literal&quot;&gt;AFTER
      UPDATE&lt;/code&gt; triggers, depending on whether there was a
      duplicate key for the row.
    &lt;br /&gt;
There cannot be two triggers for a given table that have the same
      trigger action time and event. For example, you cannot have two
      &lt;code class=&quot;literal&quot;&gt;BEFORE UPDATE&lt;/code&gt; triggers for a table. But you can
      have a &lt;code class=&quot;literal&quot;&gt;BEFORE UPDATE&lt;/code&gt; and a &lt;code class=&quot;literal&quot;&gt;BEFORE
      INSERT&lt;/code&gt; trigger, or a &lt;code class=&quot;literal&quot;&gt;BEFORE UPDATE&lt;/code&gt;
      and an &lt;code class=&quot;literal&quot;&gt;AFTER UPDATE&lt;/code&gt; trigger.
    &lt;br /&gt;
&lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;trigger_body&lt;/code&gt;&lt;/i&gt; is the statement to
      execute when the trigger activates. If you want to execute
      multiple statements, use the
      &lt;a href=&quot;http://adfoc.us/364235420642&quot; title=&quot;BEGIN ... END
      Compound-Statement Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;BEGIN ... END&lt;/code&gt;&lt;/a&gt;
      compound statement construct. This also enables you to use the
      same statements that are permissible within stored routines. See
      &lt;a href=&quot;http://adfoc.us/364235420642&quot; title=&quot;BEGIN ... END
      Compound-Statement Syntax&quot;&gt;Section 13.6.1, “&lt;code class=&quot;literal&quot;&gt;BEGIN ... END&lt;/code&gt;
      Compound-Statement Syntax”&lt;/a&gt;. Some statements are not permitted in
      triggers; see &lt;a href=&quot;http://adfoc.us/364235420689&quot; title=&quot;Restrictions on Stored Programs&quot;&gt;Section E.1, “Restrictions on Stored Programs”&lt;/a&gt;.
    &lt;br /&gt;
You can refer to columns in the subject table (the table
      associated with the trigger) by using the aliases
      &lt;code class=&quot;literal&quot;&gt;OLD&lt;/code&gt; and &lt;code class=&quot;literal&quot;&gt;NEW&lt;/code&gt;.
      &lt;code class=&quot;literal&quot;&gt;OLD.&lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;col_name&lt;/code&gt;&lt;/i&gt;&lt;/code&gt; refers
      to a column of an existing row before it is updated or deleted.
      &lt;code class=&quot;literal&quot;&gt;NEW.&lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;col_name&lt;/code&gt;&lt;/i&gt;&lt;/code&gt; refers
      to the column of a new row to be inserted or an existing row after
      it is updated.
    &lt;br /&gt;
MySQL stores the &lt;a href=&quot;http://adfoc.us/364235420747&quot;&gt;&lt;code class=&quot;literal&quot;&gt;sql_mode&lt;/code&gt;&lt;/a&gt; system
      variable setting that is in effect at the time a trigger is
      created, and always executes the trigger with this setting in
      force, &lt;span class=&quot;emphasis&quot;&gt;&lt;i&gt;regardless of the current server SQL
      mode&lt;/i&gt;&lt;/span&gt;.
    &lt;br /&gt;
&lt;div class=&quot;note&quot; style=&quot;margin-left: 0.5in; margin-right: 0.5in;&quot; xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;
&lt;div class=&quot;admon-title&quot;&gt;
Note&lt;/div&gt;
&lt;div xmlns=&quot;&quot;&gt;
Currently, cascaded foreign key actions do not activate
        triggers.
      &lt;/div&gt;
&lt;/div&gt;
The &lt;code class=&quot;literal&quot;&gt;DEFINER&lt;/code&gt; clause specifies the MySQL account
      to be used when checking access privileges at trigger activation
      time. If a &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;user&lt;/code&gt;&lt;/i&gt; value is given, it
      should be a MySQL account specified as
      &lt;code class=&quot;literal&quot;&gt;&#39;&lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;user_name&lt;/code&gt;&lt;/i&gt;&#39;@&#39;&lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;host_name&lt;/code&gt;&lt;/i&gt;&#39;&lt;/code&gt;
      (the same format used in the &lt;a href=&quot;http://adfoc.us/364235420964&quot; title=&quot;GRANT Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;GRANT&lt;/code&gt;&lt;/a&gt;
      statement), &lt;a href=&quot;http://adfoc.us/364235420781&quot;&gt;&lt;code class=&quot;literal&quot;&gt;CURRENT_USER&lt;/code&gt;&lt;/a&gt;, or
      &lt;a href=&quot;http://adfoc.us/364235420781&quot;&gt;&lt;code class=&quot;literal&quot;&gt;CURRENT_USER()&lt;/code&gt;&lt;/a&gt;. The default
      &lt;code class=&quot;literal&quot;&gt;DEFINER&lt;/code&gt; value is the user who executes the
      &lt;code class=&quot;literal&quot;&gt;CREATE TRIGGER&lt;/code&gt; statement. This is
      the same as specifying &lt;code class=&quot;literal&quot;&gt;DEFINER = CURRENT_USER&lt;/code&gt;
      explicitly.
    &lt;br /&gt;
If you specify the &lt;code class=&quot;literal&quot;&gt;DEFINER&lt;/code&gt; clause, these rules
      determine the legal &lt;code class=&quot;literal&quot;&gt;DEFINER&lt;/code&gt; user values:
    &lt;br /&gt;
&lt;div class=&quot;itemizedlist&quot;&gt;
&lt;ul&gt;
&lt;li&gt;If you do not have the &lt;a &quot;=&quot;&quot; href=&quot;http://adfoc.us/364235406359&quot; title=&quot;Super Privilege&quot;&gt;&lt;code class=&quot;literal&quot;&gt;SUPER&lt;/code&gt;&lt;/a&gt;
          privilege, the only legal &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;user&lt;/code&gt;&lt;/i&gt;
          value is your own account, either specified literally or by
          using &lt;a href=&quot;http://adfoc.us/364235420781&quot;&gt;&lt;code class=&quot;literal&quot;&gt;CURRENT_USER&lt;/code&gt;&lt;/a&gt;. You cannot
          set the definer to some other account.
        &lt;/li&gt;
&lt;li&gt;If you have the &lt;a &quot;=&quot;&quot; href=&quot;http://adfoc.us/364235406359&quot; title=&quot;Super Privilege&quot;&gt;&lt;code class=&quot;literal&quot;&gt;SUPER&lt;/code&gt;&lt;/a&gt;
          privilege, you can specify any syntactically legal account
          name. If the account does not actually exist, a warning is
          generated.
        &lt;/li&gt;
&lt;li&gt;Although it is possible to create a trigger with a nonexistent
          &lt;code class=&quot;literal&quot;&gt;DEFINER&lt;/code&gt; account, it is not a good idea for
          such triggers to be activated until the account actually does
          exist. Otherwise, the behavior with respect to privilege
          checking is undefined.
        &lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
Note: Because MySQL currently requires the
      &lt;a &quot;=&quot;&quot; href=&quot;http://adfoc.us/364235406359&quot; title=&quot;Super Privilege&quot;&gt;&lt;code class=&quot;literal&quot;&gt;SUPER&lt;/code&gt;&lt;/a&gt; privilege for the use of
      &lt;code class=&quot;literal&quot;&gt;CREATE TRIGGER&lt;/code&gt;, only the second of
      the preceding rules applies. (MySQL 5.1.6 implements the
      &lt;a href=&quot;http://adfoc.us/364235420832&quot; target=&quot;_top&quot;&gt;&lt;code class=&quot;literal&quot;&gt;TRIGGER&lt;/code&gt;&lt;/a&gt; privilege and requires that
      privilege for trigger creation, so at that point both rules come
      into play and &lt;a &quot;=&quot;&quot; href=&quot;http://adfoc.us/364235406359&quot; title=&quot;Super Privilege&quot;&gt;&lt;code class=&quot;literal&quot;&gt;SUPER&lt;/code&gt;&lt;/a&gt; is required
      only for specifying a &lt;code class=&quot;literal&quot;&gt;DEFINER&lt;/code&gt; value other than
      your own account.)
    &lt;br /&gt;
From MySQL 5.0.17 on, MySQL takes the &lt;code class=&quot;literal&quot;&gt;DEFINER&lt;/code&gt;
      user into account when checking trigger privileges as follows:
    &lt;br /&gt;
&lt;div class=&quot;itemizedlist&quot;&gt;
&lt;ul&gt;
&lt;li&gt;At &lt;code class=&quot;literal&quot;&gt;CREATE TRIGGER&lt;/code&gt; time, the
          user who issues the statement must have the
          &lt;a &quot;=&quot;&quot; href=&quot;http://adfoc.us/364235406359&quot; title=&quot;Super Privilege&quot;&gt;&lt;code class=&quot;literal&quot;&gt;SUPER&lt;/code&gt;&lt;/a&gt; privilege.
        &lt;/li&gt;
&lt;li&gt;
At trigger activation time, privileges are checked against the
          &lt;code class=&quot;literal&quot;&gt;DEFINER&lt;/code&gt; user. This user must have these
          privileges:
        &lt;br /&gt;

&lt;div class=&quot;itemizedlist&quot;&gt;
&lt;ul&gt;
&lt;li&gt;The &lt;a &quot;=&quot;&quot; href=&quot;http://adfoc.us/364235406359&quot; title=&quot;Super Privilege&quot;&gt;&lt;code class=&quot;literal&quot;&gt;SUPER&lt;/code&gt;&lt;/a&gt; privilege.
            &lt;/li&gt;
&lt;li&gt;The &lt;a href=&quot;http://adfoc.us/364235420903&quot;&gt;&lt;code class=&quot;literal&quot;&gt;SELECT&lt;/code&gt;&lt;/a&gt; privilege for
              the subject table if references to table columns occur
              using
              &lt;code class=&quot;literal&quot;&gt;OLD.&lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;col_name&lt;/code&gt;&lt;/i&gt;&lt;/code&gt;
              or
              &lt;code class=&quot;literal&quot;&gt;NEW.&lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;col_name&lt;/code&gt;&lt;/i&gt;&lt;/code&gt;
              in the trigger definition.
            &lt;/li&gt;
&lt;li&gt;The &lt;a href=&quot;http://adfoc.us/364235420903&quot;&gt;&lt;code class=&quot;literal&quot;&gt;UPDATE&lt;/code&gt;&lt;/a&gt; privilege for
              the subject table if table columns are targets of
              &lt;code class=&quot;literal&quot;&gt;SET NEW.&lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;col_name&lt;/code&gt;&lt;/i&gt; =
              &lt;i class=&quot;replaceable&quot;&gt;&lt;code&gt;value&lt;/code&gt;&lt;/i&gt;&lt;/code&gt; assignments in
              the trigger definition.
            &lt;/li&gt;
&lt;li&gt;Whatever other privileges normally are required for the
              statements executed by the trigger.
            &lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
&lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
Before MySQL 5.0.17, &lt;code class=&quot;literal&quot;&gt;DEFINER&lt;/code&gt; is not available
      and MySQL checks trigger privileges like this:
    &lt;br /&gt;
&lt;div class=&quot;itemizedlist&quot;&gt;
&lt;ul&gt;
&lt;li&gt;At &lt;code class=&quot;literal&quot;&gt;CREATE TRIGGER&lt;/code&gt; time, the
          user who issues the statement must have the
          &lt;a &quot;=&quot;&quot; href=&quot;http://adfoc.us/364235406359&quot; title=&quot;Super Privilege&quot;&gt;&lt;code class=&quot;literal&quot;&gt;SUPER&lt;/code&gt;&lt;/a&gt; privilege.
        &lt;/li&gt;
&lt;li&gt;At trigger activation time, privileges are checked against the
          user whose actions cause the trigger to be activated. This
          user must have whatever privileges normally are required for
          the statements executed by the trigger.
        &lt;/li&gt;
&lt;/ul&gt;
&lt;/div&gt;
For more information about trigger security, see
      &lt;a href=&quot;http://adfoc.us/364235420930&quot; title=&quot;Access Control for Stored Programs and Views&quot;&gt;Section 18.5, “Access Control for Stored Programs and Views”&lt;/a&gt;.
    &lt;br /&gt;
Within a trigger, the
      &lt;a href=&quot;http://adfoc.us/364235420781&quot;&gt;&lt;code class=&quot;literal&quot;&gt;CURRENT_USER()&lt;/code&gt;&lt;/a&gt; function returns the
      account used to check privileges at trigger activation time.
      Consistent with the privilege-checking rules just given,
      &lt;a href=&quot;http://adfoc.us/364235420781&quot;&gt;&lt;code class=&quot;literal&quot;&gt;CURRENT_USER()&lt;/code&gt;&lt;/a&gt; returns the
      &lt;code class=&quot;literal&quot;&gt;DEFINER&lt;/code&gt; user from MySQL 5.0.17 on. Before
      5.0.17, &lt;a href=&quot;http://adfoc.us/364235420781&quot;&gt;&lt;code class=&quot;literal&quot;&gt;CURRENT_USER()&lt;/code&gt;&lt;/a&gt; returns the
      user whose actions caused the trigger to be activated. For
      information about user auditing within triggers, see
      &lt;a href=&quot;http://adfoc.us/364235421051&quot; title=&quot;Auditing MySQL Account Activity&quot;&gt;Section 6.3.8, “Auditing MySQL Account Activity”&lt;/a&gt;.
    &lt;br /&gt;
If you use &lt;a href=&quot;http://adfoc.us/364235421104&quot; title=&quot;LOCK TABLES and
      UNLOCK
      TABLES Syntax&quot;&gt;&lt;code class=&quot;literal&quot;&gt;LOCK TABLES&lt;/code&gt;&lt;/a&gt; to lock a
      table that has triggers, the tables used within the trigger are
      also locked, as described in
      &lt;a href=&quot;http://adfoc.us/364235421181&quot; title=&quot;LOCK TABLES and Triggers&quot;&gt;Section 13.3.5.2, “&lt;code class=&quot;literal&quot;&gt;LOCK TABLES&lt;/code&gt; and Triggers”&lt;/a&gt;.
    &lt;br /&gt;
&lt;div class=&quot;note&quot; style=&quot;margin-left: 0.5in; margin-right: 0.5in;&quot; xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&gt;
&lt;div class=&quot;admon-title&quot;&gt;
Note&lt;/div&gt;
&lt;div xmlns=&quot;&quot;&gt;
Before MySQL 5.0.10, triggers cannot contain direct references
        to tables by name. Beginning with MySQL 5.0.10, you can write
        triggers such as the one named &lt;code class=&quot;literal&quot;&gt;testref&lt;/code&gt; shown
        in this example:
      &lt;/div&gt;
&lt;/div&gt;
&lt;pre class=&quot;programlisting&quot;&gt;CREATE TABLE test1(a1 INT);
CREATE TABLE test2(a2 INT);
CREATE TABLE test3(a3 INT NOT NULL AUTO_INCREMENT PRIMARY KEY);
CREATE TABLE test4(
  a4 INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  b4 INT DEFAULT 0
);

delimiter |

CREATE TRIGGER testref BEFORE INSERT ON test1
  FOR EACH ROW BEGIN
    INSERT INTO test2 SET a2 = NEW.a1;
    DELETE FROM test3 WHERE a3 = NEW.a1;
    UPDATE test4 SET b4 = b4 + 1 WHERE a4 = NEW.a1;
  END;
|

delimiter ;

INSERT INTO test3 (a3) VALUES
  (NULL), (NULL), (NULL), (NULL), (NULL),
  (NULL), (NULL), (NULL), (NULL), (NULL);

INSERT INTO test4 (a4) VALUES
  (0), (0), (0), (0), (0), (0), (0), (0), (0), (0);&lt;/pre&gt;
Suppose that you insert the following values into table
      &lt;code class=&quot;literal&quot;&gt;test1&lt;/code&gt; as shown here:
    &lt;br /&gt;
&lt;pre class=&quot;programlisting&quot;&gt;mysql&amp;gt; &lt;b class=&quot;userinput&quot;&gt;&lt;code&gt;INSERT INTO test1 VALUES &lt;/code&gt;&lt;/b&gt;
    -&amp;gt; &lt;b class=&quot;userinput&quot;&gt;&lt;code&gt;(1), (3), (1), (7), (1), (8), (4), (4);&lt;/code&gt;&lt;/b&gt;
Query OK, 8 rows affected (0.01 sec)
Records: 8  Duplicates: 0  Warnings: 0
&lt;/pre&gt;
As a result, the data in the four tables will be as follows:
    &lt;br /&gt;
&lt;pre class=&quot;programlisting&quot;&gt;mysql&amp;gt; &lt;b class=&quot;userinput&quot;&gt;&lt;code&gt;SELECT * FROM test1;&lt;/code&gt;&lt;/b&gt;
+------+
| a1   |
+------+
|    1 |
|    3 |
|    1 |
|    7 |
|    1 |
|    8 |
|    4 |
|    4 |
+------+
8 rows in set (0.00 sec)

mysql&amp;gt; &lt;b class=&quot;userinput&quot;&gt;&lt;code&gt;SELECT * FROM test2;&lt;/code&gt;&lt;/b&gt;
+------+
| a2   |
+------+
|    1 |
|    3 |
|    1 |
|    7 |
|    1 |
|    8 |
|    4 |
|    4 |
+------+
8 rows in set (0.00 sec)

mysql&amp;gt; &lt;b class=&quot;userinput&quot;&gt;&lt;code&gt;SELECT * FROM test3;&lt;/code&gt;&lt;/b&gt;
+----+
| a3 |
+----+
|  2 |
|  5 |
|  6 |
|  9 |
| 10 |
+----+
5 rows in set (0.00 sec)

mysql&amp;gt; &lt;b class=&quot;userinput&quot;&gt;&lt;code&gt;SELECT * FROM test4;&lt;/code&gt;&lt;/b&gt;
+----+------+
| a4 | b4   |
+----+------+
|  1 |    3 |
|  2 |    0 |
|  3 |    1 |
|  4 |    2 |
|  5 |    0 |
|  6 |    0 |
|  7 |    1 |
|  8 |    1 |
|  9 |    0 |
| 10 |    0 |
+----+------+
10 rows in set (0.00 sec)&lt;/pre&gt;
&lt;pre class=&quot;programlisting&quot;&gt;&amp;nbsp;&lt;/pre&gt;
&lt;pre class=&quot;programlisting&quot;&gt;Ref :&lt;/pre&gt;
&lt;pre class=&quot;programlisting&quot;&gt;&lt;a href=&quot;http://adfoc.us/364235421214&quot;&gt;Dev MYSQL&lt;/a&gt; &lt;/pre&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/8718222376188079012/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/05/create-trigger-syntax_14.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/8718222376188079012'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/8718222376188079012'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/05/create-trigger-syntax_14.html' title='Create Trigger Syntax'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-5800756523805366473</id><published>2012-05-13T21:18:00.000-07:00</published><updated>2012-07-29T08:11:29.453-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="Linux"/><category scheme="http://www.blogger.com/atom/ns#" term="MYSQL"/><category scheme="http://www.blogger.com/atom/ns#" term="tips and tricks"/><title type='text'>Install MySQL Workbench on Ubuntu 12.04</title><content type='html'>Read the &lt;a href=&quot;http://adfoc.us/364235562464&quot; target=&quot;_blank&quot;&gt;Inodesian Version&lt;/a&gt; &lt;br /&gt;
&lt;div class=&quot;post-body entry-content&quot; id=&quot;post-body-1933401118128524978&quot;&gt;
&lt;div dir=&quot;ltr&quot; style=&quot;text-align: left;&quot; trbidi=&quot;on&quot;&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;
Currently there is no pre-built .deb&amp;nbsp;file&amp;nbsp;or repo available to install MySQL Workbench on Ubuntu 12.04. &amp;nbsp;One will probably appear soon after official release of 12.04 but at the moment it is still in beta so there are a few extra steps to get it working.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
NOTE: Once Ubuntu 12.04 moves out of beta there will probably be a better way of doing this so please check the official MySQL Workbench download page and the official 12.04 repos before attempting this.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
First of all you will need to download the latest MySQL Workbench from &lt;a href=&quot;http://adfoc.us/364235434870&quot; target=&quot;_blank&quot;&gt;here&lt;/a&gt;.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Next you must download a .deb file for libzip1 as it is not available in the 12.04 repos.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
32 bit version -&amp;nbsp;&lt;a href=&quot;https://launchpad.net/ubuntu/+archive/primary/+files/libzip1_0.9.3-1_i386.deb&quot;&gt;https://launchpad.net/ubuntu/+archive/primary/+files/libzip1_0.9.3-1_i386.deb&lt;/a&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
64 bit version -&amp;nbsp;&lt;a href=&quot;https://launchpad.net/ubuntu/+source/libzip/0.9.3-1/+build/1728114/+files/libzip1_0.9.3-1_amd64.deb&quot;&gt;https://launchpad.net/ubuntu/+source/libzip/0.9.3-1/+build/1728114/+files/libzip1_0.9.3-1_amd64.deb&lt;/a&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
for other architectures go &lt;a href=&quot;http://adfoc.us/364235532860&quot; target=&quot;_blank&quot;&gt;here&lt;/a&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
After downloading just open them with the software&amp;nbsp;centre&amp;nbsp;and click install.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
*NEW: The libmysqlclient16 package was removed from the 12.04 repos so you will need to download the old deb files for it:&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
32 bit version -&amp;nbsp;&lt;a href=&quot;http://launchpadlibrarian.net/94563300/libmysqlclient16_5.1.58-1ubuntu5_i386.deb&quot;&gt;http://launchpadlibrarian.net/94563300/libmysqlclient16_5.1.58-1ubuntu5_i386.deb&lt;/a&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
64 bit version -&amp;nbsp;&lt;a href=&quot;http://launchpadlibrarian.net/94808408/libmysqlclient16_5.1.58-1ubuntu5_amd64.deb&quot;&gt;http://launchpadlibrarian.net/94808408/libmysqlclient16_5.1.58-1ubuntu5_amd64.deb&lt;/a&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&amp;nbsp;Next open a terminal and install the following packages:&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: left;&quot;&gt;
&lt;code&gt;sudo apt-get install libzip1 python-paramiko python-pysqlite2&amp;nbsp;libctemplate0&amp;nbsp;libgtkmm-2.4-1c2a&amp;nbsp;libmysqlclient16&lt;/code&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Then cd to the directory where you downloaded the deb file and run:&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;code&gt;sudo dpkg -i mysql-workbench-gpl-5.2.38-1ubu1104-i386.deb&lt;/code&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;br /&gt;&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
And that should be it, enjoy!&lt;/div&gt;
&lt;br /&gt;
Ref :&lt;br /&gt;
&lt;a href=&quot;http://adfoc.us/364235532876&quot;&gt;setupguides &lt;/a&gt;&lt;/div&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/5800756523805366473/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/05/install-mysql-workbench-on-ubuntu-1204_13.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/5800756523805366473'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/5800756523805366473'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/05/install-mysql-workbench-on-ubuntu-1204_13.html' title='Install MySQL Workbench on Ubuntu 12.04'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-5182213630455614536</id><published>2012-05-12T21:21:00.000-07:00</published><updated>2012-05-18T07:29:49.940-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="PHP"/><title type='text'>PHP Sessions</title><content type='html'>&lt;div&gt;
&lt;h1&gt;
&lt;span style=&quot;font-size: small; font-weight: normal;&quot;&gt;Read the &lt;a href=&quot;http://www.blogger.com/goog_514292798&quot;&gt;Indonesian Version&lt;/a&gt;&lt;/span&gt;&lt;/h1&gt;
&lt;h1&gt;
&amp;nbsp;PHP &lt;span class=&quot;color_h1&quot;&gt;Sessions&lt;/span&gt;&lt;/h1&gt;
&lt;hr /&gt;
&lt;div class=&quot;intro&quot; style=&quot;text-align: justify;&quot;&gt;
A PHP session variable is used to store information about, or 
change settings for a user session. Session variables hold information about one 
single user, and are available to all pages in one application.&lt;/div&gt;
&lt;hr /&gt;
&lt;h2&gt;




PHP Session Variables&lt;/h2&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
When you are working with an application, you open it, do some changes and 
then you close it. This is much like a Session. The computer knows who you are. 
It knows when you start the application and when you end. But on the internet 
there is one problem: the web server does not know who you are and what you do 
because the HTTP address doesn&#39;t maintain state.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
A PHP session solves this problem by allowing you to store user information 
on the server for later use (i.e. username, shopping items, etc). However, session information is temporary and 
will be deleted after 
the user has left the website. If you need a permanent storage you may want to store the data in a database.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Sessions work by creating a unique id (UID) for each 
visitor and store variables based on this UID. The UID is either stored in a 
cookie or is propagated in the URL.&lt;/div&gt;
&lt;hr /&gt;
&lt;h2&gt;




Starting a PHP Session&lt;/h2&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
Before you can store user information in your PHP session, you must 
first start up the session.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;b&gt;Note:&lt;/b&gt; The session_start() function must appear BEFORE the &amp;lt;html&amp;gt; tag:&lt;/div&gt;
&lt;pre&gt;&lt;code&gt;

&amp;lt;?php session_start(); ?&amp;gt;&lt;/code&gt;
&lt;code&gt;&lt;/code&gt;&lt;code&gt;&amp;lt;html&amp;gt;
&amp;lt;body&amp;gt;


&amp;lt;/body&amp;gt;
&amp;lt;/html&amp;gt;

&lt;/code&gt;&lt;/pre&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
The code above will register the user&#39;s session with the server, allow you to 
start saving user information, and assign a UID 
for that user&#39;s session.&lt;/div&gt;
&lt;hr /&gt;
&lt;h2&gt;




Storing a Session Variable&lt;/h2&gt;
The correct way to store and retrieve session variables is to use the 
PHP $_SESSION variable:&lt;br /&gt;
&lt;pre&gt;&lt;code&gt;

&amp;lt;?php
session_start();
// store session data
$_SESSION[&#39;views&#39;]=1;
?&amp;gt;&lt;/code&gt;&lt;/pre&gt;
&lt;pre&gt;&lt;code&gt;&amp;nbsp;&lt;/code&gt;&lt;/pre&gt;
&lt;pre&gt;&lt;code&gt;&amp;lt;html&amp;gt;
&amp;lt;body&amp;gt;&lt;/code&gt;&lt;/pre&gt;
&lt;pre&gt;&lt;code&gt;&amp;nbsp;&lt;/code&gt;&lt;/pre&gt;
&lt;pre&gt;&lt;code&gt;&amp;lt;?php
//retrieve session data
echo &quot;Pageviews=&quot;. $_SESSION[&#39;views&#39;];
?&amp;gt;

&amp;lt;/body&amp;gt;
&amp;lt;/html&amp;gt;

&lt;/code&gt;&lt;/pre&gt;
Output:&lt;br /&gt;
&lt;code&gt;&lt;/code&gt;&lt;br /&gt;
&lt;div&gt;
&lt;br /&gt;
&lt;code&gt;Pageviews=1&lt;/code&gt;&lt;/div&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
In the example below, we create a simple page-views counter. The isset() 
function checks if the &quot;views&quot; variable has already been set. If &quot;views&quot; has 
been set, we can increment our counter. If &quot;views&quot; doesn&#39;t exist, we create a &quot;views&quot; 
variable, and set it to 1:&lt;/div&gt;
&lt;pre&gt;&lt;code&gt;

&amp;lt;?php
session_start();&lt;/code&gt;&lt;/pre&gt;
&lt;pre&gt;&lt;code&gt;&amp;nbsp;&lt;/code&gt;&lt;/pre&gt;
&lt;pre&gt;&lt;code&gt;if(isset($_SESSION[&#39;views&#39;]))
   $_SESSION[&#39;views&#39;]=$_SESSION[&#39;views&#39;]+1;
else
   $_SESSION[&#39;views&#39;]=1;
echo &quot;Views=&quot;. $_SESSION[&#39;views&#39;];
?&amp;gt;
&lt;/code&gt;&lt;/pre&gt;
&lt;br /&gt;
&lt;hr /&gt;
&lt;h2&gt;




Destroying a Session&lt;/h2&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
If you wish to delete some session data, you can use the unset() or the 
session_destroy() function. The unset() function is used to free the specified session variable:&lt;/div&gt;
&lt;pre&gt;&lt;code&gt;

&amp;lt;?php
unset($_SESSION[&#39;views&#39;]);
?&amp;gt;

&lt;/code&gt;&lt;/pre&gt;
You can also completely destroy the session by calling the session_destroy() function:&lt;br /&gt;
&lt;pre&gt;&lt;code&gt;

&amp;lt;?php
session_destroy();
?&amp;gt;

&lt;/code&gt;&lt;/pre&gt;
&lt;b&gt;Note:&lt;/b&gt; session_destroy() will reset your session and you will lose all 
your stored session data.&lt;br /&gt;
&lt;br /&gt;
Ref :&lt;br /&gt;
&lt;a href=&quot;http://adfoc.us/364235434566&quot; title=&quot;PHP SESSION&quot;&gt;W3school&lt;/a&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/5182213630455614536/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/05/php-sessions.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/5182213630455614536'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/5182213630455614536'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/05/php-sessions.html' title='PHP Sessions'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-8482052995387392468</id><published>2012-05-11T21:22:00.000-07:00</published><updated>2012-05-16T21:23:12.472-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips and tricks"/><title type='text'>Login two user account using firefox</title><content type='html'>&lt;div style=&quot;text-align: justify;&quot;&gt;
 When we have several different accounts of email, twitter, facebook and etc. And We wanna login at the same time with firefox. We must create a new user profile in mozila firefox. There are two ways to do it
&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
 &lt;ol style=&quot;text-align: justify;&quot;&gt;
  &lt;li&gt;Using the manual method with RUN&lt;/li&gt;
  Do like this.
  &lt;ul&gt;
   &lt;li&gt;
    Click Start Menu =&gt; Select Run or use the shortcut &quot;CTRL + R&quot; 
   &lt;/li&gt;
   &lt;li&gt;     
    Type &quot;firefox.exe -p -no-remote&quot; And then click &quot;OK&quot;, so it will open new dialog box &quot;Firefox -Choose User Profile&quot;. 
   &lt;/li&gt;
   &lt;li&gt;     
    Next click Create Profile, follow the steps to finish. 
   &lt;/li&gt;
   &lt;li&gt;     
    If you have finish create the user profile, you can use that to login with another accounts.
   &lt;/li&gt;
   &lt;li&gt;     
    To add another Firefox user profile, simply repeat the steps above, depending on how many users Firefox do you want. 
   &lt;/li&gt;
   &lt;li&gt;     
    That&#39;s the way login with 2 diferrent account at the same time Using Firefox. With this we really have 2 firefox with a different setting. Automatic the new profile is using the default setting
   &lt;/li&gt;
   &lt;li&gt;     
    Original link : &lt;a href=&quot;http://adfoc.us/364235406331&quot; target=&quot;_blank&quot;&gt;calovision&lt;/a&gt;
   &lt;/li&gt; 
  &lt;/ul&gt;
  &lt;br/ &gt;&lt;br/ &gt;
  &lt;li&gt;Using Multifox&lt;/li&gt;
  &lt;ul&gt;
   &lt;li&gt;  
   Multifox is a Firefox extension that lets user log on to the web using different account at the same time.
   &lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;
   &lt;img border=&quot;0&quot; height=&quot;216&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfrgvR_wEJOf0DUUM3DXevjqcvFr0LL7cqUFnpogaE7jthIooYE9QvwKJvayE1rEIo2Ylb10h-TVK9HvMcCFpsmQ_QmVKgmFdleU2PsiniNRa5U4aqS6TDbjoLEvZcr6VElkIcsZ3iDyY/s1600/menu-bookmarks-en.png&quot; width=&quot;320&quot; /&gt;
   &lt;/div&gt;
   &lt;/li&gt;
   &lt;li&gt;
    Click this link to get multifox &lt;a href=&quot;http://adfoc.us/364235358747&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot; target=&quot;_blank&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;20&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXrRIAWC77S4ApSeQeM7Dg2MbGpIJS-KV4dsML5QMjgwcPr8ajpD3aPN1EP63H159OM_cvuJpI6KMgIIEXUY3_iVN7rwniyJ4_KEusYC58SwvS-Ahs_qphKebQs_Mq5I6c1xJ8EIcPNp4/s1600/logo.png&quot; width=&quot;200&quot; /&gt;&lt;/a&gt;
   &lt;/li&gt;
  &lt;/ul&gt;
 &lt;/ol&gt;
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/8482052995387392468/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/05/login-two-user-account-using-firefox.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/8482052995387392468'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/8482052995387392468'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/05/login-two-user-account-using-firefox.html' title='Login two user account using firefox'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfrgvR_wEJOf0DUUM3DXevjqcvFr0LL7cqUFnpogaE7jthIooYE9QvwKJvayE1rEIo2Ylb10h-TVK9HvMcCFpsmQ_QmVKgmFdleU2PsiniNRa5U4aqS6TDbjoLEvZcr6VElkIcsZ3iDyY/s72-c/menu-bookmarks-en.png" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-6196008383945772219</id><published>2012-05-10T21:24:00.000-07:00</published><updated>2012-05-16T21:24:43.545-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips and tricks"/><title type='text'>Set Post Align Justify Automatically</title><content type='html'>&lt;div style=&quot;text-align: justify;&quot;&gt;
In the standard template of blogger. Post that we&#39;ll make automatic align left, to make posts align Justify we have to set it every time we make a new post. It&#39;s quite complicated because it takes time. Well to make a post on your blog automatic align justify, simply by adding a CSS trick in the HTML template of your blog.&lt;br /&gt;
&lt;br /&gt;
Follow the tips.&lt;br /&gt;
&lt;br /&gt;
First let me tell, themes that I use is a standard blogger themes, then Find the code below.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;blockquote&gt;
&lt;code&gt;.post-body { line-height: 1.4; position: relative; }&lt;/code&gt;
&lt;/blockquote&gt;
&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
and then add the following code.&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;blockquote&gt;
&lt;code&gt;text-align: justify;&lt;/code&gt;
&lt;/blockquote&gt;
&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
so that becomes like this&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;blockquote&gt;
&lt;code&gt;.post-body {line-height: 1.4;position: relative;text-align: justify;}&lt;/code&gt;&lt;/blockquote&gt;
&lt;/div&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
*** Good Luck ***&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/6196008383945772219/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/05/set-post-align-justify-automatically_10.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/6196008383945772219'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/6196008383945772219'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/05/set-post-align-justify-automatically_10.html' title='Set Post Align Justify Automatically'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-2718725303768725971.post-2904335766170576015</id><published>2012-05-09T21:25:00.000-07:00</published><updated>2012-05-18T20:30:23.872-07:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="tips and tricks"/><category scheme="http://www.blogger.com/atom/ns#" term="Windows"/><title type='text'>Upgrade IDMcc Add Ons for Mozila Firefox</title><content type='html'>Read The &lt;a href=&quot;http://adfoc.us/364235580069&quot; target=&quot;_blank&quot;&gt;Indonesian Version&lt;/a&gt;
&lt;br /&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;/div&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;
&lt;a href=&quot;http://adfoc.us/364235358386&quot; imageanchor=&quot;1&quot; style=&quot;margin-left: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;320&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyGGPNZjMDwKPpu8lFCYciYICsgRxducIGWjylfjlammb6t2-KXNCnkpI-TUgOixsW0b8vjhfzL6EnCfDO2hmybW1_QFq9aiEqI3yL9WvebnkjVz3TFoXY_khwwQbnpyAykq-ZFhRRnr8/s320/idm.png&quot; width=&quot;233&quot; /&gt;&lt;/a&gt;&lt;/div&gt;
Latest update of Mozilla Firefox has many additional features, but this update makes some addons not support. For example, Internet Download Manager (IDM CC) is an extension that allows the IDM to auto capture streaming video when the play button is clicked or audio streaming when the play button is clicked. To re-enable this feature on the new version of mozilla firefox. IDM CC is needed upgrade to the latest version. At least that&#39;s what I did after reading the article in Largest Indonesian Community (&lt;a href=&quot;http://adfoc.us/364235014184&quot;&gt;Kaskus&lt;/a&gt;), so my Internet Download Manager is running normally again.
&lt;/div&gt;
&lt;div style=&quot;text-align: justify;&quot;&gt;
&lt;ol&gt;
&lt;li&gt;To upgrade click the following link &lt;a href=&quot;http://adfoc.us/364235358064&quot;&gt;idmmzcc.xpi&lt;/a&gt; to download the &quot;xpi&quot; file&lt;/li&gt;
&lt;li&gt;To install, start firefox and open the “xpi” file: File&amp;gt;Open File&lt;/li&gt;
&lt;li&gt;After that follow the process as we&#39;re installing on Mozilla Firefox Add Ons.&lt;/li&gt;
&lt;/ol&gt;
&lt;/div&gt;
&lt;div style=&quot;text-align: center;&quot;&gt;
** I Hope This Article Useful **
&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://obinote.blogspot.com/feeds/2904335766170576015/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://obinote.blogspot.com/2012/05/upgrade-idmcc-add-ons-for-mozila_09.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/2904335766170576015'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/2718725303768725971/posts/default/2904335766170576015'/><link rel='alternate' type='text/html' href='http://obinote.blogspot.com/2012/05/upgrade-idmcc-add-ons-for-mozila_09.html' title='Upgrade IDMcc Add Ons for Mozila Firefox'/><author><name>Anonymous</name><uri>http://www.blogger.com/profile/02033968808334794290</uri><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyGGPNZjMDwKPpu8lFCYciYICsgRxducIGWjylfjlammb6t2-KXNCnkpI-TUgOixsW0b8vjhfzL6EnCfDO2hmybW1_QFq9aiEqI3yL9WvebnkjVz3TFoXY_khwwQbnpyAykq-ZFhRRnr8/s72-c/idm.png" height="72" width="72"/><thr:total>0</thr:total></entry></feed>