Bro. Pick a SQL. mysql_ or mysqli_.
Best,
Karl
Sent from losPhone
> On Apr 2, 2015, at 12:48 PM, Ethan Rosenberg <erosenberg@xxxxxxxxxxxxxxxxxxxx> wrote:
>
>> On 04/02/2015 06:17 AM, Richard wrote:
>
> <snip>
>>> Here are some hints....
>>>
>>> service apache2 restart
>>> [....] Restarting web server: apache2AH00558: apache2: Could not
>>> reliably determine the server's fully qualified domain name, using
>>> 127.0.1.1. Set the 'ServerName' directive globally to suppress
>>> this message
>>> . ok
>>>
>>>
>>> using 127.0.1.1 OUCH
>>>
>>> Added this as last line in /etc/apache2/apache2.conf
>>>
>>> ServerName localhost
>>>
>>> root@meow:/var/www# service apache2 restart
>>> [ ok ] Restarting web server: apache2
>>>
>>> OK ...good
>>>
>>> But ... I am still getting the same performance - TestConnect [the
>>> code above] gives the same result, and HandleWeight hangs!!!
>>
>> As I pointed out on the apache list, 127.0.1.1 != localhost. It's
>> not clear where all you've stapled that incorrect value in at this
>> point, but that will account for why apache gave you that error.
>>
>> In the php code, you are not handling the output from
>> mysqli_fetch_array correctly. Read the documentation, there are many
>> examples -- including q/a responses that almost exactly match your
>> code.
>>
>> You have shown no debugging effort on "HandleWeight", so we have no
>> way of providing any insights on it.
>>
>> You additionally need to provide the version/release level
>> information for your installed versions of:
>>
>> - OS
>> - apache
>> - mysql
>> - php
>
> Richard -
>
> Thanks.
>
> service Apache2 restart
> >> [....] Restarting web server: apache2AH00558: apache2: Could not
> >> reliably determine the server's fully qualified domain name, using
> >> 127.0.1.1. Set the 'ServerName' directive globally to suppress
> >> this message
>
> This is what was returned on a restart of Apache.
>
> Modified the configuration file.....
>
> Added this as last line in /etc/apache2/apache2.conf
> >>
> >> ServerName localhost
>
> Now on a restart...
>
> root@meow:/var/www# service apache2 restart
> >> [ ok ] Restarting web server: apache2
>
> Fixed the mysqli_fetch_array.
>
> OS Debian Jessie
> Apache/2.4.9 (Debian)
> MySQL Ver 14.14 Distrib 5.5.37, for debian-linux-gnu (x86_64) using readline 6.3
> PHP 5.6.0RC2 (cli)
>
> Debug
>
> Here is the connection block w/ debug.
>
> $hostname="localhost";
> $database="Store";
> $username="ethan";
> $password="xxxxx";
>
>
> $link = mysqli_connect($hostname, $username, $password);
> if (!$link) {
> die('Connection failed: ' . mysqli_error());
> }
> else{
> echo "Connection to MySQL server " .$hostname . " successful!
> " . PHP_EOL;
> }
>
> $db_selected = mysql_select_db( $link,$database);
> if (!$db_selected) {
> die ('Can\'t select database: ' . mysql_error());
> }
> else {
> echo 'Database ' . $database . ' successfully selected!';
> }
>
> Never connects. Hangs
>
>
> TIA
>
> Ethan
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
