<script>ec(2);</script>
-
dd = new LampDb('localhost','root','2184237','note','utf8');
-
$sql = "select * from mynote";
-
$handle = $dd->query($sql);
-
$aa = $dd->fetchOneRow($handle);
-
print_r($aa);
-
echo "
";
-
$ddd = $dd->fetchRows($handle);
-
for ($n=0; $n count($ddd); $n++){
-
echo $ddd[$n]['id'] . "标题" . $ddd[$n]['subject'];
-
echo "
";
- }
-
echo "
";
-
echo "nums=" . $dd->fetchRowNums($handle);
- ?>
-
- php
-
class LampDb
- {
-
private $conn;
-
-
function __construct($host,$user,$pass,$dbname,$charset)
- {
-
$this->conn = mysql_connect($host,$user,$pass);
-
mysql_query('set names $charset');
-
$db = mysql_select_db($dbname,$this->conn);
- }
-
-
function query($sql)
- {
-
$handle = mysql_query($sql,$this->conn);
-
return $handle;
- }
-
-
function fetchOneRow($handle)
- {
-
$aa = mysql_fetch_assoc($handle);
-
return $aa;
- }
-
-
function fetchRows($handle,$i=0)
- {
-
while($bb = mysql_fetch_assoc($handle)){
-
$bbb[$i] = $bb;
-
$i++;
- }
-
return $bbb;
- }
-
-
function fetchRowNums($handle)
- {
-
-
$num = mysql_num_rows($handle);
-
return $num;
- }
- }
- ?>
本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系admin@php.cn
广告
6313
收藏
