Menu
▾
▴
[phpwiki-checkins] SF.net SVN: phpwiki:[10967] trunk/lib/WikiDB/backend/PDO.php
|
From: <var...@us...> - 2022-02-01 09:10:07
|
Revision: 10967
http://sourceforge.net/p/phpwiki/code/10967
Author: vargenau
Date: 2022-02-01 09:10:03 +0000 (Tue, 01 Feb 2022)
Log Message:
-----------
Use MAX_PAGENAME_LENGTH in bindParam
Modified Paths:
--------------
trunk/lib/WikiDB/backend/PDO.php
Modified: trunk/lib/WikiDB/backend/PDO.php
===================================================================
--- trunk/lib/WikiDB/backend/PDO.php 2022-02-01 08:54:54 UTC (rev 10966)
+++ trunk/lib/WikiDB/backend/PDO.php 2022-02-01 09:10:03 UTC (rev 10967)
@@ -225,7 +225,7 @@
. " FROM $nonempty_tbl, $page_tbl"
. " WHERE $nonempty_tbl.id=$page_tbl.id"
. " AND pagename=?");
- $sth->bindParam(1, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(1, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
if ($sth->execute())
return $sth->fetchColumn();
else
@@ -263,7 +263,7 @@
$sth = $dbh->prepare("UPDATE $page_tbl SET hits=hits+1"
. " WHERE pagename=?"
. " LIMIT 1");
- $sth->bindParam(1, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(1, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
$sth->execute();
}
@@ -276,7 +276,7 @@
$page_tbl = $this->_table_names['page_tbl'];
$sth = $dbh->prepare("SELECT id,pagename,hits,pagedata FROM $page_tbl"
. " WHERE pagename=? LIMIT 1");
- $sth->bindParam(1, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(1, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
$sth->execute();
$row = $sth->fetch(PDO::FETCH_NUM);
return $row ? $this->_extract_page_data($row[3], $row[2]) : false;
@@ -303,7 +303,7 @@
// hit count, who cares?
$sth = $dbh->prepare("UPDATE $page_tbl SET hits=? WHERE pagename=? LIMIT 1");
$sth->bindParam(1, $newdata['hits'], PDO::PARAM_INT);
- $sth->bindParam(2, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(2, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
$sth->execute();
return true;
}
@@ -332,7 +332,7 @@
$sth->bindParam(1, $hits, PDO::PARAM_INT);
$serialized_data = $this->_serialize($data);
$sth->bindParam(2, $serialized_data, PDO::PARAM_LOB);
- $sth->bindParam(3, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(3, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
if ($sth->execute()) {
$this->commit();
return true;
@@ -347,7 +347,7 @@
$dbh = &$this->_dbh;
$page_tbl = $this->_table_names['page_tbl'];
$sth = $dbh->prepare("SELECT cached_html FROM $page_tbl WHERE pagename=? LIMIT 1");
- $sth->bindParam(1, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(1, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
$sth->execute();
return $sth->fetchColumn(0);
}
@@ -362,7 +362,7 @@
. " WHERE pagename=?"
. " LIMIT 1");
$sth->bindParam(1, $data, PDO::PARAM_STR);
- $sth->bindParam(2, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(2, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
$sth->execute();
}
@@ -383,7 +383,7 @@
$dbh = &$this->_dbh;
$page_tbl = $this->_table_names['page_tbl'];
$sth = $dbh->prepare("SELECT id FROM $page_tbl WHERE pagename=? LIMIT 1");
- $sth->bindParam(1, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(1, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
$sth->execute();
$id = $sth->fetchColumn();
if (!$create_if_missing) {
@@ -396,7 +396,7 @@
$sth = $dbh->prepare("INSERT INTO $page_tbl"
. " (id,pagename)"
. " VALUES (NULL,?)");
- $sth->bindParam(1, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(1, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
$sth->execute();
$id = $dbh->lastInsertId();
} else {
@@ -409,7 +409,7 @@
. " VALUES (?,?,0)");
$id++;
$sth->bindParam(1, $id, PDO::PARAM_INT);
- $sth->bindParam(2, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(2, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
if ($sth->execute())
$this->commit();
else
@@ -429,7 +429,7 @@
. " WHERE $page_tbl.id=$recent_tbl.id"
. " AND pagename=?"
. " LIMIT 1");
- $sth->bindParam(1, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(1, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
$sth->execute();
return $sth->fetchColumn();
}
@@ -445,7 +445,7 @@
. " AND version < ?"
. " ORDER BY version DESC"
. " LIMIT 1");
- $sth->bindParam(1, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(1, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
$sth->bindParam(2, $version, PDO::PARAM_INT);
$sth->execute();
return $sth->fetchColumn();
@@ -486,7 +486,7 @@
. " AND pagename=?"
. " AND version=?"
. " LIMIT 1");
- $sth->bindParam(1, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(1, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
$sth->bindParam(2, $version, PDO::PARAM_INT);
$sth->execute();
$row = $sth->fetch(PDO::FETCH_NUM);
@@ -813,7 +813,7 @@
. $exclude
. $orderby
. $limit);
- $sth->bindParam(1, $pagename, PDO::PARAM_STR, 100);
+ $sth->bindParam(1, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
$sth->execute();
return new WikiDB_backend_PDO_iter($this, $sth, $this->page_tbl_field_list);
}
@@ -835,8 +835,8 @@
. " WHERE linkfrom=linker.id AND linkto=linkee.id"
. " AND $have.pagename=?"
. " AND $want.pagename=?");
- $sth->bindParam(1, $pagename, PDO::PARAM_STR, 100);
- $sth->bindParam(2, $link, PDO::PARAM_STR, 100);
+ $sth->bindParam(1, $pagename, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
+ $sth->bindParam(2, $link, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
$sth->execute();
return $sth->fetchColumn();
}
@@ -1126,7 +1126,7 @@
$this->lock(array('page', 'version', 'recent', 'nonempty', 'link'));
$id = $this->_get_pageid($pagename);
$sth = $dbh->prepare("UPDATE $page_tbl SET pagename=? WHERE id=?");
- $sth->bindParam(1, $to, PDO::PARAM_STR, 100);
+ $sth->bindParam(1, $to, PDO::PARAM_STR, MAX_PAGENAME_LENGTH);
$sth->bindParam(2, $id, PDO::PARAM_INT);
$sth->execute();
$this->unlock(array('page', 'version', 'recent', 'nonempty', 'link'));
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
