using mamp/ local server

[geestring]

<?php //this file contains information to connect to database

DEFINE('DB_USER', 'root');
DEFINE('DB_PASSWORD', 'root');
DEFINE('DB_HOST', 'localhost');
DEFINE('DB_NAME', 'helpDesk');


$dbc = @mysqli_connect(DB_USER, DB_PASSWORD, DB_HOST, DB_NAME) OR die ('could not connect to the database: ' . mysqli_connect_error());

mysqli_query($dbc, 'SET NAMES utf8');



?>

I get this "could not connect to the database: php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known"

Is this wrong?

[icio]

Yes, this is wrong. The database is not the fourth parameter to the `mysqli_connect' function. Instead, you need to connect and then select the database:

$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASS);
mysqli_select_db($dbc, DB_NAME); 

Hope that helps