tag:blogger.com,1999:blog-61050634042303741332023-12-12T16:21:34.494+01:00CodingForLiving( ...args ;-)This is an effort to share some of my knowledge about programming issues or problems I encounter.
I work with a small Company, and I am in charge of developing and fixing most of it's IT solutions.Unknownnoreply@blogger.comBlogger7125tag:blogger.com,1999:blog-6105063404230374133.post-73032524638798725592011-06-26T16:11:00.002+02:002011-07-08T23:46:40.938+02:00MySQL - avoid beginner traps
Photo by pcambraf
When my client's project (http://connectotravel.com) got online and started to chew real data, we found out that some functions perform too slow.
I started to evaluate application code and performance, using CodeIgniter Profiler class. It revealed that some SQL queries were too slow.
Some of it had unnecessary tables, left hanging there after quick development without enoughUnknownnoreply@blogger.com0tag:blogger.com,1999:blog-6105063404230374133.post-77585503043117092222011-06-02T16:09:00.000+02:002011-06-02T16:15:13.554+02:00Database management by single PHP fileYesterday I found myself in situation when I had to look for something else regarding MySQL database administration. Google search led me to something surprising. It is named "Adminer" and it exists in one single PHP file.
On it's web page, it has a detailed comparison with similar, well known tool, PhpMyAdmin which I had been using for years.
http://www.adminer.org/en/phpmyadmin/
I decided toUnknownnoreply@blogger.com1tag:blogger.com,1999:blog-6105063404230374133.post-47711760805356840662011-05-18T21:59:00.000+02:002011-05-18T22:01:16.162+02:00Recover lost page in DrupalDid you ever lost a page, in Drupal CMS, without having a backup copy?
It happened to us yesterday.
While working on repeating and rather boring task of pasting a chunk of the same code in many existing pages, my co-worker made a mistake and deleted content of a very important page.
It took us some time to realize what exactly the problem was. Since it was the front page, we thought that the Unknownnoreply@blogger.com1tag:blogger.com,1999:blog-6105063404230374133.post-6664446485592340982011-05-17T22:22:00.000+02:002011-05-19T18:37:18.307+02:00Why I love DrupalSome two years ago, I was starting as a web developer. The same job I work today.
I did not have much experience at real web programming work, only by doing some occasional jobs.
My task, among the rest, was to make a website consisting of some hundred pages. But the real problem is that it supposed to have 115 pages in ONE SINGLE language. Since it was a tourist and traveling services web, it Unknownnoreply@blogger.com2tag:blogger.com,1999:blog-6105063404230374133.post-27477732097643532642011-03-23T23:22:00.000+01:002011-04-21T21:44:35.698+02:00Simple url rewriting, using Apache mod_rewriteSome customers want to have nice, fancy, search engine friendly url-s in their browser, on their pages.
That is completely reasonable because it helps to better position the pages in search results.
For instance:
www.somewbsite.com/page1.php?subject=geography&field=cont1
or
www.someanotherwebsite.net/about_us.html
is not so tasty for search engine bots like the following:
Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6105063404230374133.post-80712818968852800372011-03-12T20:23:00.000+01:002011-03-23T21:38:27.999+01:00How to make a simple web pageYou need:
- web browser (Firefox, Internet Explorer, Safari or something alike)
- plain text editor (Notepad, Vim, Arachnophilia,...).
The most important part of a web page is HTML document. That is a text document containing page formatting code (HTML tags) and page items (texts, pictures etc...).
Let us assume you use Notepad which is bundled with any version of Windows.
General plan:
Make Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-6105063404230374133.post-84563943886931823192011-03-08T23:41:00.000+01:002011-03-26T15:20:28.078+01:00Invisible troublePerhaps you never encountered this. Happened to me once before and today I managed to fix it.
We use CodeIgniter PHP Framework as main tool in our work on this particular project. Me and my co-workers are developing rather huge website.
I am not going to write it's url here, because it is not fully online yet and I would be embarrassed to let you see all it's flaws ;-)
The main page (Unknownnoreply@blogger.com1