webcheatsheet.com: RSS Feed

How to be a better PHP developer

Tue, 5 Jul 2016 18:14:16 -0400

Many web developers consider PHP as a second class language. The truth is, as DHH puts it: "You can build the best web application in the world with any language you want". We are here not to start a religious war but to help beginner PHP developers get better. Here is the some of the best advice from season PHP programmers.

First steps

Get into the habit of commenting your code thoroughly from the outset, your future self will thank you https://www.phpdoc.org/
Ignore any online tutorials, stack-overflow solutions or any other PHP code snippets on the internet that are older than 3 or 4 years (use Google's advanced search date tools to filter out older content). PHP had evolved dramatically in the last few years, and much of what is out there is wrong, insecure and bad practice.

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

Bike - drop in phpMyAdmin replacement

Tue, 26 Jun 2012 20:59:14 -0400

Pretty often you need to run a couple of queries against your MySQL database on the client's web server. Usually phpMyAdmin does the job well but there are situations when you just need to upload something to the server and open in the borwser, without any configuration steps.

Welcome Bike, lightweight phpMyAdmin replacement. If you already have a CMS installed on the web server (WordPress, Drupal, Joomla), simply upload Bike to CMS's subfolder and open it in the browser.

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