MysqL:host=localhost;dbname=database",'username','password');
//
MysqLi,面向过程方式
$
MysqLi =
MysqLi_connect('localhost','password','database');
//
MysqLi,面向对象
$
MysqLi = new
MysqLi('localhost','database');
'test',':email' => $mail,':last_login' => time() - 3600);
$pdo->prepare('
SELECT * FROM users
WHERE username = :username
AND email = :email
AND last_login > :last_login');
prepare('
SELECT * FROM users
WHERE username = ?
AND email = ?
AND last_login > ?');
$query->bind_param('sss','test',$mail,time() - 3600);
$query->execute();
id . ': ' . $this->first_name . ' ' . $this->last_name;
}
}
$query = "SELECT id,first_name,last_name FROM users";
// PDO
$result = $pdo->query($query);
$result->setFetchMode(PDO::FETCH_CLASS,'User');
while ($user = $result->fetch())
{
echo $user->info() . "\n";
}
query($query)) {
while ($user = $result->fetch_object('User')) {
echo $user->info()."\n";
}
}
prepare('SELECT * FROM users WHERE username = :username');
$pdo->execute(array(':username' => $_GET['username']));
prepare('SELECT * FROM users WHERE username = ?');
$query->bind_param('s',$_GET['username']);
$query->execute();
