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:
Author » Amit Sonkhiya
Syntax error due to using a reserved word as a table or column name
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.
Retrieving the last record in each group
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.
DATETIME or TIMESTAMP – Comparison
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.
WordPress Categories in Hierarchical Order
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:
Methods and tips to prevent SQL Injection attacks
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.
What is SQL Injection
SQL Injection is the hacking technique which attempts to pass SQL commands (statements) through a web application for execution by the backend database. If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection
WordPress Interview Questions – I
WordPress has a wide range of questions asked for interview. I have mentioned a list of WordPress Interview Questions and their answers in this article. They are useful for developers as well as normal users too. Let’s have a look.
Add Link to Copied Text
Do you want to add a link back to your website or page when someone copy content from your website or want to show some custom message (like copyright) instead of copied content or just don’t want to let user copy then Add Link to Copied Text Plugin can do that for you.
You can know more and download this plugin via clicking the Continue Reading link given below:
Different CSS Shapes
This last part of CSS Shapes will tell you about Different CSS Shapes including Speech Bubble, Heart, Biohazard, Yin Yang, Infinity, Magnifying Glass and TV Shapes.
[ Page 20 of 22 ]