Grid tutorial in OPENSHIFT. How can I check PHP connectio?

[max6432Participant]

I’m a beginner trying to getting started. I did the “jqxGrid Getting Started” example, which is a static grid (without any connection to a database) and it worked ok in my PC and in openshift too.
Then I followed “Bind jQuery Grid to MySql Database using PHP” example using Eclipse and it worked fine in my PC. So I generated an application in Openshift, with the MySQL, PHP and phpMyAdmin cartridges, created the northwind database, commited and pushed the example application to the server and…. it didn’t work. After hours of attempts, I just get the grid, a “loading” message box, and then “no data to display” message into the grid.
It seems to me that all is ok, I used the URL connection, user and password provided by openshift and so.
I feel that I’m working blindly, because I don’t know how to look for message errors that help me to identify the problem. In the firefox console don’t appear any messages related to PHP or database connection.
I ask please help on this.
Thanks.

[Peter StoevKeymaster]

Hi max6432,

The part which depends on us – widget initialization and php code works and is available as online demo as well(http://www.jqwidgets.com/jquery-widgets-demo/demos/php/grid.htm?arctic). We can suggest you to debug your application and especially the parts related to the Database Connection(password, username), “url” parameter for the dataAdapter/Ajax call. If you see a “loading” message, that means that jqxDataAdapter makes Ajax call to your server and the fact that it displays “no data to display” means that your Server fails to return data due to some reason.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[max6432Participant]

Peter, thanks for the answer. I know the widget works because it worked fine in my PC (localhost). But now in openshift I don’t get any data, and the key is “due to some reason”. I suppose that it has to do with de server connection, but I would like to see error messages that help me to indentify specifically which is the reason (e.g. “syntax error” or “wrong password”).
Should I look for the answer in another site like openshift or php forums? Should you recommend me any other host for that kind of applications?
Regards. Max

[Peter StoevKeymaster]

Hi Max,

We can help with using our widgets and their APIs. The problem here is more related to Server-DB communication and what the Server returns as data. We would not be able to help more with that one. If you are sure that the “url”, “password” and “username” are correct, then I suggest you to look for some ways to debug your Server code. We do not have experience with OpenShift.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[max6432Participant]

Thanks, I´ll look information specifically about the server.
Regards

[max6432Participant]

After much surfing, I finally found the answer which I would like to share with people that is trying to use JQWidgets with Openshift.
You simply need to paste the following text into connect.php file:

<?php
# FileName=”connect.php”
$hostname = getenv(“OPENSHIFT_MYSQL_DB_HOST”);
$username = getenv(“OPENSHIFT_MYSQL_DB_USERNAME”);
$password = getenv(“OPENSHIFT_MYSQL_DB_PASSWORD”);
$database = getenv(“OPENSHIFT_APP_NAME”);
?>

And the connection comes alive!!

[Author]

Posts