Connect database using php

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

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

6 votes283 views1 answer
Laravel bootstrap ui
PHP
0 vote311 views2 answers
Close connection pdo
PHP
6 votes348 views1 answer
Laravel bootstrap ui
PHP Laravel
0 vote346 views1 answer
'mix' is not recognized as an internal or external command,laravel 8 npm run dev
PHP Laravel
0 vote282 views2 answers
Php curl ssl certificate problem
PHP
0 vote284 views1 answer
How to check the size of mysql database in phpmyadmin
PHP
27 votes334 views3 answers
Laravel what is migrations
PHP Laravel
16 votes290 views6 answers
Php write file
PHP
0 vote335 views1 answer
Laravel database engine innodb
PHP Laravel
2 votes361 views2 answers
Laravel migration column type json
PHP Laravel