Steps to create a connection to a local postgres database in pgAdmin ||| :
1. Make sure PostgresSql and its components should be installed in ubuntu system.
2. Check what databases are available in postgresSql through terminal
3. Login to PostresSql server in terminal using following command:
sudo -u postgres psql
With Read more…
European characters like è é å ñ ü ,à, è, ì, ò, ù – À, È, Ì, Ò, Ù, ™, © ,• , ∑, α, β, «, » do not get inserted correctly in MySQL by default. To fix it, we need to change the character set (fixed collection of symbols) and collation (set of rules that determine how data is sorted and compared).
To insert and retrieve european characters change character set to utf Read more…
Suppose we want to have columns created_date and last_modified_time with default timestamp in any table in MySQL/Phpmyadmin.
Let us take an example of Students table.
Create table Students using following query :
CREATE TABLE students(
id INT AUTO_INCREMENT PRIMARY KEY ,
first_name varchar(20) NOT NULL,
last_name varchar(20) NOT NULL Read more…
To implement Internationalization, CakePHP will pick all your strings which start with “__(“ double underscore ) and generate a default file for you.
For Example: one of the strings defined in our project is as below:
echo __ ( ‘ Gift Cards Not available’ );
Replace all your normal string with (__ Read more…
In this post I will give an example of how to perform search with Selenium script on a webpage. Below is the screenshot of the webpage:
Code to automatically enter a keyword “paint” in the textbox and then click Search button (or enter key) is given below. Go through the Read more…
We can’t use special characters like >,<,”,’ etc directly in code because browser mixes these characters with HTML tags and gets confused. So we can use HTML entities if we want to use special characters in our code.
Below are some common entities which we can use Read more…
How to show Caret symbol on hover event in the Bootstrap navigation bar as shown in the figure below:
Solution: We created a bootstrap navigation bar with ul and li tags. One of the li element within the ul for reference is given below:
<ul class=”row Read more…
var test = [“test1”, “test2”, “test3”];
Now create a hidden variable in HTML. This variable will Read more…
Most of the times when we get memory exhausted error, we normally think that the memory allocated for php program execution in php.ini file is not sufficient and raise this limit to try to fix the error.
However, code inefficiency could be the reason behind the error. Some examples Read more…
Selenium Webdriver lets us locate elements in a web page in many different ways. Some of them are:
By id: If the HTML element to be located has a unique id one can use this id to locate the element in the code. Java statement for this will Read more…
Following is the code to add Combobox in editable data grid:
<table id=”dg” title=” Combobox in editable datagrid ” style=”width:100%;height:700px”
toolbar=”#toolbar” pagination=”true” rownumbers=”true” fitColumns=”false” singleSelect=”true” autoSave=”true” data-options=”pageSize:50″>
< Read more…
Suppose on an HTML page we have a list of menu items as shown in the image on the left below (Customers, Projects, Invoices etc) and on hover over these menu items we need to change the background color to green, like shown in 2nd image:
This is the sample Read more…
1. Fetching coordinates of current location of the mouse:
Below is the code to retrieve the coordinates of the mouse at any position on the webpage and display inside a div with id getCoords:
$(‘#getCoords Read more…
The Read more…
In order to add text over an image, following PHP code can be used. Read the comments to understand purpose of code statements:
header (“Content-type: image/jpeg”); //setting the content type
//variable containing the string to be written on the image
$txt = “Here goes the text to Read more…
<apex:outputtext value=”Amount” id=”amntId”/>
<span id Read more…
Have a look at this folder structure:
Now in Abc.php file, try to include Qwerty.php using the following code:
It will give this error:
Fatal error: Failed opening required Read more…
These are the steps to install CakePHP 3.0 on Ubuntu machine:
Make sure you have PHP 5.5.9 (CLI) or higher installed. Check php version on your system using this command:
Run the following commands:
1. Download the composer installer in your Read more…
1. Turn editing On and click on the settings icon of the administration block as shown below:
2. Click on configure Administration link. This screen will open:
3. Change the drop-down value from “Assessment information page” to “ Edit Assessment page” so that only admin users could see this block Read more…
With recent evolution in CSS, we can try animations. Below is a sample code where in which have used latest CSS features and will give the illusion of animation. Just copy paste the code below in an HTM file and and view it in browser.
< Read more…