Budget Homes

Drupal

Drupal

• Drupal - Two column node list- Normally drupal node list is single column only. We can change number of columns for node list display. In this site nodes are displayed in 2 column. This I did by hacking node.module. This can be done by CSS and at template level. I feel comfortable with coding, I hacked node.module. I am now progressing well in templates and css. Here is the code for node.module(function node_page_default - line 2010) to achieve multi column node list. ------------------------ /* //----G commented for two column list while ($node = db_fetch_object($result)) { $output .= node_view(node_load($node->nid), 1);
• Drupal Search without temporaty tables- Solution for godaddy hostings- Many drupal lovers getting trouble at godaddy for search module. when user try to search they will get error message as not able to create temporary tables. I have hosted http://blogya.in in godaddy shared hosting account. I made some tweak to enable the search module working without temporary tables. User can search and get results. This is a temporary or may be a permanent solution, if your site has no very high traffic. Because as long as no concurrent request to search, this will work perfectly. AADDSS My hack in Search module works well as long as there is no concurrent request for search. Which means, within a fraction of second, if more than one request for search will go awry. We can fix this concurrent request for search if 'LOCK TABLE' previllege is given. I guess godaddy has not given 'LOCK table' too.
• mysql remotehost localhost- I have come across a question recently. I am presenting that here. If you have any idea and suggetion, please feel free to feed it here. We connect to mysql from php. Normally both php and mysql running in same machine. Sometime mysql running is some othere server. We connect to same server by mysql_connect('localhost',,,,) and mysql_connect(XXXX,,,,) where XXXX may be remote server's IP address or remote server URL. My question is there any difference between localhost and remotehost connection? like Speed, performanace, etc. If the portal has more traffic and lot of heavy transactions are there then, seperating the php and mysql is a good performance optimization. So the apache server's CPU resource is left to handle php process and free from mysql processings. Mysql load will be handled by another server. So Two CPUs handle php and mysql respectively. Load is distributed. But at the same time mysql should be connected thru LAN or WAN not interenet(http protocol).
• Search Engine Keywords Tracking in Drupal- Everybody knows how it is important to index site in search engine. For better search engine results, we have to keep monitoring how visitors are coming to our site. If your site draws visitors mainly from search engine results, you must know what keyword is typed to reach your page. AADDSS Drupal has such a great tool to track keywords used in search engine. Statistics and Log are useful modules for tracking the keywords. Referrer links in statistics can be useful to study it. But it is showing all the referrer, including 'self referrer'. We can avoid self tracking referrer by hacking the the statistics module.
• Drupal Mobile Browser Theme made easy- Creating a drupal theme for mobile phones is not technical issue. It is methodological issue. We have to change our approach while designing theme for mobile phones. I remember few years back, I set the width of a website to 800/777 pixel. Then to 1000/1025 pixel. Width increased when the monitor's resolution increased. The width of a webpage is decided by the resolution of the monitor. As far as mobile phones assume that we have a 'monitor' its width is 200 pixel (average). We have to design a webpage within the 200x200 resolution. This is the approach we have to follow when designing websites for mobile phones.
• Mobile Browsing- Converting normal websites to 'mobile browsing' is really needed? If needed, how to implement it easily? Right now there is no such traffic or data transfer from mobile devices like desktop or laptop. There is no guarantee that people will switch to mobile browsing to surf the internet as on date. If we compare the previous history of desktop browsing, I predict sooner or later mobile phones will be used for browsing more than desktop computers. Desktop browsing increased when the bandwidth capacity increased by Internet Service Providers (ISP). Because of the high speed broadband connections at affordable cost, video and audio streaming is made possible to the internet.
• Drupal SEO- Today I meet one of my Internet dwelling friend. He does many research in internet. He is a SEO specialist. He is a blogger. He told wordpress is best for Search Engine Optimization during the discussion. He suggested to use Wordpress for blogging instead of Drupal. But I disagree. I always use Drupal for anything and everything. It feel it is a multi purpose framework. Lot of contributed modules are there. Drupal has few special modules for search engine optimization. 'URL Alias' and 'Path Auto' are best for generating search engine friendly urls. These modules convert page title into url. This requires mod-rewrite enabled apache server.