<?php ini_set('mysql.connect_timeout', 300); ini_set('default_socket_timeout', 300); define('DB_SERVER', 'localhost:9080'); define('DB_USERNAME', 'root'); define('DB_PASSWORD', 'XXXX'); define('DB_DATABASE', 'api'); //$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD); $db = mysqli_connect("localhost:9080","root","XXXX"); // Check connection if (!$db) { die("Connection failed: " . mysqli_connect_error()); } $select_db = mysqli_select_db($db, DB_DATABASE); if(!$select_db) { die("Database selection failed: " . mysqli_error($db)); } echo "Connected successfully"; ?>
ini_set('mysql.connect_timeout', 300); ini_set('default_socket_timeout', 300);
RiggsFolly wrote:"and port is 3307" Then use define('DB_SERVER', 'localhost:3307'); Although the normal port is 3306 UNLESS you are actually using MariaDB when the default port is 3307
define('DB_SERVER', 'localhost:3307');
3306
3307
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)