can't access mysql from a php script
| From: | Jahislove | Date: | Wed, 22 Mar 2006 21:15:52 +0000 |
| Subject: | can't access mysql from a php script | ||
| Groups: | php.install | ||
| Request: | Send a blank email to php-install+get-17223@lists.php.net to get a copy of this message | ||
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?