- $DB_HOST ="localhost";
- $DB_LOGIN ="root";
- $DB_PASSWORD =" 123456";
- $conn=mysql_connect($DB_HOST,$DB_LOGIN,$DB_PASSWORD);
複製代碼mysql_data_seek將內部查詢指標移動至查詢行上文法bool mysql_data_seek(resource result_indetifier,int row_number)樣本：
- $DB_HOST ="localhost";
- $DB_LOGIN ="root";
- $DB_PASSWORD ="123456";
- $DB_NAME ="flag";
- $conn=mysql_connect($DB_HOST,$DB_LOGIN,$DB_PASSWORD);
- mysql_select_db($DB_NAME);
- $res=mysql_query("SELECT * FROM PRODUCT");
- $row=mysql_fetch_array($res);
- for($i=0;$i<$num;$i++)
- $row=mysql_fetch_array($res);
- mysql_data_seek($res,0);//移動指標回到查詢果的第一行
複製代碼mysql_fetch_array將查詢的結果存在數組中（每一個數組元素存一個記錄）文法array mysql_fetch_array(resource result[,int result_type])樣本：
- $DB_HOST ="localhost";
- $DB_LOGIN ="root";
- $DB_PASSWORD ="123456";
- $DB_NAME ="flag";
- $conn=mysql_connect($DB_HOST,$DB_LOGIN,$DB_PASSWORD);
- mysql_select_db($DB_NAME);
- $res=mysql_query("SELECT * FROM PRODUCT");
- $row=mysql_fetch_array($res);
複製代碼mysql_fetch_object取得查詢結果一行，並以物件類型儲存之，與MySQL_fetch_array()使用方法完全相同，不同的是mysql_fetch_object()只能通過欄位名稱來取得查詢結果echo $row->fieldname; //正確用法echo $row->0; //錯誤用法文法object mysql_fetch_object(resource result)樣本：
- $DB_HOST ="localhost";
- $DB_LOGIN ="root";
- $DB_PASSWORD ="123456";
- $DB_NAME ="flag";
- $conn=mysql_connect($DB_HOST,$DB_LOGIN,$DB_PASSWORD);
- mysql_select_db($DB_NAME);
- $res=mysql_query("SELECT * FROM PRODUCT");
- $row=$mysql_fetch_object($res);
- while($row)
- {
- echo $rowàp_id;
- echo $rowàp_name;
- }
複製代碼mysql_insert_id在使用INSERT命令增加完一條資訊後，可利用此函數取得剛剛增加記錄的unique id文法int mysql_insert_id([esource link_identifier])樣本：
- $DB_HOST ="localhost";
- $DB_LOGIN ="root";
- $DB_PASSWORD ="123456";
- $DB_NAME ="flag";
- $conn=mysql_connect($DB_HOST,$DB_LOGIN,$DB_PASSWORD);
- mysql_select_db($DB_NAME);
- $SQLStr"INSERT INTO produce (p_id,p_name)VALUES('','PHP書')";
- $res=mysql_query($res);
- $p_id=mysql_insert_id();
複製代碼mysql_num_rows取得查詢結果裡有幾行文法int mysql_num_rows(resource result)樣本：
- $DB_HOST ="localhost";
- $DB_LOGIN ="root";
- $DB_PASSWORD ="123456";
- $DB_NAME ="flag";
- $conn=mysql_connect($DB_HOST,$DB_LOGIN,$DB_PASSWORD);
- mysql_select_db($DB_NAME);
- $res=mysql_query("SELECT * FROM PRODUCT");
- $num=mysql_num_rows($res);
複製代碼mysql_query送出一個SQL文法的查詢語句文法resource mysql_query(string query[,resource link_identifier])樣本：
- $DB_HOST ="localhost";
- $DB_LOGIN ="root";
- $DB_PASSWORD="123456";
- $DB_NAME ="flag";
- $conn=mysql_connect($DB_HOST,$DB_LOGIN,$DB_PASSWORD);
- mysql_select_db($DB_NAME);
- $res=mysql_query("SELECT * FROM PRODUCT");
複製代碼mysql_select_db選擇欲存取的資料庫名稱文法bool mysql_select_db(string database_name[,resource link_identifier])樣本：
- $DB_HOST ="localhost";
- $DB_LOGIN ="root";
- $DB_PASSWORD ="123456";
- $DB_NAME ="flag";
- $conn=mysql_connect($DB_HOST,$DB_LOGIN,$DB_PASSWORD);
- mysql_select_db($DB_NAME);
複製代碼 1 2 3 下一頁 尾頁 |
