webcheatsheet.com: RSS Feed

How to create a dump of MySQL database in one click

Sun, 15 Apr 2012 21:48:45 -0400

Your users probably asked you to add an option to export the whole database to SQL file. This can be done in phpMyAdmin or Navicat of course but your users want something simpler than that.

read more | digg this | add to del.icio.us

jQuery File Upload

Wed, 21 Mar 2012 18:17:17 -0400

Wow, Yet another upload plugin! What makes it different?

It's new. Supports all modern technologies.
It's good looking and works out of the box. Based on Bootstrap and Glyphicons icons.
Cross domain upload, client size images resing.
Supports multiple platforms (PHP, Python, Ruby on Rails, Java, Node.js, etc)

SQL Server: Insufficient access rights error when doing backup

Wed, 4 Jan 2012 12:33:57 -0500

All of sudden SQL Server Management studio gives me the following error message when I'm trying to browse for the backup file location: "Property BackupDirectory is not available for Settings 'Microsoft.SqlServer.Management.Smo.Settings'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)"

read more | digg this | add to del.icio.us

Fix: Cannot load from mysql.proc. The table is probably corrupted

Wed, 4 Jan 2012 12:03:43 -0500

After upgrading MySQL from version 5.0 to 5.5 I started getting the following message trying to edit table structure in Navicat: "Cannot load from mysql.proc. The table is probably corrupted". Luckily there is an easy fix.

read more | digg this | add to del.icio.us

How to transfer logins and passwords between instances of SQL Server

Tue, 3 Jan 2012 00:01:38 -0500

Learn how to transfer logins and passwords between instances and between different versions of SQL Server.

read more | digg this | add to del.icio.us

Determine MySQL Version From the Command Line

Fri, 25 Nov 2011 17:38:11 -0500

How to determine MySQL version from the command line or from MySQL prompt. Quick and useful trick.

read more | digg this | add to del.icio.us

Record locking in Web applications

Tue, 8 Dec 2009 04:52:52 -0500

In this article we describe how to implement record locking in web applications. Because of the stateless nature of HTTP, you cannot really know whether the user left the page or is still looking at your site. We used the lock confirmation technique combined with lock expiration to solve this problem.

read more | digg this | add to del.icio.us

BBCode editor

Wed, 25 Nov 2009 06:14:18 -0500

As soon as you've decided to implement BBCode in your software product, we propose you to examine the jquery.BBCode plugin. This Jquery library plugin is a simple BBCode editor with preview option, which can be easily placed on any website.

read more | digg this | add to del.icio.us

Show different content to search engine visitors

Fri, 13 Nov 2009 02:05:00 -0500

Perhaps, you face a task to show slightly different information to different website visitors. We decided to address this issue by implementing a generic JavaScript solution.

read more | digg this | add to del.icio.us

Creating Word, Excel and CSV files with PHP

Sat, 7 Nov 2009 04:31:13 -0500

In this article we demonstrate several ways to create Microsoft Word and Excel documents, and also CSV files using PHP. Learn how to create files using HTTP headers, COM objects, OpenOffice templates, fputcsv function.

read more | digg this | add to del.icio.us