推薦：Mysql字符串字段判斷是否包含某個(gè)字符串的2種方法
假設(shè)有個(gè)表： 代碼如下: CREATE TABLE users(id int(6) NOT NULL AUTO_INCREMENT,PRIMARY KEY (id),user_name VARCHAR(20) NOT NULL,emails VARCHAR(50) NOT NULL); 初始化表，并添加些記錄。 代碼如下: truncate table users INSERT INTO users(user_name, emails) VA

 is7.5下常見(jiàn)程序通過(guò)web.config實(shí)現(xiàn)偽靜態(tài)新建一個(gè)以web.config命名的文件內(nèi)容為

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <system.webServer>
<!--將下面的規(guī)則添加到這里-->
    </system.webServer>
</configuration>
  

記得后臺(tái)的偽靜態(tài)要開(kāi)啟喔

以shopex規(guī)則示例如下，選擇需要的規(guī)則添加：

<!--shopex-->
<rewrite>
            <rules>
                <rule name="disableDownloadThemeHtml">
                    <match url="^themes/.*.(html|xml)$" ignoreCase="false" />
                    <action type="CustomResponse" url="/" statusCode="403" statusReason="Forbidden" statusDescription="Forbidden" />
                </rule>
                <rule name="urlRewrite">
                    <match url="^(.*)$" ignoreCase="false" />
                    <conditions logicalGrouping="MatchAll">
                        <add input="{REQUEST_FILENAME}" pattern=".(html|xml|json|htm|php|php2|php3|php4|php5|phtml|pwml|inc|asp|aspx|ascx|jsp|cfm|cfc|pl|cgi|shtml|shtm|phtm)$" ignoreCase="false" />
                        <add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" pattern="" ignoreCase="false" />
                        <add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" pattern="" ignoreCase="false" />
                    </conditions>
                    <action type="Rewrite" url="index.php?{R:1}" appendQueryString="false" />
                </rule>
            </rules>
        </rewrite>
<!--dz2.0-->
<rewrite>
<rules>
  <rule name="portal_topic">
   <match url="^(.*/)*topic-(.+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/portal.php\?mod=topic&amp;topic={R:2}&amp;{R:3}" />
  </rule>
  <rule name="portal_article">
   <match url="^(.*/)*article-([0-9]+)-([0-9]+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/portal.php\?mod=view&amp;aid={R:2}&amp;page={R:3}&amp;{R:4}" />
  </rule>
  <rule name="forum_forumdisplay">
   <match url="^(.*/)*forum-(\w+)-([0-9]+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/forum.php\?mod=forumdisplay&amp;fid={R:2}&amp;page={R:3}&amp;{R:4}" />
  </rule>
  <rule name="forum_viewthread">
   <match url="^(.*/)*thread-([0-9]+)-([0-9]+)-([0-9]+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/forum.php\?mod=viewthread&amp;tid={R:2}&amp;extra=page={R:4}&amp;page={R:3}&amp;{R:5}" />
  </rule>
  <rule name="group_group">
   <match url="^(.*/)*group-([0-9]+)-([0-9]+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/forum.php\?mod=group&amp;fid={R:2}&amp;page={R:3}&amp;{R:4}" />
  </rule>
  <rule name="home_space">
   <match url="^(.*/)*space-(username|uid)-(.+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/home.php\?mod=space&amp;{R:2}={R:3}&amp;{R:4}" />
  </rule>
  <rule name="home_blog">
   <match url="^(.*/)*blog-([0-9]+)-([0-9]+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/home.php\?mod=space&amp;uid={R:2}&amp;do=blog&amp;id={R:3}&amp;{R:4}" />
  </rule>
  <rule name="forum_archiver">
   <match url="^(.*/)*(fid|tid)-([0-9]+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/index.php\?action={R:2}&amp;value={R:3}&amp;{R:4}" />
  </rule>
</rules>
</rewrite>
<!--dz2.5-->
<rewrite>
<rules>
  <rule name="portal_topic">
   <match url="^(.*/)*topic-(.+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/portal.php\?mod=topic&amp;topic={R:2}&amp;{R:3}" />
  </rule>
  <rule name="portal_article">
   <match url="^(.*/)*article-([0-9]+)-([0-9]+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/portal.php\?mod=view&amp;aid={R:2}&amp;page={R:3}&amp;{R:4}" />
  </rule>
  <rule name="forum_forumdisplay">
   <match url="^(.*/)*forum-(\w+)-([0-9]+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/forum.php\?mod=forumdisplay&amp;fid={R:2}&amp;page={R:3}&amp;{R:4}" />
  </rule>
  <rule name="forum_viewthread">
   <match url="^(.*/)*thread-([0-9]+)-([0-9]+)-([0-9]+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/forum.php\?mod=viewthread&amp;tid={R:2}&amp;extra=page={R:4}&amp;page={R:3}&amp;{R:5}" />
  </rule>
  <rule name="group_group">
   <match url="^(.*/)*group-([0-9]+)-([0-9]+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/forum.php\?mod=group&amp;fid={R:2}&amp;page={R:3}&amp;{R:4}" />
  </rule>
  <rule name="home_space">
   <match url="^(.*/)*space-(username|uid)-(.+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/home.php\?mod=space&amp;{R:2}={R:3}&amp;{R:4}" />
  </rule>
  <rule name="home_blog">
   <match url="^(.*/)*blog-([0-9]+)-([0-9]+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/home.php\?mod=space&amp;uid={R:2}&amp;do=blog&amp;id={R:3}&amp;{R:4}" />
  </rule>
  <rule name="forum_archiver">
   <match url="^(.*/)*(fid|tid)-([0-9]+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/index.php\?action={R:2}&amp;value={R:3}&amp;{R:4}" />
  </rule>
  <rule name="plugin">
   <match url="^(.*/)*([a-z]+[a-z0-9_]*)-([a-z0-9_\-]+).html\?*(.*)$" />
   <action type="Rewrite" url="{R:1}/plugin.php\?id={R:2}:{R:3}&amp;{R:4}" />
  </rule>
</rules>
</rewrite>

分享：MSSQL 18052錯(cuò)誤: 9003，嚴(yán)重度: 20，狀態(tài): 1
問(wèn)題現(xiàn)象： 系統(tǒng)日志文件(控制面板管理工具系統(tǒng)日志) 能找到以下兩條錯(cuò)誤: 17052: 無(wú)法恢復(fù) master 數(shù)據(jù)庫(kù)。正在退出。 18052: 錯(cuò)誤: 9003，嚴(yán)重度: 20，狀態(tài): 1。 解決方法一： 將Microsoft SQL Server/MSSQL/Data 目錄改名為data_bak目錄，然后從其他機(jī)器上把master.