PDO链接数据库,并选择数据
<?php
$dbms='mysql';
$host='127.0.0.1';
$dbName='mysql';
$user='root';
$pass='root';
$dsn="$dbms:host=$host;dbname=$dbName";
try {
$dbh = new PDO($dsn, $user, $pass);
echo "连接成功<br/>";
$msgname=$_POST["name"] ? $_POST["name"] : "ceshi";
echo $msgname . "string <br>";
foreach ($dbh->query("SELECT * from db where User like '$msgname'") as $row) {
print_r($row);
print_r($row['Db']);
}
$dbh = null;
} catch (PDOException $e) {
die ("Error!: " . $e->getMessage() . "<br/>");
}
?>
天龙八步连接数据库
<?php
require './../phpModules/test_data.php';
$link= mysqli_connect('127.0.0.1','root','root');
if (!$link) {
exit('error('.mysqli_connect_errno.'):'.mysqli_connect_error);
}
mysqli_select_db($link,'mysql');
$sql = 'select * from db';
$result = mysqli_query($link,$sql);
while($row = mysqli_fetch_row($result))
{
var_dump($row);
}