Guriddo » Topic: Suito PHP and ZF1 integration through Zend_Db_Adapter_Pdo

Suito PHP and ZF1 integration through Zend_Db_Adapter_Pdo_Mysql

Guriddo
Suito PHP and ZF1 integration through Zend_Db_Adapter_Pdo_Mysql

This topic has 16 replies, 2 voices, and was last updated 9 years, 2 months ago by guriddo.support.

Creator

Topic

February 1, 2017 at 12:25 am #125788

Participant

Time ago I ask if this library support Zend Framework 1 because we want to buy it but in order to do that I need to demonstrate my boss that it works as should be. So this is what I am testing currently:


dbOptions = $config-&gt;db-&gt;config-&gt;toArray();
$dbOptions[&#039;driver_options&#039;] = array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY =&gt; true);
$dbAdapter = Zend_Db::factory($config-&gt;db-&gt;adapter, $dbOptions);
Zend_Db_Table::setDefaultAdapter($dbAdapter);
Zend_Registry::set(&#039;dbAdapter&#039;, $dbAdapter);

$adapter = Zend_Registry::get(&#039;dbAdapter&#039;);

dbOptions = $config->db->config->toArray();

$dbOptions['driver_options'] = array(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true);

$dbAdapter = Zend_Db::factory($config->db->adapter, $dbOptions);

Zend_Db_Table::setDefaultAdapter($dbAdapter);

Zend_Registry::set('dbAdapter', $dbAdapter);

$adapter = Zend_Registry::get('dbAdapter');

From the code above $adapter turns on a Zend_Db_Adapter_Pdo_Mysql. Which is PDO but if I try to do the following:


$grid = new jqGridRender($adapter);

$grid = new jqGridRender($adapter);

My code thrown the following error:

PHP Fatal error: Call to undefined method Zend_Db_Adapter_Pdo_Mysql::setAttribute() in /var/www/library/PHPSuito/jqGrid.php(1) : eval()’d code on line 1

I am not sure how to integrate the library and Zend Framework so I’ll need some support. We still interested in buy the library but we won’t do it unless I can demonstrate that is usable from a Zend Framework 1 project.

Can I get someone writing a small example for usage so I can test it in my own environment?

This topic was modified 9 years, 2 months ago by reynierpm.

Creator

Topic

Viewing 15 replies - 1 through 15 (of 16 total)

1 2 →

Author

Replies

February 1, 2017 at 10:31 am #125791

guriddo.support

Participant

Hello,

As far as I remember our discussion was here.

In my post I note that we do not understand ZF1, but give you advice’s how to pass ZF1 connection to the jqGrid.

Now I will write it for second time:

1. To the grid we passed connection object.
2. If your adapter stores a PDO connection somewhere then you can easy pass it.

By example if you have:

...
$dbAdapter = Zend_Db::factory($config-&gt;db-&gt;adapter, $dbOptions);
Zend_Db_Table::setDefaultAdapter($dbAdapter);
Zend_Registry::set(&#039;dbAdapter&#039;, $dbAdapter);
 
$adapter = Zend_Registry::get(&#039;dbAdapter&#039;);

...

...

$dbAdapter = Zend_Db::factory($config->db->adapter, $dbOptions);

Zend_Db_Table::setDefaultAdapter($dbAdapter);

Zend_Registry::set('dbAdapter', $dbAdapter);

$adapter = Zend_Registry::get('dbAdapter');

...

and your adapter stores the connection object to

$adapter->Connection , then you will need to pass this to the grid and not the adapter.

...
$grid = new jqGridRender($adapter-&gt;Connection);
...

...

$grid = new jqGridRender($adapter->Connection);

...

Simple the reletion is this:


...
$adapter-&gt;Connection = $conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
...

...

$adapter->Connection = $conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

...

Of course in ZF1 this should have another name and this is just example.
What you need to know is where the ZF1 stores this object in its adapter.

Hope it is now clear

Kind Regards,
Will

This reply was modified 9 years, 2 months ago by guriddo.support.

Guriddo Support Team

February 1, 2017 at 3:41 pm #125793

reynierpm

Participant

Hi there, I am getting an error when the grid is being render and I don’t know why or how to trace it. This is how my code looks like:


    public function indexAction()
    {
        $CODE_PATH = &#039;PHPSuito/&#039;;

        require_once $CODE_PATH.&#039;jqGrid.php&#039;;
        require_once $CODE_PATH.&#039;jqGridRender.php&#039;;
        require_once $CODE_PATH.&#039;DBdrivers/jqGridPdo.php&#039;;

        $adapter = Zend_Registry::get(&#039;dbAdapter&#039;);

        $grid                = new jqGridRender($adapter-&gt;getConnection());
        $grid-&gt;SelectCommand = &#039;SELECT * FROM companies&#039;;
        $grid-&gt;dataType      = &#039;json&#039;;
        $grid-&gt;setColModel();
        $grid_url = Zend_Controller_Front::getInstance()-&gt;getRequest()-&gt;getControllerName().&#039;/&#039;.Zend_Controller_Front::getInstance()-&gt;getRequest()-&gt;getActionName();
        $grid-&gt;setUrl($grid_url);
        $grid-&gt;setGridOptions(array(
            &quot;rownumbers&quot;  =&gt; true,
            &quot;rownumWidth&quot; =&gt; 35,
            &quot;rowNum&quot;      =&gt; 10,
            &quot;sortname&quot;    =&gt; &quot;companies_id&quot;,
            &quot;toppager&quot;    =&gt; true,
            &quot;rowList&quot;     =&gt; array(10, 20, 50),
        ));

        $grid-&gt;setColProperty(&quot;companies_id&quot;, array(&quot;label&quot; =&gt; &quot;ID&quot;, &quot;width&quot; =&gt; 60));
        $grid-&gt;setColProperty(&quot;created_date&quot;, array(
                &quot;formatter&quot;     =&gt; &quot;date&quot;,
                &quot;formatoptions&quot; =&gt; array(&quot;srcformat&quot; =&gt; &quot;Y-m-d H:i:s&quot;, &quot;newformat&quot; =&gt; &quot;m/d/Y&quot;)
            )
        );
        $grid-&gt;navigator = true;
        $grid-&gt;setNavOptions(
            &#039;navigator&#039;,
            array(&quot;cloneToTop&quot; =&gt; true, &quot;add&quot; =&gt; false, &quot;edit&quot; =&gt; false, &quot;del&quot; =&gt; false, &quot;excel&quot; =&gt; false)
        );
        $grid-&gt;renderGrid(&#039;#grid&#039;, &#039;#pager&#039;, true, null, null, true, true);
    }

public function indexAction()

{

$CODE_PATH = 'PHPSuito/';

require_once $CODE_PATH.'jqGrid.php';

require_once $CODE_PATH.'jqGridRender.php';

require_once $CODE_PATH.'DBdrivers/jqGridPdo.php';

$adapter = Zend_Registry::get('dbAdapter');

$grid = new jqGridRender($adapter->getConnection());

$grid->SelectCommand = 'SELECT * FROM companies';

$grid->dataType = 'json';

$grid->setColModel();

$grid_url = Zend_Controller_Front::getInstance()->getRequest()->getControllerName().'/'.Zend_Controller_Front::getInstance()->getRequest()->getActionName();

$grid->setUrl($grid_url);

$grid->setGridOptions(array(

"rownumbers" => true,

"rownumWidth" => 35,

"rowNum" => 10,

"sortname" => "companies_id",

"toppager" => true,

"rowList" => array(10, 20, 50),

));

$grid->setColProperty("companies_id", array("label" => "ID", "width" => 60));

$grid->setColProperty("created_date", array(

"formatter" => "date",

"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "m/d/Y")

)

);

$grid->navigator = true;

$grid->setNavOptions(

'navigator',

array("cloneToTop" => true, "add" => false, "edit" => false, "del" => false, "excel" => false)

);

$grid->renderGrid('#grid', '#pager', true, null, null, true, true);

}

Then the JSON returned is something like:


{
  &quot;records&quot;: &quot;1&quot;,
  &quot;page&quot;: 1,
  &quot;total&quot;: 1,
  &quot;rows&quot;: [
    {
      &quot;companies_id&quot;: &quot;1&quot;,
      &quot;parent_companies_id&quot;: &quot;0&quot;,
      &quot;client_of_companies_id&quot;: &quot;0&quot;,
      &quot;asset_locations_id&quot;: null,
      &quot;companies_name&quot;: &quot;container&quot;,
      &quot;companies_number&quot;: &quot;000001&quot;,
      &quot;companies_url&quot;: &quot;&quot;,
      &quot;location_number&quot;: null,
      &quot;statuses_id&quot;: &quot;1&quot;,
      &quot;managed&quot;: &quot;0&quot;,
      &quot;created_date&quot;: &quot;0000-00-00 00:00:00&quot;,
      &quot;created_by_users_id&quot;: &quot;0&quot;,
      &quot;updated_date&quot;: &quot;2017-01-16 15:53:35&quot;,
      &quot;updated_by_users_id&quot;: null,
      &quot;host_companies_id&quot;: &quot;0&quot;,
      &quot;host_company&quot;: &quot;0&quot;,
      &quot;view_pricing&quot;: &quot;1&quot;,
      &quot;is_demo&quot;: &quot;0&quot;,
      &quot;expired_date&quot;: &quot;0000-00-00&quot;,
      &quot;companies_region_name&quot;: null,
      &quot;companies_location_name&quot;: null,
      &quot;companies_address1&quot;: null,
      &quot;companies_address2&quot;: null,
      &quot;companies_city&quot;: null,
      &quot;companies_state_name&quot;: null,
      &quot;companies_state_abbr&quot;: null,
      &quot;companies_country_name&quot;: null,
      &quot;companies_country_abbr&quot;: null,
      &quot;companies_logo&quot;: &quot;default.jpg&quot;,
      &quot;companies_zip&quot;: null,
      &quot;internal_name&quot;: null,
      &quot;internal_number&quot;: null,
      &quot;phone&quot;: null,
      &quot;fax&quot;: null,
      &quot;number_of_subcompanies&quot;: &quot;0&quot;,
      &quot;company_type&quot;: null,
      &quot;companies_header&quot;: &quot;default_header.jpg&quot;,
      &quot;send_alert&quot;: &quot;1&quot;,
      &quot;create_asset&quot;: &quot;1&quot;,
      &quot;create_servicepak&quot;: &quot;1&quot;,
      &quot;create_contract&quot;: &quot;1&quot;,
      &quot;alert_section_1&quot;: null,
      &quot;alert_section_2&quot;: null,
      &quot;group_companies_id&quot;: &quot;0&quot;,
      &quot;email&quot;: null,
      &quot;VAT&quot;: null,
      &quot;CustomerSiteID&quot;: null,
      &quot;DistributorID&quot;: null
    }
  ]
}
Can not write to log!

{

"records": "1",

"page": 1,

"total": 1,

"rows": [

{

"companies_id": "1",

"parent_companies_id": "0",

"client_of_companies_id": "0",

"asset_locations_id": null,

"companies_name": "container",

"companies_number": "000001",

"companies_url": "",

"location_number": null,

"statuses_id": "1",

"managed": "0",

"created_date": "0000-00-00 00:00:00",

"created_by_users_id": "0",

"updated_date": "2017-01-16 15:53:35",

"updated_by_users_id": null,

"host_companies_id": "0",

"host_company": "0",

"view_pricing": "1",

"is_demo": "0",

"expired_date": "0000-00-00",

"companies_region_name": null,

"companies_location_name": null,

"companies_address1": null,

"companies_address2": null,

"companies_city": null,

"companies_state_name": null,

"companies_state_abbr": null,

"companies_country_name": null,

"companies_country_abbr": null,

"companies_logo": "default.jpg",

"companies_zip": null,

"internal_name": null,

"internal_number": null,

"phone": null,

"fax": null,

"number_of_subcompanies": "0",

"company_type": null,

"companies_header": "default_header.jpg",

"send_alert": "1",

"create_asset": "1",

"create_servicepak": "1",

"create_contract": "1",

"alert_section_1": null,

"alert_section_2": null,

"group_companies_id": "0",

"email": null,

"VAT": null,

"CustomerSiteID": null,

"DistributorID": null

}

]

}

Can not write to log!

What log is that? How I disable such feature? I don’t need to write anything

This reply was modified 9 years, 2 months ago by reynierpm.

February 1, 2017 at 4:10 pm #125795

reynierpm

Participant

Ok, I’ve discovered how to fix the previous issue by setting:


$grid-&gt;logtofile     = false;

$grid->logtofile = false;

But the error still and I can see the following on the debug output:


Array
(
    [0] =&gt; Array
        (
            [time] =&gt; 2017-02-01 14:07:44
            [query] =&gt; SELECT COUNT(*) AS COUNTR  FROM companies
            [data] =&gt; 
            [types] =&gt; 
            [fields] =&gt; 
            [primary] =&gt; 
            [input] =&gt; 
        )

    [1] =&gt; Array
        (
            [time] =&gt; 2017-02-01 14:07:44
            [query] =&gt; SELECT * FROM companies ORDER BY companies_id asc LIMIT 0, 10
            [data] =&gt; 
            [types] =&gt; 
            [fields] =&gt; 
            [primary] =&gt; 
            [input] =&gt; 
        )

)

Array

(

[0] => Array

(

[time] => 2017-02-01 14:07:44

[query] => SELECT COUNT(*) AS COUNTR FROM companies

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

[1] => Array

(

[time] => 2017-02-01 14:07:44

[query] => SELECT * FROM companies ORDER BY companies_id asc LIMIT 0, 10

[data] =>

[types] =>

[fields] =>

[primary] =>

[input] =>

)

I am not sure what this means or what I’m missing, could you help?

February 1, 2017 at 4:30 pm #125796

guriddo.support

Participant

What is the error reported?
Please show us the text reported as error!

Maybe you may need to disable debugging where you set it somewhere?

$grid->debug = false; // this option by default is false

Please check this option, or
set

$grid->logtofile = true

and make your directory writtable by the script.

Regards
Will

Guriddo Support Team

February 1, 2017 at 4:34 pm #125797

reynierpm

Participant

Hi, by setting:

$grid->logtofile = false;

the error above dissapear but I am still getting an issue. Check below:

February 2, 2017 at 10:24 am #125802

guriddo.support

Participant

Hello,

Please find and remove (or comment) any echo or print_r command which are connected to jqGrid script.

We are close.

Kind Regards
Will

Guriddo Support Team

February 2, 2017 at 8:28 pm #125806

reynierpm

Participant

There is not such thing on my code, what you’re seeing here is exactly what I currently have in my class

February 3, 2017 at 10:00 am #125809

guriddo.support

Participant

Hello,

This is strange. This message is lunched in the error ajax function.

This mean the the request is something wrong.

Could you please look in your browser console (Chrome or FireFox) the status of the request?

You can look more detailed for the error in the console and the response of the request.

Kind Regards,

Will

Guriddo Support Team

February 3, 2017 at 10:05 am #125810

guriddo.support

Participant

Hello,

There is not such thing on my code, what you’re seeing here is exactly what I currently have in my class

I’m not sure that this is true, since you have a ToolbarSearch mode which I do not see in your code.

Please check your code again!

Kind Regards,

Will

Guriddo Support Team

February 3, 2017 at 3:17 pm #125811

reynierpm

Participant

I can’t test anymore apparently, I got this “Script expired” message when I try to execute the code 🙁

February 3, 2017 at 8:01 pm #125812

guriddo.support

Participant

Hello,

To get another period of testing, please re download the trial from our download page

Kind Regards,
Will

Guriddo Support Team

February 3, 2017 at 8:09 pm #125813

reynierpm

Participant

That’s exactly what I did but still not working :-\

February 3, 2017 at 8:32 pm #125814

reynierpm

Participant

Finally I have managed to make the library work and this is how the code looks like currently:


    public function indexAction()
    {
        $CODE_PATH = &#039;PHPSuito/&#039;;

        require_once $CODE_PATH.&#039;jqGrid.php&#039;;
        require_once $CODE_PATH.&#039;jqGridRender.php&#039;;
        require_once $CODE_PATH.&#039;DBdrivers/jqGridPdo.php&#039;;

        $adapter = Zend_Registry::get(&#039;dbAdapter&#039;);

        $grid                = new jqGridRender($adapter-&gt;getConnection());
        $grid-&gt;SelectCommand = &#039;SELECT * FROM companies&#039;;
        $grid-&gt;dataType      = &#039;json&#039;;
        $grid-&gt;setColModel();
        $grid_url = Zend_Controller_Front::getInstance()-&gt;getRequest()-&gt;getControllerName().&#039;/&#039;.Zend_Controller_Front::getInstance()-&gt;getRequest()-&gt;getActionName();
        $grid-&gt;setUrl($grid_url);
        $grid-&gt;setGridOptions(array(
            &quot;rownumbers&quot;  =&gt; true,
            &quot;rownumWidth&quot; =&gt; 35,
            &quot;rowNum&quot;      =&gt; 10,
            &quot;sortname&quot;    =&gt; &quot;companies_id&quot;,
            &quot;toppager&quot;    =&gt; true,
            &quot;rowList&quot;     =&gt; array(10, 20, 50),
        ));

        $grid-&gt;setColProperty(&quot;companies_id&quot;, array(&quot;label&quot; =&gt; &quot;ID&quot;, &quot;width&quot; =&gt; 60));
        $grid-&gt;setColProperty(&quot;created_date&quot;, array(
                &quot;formatter&quot;     =&gt; &quot;date&quot;,
                &quot;formatoptions&quot; =&gt; array(&quot;srcformat&quot; =&gt; &quot;Y-m-d H:i:s&quot;, &quot;newformat&quot; =&gt; &quot;m/d/Y&quot;)
            )
        );

        $grid-&gt;navigator = true;
        $grid-&gt;setNavOptions(
            &#039;navigator&#039;,
            array(&quot;cloneToTop&quot; =&gt; true, &quot;add&quot; =&gt; false, &quot;edit&quot; =&gt; false, &quot;del&quot; =&gt; false, &quot;excel&quot; =&gt; false)
        );

        $grid-&gt;renderGrid(&#039;#grid&#039;, &#039;#pager&#039;, true, null, null, true, true);
    }

public function indexAction()

{

$CODE_PATH = 'PHPSuito/';

require_once $CODE_PATH.'jqGrid.php';

require_once $CODE_PATH.'jqGridRender.php';

require_once $CODE_PATH.'DBdrivers/jqGridPdo.php';

$adapter = Zend_Registry::get('dbAdapter');

$grid = new jqGridRender($adapter->getConnection());

$grid->SelectCommand = 'SELECT * FROM companies';

$grid->dataType = 'json';

$grid->setColModel();

$grid_url = Zend_Controller_Front::getInstance()->getRequest()->getControllerName().'/'.Zend_Controller_Front::getInstance()->getRequest()->getActionName();

$grid->setUrl($grid_url);

$grid->setGridOptions(array(

"rownumbers" => true,

"rownumWidth" => 35,

"rowNum" => 10,

"sortname" => "companies_id",

"toppager" => true,

"rowList" => array(10, 20, 50),

));

$grid->setColProperty("companies_id", array("label" => "ID", "width" => 60));

$grid->setColProperty("created_date", array(

"formatter" => "date",

"formatoptions" => array("srcformat" => "Y-m-d H:i:s", "newformat" => "m/d/Y")

)

);

$grid->navigator = true;

$grid->setNavOptions(

'navigator',

array("cloneToTop" => true, "add" => false, "edit" => false, "del" => false, "excel" => false)

);

$grid->renderGrid('#grid', '#pager', true, null, null, true, true);

}

There is not “echo” or “print_f” or any other output statement around meaing the code you’re seeing here is the code being executed. The template is completely empty as well.

No matter what the error still happening and for some reason the response comes as a whole HTML page and not a JSON, why? no ideas!!

Any other clue or test you want me to perform?

February 6, 2017 at 1:15 pm #125815

guriddo.support

Participant

Hello,

Glad to hear that the problem is solved.

One possible reason that can cause this problem is a white space in the file.

Kind Regards,

Will

Guriddo Support Team

February 6, 2017 at 3:14 pm #125816

reynierpm

Participant

Hi there, I think you miss understand => “Finally I have managed to make the library work” this mean I didn’t get the “Script expired” message but I can’t get this to work, the same issue where the JSON is printed out to a popup window still happening so nothing is really fixed I am still need some support to make this work otherwise my boss won’t never buy something that doesn’t work with our system.

Suito PHP and ZF1 integration through Zend_Db_Adapter_Pdo_Mysql

Search Forum

Recent Replies

Forum Statistics

UserOnline