Trying to insert data into a MSSQL server using php but getting error

Question

So i just bought a Microsoft azure SQL server, and im trying to connect to it using php on my website however it keeps throwing an error saying "Warning: mysqli::__construct(): php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\xampp\htdocs\Website\data.php on line 50

Warning: mysqli::__construct(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\xampp\htdocs\Website\data.php on line 50 Connection failed: php_network_getaddresses: getaddrinfo failed: No such host is known." Can someone give me precise instructions on how to fix this issue.

CODE:

<!DOCTYPE html>
<html>
<body>

<?php

$firstname = $_POST["inputFirstName"];

$lastname = $_POST["inputLastName"];

$email = $_POST["emailaddress"];
//$email = "";

$discordid = $_POST["discordid"];

$stuff = array($firstname, $lastname, $email, $discordid);
//echo implode(" ",$stuff);

require_once('vendor/autoload.php');
$stripe = new \Stripe\StripeClient(
  'APIKEYHERE'
);
if(!empty($stripe->customers->all(['email' => $email, 'limit' => 1])->data[0])){
$yo = $stripe->customers->all(['email' => $email, 'limit' => 1])->data[0]->id;
echo("You are already in our system your customer ID is: " . $yo);
}
else{
  echo("All good");
  
  $stripe->customers->create([
      'name' => $firstname . " " . $lastname,
      'email' => $email, 
    'description' => $discordid,
  ]);
  //add free subscription
  $stripe->subscriptions->create([
    'customer' => $stripe->customers->all(['email' => $email, 'limit' => 1])->data[0]->id,
    'items' => [
      ['price' => ''],
    ],
  ]);

  // Create connection
  $servername = "";
  $username = "";
  $password = "";
  $dbname = "";
  
  // Create connection
  $conn = new mysqli($servername, $username, $password, $dbname);
  // Check connection
  if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
  }
  
  $sql = "INSERT INTO tblCustomer (DiscordID, CustID, DiscordName)
  VALUES ('111', '55', 'John Smith')";
  
  if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
  } else {
    echo "Error: " . $sql . "<br>" . $conn->error;
  }
  
  $conn->close();

  //create and redirect user to billing session
  header("Location: ".$stripe->billingPortal->sessions->create([
    'customer' => $stripe->customers->all(['email' => $email, 'limit' => 1])->data[0]->id,
    'return_url' => 'https://www.google.com/',
  ])->url);
  }
?>
</body>
</html>

For the time being im just trying to do a get request, just to make sure i can get this going. — RAT
– RAT, Commented Jul 29, 2020 at 20:48
after your insert.. you have three = signs... shouldn't that be only 2 like == — Harry
– Harry, Commented Jul 30, 2020 at 3:16
@harry idk i copied that template from the internet. Ill give it a shot tho. — RAT
– RAT, Commented Jul 30, 2020 at 3:35
nope still doesnt work. ERROR: Warning: mysqli::__construct(): php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\xampp\htdocs\Website\data.php on line 50 Warning: mysqli::__construct(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\xampp\htdocs\Website\data.php on line 50 Connection failed: php_network_getaddresses: getaddrinfo failed: No such host is known. — RAT
– RAT, Commented Jul 30, 2020 at 3:37
I'm guessing.. where it says //creta connection . you have actually entered all your connections setting and not blank? Just asking the obvious! — Harry
– Harry, Commented Jul 30, 2020 at 3:39

Yashit Sahni · Accepted Answer · 2020-07-30 04:25:52Z

1

Warning "No such host is known" occur because "Host" is not set properly.

Recheck the 'servername'

To know about How to find server name of SQL Server Management Studio

This worked for me :

 $servername = "localhost";
 $username = "root";
 $password = "";
 $dbname = "test";

answered Jul 30, 2020 at 4:25

Yashit Sahni

1361 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Trying to insert data into a MSSQL server using php but getting error

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related