Why PostgreSQL? The purpose of this article is to give you an idea about PostgreSQL. Most probably this will be an introduction for you. I will be providing a lot of links through out the article. Make sure to check those out . Let me start like this. I have been a MySQL fan for a long time & ...
Why PostgreSQL? The purpose of this article is to give you an idea about PostgreSQL. Most probably this will be an introduction for you. I will be providing a lot of links through out the article. Make sure to check those out . Let me start like this. I have been a MySQL fan for a long time & I ...
Why? When To? Software Design Patterns. Interesting topic right? Software Design Patterns Explained Let’s 1st talk about software design patterns. Software design patterns can be defined as recurring solutions to common problems in software design. You might be wondering how does your application work without design patterns if this’s so important. The main point to understand is that if your application doesn’t contain ...
Why? When To? Software Design Patterns. Interesting topic right? Software Design Patterns Explained Let’s 1st talk about software design patterns. Software design patterns can be defined as recurring solutions to common problems in software design. You might be wondering how does your application work without design patterns if this’s so important. The main point to understand is that if your application doesn’t contain ...
Why hybrid mobile application development is so awesome? Why everyone is talking about hybrid mobile applications today? Why does it matter so much? What are the frameworks available to develop a hybrid mobile application? If you are a web developer wondering about how to become a mobile app developer this is for you. In this article you will get the ...
Why hybrid mobile application development is so awesome? Why everyone is talking about hybrid mobile applications today? Why does it matter so much? What are the frameworks available to develop a hybrid mobile application? If you are a web developer wondering about how to become a mobile app developer this is for you. In this article you will get the ...
Have you ever got this MySQL error? Oh! You are searching for a solution right? You have come to the right place. Let me give you the simplest answer and it works charm. For the time being assume that this is your query. DELETE FROM table_name where coulmn_name IN (SELECT coulmn_name FROM table_name WHERE coulmn_name > 10); What you can do is change the ...
Have you ever got this error? Oh! You are searching for a solution right? You have come to the right place. Let me give you the simplest answer and it works charm. For the time being assume that this is your query. DELETE FROM table_name where coulmn_name IN (SELECT coulmn_name FROM table_name WHERE coulmn_name > 10); What you can do is change the ...
Indexes! Whooh! Let me tell you what my experience about indexing a table. I had a SQL query which took 8-9 secs to fetch the data I want. After indexing now it only takes 1 sec. Interesting right. Let’s go through what’s indexing and how to and when to and stuff. You could find technical explanation of indexes in ...
Indexes! Whooh! Let me tell you what my experience about indexing a table. I had a SQL query which took 8-9 secs to fetch the data I want. After indexing now it only takes 1 sec. Interesting right. Let’s go through what’s indexing and how to and when to and stuff. You could find technical explanation of indexes in ...
Connect to the WordPress database via the phpMyAdmin tool at your web hosting account. Once in phpMyAdmin select the WordPress database & Open the SQL tab (look at the top navigation bar). write the following SQL query: UPDATE `wp_users` SET `user_pass` = MD5( ‘new_password_here‘ ) WHERE `wp_users`.`user_login` = “admin_username“; “new_password_here” – replace this with the new password you wish to ...
Connect to the WordPress database via the phpMyAdmin tool at your web hosting account. Once in phpMyAdmin select the WordPress database & Open the SQL tab (look at the top navigation bar). write the following SQL query: UPDATE `wp_users` SET `user_pass` = MD5( ‘new_password_here‘ ) WHERE `wp_users`.`user_login` = “admin_username“; “new_password_here” – replace this with the new password you wish to ...
Let’s take a look at what’s regular expression and it’s use in the development environment. 1st of all regular expression is a small piece of code which looks for pattern(s). In web development environment Regex are used in the .htaccess file most frequently. Regexs are supposed to make developer’s life easier but most of the time it’s the other way ...
Let’s take a look at what’s regular expression and it’s use in the development environment. 1st of all regular expression is a small piece of code which looks for pattern(s). In web development environment Regex are used in the .htaccess file most frequently. Regexs are supposed to make developer’s life easier but most of the time it’s the other way ...
Add this code where you want to put the custom search. Settings : action – set the site url cat field value – should be set to the category id whatever you want to search in(here its 5) <form method="get" id="search form" action="http://localhost/wordpress_test/"> <div> <input type="text" value="" name="s" id="s" /> <input type="hidden" value="5" name="cat" id="scat" /> <input type="submit" value="search"/> </div> ...
Add this code where you want to put the custom search. Settings : action – set the site url cat field value – should be set to the category id whatever you want to search in(here its 5)<form method="get" id="search form" action="http://localhost/wordpress_test/"> <div> <input type="text" value="" name="s" id="s" /> <input type="hidden" value="5" name="ca
So you have a larger mySQL database of more than 30 MB size, you want to move it to a new server, and you’re unable to import your database to the new server via phpMyAdmin, due to its time and size limitations. But don’t worry, its not a big problem. It can be done using a tool BigDump Here are ...
So you have a larger mySQL database of more than 30 MB size, you want to move it to a new server, and you’re unable to import your database to the new server via phpMyAdmin, due to its time and size limitations. But don’t worry, its not a big problem. It can be done using a tool BigDump Here are ...
