hello all ,
i am under NetBSD 3.0
and i have installed apache/php/mysql as described on this wiki
http://wiki.onetbsd.org/index.php/How_to_install_a_LAMP_Server
/usr/pkgsrc/www/apache2
/usr/pkgsrc/databases/mysql5-server
/usr/pkgsrc/www/ap-php (Installing the PHP Module for Apache)
apache work fine
php work fine
mysql work fine
but it seem that i can't access database from a php script
this little script (test.php) return only "test1" and not "test2"
without any error
<?php
$host = "localhost";
$login = "compteur";
$password = "xxxxxx";
$database = "compteur";
$table = "nb_connect";
echo "test1";
$db = mysql_connect($host, $login, $password)
or die("Impossible de se connecter : ".mysql_error());
echo "test2";
mysql_select_db($database,$db);
mysql_query("INSERT INTO $table VALUES('','blabla','30')")
or die("error : ".mysql_error());
$update = mysql_insert_id();
mysql_close($db);
?>
a phpinfo() return :
Configure Command './configure' '--without-mysql' '--without-iconv'
'--disable-posix' '--with-config-file-path=/usr/pkg/etc'
'--with-exec-dir=/usr/pkg/libexec/php4' '--with-regex=system'
'--enable-memory-limit' '--enable-track-vars' '--enable-ipv6'
'--with-openssl=/usr' '--with-apxs2=/usr/pkg/sbin/apxs'
'--prefix=/usr/pkg' '--host=mipsel--netbsd' '--mandir=/usr/pkg/man'
any idea of the problem?
is it possible that the problem come from '--without-mysql' ?
and so how can i install that?
