PHP를 사용하여 데이터베이스에서 간단한 추가, 삭제, 수정 및 쿼리 구현(순수 코드, 개선 예정)

<span>php
    </span><span>$con</span> = <span>mysql_connect</span>("localhost:3306","root",""<span>);

    </span><span>if</span> (!<span>$con</span><span>) {
        </span><span>die</span>('Could not connect: ' . <span>mysql_error</span><span>());
    }

    </span><span>mysql_select_db</span>("test", <span>$con</span><span>);

    </span><span>$result</span> = <span>mysql_query</span>("SELECT * FROM user"<span>);

    </span><span>echo</span> "<span><table border="1">
    <tr>
    <th>Username</th>
    <th>Password</th>
    </tr>"<span>;

    </span><span>while</span>(<span>$row</span> = <span>mysql_fetch_array</span>(<span>$result</span><span>)) {
        </span><span>echo</span> "<tr>"<span>;
        </span><span>echo</span> "<td>" . <span>$row</span>['username'] . "</td>"<span>;
        </span><span>echo</span> "<td>" . <span>$row</span>['password'] . "</td>"<span>;
        </span><span>echo</span> "</tr>"<span>;
    }
    </span><span>echo</span> "</table>"<span>;

    </span><span>mysql_close</span>(<span>$con</span><span>);

</span>?></span>

서버에서 모든 사용자 정보(SQL SELECT 문)를 가져와서 테이블 형식으로 표현

<span>php
    </span><span>$con</span> = <span>mysql_connect</span>("localhost","root",""<span>);
    </span><span>if</span> (!<span>$con</span><span>) {
        </span><span>die</span>('Could not connect: ' . <span>mysql_error</span><span>());
    }

    </span><span>mysql_select_db</span>("test", <span>$con</span><span>);

    </span><span>mysql_query</span>("DELETE FROM user WHERE username = '<span>$_POST</span>[username]'"<span>);

    </span><span>mysql_close</span>(<span>$con</span><span>);
</span>?>

이 사용자의 모든 정보 삭제 delete.php

<span>php
    </span><span>$con</span> = <span>mysql_connect</span>("localhost:3306","root",""<span>);

    </span><span>if</span> (!<span>$con</span><span>) {
        </span><span>die</span>('Could not connect: ' . <span>mysql_error</span><span>());
    }

    </span><span>mysql_select_db</span>("test", <span>$con</span><span>);

    </span><span>$sql</span> = "<span>INSERT INTO user (username,password)
    VALUES
    ('</span><span>$_POST</span>[username]','<span>$_POST</span>[password]')"<span>;

    </span><span>if</span> (!<span>mysql_query</span>(<span>$sql</span>,<span>$con</span><span>)) {
        </span><span>die</span>('Error: ' . <span>mysql_error</span><span>());
    }

    </span><span>echo</span> "1 record added"<span>;

    </span><span>mysql_close</span>(<span>$con</span><span>);

</span>?>

신규 사용자 등록 insert.php

<span>php

    </span><span>$con</span> = <span>mysql_connect</span>("localhost","root",""<span>);
    </span><span>if</span> (!<span>$con</span><span>) {
        </span><span>die</span>('Could not connect: ' . <span>mysql_error</span><span>());
    }

    </span><span>mysql_select_db</span>("test", <span>$con</span><span>);

    </span><span>mysql_query</span>("UPDATE user SET password = '<span>$_POST</span>[password]' WHERE username = '<span>$_POST</span>[username]'"<span>);

    </span><span>mysql_close</span>(<span>$con</span><span>);
</span>?>

사용자 비밀번호 변경 update.php

    
        <title>用PHP向数据库中实现简单的增删改查</title>
    
    
        <br>
        <h1>Insert:</h1>
        

username:
password:

---

Delete

username:
Are you sure?

---

Update

username:
You want to change your password into:

---

위 세 가지 기능의 제출 소스 Operate.html

위 내용은 PHP를 사용하여 데이터베이스(순수 코드, 개선 예정)에서 간단한 추가, 삭제, 수정 및 검색을 구현하는 방법을 소개하며, 관련 측면도 포함하여 PHP 튜토리얼에 관심이 있는 친구들에게 도움이 되기를 바랍니다.