Category Archives: LAMP

Creating a MySQL Dump File from Remote Datase

Sometimes you need mysql dump from your remote mysql database. Here is the command for generate mysql dump.

mysqldump -u username -p -h hostname dbname > filetosave.sql


Upgrade php 5.3 to php 5.4.6 in ubuntu 12.04

For a project purpose I had to upgrade my PHP version 5.3 to 5.4
Today I will show simple step to upgrade PHP version

Step One: Simply add the PPA repository:

sudo add-apt-repository ppa:ondrej/php5

Step Two:

sudo apt-get update
sudo apt-get install php5

That’s it. happy coding 🙂

Create XML pingomatic for your PHP project

Ping-O-Matic is a service to update different search engines that your blog has updated.

Here is simple way to do that:

 * XML Pingomatic
 * @category  Model
 * @author    Md. Sirajus Salayhin <>
class xmlPingoMatic
    public function pingoMatic($debug = false)
        $sql = "SELECT DISTINCT * ,DATE_FORMAT(date, '%Y-%m-%dT%H:%i:%s+00:00') AS new_date FROM articles
                    WHERE articles.status =  0
                    AND DATE_FORMAT(date, '%Y-%m-%d') = CURDATE() ORDER BY DESC";
        $res = mysql_query($sql);
        while ($row = mysql_fetch_assoc($res)) {
            $data[] = $row;
        $content = '';
        $content .= '<?xml version="1.0"?>';
        $content .= '<methodCall>';
        $content .= '<methodName></methodName>';
        $content .= '<params>';
        for ($i = 0; $i < count($data); $i++) {
            $content .= '<param>';
            $content .= '<value>' . $data[$i]['title'] . '</value>';
            $content .= '</param>';
            $content .= '<param>';
            $content .= '<value>' . '' . $data[$i]['id'] . '</value>';
            $content .= '</param>';
        $content .= ' </params>';
        $content .= '</methodCall>';
        $headers = "POST / HTTP/1.0\r\n" .
            "User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1) Gecko/20090624 Firefox/3.5 (.NET CLR 3.5.30729)\r\n" .
            "Host:\r\n" .
            "Content-Type: text/xml\r\n" .
            "Content-length: " . strlen($content);
        if ($debug) nl2br($headers);
        $request = $headers . "\r\n\r\n" . $content;
        $response = "";
        $fs = fsockopen('', 80, $errno, $errstr);
        if ($fs) {
            fwrite($fs, $request);
            while (!feof($fs)) $response .= fgets($fs);
            if ($debug) echo "<xmp>" . $response . "</xmp>";
            preg_match_all("/<(name|value|boolean|string)>(.*)<\/(name|value|boolean|string)>/U", $response, $ar, PREG_PATTERN_ORDER);
            for ($i = 0; $i < count($ar[2]); $i++) $ar[2][$i] = strip_tags($ar[2][$i]);
            return array('status' => ($ar[2][1] == 1 ? 'ko' : 'ok'), 'msg' => $ar[2][3]);
        } else {
            if ($debug) echo "<xmp>" . $errstr . " (" . $errno . ")</xmp>";
            return array('status' => 'ko', 'msg' => $errstr . " (" . $errno . ")");

Create sitemap for PHP project

For Search Engin Optimization you need to create site map for your website. Here is a simple class example to do that.

 * Create Site map
 * @category  Model
 * @author    Md. Sirajus Salayhin <>
class xmlSitemap
    public function generateXML()
        $xmlFile = "../sitemap.xml";
        $fh = fopen($xmlFile, 'w') or die("can't open file");
        $sql = "SELECT DISTINCT * ,DATE_FORMAT(date, '%Y-%m-%dT%H:%i:%s+00:00') AS new_date FROM articles
             WHERE articles.status =  0 ORDER BY DESC";
        $res = mysql_query($sql);
        while ($row = mysql_fetch_assoc($res)) {
            $content[] = $row;
        $str = '';
        $str .= '<?xml version="1.0" encoding="UTF-8"?>';
        $str .= '<?xml-stylesheet type="text/xsl" href="sitemap.xsl"?>
<!-- sitemap-generator-url="" sitemap-generator-version="3.2.6" -->
<!-- generated-on="October 13, 2011 05:29" -->';
        $str .= '<urlset xmlns:xsi="" xsi:schemaLocation="" xmlns="">';
        for ($i = 0; $i < count($content); $i++) {
            $str .= '<url>';
            $str .= '<loc>' . $content[$i]['id'] . '</loc>';
            $str .= '<lastmod>' . $content[$i]['new_date'] . '</lastmod>';
            $str .= '<changefreq>daily</changefreq>';
            $str .= '<priority>1.0</priority>';
            $str .= '</url>';
        $str .= '</urlset>';
        fwrite($fh, $str);

Add custom style for your sitemap:

 <?xml version = "1.0" encoding = "UTF-8"?>
<xsl:stylesheet version="2.0"
    <xsl:output method="html" version="1.0" encoding="UTF-8" indent="yes"/>
    <xsl:template match="/">
        <html xmlns="">
            <title>XML Sitemap</title>
            <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
            <style type="text/css">
                body {
                    font-family: "Lucida Grande", "Lucida Sans Unicode", Tahoma, Verdana;
                    font-size: 13px;
                #intro {
                    background-color: #CFEBF7;
                    border: 1px #2580B2 solid;
                    padding: 5px 13px 5px 13px;
                    margin: 10px;
                #intro p {
                    line-height: 16.8667px;
                td {
                    font-size: 11px;
                th {
                    text-align: left;
                    padding-right: 30px;
                    font-size: 11px;
                tr.high {
                    background-color: whitesmoke;
                #footer {
                    padding: 2px;
                    margin: 10px;
                    font-size: 8pt;
                    color: gray;
                #footer a {
                    color: gray;
                a {
                    color: black;
        <h1>XML Sitemap</h1>
        <div id="intro">
        <div id="content">
            <table cellpadding="5">
                <tr style="border-bottom:1px black solid;">
                    <th>Change Frequency</th>
                    <th>LastChange (GMT)</th>
                <xsl:variable name="lower" select="'abcdefghijklmnopqrstuvwxyz'"/>
                <xsl:variable name="upper" select="'ABCDEFGHIJKLMNOPQRSTUVWXYZ'"/>
                <xsl:for-each select="sitemap:urlset/sitemap:url">
                        <xsl:if test="position() mod 2 != 1">
                            <xsl:attribute name="class">high</xsl:attribute>
                            <xsl:variable name="itemURL">
                                <xsl:value-of select="sitemap:loc"/>
                            <a href="{$itemURL}">
                                <xsl:value-of select="sitemap:loc"/>
                            <xsl:value-of select="concat(sitemap:priority*100,'%')"/>
                                select="concat(translate(substring(sitemap:changefreq, 1, 1),concat($lower, $upper),concat($upper, $lower)),substring(sitemap:changefreq, 2))"/>
                                select="concat(substring(sitemap:lastmod,0,11),concat(' ', substring(sitemap:lastmod,12,5)))"/>
        <div id="footer">

Happy coding 🙂

How to install LAMP server in Fedora 17

I have recently move on Fedora from Ubunutu . Here I share how to install LAMP (Linux, Apache, MySQL and PHP) server in fedora 17.

– Install Mysql Server

yum install mysql mysql-server

Now start and Enable Mysql service. Run this command

systemctl start mysqld.service
systemctl enable mysqld.service

Now create MySQL pasword –

mysqladmin -u root password [your_password_here]

Now check mySQL . Run

mysql -h localhost -u root -p

Continue reading How to install LAMP server in Fedora 17

Error on MongoDB: couldn’t connect to server shell/mongo.js

I have faced some problem after installing MongoDB on my Ubunutu 12.04.  Here is the error .

Error: couldn't connect to server shell/mongo.js:84
exception: connect failed

I found some solution on google. Here it is.

sudo rm /var/lib/mongodb/mongod.lock
sudo -u mongodb mongod -f /etc/mongodb.conf --repair
sudo service mongodb start

Please read this  for more detail. Continue reading Error on MongoDB: couldn’t connect to server shell/mongo.js

Creating custom routes in your zend framework application

One of my zend framework project need to define custom routs . I have google a lot then found a solution.

Here I share my solution.

You can define custom routes in zend framework in many ways. I create a ini file to do this.

First add those line to your Bootstrap file.

protected function _initRoutes() {
$front = Zend_Controller_Front::getInstance();
$router = $front->getRouter();
$myRoutes = new Zend_Config_Ini(APPLICATION_PATH . '/configs/routes.ini', 'production');
$router->addConfig($myRoutes, 'routes');

This will tell the system routing information from “routes.ini” file from application/configs.

Then you need a routes.ini file in application/configs. Now create a new file named routes.ini there.

Now say for example your domain is and you want the to be Continue reading Creating custom routes in your zend framework application