I recently found a lot of Instagram pages that publish helpful phrases and idioms in English. Since it is almost impossible to find something we need and do not remember, I decided to collect and publish them in a searchable table here. The table inside this page is not suitable for mobile, Please view it on a PC. This is my third year living in Australia, and every day I feel more than yesterday that I should speak English the way people do here, not how I learned them before. I will check each of these phrases with my Australian friends and identify common in Australia. In addition, a free picture dictionary site in 4 languages is available for free
Category: Web
MySQL database, table name, table size in MB, number of records
I am busy with a big database these days, and I need to know more about its structure and size. This MySQL query helps you to find a database List of table names Number of rows () Number of columns It is a real time saver for me, so I shared it with you. SELECT `main`.`table_name` AS ‘table’, `table_rows` AS `rows`, ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)`,`colnum`.`columns` FROM`information_schema`.`tables` AS `main` JOIN (SELECT count(*) AS `columns`, `table_name` FROM `information_schema`.`columns` GROUP BY `table_name`) AS `colnum` ON `main`.`table_name` = `colnum`.`table_name` WHERE `main`.`table_schema` = ‘your_database_name’ AND `main`.`table_type` = ‘BASE TABLE’ ORDER BY `table_rows` DESC

PHP Function for Colour Text to HEX Code
In a PHP project database, there was a text filed for colours that should be shown as a background colour of a box in front of the product name. Stored colours were like these: Blue BLUE Tomato Beech Flame Red Salmon … That some of them were not a standard colour for HTML, I searched the Internet for the colour to the HEX code table, and I added some non-standard but recurrent colours on that project like: Wood Charcol Gun Metal United Nations Blue … to this PHP function, you can add yours <?php function colourtexthex($colour_text) { // colour text to HEX code $colours = array ( ‘aliceblue’ => ‘F0F8FF’, ‘aluminium’ => ‘848789’, ‘antiquewhite’ => ‘FAEBD7’, ‘aqua’ => ’00FFFF’, ‘aquamarine’

Smarter Tech
This is the 11th month that I am in Australia; during this time, I tried to learn more about the Australian online market. I learnt that besides giants companies that have very advanced tools in digital marketing, there are many small companies with old fashioned web sites that their web site does nothing for them. After ten months, I decided to register my business name here, I named it Smarter Tech. Smarter Tech goes to show smarter and simpler ways to small businesses to promote their online activities. Smarter Tech services for the first year of its activity will be: Fast and reliable web hosting Web Development Digital Marketing WordPress Plugins For Online Shops Actually I am going to gather

swiftprice.com.au and Australia market
swiftprice.com.au is a modified version of the ghaimat project for the Australian market. This site monitors 11K products right now and has been designed to monitor millions of products in 2021. The SwiftPrice helps Australian customers to find better and cheaper prices for goods and services inside Australia. Unlike large sites like Google which only show great site prices, Swift Price allows small sellers to easily display their prices on the site. It is enough for a small online business owner to contact the site owner and submit their inquiry. Find some online prices here :

Afghan Village Restaurant a new website and digital marketing
I am proud to say I created a new website for Afghan Village Restaurant. This restaurant location is in Camberwell, Melbourne and its new manager is Ms Ghavidel. The restaurant was started its activity in 2001, and some famous people like Stephen Downes, Lianne Tolra, Janne Apelgren and Matt Preston have written a review about it. A good history and experienced team of Afghan Village Restuarant brings them new and loyal customers every week. But like any other business in the 21st century, old and conventional methods should be boosted with “Digital Marketing” to be more effective. I started my job with a simple and mobile-friendly website. Unfortunately, I haven’t the chance to visit Melbourne and the restaurant place so as

Easy Host Way Australia
Easy Host Way Australia created a new website for Aussie customers. The new website address is easyhostway.com.au . All prices on this site are in the Australian Dollar, and the default cloud web hosting data centre (Amaze) is based in Sydney, Australia. Clients can also host their websites in four other data centres in America and Europe. Yes, Location is the matter If your websites are created for clients coming from Australia, Oceania, and New Zealand, then Easy Host Way Australia–based data centre is the ideal hosting solution for your requirements. By accommodating your websites in Australia, you are going to provide the best available website streaming speeds for your customers from the area. All of the Easy Host Way

Interchange Shoalhaven and Me
Today, I went to Interchange Shoalhaven (a not for profit, non-government, community-based organisation) for the 3rd time. Their office location is at 37 Holloway Road, East Nowra. Today I had the chance to visit their influential team members, and then I start to analyse their website and social media current status. In a 1-hour meeting with their IT person, we set some goals for the next two months. I understood that they had done a lot of valuable jobs, and we should do some more tasks before 2020 starts. Some tasks like Increasing their site rank with SEO Decreasing their website Alexa rank to 1 million Creating some back-link to the website Doubling the Facebook page fans and followers Doubling

Eidos Consulting
A friend of mine, Mr Ian Deck, asked me to make some changes on his business web site (Eidos Consulting) and make it mobile-friendly. I made him a new website with WordPress. The new site contains both classic web pages and modern one-page style. Ian is a brilliant guy and asked me to teach him WordPress, and We spent 3 hours in two sessions, and then he modified some texts, added some pictures and statistics to his site. Yesterday he wrote to me “I spent some time last night and this morning getting myself confused with structure and links within the website, but I reckon it’s now good enough to ‘go live’” I am happy that “Eidos Consulting” new website

I am happy with PHP
It was Feb 2018 that I decided to switch PHP. Because of the lovely W3Schools site, learning the PHP was easy to start. In the second week, I tried to write some codes in Notepad++, and then I started to use Eclipse. After two months, I created a simple website (Gheimat.xyz [view it on the arichive.org], a Telegram robot (https://t.me/Gheimatxyz_bot), and a WordPress plugin (Warehouse updater from an external XML for Woocommerce). For ten months, I was mostly busy with my professional online shopping system. I helped some companies to maintain their WP sites. I took more photos, passed food and industrial photography courses, and I attended professional photo editing classes. In other words, I have no free time to

This site needs your help
Today, I published the above picture “this site needs your help” to my Instagram account to ask my followers to support my web site. As Instagram is an easy to use application and many people all around the world have it on their mobile phones, so each good picture will collect 10s or 100s even millions of likes in a few hours. Unfortunately adding links to Instagram posts is not possible! I am glad to inform you that this request has collected six likes in 30 minutes, I predict that this picture would raise more than 50 likes in next 24 hours (about 60% of the average number of likes on my photos posted on Instagram). Thank you, dear followers! Anyway,

Online Shop removed
It was a hard decision, but I had no cure except removing Online Shop from my site. Managing a multilingual site in WordPress is not as easy as I was thinking at first. More than two years, I had used qTranslateX for this purpose, and I have had many unexpected problems with it. Finally, I decided to use WPML, migrating to WPML was a tough process and after I thought that everything is OK, I found more than 6000 unwanted categories in my Woocommerce shop! Removing these unwanted categories was something possible, but I think handling a multilingual online shop with open source tools like WordPress and Woocommerce need someone to work full time on them. As I am too

My first 360 picture test
The below image is my first 360 picture test; It works fine in Google Street View, Facebook 360 and my site. Please wait a moment to picture be loaded completely, then move it by mouse, If you are loading it on your tablet or phone, move it. You can see the map of the place I took the picture:

URL Shortener
Sometime in Iran, we should re-invent the wheel! Unexpectedly I understood that none of my “bit.ly” Short URL doesn’t work because this site is blocked by the Iran government. For a while, I used goo.gl, but bit.ly gives customers more professional services like a hosted domain name. Finally, I decided to set my URL Shortener. I chose sml.yt for the domain name and installed specified software for it. I hope everything is OK now. Why should we use an URL Shortener? There are five reasons on (http://sml.yt/o) 1. They make links more manageable 2. They can track and compile click data 3. They can be transformed into social media services 4. They can provide users useful features 5. They promote

Team Photo Blog – MycamTalks
Yesterday I installed WP on MyCamTalks.com (a team photo blog in English and Persian). I also uploaded some photos and their description for the test. Javaneh Azimi and I have created this photoblog to have better communication with people all around the world. We strongly believe that Instagram and other social media cannot cover our needs. However, we will continue to upload and share our contents on other apps, but complete contents and large-size photos will only be uploaded to this site. We (current and future website members) will upload daily photos there, there is no limitation about the subjects and location of pictures, but the members will take pictures. So you should expect many original photos there.

Domains for Sale
I have 10s of active domains and some of my domains are ready to sale Please view the domains for sale domain list here https://flippa.com/domain-catalogs/45022 Please put your offers via flippa.com There are some other domains that are not listed there like: www.iranmap.asia Price: 150 USD

Online Multilingual Picture Dictionary
The “Online Multilingual Picture Dictionary” test site is available on www.picturedictionary.com.au. This picture dictionary contains some languages and is developing by a dynamic team of languages and culture lovers. I have been on the consultant team, and now I try to introduce this test site by social media. Javaneh Azimi and I (the project owner and developer) idea for this project is: If people know more about other languages and cultures, they will understand each other more, and this will cause a decrease in regional and international conflicts. Please keep your fingers crossed for this aim. Thank you

Liana Italian Restaurant
Liana Italian Restaurant beta web site is active now. People who lives in eastern part of Tehran can order online via: http://www.lianarestaurant.com Site is active in Persian and English now and in coming week some other feature will be added to it.

1000 daily visitors up to march 2016
I know that having a real challenge will cause that I enjoy from my life, always should be something to fight for. I knew that I have not written on my weblog for a while, and unfortunately, recently, I just used social media to write and publish my notes and pictures. Recently I seldom write about my hobbies and job activities. As tomorrow is not promised to anyone, So I am going to publish at least three posts per week. I hope the new procedure helps me to have about 1000 daily visitors instead of current 10-15 visitors up to March 2016.

Advertisement system and search engine robots
Last week I re-activated my old advertisement system on one of our company’s high traffic sites. And after one day I understood that the number of views and clicks are not reasonable, I mean they were ten times higher than I expected. When I checked the raw site logs, unexpectedly, I found about 80% of the site traffic belonged to search engine robots and crawlers!!! Not only famous American ones like Google, Bing, and Yahoo but also Russian Yandex, Chinese Baidu, and Iranian Yooz were very active on the site. There were two solutions for solving the problem: 1. Blocking search engine traffic and preventing their robots and crawlers to indexing my site, an expert knows this action means suicide