Re: [PHP] Mysqli Extension
Matijn Woudt wrote: apt-get install php5-mysql Just to elaborate on that ... php5-common and php5-cli does not include a number of modules that need to be loaded separately. Choosing one of the database modules is not the only thing that may need to be added to your list of additional installations. -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Mysqli Extension
Matijn Woudt wrote:
> On Mon, Aug 19, 2013 at 9:40 PM, Ashley
Sheridan
> wrote:
>
>>
>>
>> Matijn Woudt
wrote:
>> >On Mon, Aug 19, 2013 at
8:55 PM, Ashley Sheridan
>>
>wrote:
>> >
>> >>
>> >>
>> >> Curtis
Maurand wrote:
>> >> >
>> >> >
>> >> >Ethan Rosenberg
wrote:
>> >> >> Dear List -
>> >>
>>
>> >> >> My
>> >>
>mysqli extension seems to have gone away.
>> >>
>>
>> >> >> $host =
>> >>
>'localhost';
>> >> >> $user = 'root';
>> >> >> $password = 'SdR3908';
>> >>
>> echo "hello2";
>> >>
>>
>> >>
>var_dump(function_exists('mysqli_connect'));// this returns
>> >boo(false)
>> >> >> $db =
'Store';
>> >> >> $cxn =
>> >>
>mysqli_connect($host,$user,$password,$db);
>> >>
>>
>> >> >> I tried to
>> >>
>reinstall -
>> >> >>
>> >>
>> rosenberg:/home/ethan# apt-get install
>> >>
>php5-common libapache2-mod-php5
>> >> >>
php5-cli
>> >> >> Reading
>> >>
>package lists... Done
>> >> >> Building
dependency tree
>> >> >> Reading
>>
>> >state information... Done
>> >> >>
libapache2-mod-php5 is already the
>> >> >newest
version.
>> >> >> libapache2-mod-php5 set to
manually
>> >> >installed.
>> >>
>> php5-cli is already the newest version.
>> >>
>>
>> >> >php5-cli set to manually installed.
>> >> >> php5-common is already the
>>
>> >newest version.
>> >> >> php5-common
set to manually installed.
>> >> >>
>>
>> >0 upgraded, 0 newly installed, 0 to remove and 0 not
upgraded.
>> >> >>
>> >> >
>> >> >> It did not help.
>> >>
>>
>> >> >> TIA
>> >>
>>
>> >> >>
>> >>
>Ethan
>> >> >>
>> >> >>
--
>> >> >> PHP General Mailing List
>>
>> >(http://www.php.net/)
>> >> >> To
unsubscribe, visit:
>> >>
>http://www.php.net/unsub.php
>> >> >>
>> >> >>
>> >> >
>>
>> >
>> >> >Found
>> >>
>this in ubuntu forums.
>> >> >
>>
>> >http://ubuntuforums.org/showthread.php?t=1814736
>> >> >
>> >> >
>>
>> >sudo apt-get install
>> >> >php5-mysql
>> >> >This package contains the PHP module that
interfaces with the MySQL
>> >> >server.
>>
>>
>> >> Could it be that the mysql service on the
server has stopped.
>> >Typically
>> >>
you'd do something like this on RedHat/Fedora servers:
>>
>>
>> >> service mysqld status
>>
>>
>> >> That would certainly stop the extension
working from within PHP.
>> >>
>> >>
Thanks,
>> >> Ash
>> >>
>>
>>
>> >I'm sorry, but this is just plain wrong.
>> >The extension has nothing to do with the mysql service. In
fact, a lot
>> >of
>> >the larger websites
have their database service running at a different
>>
>server, and probably don't even have the mysql service installed.
>> >
>> >- Matijn
>>
>>
Look at his connection settings, it says localhost...
>>
>> Thanks,
>> Ash
>>
>
>
> var_dump(function_exists('**mysqli_connect'));// this returns
boo(false)
>
> I think it explains everything.
>
You guys aren't being terribly helpful. My mostly stock
12.04 has the mysqli library so something else is going on. You
might give the guy a little direction rather than berating him. or
me. His question was about the library being missing. My
answer was that it was included in the php_mysql package already and that
was the correct answer to his question. The following is the result
of a "locate mysqli" I've also followed with a sample
script that I ran against the localhost database which returned 11
rows.
These are the results of the locate command.
/usr/include/php5/ext/mysqli
/usr/include/php5/ext/mysqli/php_mysqli_structs.h
/usr/lib/php5/20090626/mysqli.so
/usr/share/man/man1/mysqlimport.1.gz
/usr/share/php/.registry/mdb2_driver_mysqli.reg
/usr/share/php/MDB2/Driver/mysqli.php
/usr/share/php/MDB2/Driver/Datatype/mysqli.php
/usr/share/php/MDB2/Driver/Function/mysqli.php
/usr/share/php/MDB2/Driver/Manager/mysqli.php
/usr/share/php/MDB2/Driver/Native/mysqli.php
/usr/share/php/MDB2/Driver/Reverse/mysqli.php
/usr/share/php/data/MDB2_Driver_mysqli
/usr/share/php/data/MDB2_Driver_mysqli/package_mysqli.xml
/usr/share/php/test/MDB2_Driver_mysqli
/usr/share/php/test/MDB2_Driver_mysqli/tests
/usr/share/php/test/MDB2_Driver_mysqli/tests/MDB2_nonstandard_mysqli.php
connect_errno)
{
printf("Connect failed:
%s\n", $conn->connect_error);
exit();
}
if ($result = $conn->query("SELECT * FROM user")){
printf("Select returned %d rows.\n",
$result->num_rows);
$result->close();
}
Mind you I had a lot wrong with this script as I wrote it
because I don't generally use mysqli directly and mysqli didn't complain
about things being wrong. I thought that was a bit strange since I
work mostly in Java these days and Java complains mercilessly about this
that and the other thing.
Curtis
Re: [PHP] Mysqli Extension
On Mon, Aug 19, 2013 at 9:40 PM, Ashley Sheridan
wrote:
>
>
> Matijn Woudt wrote:
> >On Mon, Aug 19, 2013 at 8:55 PM, Ashley Sheridan
> >wrote:
> >
> >>
> >>
> >> Curtis Maurand wrote:
> >> >
> >> >
> >> >Ethan Rosenberg wrote:
> >> >> Dear List -
> >> >>
> >> >> My
> >> >mysqli extension seems to have gone away.
> >> >>
> >> >> $host =
> >> >'localhost';
> >> >> $user = 'root';
> >> >> $password = 'SdR3908';
> >> >> echo "hello2";
> >> >>
> >> >var_dump(function_exists('mysqli_connect'));// this returns
> >boo(false)
> >> >> $db = 'Store';
> >> >> $cxn =
> >> >mysqli_connect($host,$user,$password,$db);
> >> >>
> >> >> I tried to
> >> >reinstall -
> >> >>
> >> >> rosenberg:/home/ethan# apt-get install
> >> >php5-common libapache2-mod-php5
> >> >> php5-cli
> >> >> Reading
> >> >package lists... Done
> >> >> Building dependency tree
> >> >> Reading
> >> >state information... Done
> >> >> libapache2-mod-php5 is already the
> >> >newest version.
> >> >> libapache2-mod-php5 set to manually
> >> >installed.
> >> >> php5-cli is already the newest version.
> >> >>
> >> >php5-cli set to manually installed.
> >> >> php5-common is already the
> >> >newest version.
> >> >> php5-common set to manually installed.
> >> >>
> >> >0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
> >> >>
> >> >
> >> >> It did not help.
> >> >>
> >> >> TIA
> >> >>
> >> >>
> >> >Ethan
> >> >>
> >> >> --
> >> >> PHP General Mailing List
> >> >(http://www.php.net/)
> >> >> To unsubscribe, visit:
> >> >http://www.php.net/unsub.php
> >> >>
> >> >>
> >> >
> >> >
> >> >Found
> >> >this in ubuntu forums.
> >> >
> >> >http://ubuntuforums.org/showthread.php?t=1814736
> >> >
> >> >
> >> >sudo apt-get install
> >> >php5-mysql
> >> >This package contains the PHP module that interfaces with the MySQL
> >> >server.
> >>
> >> Could it be that the mysql service on the server has stopped.
> >Typically
> >> you'd do something like this on RedHat/Fedora servers:
> >>
> >> service mysqld status
> >>
> >> That would certainly stop the extension working from within PHP.
> >>
> >> Thanks,
> >> Ash
> >>
> >>
> >I'm sorry, but this is just plain wrong.
> >The extension has nothing to do with the mysql service. In fact, a lot
> >of
> >the larger websites have their database service running at a different
> >server, and probably don't even have the mysql service installed.
> >
> >- Matijn
>
> Look at his connection settings, it says localhost...
>
> Thanks,
> Ash
>
var_dump(function_exists('**mysqli_connect'));// this returns boo(false)
I think it explains everything.
- Matijn
Re: [PHP] Mysqli Extension
On Aug 19, 2013 2:32 PM, "Ethan Rosenberg"
wrote:
>
> Dear List -
>
> My mysqli extension seems to have gone away.
>
(REACTED)
Remember: avoid putting passwords - especially for root users - on a
public mailing list, which is also permanently archived.
> echo "hello2";
> var_dump(function_exists('mysqli_connect'));// this returns boo(false)
> $db = 'Store';
> $cxn = mysqli_connect($host,$user,$password,$db);
>
> I tried to reinstall -
>
> rosenberg:/home/ethan# apt-get install php5-common libapache2-mod-php5
php5-cli
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> libapache2-mod-php5 is already the newest version.
> libapache2-mod-php5 set to manually installed.
> php5-cli is already the newest version.
> php5-cli set to manually installed.
> php5-common is already the newest version.
> php5-common set to manually installed.
> 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
>
> It did not help.
>
> TIA
>
> Ethan
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
Re: [PHP] Mysqli Extension
Matijn Woudt wrote:
>On Mon, Aug 19, 2013 at 8:55 PM, Ashley Sheridan
>wrote:
>
>>
>>
>> Curtis Maurand wrote:
>> >
>> >
>> >Ethan Rosenberg wrote:
>> >> Dear List -
>> >>
>> >> My
>> >mysqli extension seems to have gone away.
>> >>
>> >> $host =
>> >'localhost';
>> >> $user = 'root';
>> >> $password = 'SdR3908';
>> >> echo "hello2";
>> >>
>> >var_dump(function_exists('mysqli_connect'));// this returns
>boo(false)
>> >> $db = 'Store';
>> >> $cxn =
>> >mysqli_connect($host,$user,$password,$db);
>> >>
>> >> I tried to
>> >reinstall -
>> >>
>> >> rosenberg:/home/ethan# apt-get install
>> >php5-common libapache2-mod-php5
>> >> php5-cli
>> >> Reading
>> >package lists... Done
>> >> Building dependency tree
>> >> Reading
>> >state information... Done
>> >> libapache2-mod-php5 is already the
>> >newest version.
>> >> libapache2-mod-php5 set to manually
>> >installed.
>> >> php5-cli is already the newest version.
>> >>
>> >php5-cli set to manually installed.
>> >> php5-common is already the
>> >newest version.
>> >> php5-common set to manually installed.
>> >>
>> >0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
>> >>
>> >
>> >> It did not help.
>> >>
>> >> TIA
>> >>
>> >>
>> >Ethan
>> >>
>> >> --
>> >> PHP General Mailing List
>> >(http://www.php.net/)
>> >> To unsubscribe, visit:
>> >http://www.php.net/unsub.php
>> >>
>> >>
>> >
>> >
>> >Found
>> >this in ubuntu forums.
>> >
>> >http://ubuntuforums.org/showthread.php?t=1814736
>> >
>> >
>> >sudo apt-get install
>> >php5-mysql
>> >This package contains the PHP module that interfaces with the MySQL
>> >server.
>>
>> Could it be that the mysql service on the server has stopped.
>Typically
>> you'd do something like this on RedHat/Fedora servers:
>>
>> service mysqld status
>>
>> That would certainly stop the extension working from within PHP.
>>
>> Thanks,
>> Ash
>>
>>
>I'm sorry, but this is just plain wrong.
>The extension has nothing to do with the mysql service. In fact, a lot
>of
>the larger websites have their database service running at a different
>server, and probably don't even have the mysql service installed.
>
>- Matijn
Look at his connection settings, it says localhost...
Thanks,
Ash
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Mysqli Extension
On Mon, Aug 19, 2013 at 8:55 PM, Ashley Sheridan
wrote:
>
>
> Curtis Maurand wrote:
> >
> >
> >Ethan Rosenberg wrote:
> >> Dear List -
> >>
> >> My
> >mysqli extension seems to have gone away.
> >>
> >> $host =
> >'localhost';
> >> $user = 'root';
> >> $password = 'SdR3908';
> >> echo "hello2";
> >>
> >var_dump(function_exists('mysqli_connect'));// this returns boo(false)
> >> $db = 'Store';
> >> $cxn =
> >mysqli_connect($host,$user,$password,$db);
> >>
> >> I tried to
> >reinstall -
> >>
> >> rosenberg:/home/ethan# apt-get install
> >php5-common libapache2-mod-php5
> >> php5-cli
> >> Reading
> >package lists... Done
> >> Building dependency tree
> >> Reading
> >state information... Done
> >> libapache2-mod-php5 is already the
> >newest version.
> >> libapache2-mod-php5 set to manually
> >installed.
> >> php5-cli is already the newest version.
> >>
> >php5-cli set to manually installed.
> >> php5-common is already the
> >newest version.
> >> php5-common set to manually installed.
> >>
> >0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
> >>
> >
> >> It did not help.
> >>
> >> TIA
> >>
> >>
> >Ethan
> >>
> >> --
> >> PHP General Mailing List
> >(http://www.php.net/)
> >> To unsubscribe, visit:
> >http://www.php.net/unsub.php
> >>
> >>
> >
> >
> >Found
> >this in ubuntu forums.
> >
> >http://ubuntuforums.org/showthread.php?t=1814736
> >
> >
> >sudo apt-get install
> >php5-mysql
> >This package contains the PHP module that interfaces with the MySQL
> >server.
>
> Could it be that the mysql service on the server has stopped. Typically
> you'd do something like this on RedHat/Fedora servers:
>
> service mysqld status
>
> That would certainly stop the extension working from within PHP.
>
> Thanks,
> Ash
>
>
I'm sorry, but this is just plain wrong.
The extension has nothing to do with the mysql service. In fact, a lot of
the larger websites have their database service running at a different
server, and probably don't even have the mysql service installed.
- Matijn
Re: [PHP] Mysqli Extension
Curtis Maurand wrote:
>
>
>Ethan Rosenberg wrote:
>> Dear List -
>>
>> My
>mysqli extension seems to have gone away.
>>
>> $host =
>'localhost';
>> $user = 'root';
>> $password = 'SdR3908';
>> echo "hello2";
>>
>var_dump(function_exists('mysqli_connect'));// this returns boo(false)
>> $db = 'Store';
>> $cxn =
>mysqli_connect($host,$user,$password,$db);
>>
>> I tried to
>reinstall -
>>
>> rosenberg:/home/ethan# apt-get install
>php5-common libapache2-mod-php5
>> php5-cli
>> Reading
>package lists... Done
>> Building dependency tree
>> Reading
>state information... Done
>> libapache2-mod-php5 is already the
>newest version.
>> libapache2-mod-php5 set to manually
>installed.
>> php5-cli is already the newest version.
>>
>php5-cli set to manually installed.
>> php5-common is already the
>newest version.
>> php5-common set to manually installed.
>>
>0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
>>
>
>> It did not help.
>>
>> TIA
>>
>>
>Ethan
>>
>> --
>> PHP General Mailing List
>(http://www.php.net/)
>> To unsubscribe, visit:
>http://www.php.net/unsub.php
>>
>>
>
>
>Found
>this in ubuntu forums.
>
>http://ubuntuforums.org/showthread.php?t=1814736
>
>
>sudo apt-get install
>php5-mysql
>This package contains the PHP module that interfaces with the MySQL
>server.
Could it be that the mysql service on the server has stopped. Typically you'd
do something like this on RedHat/Fedora servers:
service mysqld status
That would certainly stop the extension working from within PHP.
Thanks,
Ash
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Mysqli Extension
Ethan Rosenberg wrote:
> Dear List -
>
> My
mysqli extension seems to have gone away.
>
> $host =
'localhost';
> $user = 'root';
> $password = 'SdR3908';
> echo "hello2";
>
var_dump(function_exists('mysqli_connect'));// this returns boo(false)
> $db = 'Store';
> $cxn =
mysqli_connect($host,$user,$password,$db);
>
> I tried to
reinstall -
>
> rosenberg:/home/ethan# apt-get install
php5-common libapache2-mod-php5
> php5-cli
> Reading
package lists... Done
> Building dependency tree
> Reading
state information... Done
> libapache2-mod-php5 is already the
newest version.
> libapache2-mod-php5 set to manually
installed.
> php5-cli is already the newest version.
>
php5-cli set to manually installed.
> php5-common is already the
newest version.
> php5-common set to manually installed.
>
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
>
> It did not help.
>
> TIA
>
>
Ethan
>
> --
> PHP General Mailing List
(http://www.php.net/)
> To unsubscribe, visit:
http://www.php.net/unsub.php
>
>
Found
this in ubuntu forums.
http://ubuntuforums.org/showthread.php?t=1814736
sudo apt-get install
php5-mysql
This package contains the PHP module that interfaces with the MySQL
server.
Re: [PHP] Mysqli Extension
On Mon, Aug 19, 2013 at 8:02 PM, Ethan Rosenberg <
erosenb...@hygeiabiomedical.com> wrote:
> Dear List -
>
> My mysqli extension seems to have gone away.
>
> $host = 'localhost';
> $user = 'root';
> $password = 'SdR3908';
> echo "hello2";
> var_dump(function_exists('**mysqli_connect'));// this returns boo(false)
> $db = 'Store';
> $cxn = mysqli_connect($host,$user,$**password,$db);
>
> I tried to reinstall -
>
> rosenberg:/home/ethan# apt-get install php5-common libapache2-mod-php5
> php5-cli
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> libapache2-mod-php5 is already the newest version.
> libapache2-mod-php5 set to manually installed.
> php5-cli is already the newest version.
> php5-cli set to manually installed.
> php5-common is already the newest version.
> php5-common set to manually installed.
> 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
>
> It did not help.
>
> TIA
>
> Ethan
>
>
apt-get install php5-mysql
If that doesn't help, there's something wrong with your configuration of
the modules.
- Matijn
