Category: Scripting

Server, Web, Web Technologies

FIX: SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: NO)

Error: SQLSTATE[HY000] [1045] Access denied for user ‘root’@’localhost’ (using password: NO) Scenario: After very first setup of your own wamp/xamp with MySQL DB and updated password for DB root user, you notice that your php code fails to connect/communicate to the mySQL DB with above error.   CAUSE and FIX: This error message indicates that you are attempting to connect/logon to the MySQL with reported user “root” without specifying any password or it’s password value is NULL.   To fix it, you need to provide the appropriate root user password for on your MySQL DB connection string or call.   […]

Read more
Scripting

Installing, Configuring PHP and Running PHP scripts

In order to run PHP on your Windows system, you can simply have the required version of regular or debug PHP zip files and extract them.  And then ensure that extracted location is in %PATH% so that Windows starts picking up that particular version of php by defult for running .php scripts/files locally. Example: On the same system you can run multiple versions of PHP side-by-side. C:>php -v PHP 5.3.24 (cli) (built: Apr 10 2013 18:32:42) Copyright (c) 1997-2013 The PHP Group Zend Engine v2.3.0, Copyright (c) 1998-2013 Zend Technologies C:>php-5.5.6php.exe -v PHP 5.5.6 (cli) (built: Nov 12 2013 11:35:48) […]

Read more
Scripting, Web, Web Technologies

Understanding how URLs are linked to Code in the HTML pages

Whenever we launch a website in the browser, it then gets modified as we navigate the other elements on that web site page.  We notice that, the modified URL will mostly have the website actual website but with more strings attached to it starting with a ?. Example: We open a main web site  page say http://www.yahoo.com/ Then we navigate to Yahoo mail login page: https://login.yahoo.com/?.src=ym&.intl=us&.lang=en-US&.done=http://mail.yahoo.com    In the above we see the web site of yahoo.com is having URL with   https://login.yahoo.com/   +  ?  + .src=ym&.intl=us&.lang=en-US&.done=http://mail.yahoo.com   This process of URL modification is called the URL encoding.  This is […]

Read more