cvs: phpdoc-ru /security database.xml
| From: | Antony Dovgal | Date: | Mon, 22 Mar 2004 10:07:40 +0000 |
| Subject: | cvs: phpdoc-ru /security database.xml | ||
| Groups: | php.doc.ru | ||
| Request: | Send a blank email to doc-ru+get-256@lists.php.net to get a copy of this message | ||
tony2001 Mon Mar 22 05:07:40 2004 EDT
Modified files:
/phpdoc-ru/security database.xml
Log:
CS fixes by young
http://cvs.php.net/diff.php/phpdoc-ru/security/database.xml?r1=1.2&r2=1.3&ty=u
Index: phpdoc-ru/security/database.xml
diff -u phpdoc-ru/security/database.xml:1.2 phpdoc-ru/security/database.xml:1.3
--- phpdoc-ru/security/database.xml:1.2 Fri Mar 19 11:01:19 2004
+++ phpdoc-ru/security/database.xml Mon Mar 22 05:07:40 2004
@@ -1,6 +1,6 @@
<?xml version="1.0" encoding="windows-1251"?>
-<!-- $Revision: 1.2 $ -->
-<!-- EN-Revision: 1.1 Maintainer: young Status: ready -->
+<!-- $Revision: 1.3 $ -->
+<!-- EN-Revision: 1.3 Maintainer: young Status: ready -->
<!-- splitted from ./index.xml, last change in rev 1.66 -->
<sect1 id="security.database">
<title>Áåçîïàñíîñòü áàç äàííûõ</title>
@@ -119,6 +119,7 @@
<title>Èñïîëüçîâàíèå õåøèðîâàííûõ ïàðîëåé</title>
<programlisting role="php">
<![CDATA[
+<?php
// ñîõðàíåíèå õåøèðîâàííîãî ïàðîëÿ
$query = sprintf("INSERT INTO users(name,pwd) VALUES('%s','%s');",
addslashes($username), md5($password));
@@ -135,6 +136,7 @@
else {
echo "Authentication failed for $username.";
}
+?>
]]>
</programlisting>
</example>
@@ -168,12 +170,14 @@
</title>
<programlisting role="php">
<![CDATA[
+<?php
$offset = argv[0]; // ïðîâåðêà ïîëüçîâàòåëüñêèõ äàííûõ
îòñóòñòâóåò
$query = "SELECT id, name FROM products ORDER BY name LIMIT 20 OFFSET $offset;";
// èñïîëüçóÿ PostgreSQL
$result = pg_exec($conn, $query);
// èñïîëüçóÿ MySQL
$result = mysql_query($query);
+?>
]]>
</programlisting>
</example>
@@ -230,10 +234,12 @@
</title>
<programlisting role="php">
<![CDATA[
+<?php
$query = "SELECT id, name, inserted, size FROM products
WHERE size = '$size'
ORDER BY $order LIMIT $limit, $offset;";
$result = odbc_exec($conn, $query);
+?>
]]>
</programlisting>
</example>
@@ -267,7 +273,9 @@
</title>
<programlisting role="php">
<![CDATA[
+<?php
$query = "UPDATE usertable SET pwd='$pwd' WHERE uid='$uid';";
+?>
]]>
</programlisting>
</example>
@@ -279,11 +287,13 @@
<informalexample>
<programlisting role="php">
<![CDATA[
+<?php
// $uid == ' or uid like'%admin%'; --
$query = "UPDATE usertable SET pwd='...' WHERE uid='' or uid like
'%admin%'; --";
// $pwd == "hehehe', admin='yes', trusted=100 "
-$query = "UPDATE usertable SET pwd='hehehe', admin='yes', trusted=100
WHERE ...;"
+$query = "UPDATE usertable SET pwd='hehehe', admin='yes', trusted=100
WHERE ...;";
+?>
]]>
</programlisting>
</informalexample>