The Connection String is a property of the ADO.NET connection object MySqlConnection. It gets or sets the string used to connect to a MySQL server database.
A D V E R T I S E M E N T
The Connection String contains a series of parameters (keywords) separated by semicolons. The order of these parameters is not mandatory and they are not case sensitive. These parameters have specific names defined in the .NET provider such as, Server, Database, User Id (Uid), Password (Pwd), Connect Timeout, Persist Security Info, etc. The .NET provider for these parameters determines the default values and description too. If a parameter is not included in the Connection String its default value is assumed.
Before you can do anything with MySQL in PHP you must first establish a connection to your web host's MySQL database. This is done with the MySQL connect function
PHP & MySQL Code
-<?php
mysql_connect("localhost", "admin", "1admin") or die(mysql_error());
echo "Connected to MySQL-<br /->";
?>
MySQLConnectionString has been used as a constructor. The Open() method of the ADO.NET connection object establishes a new open connection from the connection pool if one is not available. Otherwise, it will use an already created one.
The mysql_connect function takes three arguments. Server, username, and password. In our example above these arguments were:
Share And Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.
Keywords:
MySQL Connection, Mysql Tutorial, Mysql tutorial pdf, history of mysql, basic mysql, syntax use in mysql, mysql software download, learn mysql, mysql insert, mysql delete, mysql data types, mysql administrator.
