php and mysql

lynger · 11-17-2003, 11:44 PM

hi

im using openna linux and im hving problm how to connect php4 to mysql. i'v check the configurations and many times to some books but it stil dosnt display the results i needed.

here i tested if im really connected to the localhost database but unfortunately no display.

<html>
<title>test</title>
<body>

<?php

$db = mysql_connect("localhost", "username", "mypass") or die("could not connect:" . mysql_error()) ;
echo "link is ".$db;

?>

</body>
</html>

pls. help.. maybe some advices or tips i might need. thnk you for your time

lyn

Cerbere · 11-18-2003, 12:26 AM

There are lots of things that could be wrong. And your post doesn't really give many clues. Is mysql running? Is it configured? How about apache? Will it process other php files?

The only thing I could suggest is opening the following php file to see if php is even configured for mysql, or if apache is configured for php:

Code:

<?php
phpinfo();
?>

Look at the page to see if there is something like this:
'--with-mysql=shared,/usr'
in the Configure Command section.

You have to post some more info about how you installed & configured php, mysql, and apache, otherwise we have no way of knowing what you need to do.

Enjoy!
--- Cerbere

lynger · 11-19-2003, 12:09 AM

hi,

I'm sory for the lack of details. but my answer is yes.. mysql-3.23 is configured and running, apache-2.0 server is configured and running. php is conifured.. and i got these result running phpinfo():

./configure' '--host=i686-pc-linux-gnu' '--build=i686-pc-linux-gnu' '--target=i686-openna-linux' '--program-prefix=' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--includedir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--prefix=/usr' '--with-layout=GNU' '--with-config-file-path=/etc/httpd' '--with-apxs2=/usr/sbin/apxs' '--with-exec-dir=/usr/bin' '--with-openssl' '--with-zlib' '--with-bz2' '--with-gd' '--with-ttf' '--with-png' '--with-jpeg-dir=/usr' '--with-png-dir=/usr' '--with-freetype-dir=/usr' '--with-expat-dir=/usr' '--with-gmp' '--with-xml' '--with-curl' '--with-mm' '--with-imap=shared' '--with-imap-ssl' '--with-pspell' '--with-gettext' '--with-mysql=shared,/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-pgsql=shared' '--with-ldap=shared' '--with-pear' '--disable-static' '--disable-debug' '--disable-rpath' '--disable-posix' '--disable-tokenizer' '--enable-discard-path' '--enable-safe-mode' '--enable-magic-quotes' '--enable-bcmath' '--enable-dio' '--enable-gd-native-ttf' '--enable-sysvsem' '--enable-sysvshm' '--enable-sockets' '--enable-track-vars' '--enable-wddx' '--enable-inline-optimization' '--enable-memory-limit'

php.ini

[MySQL]
mysql.allow_persistent = On
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port =
mysql.default_socket = /var/lib/mysql/mysql.sock
mysql.default_host =
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 0
mysql.trace_mode = Off

httpd.conf
Dynamic Shared Object (DSO) Support
#
LoadModule access_module modules/mod_access.so
#LoadModule auth_module modules/mod_auth.so
#LoadModule auth_dbm_module modules/mod_auth_dbm.so
#LoadModule auth_digest_module modules/mod_auth_digest.so
#LoadModule file_cache_module modules/mod_file_cache.so
LoadModule include_module modules/mod_include.so
LoadModule log_config_module modules/mod_log_config.so
LoadModule env_module modules/mod_env.so
LoadModule mime_magic_module modules/mod_mime_magic.so
#LoadModule cern_meta_module modules/mod_cern_meta.so
#LoadModule expires_module modules/mod_expires.so
#LoadModule headers_module modules/mod_headers.so
#LoadModule usertrack_module modules/mod_usertrack.so
#LoadModule unique_id_module modules/mod_unique_id.so
LoadModule setenvif_module modules/mod_setenvif.so
#LoadModule ssl_module modules/mod_ssl.so
LoadModule mime_module modules/mod_mime.so
#LoadModule dav_module modules/mod_dav.so
LoadModule autoindex_module modules/mod_autoindex.so
LoadModule cgi_module modules/mod_cgi.so
#LoadModule dav_fs_module modules/mod_dav_fs.so
#LoadModule vhost_alias_module modules/mod_vhost_alias.so
#LoadModule negotiation_module modules/mod_negotiation.so
LoadModule dir_module modules/mod_dir.so
#LoadModule actions_module modules/mod_actions.so
#LoadModule speling_module modules/mod_speling.so
LoadModule alias_module modules/mod_alias.so
LoadModule rewrite_module modules/mod_rewrite.so
LoadModule perl_module modules/mod_perl.so
LoadModule php4_module modules/libphp4.so

---pls. help.. : (

Cerbere · 11-19-2003, 02:12 AM

I think you need to edit your php.ini file. The line:

mysql.connect_timeout = 0

should be:

mysql.connect_timeout = -1

for no limit. A value of 0 means it times out in 0 seconds.

Enjoy!
--- Cerbere

lynger · 11-19-2003, 03:04 AM

hi Cerbere

you're right about 0 and -1 but unfortunately it stl dosnt work.. i get no results or error using this:

<html>
<title>test</title>
<body>

<?php
define ('DB_USER', 'user1');
define ('DB_PASS', 'password');
define ('DB_HOST', 'localhost');
define ('DB_NAME', 'mydb');

$db = mysql_connect(DB_HOST, DB_USER, DB_PASS) or die('could not connect ' . mysql_error()) ;
mysql_select_db(DB_NAME) or die('could not connect to database ' . mysql_error());
$sql = "Select Username from Customer";
$result = mysql_query("$sql");
echo "Results are $result<br>\n";

?>
</body>
</html>

slizadel · 11-19-2003, 05:02 AM

When you say that you get no results or error, are you not recieving any output from the code, or are you simply not receiving the desired ouput from the code?

Quote:

echo "Results are $result<br>\n";

If apache and php are properly configured to work together, the code should at least return: Results are

lynger · 11-19-2003, 06:45 PM

hi

yes.. i dont get any result from the code above, at least i'm expecting an error to show if im not connectd to the db or its result if connectd.. but when i test phpinfo() i get the desired result (description of php) which tells me that php and apache are working.. On the side of mysql, the database is been used for months now. priviledges, users and passwords are set.

could i pls ask a sample copy of php.ini, httpd.conf ? thank you for your time

lynger · 11-20-2003, 12:30 AM

hi forum

i know found out the problm ( but not yet solve : ( ), i enabled log_errors to see some log files and there i came out an error after restarting httpd.
error: Unable to load dynamic library /usr/lib/php4/mysql.so

den i get an eror: PHP fatal error Call to undefined function mysql_connect()

it seems im missing mysql.so ...pls. help

DirtDart · 11-21-2003, 05:15 AM

Quote:

den i get an eror: PHP fatal error Call to undefined function mysql_connect()

You need to install the php-mysql package.

lynger · 11-21-2003, 06:30 AM

hi

sorry again for the lack of details.. if you have read above , php mysql and apache are installed.. so after restarting httpd i get an error saying "Unable to load dynamic library /usr/lib/php4/mysql.so "

so i get on testing by browsing my index.php where i get an error "PHP fatal error Call to undefined function mysql_connect()" in the log files..

thnx for your time

_KDF · 11-21-2003, 10:02 AM

Is the file even there ? do as root

updatedb

then (as any user)

locate mysql.so

and post the results.

lynger · 11-21-2003, 09:12 PM

hi..

the result(s) i had.... /var/lib/mysql/mysql.sock

Cerbere · 11-22-2003, 01:42 AM

So, we're back to one of the questions from my first post: How did you install PHP (and mySQL and Apache)? I'm not familiar with openna Linux. Does it have some sort of package system, or did you install from source? It seems as if the install wasn't complete. You may have to reinstall PHP, paying particular attention to any configure options that deal with mySQL. For example:

./configure --with-mysql=/usr/local/mysql

Enjoy!
--- Cerbere

lynger · 11-23-2003, 11:31 PM

hi Cerbere : )

I installed all the packages via RPM's which came with the installer cd..

# rpm -Uvh php-4.0......

really not using tar files.. but as you've seen in the results from phpinfo(), there's the line your wanting to see..

gettext' '--with-mysql=shared,/usr' '--with-mysql-sock=/var/lib/mysql/mysql.sock' '--with-pgsql=shared' '--with-ldap=shared'

..Gee.. i really had a hard time working with php

Maybe i'l try reinstalling the package from start.. Is there an installer( rpm or tar files ) you could send me ??

thank you for you time..

lynger · 11-24-2003, 03:22 AM

hi forum

At last.. php and mysql are working well.. thank you all for your help..

more power forum..

---- after i reinstalled all the packages.. it worked wel..