Re: can't access mysql from a php script

remove --without-mysql: You need to explicitly enable mysql like this: ./configure --with-apxs2=/usr/local/apache-2.2.0/bin/apxs' --prefix=/usr/local/php-5.1.2' --with-mysql=shared,/downloads/mysql/bin/mysql-standard-5.0.18-linux-i686' --with-mysqli=shared,/downloads/mysql/bin/mysql-standard-5.0.18-linux-i686/bin/mysql_config' --with-mysql-sock=/var/lib/mysql/mysql.sock' --with-mhash' --enable-shared=yes' --enable-all=shared' and anything else you want to compile php with. Alter the paths to suite your environment. Keith In theory, theory and practice are the same; in practice they are not. To unsubscribe from this list, please see detailed instructions already posted at: http://marc.theaimsgroup.com/?l=php-install&m=114138567814319&w=2 On Wed, 22 Mar 2006, Jahislove wrote: > To: php-install@lists.php.net > From: Jahislove <jahislove@wanadoo.fr> > Subject: [PHP-INSTALL] can't access mysql from a php script > > 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?