Re: [PHP] Mysqli Extension

Matijn Woudt wrote:
> On Mon, Aug 19, 2013 at 9:40 PM, Ashley
Sheridan
> <[email protected]>wrote:
> 
>>
>>
>> Matijn Woudt
<[email protected]> wrote:
>> >On Mon, Aug 19, 2013 at
8:55 PM, Ashley Sheridan
>>
><[email protected]>wrote:
>> >
>> >>
>> >>
>> >> Curtis
Maurand <[email protected]> wrote:
>> >> >
>> >> >
>> >> >Ethan Rosenberg
wrote:
>> >> >> Dear List -
>> >>
>>
>> >> >> My
>> >>
>mysqli extension seems to have gone away.
>> >>
>>
>> >> >> $host =
>> >>
>'localhost';
>> >> >> $user = 'root';
>> >> >> $password = 'SdR3908';
>> >>
>> echo "hello2<br />";
>> >>
>>
>> >>
>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

<?
$conn = new mysqli("localhost",
"user", "password", "mysql");

if
($conn->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