Suliman alkous

Tuesday, February 14, 2012

to populate date to dojo in Zend

you need to convert date to ISO :

$q = Doctrine_Query::create()
                        ->from('Model_Emp e')
                        ->where('cid = ?', $input->id);

$result = $q->fetchArray();

$date = new Zend_Date();
$date->set($result[0]['job_date'], Zend_Date::ISO_8601);
$result[0]['job_date'] = $date->getIso();

$this->view->form->getSubForm('empform')->populate($result[0]);

Thursday, January 19, 2012

How to cunfigure JQuery with Zend 1.11

1- In bootstrap add this function:

   protected function _initAppAutoload() {
        $moduleLoader = new Zend_Application_Module_Autoloader(array(
                    'namespace' => '',
                    'basePath' => APPLICATION_PATH));

        $this->bootstrap('view');
        $view = $this->getResource('view');
    $view->addHelperPath("ZendX/JQuery/View/Helper", "ZendX_JQuery_View_Helper");

    $viewRenderer = new Zend_Controller_Action_Helper_ViewRenderer();
    $viewRenderer->setView($view);
    Zend_Controller_Action_HelperBroker::addHelper($viewRenderer);
    $view->dojo()->enable();
    }

2- download JQuery and put the folder inside public/js.

3- add this lines below to application.ini :
resources.view[] =
pluginPaths.ZendX_Application_Resource_ = "ZendX/Application/Resource"
resources.jquery.localpath = "/js/jquery-ui-1.8.17.custom/js/jquery-1.7.1.min.js"
resources.jquery.stylesheet = "/js/jquery-ui-1.8.17.custom/css/pepper-grinder/jquery-ui-1.8.17.custom.css"
resources.jquery.uilocalpath = "/js/jquery-ui-1.8.17.custom/js/jquery-ui-1.8.17.custom.min.js"

4- finally put these lines in <head> inside your layout.phtml:
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <?php echo $this->headTitle(); ?>
        <?php echo $this->headLink()->appendStylesheet('/css/style.css'); ?>
        <?php echo $this->headLink(); ?>
        <?php echo $this->jQuery(); ?>
    </head>

for testing put this code to index.phtml :
<form method="post" action="/hello/world">
Pick your Date: <?php echo $this->datePicker("dp1",
                                             '',
                                             array(
                                                'defaultDate' =>
                                                    date('Y/m/d', time())));?>
<input type="submit" value="Submit" />
</form>

that`s it .

Wednesday, December 14, 2011

Missing mysql.sock on mac lion with Zend server

If you have MySQL server installed on Mac OS X Lion and after you install Zend Server
maybe you have this error:

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2)
to fix this error you need to make this link:

sudo ln -s /private/tmp/mysql.sock /usr/local/zend/mysql/tmp/mysql.sock

Good luck :)

Monday, December 12, 2011

Run Jdeveloper on mac lion

To run JDeveloper on mac lion you need :

1- create file and name it java_setting.sh
2- put this in file

#!/bin/bash

mkdir /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6

mkdir /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/bin/java /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin/java

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/bin/javac /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin/javac

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/bin/javap /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin/javap

ln -s /System/Library/Java/Support/Deploy.bundle/Contents/Home/bin/javaws /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin/javaws

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/bin/jar /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin/jar

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/bin/xjc /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/bin/xjc

mkdir /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/lib

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/classes/classes.jar /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/lib/tools.jar

mkdir /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/jre

mkdir /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/jre/bin

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/bin/java /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/jre/bin/java

mkdir /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/jre/lib

ln -s /system/library/java/javavirtualmachines/1.6.0.jdk/contents/classes/classes.jar /system/library/java/javavirtualmachines/1.6.0.jdk/contents/home/jdk6/jre/lib/rt.jar

3- chmod +x java_setting.sh

4- sudo ./java_setting.sh

After that run jdevstudio11121install.jar and install .

thanks

Install mysql server 5.5 on mac lion

To install mysql server NOT MAMP only mysql server follow this link :

http://www.djangoapp.com/blog/2011/07/24/installation-of-mysql-server-on-mac-os-x-lion/

Sunday, December 11, 2011

Compare two columns using like syntax In MYSQL

if you have two tables:

emp (id , name, grad)

grad (id, name)

and you want to compare column (emp.name and grad.name) with LIKE % use this:

select e.name, g.name

from emp e inner join grad g

ON e.grad like CONCAT('%',g.name, '%');

Saturday, December 3, 2011

Good example for CRUD OOP for PHP and MYSQL

By creating a MySQL CRUD class you can easily create, read, update and delete entries in any of your projects, regardless of how the database is designed.

This is good example for CRUD OOP for PHP and MYSQL:

http://net.tutsplus.com/tutorials/php/real-world-oop-with-php-and-mysql/