Php mysql connect

<?php
$servername = "localhost";
$username = "username";
$password = "password";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>

$conn php

<?php
    $user = "username";
    $pass = "password";
    $host = "host";
    $dbdb = "database";
    
$conn = new mysqli($host, $user, $pass, $dbdb);
   if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 
?>

Connect sql server php

//Connect MSSQL
$serverName = '192.xxx.xxx.xx';
$userName = 'usertest';
$userPassword = 'pwdtest';
$dbName = 'dbtest';
 
try{
	$conn = new PDO("sqlsrv:server=$serverName ; Database = $dbName", $userName, $userPassword);
	$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(Exception $e){
	die(print_r($e->getMessage()));
}
 
//การ query และแสดงข้อมูล จัดเรียงตามฟิวด์ field1 แบบมากไปน้อย เริ่มที่เรคคอร์ดที่ 0-100
$query = " SELECT * FROM tbl 
ORDER BY field1 DESC
OFFSET 0 ROWS
FETCH NEXT 100 ROWS ONLY ";
$getRes = $conn->prepare($query);
$getRes->execute();
 
while($row = $getRes->fetch( PDO::FETCH_ASSOC ))
{
echo $row['field1']."<br />";
echo $row['field2']."<br />";
}

Source: seenual.com

How to connect to a mysql database using php

<?php
  $serverName = "localhost";
  $dBUsername = "root";
  $dBPassword = "";
  $dBName = "users";

  $conn = mysqli_connect($serverName, $dBUsername, $dBPassword, $dBName);

  if (!$conn) {
    die("Connection failed: " . mysqli_connection_error());
  }

-1

Php sql server connect

$serverName = "serverName\sqlexpress"; //serverName\instanceName
$connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

-1

Connect database using php

php db connect

-2

Similar codes

1 vote134 views1 answer
Split 10 email out of 50 email using coma separated via php
PHP
0 vote126 views2 answers
Auto complete order paid1
PHP
11 votes123 views3 answers
Change date format php
PHP
1 vote145 views1 answer
Remove all post in wordpress by query
PHP
2 votes154 views1 answer
Add Laravel .env variable to Vue component
PHP Laravel
0 vote142 views1 answer
Sage / sage one accounting php connect login
PHP
0 vote121 views1 answer
Laravel array search blade
PHP
1 vote133 views1 answer
How to take last entry in database in laravel Method ONe
PHP
0 vote146 views1 answer
Php move element to beginning of array
PHP
0 vote190 views1 answer
Laravel unique column except self
PHP