1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
|
## Clean up all the failed and moved links in the documentation.
--- libphp-adodb.orig/docs/docs-adodb.htm
+++ libphp-adodb/docs/docs-adodb.htm
@@ -835,12 +835,12 @@
of ADOdb.</li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l4 level1 lfo2;tab-stops:list 36.0pt'><a
- href="http://www.interakt.ro/phakt/">PHAkt: PHP Extension for DreamWeaver
+ href="http://www.interaktonline.com/Products/Free-Products/PHAkt/EOL/">PHAkt: PHP Extension for DreamWeaver
Ultradev</a> allows you to script PHP in the popular Web page editor.
Database handling provided by ADOdb.</li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l4 level1 lfo2;tab-stops:list 36.0pt'><a
- href="http://www.andrew.cmu.edu/%7Erdanyliw/snort/snortacid.html">Analysis
+ href="http://www.andrew.cmu.edu/user/rdanyliw/snort/snortacid.html">Analysis
Console for Intrusion Databases</a> (ACID): PHP-based analysis engine to
search and process a database of security incidents generated by
security-related software such as IDSes and firewalls (e.g. Snort,
@@ -853,13 +853,13 @@
and is fully multi-lingual enabled. </li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l4 level1 lfo2;tab-stops:list 36.0pt'><a
- href="http://www.auto-net.no/easypublish.php?page=index&lang_id=2">EasyPublish
+ href="http://www.escio.no/index.php?page_id=3&lang_id=2">EasyPublish
CMS</a> is another free content management system for managing information
and integrated modules on your internet, intranet- and extranet-sites.
From <st1:country-region w:st="on"><st1:place w:st="on">Norway</st1:place></st1:country-region>.</li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l4 level1 lfo2;tab-stops:list 36.0pt'><a
- href="http://nola.noguska.com/">NOLA</a> is a full featured accounting,
+ href="http://www.nolapro.com/nolapro.html">NOLA</a> is a full featured accounting,
inventory, and job tracking application. It is licensed under the GPL, and
developed by Noguska. </li>
</ul>
@@ -1987,7 +1987,7 @@
<p><span style='font-size:10.0pt'>Unix and Windows. <br>
<a href="http://phpbuilder.com/columns/alberto20000919.php3">Unix install
howto</a> and <a
- href="http://linuxjournal.com/article.php?sid=6636&mode=thread&order=0">another
+ href="http://www.linuxjournal.com/article/6636">another
one</a>. </span></p>
</td>
</tr>
@@ -3547,7 +3547,7 @@
<p>Since ADOdb 2.30, we support the generation of SQL to create pivot tables,
also known as cross-tabulations. For further explanation read this DevShed <a
-href="http://www.devshed.com/Server_Side/MySQL/MySQLWiz/">Cross-Tabulation tutorial</a>.
+href="http://www.devshed.com/c/a/MySQL/MySQL-wizardry/1/">Cross-Tabulation tutorial</a>.
We assume that your database supports the SQL case-when expression. </p>
<p>In this example, we will use the Northwind database from Microsoft. In the
@@ -4288,7 +4288,7 @@
".$ADODB_CACHE_DIR." -name adodb_*.cache`");</span></code></p>
<p>For general cleanup of all expired files, you should use <a
-href="http://www.superscripts.com/tutorial/crontab.html">crontab</a> on Unix,
+href="http://www.adminschoice.com/docs/crontab.htm">crontab</a> on Unix,
or at.exe on Windows, and a shell script similar to the following:<span
style='font-family:"Courier New"'><br>
#------------------------------------------------------ <br>
@@ -4788,7 +4788,7 @@
<a
href="http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10759/statements_10005.htm">Oracle</a>,
<a href="http://dev.mysql.com/doc/refman/5.0/en/set-transaction.html">MySQL</a>,
-and <a href="http://msdn2.microsoft.com/en-US/ms173763.aspx">MS SQL Server</a>.
+and <a href="http://msdn.microsoft.com/en-us/ms173763.aspx">MS SQL Server</a>.
</p>
<p><b>GetAssoc<a name=getassoc1></a>($sql,$inputarr=false,$force_array=false,$first2cols=false)</b></p>
--- libphp-adodb.orig/docs/docs-oracle.htm
+++ libphp-adodb/docs/docs-oracle.htm
@@ -35,7 +35,7 @@
<li>ADOdb library</li>
</ul>
<p>The wide range of choices is confusing to someone just starting with Oracle and PHP. I will briefly summarize the differences, and show you the advantages of using <a href="http://adodb.sourceforge.net/">ADOdb</a>. </p>
-<p>First we have the C extensions which provide low-level access to Oracle functionality. These C extensions are precompiled into PHP, or linked in dynamically when the web server starts up. Just in case you need it, here's a <a href=http://www.oracle.com/technology/tech/opensource/php/apache/inst_php_apache_linux.html>guide to installing Oracle and PHP on Linux</a>.</p>
+<p>First we have the C extensions which provide low-level access to Oracle functionality. These C extensions are precompiled into PHP, or linked in dynamically when the web server starts up. Just in case you need it, here's a <a href="http://www.oracle.com/technology/tech/php/htdocs/inst_php_apache_linux.html">guide to installing Oracle and PHP on Linux</a>.</p>
<table width="75%" border="1" align="center">
<tr valign="top">
<td nowrap><b>Oracle extension</b></td>
@@ -457,9 +457,9 @@
$db->Execute("insert into atable (f1, f2) values (?,?)", array(12, 'abc'));</pre>
<p> <a name=connecting></a>
<h3>9. Connecting to Oracle</h3>
-<p>Before you can use ADOdb, you need to have the Oracle client installed and setup the oci8 extension. This extension comes pre-compiled for Windows (but you still need to enable it in the php.ini file). For information on compiling the oci8 extension for PHP and Apache on Unix, there is an excellent guide at <a href="http://www.oracle.com/technology/tech/opensource/php/apache/inst_php_apache_linux.html">oracle.com</a>. </p>
+<p>Before you can use ADOdb, you need to have the Oracle client installed and setup the oci8 extension. This extension comes pre-compiled for Windows (but you still need to enable it in the php.ini file). For information on compiling the oci8 extension for PHP and Apache on Unix, there is an excellent guide at <a href="http://www.oracle.com/technology/tech/php/htdocs/inst_php_apache_linux.html">oracle.com</a>. </p>
<h4>Should You Use Persistent Connections</h4>
-<p>One question that is frequently asked is should you use persistent connections to Oracle. Persistent connections allow PHP to recycle existing connections, reusing them after the previous web pages have completed. Non-persistent connections close automatically after the web page has completed. Persistent connections are faster because the cost of reconnecting is expensive, but there is additional resource overhead. As an alternative, Oracle allows you to pool and reuse server processes; this is called <a href="http://www.cise.ufl.edu/help/database/oracle-docs/server.920/a96521/manproc.htm#13132">Shared Server</a> (also known as MTS).</p>
+<p>One question that is frequently asked is should you use persistent connections to Oracle. Persistent connections allow PHP to recycle existing connections, reusing them after the previous web pages have completed. Non-persistent connections close automatically after the web page has completed. Persistent connections are faster because the cost of reconnecting is expensive, but there is additional resource overhead. As an alternative, Oracle allows you to pool and reuse server processes; this is called <a href="http://www.dba-oracle.com/t_mts_multithreaded_servers_shared.htm">Shared Server</a> (also known as MTS).</p>
<p>The author's benchmarks suggest that using non-persistent connections and the Shared Server configuration offer the best performance. If Shared Server is not an option, only then consider using persistent connections.</p>
<h4>Connection Examples</h4>
<p>Just in case you are having problems connecting to Oracle, here are some examples:</p>
@@ -534,7 +534,7 @@
<ul>
<li>Oracle's <a href="http://www.oracle.com/technology/pub/articles/php_experts/index.html">Hitchhiker Guide to PHP</a></li>
<li>OTN article on <a href=http://www.oracle.com/technology/pub/articles/deployphp/lim_deployphp.html>Optimizing PHP and Oracle</a> by this author.
- <li>Oracle has an excellent <a href="http://www.oracle.com/technology/tech/opensource/php/php_troubleshooting_faq.html">FAQ on PHP</a></li>
+ <li>Oracle has an excellent <a href="http://www.oracle.com/technology/tech/php/htdocs/php_troubleshooting_faq.html">FAQ on PHP</a></li>
<li>PHP <a href="http://php.net/oci8">oci8</a> manual pages</li>
<li><a href=http://phplens.com/lens/lensforum/topics.php?id=4>ADOdb forums</a>.
</ul>
--- libphp-adodb.orig/docs/docs-perf.htm
+++ libphp-adodb/docs/docs-perf.htm
@@ -110,7 +110,7 @@
<table bgcolor="lightyellow" border="1" width="100%">
<tbody>
<tr>
- <td> <b><a href="http://php.weblogs.com/adodb?perf=1">ADOdb</a>
+ <td> <b><a href="http://phplens.com/lens/adodb/docs-perf.htm">ADOdb</a>
Performance Monitor</b> for localhost, db=test<br>
<font size="-1">PostgreSQL 7.3.2 on i686-pc-cygwin, compiled by
GCC gcc (GCC) 3.2 20020927 (prerelease)</font></td>
@@ -370,7 +370,7 @@
<td>data cache buffers</td>
<td>250 </td>
<td>See <a
- href="http://www7b.boulder.ibm.com/dmdd/library/techarticle/anshum/0107anshum.html#bufferpoolsize">tuning
+ href="http://www-128.ibm.com/developerworks/db2/library/techarticle/anshum/0107anshum.html#bufferpoolsize">tuning
reference</a>.</td>
</tr>
<tr bgcolor="#ffffff">
--- libphp-adodb.orig/docs/docs-session.htm
+++ libphp-adodb/docs/docs-session.htm
@@ -299,7 +299,7 @@
<h2>Session Cookie Regeneration: adodb_session_regenerate_id()</h2>
<p>Dynamically change the current session id with a newly generated one and update
database. Currently only works with cookies. Useful to improve security by
- reducing the risk of session-hijacking. See this article on <a href=http://shiflett.org/articles/security-corner-feb2004>Session
+ reducing the risk of session-hijacking. See this article on <a href="http://shiflett.org/articles/session-fixation">Session
Fixation</a> for more info
on the theory behind this feature. Usage:<pre>
include('path/to/adodb/session/adodb-session2.php');
--- libphp-adodb.orig/docs/docs-session.old.htm
+++ libphp-adodb/docs/docs-session.old.htm
@@ -279,7 +279,7 @@
<h3>adodb_session_regenerate_id()</h3>
<p>Dynamically change the current session id with a newly generated one and update database. Currently only
works with cookies. Useful to improve security by reducing the risk of session-hijacking.
-See this article on <a href=http://shiflett.org/articles/security-corner-feb2004>Session Fixation</a> for more info
+See this article on <a href="http://shiflett.org/articles/session-fixation">Session Fixation</a> for more info
on the theory behind this feature. Usage:
<pre>
$ADODB_SESSION_DRIVER='mysql';
--- libphp-adodb.orig/docs/tips_portable_sql.htm
+++ libphp-adodb/docs/tips_portable_sql.htm
@@ -358,7 +358,7 @@
sound principles. Learn the theory of normalization and entity-relationship diagrams and model
your data carefully. Understand how joins and indexes work and how they are used to tune performance.
<p> Visit the following page for more references on database theory and vendors:
- <a href="http://php.weblogs.com/sql_tutorial">http://php.weblogs.com/sql_tutorial</a>.
+ <a href="http://phplens.com/lens/adodb/tips_portable_sql.htm">http://phplens.com/lens/adodb/tips_portable_sql.htm</a>.
Also read this article on <a href=http://phplens.com/lens/php-book/optimizing-debugging-php.php>Optimizing PHP</a>.
<p>
<font size=1>(c) 2002-2003 John Lim.</font>
--- libphp-adodb.orig/docs/tute.htm
+++ libphp-adodb/docs/tute.htm
@@ -41,7 +41,7 @@
<p>ADODB stands for Active Data Objects DataBase (sorry computer guys are sometimes
not very original). ADODB currently supports MySQL, PostgreSQL, Oracle, Interbase,
Microsoft SQL Server, Access, FoxPro, Sybase, ODBC and ADO. You can download
- ADODB from <a href=http://php.weblogs.com/adodb></a><a href="http://php.weblogs.com/adodb">http://php.weblogs.com/adodb</a>.
+ ADODB from <a href=http://adodb.sourceforge.net></a><a href="http://adodb.sourceforege.net">http://adodb.sourceforge.net</a>.
<h3>MySQL Example</h3>
<p>The most common database used with PHP is MySQL, so I guess you should be familiar
with the following code. It connects to a MySQL server at <i>localhost</i>,
@@ -160,7 +160,7 @@
$conn->PConnect('localhost','userid','password','database');
$rs = $conn->Execute('select * from table');
<b> rs2html($rs)</b>; /* recordset to html table */ </pre>
-<p>There are many other helper functions that are listed in the documentation available at <a href="http://php.weblogs.com/adodb_manual"></a><a href="http://php.weblogs.com/adodb_manual">http://php.weblogs.com/adodb_manual</a>.
+<p>There are many other helper functions that are listed in the documentation available at <a href="http://phplens.com/adodb/"></a><a href="http://phplens.com/adodb/">http://phplens.com/adodb/</a>.
<h2>Advanced Material</h2>
<h3>Inserts and Updates </h3>
<p>Let's say you want to insert the following data into a database.
@@ -228,7 +228,7 @@
<p><b>PHP4 Session Handler Support</b>
<p>ADODB also supports PHP4 session handlers. You can store your session variables
in a database for true scalability using ADODB. For further information, visit
- <a href="http://php.weblogs.com/adodb-sessions"></a><a href="http://php.weblogs.com/adodb-sessions">http://php.weblogs.com/adodb-sessions</a>
+ <a href="http://phplens.com/lens/adodb/docs-session.htm"></a><a href="http://phplens.com/lens/adodb/docs-session.htm">http://phplens.com/lens/adodb/docs-session.htm</a>
<h3>Commercial Use Encouraged</h3>
<p>If you plan to write commercial PHP applications that you want to resell, you should consider ADODB. It has been released using the lesser GPL, which means you can legally include it in commercial applications, while keeping your code proprietary. Commercial use of ADODB is strongly encouraged! We are using it internally for this reason.<p>
|
