php can connect mysql, but can't do anything else?

towlie · 04-26-2004, 01:05 AM

hey everyone:

First off, my apologies for the really long post, and if it would be more
appropriate in another forum, please let me know so I'll know next time.

I'm making a web app with php and mysql. Using the default versions
which came with Slack 9.1.
For some reason, i can get php to make a connection with mysql,
but none of the other functions seem to work, even though I'm
connecting as root.

Here is the code (just a test to demonstrate the problem):

<html> <body>
<head> <title></title> </head>

<?php
$link= mysql_connect('localhost', mysqlu(), mysqlp()) ||
exit("couldn't connect");

echo 'db connected';

$db_sel= mysql_select_db("nonexistentdb", $link);

if( !($db_sel) )
echo mysql_errno( $link ) . ": " . mysql_error( $link );
?>
</body> </html>

The mysqlu() and mysqlp() return 'root' and 'rootpassword'.
This is the same example as in the php manual (html) page
for msyql_select_db.

The mysql_select_db is the function i used in this case, but
none of my other mysql functions, other than connect,
seem to be working.

Below is the output followed by some version info, as well
as php.ini. I also tried changing the default socket path
line in php.ini to:
/var/run/mysql/mysql.sock
and restarting the system. But the output was exactly
the same.

Thanks for all your help!

----------------------------------------------------------------------

db connected

:

----------------------------------------------------------------------

below is the actual html (output) source:

<html>

<head> <title></title> </head>

<body>
db connected<br><br>:
</body>
</html>

-----------------------------------------------------------------------

here is some version info:

PHP 4.3.3 (cgi-fcgi) (built: Sep 12 2003 00:18:31)

mysql Ver 12.21 Distrib 4.0.15a, for slackware-linux (i486)

------------------------------------------------------------------------

here are some lines from php.ini

; Load the MySQL module by default. Comment this out if you don't use MySQL.
extension=mysql.so

[SQL]
sql.safe_mode = Off

[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
mysql.max_persistent = -1

; Maximum number of links (persistent + non-persistent). -1 means no limit.
mysql.max_links = -1

; Default port number for mysql_connect(). If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
; at MYSQL_PORT.
mysql.default_port =

; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =

; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password! And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =

; Maximum time (in secondes) for connect timeout. -1 means no limimt
mysql.connect_timeout = 60

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Erros will be displayed.
mysql.trace_mode = Off

msound · 04-26-2004, 03:28 PM

if you're new to php and mysql I would suggest logging in to mysql locally if you have direct access to the server. just do mysql -u username -p and enter your password.

Once you connect locally try out a few functions like creating databases and tables. Then insert some values into the tables.

The reason I suggest this is becuase I learned mysql while I learned php, most of the time the mysql errors came becuase my php syntax was incorrect. By working with mysql directly, you can get used to the syntax and plug it in to php a little more easily.

If mysql works locally and you still cant get it to work with php scripts, try looking for php-mysql packages. I know with redhat you have to install a specific package to make php and mysql to work together. I've never used slackware but if its like redhat, you may not have all of the packages installed to get the 2 apps to run together.

you're the worst character ever towlie

towlie · 04-26-2004, 04:17 PM

msound:

Thanks for the response.

I can log in to mysql in the console, and everything works great there. I have a functional db with 8 or so tables.

However, with trying to connect with php from the cgi-module, mysql_connect() is all I can get to work. I can't even get mysql_errno() and mysql_error() working, so I don't even know where to start looking for a problem.

Instead, does anyone know if there's a log file I could look at, perhaps one created by php, mysql, or even apache?

As for the packages, i'm using the defaults of what the slackware guys put on here, so I don't know why they wouldn't work. Kind of hesitant to reinstall something myself since almost everything else from the install cd seems to be working.

I will look around for some packages though.

And remember ... if you're going to the pool or the beach, dont forget to bring a towel!