PHP - Cannot Connect To Web Server Mysql Database

Hi,

I cant connect to my Mysql database.
I get this problem:
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'esolarch_databas'@'localhost' (using password: YES) in /home7/esolarch/public_html/new/storescripts/connect_to_mysql.php on line 21
could not connect to mysql

Code: [Select]
<?php  
/*  
1: "die()" will exit the script and show an error statement if something goes wrong with the "connect" or "select" functions. 
2: A "mysql_connect()" error usually means your username/password are wrong  
3: A "mysql_select_db()" error usually means the database does not exist. 
*/ 
// Place db host name. Sometimes "localhost" but  
// sometimes looks like this: >>      ???mysql??.someserver.net 
$db_host = "localhost"; 
// Place the username for the MySQL database here 
$db_username = "esolarch_database";  
// Place the password for the MySQL database here 
$db_pass = "Password";  
// Place the name for the MySQL database here 
$db_name = "esolarch_admin2"; 

// Run the actual connection here  
mysql_connect("$db_host","$db_username","$db_pass") or die ("could not connect to mysql");
mysql_select_db("$db_name") or die ("no database");              
?>

Hello,
I've been having trouble connecting to a MySQL database, I can't find the problem in the code, what am I doing wrong?

Getting the database file in the config file : require_once("db_connect.php");

db_connect.php :
<?php
$db = mysql_connect('83.172.155.14:3306', 'username', 'password') or die(mysql_error());
mysql_select_db('databasename', $db) or die(mysql_error());
?>

I need to connect to a PhpMyAdmin database.
I need this fixed asap since I'm doing this for someone and he wants the site done as quickly as possible.
P.S: The database used to work in php4 and now I need it to work on php5
Thanks in advance,

Hi there, I have this connect script I have made. I was wondering if it's secure or not, if not... What would be a good way to do so...
Code: [Select]
<?php
class connect{
public $host = "localhost";
public $dbuser = "";
public $dbpass = "";
public $db = "";
}
$connect = new connect();

mysql_connect($connect->host,$connect->dbuser,$connect->dbpass) or die("Could not connect!");
mysql_select_db($connect->db);
?>

hi all, i have a test server (newest xampp) and the code works fine, as soon as i upload to 1and1 (they use apachi, php and mysql) i get this message: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
i have double checked username and passwords, had a look on google, contacted there support with no luck yet.
i am wondering if its a mysql or php version problem, so hoping someone knows when the following code with classes etc was added or if someone knows how to fix it i be really greatful.
heres some of the code i am using

class cyberglide {

var $host;

var $username;

var $password;

var $db;

function connect() {

$con = mysql_connect($this->host, $this->username, $this->password) or die (mysql_error());

mysql_select_db($this->db, $con) or die(mysql_error());

}

function get_top() {

        if (isset($_GET['page']))
 {

 

$page = $_GET['page'];

// Display Page.
                $sql = "SELECT title,body FROM content WHERE page = '$page' AND location = 'left' AND disabled = 'no' ORDER BY id";
                $res = mysql_query($sql) or die (mysql_error());
                while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';

                    echo '<p>' . $row['body'] . '</p>';

}

}

        else
        {
                //Show Home Page
                $sql = "SELECT title,body FROM content WHERE page = 'home' AND location = 'left' AND disabled = 'no' ORDER BY id";
                $res = mysql_query($sql) or die (mysql_error());
                while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';
                    echo '<p>' . $row['body'] . '</p>';  
                }

  }

}

function get_left() {

        if (isset($_GET['page']))
 {

 

$page = $_GET['page'];

// Display Page.
                $sql = "SELECT title,body FROM content WHERE page = '$page' AND location = 'left' AND disabled = 'no' ORDER BY id";
                $res = mysql_query($sql) or die (mysql_error());
                while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';

                    echo '<p>' . $row['body'] . '</p>';

}

}

        else
        {
                //Show Home Page
                $sql = "SELECT title,body FROM content WHERE page = 'home' AND location = 'left' AND disabled = 'no' ORDER BY id";
                $res = mysql_query($sql) or die (mysql_error());
                while($row = mysql_fetch_assoc($res)){

echo '<h1>' . $row['title'] . '</h1>';
                    echo '<p>' . $row['body'] . '</p>';  
                }

}

}
}//Ends Our Class

db file

//Setup Our Connection Vars

$obj->host = 'localhost';

$obj->username = 'root';

$obj->password = '';

$obj->db = 'db361371865';
 
 

//Connect To Our Database

$obj->connect();

many thanks all.

Hello. I just inherited a game stats system but it's not working properly. I'm gonna post the entire script:

<?php
error_reporting(E_ERROR | E_WARNING | E_PARSE);
$servername = "127.0.0.1";
$username = "";
$password = "";
$dbname = "";
 
$addresses = Array();
$nicknames = Array();
$servers = Array();
$times = Array();
 
$find_ip = $_GET["ip"];
$find_name = $_GET["nick"];
 
if(isset($_GET["format"]))
{
	$format = $_GET["format"];
}
else
{
	$format = "include";
}
 
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error)
{
    ReturnError("NO_CONNECTION");
}
 
function ReturnError($error)
{
	global $format;
	if($format == "mod")
		die("!DATA!ERROR:" .$error. "!DATA!");
	else
		die("ERROR:" . $error);
 
}
 
function ReturnData($data)
{
	global $format;
	if($format == "mod")
		die("!DATA!SUCCESS:" .$data. "!DATA!");
	else
 
		die("SUCCESS:" .$data);
}
 
function GetServerIP()
{
	if (!empty($_SERVER['HTTP_CLIENT_IP']))
		return $_SERVER['HTTP_CLIENT_IP'];
	else if (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))
		return $_SERVER['HTTP_X_FORWARDED_FOR'];
	else
		return $_SERVER['REMOTE_ADDR'];
}
 
function GetTimestamp()
{
	$now = DateTime::createFromFormat('U.u', number_format(microtime(true), 6, '.', ''));
	$now->format("m-d-Y H:i:s.u");
	$local = $now->setTimeZone(new DateTimeZone('Europe/Prague'));
	return $local->getTimestamp();
}
 
function GetFormatedTime()
{
	$now = DateTime::createFromFormat('U.u', number_format(microtime(true), 6, '.', ''));
	$now->format("m-d-Y H:i:s.u");
	$local = $now->setTimeZone(new DateTimeZone('Europe/Prague'));
	return $local->format("Y-m-d H:i:s.u");
}
 
function AddAddress($addr)
{
	global $addresses;
	if(in_array($addr, $addresses, true))
	{
		return false;
	}
	else
	{
		array_push($addresses, $addr);
		return true;
	}
}
 
function AddTime($time)
{
	global $times;
	if(in_array($time, $times, true))
	{
		return false;
	}
	else
	{
		array_push($times, $time);
		return true;
	}
}
 
function AddNickname($nick)
{
	global $nicknames;
	if(in_array($nick, $nicknames, true))
	{
		return false;
	}
	else
	{
		array_push($nicknames, $nick, true);
		return true;
	}
}
 
function AddServer($server)
{
	global $servers;
	if(in_array($server, $servers, true))
	{
		return false;
	}
	else
	{
		array_push($servers, $server, true);
		return true;
	}
}
 
function LookForIPs($ip)
{
	global $conn;
 
	$sql = "SELECT * FROM  `connections` WHERE `IP` = '".$ip."'";
	$result = $conn->query($sql);
 
	if ($result->num_rows > 0)
	{
		while($row = $result->fetch_assoc())
		{
			AddAddress($row["IP"]);
			AddServer($row["serverIP"]);
			AddTime(Array($row["datestamp"], $row["datestring"], $row["serverIP"]));
 
			if(AddNickname($row["nickname"]) && $row["nickname"] != "Player" && $row["nickname"] != "A_Edition_V2")
			{
				LookForNicknames($row["nickname"]);
			}
 
		}
		return true;
	}
	else
	{
		return false;
	}
}
 
function LookForNicknames($nick)
{
	global $conn;
 
	$sql = "SELECT * FROM  `connections` WHERE `nickname` LIKE '".$nick."'";
	$result = $conn->query($sql);
 
	if ($result->num_rows > 0)
	{
		while($row = $result->fetch_assoc())
		{
			AddNickname($row["nickname"]);
			AddServer($row["serverIP"]);
			AddTime(Array($row["datestamp"], $row["datestring"], $row["serverIP"]));
 
			if(AddAddress($row["IP"]))
			{
				LookForIPs($row["IP"]);
			}
		}
		return true;
	}
	else
	{
		return false;
	}
}
 
function SortTimes()
{
	global $times;
	$good = false;
 
	while($good == false)
	{
		$good = true;
		for($i = 0; $i < count($times); $i++)
		{
			if($i+1 == count($times))
				continue;
 
			if($times[$i][0] < $times[$i + 1][0])
			{
				$tmp = $times[$i];
				$times[$i] = $times[$i + 1];
				$times[$i+1] = $tmp;
 
				$good = false;
			}
		}
	}
}
 
function GenerateLastSeenString($fromTime)
{
	$time_now = GetTimestamp();
 
	if($time_now < $fromTime)
	{
		return "N/A";
	}
	if($fromTime == 0 || $fromTime =="")
	{
		return "N/A";
	}
 
	$ss = $time_now - $fromTime;
 
	$seconds = $ss%60;
	$minutes = floor(($ss%3600)/60);
	$hours = floor(($ss%86400)/3600);
	$days = floor(($ss%2592000)/86400);
	$months = floor($ss/2592000);
 
	$str = "";
 
	if($months != 0)
	{
		if($str != "")
			$str = $str . " ";
		if($days == 1)
			$str = $str . $months . " month";
		else
			$str = $str . $months . " months";
	}
 
	if($days != 0)
	{
		if($str != "")
			$str = $str . " ";
		if($days == 1)
			$str = $str . $days . " day";
		else
			$str = $str . $days . " days";
	}
 
	if($hours != 0)
	{
		if($str != "")
			$str = $str . " ";
		if($hours == 1)
			$str = $str . $hours . " hour";
		else
			$str = $str . $hours . " hours";
	}
 
	if($minutes != 0)
	{
		if($str != "")
			$str = $str . " ";
		if($minutes == 1)
			$str = $str . $minutes . " minute";
		else
			$str = $str . $minutes . " minutes";
	}
 
	if($seconds != 0)
	{
		if($str != "")
			$str = $str . " ";
		if($seconds == 1)
			$str = $str . $seconds . " second";
		else
			$str = $str . $seconds . " seconds";
	}
 
	return $str. " ago";
}
 
function ClearResult($arr)
{
	for($i = 0; $i < count($arr); $i++)
	{
		if(gettype($arr[$i]) == "boolean")
		{
			 //echo "Found bool at $i";
			 array_splice($arr, $i, 1);
		}
	}
 
	return $arr;
}
 
function PrintArray($arr)
{
	for($i = 0; $i < count($arr); $i++)
	{
		echo $arr[$i];
		if($i + 1 != count($arr))
		{
			echo ", ";
		}
	}
}
 
if($format == "mod")
{
	LookForNicknames($find_name);
	LookForIPs($find_ip);
 
	$nicknames = ClearResult($nicknames);
	$addresses = ClearResult($addresses);
	$servers   = ClearResult($servers);
	$conn->close();
 
	/*if (!filter_var($find_ip, FILTER_VALIDATE_EMAIL) && $find_ip != "")
	{
	    $find_ip = $addresses[0];
	}*/
 
	if($find_ip == "")
	{
		$find_ip = $addresses[0];
	}
 
	if($find_ip == "")
	{
		$find_ip = "0.0.0.0";
	}
 
 
	if(count($nicknames) == 0 && count($addresses) == 0)
	{
		ReturnError("NOT_FOUND");
	}
 
	echo "!DATA!";
	echo "Nicknames used: "; PrintArray($nicknames); echo "*-*";
	echo "Total IPs used: "; echo count($addresses); echo "*-*";
	echo "Location: "; echo file_get_contents("http://127.0.0.1/db/getlocation.php?ip=$find_ip"); echo "*-*";
	echo "Connected: ";  echo count($times); echo " times*-*";
	SortTimes();
 
	if(GetTimestamp() - $times[0][0] < 60 * 60)
		echo "Last seen: " . GenerateLastSeenString($times[1][0]) . "*-*";
	else
		echo "Last seen: " . GenerateLastSeenString($times[0][0]) . "*-*";
 
	echo "First seen: " . GenerateLastSeenString($times[count($times)-1][0]);
	echo "!DATA!";
}
else if($format == "debug")
{
	LookForNicknames($find_name);
	LookForIPs($find_ip);
 
	$nicknames = ClearResult($nicknames);
	$addresses = ClearResult($addresses);
	$servers   = ClearResult($servers);
	$conn->close();
 
	/*if (!filter_var($find_ip, FILTER_VALIDATE_EMAIL) && $find_ip != "")
	{
	    $find_ip = $addresses[0];
	}*/
 
	if($find_ip == "")
	{
		$find_ip = $addresses[0];
	}
 
	if($find_ip == "")
	{
		$find_ip = "0.0.0.0";
	}
 
	if(count($nicknames) == 0 && count($addresses) == 0)
	{
		ReturnError("NOT_FOUND");
	}
 
	echo "Nicknames used: "; PrintArray($nicknames); echo "<br>";
	echo "IPs used: "; PrintArray($addresses); echo "<br>";
	echo "Location: "; echo file_get_contents("http://127.0.0.1/db/getlocation.php?ip=$find_ip"); echo "<br>";
	echo "Connected: ";  echo count($times); echo " times<br>";
	SortTimes();
	echo "Last seen: " . GenerateLastSeenString($times[0][0]) . "<br>";
	echo "First seen: " . GenerateLastSeenString($times[count($times)-1][0]) . "<br>";
	echo $find_name;
}
?>

The problem is that for some nicknames it returns a proper output which should look like this:

But sometimes it just returns lots and lots of data even if the nickname I ask for is unique enough:

Here's how the database looks:

I don't know what's wrong with the script because I'm a PHP beginner. If someone could take a look at it and tell me what's the issue I'd appreciate.

Edited September 22, 2020 by jevgienij

hi all

First of all

My client have dot net server on windows OS. They want to display some pages which are created by php. Is there any possibility to display like this.

And

How can i connect sql server using php on remote to retrieve data.

Can any one tell me how can i do this.

Thanks in advance

I am using this:

$tags = @get_meta_tags($http["domain"]);

Is there any way to tell if that function can not connect to the server for reasons such as server being down, or an invalid URL?

Hi guys   I'll try keep this simple   I have been given access to a betting xml feed which requires my IP to be whitelisted.   I have whitelisted my home IP and it works fine.   I have whitelisted an IP on server 1 (linux, cpanel), this works fine   I have whitelisted an IP on server 2 (linux, cpanel), this doesn't work and I get:     "simplexml_load_file failed to open stream: http request failed!"   The IP is definitely whitelisted but I think it is something to do with the server. What could be blocking this? allow_url_fopen and allow_url_include are both on by the way   Many thanks Sam

Hi friends...
I am using Wamp with PHP 5.3 and want to connect with SQL Server 2005 but not successful. I also tried it with PHP 5.2.8 but it still not working.
I google it and found some solutions but not successsful yet.
Can anyone give me detailed guide (step by step) that how i can connect PHP with Sql Server 2005???
Thanks in advance...

I've been working on this for 8 hours and still cannot get sqlsrv_connect to work. Thank you, Microsoft. My connection strings work for Access DBs and MySQL - but I can't get this to work.

For servername, I've tried:
$serverName = "MYSERVER";
$serverName = "(MYSERVER\MYINSTANCE)";
$serverName = "'MYSERVER\MYINSTANCE'";
$serverName = "(MYSERVER)";

Setup:
PHP Compiler = MSVC9 (Visual C++ 2008)
C:\Program Files (x86)\PHP\v5.3\php.ini
extension_dir C:\Program Files (x86)\PHP\v5.3\ext\
php_sqlsrv_53_nts_vc9.dll in the extension library.

And I'm getting an error from sqlsrv_errors, so it looks like the DLL is working. Pulling my hair out here.

Any ideas?

Code: [Select]
$serverName = "MYSERVER\MYINSTANCE";
$connectionInfo = array("UID" => $uid, "PWD" => $pwd, "Database"=>"$dbname");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

if($conn) {
echo "Connection established.\n";
} else {
echo "Connection could not be established.\n";
die( print_r( sqlsrv_errors(), true));
}

sqlsrv_close( $conn);


Connection could not be established. Array ( => Array ( => 08001  => 08001 [1] => 53  => 53 [2] => [SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [53].  => [SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [53]. ) [1] => Array ( => HYT00  => HYT00 [1] => 0  => 0 [2] => [SQL Server Native Client 10.0]Login timeout expired  => [SQL Server Native Client 10.0]Login timeout expired ) [2] => Array ( => 08001  => 08001 [1] => 53  => 53 [2] => [SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.  => [SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. ) )

Is there a way for me to connect to a directory on a NAS server running a windows share from PHP.
I can connect from the command line using mount, but I want the connect within my PHP script.
Can this be done & if so how?

My code is: <?php
echo system("openssl s_client -crlf -connect pop3.live.com:995");
?>


This connects fine. However, I don't know how to log in now. If I'm connecting from the terminal I then type "user annie" followed by "pass idontlikesand". I don't know how to pipe this in using php.

Any ideas?

hello sir,

            i  have to connect database to my live server using 

<?php

define('DB_HOST', 'localhost');
define('DB_NAME', 'oop_pdo_crud');
define('DB_USER', 'root');
define('DB_PASS', '');

?>

or 

 

Have actually tried this mailer on localhost and it worked perfectly. Now am trying to use it on online but it's giving this error SMTP-> ERROR: Failed to connect to server: Connection timed out (110) SMTP -> ERROR: Could not connect to SMTP host. Mailer Error: SMTP Error: Could not connect to SMTP Host.   please how do i fix this?     include "classes/class.phpmailer.php"; // include the class name
$mail = new PHPMailer(); // create a new object
$mail->IsSMTP(); // enable SMTP
$mail->SMTPDebug = 1; // debugging: 1 = errors and messages, 2 = messages only
$mail->SMTPAuth = true; // authentication enabled
$mail->SMTPSecure = 'ssl'; // secure transfer enabled REQUIRED for GMail
$mail->Host = "smtp.gmail.com";
$mail->Port = 465; // or 587
$mail->IsHTML(true);
$mail->Username = "hypropsict@gmail.com";
$mail->Password = "hyprops123";
$mail->SetFrom("hypropsict@gmail.com");
$mail->Subject = "Requisition Processed";
$mail->Body = "<b>Hello $firstname, your requisition has been processed and Approved.. <br/><br/>Come to the Account department to recieve your $text . <br/> Thank You </b>";

$mail->AddAddress($email);
 if(!$mail->Send()){
    echo "Mailer Error: " . $mail->ErrorInfo;
}

The information on the php.net documentation seems to be out of date.   http://php.net/manua...databases.mssql   as the link to the necessary libraries for Linux is broken.    Can you tell me, or point me to what is needed to connect to MSSQL with PHP 5.3.3/Apache  on Red Hat Linux   If there is more than one option, we would like to know what they are and the installation details.   Thanks