How to access Mysql Database using PDO:
PHP is changing day by day. in old days we were use mysql_connect(...) but now in current days it is not supported. current days we can use mysqli_connect(...). but it is better if we use PDO (PHP Data Object).
PHP Data Objects (PDO) is a very lightweight, consistent interface for accessing different types...
Saturday, October 31, 2015
Thursday, October 29, 2015
PDOException' with message 'SQLSTATE[42000 Syntax error or access violation: 1064
Problem:
How to fix following PHP PDO error
exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line
Solution:
It means you are missing small brackets ')' in your...
Tuesday, October 20, 2015
Video Watermark Remover
Problem:
Some time you have many videos that has watermark. you just hate that watermark and need to delete it. There are many watermark remover software but all are not free. so if you want a free video watermark remover then you are at present here right place.
Solution:
I...
Monday, October 19, 2015
Microsoft Office Interop Outlook
Problem:
Where to find library of Microsoft.Office.Interop.Outlook?
Solution:
To locate library of Microsoft.Office.Interop.Outlook you should look into below 2 folders:
C:\Program Files (x86)\Microsoft Visual Studio 12.0\Visual Studio Tools for Office\PIA\Office14
C:\Program Files (x86)\Microsoft Visual Studio 12.0\Visual Studio Tools...
Friday, October 16, 2015
mongoDB on windows 7
Problem:
While installing mongoDB on windows 7 you will get the same message as below:
I CONTROL Hotfix KB2731284 or later update is not installed, will zero-out data files
I STORAGE [initandlisten] exception in initAndListen: Data directory C:\data\db\ not found., terminating
I CONTROL [initandlisten] dbexit: rc: 100Solution:
Solution:
you...
Wednesday, October 14, 2015
how to check if visitor is a robot or bot
Problem:
how to check if visitor is a robot or bot?
Solution:
Please use below code
Example:
$user_agent='';
if( !isset( $_SERVER['HTTP_USER_AGENT'])){
echo 'i m a Robot!';
die();
} else {
$user_agent=strtolower($_SERVER['HTTP_USER_AGENT']);
}
$robot='N';
if(strpos($user_agent,'bot')>0 || strpos($user_agent,'Bot')>0) {
...
Tuesday, October 13, 2015
Currency convertor
Problem:
Some time you need to convert currency into different countries, so what you will do?
Solution:
You can use yahooapi
Example:
Use below code. the code is in PHP ou can easily convert it into VB.Net, Java, C# etc if you are good programmer.
function curr_convert($ffrom,$tto,$iinput) {
$yql_url = "http://query.yahooapis.com/v1/public/yql";
...
Posts
