php module reference, php_PHP tutorial

php module reference, php

<span><span>  1</span> <?<span>php
</span><span>  2</span> <span>//</span><span>数据库连接类</span>
<span>  3</span> <span>class</span><span> ConnDB{
</span><span>  4</span>     
<span>  5</span>     <span>var</span> <span>$dbtype</span><span>;
</span><span>  6</span>     <span>var</span> <span>$host</span><span>;
</span><span>  7</span>     <span>var</span> <span>$user</span><span>;
</span><span>  8</span>     <span>var</span> <span>$pwd</span><span>;
</span><span>  9</span>     <span>var</span> <span>$dbname</span><span>;
</span><span> 10</span>     
<span> 11</span>     <span>//</span><span>构造方法</span>
<span> 12</span>     <span>function</span> ConnDB(<span>$dbtype</span>,<span>$host</span>,<span>$user</span>,<span>$pwd</span>,<span>$dbname</span><span>){
</span><span> 13</span>         <span>$this</span>->dbtype=<span>$dbtype</span><span>;
</span><span> 14</span>         <span>$this</span>->host=<span>$host</span><span>;
</span><span> 15</span>         <span>$this</span>->user=<span>$user</span><span>;
</span><span> 16</span>         <span>$this</span>->pwd=<span>$pwd</span><span>;
</span><span> 17</span>         <span>$this</span>->dbname=<span>$dbname</span><span>;
</span><span> 18</span> <span>    }
</span><span> 19</span> 
<span> 20</span>     <span>//</span><span>实现数据库的连接并返回连接对象</span>
<span> 21</span>     <span>function</span><span> GetConnId(){
</span><span> 22</span>          
<span> 23</span>         <span>if</span>(<span>$this</span>->dbtype=="mysql" || <span>$this</span>->dbtype=="mssql"<span>){
</span><span> 24</span>             <span>$dsn</span>="<span>$this</span>->dbtype:host=<span>$this</span>->host;dbname=<span>$this</span>->dbname"<span>;
</span><span> 25</span>         }<span>else</span><span>{
</span><span> 26</span>             <span>$dsn</span>="<span>$this</span>->dbtype:dbname=<span>$this</span>->dbname"<span>;
</span><span> 27</span> <span>        }    
</span><span> 28</span>         <span>try</span><span> {
</span><span> 29</span>             <span>$conn</span> = <span>new</span> PDO(<span>$dsn</span>, <span>$this</span>->user, <span>$this</span>->pwd);     <span>//</span><span>初始化一个PDO对象，就是创建了数据库连接对象$pdo</span>
<span> 30</span>             <span>$conn</span>->query("set names utf8"<span>);
</span><span> 31</span>             <span>return</span> <span>$conn</span><span>;
</span><span> 32</span>         } <span>catch</span> (PDOException <span>$e</span><span>) {
</span><span> 33</span>             <span>die</span> ("Error!: " . <span>$e</span>->getMessage() . "<br/>"<span>);
</span><span> 34</span> <span>        }
</span><span> 35</span> 
<span> 36</span>          
<span> 37</span> <span>    }    
</span><span> 38</span> <span>}
</span><span> 39</span> 
<span> 40</span> <span>//</span><span>数据库管理类</span>
<span> 41</span> <span>class</span><span> AdminDB{
</span><span> 42</span>     
<span> 43</span>     
<span> 44</span>     <span>function</span> ExecSQL(<span>$sqlstr</span>,<span>$conn</span><span>){
</span><span> 45</span>         
<span> 46</span>         <span>$sqltype</span>=<span>strtolower</span>(<span>substr</span>(<span>trim</span>(<span>$sqlstr</span>),0,6<span>));
</span><span> 47</span>         <span>$rs</span>=<span>$conn</span>->prepare(<span>$sqlstr</span>);        <span>//</span><span>准备查询语句</span>
<span> 48</span>         <span>$rs</span>->execute();                    <span>//</span><span>执行查询语句，并返回结果集</span>
<span> 49</span>         <span>if</span>(<span>$sqltype</span>=="select"<span>){
</span><span> 50</span>             <span>$array</span>=<span>$rs</span>->fetchAll(PDO::FETCH_ASSOC);        <span>//</span><span>获取结果集中的所有数据</span>
<span> 51</span>             <span>if</span>(<span>count</span>(<span>$array</span>)==0 || <span>$rs</span>==<span>false</span><span>)
</span><span> 52</span>                 <span>return</span> <span>false</span><span>;
</span><span> 53</span>             <span>else</span>
<span> 54</span>                 <span>return</span> <span>$array</span><span>;
</span><span> 55</span>         }<span>elseif</span> (<span>$sqltype</span>=="update" || <span>$sqltype</span>=="insert" || <span>$sqltype</span>=="delete"<span>){            
</span><span> 56</span>             <span>if</span>(<span>$rs</span><span>)
</span><span> 57</span>                 <span>return</span> <span>true</span><span>;
</span><span> 58</span>             <span>else</span> 
<span> 59</span>                 <span>return</span> <span>false</span><span>;    
</span><span> 60</span> <span>        }
</span><span> 61</span> <span>    }
</span><span> 62</span> <span>}
</span><span> 63</span> <span>//</span><span>分页类</span>
<span> 64</span> <span>class</span><span> SepPage{
</span><span> 65</span>     <span>var</span> <span>$rs</span><span>;
</span><span> 66</span>     <span>var</span> <span>$pagesize</span><span>;
</span><span> 67</span>     <span>var</span> <span>$nowpage</span><span>;
</span><span> 68</span>     <span>var</span> <span>$array</span><span>;
</span><span> 69</span>     <span>var</span> <span>$conn</span><span>;
</span><span> 70</span>     <span>var</span> <span>$sqlstr</span><span>;
</span><span> 71</span>     <span>function</span> ShowData(<span>$sqlstr</span>,<span>$conn</span>,<span>$pagesize</span>,<span>$nowpage</span>){    <span>//</span><span>定义方法</span>
<span> 72</span>         <span>if</span>(!<span>isset</span>(<span>$nowpage</span>) || <span>$nowpage</span>=="")            <span>//</span><span>判断变量值是否为空</span>
<span> 73</span>             <span>$this</span>->nowpage=1;                        <span>//</span><span>定义每页起始页</span>
<span> 74</span>         <span>else</span>
<span> 75</span>             <span>$this</span>->nowpage=<span>$nowpage</span><span>;
</span><span> 76</span>         <span>$this</span>->pagesize=<span>$pagesize</span>;                    <span>//</span><span>定义每页输出的记录数</span>
<span> 77</span>         <span>$this</span>->conn=<span>$conn</span>;                            <span>//</span><span>连接数据库返回的标识</span>
<span> 78</span>         <span>$this</span>->sqlstr=<span>$sqlstr</span>;                            <span>//</span><span>执行的查询语句</span>
<span> 79</span>         <span>$offset</span>=(<span>$this</span>->nowpage-1)*<span>$this</span>-><span>pagesize;
</span><span> 80</span>         <span>$sql</span>=<span>$this</span>->sqlstr." limit <span>$offset</span>, <span>$this</span>->pagesize"<span>;
</span><span> 81</span>         <span>$result</span>=<span>$this</span>->conn->prepare(<span>$sql</span>);            <span>//</span><span>准备查询语句</span>
<span> 82</span>         <span>$result</span>->execute();                        <span>//</span><span>执行查询语句，并返回结果集</span>
<span> 83</span>         <span>$this</span>-><span>array</span>=<span>$result</span>->fetchAll(PDO::FETCH_ASSOC);        <span>//</span><span>获取结果集中的所有数据</span>
<span> 84</span>         <span>if</span>(<span>count</span>(<span>$this</span>-><span>array</span>)==0 || <span>$this</span>-><span>array</span>==<span>false</span><span>)
</span><span> 85</span>             <span>return</span> <span>false</span><span>;
</span><span> 86</span>         <span>else</span>
<span> 87</span>             <span>return</span> <span>$this</span>-><span>array</span><span>;
</span><span> 88</span> <span>    }
</span><span> 89</span>     
<span> 90</span>     <span>function</span> ShowPage(<span>$contentname</span>,<span>$utits</span>,<span>$anothersearchstr</span>,<span>$anothersearchstrs</span>,<span>$class</span><span>){
</span><span> 91</span>         <span>$str</span>=""<span>;
</span><span> 92</span>         <span>$res</span>=<span>$this</span>->conn->prepare(<span>$this</span>->sqlstr);            <span>//</span><span>准备查询语句</span>
<span> 93</span>         <span>$res</span>->execute();                        <span>//</span><span>执行查询语句，并返回结果集</span>
<span> 94</span>         <span>$this</span>-><span>array</span>=<span>$res</span>->fetchAll(PDO::FETCH_ASSOC);        <span>//</span><span>获取结果集中的所有数据    </span>
<span> 95</span>         <span>$record</span>=<span>count</span>(<span>$this</span>-><span>array</span>);                <span>//</span><span>统计记录总数</span>
<span> 96</span>         
<span> 97</span>         <span>$pagecount</span>=<span>ceil</span>(<span>$record</span>/<span>$this</span>->pagesize);        <span>//</span><span>计算共有几页</span>
<span> 98</span>         <span>$str</span>.=<span>$contentname</span>." ".<span>$record</span>." ".<span>$utits</span>." 每页 ".<span>$this</span>->pagesize." ".<span>$utits</span>." 第 ".<span>$this</span>->nowpage." 页/共 ".<span>$pagecount</span>." 页"<span>;
</span><span> 99</span>         <span>$str</span>.="    "<span>;
</span><span>100</span>         <span>if</span>(<span>$this</span>->nowpage!=1<span>)
</span><span>101</span>             <span>$str</span>.="<a href=".<span>$_SERVER</span>['PHP_SELF']."?page=1&page_type=".<span>$anothersearchstr</span>."&parameter2=".<span>$anothersearchstrs</span>." class=".<span>$class</span>.">首页</a>"<span>;
</span><span>102</span>         <span>else</span>
<span>103</span>             <span>$str</span>.="<font color='#555555'>首页</font>"<span>;
</span><span>104</span>         <span>$str</span>.=" "<span>;
</span><span>105</span>         <span>if</span>(<span>$this</span>->nowpage!=1<span>)
</span><span>106</span>             <span>$str</span>.="<a href=".<span>$_SERVER</span>['PHP_SELF']."?page=".(<span>$this</span>->nowpage-1)."&page_type=".<span>$anothersearchstr</span>."&parameter2=".<span>$anothersearchstrs</span>." class=".<span>$class</span>.">上一页</a>"<span>;
</span><span>107</span>         <span>else</span>
<span>108</span>             <span>$str</span>.="<font color='#555555'>上一页</font>"<span>;
</span><span>109</span>         <span>$str</span>.=" "<span>;    
</span><span>110</span>         <span>if</span>(<span>$this</span>->nowpage!=<span>$pagecount</span><span>)
</span><span>111</span>             <span>$str</span>.="<a href=".<span>$_SERVER</span>['PHP_SELF']."?page=".(<span>$this</span>->nowpage+1)."&page_type=".<span>$anothersearchstr</span>."&parameter2=".<span>$anothersearchstrs</span>." class=".<span>$class</span>.">下一页</a>"<span>;
</span><span>112</span>         <span>else</span>
<span>113</span>             <span>$str</span>.="<font color='#555555'>下一页</font>"<span>;    
</span><span>114</span>         <span>$str</span>.=" "<span>;
</span><span>115</span>         <span>if</span>(<span>$this</span>->nowpage!=<span>$pagecount</span><span>)
</span><span>116</span>             <span>$str</span>.="<a href=".<span>$_SERVER</span>['PHP_SELF']."?page=".<span>$pagecount</span>."&page_type=".<span>$anothersearchstr</span>."&parameter2=".<span>$anothersearchstrs</span>." class=".<span>$class</span>.">尾页</a>"<span>;
</span><span>117</span>         <span>else</span>
<span>118</span>             <span>$str</span>.="<font color='#555555'>尾页</font>"<span>;
</span><span>119</span>         <span>if</span>(<span>count</span>(<span>$this</span>-><span>array</span>)==0 || <span>$this</span>-><span>array</span>==<span>false</span><span>)            
</span><span>120</span>             <span>return</span> "无数据！"<span>;
</span><span>121</span>         <span>else</span>
<span>122</span>             <span>return</span> <span>$str</span><span>;    
</span><span>123</span> <span>    }
</span><span>124</span> <span>}
</span><span>125</span> <span>//</span><span>系统常用方法</span>
<span>126</span> <span>class</span><span> UseFun{
</span><span>127</span>     
<span>128</span>     <span>function</span> UnHtml(<span>$text</span><span>){
</span><span>129</span>        <span>$content</span>=(<span>nl2br</span>(<span>htmlspecialchars</span>(<span>$text</span><span>)));
</span><span>130</span>        <span>$content</span>=<span>str_replace</span>("[strong]","<strong>",<span>$content</span><span>);
</span><span>131</span>        <span>$content</span>=<span>str_replace</span>("[/strong]","</strong>",<span>$content</span><span>);
</span><span>132</span>        <span>$content</span>=<span>str_replace</span>("[em]","<em>",<span>$content</span><span>);
</span><span>133</span>        <span>$content</span>=<span>str_replace</span>("[/em]","</em>",<span>$content</span><span>);
</span><span>134</span>        <span>$content</span>=<span>str_replace</span>("[u]","<u>",<span>$content</span><span>);
</span><span>135</span>        <span>$content</span>=<span>str_replace</span>("[/u]","</u>",<span>$content</span><span>);
</span><span>136</span>     
<span>137</span>     
<span>138</span>        <span>$content</span>=<span>str_replace</span>("[font color=#FF0000]","<font color=#FF0000>",<span>$content</span><span>);
</span><span>139</span>        <span>$content</span>=<span>str_replace</span>("[font color=#00FF00]","<font color=#00FF00>",<span>$content</span><span>);
</span><span>140</span>        <span>$content</span>=<span>str_replace</span>("[font color=#0000FF]","<font color=#0000FF>",<span>$content</span><span>);
</span><span>141</span>     
<span>142</span>        <span>$content</span>=<span>str_replace</span>("[font face=楷体_GB2312]","<font face=楷体_GB2312>",<span>$content</span><span>);
</span><span>143</span>        <span>$content</span>=<span>str_replace</span>("[font face=宋体]","<font face=新宋体>",<span>$content</span><span>);
</span><span>144</span>        <span>$content</span>=<span>str_replace</span>("[font face=隶书]","<font face=隶书>",<span>$content</span><span>);
</span><span>145</span>        <span>$content</span>=<span>str_replace</span>("[/font]","</font>",<span>$content</span><span>);
</span><span>146</span>        <span>//</span><span>$content=str_replace(chr(32)," ",$content);</span>
<span>147</span>        <span>$content</span>=<span>str_replace</span>("[font size=1]","<font size=1>",<span>$content</span><span>);
</span><span>148</span>        <span>$content</span>=<span>str_replace</span>("[font size=2]","<font size=2>",<span>$content</span><span>);
</span><span>149</span>        <span>$content</span>=<span>str_replace</span>("[font size=3]","<font size=3>",<span>$content</span><span>);
</span><span>150</span>        <span>$content</span>=<span>str_replace</span>("[font size=4]","<font size=4>",<span>$content</span><span>);
</span><span>151</span>        <span>$content</span>=<span>str_replace</span>("[font size=5]","<font size=5>",<span>$content</span><span>);
</span><span>152</span>        <span>$content</span>=<span>str_replace</span>("[font size=6]","<font size=6>",<span>$content</span><span>);
</span><span>153</span>        
<span>154</span>        <span>$content</span>=<span>str_replace</span>("[FIELDSET][LEGEND]","<FIELDSET><LEGEND>",<span>$content</span><span>);
</span><span>155</span>        <span>$content</span>=<span>str_replace</span>("[/LEGEND]","</LEGEND>",<span>$content</span><span>);
</span><span>156</span>        <span>$content</span>=<span>str_replace</span>("[/FIELDSET]","</FIELDSET>",<span>$content</span><span>);
</span><span>157</span>        <span>return</span> <span>$content</span><span>;
</span><span>158</span> <span>    }
</span><span>159</span>     
<span>160</span> <span>}
</span><span>161</span> 
<span>162</span> ?></span>

Ask what are the more popular modules in PHP?

Say the module .... I understand it too well, because of the php module php environment concept, the php environment consists of multiple modules It consists of modules used by php to implement certain functions, such as gd library, which is used to implement image operations.

But I think said code blocks, or reuse code, look for php classes and go to www.phpclasses.org. There are 2 official projects, is called PEAR, and the other is is called PECL, which provides a lot of functional support, and Brothers have already started, I suggest take a look at zendframework.

How to use the existing php module? Is it added to the web page?

Message board source code copy web directory than bbs directory add link to the main page Message program in the bbs directory

http://www.bkjia.com/PHPjc/827940.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/827940.htmlTechArticlephp module reference, php 1 ? php 2 // Database connection class 3 class ConnDB{ 4 5 var $dbtype; 6 var $host ; 7 var $user ; 8 var $pwd ; 9 var $dbname ; 10 11 //Construction method 12 function C...