CodeHill

Importing and Exporting MySQL Databases

Amgad Suliman — Wed, 19 Jun 2013 06:04:32 +0000

Importing and exporting MySQL databases in a Unix/Linux environment can be done easily with a single command. You can even choose to export the database’s structure or data only. Exporting is done using the mysqldump program and importing is done using the MySQL command line client mysql. mysqldump prints out the resulting SQL to standard [...]

Navigating MySQL Databases and Tables

Amgad Suliman — Tue, 18 Jun 2013 16:00:41 +0000

Here is a list of MySQL’s command line client commands to navigate through the databases and their tables. First run the client program by entering the following at the command line: [crayon-51c14a1f24dd7/] The -u option is for passing the username. So change root to the username you have access to. And the -p options prompts [...]

List Drives and Folders in a TreeView Using C#

Amgad Suliman — Tue, 04 Jun 2013 16:00:10 +0000

The .NET Framework makes it easy to read drive and folder details but it does not include a Windows Forms control to automatically list them other than the FolderBrowserDialog control. Here is a fast and simple way to use a TreeView control to list the drives and folders in a system. The trick to keeping [...]

New Ticketing and Knowledgebase System for Cronless

Amgad Suliman — Sun, 24 Mar 2013 14:00:28 +0000

We released a new update for Cronless that will hopefully ease asking for support and help us keep up with the growing number of tickets. We’ve integrated with Zendesk to provide a ticketing system, knowledgebase and a section for submitting and voting for ideas and suggestions. To access any of these new feature simply click [...]

Shortcut Keys for Bash

Amgad Suliman — Tue, 07 Aug 2012 14:00:30 +0000

A list of 30 Bash shortcut keys that will save you time. Bash is the default shell in most Linux distributions and the most popular. The shortcuts are divided into 3 sections (navigation, editing and cutting and pasting) for easy reference. Nanigation Tab Auto-complete files and folder names Shift + Page Up Scroll terminal [...]

A Simple Port Scanner in PHP

Amgad Suliman — Tue, 17 Jul 2012 14:00:54 +0000

Here is a simple port scanner written in PHP. It checks if a port is accessible by trying to connect to it using PHP’s fsockopen function. [crayon-51c14a1f2615b/] The first foreach loop goes through the port numbers in the $ports array trying to connect to each one using the fsockopen function (PHP.net reference.) The ampersand (@) [...]

Managing Application Settings in PHP

Amgad Suliman — Tue, 27 Mar 2012 15:00:46 +0000

There are multiple ways to save application settings/configurations in PHP. You can save them in INI, XML or PHP files as well as a database table. I prefer a combination of the latter two; saving the database connection details in a PHP file and the rest in a database table. The advantage of using this [...]

SnipsManager Version 2.3 Released

Amgad Suliman — Mon, 06 Feb 2012 14:00:26 +0000

The new version of SnipsManager is available for download. We fixed some bugs and added a few more features: Fixed the text wrapping bug in snippets containing long strings of text without spaces. Improved snippet submission summary page, parse.php. Added a Use CAPTCHA checkbox to the snippet submission page to display a CAPTCHA image before [...]

Cronless Now Supports 30 Second Cron Jobs

Amgad Suliman — Wed, 10 Aug 2011 14:00:13 +0000

Today we released a new Cronless update that allows premium members to schedule cron jobs to run every 30 seconds (twice per minute). To make use of this feature create a new job or modify an existing one and just set the Interval to ‘Every 30 seconds’. Please note that the crontab importing feature will [...]

Download And Search Multiple Pages Using PHP

Amgad Suliman — Tue, 02 Aug 2011 14:00:44 +0000

Here is a simple way to loop through a list of URLs, download the page and search the contents for a string. The script starts by checking if the post variable $_POST['urls'] is set. If it is, its content is split by line breaks into the array $urls to easily read one URL at a [...]