PHP
- Getting started with PHP
- Awesome Book
- Awesome Community
- Awesome Course
- Awesome Tutorial
- Awesome YouTube
- Alternative Syntax for Control Structures
- APCu
- Array iteration
- Arrays
- Asynchronous programming
- Autoloading Primer
- BC Math (Binary Calculator)
- Cache
- Classes and Objects
- Closure
- Coding Conventions
- Command Line Interface (CLI)
- Comments
- Common Errors
- Compilation of Errors and Warnings
- Compile PHP Extensions
- Composer Dependency Manager
- Constants
- Contributing to the PHP Core
- Contributing to the PHP Manual
- Control Structures
- Cookies
- Create PDF files in PHP
- Cryptography
- Datetime Class
- Debugging
- Dependency Injection
- Design Patterns
- Docker deployment
- Exception Handling and Error Reporting
- Executing Upon an Array
- File handling
- Filters & Filter Functions
- Functional Programming
- Functions
- Generators
- Headers Manipulation
- How to break down an URL
- How to Detect Client IP Address
- HTTP Authentication
- Image Processing with GD
- Imagick
- IMAP
- Installing a PHP environment on Windows
- Installing on Linux/Unix Environments
- JSON
- Localization
- Loops
- Machine learning
- Magic Constants
- Magic Methods
- Manipulating an Array
- mongo-php
- Multi Threading Extension
- Multiprocessing
- Namespaces
- Object Serialization
- Operators
- Output Buffering
- Outputting the Value of a Variable
- Parsing HTML
- Password Hashing Functions
- PDO
- Performance
- PHP Built in server
- PHP MySQLi
- php mysqli affected rows returns 0 when it should return a positive integer
- PHPDoc
- Processing Multiple Arrays Together
- PSR
- Reading Request Data
- Recipes
- References
- Reflection
- Regular Expressions (regexp/PCRE)
- Secure Remeber Me
- Security
- Sending Email
- Serialization
- Sessions
- SimpleXML
- SOAP Client
- SOAP Server
- Sockets
- SPL data structures
- SQLite3
- Streams
- String formatting
- String Parsing
- Superglobal Variables PHP
- Traits
- Type hinting
- Type juggling and Non-Strict Comparison Issues
- Types
- Unicode Support in PHP
- Unit Testing
- URLs
- Using cURL in PHP
- Using MongoDB
- Using Redis with PHP
- Using SQLSRV
- Creating a Connection
- Fetching Query Results
- Invoking a Stored Procedure
- Making a Parameterised Query
- Making a Simple Query
- Retrieving Error Messages
- UTF-8
- Variable Scope
- Variables
- WebSockets
- Working with Dates and Time
- XML
- YAML in PHP
PHP Using SQLSRV Making a Simple Query
Example
//Create Connection
$conn = sqlsrv_connect($dbServer, $connectionInfo);
$query = "SELECT * FROM [table]";
$stmt = sqlsrv_query($conn, $query);
Note: the use of square brackets [] is to escape the word table as it is a reserved word. These work in the same way as backticks ` do in MySQL.
