Re: cvs: phpdoc /en/security database.xml

From: Date: Mon, 22 Mar 2004 10:00:58 +0000
Subject: Re: cvs: phpdoc /en/security database.xml
Groups: php.doc.ru 
Request: Send a blank email to doc-ru+get-255@lists.php.net to get a copy of this message
Good day. Diff file for /phpdoc-ru/ru/security/database.xml Trying again... Third version of diff file :) -- С уважением, Voytsekhovskyy mailto:mail@young.org.ua

--- database.xml.old Mon Mar 22 11:43:32 2004 +++ database.xml Mon Mar 22 11:43:50 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>
« previous php.doc.ru (#255) next »