You're giving this error:
Warning: mysqli_select_db () expects exactly 2 parameters, 1 given in
My code is this:
define("HOST", "localhost");
define("USER", "meu-usuario");
define("PASS", "minha-senha");
define("BDNAME", "meu_banco_de_dados");
mysqli_connect(HOST, USER, PASS);
mysqli_select_db(BDNAME)
According to the mysqli_select_db documentation, you need to pass two parameters to this function , the first being the connection link and the second the database .
Edit
Connection link is a resource returned by mysqli_connect () or mysqli_init ()
Example:
$con = mysqli_connect(HOST, USER, PASS);
mysqli_select_db($con, BDNAME);
It should have two parameters to connect like this:
<?php
$con=mysqli_connect("localhost","my_user","my_password","my_db");
// Checa a database
if (mysqli_connect_errno())
{
echo "Deu errado mano: " . mysqli_connect_error();
}
$teste = "Select * from table";
// Change database to "teste "
mysqli_select_db($con,"teste ");
// ...some PHP code for database "test"...
mysqli_close($con);
?>
or via Object like this:
<?php
// Aqui você se conecta ao banco
$mysqli = new mysqli('localhost', 'root', '', 'mydb');
// Executa uma consulta que pega cinco notícias
$sql = "SELECT 'id', 'titulo' FROM 'noticias' LIMIT 5";
$query = $mysqli->query($sql);
while ($dados = $query->mysqli_fetch_array()) {
echo 'ID: ' . $dados['id'] . '';
echo 'Título: ' . $dados['titulo'] . '';
}
echo 'Registros encontrados: ' . $query->num_rows;
Good for academic information, this method has been discontinued in older versions of php.