Search In
There are two ways to fetch Nth highest salary/number.
1 - By using general sql query which works on all database.
2 - By using database specific sql query.
Database specific sql query example Nth highest salary/number
SQL Queries in Oracle to fe
Sanitize data means "Remove any illegal character from the data".
Best methods for sanitizing in php are given below.
Method 1 - Sanitize user-input when we are using Mysql Query.
For this case you have to use real_escape_string of mysqli.
For
Views are virtual tables that are compiled at run time. The data associated with views are not physically stored in the view, but it is stored in the base tables of the view. A view can be made over one or more database tables.
Ex:
create view my
Comparison Testing:- Normally comparison testing involves in the comparability the substance of the files, database, towards the genuine outputs or results. They are efficient to emphasizing the dissimilarities between the real and assumed or expecte
There are conditions when we need to show sql error messages to users such as Duplicate Entries from database.
For example in cakephp, if there is duplicacy error from database then it will show following message to the user:
"Database Error E
Application Services
The application service is the way of providing basic network based service like the web services , database management and the resource sharing.
Resource Sharing
To access the resources in an
I am working on a MySQL PHP social networking application and I want to Fetch Recent Activity as Newsfeed with respect to post activity timings.
Here is my site database, i am writing only few columns which are required to show.
u
Hi Friends,
Today I will tell you about using Code First approach using entity framework. There are some situations where you need to create the table(when it does not exist in the database). So to do this we will
use entity framework 6.0.0.0
Naming convention in cakephp
To get Maximum advantages from Cakephp then we need to follow some basic naming convention that cakephp rules says.
Naming convention follows principles of following section of cakephp
Database name
Controller file n
MongoDB is a free and open source document based DBMS . Use the following command for MongoDB installation:
1) Execute the following command to import the public GPG Key.
sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com
