Application Development & Informative Tutorials
An Initiative of AS Tech Solutions
Breadcrumbs are the important part of every website for easy navigation. Here is a simple WordPress custom breadcrumbs without plugin code which you can copy paste and paste to `functions.php` file of your active theme.
More ever you will also find some easily configurable options to modify breadcrumbs to match your site’s look in this WordPress custom breadcrumbs.
To resize iframe height according to content, we can use javascript or jQuery. We just need to apply code on the iframe load event, so that content is loaded and height can be get at that time
You can easily remove duplicate rows in MySQL and keep just one record for each. I have provided two solutions here, one is simple query and second is using subquery to attain the same
Setting up foreign key in phpMyAdmin is quite easy. With help of this step by step pictured tutorial, you will be able to set foreign keys within your tables.
Here in the example we have three tables. ‘products’, ‘category’ and ‘product_category’. You can see structures of these tables in the picture below:
If we try to execute a simple MySQL query or any database query that contains reserved word as a table or column name we come across syntax errors.
We have discuss two options to have Defense from syntax error using a reserved word as a table or column name.
Many times we need to retrieve the last record in each group while working with database. Here group is set of those rows which have a identical column value.
You can use a ‘GROUP BY‘ to obtain the result but query with ‘LEFT JOIN‘ performs far better.
MySQL has DATETIME and TIMESTAMP fields to store date & time in MySQL database. There are some points that should be keep into mind while choosing data type to store date and time. DATETIME or TIMESTAMP? Let’s compare.
We have introduced a WordPress plugin to show Categories in Hierarchical Order in Category tab under your WordPress admin post editor window.
Categories are pushed to top by default when you select and save them for a post while this plugin maintains them on their regular order of their parent child relationship. Check and download the plugin via clicking the Continue Reading link given below:
In this article we are presented with few methods and tips to prevent SQL Injection attacks in our web application.
In simple term when an application takes user data as an input, there is an opportunity for a malicious user to enter carefully crafted data that causes the input to be interpreted as part of a SQL query instead of data in our application.
One day, I came across a problem for unwrapping anchor tag from its contents. Jquery provides us a unWrap function to unwrap the tag by removing it’s parent tag from the DOM. So there are lot of ways to unwrap a html tag itself using jQuery, overall it depends on your html structure.
