Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysql_get_proto_info(3) [php man page]

MYSQL_GET_PROTO_INFO(3) 						 1						   MYSQL_GET_PROTO_INFO(3)

mysql_get_proto_info - Get MySQL protocol 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_proto_info(3) int mysql_get_proto_info ([resource $link_identifier = NULL]) DESCRIPTION
Retrieves the MySQL protocol. 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 the MySQL protocol on success or FALSE on failure. Example #1 mysql_get_proto_info(3) example <?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Could not connect: ' . mysql_error()); } printf("MySQL protocol version: %s ", mysql_get_proto_info()); ?> The above example will output something similar to: MySQL protocol version: 10 mysql_get_client_info(3), mysql_get_host_info(3), mysql_get_server_info(3). PHP Documentation Group MYSQL_GET_PROTO_INFO(3)

Check Out this Related Man Page

MYSQL_SELECT_DB(3)							 1							MYSQL_SELECT_DB(3)

mysql_select_db - Select a MySQL database

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_select_db(3) o PDO::__construct (part of dsn) bool mysql_select_db (string $database_name, [resource $link_identifier = NULL]) DESCRIPTION
Sets the current active database on the server that's associated with the specified link identifier. Every subsequent call to mysql_query(3) will be made on the active database. o $database_name - The name of the database that is to be selected. 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_select_db(3) example <?php $link = mysql_connect('localhost', 'mysql_user', 'mysql_password'); if (!$link) { die('Not connected : ' . mysql_error()); } // make foo the current db $db_selected = mysql_select_db('foo', $link); if (!$db_selected) { die ('Can't use foo : ' . mysql_error()); } ?> Note For backward compatibility, the following deprecated alias may be used: mysql_selectdb(3) mysql_connect(3), mysql_pconnect(3), mysql_query(3). PHP Documentation Group MYSQL_SELECT_DB(3)

12 More Discussions You Might Find Interesting

1. Cybersecurity

Open Port 3306 for MySQL connection

I am needing to "un-block" port 3306 so that I can access MySQL from another PC. When I installed Mandrake 8.1, I set the security level to high because it is going to be a web server. I believe I have to allow access to my ports now and I do not know the commands to do that. If anyone... (4 Replies)
Discussion started by: gdboling
4 Replies

2. Programming

Howto convert Ascii -> UTF-8 & back C++

While working with russian text under FreeBSD&MySQL I need to convert a string from MySQL to the Unicode format. I've just started my way in C++ under FreeBSD , so please explain me how can I get ascii code of Char variable and also how can i get a character into variable with the specified ascii... (3 Replies)
Discussion started by: macron
3 Replies

3. 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

4. Linux

MySQL server connetction problem

Hello,thanks for your help. I can't connect my MYSQLserver , the note from my Linux System is 'Error 1130 (00000): Host 'my ip address' is not allowed to connect to this MySQL server. What could I do on this? Thanks again! (4 Replies)
Discussion started by: lancepanda
4 Replies

5. Shell Programming and Scripting

Problem with looping construct

Hi all I have tried to search for this, but keep getting a MySQL db connect error, so am posing the question here, and taking a risk of incurring the wrath of the mods with my first post... I have the following test script: #!/bin/bash HTTPD=`/bin/ps -axcu | /usr/bin/grep httpd... (6 Replies)
Discussion started by: mikie
6 Replies

6. 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

7. UNIX and Linux Applications

What Database engine would you recommend?

Thank you for choosing this thread to read. I am about to develop a heavy set financial system. My client wants to build his own in-house. Due to my LAMP/BSD mind set, I know MySQL, but no other database (never got the chance to see others). I do not know if MySQL can handle 2000 to 5000 records... (3 Replies)
Discussion started by: sad_angle
3 Replies

8. Linux

MySQL DATABASE AND LINUX SYSTEMS ADMINISTRATOR

(3 Replies)
Discussion started by: danny.aiello22
3 Replies

9. 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

10. Programming

MySQL - PHP

Hello every one i have question i want to build DATAbase using PHP as interface i use shell to access to linux . i have in linux psql and SQLplus i'll call all html files that has db tabels from shell directory. what should to do before design php pages. can build the database sql design... (3 Replies)
Discussion started by: Scotch
3 Replies

11. 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

12. 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

Featured Tech Videos