A7med Baraka

Member
Jan 1, 2010
5
0
51
i want to enable mysqli

i searched for that and i found i have to run this
Code:
./configure --with-mysql=/usr –with-mysqli=/usr/bin/mysql_config
but its return that
Code:
-bash: ./configure: No such file or directory
if this right where i have to write this command to run right
Code:
./configure --with-mysql=/usr –with-mysqli=/usr/bin/mysql_config
if no what i have to do to enable it ??

kindly if anybody can help me show me the steps in details
i hope anybody can help me in that

thnx alot all
 

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,545
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
You can enable this through easy apache, then go to the exhaustive options list.
ChrisRHS is correct; enabling the "mysqli" extension in PHP (v5) may be performed via EasyApache, using the Exhaustive Options List.

For additional reference on using EasyApache I recommend the following documentation resources:
Apache & cPanel/WHM
The Options Lists
EasyApache (Apache Update)
Exhaustive Options List

EastApache may be found in WHM at the following menu path:
WHM: Main >> Software >> EasyApache (Apache Update)

EasyApache may also be initiated using the following command via root SSH access:
Code:
# /scripts/easyapache
 

A7med Baraka

Member
Jan 1, 2010
5
0
51
You can enable this through easy apache, then go to the exhaustive options list.
thnx alot ChrisRHS

ChrisRHS is correct; enabling the "mysqli" extension in PHP (v5) may be performed via EasyApache, using the Exhaustive Options List.

For additional reference on using EasyApache I recommend the following documentation resources:
Apache & cPanel/WHM
The Options Lists
EasyApache (Apache Update)
Exhaustive Options List

EastApache may be found in WHM at the following menu path:
WHM: Main >> Software >> EasyApache (Apache Update)

EasyApache may also be initiated using the following command via root SSH access:
Code:
# /scripts/easyapache
thnx alot cPanelDon

i do that and choose

Mysql
compile MySQL support using the PHP bundled libraries (if the System MySQL option is checked it takes precedence over this option)

Mysql of the system
compile mysql (and mysqli if its checked) support against the system libraries

MySQL "Improved" extension.
MySQLi does not replace the standard MySQL extension. Requires MySQL 4.1 or later. !! mysqli may not work on all systems, contact your support provider for mysqli support !!


finished when check if this function exist or no it show me no ??
 

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,545
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
thnx alot ChrisRHS

thnx alot cPanelDon

i do that and choose
Mysql: compile MySQL support using the PHP bundled libraries (if the System MySQL option is checked it takes precedence over this option)

Mysql of the system: compile mysql (and mysqli if its checked) support against the system libraries

MySQL "Improved" extension: MySQLi does not replace the standard MySQL extension. Requires MySQL 4.1 or later. !! mysqli may not work on all systems, contact your support provider for mysqli support !!

finished when check if this function exist or no it show me no ??
The following command may be used to list MySQL modules installed in PHP:
Code:
# /usr/local/bin/php -m | grep -i mysql
As an example, you might see "mysql" and "mysqli"
Code:
# /usr/local/bin/php -m | grep -i mysql
mysql
mysqli
 

A7med Baraka

Member
Jan 1, 2010
5
0
51
yes it return
mysql
mysqli

but when test it using
PHP:
<?php
if (function_exists('mysqli')) {
    echo "Yes.<br />\n";
} else {
    echo "No.<br />\n";
}
?>
it shown me NO ??!!
any suggest ??
 

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,545
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
yes it return
mysql
mysqli

but when test it using
PHP:
<?php
if (function_exists('mysqli')) {
    echo "Yes.<br />\n";
} else {
    echo "No.<br />\n";
}
?>
it shown me NO ??!!
any suggest ??
The provided PHP script is not a valid test for MySQLi support; a minor edit to the script will help; change mysqli to mysqli_connect.

Please refer to the official PHP documentation for more verbose details: PHP: The MySQLi Extension Function Summary - Manual
 

cPanelDon

cPanel Quality Assurance Analyst
Staff member
Nov 5, 2008
2,545
12
268
Houston, Texas, U.S.A.
cPanel Access Level
DataCenter Provider
Twitter
also return NO ??
When loading a PHP info page from the same path as the other script(s):
1.) Does it show PHP version 4 or does it show PHP version 5?
2.) Does it indicate support for MySQLi?
Code:
<?php
phpinfo();
?>
Reference: PHP: phpinfo - Manual


Is MySQL at least version 4.1.13 or newer or 5.0.7 or newer? The following commands via SSH access could be used to confirm:
Code:
# mysql -V
# mysqld -V
# mysqladmin version | grep -i ver
Reference: PHP: MySQLi Requirements - Manual
 
Last edited: