Home Backend Development PHP Tutorial PHP error problem collection

PHP error problem collection

Jul 29, 2016 am 09:05 AM
mysql php quot

1. The single quotes surrounding $pswd1 and $pswd2 cannot be deleted, otherwise data cannot be inserted into MySQL.

<?php
$con=mysql_connect("localhost","root","00001111");
if(!$con){
    die("Could not connect MySQL database!");
}
mysql_select_db("sql_test",$con);
$pswd1=md5("0000");
$pswd2=md5("1111");
$sql="INSERT INTO logins (username,pswd)
VALUES
('John','$pswd1'),
('Sam','$pswd2')";
mysql_query($sql,$con);
mysql_close($con);
?>
Copy after login

2.Linux: The newline character in the file is "n"; Windows: The newline character in the file is "rn";

Example: File-based authentication

File authenticationFile. The content of txt is as follows:

jack:ae2bac2e4b4da805d01b2952d7e35ba4
milk:ae2bac2e4b4da805d01b2952d7e35ba4

<?php
$authorized=false;
if(isset($_SERVER['PHP_AUTH_USER'])&&isset($_SERVER['PHP_AUTH_PW'])){
    $authFile=file("authenticationFile.txt");
    if(in_array($_SERVER['PHP_AUTH_USER'].":"
        .md5($_SERVER['PHP_AUTH_PW'])."\n",$authFile)){
        $authorized=true;
    }
}
if(!$authorized){
    header('WWW-Authenticate:Basic Realm="Secret Stash"');
    header('HTTP/1.0 401 Unauthorized');
    print('You must provide the proper credentials');
    exit;
}
?>
Copy after login
If it is in a Windows environment, the above code "n" needs to be changed to "rn"

The above has introduced the collection of PHP error problems, including aspects of the problem. I hope it will be helpful to friends who are interested in PHP tutorials.

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian Dec 24, 2024 pm 04:42 PM

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian

CakePHP Date and Time CakePHP Date and Time Sep 10, 2024 pm 05:27 PM

CakePHP Date and Time

CakePHP File upload CakePHP File upload Sep 10, 2024 pm 05:27 PM

CakePHP File upload

CakePHP Routing CakePHP Routing Sep 10, 2024 pm 05:25 PM

CakePHP Routing

CakePHP Project Configuration CakePHP Project Configuration Sep 10, 2024 pm 05:25 PM

CakePHP Project Configuration

Discuss CakePHP Discuss CakePHP Sep 10, 2024 pm 05:28 PM

Discuss CakePHP

How to fix mysql_native_password not loaded errors on MySQL 8.4 How to fix mysql_native_password not loaded errors on MySQL 8.4 Dec 09, 2024 am 11:42 AM

How to fix mysql_native_password not loaded errors on MySQL 8.4

CakePHP Quick Guide CakePHP Quick Guide Sep 10, 2024 pm 05:27 PM

CakePHP Quick Guide

See all articles