Home >Backend Development >PHP Tutorial >PHP error problem collection

PHP error problem collection

WBOY
WBOYOriginal
2016-07-29 09:05:251051browse

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
(&#39;John&#39;,&#39;$pswd1&#39;),
(&#39;Sam&#39;,&#39;$pswd2&#39;)";
mysql_query($sql,$con);
mysql_close($con);
?>

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[&#39;PHP_AUTH_USER&#39;])&&isset($_SERVER[&#39;PHP_AUTH_PW&#39;])){
    $authFile=file("authenticationFile.txt");
    if(in_array($_SERVER[&#39;PHP_AUTH_USER&#39;].":"
        .md5($_SERVER[&#39;PHP_AUTH_PW&#39;])."\n",$authFile)){
        $authorized=true;
    }
}
if(!$authorized){
    header(&#39;WWW-Authenticate:Basic Realm="Secret Stash"&#39;);
    header(&#39;HTTP/1.0 401 Unauthorized&#39;);
    print(&#39;You must provide the proper credentials&#39;);
    exit;
}
?>
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:
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