Backend Development
PHP Tutorial
IIS 7.5 configure php 5.4.22 link sql 2008 (use PDO to link to the database)_PHP tutorial
IIS 7.5 configure php 5.4.22 link sql 2008 (use PDO to link to the database)_PHP tutorial
I have recently come into contact with PHP. Regarding the PHP configuration under the wndows system, although there are many articles on the Internet, sometimes it is troublesome to find some configurations, so I would like to share them with you.
1.php 5.4.22
Download address http://windows.php.net/download/#php-5.4-nts-VC9-x86
Select version: PHP 5.4 (5.4.22), VC9 x86 Thread Safe (php-5.4.22-Win32-VC9-x86.zip)
After unzipping, change the name of php.ini-development file to php.ini
2. Configure php.ini
short_open_tag = On supports writing
date.timezone = PRC or add date_default_timezone_set("PRC") at the top of PRC program; set the default time zone to Beijing time
extension_dir = "ext" specifies the php extension module as the ext directory
error_reporting = E_ALL & ~E_DEPRECATED & ~E_STRICT & ~E_NOTICE does not prompt for some information data (such as: warning
3. Support sql 2008 database link, go to Microsoft to download sqlsrv 3
Download link http://www.microsoft.com/en-us/download/details.aspx?id=20098
The download is exe, you can unzip it directly and put php_pdo_sqlsrv_54_ts.dll and php_sqlsrv_54_ts.dll into the ext directory
extension=php_pdo_sqlsrv_54_ts.dll
extension=php_sqlsrv_54_ts.dll
Note: ts is thread-safe, nts is non-thread-safe, and must be consistent with the downloaded php version
There are other extension libraries such as: gd library, mbstring, sqlite, mysql, etc. These are all together, so I won’t go into details.
4. Database link string
<span $db</span>= <span new</span> PDO("sqlsrv:server=127.0.0.1;database=dbname","user1","123456");
5. Configure PHP to IIS7.5
I am using win7 system. First install the FastCGI function of IIS. Go to Control Panel > Open Programs and Features > Click to turn Windows features on or off
Expand in order: Internet Information Services > World Wide Web Services > Application Development Function, check CGI
After installation, open IIS, you can open the processing mapping program in the default site
After entering, right-click and add module mapping
How to configure the website directory is the simplest. I won’t explain it in detail. You can create a new a.php in the website directory and enter the code
<span phpinfo</span>();
Run result:
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1386
52
Explain JSON Web Tokens (JWT) and their use case in PHP APIs.
Apr 05, 2025 am 12:04 AM
JWT is an open standard based on JSON, used to securely transmit information between parties, mainly for identity authentication and information exchange. 1. JWT consists of three parts: Header, Payload and Signature. 2. The working principle of JWT includes three steps: generating JWT, verifying JWT and parsing Payload. 3. When using JWT for authentication in PHP, JWT can be generated and verified, and user role and permission information can be included in advanced usage. 4. Common errors include signature verification failure, token expiration, and payload oversized. Debugging skills include using debugging tools and logging. 5. Performance optimization and best practices include using appropriate signature algorithms, setting validity periods reasonably,
Explain late static binding in PHP (static::).
Apr 03, 2025 am 12:04 AM
Static binding (static::) implements late static binding (LSB) in PHP, allowing calling classes to be referenced in static contexts rather than defining classes. 1) The parsing process is performed at runtime, 2) Look up the call class in the inheritance relationship, 3) It may bring performance overhead.
What are PHP magic methods (__construct, __destruct, __call, __get, __set, etc.) and provide use cases?
Apr 03, 2025 am 12:03 AM
What are the magic methods of PHP? PHP's magic methods include: 1.\_\_construct, used to initialize objects; 2.\_\_destruct, used to clean up resources; 3.\_\_call, handle non-existent method calls; 4.\_\_get, implement dynamic attribute access; 5.\_\_set, implement dynamic attribute settings. These methods are automatically called in certain situations, improving code flexibility and efficiency.
Explain the match expression (PHP 8 ) and how it differs from switch.
Apr 06, 2025 am 12:03 AM
In PHP8, match expressions are a new control structure that returns different results based on the value of the expression. 1) It is similar to a switch statement, but returns a value instead of an execution statement block. 2) The match expression is strictly compared (===), which improves security. 3) It avoids possible break omissions in switch statements and enhances the simplicity and readability of the code.
MySQL: Simple Concepts for Easy Learning
Apr 10, 2025 am 09:29 AM
MySQL is an open source relational database management system. 1) Create database and tables: Use the CREATEDATABASE and CREATETABLE commands. 2) Basic operations: INSERT, UPDATE, DELETE and SELECT. 3) Advanced operations: JOIN, subquery and transaction processing. 4) Debugging skills: Check syntax, data type and permissions. 5) Optimization suggestions: Use indexes, avoid SELECT* and use transactions.
What is Cross-Site Request Forgery (CSRF) and how do you implement CSRF protection in PHP?
Apr 07, 2025 am 12:02 AM
In PHP, you can effectively prevent CSRF attacks by using unpredictable tokens. Specific methods include: 1. Generate and embed CSRF tokens in the form; 2. Verify the validity of the token when processing the request.
Explain strict types (declare(strict_types=1);) in PHP.
Apr 07, 2025 am 12:05 AM
Strict types in PHP are enabled by adding declare(strict_types=1); at the top of the file. 1) It forces type checking of function parameters and return values to prevent implicit type conversion. 2) Using strict types can improve the reliability and predictability of the code, reduce bugs, and improve maintainability and readability.
How can you prevent a class from being extended or a method from being overridden in PHP? (final keyword)
Apr 08, 2025 am 12:03 AM
In PHP, the final keyword is used to prevent classes from being inherited and methods being overwritten. 1) When marking the class as final, the class cannot be inherited. 2) When marking the method as final, the method cannot be rewritten by the subclass. Using final keywords ensures the stability and security of your code.
