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

4 votes164 views2 answers
Laravel migration update table column type
PHP
2 votes188 views3 answers
Php knoww if array has duplicate values
PHP
0 vote212 views1 answer
Laravel string capitalize in view
PHP Laravel
2 votes155 views1 answer
Php capital string
PHP
25 votes180 views4 answers
ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel
PHP
0 vote156 views2 answers
"message": "Call to a member function canNot() on null", "exception": "Symfony\\Component\\Debug\\Exception\\FatalThrowableError",
PHP
0 vote178 views1 answer
Stripe php sdk constants
PHP
0 vote148 views1 answer
Laravel keep old input
PHP
0 vote185 views1 answer
Laravel download file change name
PHP Laravel
0 vote158 views1 answer
Get post index wordpress
PHP Wordpress