11-20-2003
Your PHP is not compiled with MySQL functions enabled. See if there are some RPM packages with the missing libraries. For example, php-mysql (I don't know the exact name)
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I am moving from a shared hosting environment to a dedicated box. The migration also involves a mySQL database managed using a web-based PHP interface.
I can read the contents of the db (connection is good) but when I try to administer, the form variables aren't going from step 1 (add) to step 2... (0 Replies)
Discussion started by: adrious
0 Replies
2. UNIX and Linux Applications
Hi,
I'm new to mysql, I've installed MYSQL on our unix server and started MYSQL on this server.
I've now downloaded MYSQL Query Browser, when I try to connect to MYSQL server, I get the following error "could not connect to the specified instance" - MySQL Error Number 1130.
From the... (3 Replies)
Discussion started by: venhart
3 Replies
3. Programming
I've tried every type of dereferencing I can think of but I still can't get to array data.
#!/usr/bin/perl
use DBI;
use DBD::mysql;
use DBI qw(:sql_types);
$hostname = "localhost";
$database = "c2";
$username = "user";
$password = "password";
$dbh =... (4 Replies)
Discussion started by: s_becker
4 Replies
4. Web Development
Hi all,
I recently changed the name of my hostname from 'abc123' to 'abc456' (as an example).
I then added a user in my mysql database with the new host and removed references to the old users and hostname.
The strange thing is though, a process using the database still uses the old... (1 Reply)
Discussion started by: muay_tb
1 Replies
5. Linux
Hi,
I have installed mysql in linux box as mysql-5.0.77-4.el5_6.6..
I would like to start the server. But there is no mysql file in this location /etc/init.d/
Please advice how to start the server now !!
Thnaks,
Mani (5 Replies)
Discussion started by: Mani_apr08
5 Replies
6. Programming
I have a data table as follows:
mysql> select * from validations where source = "a03";
+------------+-------+--------+
| date | price | source |
+------------+-------+--------+
| 2001-01-03 | 80 | a03 |
| 2001-01-04 | 82 | a03 |
| 2001-01-05 | 84 | a03 |
| 2001-01-06... (2 Replies)
Discussion started by: figaro
2 Replies
7. Shell Programming and Scripting
i'm trying to write a bash script that executes a mysql statement
mysql -sN -e INSERT INTO "$database"."$tableprefix"users (var1, var2,var3) VALUES (123, '1','')
i don't know where to put the quotes
it doesnt work with this one: `
it seems i can only put double quotes around the... (0 Replies)
Discussion started by: vanessafan99
0 Replies
8. Shell Programming and Scripting
I'm running mysql in a bash script
mysql <<EOF
query
EOF
one query is like this:
UPDATE $dbname.$prefix"config" SET value = $var WHERE "$prefix"config.name = 'table colname';
with variable
but it's giving an error
i'm not sure what to put for
"$prefix"config.name
the table... (3 Replies)
Discussion started by: vanessafan99
3 Replies
LEARN ABOUT PHP
mysql_list_dbs
MYSQL_LIST_DBS(3) 1 MYSQL_LIST_DBS(3)
mysql_list_dbs - List databases available on a MySQL server
SYNOPSIS
Warning
This function was deprecated in PHP 5.4.0, and will be removed in the future, along with the entirety of the original MySQL exten-
sion. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more
information. Alternatives to this function include:
oSQL Query:
SHOW DATABASES
resource mysql_list_dbs ([resource $link_identifier = NULL])
DESCRIPTION
Returns a result pointer containing the databases available from the current mysql daemon.
o $
link_identifier -The MySQL connection. If the link identifier is not specified, the last link opened by mysql_connect(3) is
assumed. If no such link is found, it will try to create one as if mysql_connect(3) was called with no arguments. If no connection
is found or established, an E_WARNING level error is generated.
Returns a result pointer resource on success, or FALSE on failure. Use the mysql_tablename(3) function to traverse this result pointer, or
any function for result tables, such as mysql_fetch_array(3).
Example #1
mysql_list_dbs(3) example
<?php
// Usage without mysql_list_dbs()
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
$res = mysql_query("SHOW DATABASES");
while ($row = mysql_fetch_assoc($res)) {
echo $row['Database'] . "
";
}
// Deprecated as of PHP 5.4.0
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
$db_list = mysql_list_dbs($link);
while ($row = mysql_fetch_object($db_list)) {
echo $row->Database . "
";
}
?>
The above example will output something similar to:
database1
database2
database3
Note
For backward compatibility, the following deprecated alias may be used: mysql_listdbs(3)
mysql_db_name(3), mysql_select_db(3).
PHP Documentation Group MYSQL_LIST_DBS(3)