Mysql – CentOS 7 thesqli works on php apache but not on php-cli

centos7MySQLphp-cliphp7

I have php7.2 installed(from remi repository) in CentOS 7.5. I want to access mysqli from command line php. When trying, it shows the error:

Call to undefined function mysqli_connect()

The php running with apache works fine with mysqli. All extensions installed through yum reflects perfectly here. But for the php command line(which is parsing a different php.ini file), the extensions are not loaded.

Do I need to separately add the extensions for commandline php? If so how? Or any other alternative? Please let e know if you need any further information.

Thank you for your time.

Best Answer

As pointed out by Michael Hampton (thanks) in the comment, there were two php installations in the server. I have arrived at two different solutions based on specific need:

For php-cli:

In the .bash_profile, the following line is added
alias php="/usr/bin/php"

For running PHP from java servlet (as command):

Use

String[] commands = {"bash", "-c", "/usr/bin/php myphpfile.php arg01 arg02"};
File dir = new File("<my-php-file-directory>");
try{
Process process;
process = Runtime.getRuntime().exec(commands, null, dir);
process.waitFor();
....
....
}

Thats all

php -modules in the terminal gives the desired output with mysqli.

Related Solutions

Mysql – php-cgi shows thesql modules but throws “Call to undefined function thesql_connect()” error

You have compiled PHP with support of mysqli extension (mysqli_* functions)... but the error clearly shows that you are using mysql_connect() function (without "i", which belongs to mysql extension). These are 2 different extensions: mysqli stands for "MySQL Improved" and is preferred to use over older and less feature-rich mysql.

You have 2 choices:

1) Update your code to use mysqli_* functions

2) Compile your PHP again with mysql extension support (do not forget to enable it later in php.ini)

P.S. In any case I would recommend to use PDO for your database needs (if you can, of course).

Php – Apache executes HTML, but not PHP; PHP CLI works

It seems that php5_module is already loaded by yourself and loaded later by the default rhel6 configuration or the configuration on rhel6 is loading the module php5_module... which in itself doesn't matter except for the fact that the configuration you are entering is being overridden by the default rhel6 configuration.

Looking at step 11 from Dan's site, which has worked for me in the past whenever I forgot and needed a quick reminder:

# Make sure there's only **1** line for each of these 2 directives:

# Use for PHP 4.x:
#LoadModule php4_module modules/libphp4.so
#AddHandler php-script .php

# Use for PHP 5.x:
LoadModule php5_module modules/libphp5.so
AddHandler php5-script .php 

# Add index.php to your DirectoryIndex line:
DirectoryIndex index.html index.php

AddType text/html .php

# PHP Syntax Coloring
# (optional but useful for reading PHP source for debugging):
AddType application/x-httpd-php-source phps

Best Answer

Related Solutions

Mysql – php-cgi shows thesql modules but throws “Call to undefined function thesql_connect()” error

Php – Apache executes HTML, but not PHP; PHP CLI works

Related Topic