MYSQL_GET_CLIENT_INFO(3) 1 MYSQL_GET_CLIENT_INFO(3)mysql_get_client_info - Get MySQL client infoSYNOPSIS
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. 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:
omysqli_get_client_info(3)
o PDO::getAttribute
string mysql_get_client_info (void )
DESCRIPTION mysql_get_client_info(3) returns a string that represents the client library version.
The MySQL client version.
Example #1
mysql_get_client_info(3) example
<?php
printf("MySQL client info: %s
", mysql_get_client_info());
?>
The above example will output something similar to:
MySQL client info: 3.23.39
mysql_get_host_info(3), mysql_get_proto_info(3), mysql_get_server_info(3).
PHP Documentation Group MYSQL_GET_CLIENT_INFO(3)
Check Out this Related Man Page
MYSQL_CREATE_DB(3) 1 MYSQL_CREATE_DB(3)mysql_create_db - Create a MySQL databaseSYNOPSIS
Warning
This function was deprecated in PHP 4.3.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:
omysqli_query(3)
o PDO::query
bool mysql_create_db (string $database_name, [resource $link_identifier = NULL])
DESCRIPTION mysql_create_db(3) attempts to create a new database on the server associated with the specified link identifier.
o $database_name
- The name of the database being created.
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 TRUE on success or FALSE on failure.
Example #1
mysql_create_db(3) alternative example
The function mysql_create_db(3) is deprecated. It is preferable to use mysql_query(3) to issue an sql CREATE DATABASE statement
instead.
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
$sql = 'CREATE DATABASE my_db';
if (mysql_query($sql, $link)) {
echo "Database my_db created successfully
";
} else {
echo 'Error creating database: ' . mysql_error() . "
";
}
?>
The above example will output something similar to:
Database my_db created successfully
Note
For backward compatibility, the following deprecated alias may be used: mysql_createdb(3)
Note
This function will not be available if the MySQL extension was built against a MySQL 4.x client library.
mysql_query(3), mysql_select_db(3).
PHP Documentation Group MYSQL_CREATE_DB(3)
Okay, I'm new to this PHP and MySQL stuff, so help would be VERY much appreciated. :)
On my iMac runnning Panther, it has MySQL and PHP installed.
Yet when I view a PHP file from the iMac or another computer at my house, I get the source code.
What's wrong? (11 Replies)
When I'm running a few statements through mysql console, they are working just fine but when I'm trying to write some logic in php and trying to execute it, its awfully slow.. Its perhaps performing, 10 queries in 20 seconds... :( Why is this happening?
My table structures are:
Name:... (23 Replies)
Hi All,
I have a problem with my database having lots of 'stale' slow_queries. I think the problem may be because of the following code:
$numresults=mysql_query("select * from links where catagory=".$catagory." order by linknum");
$numrows=mysql_num_rows($numresults);
I believe this... (4 Replies)
A few weeks ago at the recommendation of people I trust, I bought and started reading Kernighan and Ritchie's (K&R) C Programming Language. For one thing, it's damn thin compared to the O'Reilly Practical C I just finished last month. It covers generally the same stuff but in a much more... (9 Replies)
Hello all. I am going to build an x86 Solaris box. Sun only offers it in a 64 bit flavor.
I want to put MySQL on this box. MySQL only comes in a 32 bit version for x86 Solaris.
Can I run 32 bit apps on a 64 bit x86 Solaris machine?
Thanks! (4 Replies)
Hello. the purpose of my efforts right now are to get a larger script of mine (which the admin told me he'd put into cron for me) to properly back-up my MySQL database. To test out the sql back-up part (before getting the whole script into cron, and having it not work) I wanted to test it. So... (12 Replies)
I'm trying to install something on my server that requires mysqlclient, but looking at my RPM package list I have it ("MySQL-client-5.0.91-0.glibc23"). Doing a locate on libmysqlclient gives me this:
For some reason it looks like I'm missing libmysqlclient.so.16. Does anyone know why this... (6 Replies)
Anyone know the normal and average monthly salary (and hourly wage for part time) for a solid Web Development in India?
Basic requirements. LAMP (Linux, Apache, MySQL, PHP), HTML, CSS, Javascript. vBulletin a plus, but not necessary.
Anyone have any idea? (5 Replies)
Hi Programming Geeks,
I got an interesting C++ and MySQL problem to solve.
I was unable to do this as I am not much confident on MySQL DB.
Please have a go at it if possible.
Write a C/C++ program that connects to a MySQLserver and checks if
the InnoDB plug-in is installed on it. If so,... (5 Replies)
So I have this PHP script that takes info from HTML form and saves the info to a txt file.
Here is the code
<?php
$input = $_POST;
$dateposted = date("m-d-Y-His");
$fp = fopen("/some/location/public_html/sh/$dateposted.txt", "w");
fwrite($fp, $input.).' ';
fclose($fp);... (16 Replies)
Fedora and openSUSE will replace MySQL with MariaDB:
Oracle who? Fedora & openSUSE will replace MySQL with MariaDB | ZDNet
The article also has a comment that Chakra is planning on doing the same. No doubt the Fedora based distributions are planning to do the same. (7 Replies)
Hi all,
Exactly like my title says.
I am learning PHP and MySQL and I used to use /var/www/ to host (contain or store) my files (.htm/.php) for testing. I could configure, finally, apache2 to use ~/public_html instead.
Now I when I tried to use $_SERVER it still directs (I used echo to show... (7 Replies)