Import a large sql dump file to a MySQL database from command line

Today I had to import a very large SQL dump file (6 Gb) to a MySQL database using windows command line. If you are using linux it is the sam...

How to generate the alias using PHP code

The dream would be that it automatically checks if the alias already exists, and if necessary adds a prefix (or suffix) to ensure each alia...

Base64 Encode and Base64 Decode PHP for GET parameters

<?php /**    * Base64 encoding that doesn't need to be urlencode()ed.    * Exactly the same as base64_encode except it uses    *   -...

Curl upload file PHP

There are "@" issue on multipart POST requests. Solution for PHP 5.5 or later: - Enable CURLOPT_SAFE_UPLOAD. - Use CURLFile instea...

PHP Extract zip file using ZipArchive class

<?php $path = 'zipfile.zip'; $zip = new ZipArchive ; if ( $zip -> open ( $path ) === true ) {     for( $i = 0 ; $i < $zip -...

cURL processes for POST and GET queries functions

<?php /** * Send a POST requst using cURL * @param string $url to request * @param array $post values to send * @param array $options for...

C# XML Serialization and Deserialization: Part-2

Introduction My previous article XML Serialization and Deserialization (Part-1)  , talk about serialization of object to XML form. In this...

XML Serialization and Deserialization: Part-1

Introduction   The article talks about serialization of objects in XML format and deserialization of an XML file back to an object. Serial...