Connection to the database

Once we have created the database in our server, the following step is to connect to the database from a PHP page. To this end, PHP provides us with a series of statements to access MySQL databases.

<html>
<head>
   <title>PHP Example</title>
</head>
<body>
<?php
function Conectarse()
{
   if (!($link=mysql_connect("localhost","usuario","Password")))
   {
      echo "Error conectando a la base de datos.";
      exit();
   }
   if (!mysql_select_db("base_datos",$link))
   {
      echo "Error seleccionando la base de datos.";
      exit();
   }
   return $link;
}

$link=Conectarse();
echo "Conexión con la base de datos conseguida.<br>";

mysql_close($link); //cierra la conexion
?>
</body>
</html>

View code

Ejecutar ejemplo

By executing the statement mysql_connect, we are creating a link between the database and the PHP page, this link will be used later in the queries we make to the database.

Finally, once we have stopped using the link to the database, we release it with the statement mysql_close so the connection does not remain busy.

Create the database

Querying the database

Basic PHP

Basic concepts

Operators

Statements

Functions and libraries

- Functions
- Library

Advanced PHPo

Processing forms

Database access

Security

Sessions (PHP4)


	Web WebEstilo.com