PHP中MySql函数收集

说明：

　　 返回对应结果集的关联数组，并且继续移动内部数据指针。

参数：result

　　  resource 型的结果集。此结果集来自对 mysql_query() 的调用。

实例：

<?<span style="color: #000000;">php
 
</span><span style="color: #800080;">$conn</span>  =  mysql_connect ( <span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000; font-weight: bold;">localhost</span><span style="color: #000000; font-weight: bold;">"</span> ,  <span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000; font-weight: bold;">mysql_user</span><span style="color: #000000; font-weight: bold;">"</span> ,  <span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000; font-weight: bold;">mysql_password</span><span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000;"> );
 
</span><span style="color: #0000ff;">if</span> (! <span style="color: #800080;">$conn</span><span style="color: #000000;"> ) {
    echo  </span><span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000; font-weight: bold;">Unable to connect to DB: </span><span style="color: #000000; font-weight: bold;">"</span>  .<span style="color: #000000;">  mysql_error ();
    </span><span style="color: #0000ff;">exit</span><span style="color: #000000;">;
}
  
</span><span style="color: #0000ff;">if</span> (! mysql_select_db ( <span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000; font-weight: bold;">mydbname</span><span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000;"> )) { 
    echo  </span><span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000; font-weight: bold;">Unable to select mydbname: </span><span style="color: #000000; font-weight: bold;">"</span>  .<span style="color: #000000;">  mysql_error ();
    </span><span style="color: #0000ff;">exit</span><span style="color: #000000;">;
}
 
</span><span style="color: #800080;">$sql</span>  =  <span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000; font-weight: bold;">SELECT id as userid, fullname, userstatus 
        FROM   sometable
        WHERE  userstatus = 1</span><span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000;"> ;
 
</span><span style="color: #800080;">$result</span>  =  mysql_query ( <span style="color: #800080;">$sql</span><span style="color: #000000;"> );
 
</span><span style="color: #0000ff;">if</span> (! <span style="color: #800080;">$result</span><span style="color: #000000;"> ) {
    echo  </span><span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000; font-weight: bold;">Could not successfully run query ( $sql ) from DB: </span><span style="color: #000000; font-weight: bold;">"</span>  .<span style="color: #000000;">  mysql_error ();
    </span><span style="color: #0000ff;">exit</span><span style="color: #000000;">;
}
 
</span><span style="color: #0000ff;">if</span> ( mysql_num_rows ( <span style="color: #800080;">$result</span> ) ==  <span style="color: #800000;">0</span><span style="color: #000000;"> ) {
    echo  </span><span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000; font-weight: bold;">No rows found, nothing to print so am exiting</span><span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000;"> ;
    </span><span style="color: #0000ff;">exit</span><span style="color: #000000;">;
}
 
</span>// <span style="color: #0000ff;">While</span> a row of data <span style="color: #0000ff;">exists</span>, put that row in <span style="color: #800080;">$row</span><span style="color: #000000;"> as an associative array
</span>// Note: <span style="color: #0000ff;">If</span> you<span style="color: #000000; font-weight: bold;">‘</span><span style="color: #000000; font-weight: bold;">re expecting just one row, no need to use a loop
// Note: If you put extract($row); inside the following loop, you</span><span style="color: #000000; font-weight: bold;">‘</span><span style="color: #000000;">ll
</span>//       then create <span style="color: #800080;">$userid</span>, <span style="color: #800080;">$fullname</span>, and <span style="color: #800080;">$userstatus</span>
 <span style="color: #0000ff;">while</span> ( <span style="color: #800080;">$row</span>  =  mysql_fetch_assoc ( <span style="color: #800080;">$result</span><span style="color: #000000;"> )) {
    echo  </span><span style="color: #800080;">$row</span> [ <span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000; font-weight: bold;">userid</span><span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000;"> ];
    echo  </span><span style="color: #800080;">$row</span> [ <span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000; font-weight: bold;">fullname</span><span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000;"> ];
    echo  </span><span style="color: #800080;">$row</span> [ <span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000; font-weight: bold;">userstatus</span><span style="color: #000000; font-weight: bold;">"</span><span style="color: #000000;"> ];
}
 
mysql_free_result ( </span><span style="color: #800080;">$result</span><span style="color: #000000;"> );
 
</span>?> 

PHP中MySql函数收集

标签：