Connecting to a MySQL Server in PHP

Q

How To Connect to MySQL from a PHP Script in PHP?

✍: FYIcenter.com

A

If you want access the MySQL server, you must create a connection object first by calling the mysql_connect() function in the following format:

$con = mysql_connect($server, $username, $password);

If you are connecting to a local MySQL server, you don't need to specify username and password. If you are connecting to a MySQL server offered by your Web hosting company, they will provide you the server name, username, and password.

The following script shows you how to connect to a local MySQL server, obtained server information, and closed the connection:

<?php
  $con = mysql_connect('localhost');
  print(mysql_get_server_info($con)."\n");
  print(mysql_get_host_info($con)."\n");
  mysql_close($con); 
?>

If you run this script, you will get something like this:

5.0.2-alpha
localhost via TCP/IP

⇒ Creating a Database in PHP

⇐ Information Needed for MySQL Connection in PHP

⇑ Working with MySQL Database in PHP

⇑⇑ PHP Tutorials

2016-10-20, 2190👍, 0💬

Working with MySQL Database in PHP
Where to find tutorials on how to work with MySQL Database in PHP? A collection of tutorials to answer many frequently asked questions on how to Work with MySQL Database in PHP. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping t... 2016-10-22, 2242👍, 0💬

Connecting to a MySQL Server in PHP
How To Connect to MySQL from a PHP Script in PHP? If you want access the MySQL server, you must create a connection object first by calling the mysql_connect() function in the following format: $con = mysql_connect($server, $username, $password); If you are connecting to a local MySQL server, you do... 2016-10-20, 2191👍, 0💬

Selecting an Existing Database in PHP
How To Select an Exiting Database in PHP? The first thing after you have created a connection object to the MySQL server is to select the database where your tables are locate, by using the mysql_select_db() function. If your MySQL server is offered by your Web hosting company, they will assign a da... 2016-10-20, 2039👍, 0💬

Number of Rows Affected by a SQL Statement in PHP
How To Get the Number of Rows Selected or Affected by a SQL Statement in PHP? There are two functions you can use the get the number of rows selected or affected by a SQL statement: mysql_num_rows($rs) - Returns the number of rows selected in a result set object returned from SELECT statement. mysql... 2016-10-20, 1599👍, 0💬

Using MySQL Command Line Interface in PHP
How To Use MySQL Command Line Interface in PHP? MySQL server comes with a command line interface, which will allow you to operate with the server with SQL statements and other commands. To start the command line interface, you can run the \mysql\bin\mysql program. The tutorial exercise below shows y... 2016-10-22, 1527👍, 0💬

Installing MySQL Server in PHP
How To Install MySQL Server in PHP? MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local computer. Here is how you can do this: Go to http://dev.mysql.com/downloads /mysql/5.0.html.Select the "Windows" an... 2016-10-22, 1453👍, 0💬

Creating a Table in PHP
How To Create a Table in PHP? If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script: <?php include "mysql_connection.php"; $sql = "CREATE TABLE fyi_links (" . " id INTEGER NOT NULL" . ", url VARCHAR(80) NOT NULL" . ", notes VARCHAR(1024)... 2016-10-20, 1398👍, 0💬

Creating a Database in PHP
How To Create a Database in PHP? A database in a MySQL server is a logical container used to group tables and other data objects together as a unit. If you are the administrator of the server, you can create and delete databases using the CREATE/DROP DATABASE statements. The following PHP script sho... 2016-10-20, 1377👍, 0💬

Information Needed for MySQL Connection in PHP
What Do You Need to Connect PHP to MySQL in PHP? If you want to access MySQL database server in your PHP script, you need to make sure that MySQL module is installed and turned on in your PHP engine. Check the PHP configuration file, php.ini, to make sure the extension=php_mysql.dll is not commented... 2016-10-20, 1371👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.