# 第十一課 mysql和pdo 原生的mysql ``` <pre class="calibre16">``` <span class="token1">mysql_connect</span><span class="token2">(</span><span class="token4">"localhost"</span><span class="token2">,</span><span class="token4">"root"</span><span class="token2">,</span><span class="token4">"mysql"</span><span class="token2">)</span> or <span class="token1">die</span><span class="token2">(</span><span class="token1">mysql_error</span><span class="token2">(</span><span class="token2">)</span><span class="token2">)</span><span class="token2">;</span> <span class="token1">mysql_select_db</span><span class="token2">(</span>$db<span class="token2">)</span> or <span class="token1">die</span><span class="token2">(</span><span class="token1">mysql_error</span><span class="token2">(</span><span class="token2">)</span><span class="token2">)</span><span class="token2">;</span> <span class="token1">mysql_query</span><span class="token2">(</span><span class="token4">"set names utf8"</span><span class="token2">)</span><span class="token2">;</span> $result1 <span class="token">=</span> <span class="token1">mysql_query</span><span class="token2">(</span><span class="token4">"insert into t_typevalues(null,'你好','hello') "</span><span class="token2">)</span><span class="token2">;</span> echo <span class="token1">mysql_affected_rows</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span> <span class="token5">if</span><span class="token2">(</span><span class="token1">mysql_affected_rows</span><span class="token2">(</span><span class="token2">)</span><span class="token">></span><span class="token3">0</span><span class="token2">)</span><span class="token2">{</span> echo <span class="token4">'插入成功'</span><span class="token2">;</span> <span class="token2">}</span> $result2 <span class="token">=</span> <span class="token1">mysql_query</span><span class="token2">(</span><span class="token4">"update t_type set value='中國' where id=61"</span><span class="token2">)</span><span class="token2">;</span> echo <span class="token1">mysql_affected_rows</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span> <span class="token5">if</span><span class="token2">(</span>$result2 <span class="token">&&</span> <span class="token1">mysql_affected_rows</span><span class="token2">(</span><span class="token2">)</span><span class="token">></span><span class="token3">0</span><span class="token2">)</span><span class="token2">{</span> echo <span class="token4">'修改成功'</span><span class="token2">;</span> <span class="token2">}</span> $result3 <span class="token">=</span> <span class="token1">mysql_query</span><span class="token2">(</span><span class="token4">"delete from t_type where id=3"</span><span class="token2">)</span><span class="token2">;</span> echo <span class="token1">mysql_affected_rows</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span> <span class="token5">if</span><span class="token2">(</span>$result3 <span class="token">&&</span> <span class="token1">mysql_affected_rows</span><span class="token2">(</span><span class="token2">)</span><span class="token">></span><span class="token3">0</span><span class="token2">)</span><span class="token2">{</span> echo <span class="token4">"刪除成功"</span><span class="token2">;</span> <span class="token2">}</span> $sql2 <span class="token">=</span> "create table <span class="token5">if</span> not exists <span class="token1">t_mysql1</span><span class="token2">(</span> id <span class="token1">int</span><span class="token2">(</span><span class="token3">10</span><span class="token2">)</span> primary key AUTO_INCREMENT<span class="token2">,</span> no <span class="token1">int</span><span class="token2">(</span><span class="token3">10</span><span class="token2">)</span><span class="token2">,</span> name <span class="token1">VARCHAR</span><span class="token2">(</span><span class="token3">255</span><span class="token2">)</span><span class="token2">)</span>"<span class="token2">;</span> $result4 <span class="token">=</span> <span class="token1">mysql_query</span><span class="token2">(</span>$sql2<span class="token2">)</span><span class="token2">;</span> <span class="token5">if</span><span class="token2">(</span>$result4<span class="token2">)</span><span class="token2">{</span> echo <span class="token4">"創建表成功"</span><span class="token2">;</span> <span class="token2">}</span> $sql3 <span class="token">=</span> <span class="token4">"drop table if exists t_mysql1"</span><span class="token2">;</span> $result5 <span class="token">=</span> <span class="token1">mysql_query</span><span class="token2">(</span>$sql3<span class="token2">)</span><span class="token2">;</span> <span class="token5">if</span><span class="token2">(</span>$result5<span class="token2">)</span><span class="token2">{</span> echo <span class="token4">"刪除表成功"</span><span class="token2">;</span> <span class="token2">}</span> <span class="token1">mysql_query</span><span class="token2">(</span><span class="token4">"begin"</span><span class="token2">)</span><span class="token2">;</span> $result7 <span class="token">=</span> <span class="token1">mysql_query</span><span class="token2">(</span>"insert into t_mysql <span class="token1">values</span><span class="token2">(</span><span class="token5">null</span><span class="token2">,</span><span class="token4">'11111112333vs'</span><span class="token2">)</span>"<span class="token2">)</span><span class="token2">;</span> $result8 <span class="token">=</span> <span class="token1">mysql_query</span><span class="token2">(</span>"insert into t_mysql <span class="token1">values</span><span class="token2">(</span><span class="token5">null</span><span class="token2">,</span><span class="token4">'111111111111vs44433'</span><span class="token2">)</span>"<span class="token2">)</span><span class="token2">;</span> <span class="token5">if</span><span class="token2">(</span>$result7 <span class="token">&&</span> $result8 <span class="token">&&</span> <span class="token1">mysql_affected_rows</span><span class="token2">(</span><span class="token2">)</span><span class="token">></span><span class="token3">0</span><span class="token2">)</span><span class="token2">{</span> <span class="token1">mysql_query</span><span class="token2">(</span><span class="token4">"commit"</span><span class="token2">)</span><span class="token2">;</span> echo <span class="token4">'事務成功'</span><span class="token2">;</span> <span class="token2">}</span><span class="token5">else</span><span class="token2">{</span> <span class="token1">mysql_query</span><span class="token2">(</span><span class="token4">"rollback"</span><span class="token2">)</span><span class="token2">;</span> <span class="token2">}</span> 關聯數組和數字數組 MYSQL_ASSOC關聯 MYSQL_NUM數字 <span class="token5">while</span> <span class="token2">(</span>$row <span class="token">=</span> <span class="token1">mysql_fetch_array</span><span class="token2">(</span>$result<span class="token2">,</span> MYSQL_NUM<span class="token2">)</span><span class="token2">)</span> <span class="token2">{</span> printf <span class="token2">(</span><span class="token4">"ID: %s Name: %s"</span><span class="token2">,</span> $row<span class="token2">[</span><span class="token3">0</span><span class="token2">]</span><span class="token2">,</span> $row<span class="token2">[</span><span class="token3">1</span><span class="token2">]</span><span class="token2">)</span><span class="token2">;</span> <span class="token2">}</span> 關聯數組 <span class="token1">mysql_fetch_assoc</span><span class="token2">(</span>$result<span class="token2">)</span><span class="token2">)</span> 對象 <span class="token1">mysql_fetch_object</span><span class="token2">(</span>$result<span class="token2">)</span><span class="token2">)</span> 數字數組 <span class="token1">mysql_fetch_row</span><span class="token2">(</span>$result<span class="token2">)</span><span class="token2">;</span> 插入的id $id <span class="token">=</span> <span class="token1">mysql_insert_id</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span> 結果集數目 $num <span class="token">=</span> <span class="token1">mysql_num_rows</span><span class="token2">(</span>$result<span class="token2">)</span><span class="token2">;</span> 版本號 <span class="token1">mysql_get_server_info</span><span class="token2">(</span><span class="token2">)</span><span class="token2">;</span> ``` ```