Coding Sparks

Ionic framework Basics - 1

2018-02-20T08:50:00.000+05:30

Ionic framework Basics - 1

1. Install Node.js

check node js is installed
Goto CMD
> type npm --> to check node js is installed
> if not install node js

2. Install git (if necessary)

3. Install Ionic:

> check ionic is installed or not
> ionic

Installing Ionic:
> install ionic cordava -install

4. Creating a blank project in Ionic:

Upto 3.19.0 ver
> ionic start myApp blank --v2

3.19.1+

ionic start saiApp blank --type=ionic-angular

saiApp >>> your app folder
--v2 >>> ionic version

5. Running an ionic App:
Goto your App folder (saiApp)
type
> ionic serve -w chrome -lab

dev server running: http://localhost:8100/

>>> Files in ionic
> src >> component.ts

> pages >> home (default)
>>> home.html
>>> home.ts

--------------------------------------------
Tips:

1. ionic start --help

2. You can downgrade to your old version by running: npm i -g ionic@3.19.0

Most Useful .htaccess Tricks for WordPress website

2017-11-18T11:14:00.002+05:30

Most Useful .htaccess Tricks for WordPress website

Some most useful .htaccess tricks for your WordPress website are here. Wordpress needs htaccess to work perfectly and runs smoothly.

Here is the htaccess code for a basic wordpress site:

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
# END WordPress

-----------

If you are using Localhost, for example:

http://localhost/codingsparks

Then htaccess is...

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /codingsparks/
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /codingsparks/index.php [L]

</IfModule>
# END WordPress

Wordpress MultiSite htaccess:

RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]

# add a trailing slash to /wp-admin
RewriteRule ^([_0-9a-zA-Z-]+/)?wp-admin$ $1wp-admin/ [R=301,L]

RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ - [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(wp-(content|admin|includes).*) $2 [L]
RewriteRule ^([_0-9a-zA-Z-]+/)?(.*\.php)$ $2 [L]
RewriteRule . index.php [L]

Reference Link: https://codex.wordpress.org/htaccess

How to avoid Access-Control-Allow-Origin error using htaccess

2017-11-17T08:45:00.000+05:30

How to avoid Access-Control-Allow-Origin error using htaccess

Add the below code in you .htaccess file.

#avoid Access-Control-Allow-Origin error using htaccess
<IfModule mod_headers.c>
<FilesMatch "\.(ttf|ttc|otf|eot|woff|woff2|font.css|css|js)$">
Header set Access-Control-Allow-Origin "*"
</FilesMatch>
</IfModule>

Update Php.ini values from htaccess

2017-11-17T00:07:00.001+05:30

Add the below code to change the default php.ini settings

1) Upload Max Filesize
2) Post Max Size
3) Max Execution Time
4) Max Input Time
5) Memory Limit

#Update Php.ini values from htaccess
php_value upload_max_filesize 512M
php_value post_max_size 512M
php_value max_execution_time 600
php_value max_input_time 600
php_value memory_limit 512M

we can also update in php.ini or .user.ini.

Remove public from Laravel using htaccess

2017-11-15T23:36:00.000+05:30

Remove public from Laravel using htaccess

RewriteEngine On

# Remove all trailing slashes
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_URI} /(.*)/$
RewriteRule ^ /%1 [R=301,L]

RewriteCond %{REQUEST_URI} !(\.css|\.js|\.png|\.jpg|\.gif|robots\.txt)$ [NC]
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^ index.php [L]

RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_URI} !^/public/
RewriteRule ^(css|js|images)/(.*)$ public/$1/$2 [L,NC]

How To Install XAMPP/LAMPP Stack On Ubuntu 16.04 64bit Step by Step

2017-08-13T08:05:00.000+05:30

Install XAMPP/LAMPP 64bit Stack Step by Step:

Step1:
Open Terminal

Step2:

Before installing the package, create a directory.
user1@user1:~$ mkdir xampp
user1@user1:~$ cd xampp/
user1@user1:~/xampp$

* it creates a folder in HOME

Step3:

Download the XAMPP/LAMPP package by using the wget command

user1@user1:~/xampp$ wget https://www.apachefriends.org/xampp-files/5.6.20/xampp-linux-x64-5.6.20-0-installer.run

Step4:

Run the following command to make XAMPP execuatable.
chmod +x xampp-linux-x64-5.6.20-0-installer.run

Step5:

Install XAMPP stack as shown below.

sudo ./xampp-linux-x64-5.6.20-0-installer.run
[sudo] password for user1:

How To Install XAMPP/LAMPP Stack On Ubuntu 16.04 32bit

2017-08-12T08:03:00.003+05:30

Install XAMPP Stack On Ubuntu 16.04 32bit

Install XAMPP/LAMPP 32bit Stack Step by Step:

Step1:
Open Terminal

Step2:

Before installing the XAMPP/LAMPP 32bit Stack package, create a directory.
user1@user1:~$ mkdir xampp
user1@user1:~$ cd xampp/
user1@user1:~/xampp$

* it creates a folder in HOME

Step3:

Download the XAMPP/LAMPP package by using the wget command

user1@user1:~/xampp$ wget https://sourceforge.net/projects/xampp/files/XAMPP%20Linux/5.6.23/xampp-linux-5.6.23-0-installer.run

Step4:

Run the following command to make XAMPP execuatable.
chmod +x xampp-linux-5.6.23-0-installer.run

Step5:

Install XAMPP stack as shown below.

sudo ./xampp-linux-5.6.23-0-installer.run
[sudo] password for user1:

Install Xampp in Ubuntu

2017-06-18T10:40:00.000+05:30

Install Xampp in Ubuntu:

Step1:

Open Terminal
Before installing the package, create a directory.
user1@user1:~$ mkdir xampp
user1@user1:~$ cd xampp/
user1@user1:~/xampp$

* it creates a folder in HOME

Step2:

wget https://sourceforge.net/projects/xampp/files/XAMPP%20Linux/5.6.23/xampp-linux-5.6.23-0-installer.run
chmod +x xampp-linux-5.6.23-0-installer.run
sudo ./xampp-linux-5.6.23-0-installer.run

https://bitnami.com/stack/xampp?utm_source=bitnami&utm_medium=installer&utm_campaign=XAMPP%2BInstaller

http://localhost/dashboard/

Check Xampp Status:

sudo /opt/lampp/lampp status

Run Xampp with Control Panel window:

sudo /opt/lampp/manager-linux.run

Run Xampp:

sudo /opt/lampp/manager-linux.run

Stop Xampp:

sudo /opt/lampp/lampp stop

You can create the backup by calling:

sudo /opt/lampp/lampp backup

Install NetBeans in Ubuntu

2017-06-18T10:36:00.000+05:30

Install NetBeans:

chmod +x netbeans-8.1-linux.sh

Now to execute it run from its directory

sudo sh netbeans-8.1-linux.sh

DBMS FAQ's

2017-06-18T10:33:00.001+05:30

DBMS FAQ's

1. What is database?

A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose.

2. What is DBMS?
It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users with the processes of defining, constructing and manipulating the database for various applications.

3. What is a Database system?
The database and DBMS software together is called as Database system.

4. Advantages of DBMS?
Redundancy is controlled.
Unauthorized access is restricted.
Providing multiple user interfaces.
Enforcing integrity constraints.
Providing backup and recovery.

5. Disadvantage in File Processing System?
Data redundancy & inconsistency.
Difficult in accessing data.
Data isolation.
Data integrity.
Concurrent access is not possible.
Security Problems.

6. Describe the three levels of data abstraction?
The are three levels of abstraction:
Physical level: The lowest level of abstraction describes how data are stored.
Logical level: The next higher level of abstraction, describes what data are stored in database and what relationship among those data.
View level: The highest level of abstraction describes only part of entire database.

7. Define the "integrity rules".
There are two Integrity rules.
Entity Integrity: States that “Primary key cannot have NULL value”
Referential Integrity: States that “Foreign Key can be either a NULL value or should be Primary Key value of other relation.

8. What is extension and intension?
Extension -
It is the number of tuples present in a table at any instance. This is time dependent.
Intension -
It is a constant value that gives the name, structure of table and the constraints laid on it.

9. What is System R? What are its two major subsystems?
System R was designed and developed over a period of 1974-79 at IBM San Jose Research Center. It is a prototype and its purpose was to demonstrate that it is possible to build a Relational System that can be used in a real life environment to solve real life problems, with performance at least comparable to that of existing system.
Its two subsystems are
Research Storage
System Relational Data System.

10. How is the data structure of System R different from the relational structure?
Unlike Relational systems in System R
Domains are not supported
Enforcement of candidate key uniqueness is optional
Enforcement of entity integrity is optional
Referential integrity is not enforced

11. What is Data Independence?
Data independence means that “the application is independent of the storage structure and access strategy of data”. In other words, The ability to modify the schema definition in one level should not affect the schema definition in the next higher level.
Two types of Data Independence:
Physical Data Independence: Modification in physical level should not affect the logical level.
Logical Data Independence: Modification in logical level should affect the view level.
NOTE: Logical Data Independence is more difficult to achieve

12. What is a view? How it is related to data independence?
A view may be thought of as a virtual table, that is, a table that does not really exist in its own right but is instead derived from one or more underlying base table. In other words, there is no stored file that direct represents the view instead a definition of view is stored in data dictionary.
Growth and restructuring of base tables is not reflected in views. Thus the view can insulate users from the effects of restructuring and growth in the database. Hence accounts for logical data independence.

13. What is Data Model?
A collection of conceptual tools for describing data, data relationships data semantics and constraints.

14. What is E-R model?
This data model is based on real world that consists of basic objects called entities and of relationship among these objects. Entities are described in a database by a set of attributes.

15. What is Object Oriented model?
This model is based on collection of objects. An object contains values stored in instance variables with in the object. An object also contains bodies of code that operate on the object. These bodies of code are called methods. Objects that contain same types of values and the same methods are grouped together into classes.

16. What is an Entity?
It is a 'thing' in the real world with an independent existence.

17. What is an Entity type?
It is a collection (set) of entities that have same attributes.

18. What is an Entity set?
It is a collection of all entities of particular entity type in the database.

19. What is an Extension of entity type?
The collections of entities of a particular entity type are grouped together into an entity set.

20. What is Weak Entity set?
An entity set may not have sufficient attributes to form a primary key, and its primary key compromises of its partial key and primary key of its parent entity, then it is said to be Weak Entity set.

21. What is an attribute?
It is a particular property, which describes the entity.

22. What is a Relation Schema and a Relation?
A relation Schema denoted by R(A1, A2, …, An) is made up of the relation name R and the list of attributes Ai that it contains. A relation is defined as a set of tuples. Let r be the relation which contains set tuples (t1, t2, t3, ..., tn). Each tuple is an ordered list of n-values t=(v1,v2, ..., vn).

23. What is degree of a Relation?
It is the number of attribute of its relation schema.

24. What is Relationship?
It is an association among two or more entities.

25. What is Relationship set?
The collection (or set) of similar relationships.

26. What is Relationship type?
Relationship type defines a set of associations or a relationship set among a given set of entity types.

27. What is degree of Relationship type?
It is the number of entity type participating.

28. What is DDL (Data Definition Language)?
A data base schema is specifies by a set of definitions expressed by a special language called DDL.

29. What is VDL (View Definition Language)?
It specifies user views and their mappings to the conceptual schema.

30. What is SDL (Storage Definition Language)?
This language is to specify the internal schema. This language may specify the mapping between two schemas.

Official Google Webmaster Central Blog: High-quality sites algorithm goes global, incorpor...

2013-09-09T11:03:00.001+05:30

Official Google Webmaster Central Blog: High-quality sites algorithm goes global, incorpor...: Over a month ago we introduced an algorithmic improvement designed to help people find more high-quality sites in search . Since then we’ve ...

Official Google Webmaster Central Blog: Another step to reward high-quality sites

2013-09-09T11:00:00.001+05:30

Official Google Webmaster Central Blog: Another step to reward high-quality sites: Webmaster level: All Google has said before that search engine optimization, or SEO, can be positive and constructive —and we're not t...

Official Google Webmaster Central Blog: Introducing "x-default hreflang" for international...

2013-09-09T10:52:00.005+05:30

Official Google Webmaster Central Blog: Introducing "x-default hreflang" for international...: Webmaster Level: All The homepages of multinational and multilingual websites are sometimes configured to point visitors to localized pag...

Official Google Webmaster Central Blog: Using schema.org markup for organization logos

2013-09-09T10:52:00.003+05:30

Official Google Webmaster Central Blog: Using schema.org markup for organization logos: Webmaster level: all Today, we’re launching support for the schema.org markup for organization logos, a way to connect your site with an ...

Official Google Webmaster Central Blog: Getting started with structured data

2013-09-09T10:52:00.001+05:30

Official Google Webmaster Central Blog: Getting started with structured data: Webmaster level: All If Google understands your website’s content in a structured way, we can present that content more accurately and mo...

Official Google Webmaster Central Blog: 6 Quick Tips for International Websites

2013-09-09T10:49:00.001+05:30

Official Google Webmaster Central Blog: 6 Quick Tips for International Websites: Note from the editors: After previously looking into various ways to handle internationalization for Google’s web-search , here’s a post fro...

Official Google Webmaster Central Blog: Changes in rankings of smartphone search results

2013-09-09T10:48:00.003+05:30

Official Google Webmaster Central Blog: Changes in rankings of smartphone search results: Webmaster level: Intermediate Smartphone users are a significant and fast growing segment of Internet users, and at Google we want them to e...

Official Google Webmaster Central Blog: Verify your site in Webmaster Tools using Google T...

2013-09-09T10:48:00.001+05:30

Official Google Webmaster Central Blog: Verify your site in Webmaster Tools using Google T...: Webmaster level: Intermediate If you use Google Tag Manager to add and update your site tags, now you can quickly and easily verify owners...

Official Google Webmaster Central Blog: Backlinks and reconsideration requests

2013-09-09T10:47:00.001+05:30

Official Google Webmaster Central Blog: Backlinks and reconsideration requests: Webmaster level: advanced When talking to site owners on Google Webmaster Forums we come across questions on reconsideration requests and ...

Official Google Webmaster Central Blog: A reminder about manipulative or deceptive behavio...

2013-09-09T10:46:00.003+05:30

Official Google Webmaster Central Blog: A reminder about manipulative or deceptive behavio...: Webmaster level: All Our quality guidelines prohibit manipulative or deceptive behavior, and this stance has remained unchanged since the...

Official Google Webmaster Central Blog: In-depth articles in search results

2013-09-09T10:46:00.001+05:30

Official Google Webmaster Central Blog: In-depth articles in search results: Webmaster level: all Users often turn to Google to answer a quick question, but research suggests that up to 10% of users’ daily informat...

Official Google Webmaster Central Blog: View manual webspam actions in Webmaster Tools

2013-09-09T10:45:00.005+05:30

Official Google Webmaster Central Blog: View manual webspam actions in Webmaster Tools: Webmaster level: All We strive to keep spam out of our users’ search results. This includes both improving our webspam algorithms as wel...

Official Google Webmaster Central Blog: Making smartphone sites load fast

2013-09-09T10:45:00.003+05:30

Official Google Webmaster Central Blog: Making smartphone sites load fast: Webmaster level: Intermediate Users tell us they use smartphones to search online because it’s quick and convenient, but today’s average ...

Official Google Webmaster Central Blog: rel=”author” frequently asked (advanced) questions...

2013-09-09T10:45:00.001+05:30

Official Google Webmaster Central Blog: rel=”author” frequently asked (advanced) questions...: Webmaster Level: Intermediate to Advanced Using authorship helps searchers discover great information by highlighting content from author...

Analytics Blog: Introducing The New Google Analytics Metadata API

2013-09-09T10:23:00.001+05:30

Analytics Blog: Introducing The New Google Analytics Metadata API: Google Analytics users can use the Core Reporting API to save time by building dashboards and automating complex reporting tasks. This API ...