How To Connect to MySQL from a PHP Script

Q

How To Connect to MySQL from a PHP Script? - PHP Script Tips - Working with MySQL Database

✍: 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

2007-04-18, 5145👍, 0💬

Using XML with Non-Latin Characters
Can XML use non-Latin charac'ters? Yes. The XML Specification explicitly says XML uses ISO 10646, the international standard character repertoire which covers most known languages. Unicode is an identical repertoire, and the two standards track each other. The spec says (2.2): All XML processors mus... 2007-04-11, 5376👍, 0💬

Using XML Files with SGML Tools
If XML is just a subset of SGML, can I use XML files directly with existing SGML tools? Yes, provided you use up-to-date SGML software which knows about the WebSGML Adaptations TC to ISO 8879 (the features needed to support XML, such as the variant form for EMPTY elements; some aspects of the SGML D... 2007-04-11, 5166👍, 0💬

How To Connect to MySQL from a PHP Script
How To Connect to MySQL from a PHP Script? - PHP Script Tips - Working with MySQL Database 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 c... 2007-04-18, 5146👍, 0💬

How To Install MySQL
How To Install MySQL? - PHP Script Tips - Working with MySQL Database 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... 2007-04-18, 5126👍, 0💬

What Do You Need to Connect PHP to MySQL
What Do You Need to Connect PHP to MySQL? - PHP Script Tips - Working with MySQL Database 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... 2007-04-18, 5100👍, 0💬

How To Select an Exiting Database
How To Select an Exiting Database? - PHP Script Tips - Working with MySQL Database 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 W... 2007-04-18, 5075👍, 0💬

How To Get the Number of Rows Selected or Affected by a SQL Statement
How To Get the Number of Rows Selected or Affected by a SQL Statement? - PHP Script Tips - Working with MySQL Database 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 obj... 2007-04-19, 5058👍, 0💬

How To Create a Table
How To Create a Table? - PHP Script Tips - Working with MySQL Database 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 VARCH... 2007-04-19, 5047👍, 0💬

How To Run a SQL Statement
How To Run a SQL Statement? - PHP Script Tips - Working with MySQL Database You can run any types of SQL statements through the mysql_query() function. It takes the SQL statement as a string and returns different types of data depending on the SQL statement type and execution status: Returning FALSE... 2007-04-18, 4994👍, 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.