如何使用PDO获取数据 [英] how to fetch data with PDO

问题描述

大家好，希望一切顺利吗？



请不要使用这个PDO，我怎样才能从我的数据库中获取数据，就像下面的Mysql查询一样

Hi all, hope all is well?

Please am new to this PDO thingy, how can I fetch data from my database just like this Mysql query below

<?php

include ("connect.php");


$email=@$_POST["email"];

$sql="SELECT sname,fname FROM user_db WHERE email='$email' ";
	$result=mysql_query($sql);

// Mysql_num_row is counting table row

$count=mysql_num_rows($result);

if($count==1){
	
$info=mysql_fetch_array($result);


$sname=$info['sname'];

$fname=$info['fname'];


}
else{
	
	echo "user details not found";
	
	}

?>

如何将PDO的连接字符串放在另一个文件中并在需要时导入并使用它？谢谢

And how can I put the connection string of the PDO in another file and import and use it when need? Thanks

推荐答案

email = @

email=@

_POST [ < span class =code-string> email];

_POST["email"];

sql = SELECT sname，fname FROM user_db WHERE email ='

sql="SELECT sname,fname FROM user_db WHERE email='

这篇关于如何使用PDO获取数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！