<?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-5619550813183664888</id><updated>2026-02-28T08:07:38.936+08:00</updated><category term="Products"/><category term="Beauty Product"/><category term="About Me"/><category term="My Diary"/><category term="Technology Tutorials"/><category term="javascript jquery"/><category term="Knowledge"/><category term="Living Skills"/><category term="Creative"/><category term="Money"/><category term="Events"/><category term="Horoscopes"/><category term="Meaningful Words"/><category term="php mySQL"/><category term="Website"/><category term="HTML Css"/><category term="Internet"/><category term="Business"/><category term="Caution"/><category term="Graphic"/><category term="Technology Article"/><category term="Health"/><category term="Funny"/><category term="zodiac"/><category term="Entertainments"/><category term="Boys"/><category term="Girl"/><category term="Plurk"/><category term="Art"/><category term="Emoticons"/><category term="Love"/><category term="Pet"/><category term="Services"/><category term="odd"/><category term="Blogspot"/><category term="Cute"/><category term="Food"/><category term="News"/><category term="Building Body"/><category term="Fashion"/><category term="Software"/><category term="Facebook"/><category term="Job"/><category term="Story"/><category term="Surgery"/><category term="Adobe Flash"/><category term="Animal"/><category term="Database"/><category term="Interesting"/><category term="Investment"/><category term="Music"/><category term="My Theory"/><category term="Penang"/><category term="Problem"/><category term="Teeth"/><category term="movie"/><category term="Accidents"/><category term="Advertisement"/><category term="Furniture"/><category term="Houses"/><category term="Lame"/><category term="Life"/><category term="Medical"/><category term="My Friends"/><category term="Places"/><category term="Thailand"/><category term="Video"/><category term="law"/><title type='text'>Ye5</title><subtitle type='html'>A blog about how to make money, improve beauty, website, animation, graphic design, living skills, life.</subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><link rel='next' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default?start-index=26&amp;max-results=25'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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>535</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-5619550813183664888.post-5985741854271994487</id><published>2025-07-03T03:46:00.004+08:00</published><updated>2025-07-03T03:46:49.430+08:00</updated><title type='text'>Cherybooking</title><content type='html'>1) When adding Car Model, after copy paste the existing code, do NOT modify the id, otherwise the css will loss.&lt;br&gt;&lt;br&gt;

Click &quot;Learn More&quot; button popup code at line 1599 :&lt;br&gt;
&amp;lt;div data-elementor-type=&quot;popup&quot; data-elementor-id=&quot;487&quot; /&amp;gt;&lt;br&gt;&lt;br&gt;

Modify id=487 to other id=488&lt;br&gt;
Then edit the click popup url :&lt;br&gt;
href=&quot;#elementor-action:action=popup:open&amp;settings=eyJpZCI6IjQ4NyIsInRvZ2dsZSI6ZmFsc2V9&quot;&lt;br&gt;&lt;br&gt;

the value after settings = is Base64 encoded, so we need to decoded it.
</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/5985741854271994487/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/5985741854271994487' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/5985741854271994487'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/5985741854271994487'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2025/07/cherybooking.html' title='Cherybooking'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-3076183019492766908</id><published>2024-10-18T21:28:00.009+08:00</published><updated>2024-10-21T05:12:05.263+08:00</updated><title type='text'>PHP Tutorial</title><content type='html'>&lt;textarea style=&quot;height: 500px; width: 670px;&quot;&gt;  

$price = isset($_POST[&#39;price&#39;]) ? $_POST[&#39;price&#39;] : &#39;&#39;;&lt;br&gt;&lt;br&gt;

var reportContent = &lt;?php echo isset($_SESSION[&#39;report_content&#39;]) ? json_encode($_SESSION[&#39;report_content&#39;]) : &#39;null&#39;; ?&gt;;
  
  
//get only 1 column record
$sql = &quot;SELECT id FROM driver WHERE RIGHT(driver_phone, 7) = &#39;$last7DriverDigits&#39;&quot;;
$driver_id = $conn-&gt;query($sql)-&gt;fetch_column();
  
&lt;/textarea&gt;</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/3076183019492766908/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/3076183019492766908' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/3076183019492766908'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/3076183019492766908'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2024/10/php-tutorial.html' title='PHP Tutorial'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-4226700955451962763</id><published>2024-05-26T13:38:00.010+08:00</published><updated>2024-08-13T13:09:08.034+08:00</updated><title type='text'>Davici Furniture Theme Wordpress Customization</title><content type='html'>Edit Footer :&lt;br/&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqy4jeNtm8y4fgx5AcIcTJgXochURGaaqdHWDFz7SOPIkk6wqfZXYfaiNOnguoJWouMuR_AQM-IuzsGQYUGTgdjVnoz90AuNrDyrGDe2Oav3lPN7sardXNPdLJA7cv_ukBwNSCtV88kgAm07tr3bDx8iFLzV9NQOx8STX59mGBAskv4NsgoxIlKDBv4ZVF/s1600/edit-footer.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;771&quot; data-original-width=&quot;1695&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiqy4jeNtm8y4fgx5AcIcTJgXochURGaaqdHWDFz7SOPIkk6wqfZXYfaiNOnguoJWouMuR_AQM-IuzsGQYUGTgdjVnoz90AuNrDyrGDe2Oav3lPN7sardXNPdLJA7cv_ukBwNSCtV88kgAm07tr3bDx8iFLzV9NQOx8STX59mGBAskv4NsgoxIlKDBv4ZVF/s670/edit-footer.jpg&quot;/&gt;&lt;/a&gt;
  
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQE7JZ565dxR9mwLdvK4Hnp9BkGiPro9LGTC82AUC71C83njpFUgaNy0saNb_npI-3OMfFimTZZRggIDM0KBY8dTiLzDvowJQtVuT0bxWd08Ru084SIJJ49eirVnPpseE9NoJozga6jujJuaGGl6gYEMKTELtmCr63wMnU9803B2ufc2rK1kUfGZ7XwEvt/s1600/wp_footer.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;669&quot; data-original-width=&quot;1807&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQE7JZ565dxR9mwLdvK4Hnp9BkGiPro9LGTC82AUC71C83njpFUgaNy0saNb_npI-3OMfFimTZZRggIDM0KBY8dTiLzDvowJQtVuT0bxWd08Ru084SIJJ49eirVnPpseE9NoJozga6jujJuaGGl6gYEMKTELtmCr63wMnU9803B2ufc2rK1kUfGZ7XwEvt/s670/wp_footer.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;&lt;br/&gt;

Remove Social icon Twitter and Tiktok :&lt;br/&gt;
wpBingo &gt; Theme Option &gt; Social Link &gt; Leave empty textbox for Twitter and Tiktok.&lt;br/&gt;&lt;br/&gt;

Edit Header :&lt;br/&gt;
First need to check what is the number of header by counting at Appearance &gt; Theme Option &gt; Header.&lt;br/&gt;&lt;br/&gt;

Then go DirectAdmin or Cpanel file manager : wp-content/themes/davici/templates/headers/headers-6.php&lt;br/&gt;&lt;br/&gt;

Find keyword &quot;Call us&quot;, replace &quot;Whatsapp&quot;.&lt;br/&gt;&lt;br/&gt;

Or Appearance &gt; Theme File &gt; template &gt; headers &gt; herder-7.php (Might have error when click &quot;Save/Update&quot; button.
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizLxNTkymwWI6LUxbkhLO_SExV-Sx3f15O7cfT5AdDS3i59RVjVYuN_vOv1uysEVDudm8g1-8KP0LDR4WD6omDCe9Jyrp66bv3lKy5aa_wxGbiJ1b0H4xIKQXkwGco0suNmiUU922XGLQm9JQgsxSoQKW2j4lyAd9Lgcxsve66tfMhcNkMmvQmaSzlqvJs/s1600/image%20%2896%29.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;521&quot; data-original-width=&quot;1304&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEizLxNTkymwWI6LUxbkhLO_SExV-Sx3f15O7cfT5AdDS3i59RVjVYuN_vOv1uysEVDudm8g1-8KP0LDR4WD6omDCe9Jyrp66bv3lKy5aa_wxGbiJ1b0H4xIKQXkwGco0suNmiUU922XGLQm9JQgsxSoQKW2j4lyAd9Lgcxsve66tfMhcNkMmvQmaSzlqvJs/s670/image%20%2896%29.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;

Select different Theme :&lt;br/&gt;
Go to Appearance &gt; Customize &gt; Select Homepage
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjn-435JIcoEJHsaYaNma6FmpNIE62uhyphenhyphenFycuadkoQu4xvfllZtnskFJyZO3dLLteOABhS7mr2sZVFqA6OEtxT37qeZb37Y0QsBib6mFn5Zg01mMQO47sVvPRScUX-Ikt5ngh66bfUhXGoWo5RH8eVxfXYSB0oG6Wy7ip1OqUikHT6QH47UWdtRKETiAIrh/s1600/image%20%2897%29.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;706&quot; data-original-width=&quot;595&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjn-435JIcoEJHsaYaNma6FmpNIE62uhyphenhyphenFycuadkoQu4xvfllZtnskFJyZO3dLLteOABhS7mr2sZVFqA6OEtxT37qeZb37Y0QsBib6mFn5Zg01mMQO47sVvPRScUX-Ikt5ngh66bfUhXGoWo5RH8eVxfXYSB0oG6Wy7ip1OqUikHT6QH47UWdtRKETiAIrh/s670/image%20%2897%29.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;

Upload new logo:&lt;br/&gt;
Pages &gt; Home Page 7 &gt; Edit &gt; Header &gt; Page Logo (Upload)&lt;br/&gt;&lt;br/&gt;

How to show latest/top rate products on homepage7?
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-BMtsrVvYYpb3_0iIq5gViX4huu_r49V72mU_PzOD4XMgxNvZ9Ny0KqFtxwuXKbcnrMc-sTwP7Yy48mExJ2N0MJaZzSEUP1zTJb4Q13aKz7dnpxJQdwOpWVyGLZAU6wnNi51LDrHBRLZkV03Ckq93eVDWLj8fZNQ_U2WP_KvuCICSGSBAKSIeUkbHbXuI/s1366/image%20-%202024-07-20T230833.434.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;670&quot; data-original-width=&quot;1366&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-BMtsrVvYYpb3_0iIq5gViX4huu_r49V72mU_PzOD4XMgxNvZ9Ny0KqFtxwuXKbcnrMc-sTwP7Yy48mExJ2N0MJaZzSEUP1zTJb4Q13aKz7dnpxJQdwOpWVyGLZAU6wnNi51LDrHBRLZkV03Ckq93eVDWLj8fZNQ_U2WP_KvuCICSGSBAKSIeUkbHbXuI/s680/image%20-%202024-07-20T230833.434.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxClTibon9hQQyp8snuEqPQFbcOuUHwQhgBMOOySx7zxFXnyfaO7vdQlFG46Zm6JHZRxmiE4_M36-LowLkoI26QKSbths3eItRpCHqVvS7Uc-4vwLLlv2uaFJ3PgSWXc08Mv7-2ykCKngRvTzjWW8bdVfA_MJth4H_ssdK_ZWr5gj7aad05Pzpx0Y8tDEX/s804/5212249377.png&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;670&quot; data-original-height=&quot;804&quot; data-original-width=&quot;745&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxClTibon9hQQyp8snuEqPQFbcOuUHwQhgBMOOySx7zxFXnyfaO7vdQlFG46Zm6JHZRxmiE4_M36-LowLkoI26QKSbths3eItRpCHqVvS7Uc-4vwLLlv2uaFJ3PgSWXc08Mv7-2ykCKngRvTzjWW8bdVfA_MJth4H_ssdK_ZWr5gj7aad05Pzpx0Y8tDEX/s680/5212249377.png&quot;/&gt;&lt;/a&gt;&lt;/div&gt;

How to add Deals of Days products?
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhukQLjAV0lx9IxuHZKA_8OOF1jFDIkMS5NEA2dkXLeCIYgcxKc-jSZrKYSkA37nW9OISCktwlEVZoW9Nhfcib8iFbomwVXSRA2IRZbk2URqqwiWI56J7f2ds0UKTRNiJyLRrw2YhTr4ltVc3_NeMh2xWYYDuNBXAo_rK93bQ0BZFBNtqEtZIMiaf1V98SJ/s1237/2630185803.png&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;670&quot; data-original-height=&quot;658&quot; data-original-width=&quot;1237&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhukQLjAV0lx9IxuHZKA_8OOF1jFDIkMS5NEA2dkXLeCIYgcxKc-jSZrKYSkA37nW9OISCktwlEVZoW9Nhfcib8iFbomwVXSRA2IRZbk2URqqwiWI56J7f2ds0UKTRNiJyLRrw2YhTr4ltVc3_NeMh2xWYYDuNBXAo_rK93bQ0BZFBNtqEtZIMiaf1V98SJ/s670/2630185803.png&quot;/&gt;&lt;/a&gt;&lt;/div&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCgFnG_k-tnIfc8kJRp35wZr7GKzoMx4I1S6s4N_HIZrI4tLw3ZeGMdEqN3yWye-686P2fCCCRiIX8ZzElfZzDFo4uFnflmQZnYvar-TyVKqIIgB2e7lUQcjRFtypcMDe23qm5Q5nThzeOlrJPdViGOZJCiQCViBPl5fQpCB-65HmxkRD4mlevp-YAh3d4/s1041/image%20-%202024-07-23T140218.014.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;670&quot; data-original-height=&quot;447&quot; data-original-width=&quot;1041&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCgFnG_k-tnIfc8kJRp35wZr7GKzoMx4I1S6s4N_HIZrI4tLw3ZeGMdEqN3yWye-686P2fCCCRiIX8ZzElfZzDFo4uFnflmQZnYvar-TyVKqIIgB2e7lUQcjRFtypcMDe23qm5Q5nThzeOlrJPdViGOZJCiQCViBPl5fQpCB-65HmxkRD4mlevp-YAh3d4/s670/image%20-%202024-07-23T140218.014.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;

How to disable / hide floating sticky &quot;add to cart&quot; bottom bar on product page?
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhK2dMCflhq-J2O4pA6GKLPZcU2ChiNfrj0pHrbXM_dl_Rf9FYxcCMphy4xDk5XV8M1m91zcDzgT_Fjr-0ZzyPuVbiKkhNOD6FfxeNyVcvGB0iinrtI2bYyKbjJH8a-EYmtXQ2kbyT4_lUlbUX1wQqNbhoKvLr0FBtM7VbRqjpSQpQWT_nTnKhlxkSPiDcC/s1366/image%20-%202024-07-23T150023.631.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;670&quot; data-original-height=&quot;731&quot; data-original-width=&quot;1366&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhK2dMCflhq-J2O4pA6GKLPZcU2ChiNfrj0pHrbXM_dl_Rf9FYxcCMphy4xDk5XV8M1m91zcDzgT_Fjr-0ZzyPuVbiKkhNOD6FfxeNyVcvGB0iinrtI2bYyKbjJH8a-EYmtXQ2kbyT4_lUlbUX1wQqNbhoKvLr0FBtM7VbRqjpSQpQWT_nTnKhlxkSPiDcC/s670/image%20-%202024-07-23T150023.631.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2Et-Mwm-j1y4Xtee1SaS8LTm4Gmo6-HoTIeNopjZY0kMB-bRnXEbj5n9dt2XR953kQ_6eRJU0m1TrtwOb9h_VRrh6_6I2P8xDpdWx1s6orSZOBCCxrdYyF96ET8XBq9Z0NP0PfJgfMfXHSKP6DAsHqbqQFvjFr7YMDnUDzbPyNPJqFqlcaIVElsbQIVdT/s963/image%20-%202024-07-23T155707.355.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;670&quot; data-original-height=&quot;615&quot; data-original-width=&quot;963&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2Et-Mwm-j1y4Xtee1SaS8LTm4Gmo6-HoTIeNopjZY0kMB-bRnXEbj5n9dt2XR953kQ_6eRJU0m1TrtwOb9h_VRrh6_6I2P8xDpdWx1s6orSZOBCCxrdYyF96ET8XBq9Z0NP0PfJgfMfXHSKP6DAsHqbqQFvjFr7YMDnUDzbPyNPJqFqlcaIVElsbQIVdT/s670/image%20-%202024-07-23T155707.355.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;

How to turn off lazy load :
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrx5dn_294Mtsxg_wiU3tT_LFn16n9nfUfAFIwm_FLqSNMesAA4pinuvV7pRncXMkQ3KbEqYD_pV40hqxHiXIwONDUz_FPsOVF8CIWr1Sq_a_bw7XKCV6OF1EETEhS9MBP_hEQgcZZVsjwnguOclA90uOqOS689T8b8hsmBolraKop-nvycyVUeNGE8yjN/s1600/image%20-%202024-08-13T130442.892.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;658&quot; data-original-width=&quot;667&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrx5dn_294Mtsxg_wiU3tT_LFn16n9nfUfAFIwm_FLqSNMesAA4pinuvV7pRncXMkQ3KbEqYD_pV40hqxHiXIwONDUz_FPsOVF8CIWr1Sq_a_bw7XKCV6OF1EETEhS9MBP_hEQgcZZVsjwnguOclA90uOqOS689T8b8hsmBolraKop-nvycyVUeNGE8yjN/s670/image%20-%202024-08-13T130442.892.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;

Mobile view bottom buttons / menu :&lt;br&gt;
modesco/wp-content/themes/davici/inc/function.php&lt;br&gt;&lt;br&gt;</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/4226700955451962763/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/4226700955451962763' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/4226700955451962763'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/4226700955451962763'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2024/05/davici-furniture-theme-wordpress.html' title='Davici Furniture Theme Wordpress Customization'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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/AVvXsEiqy4jeNtm8y4fgx5AcIcTJgXochURGaaqdHWDFz7SOPIkk6wqfZXYfaiNOnguoJWouMuR_AQM-IuzsGQYUGTgdjVnoz90AuNrDyrGDe2Oav3lPN7sardXNPdLJA7cv_ukBwNSCtV88kgAm07tr3bDx8iFLzV9NQOx8STX59mGBAskv4NsgoxIlKDBv4ZVF/s72-c/edit-footer.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5619550813183664888.post-8363794768967273557</id><published>2024-01-20T03:33:00.006+08:00</published><updated>2024-01-20T03:33:57.753+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="javascript jquery"/><title type='text'>jquery click on each line of td to pop up window content</title><content type='html'>&lt;textarea style=&quot;height: 890px; width: 670px;&quot;&gt;  
$(&#39;td&#39;).on(&#39;click&#39;, function(eventData) {
  var full = $(this).text();
  var pairSymbol = $(this).contents().eq(0).text();
  var pairSymbolClearSpace = pairSymbol.split(&quot; &quot;).join(&quot;&quot;); 

  var lineHeight = $(this).css(&quot;line-height&quot;);
  lineHeight = parseInt(lineHeight.substring(0, lineHeight.length - 2));

  var line = Math.floor(eventData.offsetY / lineHeight);
  var fullLine = ($(this).text().split(&quot;\n&quot;)[line]);

  var splitFullLine = fullLine.split(&quot; = &quot;);
  var tElement = splitFullLine[0];
  var tElementClearSpace = tElement.split(&quot; &quot;).join(&quot;&quot;); 

  var beforeStar = splitFullLine[1].split(&quot;*&quot;);
  var buySell = beforeStar[0];
  var buySellClearSpace = buySell.split(&quot; &quot;).join(&quot;&quot;); 

  $(&quot;#pairSymbol&quot;).val(&quot;&quot;);
  $(&quot;#tElement&quot;).val(&quot;&quot;);
  $(&quot;#tElement&quot;).val(&quot;&quot;);
  $(&quot;#winCount&quot;).val(&quot;&quot;);
  $(&quot;#lossCount&quot;).val(&quot;&quot;);

  $(&quot;#pairSymbol&quot;).val(pairSymbolClearSpace);
  $(&quot;#tElement&quot;).val(tElementClearSpace);
  $(&quot;#buySell&quot;).val(buySellClearSpace);
  //alert(buySell);

  $.ajax({
  type: &quot;POST&quot;,
  url: &quot;modal_view_winLoss.php&quot;,
  data: {
  pairSymbol: pairSymbolClearSpace,
  tElement: tElementClearSpace,
  buySell: buySellClearSpace
  },

  cache: false,
  success:function(data)
  {
  if(data == &quot;error&quot;)
  {
  location.reload();
  }
  else
  {
  var winLoss = data.split(&quot;##&quot;);
  $(&quot;#winCount&quot;).val(&quot;&quot;);
  $(&quot;#lossCount&quot;).val(&quot;&quot;);
  $(&quot;#winCount&quot;).val(winLoss[0]);
  $(&quot;#lossCount&quot;).val(winLoss[1]);
  }
  }
});
&lt;/textarea&gt;</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/8363794768967273557/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/8363794768967273557' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/8363794768967273557'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/8363794768967273557'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2024/01/jquery-click-on-each-line-of-td-to-pop.html' title='jquery click on each line of td to pop up window content'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-7202770770073188365</id><published>2024-01-20T03:27:00.002+08:00</published><updated>2024-01-20T03:34:07.755+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="javascript jquery"/><title type='text'>jquery select all same text on the whole page</title><content type='html'>&lt;textarea style=&quot;height: 870px; width: 670px;&quot;&gt;  
&lt;button type=&quot;button&quot; onclick=&quot;mark(&#39;寅&#39;)&quot;&gt;寅&lt;/button&gt;
  
&lt;script&gt; 
	// Start Highlight text on whole page.
    function mark(char) {
        let contentElement = document.getElementById(&#39;sentences&#39;);
        let textNodes = getTextNodes(contentElement);

        // Clear previous highlights
        unmarkAll(textNodes);

        // Use a regular expression to find all occurrences of the character
        let regex = new RegExp(char, &#39;g&#39;);

        textNodes.forEach(node =&gt; {
            let textContent = node.textContent;
            let matches = textContent.matchAll(regex);

            for (const match of matches) {
                let range = document.createRange();
                range.setStart(node, match.index);
                range.setEnd(node, match.index + match[0].length);

                let markElement = document.createElement(&#39;mark&#39;);
                range.surroundContents(markElement);
            }
        });
    }

    function getTextNodes(element) {
        let walker = document.createTreeWalker(element, NodeFilter.SHOW_TEXT, null, false);
        let textNodes = [];

        while (walker.nextNode()) {
            textNodes.push(walker.currentNode);
        }

        return textNodes;
    }

    function unmarkAll(nodes) {
        nodes.forEach(node =&gt; {
            let parentNode = node.parentNode;

            if (parentNode &amp;&amp; parentNode.nodeName === &#39;MARK&#39;) {
                let textNode = document.createTextNode(node.textContent);
                parentNode.replaceWith(textNode);
            }
        });
    }
    // End Highlight text on whole page.
&lt;/script&gt;
&lt;/textarea&gt;</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/7202770770073188365/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/7202770770073188365' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/7202770770073188365'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/7202770770073188365'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2024/01/jquery-select-all-same-text-on-whole.html' title='jquery select all same text on the whole page'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-2684055021027148864</id><published>2024-01-20T03:21:00.012+08:00</published><updated>2024-01-20T09:00:13.892+08:00</updated><category scheme="http://www.blogger.com/atom/ns#" term="javascript jquery"/><title type='text'>jquery how to select character before &#39;=&#39; and add the character after &#39;*&#39; and before &amp;lt;br/ &amp;gt; :  Add winCount and lossCount before &amp;lt;br/ &amp;gt;</title><content type='html'>&lt;textarea style=&quot;height: 1000px; width: 670px;&quot;&gt;  
  
&lt;script src=&quot;https://code.jquery.com/jquery-3.6.4.min.js&quot;&gt;&lt;/script&gt;
&lt;script&gt;
 $(document).ready(function() {
        
    //start adding winCount and lossCount to beside
    var dbData = &lt;?php echo json_encode($arrayDbData); ?&gt;;
    var myString = JSON.stringify(dbData); //convert json to string
    
    myString = myString.slice(2); //remove 1st 2 characters
    myString = myString.slice(0,-2) //remove last 2 characters
    myString = myString.replace(/[,&quot;]/g, &#39;&#39;); //remove &quot;,&quot;
    
    var arrayLine = myString.split(&#39;&lt;br&gt;&#39;);
    var i = 0;
    jQuery.each(arrayLine, function() {
        var eachData = arrayLine[i].split(&#39;##&#39;);
        var pairSymbol = eachData[0].trim();
        var elementName = eachData[1];
        var winCount = eachData[2];
        var lossCount = eachData[3];
        
       //hehe
        let targetTd = $(&#39;td:contains(&quot;&#39; + pairSymbol + &#39;&quot;)&#39;);
        if (targetTd.length &gt; 0) {

            let tdContent = targetTd.html();
            var $html = $(`&lt;span&gt;${tdContent}&lt;/span&gt;`);
            
            $html.each(function() {
               
                if ($(this).text().includes(elementName)) {
                   
                    $(this).html(function(index, oldHtml) {
                        
                        //return oldHtml.replace(&#39;*&lt;br&gt;&#39;, &#39;* &lt;span style=&quot;color:blue;&quot;&gt;&#39; + winCount + &#39; &lt;/span&gt;&lt;span style=&quot;color:red;&quot;&gt;&#39; + lossCount + &#39;&lt;/span&gt;&lt;br&gt;&#39;);
                        
                        var escapedElement = elementName.replace(/[-\/\\^$*+?.()|[\]{}]/g, &#39;\\$&amp;&#39;);
                        var regex = new RegExp(&#39;(&#39; + escapedElement + &#39;.*?)(&lt;br&gt;)&#39;);

                        return oldHtml.replace(regex, &#39;$1 &lt;span style=&quot;color:blue;&quot;&gt;&#39; + winCount + &#39; &lt;/span&gt;&lt;span style=&quot;color:red;&quot;&gt;&#39; + lossCount + &#39;&lt;/span&gt;$2&#39;);

                                           
                        
                    });
                    
                    $(&#39;td:contains(&quot;&#39; + pairSymbol + &#39;&quot;)&#39;).html($html.prop(&#39;outerHTML&#39;));
                    return false; // Exit the loop once the line is found
                }
            });

            //console.log($html.prop(&#39;outerHTML&#39;));
        } else {
            console.log(&#39;No matching &lt;td&gt; found.&#39;);
        }
        
        i++;
    });
});
&lt;/script&gt;
  
  
&lt;/textarea&gt;</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/2684055021027148864/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/2684055021027148864' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/2684055021027148864'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/2684055021027148864'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2024/01/jquery-how-to-select-character-before.html' title='jquery how to select character before &#39;=&#39; and add the character after &#39;*&#39; and before &amp;lt;br/ &amp;gt; :  Add winCount and lossCount before &amp;lt;br/ &amp;gt;'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-3207354758950646972</id><published>2024-01-15T07:01:00.001+08:00</published><updated>2024-01-15T07:01:03.489+08:00</updated><title type='text'>Software Chinese Language on Windows 10</title><content type='html'>Windows search language setting &gt; Region &gt; Additional Date Time and Region Settings &gt; Region : Change Date Time and Region Format &gt; &lt;br/&gt;&lt;br/&gt;

1) Formats Tab &gt; Format : English (United States)&lt;br/&gt;&lt;br/&gt;

2) Admistrative Tab &gt; Language for non-Unicode programs (Change system locale...) &gt; Chinese (Simplified, Singaotre) &gt; Uncheck UTF-8&lt;br/&gt;&lt;br/&gt;</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/3207354758950646972/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/3207354758950646972' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/3207354758950646972'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/3207354758950646972'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2024/01/software-chinese-language-on-windows-10.html' title='Software Chinese Language on Windows 10'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-8375119110847886754</id><published>2023-11-03T06:37:00.007+08:00</published><updated>2023-11-03T21:18:14.249+08:00</updated><title type='text'>My first covid experience</title><content type='html'>2023 Oct 26 was my first infected covid.&lt;/br&gt;&lt;/br&gt;


I though it was just normal fever and sorethroat.&lt;/br&gt;&lt;/br&gt;

But many strange symptom :&lt;/br&gt;&lt;/br&gt;

1) My eyes very tired always want to close and sleep. I can sleep for 3 days without eat, without shower. Normally people sleep fully 8 hours already enough, but I sleep 60 hours still not enough.&lt;/br&gt;&lt;/br&gt;

2) I checked my heart rate increase to 110, I asked phamacy is it normal if heart rate 110 during fever? they said NOT normal.&lt;/br&gt;&lt;/br&gt;

3) I drink alot of water but still no pee, my little pee was yellow color. I guess all water stuck on stomach can&#39;t digest water, and i always vomit out the water and food.&lt;/br&gt;&lt;/br&gt;

4) I don&#39;t have appertise to eat anything. I continue 3 days no eat anything, i worry gastric will happen. I don&#39;t even has energy to bite any food. I try to cook maggie mee, then 1st bite on the mee feel very tired lazy to bite, I think i can hold the mee in my mouth to let it disolve itself, but it can&#39;t, so i just throw it all. Then i cook poride and drink poride every 5 hours just to prevent gastric. &lt;/br&gt;&lt;/br&gt;

5) My room is hot but my hold body feel cold. Especially bottom of my legs and hand palm area feeling super cold.&lt;/br&gt;&lt;/br&gt;

6) When my fever is gone today, then i feel good. Then tomorow fever come back again wtf. Doctor say this is covid symptom fever always come back again on next day.&lt;/br&gt;&lt;/br&gt;

7) When fever, luckly my muscles feel no sour and no pain, but i feel no energy to move, I walk like turtle speed. Easy get tired.&lt;/br&gt;&lt;/br&gt;

8) After 1 week, my head dizzy, i think because there are many anti-virus armies produced in 1 week to protect my lung, so virus can&#39;t stay in lung anymore, so virus goes up live on my brain, virus attack my brain so my brain dizzy?&lt;/br&gt;&lt;/br&gt;</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/8375119110847886754/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/8375119110847886754' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/8375119110847886754'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/8375119110847886754'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2023/11/my-first-covid-experience.html' title='My first covid experience'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-1810716761987187114</id><published>2023-10-14T19:01:00.003+08:00</published><updated>2023-10-14T19:01:52.343+08:00</updated><title type='text'>Stop ajax from submitting form before validate form</title><content type='html'>Just move html submit button to outside the form.

After validate form successfully then only trigger form submision.

</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/1810716761987187114/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/1810716761987187114' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/1810716761987187114'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/1810716761987187114'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2023/10/stop-ajax-from-submitting-form-before.html' title='Stop ajax from submitting form before validate form'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-4555448683621288323</id><published>2023-09-19T14:51:00.003+08:00</published><updated>2024-04-02T17:28:11.298+08:00</updated><title type='text'>PHP mailer cannot send email, gmail smtp error.</title><content type='html'>You need to go your google account to set 2nd Authentication scroll down Create App Password.&lt;br/&gt;&lt;br/&gt;

1. Go to your Google Account and choose Security on the left panel.&lt;br/&gt;&lt;br/&gt;

2. On the Signing in to Google tab, select App Passwords.&lt;br/&gt;&lt;br/&gt;

If you don’t see this option, it might mean that:&lt;br/&gt;&lt;br/&gt;

Two-step verification is not set up for your Google account.&lt;br/&gt;&lt;br/&gt;
Two-step verification is set up for security keys only.&lt;br/&gt;&lt;br/&gt;
Your account is used through work, school, or another organization.&lt;br/&gt;&lt;br/&gt;
You’ve turned on Advanced Protection for your account.&lt;br/&gt;&lt;br/&gt;
3. Click on Select app and pick the app you’re using.&lt;br/&gt;&lt;br/&gt;

4. Click Select device and choose the device you’re using.&lt;br/&gt;&lt;br/&gt;

5. Click on Generate.&lt;br/&gt;&lt;br/&gt;


&lt;hr/&gt;
1 - Contact customer service of your hosting server to set firewall allow gmail smtp port 587&lt;br/&gt;&lt;br/&gt;

2 - follow the steps on this webpage to install the latest version phpmailer to your hosting

</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/4555448683621288323/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/4555448683621288323' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/4555448683621288323'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/4555448683621288323'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2023/09/php-mailer-cannot-send-email-gmail-smtp.html' title='PHP mailer cannot send email, gmail smtp error.'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-7247857976846243992</id><published>2023-08-28T20:55:00.024+08:00</published><updated>2023-10-31T06:33:39.936+08:00</updated><title type='text'>Sql and pdo give error when upgraded to mysql new version 8.0.34</title><content type='html'>When my shared hosting upgrade mysql version from 5 to 8, many of my php websites cannot be openned.&lt;br/&gt;&lt;br/&gt;

I checked php error log saw many syntax become error.&lt;br/&gt;&lt;br/&gt;

So here are the fixes of syntax :&lt;br/&gt;

Codeigniter : Library &gt; common.php&lt;br/&gt;
&lt;textarea style=&quot;height: 170px; width: 670px;&quot;&gt; 
Old variable 
$where = &quot;Where id=123&quot;
  
need to modify it become :
$where = &quot;id=123&quot;

So we need to remove &quot;Where&quot; from variable.
$where2 = substr($where,6);

&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;


Cannot combine &lt;b&gt;Select, Table, Where&lt;/b&gt; in 1 query.&lt;br /&gt;
Must saperate &lt;b&gt;Select, Table, Where&lt;/b&gt;.&lt;br /&gt;&lt;br /&gt;
  
&lt;textarea style=&quot;height: 500px; width: 670px;&quot;&gt; 
//Problem code :
  function getSelectedOneField($select,$table,$where) 
		{	
			$q = &quot;select $select from $table $where&quot;;
			$query=$this-&gt;CI-&gt;db-&gt;query($q);
			$result =  $query-&gt;row_array();
			return $result[$select];
		}
  
//Solution code :
  function getSelectedOneField($select, $table, $where) 
        {	
            $this-&gt;CI-&gt;db-&gt;select($select);
            $this-&gt;CI-&gt;db-&gt;from($table);
            
            $where2 = substr($where,6);
            $this-&gt;CI-&gt;db-&gt;where($where2);
        
            $query = $this-&gt;CI-&gt;db-&gt;get();
            $result = $query-&gt;row_array();
        
            if ($result) {
                return $result[$select];
            }
            
            return null; // Return an appropriate value if no result is found
        }
  
&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;


Cannot write query join tables in 1 query (library/common.php).&lt;br /&gt;
Must saperate &lt;b&gt;join tables&lt;/b&gt;.&lt;br /&gt;&lt;br /&gt;
&lt;textarea style=&quot;height: 700px; width: 670px;&quot;&gt; 

// Problem codes :

$total_invested = $this-&gt;getSelectedOneField(&quot;SUM(p.investment_capital) AS abc&quot;, &quot;tbl_product_order o LEFT JOIN tbl_package_master p ON p.id = o.package_id&quot;, &quot;WHERE o.status = 3 AND o.user_id = &#39;&quot; . $user_id . &quot;&#39;&quot;);

// Solution codes :
function getSelectedOneFieldJoinTbl($select, $table, $where, $join_table, $join_condition)
	    {
	        $this-&gt;CI-&gt;db-&gt;select($select);
            $this-&gt;CI-&gt;db-&gt;from($table);
  
  			$where2 = substr($where,6);
            $this-&gt;CI-&gt;db-&gt;where($where2);
            
            if($join_table &amp;&amp; $join_condition)
            {
                $this-&gt;CI-&gt;db-&gt;join($join_table, $join_condition);
            }

            $query = $this-&gt;CI-&gt;db-&gt;get();
            $result = $query-&gt;row_array();
        
            if ($result) {
                return $result[$select];
            }
            
            return null; // Return an appropriate value if no result is found	        
	    }

$total_invested = $this-&gt;getSelectedOneFieldJoinTbl(
    &quot;SUM(p.investment_capital)&quot;,
    &quot;tbl_product_order o&quot;,    
    &quot;WHERE o.status = 3 AND o.user_id = &#39;&quot; . $user_id . &quot;&#39;&quot;,
    &quot;tbl_package_master p&quot;, // $join_table
    &quot;p.id = o.package_id&quot; // $join_condition
);
&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;


Must saperate Group_By :&lt;br /&gt;&lt;br /&gt;
&lt;textarea style=&quot;height: 700px; width: 670px;&quot;&gt; 
  
  	function getAllRecJoinTblGroupBy($select, $table, $join_table, $join_condition, $where, $group_by)
	    {
	        $this-&gt;CI-&gt;db-&gt;select($select);
            $this-&gt;CI-&gt;db-&gt;from($table);
            
            if($join_table &amp;&amp; $join_condition)
            {
                $this-&gt;CI-&gt;db-&gt;join($join_table, $join_condition);
            }
            
            $where2 = substr($where,6);
            $this-&gt;CI-&gt;db-&gt;where($where2);
            
            $group_by2 = substr($group_by,8);
            $this-&gt;CI-&gt;db-&gt;group_by($group_by2);

            $query = $this-&gt;CI-&gt;db-&gt;get();
            $result = $query-&gt;row_array();
        
           
	        
	    }
  
  
  $total_direct_all_child1 = $this-&gt;getAllRecJoinTblGroupBy(
        			&quot;u.user_id, u.username, u.unique_code, u.user_email, p.id, p.status&quot;,
        			
        			&quot;tbl_user_master u&quot;,
        			
        			&quot;tbl_product_order p&quot;,
        			
        			&quot;p.user_id = u.user_id&quot;,
        			
        			&quot;WHERE 
        			u.sponsor_id = &#39;&quot;.$total_direct_child[&#39;user_id&#39;].&quot;&#39;
        			AND u.status = 1 
        			AND u.user_type = 2 
        			AND p.status = 3&quot;,
        
        			&quot;GROUP_BY u.user_id&quot;
  );
  
&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;


Must saperate Order_By :&lt;br /&gt;&lt;br /&gt;
&lt;textarea style=&quot;height: 350px; width: 670px;&quot;&gt; 
  function getAllRecOrderBy($select,$table,$where,$order_by=null) // GET ALL RECORDS WITH SELECT STRING
		{	
			$where2 = substr($where,6);
			
			$this-&gt;CI-&gt;db-&gt;select($select);
            $this-&gt;CI-&gt;db-&gt;from($table);
            $this-&gt;CI-&gt;db-&gt;where($where2);
            $this-&gt;CI-&gt;db-&gt;order_by($order_by);
        
            $query = $this-&gt;CI-&gt;db-&gt;get();
            $result = $query-&gt;row_array();
		}
  
  $member = $this-&gt;common-&gt;getAllRecOrderBy(
			    &quot;user_id,username,first_name, last_name, rank&quot;, 
			    &quot;tbl_user_master&quot;,
			    &quot;WHERE status != 3 AND user_type = 2&quot;, 
			    &quot;first_name&quot;, &quot;ASC&quot;,	
			    &quot;last_name&quot;, &quot;ASC&quot;
  );
  
  
&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;


Php pdo :

&lt;textarea style=&quot;height: 440px; width: 670px;&quot;&gt; 
//Problem Code:
    $sql = &#39;SELECT 
	        payment_date, 
	        SUM(price),
	        SUM(profit) 
	        FROM sale 
	        WHERE seller_id = ? &amp;&amp; Year(payment_date) = ?
	        GROUP BY Month(payment_date) DESC&#39;;
    $q = $conn-&gt;prepare($sql);
	$result = $q-&gt;execute(array($user_id, $selected_year));

//Solution Code: 
	$sql = &#39;SELECT 
	        payment_date, 
	        SUM(price) AS price_total,
	        SUM(profit) AS profit_total 
	        FROM sale 
	        WHERE seller_id = :spender_id &amp;&amp; Year(payment_date) = :payMYear 
	        GROUP BY Month(payment_date) 
	        ORDER BY payment_date DESC&#39;;
	$stmt = $conn-&gt;prepare($sql);
	$stmt-&gt;bindParam(&#39;:spender_id&#39;, $user_id, PDO::PARAM_INT); 
	$stmt-&gt;bindParam(&#39;:payMYear&#39;, $selected_year);
	$stmt-&gt;execute();
&lt;/textarea&gt;&lt;br /&gt;

select and display data from database :&lt;/br&gt;
important at :&lt;/br&gt;
1) try &lt;/br&gt;
2) {$row[&#39;id&#39;]}&lt;/br&gt;
&lt;textarea style=&quot;height: 540px; width: 670px;&quot;&gt; 
try 
{
    $dbhost = &quot;localhost&quot;;
    $dbusername = &quot;aekcom_zac1987&quot;;
    $dbpassword = &quot;h~m_*MqTH*pD&quot;;
    $dbname = &quot;aekcom_idea4better&quot;;
    
    $pdo = new PDO(&quot;mysql:host=$dbhost;charset=utf8mb4;dbname=$dbname&quot;, $dbusername, $dbpassword);
    $pdo-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    
    $sql = &quot;SELECT * FROM ckeditorSummernote&quot;;
    $stmt = $pdo-&gt;prepare($sql);
    
    $stmt-&gt;execute();
    $result = $stmt-&gt;fetchAll(PDO::FETCH_ASSOC);

    foreach ($result as $row) 
    {
        echo &quot;&lt;tr&gt;&quot;;
        echo &quot;&lt;td&gt;{$row[&#39;id&#39;]}&lt;/td&gt;&quot;;
        echo &quot;&lt;td&gt;{$row[&#39;title&#39;]}&lt;/td&gt;&quot;;
        echo &quot;&lt;td&gt;{$row[&#39;content&#39;]}&lt;/td&gt;&quot;;
        echo &quot;&lt;/tr&gt;&quot;;
    }
    
} catch (PDOException $e) {
    echo &quot;Error: &quot; . $e-&gt;getMessage();
}

$pdo = null;
&lt;/textarea&gt;&lt;br /&gt;

Join 2 tables + Group_by + Order_by :&lt;br /&gt;&lt;br /&gt;
&lt;textarea style=&quot;height:550px; width: 670px;&quot;&gt; 

function getSelectedOneFieldJoin2TblGroupOrder($select, $table, $where, $join_table1, $join_condition1, $join_table2, $join_condition2, $order_by=null, $group_by=null)
{
    $this-&gt;CI-&gt;db-&gt;select($select);
    $this-&gt;CI-&gt;db-&gt;from($table);
    
    $where2 = substr($where,6);
    $this-&gt;CI-&gt;db-&gt;where($where2);
    
    if($join_table1 &amp;&amp; $join_condition1)
    {
        $this-&gt;CI-&gt;db-&gt;join($join_table1, $join_condition1, &#39;left&#39;);
    }
    
    if($join_table2 &amp;&amp; $join_condition2)
    {
        $this-&gt;CI-&gt;db-&gt;join($join_table2, $join_condition2, &#39;left&#39;);
    }
    
    $this-&gt;CI-&gt;db-&gt;order_by($order_by);
    
    $group_by2 = substr($group_by,8);
    $this-&gt;CI-&gt;db-&gt;group_by($group_by2);

    $query = $this-&gt;CI-&gt;db-&gt;get();
    $result = $query-&gt;result_array();

    if ($result) {
        return $result;
    }
    
    return null; // Return an appropriate value if no result is found
}
  
&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;


If sql got error then check this two things :&lt;br /&gt;&lt;br /&gt;
&lt;textarea style=&quot;height: 150px; width: 670px;&quot;&gt; 
$query = $this-&gt;CI-&gt;db-&gt;get();
$result = $query-&gt;result_array();
  
  
$query-&gt;result_array(); //get many rows of records so use foreach loop.
  
$query-&gt;row_array(); //get only 1 record.
&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;


Limit : (Must delete limit if no use limit, otherwise no result will show) &lt;br /&gt;&lt;br /&gt;
&lt;textarea style=&quot;height: 450px; width: 670px;&quot;&gt; 
function getAllRec2($select, $table, $where, $order_by=null, $limit=null)
{                    
    $this-&gt;CI-&gt;db-&gt;select($select);
    $this-&gt;CI-&gt;db-&gt;from($table);
    
    $where2 = substr($where,6);
    $this-&gt;CI-&gt;db-&gt;where($where2);
    
    $this-&gt;CI-&gt;db-&gt;order_by($order_by);
    
    $limit2 = substr($limit,6);
    $this-&gt;CI-&gt;db-&gt;limit($limit2);
    
    $query = $this-&gt;CI-&gt;db-&gt;get();
    return $query-&gt;result_array();
}
	
$res_data[]=$res2=$this-&gt;common-&gt;getAllRec2(
&quot; &#39;New Member Registered&#39; as activity_title, u.created_on as created_on, concat(u.first_name, &#39; &#39;, u.last_name) as created_by&quot;,
&quot;tbl_user_master u&quot;,
&quot;WHERE u.status != 2 and u.status != 0 &quot;, //and u.created_on &gt;= DATE_ADD(CURDATE(), INTERVAL -3 DAY)
&quot;u.created_on&quot;, &quot;ASC&quot;,
&quot;Limit 5&quot;
);
&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;


php variable in WHERE clause :&lt;br /&gt;&lt;br /&gt;
&lt;textarea style=&quot;height: 50px; width: 670px;&quot;&gt; 
&quot;WHERE u.user_type = 2 AND u.status != 3 /&#39;{$where}/&#39;&quot;  ,
&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;  


wordpress error :&lt;br /&gt;&lt;br /&gt;
&lt;textarea style=&quot;height: 150px; width: 670px;&quot;&gt; 
Severity: error --&gt; Exception: Call to undefined function curl_init()
  
I think your hosting comment out curl on php.ini
Where can i edit php.ini file?
  
I want to remove the ; mark from the beginning of the following line:
;extension=php_curl.dll
  &lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;&lt;br /&gt;  </content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/7247857976846243992/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/7247857976846243992' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/7247857976846243992'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/7247857976846243992'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2023/08/sql-and-pdo-give-error-when-upgraded-to.html' title='Sql and pdo give error when upgraded to mysql new version 8.0.34'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-7445269285011722398</id><published>2023-06-04T07:35:00.004+08:00</published><updated>2023-06-04T07:58:22.348+08:00</updated><title type='text'>150% Profit EA</title><content type='html'>&lt;h1 style=&quot;color:cyan;&quot;&gt;150% Profit EA&lt;/h1&gt;  



&lt;img src=&quot;https://toto180.com/images/150profit-ea-myfxbook1.jpg&quot; style=&quot;border:solid blue 3px;  width:650px; margin-left:10px;&quot;&gt;&lt;br/&gt;&lt;br/&gt;

&lt;img src=&quot;https://toto180.com/images/150profit-ea-myfxbook2.jpg&quot; style=&quot;border:solid blue 3px; margin-left:10px;&quot;&gt;&lt;br/&gt;&lt;br/&gt;

Do you want to earn &lt;span class=&quot;bigtext&quot;&gt;10% to 40% profit&lt;/span&gt; monthly from this EA robot?&lt;br/&gt;&lt;br/&gt;

USD100 real money (USD10000 Cent account) to trade 1 pair : XAUUSD&lt;br/&gt;
        
        15minutes TF.&lt;br/&gt;&lt;br/&gt;
        
        Download and lot the setting file as picture below :&lt;br/&gt;
        
        &lt;img src=&quot;https://toto180.com/images/150profit-ea-settings.jpg&quot; style=&quot;border:solid blue 3px;  width:95%; margin-left:10px;&quot;&gt;&lt;br/&gt;&lt;br/&gt;
        
        This 150% Profit EA only works perfectly on Roboforex broker :&lt;br/&gt;
        &lt;a target=&quot;_blank&quot; href=&quot;https://my.roboforex.com/en/?a=pbxk&quot;&gt;https://my.roboforex.com/en/?a=pbxk&lt;/a&gt;&lt;br/&gt;&lt;br/&gt;
        
        My Roboforex Referral Code ➜  pbxk&lt;br/&gt;&lt;br/&gt;
        
        You will get &lt;b&gt;&lt;span style=&quot;color:cyan;&quot;&gt;100% bonus&lt;/span&gt;&lt;/b&gt; if register through &lt;b&gt;&lt;span style=&quot;color:cyan;&quot;&gt;my affiliate link&lt;/span&gt;&lt;/b&gt;.&lt;br/&gt;
        For example, you deposit usd50, &lt;b&gt;&lt;span style=&quot;color:cyan;&quot;&gt;you get usd50 bonus&lt;/span&gt;&lt;/b&gt;. So total you get USD100 in your MT4 account.&lt;br/&gt;&lt;br/&gt;

&lt;a href=&#39;https://toto180.com/150profitEA.php&#39;&gt;Download 150% Profit EA File&lt;br&gt; &lt;img style=&quot;margin-left:10px;&quot; src=&quot;https://toto180.com/download-button-red.png&quot;&gt;&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/7445269285011722398/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/7445269285011722398' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/7445269285011722398'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/7445269285011722398'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2023/06/150-profit-ea.html' title='150% Profit EA'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-2893696149627734525</id><published>2022-01-21T06:45:00.008+08:00</published><updated>2022-01-22T08:04:00.274+08:00</updated><title type='text'>Backtest EA on news filter.</title><content type='html'>Now you will need to download the news csv file from https://www.fxstreet.com/economic-calendar (max 3 months, then combine all).
&lt;br /&gt;&lt;br /&gt;

After the newslist is downloaded, you will need to edit the list. I am using EmEditor for that.&lt;br /&gt;
Open your csv file in EmEditor (Ctrl-O)&lt;br /&gt;&lt;br /&gt;

File open in editor:&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEg29mCCJmw3PZrFy27QuBBjQA3tWrXEf6J9fcUbkzOIhtqKhiQWioz6CValdDx2GdBUVEnEkAFTcjTKM39O2xjGc9BWzUTAdGuZZhB-QZFITHVJxQeatJfKYR79yZNdJq7pRuCfArVXOADUy2jbOT5X-q2dlSmoV92-F6V_IyWcSj-Tp3XbzWO2j7CsDw=s1425&quot; style=&quot;display: block; padding: 1em 0px; text-align: center;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;727&quot; data-original-width=&quot;1425&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEg29mCCJmw3PZrFy27QuBBjQA3tWrXEf6J9fcUbkzOIhtqKhiQWioz6CValdDx2GdBUVEnEkAFTcjTKM39O2xjGc9BWzUTAdGuZZhB-QZFITHVJxQeatJfKYR79yZNdJq7pRuCfArVXOADUy2jbOT5X-q2dlSmoV92-F6V_IyWcSj-Tp3XbzWO2j7CsDw=s670&quot; width=&quot;670&quot; /&gt;&lt;/a&gt;&lt;/div&gt;

First thing to do is to delete the first column, right click on the top of the first column and select delete column
&lt;br /&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEi5frRzbtwge4Gi8Y_PuLVMga4CRXA5KD54E_pMKd7QIK0evoU55UdmUGkYYrks5p9fWNzuZQc9IvArEV2aE81MLQP8u_UQ7Se9OLrPgCagkNvV1eC9QjWVoCMZXHYtBuT0VyWrfvC7G03bR36HgYlm0UMH-arzycNyi_pnArhXCBKfU-jxVK5WynfRbg=s686&quot; style=&quot;display: block; padding: 1em 0px; text-align: center;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;615&quot; data-original-width=&quot;686&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEi5frRzbtwge4Gi8Y_PuLVMga4CRXA5KD54E_pMKd7QIK0evoU55UdmUGkYYrks5p9fWNzuZQc9IvArEV2aE81MLQP8u_UQ7Se9OLrPgCagkNvV1eC9QjWVoCMZXHYtBuT0VyWrfvC7G03bR36HgYlm0UMH-arzycNyi_pnArhXCBKfU-jxVK5WynfRbg=s670&quot; width=&quot;670&quot; /&gt;&lt;/a&gt;&lt;/div&gt;

Column deleted:&lt;br /&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEj_m3X_2T1Lgi5G791FqI_tR7EkM5c53fnm6gug3KzLEfde9B4h-Pb3YwCKuoLvUukS4papstEEbwqCSPKpfsnA1J-qbRarHmDxI1rMdyHkgczjvKhChhrulpSu0u9kHekt34XQPVjCGBGhEU-T2uAkLA7WMM2V00qKSiouxumG_QTyxZuv_qba21RSfg=s648&quot; style=&quot;display: block; padding: 1em 0px; text-align: center;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;473&quot; data-original-width=&quot;670&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEj_m3X_2T1Lgi5G791FqI_tR7EkM5c53fnm6gug3KzLEfde9B4h-Pb3YwCKuoLvUukS4papstEEbwqCSPKpfsnA1J-qbRarHmDxI1rMdyHkgczjvKhChhrulpSu0u9kHekt34XQPVjCGBGhEU-T2uAkLA7WMM2V00qKSiouxumG_QTyxZuv_qba21RSfg=s670&quot; width=&quot;670&quot; /&gt;&lt;/a&gt;&lt;/div&gt;

Now we need to split the date and time column, rightclick on the Date time column and select &quot;Split column&quot;&lt;br /&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEgjP6ZUaT4ivjS2fTOkgZDzGbsLvNBqjC9pkLFOi1dZn41TCgm85q2MgbZQOXufEjfok3uK8u9unAzRaxQMQu9gASxaeDdIgLqw6oX2hIQELy9j0zAwj3nE52RW5eLPunkerKtJntO8V90A-HBmLCJbZVIrewHq7vju0YXKLryNG-R0PH4I0KLVIHc04Q=s596&quot; style=&quot;display: block; padding: 1em 0px; text-align: center;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;596&quot; data-original-width=&quot;522&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEgjP6ZUaT4ivjS2fTOkgZDzGbsLvNBqjC9pkLFOi1dZn41TCgm85q2MgbZQOXufEjfok3uK8u9unAzRaxQMQu9gASxaeDdIgLqw6oX2hIQELy9j0zAwj3nE52RW5eLPunkerKtJntO8V90A-HBmLCJbZVIrewHq7vju0YXKLryNG-R0PH4I0KLVIHc04Q=s670&quot; width=&quot;670&quot; /&gt;&lt;/a&gt;&lt;/div&gt;

In the Split column window, make one space(spacrebar) in Seperator entry and click Ok button&lt;br /&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEhgKwyUZS7gtKU42YEPtj9BBOYHTC505F6uikb5GcQyjkg8bvWK_I2eFUxaHvaHkcBL6id5R9SOLcci07Wm5e4Jd4bJecvS8-IrQDhSN5h36yOeB7-6NbZBQDp2YhmENrrYpRhYO131frVLWnCB7Dmb_PbwHnYhdNAAq7k5Lg53-9Dez9fZWqqT-6rjbQ=s524&quot; style=&quot;display: block; padding: 1em 0px; text-align: center;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;425&quot; data-original-width=&quot;524&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEhgKwyUZS7gtKU42YEPtj9BBOYHTC505F6uikb5GcQyjkg8bvWK_I2eFUxaHvaHkcBL6id5R9SOLcci07Wm5e4Jd4bJecvS8-IrQDhSN5h36yOeB7-6NbZBQDp2YhmENrrYpRhYO131frVLWnCB7Dmb_PbwHnYhdNAAq7k5Lg53-9Dez9fZWqqT-6rjbQ=s670&quot; width=&quot;670&quot; /&gt;&lt;/a&gt;&lt;/div&gt;

The Date and Time(hours) is now splitted into 2 columns&lt;br /&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEjgZfL76ZOCHsU-GLgZom25lt7EIdv8r1a0TBsjPTB-l70KqMjIihmGl12YiLHhZh3ayncLhRW_EYruEkz_LuS0UoSYc280Ptf9MMP7sWlP0TTMFflT7neGILX-VOJkAHOdfSxvhvKYE-nMN-F_shJ-Jg2ifVoNXI8pCSKtQXhZXKLG8NFZMLU8jCKiRA=s651&quot; style=&quot;display: block; padding: 1em 0px; text-align: center;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;460&quot; data-original-width=&quot;651&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEjgZfL76ZOCHsU-GLgZom25lt7EIdv8r1a0TBsjPTB-l70KqMjIihmGl12YiLHhZh3ayncLhRW_EYruEkz_LuS0UoSYc280Ptf9MMP7sWlP0TTMFflT7neGILX-VOJkAHOdfSxvhvKYE-nMN-F_shJ-Jg2ifVoNXI8pCSKtQXhZXKLG8NFZMLU8jCKiRA=s670&quot; width=&quot;670&quot; /&gt;&lt;/a&gt;&lt;/div&gt;

Next step is to convert the Date format so MT4 can use it, open replace window (Ctrl-H)&lt;br /&gt;&lt;br /&gt;

In the &quot;Find&quot; you write exactly this string: ([0-9]{1,2})/([0-9]{1,2})/([0-9]{2,4})&lt;br /&gt;&lt;br /&gt;

In the &quot;Replace with&quot; you enter exactly this string: \3.\1.\2&lt;br /&gt;&lt;br /&gt;

Choose regular Expressions and click on &quot;replace all&quot; button.&lt;br /&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEiy6-OtoxSj_GoLHxEx88q2bbBdIbatn-i-uXeR0CY2dD3sCzpH-LWc8jOm68le8-4X_rK7NuRnEL7cFkSnQwr5OGkqwIOWSw13eZ51ABf7B3FBqNbhV0hzom-QiLJWDGYWshdYZqhxs4yovSja1b-6XzgFFkN5ceMOZUg8i1HgqExhuH6TAysPJIHzUQ=s496&quot; style=&quot;display: block; padding: 1em 0px; text-align: center;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;320&quot; data-original-width=&quot;496&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEiy6-OtoxSj_GoLHxEx88q2bbBdIbatn-i-uXeR0CY2dD3sCzpH-LWc8jOm68le8-4X_rK7NuRnEL7cFkSnQwr5OGkqwIOWSw13eZ51ABf7B3FBqNbhV0hzom-QiLJWDGYWshdYZqhxs4yovSja1b-6XzgFFkN5ceMOZUg8i1HgqExhuH6TAysPJIHzUQ=s670&quot; width=&quot;670&quot; /&gt;&lt;/a&gt;&lt;/div&gt;


The list now looks like this:&lt;br /&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEh6GXDGlXx-CQgsBLOXId0Q8gxY5nvq762w-_VU-DxtQ-4DOznXe9vSPxBuVpNOkHWKBnGgW66ATfMrF7eIBIt4EK5OY3c5vMjtpfHvGbVeOS6h8GYu4_2bc1f_BuocunucsQV6uQgfnCkYdwYs3okiX_rMDmdaDqlzLYZ7AEjGgY5vLKlSZaIFP-QqCA=s645&quot; style=&quot;display: block; padding: 1em 0px; text-align: center;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;462&quot; data-original-width=&quot;645&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEh6GXDGlXx-CQgsBLOXId0Q8gxY5nvq762w-_VU-DxtQ-4DOznXe9vSPxBuVpNOkHWKBnGgW66ATfMrF7eIBIt4EK5OY3c5vMjtpfHvGbVeOS6h8GYu4_2bc1f_BuocunucsQV6uQgfnCkYdwYs3okiX_rMDmdaDqlzLYZ7AEjGgY5vLKlSZaIFP-QqCA=s670&quot; width=&quot;670&quot; /&gt;&lt;/a&gt;&lt;/div&gt;

Now select all columns in the first row, then rightclick and select &quot;Delete&quot; from the dropdown menu.&lt;br /&gt;


&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEj39HdkLIqLfsdfRPNkfFsrxRHX1XW7JojAke8i9P174uhB9Aq3wKpZLk58rWDHKBSnzSsNqUbbGHKk4v1nHaPhOUTjrNPnFe49tz-zkPU_csBCRrhgnMqVg7PGy1KBbgZdcNlr2nDU1qWKbmrGHbzklfjClzmC8sWdR-YL_8MNECzpVFta6v7yJ6A9WQ=s538&quot; style=&quot;display: block; padding: 1em 0px; text-align: center;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;525&quot; data-original-width=&quot;538&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEj39HdkLIqLfsdfRPNkfFsrxRHX1XW7JojAke8i9P174uhB9Aq3wKpZLk58rWDHKBSnzSsNqUbbGHKk4v1nHaPhOUTjrNPnFe49tz-zkPU_csBCRrhgnMqVg7PGy1KBbgZdcNlr2nDU1qWKbmrGHbzklfjClzmC8sWdR-YL_8MNECzpVFta6v7yJ6A9WQ=s670&quot; width=&quot;670&quot; /&gt;&lt;/a&gt;&lt;/div&gt;


Ok! :) The list is now finnished, you can now save it.&lt;br /&gt;


&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEgCpZDg08SYP-E0QvisJwUqY7rLr2ruwJq0NbVq4yD6TEkEMdvmVhtgyjfwZGTYRBsSfQQr4Pj9o6lmHkZ6UsZbW9iwJE-N8eDO4GuSJ3DvN7Yo54wOndkA3KEiswfK3mYi9P-ratTla-I_ugwfiOpp5YUtDfVk2HZUvbj-hIw9yuj8Yy0cFzITpaTj9Q=s657&quot; style=&quot;display: block; padding: 1em 0px; text-align: center;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;506&quot; data-original-width=&quot;657&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEgCpZDg08SYP-E0QvisJwUqY7rLr2ruwJq0NbVq4yD6TEkEMdvmVhtgyjfwZGTYRBsSfQQr4Pj9o6lmHkZ6UsZbW9iwJE-N8eDO4GuSJ3DvN7Yo54wOndkA3KEiswfK3mYi9P-ratTla-I_ugwfiOpp5YUtDfVk2HZUvbj-hIw9yuj8Yy0cFzITpaTj9Q=s670&quot; width=&quot;670&quot; /&gt;&lt;/a&gt;&lt;/div&gt;

You need to put the list(csv file) in your terminal ./tester/files/ folder&lt;br /&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEhqQH1eQO7G3JRvhfhwUIkJeKKJ2dfhSwMVkLfTbVF-ukl0ouUZu7mQvSYIhAP65yI6J3GtrzuCzE9R0DASW0uFgOddOQrDGal0sdk2wlHZFGI4VedwQ3GSC1W06cRp08XyItLLiAWC4TweKQMxMHFTcIeJaJOP6N6ZG8wGXw-vWpmf-4nA6gmGWfzPEg=s844&quot; style=&quot;display: block; padding: 1em 0px; text-align: center;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;197&quot; data-original-width=&quot;844&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEhqQH1eQO7G3JRvhfhwUIkJeKKJ2dfhSwMVkLfTbVF-ukl0ouUZu7mQvSYIhAP65yI6J3GtrzuCzE9R0DASW0uFgOddOQrDGal0sdk2wlHZFGI4VedwQ3GSC1W06cRp08XyItLLiAWC4TweKQMxMHFTcIeJaJOP6N6ZG8wGXw-vWpmf-4nA6gmGWfzPEg=s670&quot; width=&quot;670&quot; /&gt;&lt;/a&gt;&lt;/div&gt;


In MT4 backtesting Expert properties remember to write in the file name for the file you just putted in the tester/files folder.&lt;br /&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEj3k6SEiVIAGASxqQq1o-xNbo4aemv_LfHZ8wkZ5A3H7fwX284lBOdzrCku6w5a-efAuRDXPVeBu8DL6twDLhKBfbRuVqbgRUe2gUumiX_C6nK8ac9A8X7wFNHRLRDCg13hIbHkLZj_YcVZiWLaFYLD0djnL0eAfGhAdHQppNw72KwqQVKyEtPmwWDZNg=s1070&quot; style=&quot;display: block; padding: 1em 0px; text-align: center;&quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; data-original-height=&quot;729&quot; data-original-width=&quot;1070&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEj3k6SEiVIAGASxqQq1o-xNbo4aemv_LfHZ8wkZ5A3H7fwX284lBOdzrCku6w5a-efAuRDXPVeBu8DL6twDLhKBfbRuVqbgRUe2gUumiX_C6nK8ac9A8X7wFNHRLRDCg13hIbHkLZj_YcVZiWLaFYLD0djnL0eAfGhAdHQppNw72KwqQVKyEtPmwWDZNg=s670&quot; width=&quot;670&quot; /&gt;&lt;/a&gt;&lt;/div&gt;

Then open Sublime ctrl + H to replace , to ;&lt;br /&gt;&lt;br /&gt;

-------------------------&lt;br /&gt;&lt;br /&gt;

insert this to weburl at option : https://nfs.faireconomy.media/ff_calendar_thisweek.xml
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEi2ATRuD-IGyAeKnD52eRm1qfO6nXHlurEa4C8f0OZZhLZhT2kNOwe9wruHqFQH7fsCFD7v14F-p8lIScg-IMYovBPO13tLMDtADUZdlqFOIVOrT_4Fv0xVhuGCR8IGqE4FeeqCUzjCgSNMsQiSaDmBGsBQt5On0OQHCsjSpjpu3SF_JaF68BrJFZTsiA=s618&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;670&quot; data-original-height=&quot;448&quot; data-original-width=&quot;618&quot; src=&quot;https://blogger.googleusercontent.com/img/a/AVvXsEi2ATRuD-IGyAeKnD52eRm1qfO6nXHlurEa4C8f0OZZhLZhT2kNOwe9wruHqFQH7fsCFD7v14F-p8lIScg-IMYovBPO13tLMDtADUZdlqFOIVOrT_4Fv0xVhuGCR8IGqE4FeeqCUzjCgSNMsQiSaDmBGsBQt5On0OQHCsjSpjpu3SF_JaF68BrJFZTsiA=s670&quot;/&gt;&lt;/a&gt;&lt;/div&gt;





















</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/2893696149627734525/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/2893696149627734525' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/2893696149627734525'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/2893696149627734525'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2022/01/backtest-ea-on-news-filter.html' title='Backtest EA on news filter.'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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/a/AVvXsEg29mCCJmw3PZrFy27QuBBjQA3tWrXEf6J9fcUbkzOIhtqKhiQWioz6CValdDx2GdBUVEnEkAFTcjTKM39O2xjGc9BWzUTAdGuZZhB-QZFITHVJxQeatJfKYR79yZNdJq7pRuCfArVXOADUy2jbOT5X-q2dlSmoV92-F6V_IyWcSj-Tp3XbzWO2j7CsDw=s72-c" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5619550813183664888.post-5395334171166850135</id><published>2021-11-15T05:42:00.011+08:00</published><updated>2021-11-15T05:49:03.768+08:00</updated><title type='text'>Forex Support And Resistance EA  for free download</title><content type='html'>Support And Resistance EA &lt;br/&gt;&lt;br/&gt;

You may use the Support and Resistance Indicator without EA to ease your trading.
&lt;br/&gt;&lt;br/&gt;
Support Resistance has 4 types :&lt;br/&gt;
1) Weak.&lt;br/&gt;
2) untested.&lt;br/&gt;
3) Verified.&lt;br/&gt;
4) Proven.&lt;br/&gt;&lt;br/&gt;

This EA open trade at untested Support and Resistant.&lt;br/&gt;
this EA won&#39;t open trade on Weak, Verified, Proven SR.&lt;br/&gt;&lt;br/&gt;

You may ask me customize this EA to fit your trading style. &lt;br/&gt;&lt;br/&gt;

Download Ea file and indicators files link at :&lt;br/&gt;
&lt;a href=&quot;https://www.shorturl.at/etyC1&quot;&gt;https://www.shorturl.at/etyC1&lt;/a&gt;
&lt;br/&gt;
------------------------------------------&lt;br/&gt;
Installation setup instruction steps video at :&lt;br/&gt;
&lt;a href=&quot;https://www.youtube.com/watch?v=mg-BehDDRBk&quot;&gt;https://www.youtube.com/watch?v=mg-BehDDRBk&lt;/a&gt; 
&lt;br/&gt;
------------------------------------------&lt;br/&gt;
</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/5395334171166850135/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/5395334171166850135' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/5395334171166850135'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/5395334171166850135'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2021/11/forex-support-and-resistance-ea-for.html' title='Forex Support And Resistance EA  for free download'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-5363614015940611</id><published>2021-10-21T02:22:00.013+08:00</published><updated>2022-04-06T05:58:07.686+08:00</updated><title type='text'>mql4 tutorial</title><content type='html'>Check active order previous buy entry price is far enough from current entry then only open a new buy order :
&lt;textarea style=&quot;height: 1100px; width: 670px;&quot;&gt; 
if((Close[1] &gt; D45RecentBarHighest1 &amp;&amp; Close[2] &gt; D45RecentBarHighest2) || (Close[1] &gt; D45RecentBarHighest1 &amp;&amp; Close[3] &gt; D45RecentBarHighest3))
{
   if(Bars != ThisBarTrade)
   {
      int orderopen3 = 0;
      for (int z=OrdersTotal(); z&gt;=0; z--)
      {
      
         if ( OrderSelect(z, SELECT_BY_POS,MODE_TRADES) // Only my orders w/
              &amp;&amp;  OrderSymbol()      == Symbol() 
              &amp;&amp; OrderType()==OP_SELL
          ){
               if ((Bid &gt; OrderOpenPrice() &amp;&amp; (Bid - OrderOpenPrice())/_Point &lt; 410) || (Bid &lt; OrderOpenPrice() &amp;&amp; (OrderOpenPrice() - Bid)/_Point &lt; 410) || Bid == OrderOpenPrice())
               {
                  orderopen3 = 1;
               }
          }
      }
      if (orderopen3 == 0)
      {  
         if(Bid &gt; cantSellLevel)
         {
            TP_TMP = (0); 
            if(OrderSend(_Symbol,OP_SELL , NormalizeDouble( sellLot  ,2 ) ,Bid,3, SL_TMP, TP_TMP ,MagicNumber ,MagicNumber,0,Red)){}
            ThisBarTrade = Bars;
            sellLot = sellLot * 1.7;
         }
      }
   }
}
  
  

  
if((Close[1] &lt; D45RecentBarLowest1 &amp;&amp; Close[2] &lt; D45RecentBarLowest2) || (Close[1] &lt; D45RecentBarLowest1 &amp;&amp; Close[3] &lt; D45RecentBarLowest3))
{   
   if(Bars != ThisBarTrade)
   {
      int orderopen2 = 0;
      for (int b=OrdersTotal(); b&gt;=0; b--)
      {
         if ( OrderSelect(b, SELECT_BY_POS,MODE_TRADES) // Only my orders w/
              &amp;&amp;  OrderSymbol()      == Symbol() 
              &amp;&amp; OrderType()==OP_BUY
         ){
               if ((Ask &gt; OrderOpenPrice() &amp;&amp; (Ask - OrderOpenPrice())/_Point &lt; 410) || (Close[1] &lt; OrderOpenPrice() &amp;&amp; (OrderOpenPrice() - Ask)/_Point &lt; 410) || (Ask == OrderOpenPrice()))
               {
                  orderopen2 = 1;
               }
         }
      }
      if (orderopen2 == 0)
      {  
         if(Ask &lt; cantBuyLevel)
         {
            TP_TMP = (0); 
            if(OrderSend(_Symbol,OP_BUY , NormalizeDouble( buyLot ,2 ) ,Ask,3, SL_TMP, TP_TMP ,MagicNumber ,MagicNumber,0,DeepSkyBlue)){}
            ThisBarTrade = Bars; 
            buyLot = buyLot * 1.7;
         }
      }
   }
}  
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;   

  
To get highest price datetime :
&lt;textarea style=&quot;height: 150px; width: 670px;&quot;&gt; 
  double HighPrice = iHigh(Symbol(),0,iHighest(NULL,0,MODE_HIGH,1900,2));
  double LowPrice = iLow(Symbol(),0,iLowest(NULL,0,MODE_LOW,1900,2));

  int forHighTime   = iHighest( NULL,0,MODE_HIGH,1900);  
  int forLowTime   = iLowest( NULL,0,MODE_LOW,1900); 
  datetime highestDateTime = iTime(_Symbol,_Period, forHighTime);
  datetime lowestDateTime = iTime(_Symbol,_Period, forLowTime);
&lt;/textarea&gt;&lt;br /&gt;
----------------------------------
&lt;br /&gt;   
  
To put TP on Order :
&lt;textarea style=&quot;height: 50px; width: 670px;&quot;&gt; 
    
&lt;/textarea&gt;&lt;br /&gt;
----------------------------------
&lt;br /&gt; 
  
Modify TP :
&lt;textarea style=&quot;height: 900px; width: 670px;&quot;&gt;   
void Modify_TP()
  {
 
   total=OrdersTotal();
   for(cnt = total-1; cnt &gt;= 0; cnt--)
   {

     if(OrderSelect(cnt, SELECT_BY_POS, MODE_TRADES)){}
     if( OrderSymbol() == _Symbol ) 
     {
         if( OrderType() == OP_BUY )
          {
              if( 
                   ( (( OrderOpenPrice() - Ask )/_Point) &gt;= 300  ) 
                &amp;&amp; ( (( OrderOpenPrice() - Ask )/_Point) &lt;  350 ) 
                )
                {
                  TP_TMP = NormalizeDouble(( OrderOpenPrice() + 500*_Point ),5 );
                  if( OrderTakeProfit() != TP_TMP ) 
                    {
                      if(OrderModify(OrderTicket(),OrderOpenPrice(), OrderStopLoss() , TP_TMP ,0,White)){}
                      if(OrderSelect(OrdersTotal()-1,SELECT_BY_POS)){};
                      double last_price = OrderLots();
                      if(OrderSend(_Symbol,OP_SELLLIMIT , NormalizeDouble( last_price ,2 ) ,TP_TMP,3, 0, 0 ,&quot;tinyurl.com/ea5678&quot; ,0,0,Red)){}
                    }
                }    
           } // if( OrderType() == OP_BUY )

         if( OrderType() == OP_SELL )
           {
           
              if( 
                    ( (( Bid - OrderOpenPrice() )/_Point) &gt;= 300  ) 
                 &amp;&amp; ( (( Bid - OrderOpenPrice() )/_Point) &lt;  350 )  
                 )
                {
                  TP_TMP = NormalizeDouble(( OrderOpenPrice() - 500*_Point ),5 );
                  if( OrderTakeProfit() != TP_TMP ) 
                    {
                       if(OrderModify(OrderTicket(),OrderOpenPrice(), OrderStopLoss() , TP_TMP ,0,White)){}
                       if(OrderSelect(OrdersTotal()-1,SELECT_BY_POS)){};
                       double last_price2 = OrderLots();
                       if(OrderSend(_Symbol,OP_BUYLIMIT , NormalizeDouble( last_price2 ,2 ) ,TP_TMP,3, 0, 0 ,&quot;tinyurl.com/ea5678&quot; ,0,0,DeepSkyBlue)){}
                    }
                }
           } // if( OrderType() == OP_SELL ) 

      }
    }
   
 }
                                                               
// Then you call the function Modify_TP();
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;   
  
Open a buy limit sell limit order:
&lt;textarea style=&quot;height: 120px; width: 670px;&quot;&gt;     

  if(OrderSend(_Symbol,OP_BUYLIMIT , NormalizeDouble( buyLot ,2 ) ,D45RecentBarHighest8,3, SL_TMP,TP_TMP,&quot;tinyurl.com/swfrx&quot; ,0,0,DeepSkyBlue)){}
  
  if(OrderSend(_Symbol,OP_SELLLIMIT , NormalizeDouble( sellLot ,2 ) ,D45RecentBarHighest8,3, SL_TMP,TP_TMP ,&quot;sweetgirlforex&quot; ,0,0,Red)){}
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;     
  
Do something only if order is opened successfully?
  
&lt;textarea style=&quot;height: 120px; width: 670px;&quot;&gt;     
int sellCheck1 = OrderSend(_Symbol,OP_SELLLIMIT , NormalizeDouble( sellLot ,2 ), ighest1,3, SL_TMP, TP_TMP, &quot;1&quot; ,0,0,Red)

if(sellCheck1 &gt; 0)
{   
         oldSellEntry = 555;
}
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;     

How to Substract 1 day? How to compare 2 dates?
&lt;textarea style=&quot;height: 120px; width: 670px;&quot;&gt;     
input datetime Date1 = D&#39;00:00&#39;;
if((TimeDay(Date1 - 1 )) == TimeDay(TimeCurrent()) &amp;&amp; (TimeMonth(Date1)) == TimeMonth(TimeCurrent())  &amp;&amp; (TimeYear(Date1)) == TimeYear(TimeCurrent())){
   if(Hour()+5 == 23 &amp;&amp; kam11 == &quot;buy&quot; &amp;&amp; Bars != ThisBarTrade){
      openBuyOrder();
   }
}
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;   
  
Get previous buy and sell order lot size :
&lt;textarea style=&quot;height: 600px; width: 670px;&quot;&gt;     
double last_buy_lot = Start_Lot_Size;
double last_sell_lot = Start_Lot_Size;
datetime last_buy_time;
datetime last_sell_time;
int MagicNumber=1089731; 
for(int i = OrdersTotal()-1; i&gt;=0; i--)
{
   if(OrderSelect(i, SELECT_BY_POS, MODE_TRADES) == true)
   {
      // match the symbol EUR/USD or EUR/CHF, etc
      if ( OrderSelect(i, SELECT_BY_POS,MODE_TRADES)                 // Only my orders w/
           &amp;&amp;  OrderSymbol()      == Symbol() 
           &amp;&amp; OrderType()==OP_BUY
           &amp;&amp; (OrderMagicNumber()==MagicNumber)
      ){
            if (OrderOpenTime() &gt; last_buy_time)
            {
                   last_buy_lot = OrderLots();
                   last_buy_time=OrderOpenTime();
            }
       }
       
      if ( OrderSelect(i, SELECT_BY_POS,MODE_TRADES)                 // Only my orders w/
           &amp;&amp;  OrderSymbol()      == Symbol() 
           &amp;&amp; OrderType()==OP_SELL
           &amp;&amp; (OrderMagicNumber()==MagicNumber)
      ){
            if (OrderOpenTime() &gt; last_sell_time)
            {
                   last_sell_lot = OrderLots();
                   last_sell_time=OrderOpenTime();
            }
       }
   }    
}
&lt;/textarea&gt;&lt;br /&gt;
----------------------------------
&lt;br /&gt; 
  
mql4 check if orderopentime() is today date?
&lt;textarea style=&quot;height: 330px; width: 670px;&quot;&gt;     
if(Total_sell_pos() &gt; 0)
{
   for (int mn=OrdersTotal(); mn&gt;=0; mn--)
   {
         if ( OrderSelect(mn, SELECT_BY_POS,MODE_TRADES) // Only my orders w/
              &amp;&amp; (OrderSymbol()      == Symbol()) &amp;&amp; OrderMagicNumber()==MagicNumber
              &amp;&amp; (OrderType()==OP_SELL)
         ){

         
               if(TimeDayOfWeek(OrderOpenTime() ) != TimeDayOfWeek(TimeCurrent() )) // or TimeDayOfYear
               {
                    CloseBuyOrders2();
                    CloseSellOrders2();
               }
         }  
   }
}
&lt;/textarea&gt;&lt;br /&gt;
----------------------------------
&lt;br /&gt; 
  
  
Check 3 candles start hour of the day :
&lt;textarea style=&quot;height: 1100px; width: 670px;&quot;&gt;     
input int InpTimeStartHour=0;
input int InpTimeStartMinute=0;

string getFirst3Candle()
{
   double barClose;
   double barOpen;
   double barClose2;
   double barOpen2;
   double barClose3;
   double barOpen3;
   int BullCount = 0;
   int BearCount = 0;
   string bearBull=&quot;None&quot;;
   //check if first candle (zero-current) is after 1.00am
   datetime lastCandle=iTime(Symbol(),0,1);
   if(TimeHour(lastCandle)&lt;InpTimeStartHour || 
      (TimeHour(lastCandle)==InpTimeStartHour &amp;&amp; TimeMinute(lastCandle)&lt;InpTimeStartMinute)
     )
   {

   }else{
         //looking for that time candle starting from day start
         datetime todayStart=iTime(Symbol(),PERIOD_D1,0);
         int shift=iBarShift(Symbol(),0,todayStart);
         for(int i=shift;i&gt;0;i--)
         {
            datetime iCandleTime=iTime(Symbol(),0,i);
            if((TimeHour(iCandleTime)==InpTimeStartHour || TimeHour(iCandleTime)==InpTimeStartHour+1) &amp;&amp;
               TimeMinute(iCandleTime)==InpTimeStartMinute)
            {
                barClose=iClose(Symbol(),0,i);
                barOpen=iOpen(Symbol(),0,i);
                barClose2=iClose(Symbol(),0,i+1);
                barOpen2=iOpen(Symbol(),0,i+1);
                barClose3=iClose(Symbol(),0,i+2);
                barOpen3=iOpen(Symbol(),0,i+2);

                if(barClose &gt; barOpen){
                     BullCount = BullCount + 1;
                }else if(barClose &lt; barOpen){
                     BearCount = BearCount + 1;
                }
                
                if(barClose2 &gt; barOpen2){
                     BullCount = BullCount + 1;
                }else if(barClose2 &lt; barOpen2){
                     BearCount = BearCount + 1;
                }
                
                if(barClose2 &gt; barOpen2){
                     BullCount = BullCount + 1;
                }else if(barClose2 &lt; barOpen2){
                     BearCount = BearCount + 1;
                }

                if(BullCount &gt; BearCount){
                     bearBull=&quot;Bull&quot;;
                }else if(BullCount &lt; BearCount){
                     bearBull=&quot;Bear&quot;;
                }else{
                     bearBull=&quot;None&quot;;
                }
                return(bearBull);
            }
         }
         
   }
   return(bearBull);
}
&lt;/textarea&gt;&lt;br /&gt;
----------------------------------
&lt;br /&gt; 
  
 OrderSend Error 130 :&lt;br/&gt;
  
When Ask &gt; buy entry, only can modify SL to above entry, cannot modify TP to nearer entry.&lt;br/&gt;&lt;br/&gt;
  
  ----------------------------
  &lt;br/&gt;&lt;br/&gt;
  
 3x next Bar count only will entry again.&lt;br/&gt;
&amp;&amp; Bars &gt; ThisBarTrade+4  &lt;br/&gt;&lt;br/&gt;
  
  ----------------------------</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/5363614015940611/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/5363614015940611' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/5363614015940611'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/5363614015940611'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2021/10/mql4-tutorial.html' title='mql4 tutorial'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-7117914264096014257</id><published>2021-10-14T05:44:00.000+08:00</published><updated>2021-10-14T05:44:13.333+08:00</updated><title type='text'>Cannot connect Wifi / Wifi is disabled by windows mobility center</title><content type='html'>There are 5 solutions :&lt;br/&gt;
1) Go to Network &amp; Internet Setting &gt; Airplane Mode &gt; Slide on the &quot;WI-FI&quot;. If cannot slide on, then :&lt;br/&gt;&lt;br/&gt;

2) You need to press the &quot;wifi&quot; switch button on keyboard, if there is no wifi button on keyboard, then you need to download software to switch Wifi on. Go to your laptop brand website download Network Connection manager. Example if HP brand, then go download HP Connection Manager. Open it &gt; Preference &gt; Device Power &gt; Check both option as picture below :&lt;br/&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_zNzTYuwKDs2Do6LPatGFyuq6qkWyJygH2iU6m5h3i1dt5Xokii2tkmATRmB2W8s0sWCRqn19Kai7gManJCidgkU5D-IZhnk9IdcdW2a3hBSesroTXU0FcGOxrHVAlfjzJmMVmWezWm9z/s580/image+%252830%2529.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;600&quot; data-original-height=&quot;400&quot; data-original-width=&quot;580&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj_zNzTYuwKDs2Do6LPatGFyuq6qkWyJygH2iU6m5h3i1dt5Xokii2tkmATRmB2W8s0sWCRqn19Kai7gManJCidgkU5D-IZhnk9IdcdW2a3hBSesroTXU0FcGOxrHVAlfjzJmMVmWezWm9z/s600/image+%252830%2529.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;&lt;br/&gt;&lt;br/&gt;

3)After Done Step 2, then restart computer. Then try to do step 1 again, hope success slide on on &quot;WI-FI&quot; for this time. If cannot slide on, then :
&lt;br/&gt;&lt;br/&gt;
4) Window Search and open &quot;Windows Mobilility Center&quot; &gt; swith on WIFI.&lt;br/&gt;&lt;br/&gt;
</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/7117914264096014257/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/7117914264096014257' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/7117914264096014257'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/7117914264096014257'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2021/10/cannot-connect-wifi-wifi-is-disabled-by.html' title='Cannot connect Wifi / Wifi is disabled by windows mobility center'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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/AVvXsEj_zNzTYuwKDs2Do6LPatGFyuq6qkWyJygH2iU6m5h3i1dt5Xokii2tkmATRmB2W8s0sWCRqn19Kai7gManJCidgkU5D-IZhnk9IdcdW2a3hBSesroTXU0FcGOxrHVAlfjzJmMVmWezWm9z/s72-c/image+%252830%2529.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5619550813183664888.post-4098666920035877790</id><published>2021-10-03T01:36:00.003+08:00</published><updated>2021-10-16T18:35:28.858+08:00</updated><title type='text'>The Best Forex EA year 2021</title><content type='html'>&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgdze9uV2H5ZZoVhkPrhuktYMT-yenW8IcRzpBvT02U8QRVGthJQhTe6wrhlGA6u1Pz3U4_CgrmLrQHXOn821z95PgjHFiBTqlEthol_HhMN0_d5_BzR6j8miZwqKdwkYvK27b6Y3HuoXM/s661/600+profit+forex+ea+feature+image.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;670&quot;  data-original-width=&quot;661&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgdze9uV2H5ZZoVhkPrhuktYMT-yenW8IcRzpBvT02U8QRVGthJQhTe6wrhlGA6u1Pz3U4_CgrmLrQHXOn821z95PgjHFiBTqlEthol_HhMN0_d5_BzR6j8miZwqKdwkYvK27b6Y3HuoXM/s670/600+profit+forex+ea+feature+image.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYQZw6WyEWNMyE_rf0MrdMJIHPGxekPXo8wUW5XtynXE07a1-tcT0ufq5I632dnL9Z1F1SRR_TBE3kDGoWR3dPOigtignUXTMWdoXs-4GUELFXfYSnD4XnD0hoNaZ0Q7tqcqZLVBSABnKu/s906/600EA-installtion-step2.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;670&quot;  data-original-width=&quot;906&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiYQZw6WyEWNMyE_rf0MrdMJIHPGxekPXo8wUW5XtynXE07a1-tcT0ufq5I632dnL9Z1F1SRR_TBE3kDGoWR3dPOigtignUXTMWdoXs-4GUELFXfYSnD4XnD0hoNaZ0Q7tqcqZLVBSABnKu/s670/600EA-installtion-step2.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;
&lt;a name=&#39;more&#39;&gt;&lt;/a&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitocLfGqbjhbZ1z8g9aJo20Vw990_dJX4bwBgNe908bJLbupHFB7ULAW4B-P-euEfRRjWnRFoXn8EgkufxGZOG7eBU3IV_T1N29WS4YXtFFjC1AjIkwM-xwjpLxhxWWoOMkwMQ5zotZddC/s738/600EA-installtion-step1.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;670&quot;  src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEitocLfGqbjhbZ1z8g9aJo20Vw990_dJX4bwBgNe908bJLbupHFB7ULAW4B-P-euEfRRjWnRFoXn8EgkufxGZOG7eBU3IV_T1N29WS4YXtFFjC1AjIkwM-xwjpLxhxWWoOMkwMQ5zotZddC/s670/600EA-installtion-step1.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWms_7av2tpvQRwEG7AN0Zzxa2Hv_JqWt7syP382l4qdGp2onQqEOkYZ-OPjCAI0xeD3FGgJsMt1mG_dOYCxpVSg-vNWWaMRBAouRiawVl-dePITQVCieuYlqSBsmUlP80UN_scs5d9gOf/s1141/600+profit+forex+ea+3.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;670&quot;  data-original-width=&quot;1141&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWms_7av2tpvQRwEG7AN0Zzxa2Hv_JqWt7syP382l4qdGp2onQqEOkYZ-OPjCAI0xeD3FGgJsMt1mG_dOYCxpVSg-vNWWaMRBAouRiawVl-dePITQVCieuYlqSBsmUlP80UN_scs5d9gOf/s670/600+profit+forex+ea+3.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4hNccxWsTm1_f2KWoDCMKkp9xCFISHk6J0k3Ix03Z2hKcMFmTGFpowFdkdSwizywJ-t2_g3HmYqUBrJdLgDIi_hooKOcAOfqsulJdXNC83CPFCf5OskmIkIjeF0DmKt8Y3l1GH_gopcXF/s1366/600+profit+forex+ea+2.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;670&quot;  data-original-width=&quot;1366&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg4hNccxWsTm1_f2KWoDCMKkp9xCFISHk6J0k3Ix03Z2hKcMFmTGFpowFdkdSwizywJ-t2_g3HmYqUBrJdLgDIi_hooKOcAOfqsulJdXNC83CPFCf5OskmIkIjeF0DmKt8Y3l1GH_gopcXF/s670/600+profit+forex+ea+2.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihFTuBz2r93oG4I9FO_cprHVxnge1u9BhVH9T-LHTPgYLnNDf45i03Yc3ettuyli5hWg7fvINlEaCCYrWe1w0UaJg4FB3V_8E9YmQ8T2vqDnclXm6sO3XCVbLjQzZpi6p_nAmVpkXDA50p/s1275/600+profit+forex+ea+4.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;670&quot;  data-original-width=&quot;1275&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihFTuBz2r93oG4I9FO_cprHVxnge1u9BhVH9T-LHTPgYLnNDf45i03Yc3ettuyli5hWg7fvINlEaCCYrWe1w0UaJg4FB3V_8E9YmQ8T2vqDnclXm6sO3XCVbLjQzZpi6p_nAmVpkXDA50p/s670/600+profit+forex+ea+4.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;

This E.A made 600% profit within 2 months.&lt;br/&gt;&lt;br/&gt;

Video instruction to install and setup this EA Robot :&lt;br/&gt;
&lt;a target=&quot;_blank&quot; href=&quot;https://www.youtube.com/watch?v=2aU47eaoQ3U&quot;&gt;https://www.youtube.com/watch?v=2aU47eaoQ3U&lt;/a&gt;&lt;br/&gt;&lt;br/&gt;

Don&#39;t forget to set swap free, instruction video at :&lt;br/&gt;
&lt;a target=&quot;_blank&quot; href=&quot;https://www.youtube.com/watch?v=YfqtMpCu4ok&quot;&gt;https://www.youtube.com/watch?v=YfqtMpCu4ok&lt;/a&gt;&lt;br/&gt;&lt;br/&gt;

Download this E.A file and setting file from the following link :&lt;br/&gt;
&lt;a target=&quot;_blank&quot; href=&quot;https://tinyurl.com/2jumEA&quot;&gt;https://tinyurl.com/2jumEA&lt;/a&gt;&lt;br/&gt;
OR&lt;br/&gt;
&lt;a target=&quot;_blank&quot; href=&quot;https://bit.ly/3tbE9c8&quot;&gt;https://bit.ly/3tbE9c8&lt;/a&gt;&lt;br/&gt;
------------------------------------------&lt;br/&gt;
FBS MT4 broker :&lt;br/&gt;
1) Legit with International License,&lt;br/&gt;
2) Low spread,&lt;br/&gt;
3) No commission charged,&lt;br/&gt;
4) No swap fee,&lt;br/&gt;
5) Cent Account (USD20 = USD2000)&lt;br/&gt;
6) Leverage 1:1000&lt;br/&gt;
My FBS affiliate link :&lt;br/&gt;
&lt;a target=&quot;_blank&quot; href=&quot;https://fbs.com/?ppk=SweetGirlForex&quot;&gt;https://fbs.com/?ppk=SweetGirlForex&lt;/a&gt;&lt;br/&gt;
You will get 100% bonus if register through my affiliate link.&lt;br/&gt;
For example, you deposit usd50, u get usd50 bonus. So total you get USD100 in your MT4 account.&lt;br/&gt;
--------------------------------------------&lt;br/&gt;&lt;br/&gt;






</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/4098666920035877790/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/4098666920035877790' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/4098666920035877790'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/4098666920035877790'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2021/10/the-best-forex-ea-year-2021.html' title='The Best Forex EA year 2021'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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/AVvXsEjgdze9uV2H5ZZoVhkPrhuktYMT-yenW8IcRzpBvT02U8QRVGthJQhTe6wrhlGA6u1Pz3U4_CgrmLrQHXOn821z95PgjHFiBTqlEthol_HhMN0_d5_BzR6j8miZwqKdwkYvK27b6Y3HuoXM/s72-c/600+profit+forex+ea+feature+image.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5619550813183664888.post-4833868002984236028</id><published>2021-09-28T13:36:00.020+08:00</published><updated>2021-10-02T19:56:02.384+08:00</updated><title type='text'>How to change theme design template for existing php website?</title><content type='html'>Steps :&lt;br/&gt;
1) Upload new design template folder and file to hosting/server.&lt;br/&gt;
- Do NOT overwrite existing folder, just upload the new file to existing folder.&lt;br/&gt;
- If same name file, then rename old file by adding -old behind.&lt;br/&gt;&lt;br/&gt;

2) Test upload and open a html front page see if all image, design no missing and right click select &quot;inspect&quot; in chrome to check console got error.&lt;br/&gt;&lt;br/&gt;

3) (Please DON&#39;T do this step 3, i show step 3 is just because worry you forget and stupid doing step 3).&lt;br/&gt;
Move files to deeper folder Eg. FROM :&lt;br/&gt;
test.hyperspace.today/asset/img&lt;br/&gt;
TO:&lt;br/&gt;
test.hyperspace.today/application/views/themes/defaults/assets_web/img&lt;br/&gt;&lt;br/&gt;

4) After move file at step 3, if u can&#39;t browse the page, solution is at step 5.&lt;br/&gt;&lt;br/&gt;

5) Solution for step 4 is You need to do 3 things :&lt;br/&gt;
a) rename file extension from .html to .php&lt;br/&gt;
b) Controller/Hungry create function contactus(){ to load the view from the new file contactus.php&lt;br/&gt;
c) config/route.php add $route[&#39;contactus&#39;] = &quot;hungry/contactus&quot;;&lt;br/&gt;&lt;br/&gt;

6) Focus on edit homepage now. Clone new design index.html file and rename 1 to menu-2.php and upload it to server.&lt;br/&gt;&lt;br/&gt;

7) at Controller/Hungry.php edit function menu() load view to menu-2.php (comment out the original load view code)&lt;br/&gt;&lt;br/&gt;

8) Replace the new design content to real content. Eg, username, sidebar menu, wallet name and amount.&lt;br/&gt;&lt;br/&gt;

Bug : Bootstrap Modal cannot close.&lt;br/&gt;
make sure dont have repeating the same id of div in two files :&lt;br/&gt;
1) modal_view_tree_member_data.php&lt;br/&gt;
2) dashboard.php&lt;br/&gt;
Then if using bootstrap v5 instead of v4, solution :&lt;br/&gt;
&lt;textarea style=&quot;height: 140px; width: 670px;&quot;&gt; 
New Way
&lt;button type=&quot;button&quot; class=&quot;btn-close&quot; data-bs-dismiss=&quot;modal&quot; aria-label=&quot;Close&quot;&gt;&lt;/button&gt;
Old Way
&lt;button type=&quot;button&quot; class=&quot;btn-close&quot; data-dismiss=&quot;modal&quot; aria-label=&quot;Close&quot;&gt;&lt;/button&gt;
&lt;/textarea&gt;&lt;br /&gt;
----------------------------------
&lt;br /&gt;   

Bug : Boostrap 5 Modal cannot open.&lt;br/&gt;
Solution : Change data-toggle=&quot;modal&quot; data-target=&quot;#lostpassword&quot; TO :&lt;br/&gt;
data-bs-toggle=&quot;modal&quot; data-bs-target=&quot;#lostpassword&quot;&lt;br/&gt;&lt;br/&gt;

Cannot find jquery function or javascript function is from which .js file?&lt;br/&gt;
Solution : right click the webpage, select &quot;Page Source&quot;, then click each .js link to open it. Then press CTRL + F to find the keyword.&lt;br/&gt;&lt;br/&gt;</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/4833868002984236028/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/4833868002984236028' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/4833868002984236028'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/4833868002984236028'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2021/09/how-to-change-theme-design-template-for.html' title='How to change theme design template for existing php website?'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-7503936831421851494</id><published>2021-09-09T10:45:00.051+08:00</published><updated>2021-10-02T03:09:23.193+08:00</updated><title type='text'>Bhojon Modification Documentation</title><content type='html'>1) Add new line codes in .htaccess file :
&lt;textarea style=&quot;height: 100px; width: 670px;&quot;&gt; 
RewriteCond %{HTTP_HOST} test.hyperspace\.today [NC]
RewriteCond %{REQUEST_URI} ^/$
Rewriterule ^(.*)$ https://test.hyperspace.today/menu [L,R=301]
Redirect /home /menu
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;   

2) Edit the link url on .htaccess file.&lt;br/&gt;&lt;br/&gt;

Home page keep jump to admin login page problem :&lt;br/&gt;
3) Login to Admin panel &gt; Web Setting &gt; Common Setting &gt; Website On &gt; Save.&lt;br/&gt;&lt;br/&gt;

4) Add Food Category with picture from Admin panel.&lt;br/&gt;&lt;br/&gt;

5) Add Food with picture from Admin panel.&lt;br/&gt;&lt;br/&gt;
  
6) Add Food Variant from Admin panel.&lt;br/&gt;&lt;br/&gt;
    
7) Add /** Zac Edit Start Here **/ CSS code to &lt;br/&gt;
application/views/themes/defaults/assets_web/css/custome.css &lt;br/&gt;&lt;br/&gt;

8) Copy paste all code in app.hyperspace.today/application/views/themes/defaults/menu.php&lt;br/&gt;&lt;br/&gt;

9) Copy paste all code in app.hyperspace.today/application/views/themes/defaults/reservation.php&lt;br/&gt;&lt;br/&gt;

10) Copy paste all code in app.hyperspace.today/application/views/themes/defaults/index.php&lt;br/&gt;&lt;br/&gt;

11) Add banner from Admin panel.&lt;br/&gt;&lt;br/&gt;

12) Upload Footer Menu image at app.hyperspace.today/assets/img/icons.&lt;br/&gt;&lt;br/&gt;

13) To modify url login to admin-login :
&lt;textarea style=&quot;height: 390px; width: 670px;&quot;&gt; 
1) Edit application/config/routes.php:
$route[&#39;login&#39;]  = &quot;dashboard/auth/index&quot;;
  TO :
$route[&#39;admin-login&#39;]  = &quot;dashboard/auth/index&quot;;
  
2) Edit application/modules/dashboard/controllers/Auth.php
redirect(&#39;login&#39;);
  To :
redirect(&#39;admin-login&#39;);
  
3) Edit application/modules/template/controllers/Template.php
$this-&gt;load-&gt;view(&#39;login&#39;, $data);
  To :
$this-&gt;load-&gt;view(&#39;admin-login&#39;, $data);
  
4) Rename 
  application/modules/template/views/login.php
  To :
  application/modules/template/views/admin-login.php
  
5) application/modules/template/views/admin-login.php
echo form_open(&#39;login&#39;,&#39;id=&quot;loginForm&quot; novalidate&#39;);
  To :
echo form_open(&#39;admin-login&#39;,&#39;id=&quot;loginForm&quot; novalidate&#39;);  
&lt;/textarea&gt;&lt;br /&gt;
----------------------------------
&lt;br /&gt;  

14) Import database tbl language from id 1805 (restaurant). Steps :&lt;br /&gt;  
select records from id 1805 onward &gt; Export &gt; Custom &gt; Only Data (No need change Rows numbers field)&lt;br /&gt;&lt;br /&gt; 

15) Add Cash Wallet and Point Wallet into Table Payment_Method.&lt;br /&gt;&lt;br /&gt; 

16) import tbl_ewallet from previous project.&lt;br /&gt;&lt;br /&gt; 

17) Move php function from old project library/common.php to new project library/common.php&lt;br/&gt;
Previous project code : $query=$this-&gt;CI-&gt;db-&gt;query($q);&lt;br/&gt;
Solution : Remove &quot;CI&quot;&lt;br/&gt;
on Controller/Xxxx.php add $this-&gt;load-&gt;library(&#39;Common&#39;);&lt;br/&gt;&lt;br/&gt;

18) Add Wallet to Admin manage_member page : &lt;br/&gt;
application/modules/setting/views/customerlist.php
&lt;textarea style=&quot;height: 100px; width: 670px;&quot;&gt; 
line 138 : &lt;th&gt;&lt;?php echo display(&#39;wallet&#39;) ?&gt;&lt;/th&gt;
  
Database query : INSERT INTO `language` (`id`, `phrase`, `english`, `spanish`, `turkish`, `taiwan`) VALUES (NULL, &#39;wallet&#39;, &#39;Wallet&#39;, NULL, NULL, &#39;钱包&#39;);
  
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;   

19) Copy paste constant.php from old to new project.&lt;br/&gt;&lt;br/&gt;

20) fix admin sidebar is not active on admin manual credit member wallet page by javascript:&lt;br/&gt;
&lt;textarea style=&quot;height: 300px; width: 670px;&quot;&gt; 
&lt;script&gt;
$(document).ready(function() {
    var url = window.location.pathname;
    var segments = url.split( &#39;/&#39; );
    var module = segments[1];
    var controller = segments[2];
    var method = segments[3];
    //alert($.trim(method));
    if(method == &quot;e_wallet&quot;)
    {
        $(&#39;#&#39;+module).addClass(&#39;active&#39;);
        $(&#39;#customertype&#39;).addClass(&#39;active&#39;);
        $(&#39;#customerlist&#39;).addClass(&#39;active&#39;);
    }
});
&lt;/script&gt;
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;   

21) If 403 error or ajax error, then go to config.php turn false ALL $config[&#39;csrf_protection&#39;] = FALSE;&lt;br /&gt;&lt;br /&gt;

22) agent1 stuck at login page, so go to application/modules/setting/controllers/Language.php
&lt;textarea style=&quot;height: 200px; width: 670px;&quot;&gt; 
replace :
if (!$this-&gt;session-&gt;userdata(&#39;isAdmin&#39;)) 
  
To :
  
$uri_path = parse_url($_SERVER[&#39;REQUEST_URI&#39;], PHP_URL_PATH);
$uri_segments = explode(&#39;/&#39;, $uri_path);
$pageurl = $uri_segments[1];
if (!$this-&gt;session-&gt;userdata(&#39;isAdmin&#39;) &amp;&amp; $pageurl == &quot;admin-login&quot;) 
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;   

23）Add this sql to database :&lt;br/&gt;
&lt;textarea style=&quot;height: 90px; width: 670px;&quot;&gt; 
INSERT INTO `language` (`id`, `phrase`, `english`, `taiwan`) VALUES (NULL, &#39;cash_wallet_report&#39;, &#39;Cash Wallet Report&#39;, &#39;现金钱包报告&#39;), (NULL, &#39;point_wallet_report&#39;, &#39;Point Wallet Report&#39;, &#39;现金钱包报告&#39;);
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;   

24) Create sidebar menu : cash_wallet_report and point_wallet_report at : application/modules/template/views/includes/sidebar.php&lt;br/&gt;
if not show label of the sidebar menu, then add in tbl_language as point (23)&lt;br/&gt;&lt;br/&gt;

25) replace login.php to admin-login.php at : application/modules/setting/controllers/Setting.php&lt;br/&gt;&lt;br/&gt;

26) add the following code to : application/modules/report/controllers/Reports.php
&lt;textarea style=&quot;height: 50px; width: 670px;&quot;&gt; 
$this-&gt;load-&gt;library(&#39;Common&#39;);
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;   

27) Copy 2 functions report_wallets() and report_wallets_ajax from old project application/controllers/secure/Transaction_report.php to new project application/modules/report/controllers/Reports.php&lt;br/&gt;&lt;br/&gt;

28) Copy paste php file from old project shop.aegis2u.com/application/views/secure/report_wallets.php to new project application/modules/report/views/report_wallets.php&lt;br/&gt;&lt;br/&gt;

29) Add point to food variant table by sql :
&lt;textarea style=&quot;height: 50px; width: 670px;&quot;&gt; 
ALTER TABLE `variant` ADD `point` INT(5) NOT NULL AFTER `price`;
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  

30) Add point label to Language table by sql :
&lt;textarea style=&quot;height: 50px; width: 670px;&quot;&gt; 
INSERT INTO `language` (`id`, `phrase`, `english`, `taiwan`) VALUES (NULL, &#39;point&#39;, &#39;Point&#39;, &#39;积分&#39;);
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  

31) search keyword &quot;price&quot; and add &quot;point&quot; below it for 3 pages :&lt;br /&gt;  
a) application/modules/itemmanage/controllers/Item_food.php&lt;br /&gt;  
b) application/modules/itemmanage/views/varientlist.php&lt;br /&gt;  
c) application/modules/itemmanage/views/varientedit.php&lt;br /&gt;  &lt;br /&gt;  

32) add lable cash wallet and point wallet to table Language by sql :
&lt;textarea style=&quot;height: 80px; width: 670px;&quot;&gt; 
INSERT INTO `language` (`id`, `phrase`, `english`, `spanish`, `turkish`, `taiwan`) VALUES (NULL, &#39;cash wallet&#39;, &#39;Cash Wallet&#39;, NULL, NULL, &#39;现金钱包&#39;), (NULL, &#39;point wallet&#39;, &#39;Point Wallet&#39;, NULL, NULL, &#39;积分钱包&#39;);
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt; 

33) Copy paste the following code from old project controller/Dashboard.php to new project controller/Hungry.php
&lt;textarea style=&quot;height: 80px; width: 670px;&quot;&gt; 
$data[&#39;total_cash&#39;] = $this-&gt;common-&gt;getCashBalance(....
$data[&#39;total_point&#39;] = $this-&gt;common-&gt;getCoinBalance(....
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt; 

34) Copy paste the following 4 functions from old projects Controller/Wallets.php to new project controller/Hungry.php :&lt;br /&gt; 
a) function cash_wallet()&lt;br /&gt; 
b) function cash_wallet_ajax()&lt;br /&gt; 
c) function coin_wallet()&lt;br /&gt; 
d) function coin_wallet_ajax()&lt;br /&gt; &lt;br /&gt; 

35) add &quot;public&quot; before &quot;function&quot; at point (34) a,b,c,d.&lt;br /&gt; &lt;br /&gt; 

36) find keyword &quot;$this-&gt;session-&gt;userdata(&#39;WDW_MEMBER_LOGIN_ID&#39;)&quot; and replace it with $islogin and add declaration : $islogin = $this-&gt;session-&gt;userdata(&#39;CusUserID&#39;);&lt;br /&gt; &lt;br /&gt; 

37) 
&lt;textarea style=&quot;height: 180px; width: 670px;&quot;&gt; 
Replace :
$this-&gt;load-&gt;view(&#39;member/cash_wallet&#39;, $data);
  
To :
$data[&#39;content&#39;] = $this-&gt;load-&gt;view(&#39;themes/&#39; . $this-&gt;themeinfo-&gt;themename . &#39;/cash_wallet&#39;, $data, TRUE);
$this-&gt;load-&gt;view(&#39;themes/&#39; . $this-&gt;themeinfo-&gt;themename . &#39;/index&#39;, $data);
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt; 

38) find keyword &quot;coin&quot; replace it to &quot;Point&quot;.&lt;br /&gt; &lt;br /&gt; 

39) upload Datapicker folder from old project assets/admin/js/plugins/datapicker&lt;br /&gt; &lt;br /&gt; 

40) I have delete 90% codes at application/views/themes/defaults/cartitem.php&lt;br /&gt; 
So if found any bug on shopping cart, then have to copy paste the code back from org.hyperspace.com AND&lt;br /&gt;
function addtocartitem(pid, id, type)  at application/views/themes/defaults/assets_web/js/default_theme.js&lt;br /&gt;&lt;br /&gt;


 &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  
  </content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/7503936831421851494/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/7503936831421851494' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/7503936831421851494'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/7503936831421851494'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2021/09/bhojon-modification-documentation.html' title='Bhojon Modification Documentation'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-328030025784714603</id><published>2021-09-05T07:24:00.002+08:00</published><updated>2021-09-05T07:24:48.612+08:00</updated><title type='text'>Laravel Tutorial</title><content type='html'>If have problem, besides google search, u may search in laravel documentation : https://laravel.com/docs/8.x &lt;br/&gt;&lt;br/&gt;</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/328030025784714603/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/328030025784714603' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/328030025784714603'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/328030025784714603'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2021/09/laravel-tutorial.html' title='Laravel Tutorial'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-6437727859429942713</id><published>2021-08-27T14:40:00.056+08:00</published><updated>2021-11-05T12:46:49.214+08:00</updated><title type='text'>Bhojon CodeIgniter Tutorial</title><content type='html'>If logs folder don&#39;t show error file :&lt;br/&gt;
Go to config.php edit :
&lt;textarea style=&quot;height: 50px; width: 670px;&quot;&gt; 
$config[&#39;log_threshold&#39;] = 1;

&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  

To modify url login to admin-login :
&lt;textarea style=&quot;height: 390px; width: 670px;&quot;&gt; 
1) Edit application/config/routes.php:
$route[&#39;login&#39;]  = &quot;dashboard/auth/index&quot;;
  TO :
$route[&#39;admin-login&#39;]  = &quot;dashboard/auth/index&quot;;
  
2) Edit application/modules/dashboard/controllers/Auth.php
redirect(&#39;login&#39;);
  To :
redirect(&#39;admin-login&#39;);
  
3) Edit application/modules/template/controllers/Template.php
$this-&gt;load-&gt;view(&#39;login&#39;, $data);
  To :
$this-&gt;load-&gt;view(&#39;admin-login&#39;, $data);
  
4) Rename 
  application/modules/template/views/login.php
  To :
  application/modules/template/views/admin-login.php
  
5) application/modules/template/views/admin-login.php
echo form_open(&#39;login&#39;,&#39;id=&quot;loginForm&quot; novalidate&#39;);
  To :
echo form_open(&#39;admin-login&#39;,&#39;id=&quot;loginForm&quot; novalidate&#39;);  
  


&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  
  

Edit CSS at :&lt;br/&gt;
application/views/themes/defaults/assets_web/css/style.css but better edit in custom.css because when update version, style.css will be replaced by new file.&lt;br/&gt;&lt;br/&gt;

Edit languages at :&lt;br/&gt;
database table language&lt;br/&gt;&lt;br/&gt;


Common.php file contain all common functions is at : &lt;br/&gt;
application/models/Hungry_model.php&lt;br/&gt;&lt;br/&gt;

Home page controller/Home.php is at :&lt;br/&gt;
application/controllers/Hungry.php&lt;br/&gt;&lt;br/&gt;

Edit header and footer is at :&lt;br/&gt;
application/views/themes/defaults/index.php&lt;br/&gt;&lt;br/&gt;

Syntac replacement :&lt;br/&gt;
$data[&#39;form_data&#39;]= $this-&gt;common-&gt;getAllRec(&quot;*&quot;,&quot;tbl_manage_announcement&quot;,&quot;WHERE status = 1 Order By id DESC&quot;);&lt;br/&gt;
$data[&#39;paymentinfo&#39;] =  $this-&gt;hungry_model-&gt;read_all(&#39;*&#39;, &#39;payment_method&#39;, &#39;payment_method_id&#39;, &#39;&#39;, &#39;is_active&#39;, &#39;1&#39;);&lt;br/&gt;&lt;br/&gt;

Exception: Call to a member function query() on null&lt;br/&gt;
Previous project code : $query=$this-&gt;CI-&gt;db-&gt;query($q);&lt;br/&gt;
Solution : Remove &quot;CI&quot;&lt;br/&gt;&lt;br/&gt;

How to call function from controller to view page?&lt;br/&gt;
&lt;textarea style=&quot;height:250px; width: 670px;&quot;&gt; 
At application/controllers/Hungry.php :
public function checkout()
{
  $data[&#39;test&#39;] =  $this-&gt;test2();
}

public function test2()
{
  return &quot;ass&quot;;
}
  
At application/views/themes/defaults/checkout.php :
&lt;?php echo $test; ?&gt;

&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  

Admin header, sidebar, footer is at : &lt;br/&gt;
1) application/modules/template/views/includes/header.php &lt;br/&gt;
2) application/modules/template/views/layout.php &lt;br/&gt;
3) At Controllers/Xxx.php file replace :
&lt;textarea style=&quot;height:120px; width: 670px;&quot;&gt; 
$this-&gt;load-&gt;view(&#39;setting/member_e_wallet&#39;, $data);
to
$data[&#39;module&#39;] = &quot;setting&quot;;
$data[&#39;page&#39;]   = &quot;member_e_wallet&quot;;   
echo Modules::run(&#39;template/layout&#39;, $data); 
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  

Admin sidebar is not active, go to application/modules/template/views/includes/sidebar.php :&lt;br/&gt;
&lt;textarea style=&quot;height: 300px; width: 670px;&quot;&gt; 
&lt;script&gt;
$(document).ready(function() {
    var url = window.location.pathname;
    var segments = url.split( &#39;/&#39; );
    var module = segments[1];
    var controller = segments[2];
    var method = segments[3];
    //alert($.trim(method));
    if(method == &quot;e_wallet&quot;)
    {
        $(&#39;#&#39;+module).addClass(&#39;active&#39;);
        $(&#39;#customertype&#39;).addClass(&#39;active&#39;);
        $(&#39;#customerlist&#39;).addClass(&#39;active&#39;);
    }
});
&lt;/script&gt;
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;   

If css disappear, then go to contoller file edit :&lt;br/&gt;
&lt;textarea style=&quot;height:120px; width: 670px;&quot;&gt; 
$this-&gt;load-&gt;view(&#39;setting/member_e_wallet&#39;, $data);
to
$data[&#39;module&#39;] = &quot;setting&quot;;
$data[&#39;page&#39;]   = &quot;member_e_wallet&quot;;   
echo Modules::run(&#39;template/layout&#39;, $data); 
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  

If admin-agent cannot login, go to admin panel &gt; user &gt; edit user &gt; uncheck &quot;Is Monitor Display&quot;. &lt;br/&gt;&lt;br/&gt;

If side bar menu is not show, then add in tbl_language.&lt;br/&gt;&lt;br/&gt;

If 500 error or Call to a member function getAllRec() on null, meaning cannot read Common.php file, so add the following code to the controller file :
&lt;textarea style=&quot;height: 50px; width: 670px;&quot;&gt; 
$this-&gt;load-&gt;library(&#39;Common&#39;);
  &lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt; 

How to move Controller file from old project to new project?&lt;br /&gt;
1) Copy paste the following 4 functions from old projects Controller/Wallets.php to new project controller/Hungry.php :&lt;br /&gt; 
a) function cash_wallet()&lt;br /&gt; 
b) function cash_wallet_ajax()&lt;br /&gt; 
c) function coin_wallet()&lt;br /&gt; 
d) function coin_wallet_ajax()&lt;br /&gt; &lt;br /&gt; 

2) add &quot;public&quot; before &quot;function&quot; at point (34) a,b,c,d.&lt;br /&gt; &lt;br /&gt; 

3) find keyword &quot;$this-&gt;session-&gt;userdata(&#39;WDW_MEMBER_LOGIN_ID&#39;)&quot; and replace it with $islogin and add declaration : $islogin = $this-&gt;session-&gt;userdata(&#39;CusUserID&#39;);&lt;br /&gt; &lt;br /&gt; 

4) 
&lt;textarea style=&quot;height: 180px; width: 670px;&quot;&gt; 
Replace :
$this-&gt;load-&gt;view(&#39;member/cash_wallet&#39;, $data);
  
To :
$data[&#39;content&#39;] = $this-&gt;load-&gt;view(&#39;themes/&#39; . $this-&gt;themeinfo-&gt;themename . &#39;/cash_wallet&#39;, $data, TRUE);
$this-&gt;load-&gt;view(&#39;themes/&#39; . $this-&gt;themeinfo-&gt;themename . &#39;/index&#39;, $data);
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt; 


How to move View file from old project to new project? 7 steps :&lt;br /&gt;
1) Copy paste entire code from old project file to new project file.&lt;br /&gt;
2) Delete all codes above the following code line : &lt;br /&gt;
&lt;textarea style=&quot;height: 40px; width: 670px;&quot;&gt; 
&lt;div class=&quot;row&quot;&gt;
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  
3) make sure close div is the same number as open div (tips : just count vertical line from left side). Delete all extra div close at bottom&lt;br /&gt;&lt;br /&gt;
  
4) Visit member site to find out which page is the same template u want to copy (want side menu?), if want side menu then may copy my_profile page template. Copy all div class from there.&lt;br /&gt;&lt;br /&gt;
  
5) Find keyword &quot;member/&quot; and replace it with correct file path, eg :
&lt;textarea style=&quot;height: 40px; width: 670px;&quot;&gt; 
site_url(&#39;hungry/wallets/cash_wallet&#39;);
&lt;/textarea&gt;&lt;br /&gt;

6) application/config/routes.php add :
&lt;textarea style=&quot;height: 40px; width: 670px;&quot;&gt; 
$route[&#39;cash_wallet&#39;] = &quot;hungry/cash_wallet&quot;;
&lt;/textarea&gt;&lt;br /&gt;
 

7) include datatable css and javascript to application/modules/template/views/includes/head.php :
&lt;textarea style=&quot;height: 100px; width: 670px;&quot;&gt; 
&lt;link href=&quot;&lt;?php echo base_url(&#39;assets/datatables/css/dataTables.min.css&#39;) ?&gt;&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot;/&gt;
  
&lt;script src=&quot;&lt;?php echo base_url(&#39;assets/datatables/js/dataTables.min.js&#39;) ?&gt;&quot; type=&quot;text/javascript&quot;&gt;&lt;/script&gt;
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  
  
TypeError: $(...).DataTable is not a function , solution :&lt;br/&gt;
There could be 3 reasons for this error :&lt;br/&gt;
1) jQuery DataTables library is missing.&lt;br/&gt;
2) jQuery library is loaded after jQuery DataTables.&lt;br/&gt;
3) Multiple versions of jQuery library is loaded.&lt;br/&gt;
SOLUTION at point (7) above.&lt;br/&gt;&lt;br/&gt;
  

Those errors are because you didn&#39;t include inc_footer.php :&lt;br/&gt;
1) checkboxlist_all_new error&lt;br/&gt;
2) status active inactive toogle error&lt;br/&gt;
3) change_status error&lt;br/&gt;
4) delete_all error&lt;br/&gt;
&lt;textarea style=&quot;height: 60px; width: 670px;&quot;&gt; 
&lt;?php $this-&gt;load-&gt;view(&#39;themes/&#39; . $this-&gt;themeinfo-&gt;themename . &#39;/inc_footer&#39;); ?&gt;
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  
  
  
  
Cannot upload photo / payment resit &lt;br/&gt;
OR&lt;br/&gt;
error --&gt; Exception: Call to a member function initialize()&lt;br/&gt;
Solution is to load &quot;upload&quot; library at Config/autoload.php OR put the following code on the error page :&lt;br/&gt;
$this-&gt;load-&gt;library(&#39;upload&#39;);&lt;br/&gt;&lt;br/&gt;
  
can&#39;t submit form on bootstrap popup model, so must use javascript to submit form:
&lt;textarea style=&quot;height: 280px; width: 670px;&quot;&gt; 
    &lt;div class=&quot;modal-footer&quot;&gt;			
        &lt;button onclick=&quot;form_submit()&quot; name=&#39;sb_btn&#39; class=&quot;btn btn-danger&quot;&gt;Submit&lt;/button&gt;
    &lt;/div&gt;
&lt;/form&gt;
&lt;script type=&quot;text/javascript&quot;&gt;
   function form_submit() {
      if($(&#39;#payment_slip&#39;).get(0).files.length != 0))
      {
        document.getElementById(&quot;package_step_form&quot;).submit();
      }
   }    
&lt;/script&gt;
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  

How to copy paste library/Common_model.php from old project to new project?&lt;br /&gt; 
Solution : copy the inside codes functions from old Common_model.php to new Hungry_model.php&lt;br /&gt; &lt;br /&gt; 

Error :&lt;br/&gt;
1) 500&lt;br/&gt;
2) Unable to load the requested file: member/inc_footer.php&lt;br/&gt;
3) The path to the image is not correct.&lt;br/&gt;
4) Your server does not support the GD function required to process this type of image.&lt;br/&gt;
Solution :
&lt;textarea style=&quot;height: 140px; width: 670px;&quot;&gt; 
Replace :
	&lt;?php $this-&gt;load-&gt;view(&#39;member/inc_footer&#39;); ?&gt;

To :
	&lt;?php $this-&gt;load-&gt;view(&#39;themes/&#39; . $this-&gt;themeinfo-&gt;themename . &#39;/inc_footer&#39;); ?&gt;
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  


How to apply jquery function from old project form to new project form?
&lt;textarea style=&quot;height: 180px; width: 670px;&quot;&gt; 
Replace :
	&lt;form id=&quot;member_registration_form&quot; action=&quot;&lt;?php echo site_url(&#39;register&#39;); ?&gt;&quot;  method=&quot;post&quot;&gt;
To :
	 &lt;?php 
          $attributes = array(&#39;class&#39; =&gt; &#39;row&#39;, &#39;id&#39; =&gt; &#39;member_registration_form&#39;);
          echo form_open_multipart(&#39;hungry/submitregister&#39;,$attributes) 
     ?&gt;
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  
  
500 ERROR might because database query syntac error, or wrong field name in database.&lt;br/&gt;&lt;br/&gt;

Cannot find jquery function or javascript function is from which .js file?&lt;br/&gt;
Solution : right click the webpage, select &quot;Page Source&quot;, then click each .js link to open it. Then press CTRL + F to find the keyword.&lt;br/&gt;&lt;br/&gt;
  
javascript function addonsitem() and addtocartitem() is at application/views/themes/defaults/assets_web/js/default_theme.js&lt;br/&gt;&lt;br/&gt;
  
ERRORS :
&lt;textarea style=&quot;height: 130px; width: 670px;&quot;&gt; 
Uncaught SyntaxError: Unexpected token &#39;&lt;&#39; showljslang
Uncaught SyntaxError: Unexpected token &#39;&lt;&#39; basicjs:1
Solution : Edit php file application/modules/ordermanage/controllers/Order.php
Remove this line of code :
if (!$this-&gt;session-&gt;userdata(&#39;isLogIn&#39;)) 
redirect(&#39;admin-login&#39;); 
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;  
  
$this-&gt;session-&gt;set_flashdata not showing.
Solution : Add the following code inside div id=&quot;content&quot;
&lt;textarea style=&quot;height: 360px; width: 670px;&quot;&gt; 
&lt;?php if ($this-&gt;session-&gt;flashdata(&#39;message&#39;)) { ?&gt;
     &lt;div class=&quot;alert alert-success alert-dismissible&quot; role=&quot;alert&quot;&gt;
         &lt;button type=&quot;button&quot; class=&quot;close&quot; data-bs-dismiss=&quot;alert&quot; aria-label=&quot;Close&quot;&gt;&lt;span aria-hidden=&quot;true&quot;&gt;&amp;times;&lt;/span&gt;&lt;/button&gt;
         &lt;?php echo $this-&gt;session-&gt;flashdata(&#39;message&#39;) ?&gt;
     &lt;/div&gt;
 &lt;?php } ?&gt;
 &lt;?php if ($this-&gt;session-&gt;flashdata(&#39;exception&#39;)) { ?&gt;
     &lt;div class=&quot;alert alert-danger alert-dismissible&quot; role=&quot;alert&quot;&gt;
         &lt;button type=&quot;button&quot; class=&quot;close&quot; data-bs-dismiss=&quot;alert&quot; aria-label=&quot;Close&quot;&gt;&lt;span aria-hidden=&quot;true&quot;&gt;&amp;times;&lt;/span&gt;&lt;/button&gt;
         &lt;?php echo $this-&gt;session-&gt;flashdata(&#39;exception&#39;) ?&gt;
     &lt;/div&gt;
 &lt;?php } ?&gt;
 &lt;?php if (validation_errors()) { ?&gt;
     &lt;div class=&quot;alert alert-danger alert-dismissible&quot; role=&quot;alert&quot;&gt;
         &lt;button type=&quot;button&quot; class=&quot;close&quot; data-bs-dismiss=&quot;alert&quot; aria-label=&quot;Close&quot;&gt;&lt;span aria-hidden=&quot;true&quot;&gt;&amp;times;&lt;/span&gt;&lt;/button&gt;
         &lt;?php echo validation_errors() ?&gt;
     &lt;/div&gt;
&lt;?php } ?&gt;
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;   
  
Book table check available codes at : application/models/Hungry_model.php&lt;br /&gt;   
function checkavailtable()&lt;br /&gt;&lt;br /&gt;
  
table reservation flow :&lt;br /&gt;
reservation-2.php &gt; hungry/reservation &gt; hungry/checkavailablity &gt; checkavail.php &gt; default_theme.js/editreserveinfo() &gt; hungry/reservationform &gt; reservationform.php &gt; hungry_model/checktable()/checkfree()/checkavailtable&lt;br /&gt;&lt;br /&gt;

  
Dont know which file to edit for Cart? cart-&gt;update() /cart-&gt;contents()?&lt;br /&gt;
cart is class of Codeignitor, so you won&#39;t fine cart function. All variable save in array pass through jquery. So you just need to trace from menu-2.php form &gt; jquery call php function in Hungry.php &gt; view form...&lt;br /&gt;&lt;br /&gt;
  
shopping cart function related files :&lt;br /&gt;
addonsitem.php&lt;br /&gt;
cartlist.php&lt;br /&gt;
cart-2.php&lt;br /&gt;
default_theme.js&lt;br /&gt;
  
 &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   </content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/6437727859429942713/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/6437727859429942713' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/6437727859429942713'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/6437727859429942713'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2021/08/bhojon-codeigniter.html' title='Bhojon CodeIgniter Tutorial'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-1689920171059067022</id><published>2021-08-22T00:57:00.011+08:00</published><updated>2021-08-22T01:35:41.985+08:00</updated><title type='text'>Tonsil / Tonsilla swell and pain home remedies</title><content type='html'>&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHIGVu-f6iQESoA7L-Z2pRKs9Xh2agggULdJ0tvfGg9MmMZjaynh9g_Gg9R6QOsn-zoeE1xF3uvs0Iq97SxD6zW0GdU4_xPCn-5vBe6wuC5RpNPSiZGw0sq6YuYhXgnmxYOBtm5_430PZW/s540/tonsillar.jpg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;640&quot; data-original-width=&quot;540&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgHIGVu-f6iQESoA7L-Z2pRKs9Xh2agggULdJ0tvfGg9MmMZjaynh9g_Gg9R6QOsn-zoeE1xF3uvs0Iq97SxD6zW0GdU4_xPCn-5vBe6wuC5RpNPSiZGw0sq6YuYhXgnmxYOBtm5_430PZW/s640/tonsillar.jpg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;

Steps to cure tonsil pain at home :&lt;br/&gt;
1) Keep drinking water so that tonsil is not dry. Tonsil will recovery fast if it is always mois by water.&lt;br/&gt;&lt;br/&gt;
2) Brush when wake up and before sleep.&lt;br/&gt;&lt;br/&gt;
3) When sleeping, side sleep, let tonsil pain side at downside, so that all saliva fall to tonsil. Saliva mois the tonsil because tonsil need to be mois only will recovery faster.&lt;br/&gt;&lt;br/&gt;
4) Try to sleep before 10pm to 2am (because this 4 hours is the most healing time for body tisue).&lt;br/&gt;&lt;br/&gt;
5) use air humidifier because when u breath in the air full of mois keep tonsil mois can recovery fast.&lt;br/&gt;

&lt;a name=&#39;more&#39;&gt;&lt;/a&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjutDdsxuTJBUo4LtDlGTIYH_cQnnFk1Tj5h0JFgIRVToR_T7WijlK0D3teOcVPrJ9VSYM75VblvajwEUL__P9dW1HFfxWSzmYCeq0dmVgc67xkL0b6Duq8gZQC3Rs3-n8wds6iFCix5Xwy/s800/air+humidifier.jpeg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot; width=&quot;400&quot; data-original-width=&quot;640&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjutDdsxuTJBUo4LtDlGTIYH_cQnnFk1Tj5h0JFgIRVToR_T7WijlK0D3teOcVPrJ9VSYM75VblvajwEUL__P9dW1HFfxWSzmYCeq0dmVgc67xkL0b6Duq8gZQC3Rs3-n8wds6iFCix5Xwy/s640/air+humidifier.jpeg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;&lt;br/&gt;

6) If you have habit always drink protein powder or milk everyday while doing gym, stop drinking protein before yout tonsil recovery, because protein powder make it worse.&lt;br/&gt;&lt;br/&gt;

7) If 3 days still not recovery or not getting better, then try apply watermelon powder.&lt;br/&gt;

&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1TjlXQqNghUrwMngFAGgXkM0GXOurf7aX0556neIKpsixHSwpaXuv7zPQZwGondfxPrDuocfOXsCxgprQgLZBV_PtozwAmSEldJmvygLM8Jhw-bBKrz2CQEPVEU6vwQCaAT0i05tpAj38/s960/watermelon-powder.jpeg&quot; style=&quot;display: block; padding: 1em 0; text-align: center; &quot;&gt;&lt;img alt=&quot;&quot; border=&quot;0&quot;  data-original-width=&quot;640&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1TjlXQqNghUrwMngFAGgXkM0GXOurf7aX0556neIKpsixHSwpaXuv7zPQZwGondfxPrDuocfOXsCxgprQgLZBV_PtozwAmSEldJmvygLM8Jhw-bBKrz2CQEPVEU6vwQCaAT0i05tpAj38/s640/watermelon-powder.jpeg&quot;/&gt;&lt;/a&gt;&lt;/div&gt;&lt;br/&gt;&lt;br/&gt;</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/1689920171059067022/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/1689920171059067022' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/1689920171059067022'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/1689920171059067022'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2021/08/tonsil-tonsilla-swell-and-pain-home.html' title='Tonsil / Tonsilla swell and pain home remedies'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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/AVvXsEgHIGVu-f6iQESoA7L-Z2pRKs9Xh2agggULdJ0tvfGg9MmMZjaynh9g_Gg9R6QOsn-zoeE1xF3uvs0Iq97SxD6zW0GdU4_xPCn-5vBe6wuC5RpNPSiZGw0sq6YuYhXgnmxYOBtm5_430PZW/s72-c/tonsillar.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5619550813183664888.post-8334934722847059782</id><published>2021-07-26T17:50:00.003+08:00</published><updated>2021-07-26T17:50:28.465+08:00</updated><title type='text'>php array tutorial</title><content type='html'>php for loop add value into multidimensional array&lt;br/&gt;
&lt;textarea style=&quot;height: 150px; width: 670px;&quot;&gt;   
$cto1_users_array = array();
$i=0;
foreach($lucky_winners As $lucky_user)
{
    $cto1_users_array[$i][&#39;userid&#39;] = $lucky_user[&#39;user_id&#39;];
    $cto1_users_array[$i][&#39;amount&#39;] = $each_person_get;
    $i++;
}
&lt;/textarea&gt;&lt;br /&gt;
  ----------------------------------
&lt;br /&gt;   

  
  
  
  
 &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  &lt;br /&gt;   
  
  </content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/8334934722847059782/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/8334934722847059782' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/8334934722847059782'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/8334934722847059782'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2021/07/php-array-tutorial.html' title='php array tutorial'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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-5619550813183664888.post-8996489571994597062</id><published>2021-05-05T23:14:00.019+08:00</published><updated>2021-05-05T23:28:56.400+08:00</updated><title type='text'>Web App PWA for Codeigniter</title><content type='html'>Step 1 : Your website must be running on a secure domain (https).&lt;br /&gt;&lt;br /&gt;

Step 2 : Use &lt;a href=&quot;http://realfavicongenerator.net/&quot;&gt;realfavicongenerator.net&lt;/a&gt; to generate all the necessary icons that will be used on different mobile devices, this platform will also generate the manifest.json file that you will need later.&lt;br /&gt;&lt;br /&gt;

Step 3 : Upload all icons and manifest.json from Step 2 above to file path assets/admin/images&lt;br /&gt;&lt;br /&gt;

Step 4 : Edit manifest.json file become look like :&lt;br /&gt;
&lt;textarea style=&quot;height: 380px; width: 670px;&quot;&gt;{
    &quot;name&quot;: &quot;Do Track&quot;,
    &quot;short_name&quot;: &quot;DoTrack&quot;,
    &quot;start_url&quot;: &quot;/index.php/secure/track_zc.html&quot;,
    &quot;icons&quot;: [
        {
            &quot;src&quot;: &quot;/assets/admin/images/android-chrome-192x192.png&quot;,
            &quot;sizes&quot;: &quot;192x192&quot;,
            &quot;type&quot;: &quot;image/png&quot;
        },
        {
            &quot;src&quot;: &quot;/assets/admin/images/android-chrome-384x384.png&quot;,
            &quot;sizes&quot;: &quot;384x384&quot;,
            &quot;type&quot;: &quot;image/png&quot;,
            &quot;purpose&quot;: &quot;any maskable&quot;
        }
    ],
    &quot;theme_color&quot;: &quot;#ffffff&quot;,
    &quot;background_color&quot;: &quot;#ffffff&quot;,
    &quot;display&quot;: &quot;standalone&quot;,
    &quot;prefer_related_applications&quot;: false
}
&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;

Step 5 : Application/Views/secure/inc_header.php file add the following code that generated from Step 2 just now :&lt;br /&gt;
&lt;textarea style=&quot;height: 250px; width: 670px;&quot;&gt;&lt;link rel=&quot;icon&quot; sizes=&quot;192x192&quot; href=&quot;&lt;?php echo $this-&gt;common-&gt;auto_version(base_url(&#39;assets/admin/images/android-chrome-192x192.png&#39;)); ?&gt;&quot;&gt; &lt;!-- RECOMMENDED --&gt; 
&lt;link rel=&quot;icon&quot; sizes=&quot;128x128&quot; href=&quot;&lt;?php echo $this-&gt;common-&gt;auto_version(base_url(&#39;assets/admin/images/android-chrome-192x192.png&#39;)); ?&gt;&quot;&gt;

&lt;link rel=&quot;apple-touch-icon&quot; sizes=&quot;180x180&quot; href=&quot;&lt;?php echo $this-&gt;common-&gt;auto_version(base_url(&#39;assets/admin/images/apple-touch-icon.png&#39;)); ?&gt;&quot;&gt;
&lt;link rel=&quot;icon&quot; type=&quot;image/png&quot; sizes=&quot;32x32&quot; href=&quot;&lt;?php echo $this-&gt;common-&gt;auto_version(base_url(&#39;assets/admin/images/favicon-32x32.png&#39;)); ?&gt;&quot;&gt;
&lt;link rel=&quot;icon&quot; type=&quot;image/png&quot; sizes=&quot;16x16&quot; href=&quot;&lt;?php echo $this-&gt;common-&gt;auto_version(base_url(&#39;assets/admin/images/favicon-16x16.png&#39;)); ?&gt;&quot;&gt;
&lt;link rel=&quot;manifest&quot; href=&quot;&lt;?php echo $this-&gt;common-&gt;auto_version(base_url(&#39;assets/admin/images/site.webmanifest&#39;)); ?&gt;&quot;&gt;
&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;

Step 6 : Download upup.min.js file from &lt;a href=&quot;https://github.com/TalAter/UpUp/raw/master/dist/upup.zip&quot;&gt;https://github.com/TalAter/UpUp/raw/master/dist/upup.zip&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;

Step 7 : Upload upup.min.js and upup.sw.min.js files to folder directory assets/admin/js.
&lt;br /&gt;&lt;br /&gt;

Step 8 : Edit upup.sw.min.js file, press control + F find keyword &quot;sourceMappingURL&quot;. Edit it become //# sourceMappingURL=/assets/admin/js/upup.sw.min.js.map&lt;br /&gt;&lt;br /&gt;

Step 9 : Edit upup.min.js file, press control + F find keyword &quot;sourceMappingURL&quot;. Edit it become //# sourceMappingURL=/assets/admin/js/upup.sw.min.js.map&lt;br /&gt;&lt;br /&gt;

Step 10 : Edit upup.min.js file, press control + F find keyword &quot;service-worker-url&quot;. Edit it become service-worker-url&quot;:&quot;/assets/admin/js/upup.sw.min.js&lt;br /&gt;&lt;br /&gt;

Step 10 : Application/Views/secure/inc_footer.php add the following code :&lt;br /&gt;
&lt;textarea style=&quot;height: 80px; width: 670px;&quot;&gt;&lt;script src=&quot;&lt;?php echo $this-&gt;common-&gt;auto_version(base_url(&#39;assets/admin/js/upup.min.js&#39;)); ?&gt;&quot;&gt;&lt;/script&gt;
&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;

Step 11 : Edit the php page that you want PWA open at first page. (For example, My case Application/Views/Secure/track_wk.php) add the following code&lt;br /&gt;
&lt;textarea style=&quot;height: 120px; width: 670px;&quot;&gt;&lt;script&gt;
UpUp.start({
       &#39;content&#39;: &#39;&lt;html&gt;&lt;body&gt;&lt;h1&gt;Top Hotels in Rome&lt;/h1&gt;&lt;p&gt;Villa Domus&lt;/p&gt;&lt;p&gt;Hotel Trivelli&lt;/p&gt;&lt;/body&gt;&lt;/html&gt;&#39;
          });
&lt;/script&gt;
&lt;/textarea&gt;&lt;br /&gt;&lt;br /&gt;

Step 12 : Check if any bug by using the following 2 difference methods :&lt;br /&gt;
a) google chrome browser open your website and right click on page and select &quot;Inspect&quot;. Then follow instruction on the screenshot below :&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzibuM3kPtrX9QZXHUCDzohgMfnyx_QYjq03bfWVjRN1fedzmwFgNs6bmdBO4FBSvZKzE5kRPY8cJibcrZqkGoasTgtmOneyj58Y467DS9LbDhtiZDdhKuUrvgSJYQJ8dk_kAs54x2MH9W/s0/checkPWAbug.jpg&quot; style=&quot;display: block; padding: 1em 0px; text-align: center;&quot;&gt;&lt;img border=&quot;0&quot; data-original-width=&quot;700&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgzibuM3kPtrX9QZXHUCDzohgMfnyx_QYjq03bfWVjRN1fedzmwFgNs6bmdBO4FBSvZKzE5kRPY8cJibcrZqkGoasTgtmOneyj58Y467DS9LbDhtiZDdhKuUrvgSJYQJ8dk_kAs54x2MH9W/w700/checkPWAbug.jpg&quot; width=&quot;700&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;

b) Using google chrome browser plugin &quot;Lighthouse&quot; or 3rd party website &quot;WebPagetest Lighthouse Test&quot; to check if any bug or error :
&lt;a href=&quot;https://pwa-for-wp.com/docs/article/how-to-check-pwa-is-working-or-not/&quot;&gt;https://pwa-for-wp.com/docs/article/how-to-check-pwa-is-working-or-not/&lt;/a&gt;&lt;br /&gt;&lt;br /&gt;

</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/8996489571994597062/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/8996489571994597062' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/8996489571994597062'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/8996489571994597062'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2021/05/web-app-pwa-for-codeigniter.html' title='Web App PWA for Codeigniter'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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/AVvXsEgzibuM3kPtrX9QZXHUCDzohgMfnyx_QYjq03bfWVjRN1fedzmwFgNs6bmdBO4FBSvZKzE5kRPY8cJibcrZqkGoasTgtmOneyj58Y467DS9LbDhtiZDdhKuUrvgSJYQJ8dk_kAs54x2MH9W/s72-w700-c/checkPWAbug.jpg" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5619550813183664888.post-4558061142930686047</id><published>2021-05-04T12:13:00.012+08:00</published><updated>2021-05-05T19:13:22.745+08:00</updated><title type='text'>Creating Track page for WL and ZC</title><content type='html'>Controller folder has 2 pages :&lt;br/&gt;
1) Track_wl.php&lt;br/&gt;
2) Trac_wl_hist.php&lt;br/&gt;&lt;br/&gt;

View folder has 2 pages :&lt;br/&gt;
1) track_wl.php&lt;br/&gt;
2) trac_wl_hist.php&lt;br/&gt;
2) trac_wl_add.php&lt;br/&gt;&lt;br/&gt;

asset/js folder has bootstrap-fullscreen-select.min.js&lt;br/&gt;
secure/inc_footer.php has :&lt;br/&gt;
&lt;textarea style=&quot;height: 50px; width: 670px;&quot;&gt;
&lt;script src=&quot;&lt;?php echo $this-&gt;common-&gt;auto_version(base_url(&#39;assets/admin/js/bootstrap-fullscreen-select.js&#39;)); ?&gt;&quot;&gt;&lt;/script&gt;
&lt;/textarea&gt;
&lt;br/&gt;&lt;br/&gt;

asset/css folder has bootstrap-fullscreen-select.css&lt;br/&gt;
secure/inc_header.php has :&lt;br/&gt;
&lt;textarea style=&quot;height: 50px; width: 670px;&quot;&gt;
&lt;link href=&quot;&lt;?php echo $this-&gt;common-&gt;auto_version(base_url(&#39;assets/admin/css/bootstrap-fullscreen-select.css&#39;)); ?&gt;&quot; rel=&quot;stylesheet&quot;&gt;
&lt;/textarea&gt;
&lt;br/&gt;&lt;br/&gt;

application/libaray/commond.php file has the code :&lt;br/&gt;
&lt;textarea style=&quot;height: 600px; width: 670px;&quot;&gt;
  function secondsToTime($seconds)
        {
            $secondsInAMinute = 60;
            $secondsInAnHour = 60 * $secondsInAMinute;
            $secondsInADay = 24 * $secondsInAnHour;
        
            // Extract days
            $days = floor($seconds / $secondsInADay);
        
            // Extract hours
            $hourSeconds = $seconds % $secondsInADay;
            $hours = floor($hourSeconds / $secondsInAnHour);
        
            // Extract minutes
            $minuteSeconds = $hourSeconds % $secondsInAnHour;
            $minutes = floor($minuteSeconds / $secondsInAMinute);
        
            // Extract the remaining seconds
            $remainingSeconds = $minuteSeconds % $secondsInAMinute;
            $seconds = ceil($remainingSeconds);
        
            // Format and return
            $timeParts = [];
            $sections = [
                &#39;day&#39; =&gt; (int)$days,
                &#39;hour&#39; =&gt; (int)$hours,
                &#39;minute&#39; =&gt; (int)$minutes,
                &#39;second&#39; =&gt; (int)$seconds,
            ];
        
            foreach ($sections as $name =&gt; $value){
                if ($value &gt; 0){
                    $timeParts[] = $value. &#39; &#39;.$name.($value == 1 ? &#39;&#39; : &#39;s&#39;);
                }
            }
        
            return implode(&#39;, &#39;, $timeParts);
        }
&lt;/textarea&gt;</content><link rel='replies' type='application/atom+xml' href='http://ye5.blogspot.com/feeds/4558061142930686047/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://www.blogger.com/comment/fullpage/post/5619550813183664888/4558061142930686047' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/4558061142930686047'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5619550813183664888/posts/default/4558061142930686047'/><link rel='alternate' type='text/html' href='http://ye5.blogspot.com/2021/05/creating-track-page-for-wl-and-zc.html' title='Creating Track page for WL and ZC'/><author><name>zac1987</name><uri>http://www.blogger.com/profile/16794326033729613715</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></feed>