Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysql_get_client_info(3) [php man page]

MYSQL_GET_CLIENT_INFO(3)						 1						  MYSQL_GET_CLIENT_INFO(3)

mysql_get_client_info - Get MySQL client info

SYNOPSIS
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 database

SYNOPSIS
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)
Man Page

12 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem with PHP and MySQL

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)
Discussion started by: Danny_10
11 Replies

2. Shell Programming and Scripting

Something went awfully wrong in PHP+MySQL :(

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)
Discussion started by: Legend986
23 Replies

3. Shell Programming and Scripting

PHP/MySQL slow_queries

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)
Discussion started by: pondlife
4 Replies

4. Programming

C Beginner Looking For Suggestions

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)
Discussion started by: deckard
9 Replies

5. Solaris

32 bit MySQL on x86 64 bit?

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)
Discussion started by: RobertSubnet
4 Replies

6. Web Development

Confused maybe about MySQL Dump & PHP

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)
Discussion started by: jzacsh
12 Replies

7. UNIX for Dummies Questions & Answers

Failed depencies: libmysqlclient.so.16 is needed

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)
Discussion started by: fisher39
6 Replies

8. What is on Your Mind?

Monthly Salary in India for Web Programmer?

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)
Discussion started by: Neo
5 Replies

9. Homework & Coursework Questions

C/C++ program that connects to a MySQLserver

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)
Discussion started by: vivek.goel.piet
5 Replies

10. Web Development

CRLF to LF PHP

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.).'&nbsp;'; fclose($fp);... (16 Replies)
Discussion started by: GroveTuckey
16 Replies

11. News, Links, Events and Announcements

MySQL dropped in favor of MariaDB

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)
Discussion started by: figaro
7 Replies

12. Web Development

$_SERVER['DOCUMENT_ROOT'] directs to /var/www not ~/public_html

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)
Discussion started by: faizlo
7 Replies