i updated Ubuntu 14 to Ubuntu 16.04 on my testserver to get compatible with my ISP's server.
My configuration as shown in phpMyAdmin, which runs fine!:
- Server: Localhost via UNIX socket
- Server type: MySQL
- Server version: 5.7.17-0ubuntu0.16.04.1 - (Ubuntu)
- Protocol version: 10
- User: root@localhost
- Server charset: UTF-8 Unicode (utf8)
- Apache/2.4.18 (Ubuntu)
- Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407
- PHP extension: mysqli Documentation
- PHP version: 7.0.13-0ubuntu0.16.04.1
My test-script below create an empty screen in web-browser:
<?php
$link = mysqli_connect("localhost", "root", "cydb4tsa", "RedGround");
/* check connection */
if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit();
}else{ echo "connected"; }
mysqli_close($link);
?>i found no relevant error-message in /var/log/mysql/error.log
mysql runs on the command line including all queries from imported tables:
sebu@sebu-Inspiron-3437:~$ mysql -u root -p<pw> RedGround
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>apache2 runs, browser show default page and
ls /etc/apache2/mods-enabled/ | grep php
php7.0.conf
php7.0.loadphp7 runs, browser show all infos
phpMyAdmin runs normally although an error is displayed:Connection for controluser as defined in your configuration failed.
still get empty screen, when i run above php-script. Maybe a communication-error between mysql and php?
sebu@sebu-Inspiron-3437:~$ php -m
[PHP Modules]
calendar Core ctype date dom exif fileinfo filter ftp gd gettext hash
iconv json libxml mbstring mcrypt mysqli mysqlnd openssl pcntl pcre PDO
pdo_mysql Phar posix readline Reflection session shmop SimpleXML sockets SPL
standard sysvmsg sysvsem sysvshm tokenizer wddx xml xmlreader xmlwriter xsl
Zend OPcache zlib
[Zend Modules]
Zend OPcachescreen of my project after update on my lap, localhost:screen of my project online onISP-server:
1 Answer
SOLVED Browser can disply output with following style:
<? // should be <?php, but it works anyway because $server = $_SESSION['database_host']; $datenbank = $_SESSION['database_name']; $username = $_SESSION['database_user']; $passwort = $_SESSION['database_user_pw']; $mySQL = new mysqli($server,$username,$passwort,$datenbank); if ($mySQL->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } else { $sql = "SELECT count(fldID) count from tblPerson"; // echo"$sql<br>"; if (!$result = $mySQL->query($sql)) { echo "query \"$sql\" failed because $mySQL->error"; exit; } if (! $result->num_rows) exit; $actor = $result->fetch_assoc(); $nbr = $actor['count']; echo "nuber is: ".$nbr." persons"; }
?>