connect sql server php

ByAnurag batra July 18, 2022October 23, 2022

"dbName");
$conn = sqlsrv_connect( $serverName, $connectionInfo);

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

Here is what the above code is Doing:
1. The sqlsrv_connect() function is used to establish a connection to a Microsoft SQL Server database.
2. The sqlsrv_errors() function returns an array of errors and warnings from the last sqlsrv operation performed.
3. The die() function prints a message and exits the current script.
4. The print_r() function prints human-readable information about a variable.
5. The true parameter of the print_r() function returns the information rather than print it.
6. The $serverName variable specifies the name of the server to which to connect.
7. The $connectionInfo variable specifies the connection options.
8. The $conn variable stores the connection information returned by sqlsrv_connect().
9. The if…else statement is used to check whether the connection was successful.
10. The echo statement is used to display the connection status.

PHP Examples

fgets in php

ByAnurag batra October 7, 2022September 6, 2022

$fptr = fopen(‘myfile.txt’,’r’); if(!$fptr) { die(“Could not open file”); } while($line = fgets($fptr)) { echo $line; //fgets read line by line, if we don’t put code in while loop then it will print only one line of code } echo “End of the file reached!”; //it only reads one line at a time Here is…

PHP Examples

php add get to link

ByAnurag batra October 9, 2022September 6, 2022

$url .= $url.(parse_url($url, PHP_URL_QUERY) ? ‘&’ : ‘?’).’category=action’; Here is what the above code is Doing: 1. It’s creating a variable called $url and assigning it the value of the current URL. 2. It’s then checking to see if the URL already has a query string. If it does, it adds an ampersand (&) to…

PHP Examples

get curret timedate php

ByAnurag batra June 30, 2022September 1, 2022

// Change the line below to your timezone! date_default_timezone_set(‘Australia/Melbourne’); $date = date(‘m/d/Y h:i:s a’, time()); Here is what the above code is Doing: 1. We’re setting the timezone to Melbourne, Australia. 2. We’re creating a variable called $date and setting it to the current date and time.

PHP Examples

php loop through obect

ByAnurag batra July 18, 2022June 30, 2022

PHP By Wandering Weevil on Mar 8 2020 $person = new StdClass(); $person->name = “Ngbokoli”; $person->age = 31; $person->nationnality = “Congolese”; $person->profession = “Student”; foreach ($person as $key => $value) { echo $key.” “.$value.”\n”; } Here is what the above code is Doing: 1. We create a new object of the class StdClass. 2. We…

$auth.php Class “\App\User” not found$

PHP Examples

auth.php Class “\App\User” not found

ByAnurag batra October 5, 2022September 6, 2022

Go to config/auth.php and change App\User:class to App\Models\User::class. ‘providers’ => [ ‘users’ => [ ‘driver’ => ‘eloquent’, ‘model’ => App\Models\User::class, ], Also change the namespace of User.php model namespace App\Models; Here is what the above code is Doing: 1. We are creating a new directory called Models inside the app directory. 2. We are moving…

PHP Examples

php set no memory limit

ByAnurag batra July 17, 2022June 30, 2022

//Unlimited momory limit ini_set(‘memory_limit’, ‘-1’); //Fixed memory limit ini_set(‘memory_limit’,’2048M’); Here is what the above code is Doing: 1. The first line is setting the memory limit to unlimited. 2. The second line is setting the memory limit to 2GB.

Similar Posts