PHP MyTextSanitizer::addSlashes示例

 private function save_metas()
 {
     $this->db->queryF("DELETE FROM " . $this->db->prefix("rd_meta") . " WHERE section='" . $this->id() . "'");
     if (empty($this->metas)) {
         return true;
     }
     $sql = "INSERT INTO " . $this->db->prefix("rd_meta") . " (`name`,`value`,`section`,`edit`) VALUES ";
     $values = '';
     foreach ($this->metas as $name => $value) {
         if (is_array($value)) {
             $value = $value['value'];
         }
         $values .= ($values == '' ? '' : ',') . "('" . MyTextSanitizer::addSlashes($name) . "','" . MyTextSanitizer::addSlashes($value) . "','" . $this->getVar('id_sec') . "','1')";
     }
     if ($this->db->queryF($sql . $values)) {
         return true;
     } else {
         $this->addError($this->db->error());
         return false;
     }
 }

示例#2

显示文件

文件： qpcategory.class.php 项目： laiello/bitcero-modules

 function __construct($id = '')
 {
     $this->db =& XoopsDatabaseFactory::getDatabaseConnection();
     $this->_dbtable = $this->db->prefix("qpages_categos");
     $this->setNew();
     $this->initVarsFromTable();
     if ($id == '') {
         return;
     }
     if (is_numeric($id)) {
         if (!$this->loadValues($id)) {
             return;
         }
     } else {
         $this->primary = 'nombre_amigo';
         if (!$this->loadValues(MyTextSanitizer::addSlashes($id))) {
             return;
         }
     }
     $this->primary = 'id_cat';
     $this->unsetNew();
 }

示例#3

显示文件

文件： functions.php 项目： laiello/bitcero-modules

/**
* Check if a modules is installed
* @param string Module dirname
* @return bool
*/
function xt_module_installed($dir)
{
    if ($dir == '') {
        return;
    }
    $db = Database::getInstance();
    $sql = "SELECT COUNT(*) FROM " . $db->prefix("modules") . " WHERE dirname='" . MyTextSanitizer::addSlashes($dir) . "'";
    list($num) = $db->fetchRow($db->query($sql));
    if ($num <= 0) {
        return false;
    }
    return true;
}

示例#4

显示文件

文件： qppage.class.php 项目： laiello/bitcero-modules

 /**
  * Save existing meta
  */
 private function saveMetas()
 {
     $this->db->queryF("DELETE FROM " . $this->db->prefix("qpages_meta") . " WHERE page='" . $this->getID() . "'");
     if (empty($this->metas)) {
         return true;
     }
     $sql = "INSERT INTO " . $this->db->prefix("qpages_meta") . " (`name`,`value`,`page`) VALUES ";
     $values = '';
     foreach ($this->metas as $name => $value) {
         $values .= ($values == '' ? '' : ',') . "('" . MyTextSanitizer::addSlashes($name) . "','" . MyTextSanitizer::addSlashes($value) . "','" . $this->getID() . "')";
     }
     if ($this->db->queryF($sql . $values)) {
         return true;
     } else {
         $this->addError($this->db->error());
         return false;
     }
 }