Archive for April, 2011

PHP PDO Generate Replace Statement

Apr 13th

Posted by editor in Development

MySQL Replace Manual

http://dev.mysql.com/doc/refman/5.0/en/replace.html

PHP PDO Insert Statement

http://blog.teknober.com/2011/03/06/php-pdo-generate-insert-statement/

PHP PDO Update Statement

http://blog.teknober.com/2011/03/06/php-pdo-generate-update-statement/

Sample:

$model = new PDO(/* enter your parameters */);

$statement = generateReplaceSet("mytable", new TModelColumn("name", "Teknober", PDO::PARAM_STR, 100), null, true);

PDO Statement: Replace

function generateReplaceSet($table, $columns = null, $options = null, $execute = false) {
    if (isset($columns) == true) {
        /* prepare result */
        $result = null;

        /* prepare sql */
        $sql = "
                REPLACE `%s` INTO
                    %s (%s)
                VALUES
                    (%s);";

        /* prepare columns_string */
        $columns_string = null;
        $values_string = null;

        if (is_array($columns) == true) {
            /* iterate columns to generate columns_string */
            foreach ($columns as $value) {
                $columns_string .= "`" . $value->getKey() . "`,";
                $values_string .= "?,";
            }

            /* remove trailing comma */
            $columns_string = substr($columns_string, 0, strlen($columns_string) - 1);
            $values_string = substr($values_string, 0, strlen($values_string) - 1);
        } elseif ($columns instanceof TModelColumn) {
            $columns_string = "`" . $columns->getKey() . "`";
            $values_string = "?";
        } else {
            trigger_error("No column is defined in set", E_ERROR);
        }

        /* prepare sql */
        $sql = sprintf($sql, $options, $table, $columns_string, $values_string);

        /* prepare statement */
        $result = $model->prepare($sql);

        /* prepare statement parameter index */
        $param_index = 0;

        /* bind statement parameters */
        if (is_array($columns) == true) {
            foreach ($columns as $column) {
                $result->bindParam(++$param_index, $column->getValue(), $column->getType(), $column->getLength());
            }
        } elseif ($columns instanceof TModelColumn) {
            $result->bindParam(++$param_index, $columns->getValue(), $columns->getType(), $columns->getLength());
        } else {
            trigger_error("No column is defined in set", E_ERROR);
        }

        /* clean up */
        unset($table, $columns, $options, $sql, $columns_string, $values_string, $param_index);

        /* return PDO Statement */
        if ($execute) {
            return $result->execute();
        } else {
            return $result;
        }
    } else {
        trigger_error("No column is defined in arguments");
    }
}

TModelColumn Class

class TModelColumn {
    public $key = null;
    public $value = null;
    public $type = null;
    public $length = null;
    public function __construct($key, $value = null, $type = null, $length = null) {
        $this->key = $key;
        $this->value = $value;
        $this->type = $type;
        $this->length = $length;
    }
    public function getKey() {
        return $this->key;
    }
    public function getValue() {
        return $this->value;
    }
    public function getType() {
        return $this->type;
    }
    public function getLength() {
        return $this->length;
    }
}

$options,

pdo, pdo statement, pdo update statment, php, sql, sql replace into, statement

PHP Create HTML Tag-Node

Apr 13th

Posted by editor in Development

/**
 * Generates an HTML Node
 * @param string $name
 * @param boolean $short
 * @param array $attributes
 * @param string $content
 * @return Ambigous <NULL, string>
 */
function createTag($name, $short = false, $attributes = null, $content = null) {
    $tag = null;

    if (!$short) {
        $tag = sprintf("<%s%s>%s</%s>", $name, array_to_html_attributes("=", $attributes), $content, $name);
    } else {
        $tag = sprintf("<%s%s/>", $name, array_to_html_attributes("=", $attributes));
    }

    unset($name, $short, $attributes, $content);

    return $tag;
}

see for array_to_html_attributes: http://blog.teknober.com/2011/04/13/php-array-to-html-attributes/

php, php create html attributes, php html tag

PHP array to html attributes

Apr 13th

Posted by editor in Development

/**
 * Generates HTML Node Attribures
 * @param string $glue
 * @param array $pieces
 * @return string
 */
public static function array_to_html_attributes($glue, $pieces) {
    $str = "";
    if (is_array($pieces)) {
        $str = " ";
        foreach($pieces as $key => $value) {
            if (strlen($value) > 0) {
                $str .= $key . $glue . '"' . $value . '" ';
            }
        }
    }

    return rtrim($str);
}

array to html attributes, element attributes, html, php

Google Maps v3 OverLay Control onclick issue

Apr 2nd

Posted by editor in Development

The issue causes bubbling in DOM and pass all the events to Google Maps Event handler. Click, DoubleClick, MouseUp/Down, etc… I had the problems with input boxes and made this up as temporary solution. (I tried canceling bubbling from overlay DIV too, It didn’t work)

$("input, textarea").click(function(ev) {
    $(this).focus();

    tws_cancelEvent(ev);
});

or

var _input = document.getElementsByTag('input');
for ( ... ) {
     /* bind the click event for each item */
}

this CancelEvent function is generic. working for all browsers including old age ones.

/*
 * ----------------------------------------------------------------------------
 * tws_cancelEvent
 * --------------------------------------------------------------------------
 */
var tws_cancelEvent = function(event) {
    /* if no event is passed, pull the event from the window object */
    var ev = (event || window.event);

    if (ev) {
        /*
         * this cancels the bubble in order to prevent the event from
         * bubbling up the dom chain (eg: OOB script won't log link
         * click)
         */
        ev.cancelBubble = true;

        if (ev.stopPropagation) {
            ev.stopPropagation();
        }

        /*
         * this sets the return value to false and stops the default
         * action from occurring (eg: clicks on links won't navigate)
         */
        ev.returnValue = false;

        if (ev.preventDefault) {
            ev.preventDefault();
        }
    }

    /* return false in case we want to use in an onclick property */
    return false;
};

cancel event, click, dom, google maps, issue, overlay, v3

Archive for April, 2011

PHP PDO Generate Replace Statement

PHP Create HTML Tag-Node

PHP array to html attributes

PHP UTF to ASCII for URL Path

Google Maps v3 OverLay Control onclick issue

Partners