7-Views - Page 7 of 8 - Developers Blog
Defragment to Recover Space in MYSQL
If our application is performing a lot of update delete operations on a certain table then there is high possibility that it contains fragmented space. The OPTIMIZE TABLE statement allows MySQL DBAs to reorganize physical table storage in order to achieve three main goals: Shrinks the data pages Shrinks index pages Computes Fresh Index Statistics […]
JavaScript Void(0) in HTML document
You can use withinhref=”JavaScript:Void(0);” <a> the element in HTML Document. We can commonly use this within hyperlinks. Here are the benefits of using this is, to eliminate the unwanted side-effect, because it will return the undefined primative value. To prevent the page from refreshing, you could use JavaScript:void(0)
Desktop or Responsive view on a device
You Just need to set the Viewport in your HTML page. if you want a Desktop View on any device. <meta name=”viewport” content=”width=1024″> If you want a Responsive View on mobile : <meta name=”viewport” content=”width=device-width, initial-scale=1.0″>
Update WordPress Without Using FTP
In some cases, we are not able to update/upgrade our WordPress and plugins to a newer version without providing our FTP connection information. This is a common issue whereby the WordPress system can’t write to your ‘wp-content’ folder directly. To resolve this you need to follow certain steps 1) Give ‘wp-content’ 775 permissions 2) Open […]
Insert into a MySQL table or update if exists
I we want to add a row to a database table, but if a row exists with the same unique key we want to update the row. For example Let’s say the unique key is employee_id, and in my database there is a row with employee_id=1 , In that case we want to update that […]