PDO is used for database connection, insertion, query and other operations

This article mainly introduces PDO's operations such as database connection, insertion, query, etc. Interested friends can refer to it. I hope it will be helpful to everyone.

The test code is as follows:

<?php
/**************************
@Filename: pdotest.php
@Content : PDO操作MySQL,Access（测试）
**************************/
if($_GET[&#39;db&#39;] == &#39;mysql&#39;)
{
  $dns = &#39;mysql:host=localhost;dbname=test&#39;;
  $dbuser = &#39;root&#39;;
  $dbpass = &#39;root&#39;;
  $db = new PDO($dns,$dbuser,$dbpass);
}
else
{
  $db = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=".getcwd()."//test.mdb");
}
if($_POST[&#39;reg&#39;])
{
  $db->exec("INSERT INTO t_user (name,email) VALUES (&#39;".$_POST[&#39;name&#39;]."&#39;,&#39;".$_POST[&#39;email&#39;]."&#39;) ;");
  // header(&#39;Location:&#39;.$_SERVER[&#39;PHP_SELF&#39;]);
  ?>
  <a href="pdotest.php">返回</a>
  <?
}
else
{
  $html = &#39;
<p id="new">
  <form action="&#39;.$_SERVER[&#39;REQUEST_URI&#39;].&#39;" method="post">
   Name: <input type="text" name="name" size="10" />
  Email: <input type="text" name="email" size="15" />
  <input type="submit" name="reg" value="Register" />
  </form>
</p>
&#39;;
  $re = $db->query("SELECT uid,name,email FROM t_user ORDER BY email ;");
  while($rs = $re->fetch())
  {
    $userlisthtml .= &#39;
<tr><td>&#39;.$rs[&#39;uid&#39;].&#39;</td><td>&#39;.$rs[&#39;name&#39;].&#39;</td><td>&#39;.$rs[&#39;email&#39;].&#39;</td></tr>&#39;;
  }
  $html .= &#39;
<p id="list">
  <table border="1">
  <caption>User List</caption>
  <thead>
    <tr><th>ID</th><th>Name</th><th>Email</th></tr>
  </thead>
  <tbody>&#39;.$userlisthtml.&#39;
  </tbody>
  </table>
</p>
&#39;;
}
echo $html;
?>

Test environment:

php.ini file: Open extension=php_pdo_odbc.dll Remove the semicolon and open the aceess database driver

Access path opened by mysql by default:

mysql database

##http://192.168.1.21/lava_guess2009/test/pdo/pdotest.php?db= mysql

aceess database

http://192.168.1.21/lava_guess2009/test/pdo/pdotest.php

Features: Use Different databases only need to change the connection driver, and the code does not need to be changed in any way, which is the benefit of the abstraction layer.

Summary: The above is the entire content of this article, I hope it will be helpful to everyone's learning.

Related recommendations:

PHP's method of converting XML into an array and example code

PHP's method of reading large files Detailed explanations and examples of multiple methods

php Methods and examples of HTML submission form without refreshing

The above is the detailed content of PDO is used for database connection, insertion, query and other operations. For more information, please follow other related articles on the PHP Chinese website!