|
PHP 的 MySQL 操作类,跟手册上的函数一样用,但是更方便了。多说无益,看了就知道了。(9) }else{ $this->halt("没有的成员变量 :$nm\n",1); } } function __set($nm, $val){ // } function __call($m, $a){ print "<hr>调用不存在的方法——".$m."(".join(",",$a).")!\n"; echo '<pre>'; var_dump($a); echo '</pre>'; $this->halt("<hr>"); } } // End DummyMySQLClass ?> <?php /** function __autoload($className) { include_once $className . ".php"; } $DMC = new DummyMySQLClass("localhost","root","","test"); //print_r($DMC); */ //--------------------------------------------------------- //--------------------------------------------------------- //--------------------------------------------------------- /**4 $DMC->query("SELECT * FROM `purchase_prodUCt` LIMIT 1"); while($fetchObject = $DMC->fetchObject(3)){ echo $DMC->fieldName(0).'<br>'; // 效果如:ID echo $DMC->fieldType(0).'<br>'; echo $DMC->fieldLen(0).'<br>'; // 效果如:9 print_r($DMC->fieldFlags(0)); // 效果如:not_null primary_key auto_increment echo '<hr>合起来的效果:<br>'; echo '`'.$DMC->fieldName(0).'` '.$DMC->fieldType(0).'('.$DMC->fieldLen(0).') '.str_replace(array("NOT_NULL","PRIMARY_KEY"),array("NOT NULL","PRIMARY KEY"),strtoupper($DMC->fieldFlags(0))).",\n<br>"; } //下面这是秘籍!!^_^ $DMC->query("show create table `purchase_product`"); while($fetchObject = $DMC->fetchObject(3)){ $t = 'Create Table';print_r($fetchObject->$t); } */ //--------------------------------------------------------- /**4 echo "getHostInfo() --- ".$DMC->getHostInfo().'<br>'; echo "getClientInfo() - ".$DMC->getClientInfo().'<br>';
|