Mysql to mysql latest version

QuestionsMysql to mysql latest version
Gary asked 1 year ago

Hi Abu, I am having to move my sites hosting to another provider who run php7, as I understand this doesn’t work with mysql code. I have the latest version of phpgrid but am having lots of issues when trying to upgrade my old phpgrid version. Can you tell me the files I should be replacing to move from old to new?

3 Answers
Abu Ghufran Staff answered 1 year ago

Simply override `lib/inc` & `lib/js` from latest build to the phpgrid folder in previous implementations.

Abu Ghufran - Dev Team
PHP Grid Framework
Gary answered 1 year ago

Thank you, I tried that but throws errors everywhere. I notice in my old version the connection code is different, maybe thats it?
//old version
// include db config
// set up DB
//new version
// include db config
// include and create object
// Database config file to be passed in phpgrid constructor
$db_conf = array(
“server” => PHPGRID_DBHOST,
“password” => PHPGRID_DBPASS,
“database” => PHPGRID_DBNAME
Is the latest version the best to use?

Abu Ghufran Staff answered 1 year ago

PHP7 does not support mysql_* functions and removed them from php.
So you need to remove them from code and change it with new $db_conf setting.
Also make sure you set PHPGRID_DBTYPE to “mysqli” in ../../config.php file. (i added after mysql – mysqli)

Abu Ghufran - Dev Team
PHP Grid Framework
Your Answer

7 + 16 =

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.

How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!