Ivan's Blog


Lets learn new things!

Excel to MySQL: nice tool

For some official purpose sometimes we have to use excel. But if any one don’t know excel formulas very much, then its better to convert data to known technology like MySQL. I know MySQL data query, but don’t know excel query or formula much. So i used this tool: Excel to MySQL converter. http://panofish.net/convert-import-excel-spreadsheets-into-mysql-database/ This tool is very useful and … Read More


Megento: for ecommerce website

I recently prepared my 1st ecommerce website demo in megento. This PHP framework looks very easy to install. Megento and Zend are working together [link]. Zend is another PHP framework. One of the nice features is sample data provide bye megento community. Download: http://www.magentocommerce.com/download Magento Installation Guide Installing_on_windows_with_xampp_and_wamp Installing-the-sample-data-for-magento Initial frontend [build in theme] and backend [admin panel] looks very … Read More


[w3school]HTML5 Quiz questions

W3Schools HTML5 Quiz 1. What is the previous version of HTML, prior to HTML5? 2. Which doctype is correct for HTML5? 3. In HTML5, which element is used to group heading elements? 4. Which of the following elements is no longer supported in HTML5? 5. Which of the following elements is no longer supported in HTML5? 6. In HTML5, onblur … Read More


Yii 1.1: A simple and high performance PHP framework

In my previous company (DSI), I got opportunity to work with Yii(PHP framework). In that time I realized that framework makes life so much easy(its developer’s life). One of the main reason to learn or work with this framework is its documentation is very nice. Anyone can get help from their forum also. I also read some contents of this … Read More


[Code]How to parse some text from a file to another file

Code in C: If we download address book from SKYPE then we want to separate only the skype ids then we can do this simple code: ################################################################### #include “stdio.h” #include “string.h” #include “conio.h” int main() { static const char filename[] = “skypeDownloaded_IDS.txt”; FILE *outputFile = fopen(“save_all_id.txt”, “w”); char compareLine []= “X-SKYPE-USERNAME:”; bool flag = 0; int i=0; FILE *file = … Read More


Viva questions for PHP(Web developments)

Why you want to change your company/job? Difference between left join and right join. How many types of states in ajax? Comparison of MySQL database engines.


Some other useful command for windows

To show the run command box : Windows key+R There are some commands we can use in the run command box: calc = To open calculator. tree = For refreshing all drives and folders. mspaint = To open paint software msconfig = To open system configuration utility notepad = To open notepad. notepad++ = For open notepad++(if notepad++ software installed … Read More


Some useful widows commands

Actually I use Ubuntu operating system almost 1.5 years for official work. That time I really enjoyed working in Ubuntu 10.04 LTS version. That was a stable version of Ubuntu. That time also other Ubuntu versions are released 10.11, 11.04, and 11.11. But all are not as stable as 10.04. The main facility was using Ubuntu system, the rich command … Read More


Some common shortcut and website

 Some common shortcut that we know: Here I am sharing some common shortcut I use and most software use this shortcut. Ctrl+A Select all Ctrl+C copy some content Ctrl+P past some content Ctrl+X cut some content Ctrl+Z undo the last action Ctrl+F find something Ctrl+W close a window or tab Ctrl+O open an existing file Ctrl+N open a new file … Read More


Basic Web developer Viva Questions

1. Difference between GET and POST: => Form submission method both GET and POST. => As in GET method the form data are passing to server by a query string, so data size is limited and only ASCII character are only allowed. The HTTP-GET protocol creates a query string of the name-and-value pairs and then appends the query string to the … Read More