基本的PHP面向对象的MYSQL查询

问题描述：

So I've been learning for about 3 months now and am currently using very old procedural techniques and the deprecated mysql extension in my code. So time to take a step forward, ditch my procedural ways and get into object oriented / prepared statements...

This is very basic but I guess everyone has to learn some day. I'm trying to get retrieve and simple dataset from mysql database..

so far I have my connection:

$useri = new mysqli('localhost', 'useri', 'xxx','yyy');
if(mysqli_connect_errno()){
    echo mysqli_connect_error();
        }

I get no errors so I assume this works, and I have my query:

$test_query = "SELECT * FROM t";
$test_query = $useri->real_escape_string($test_query);
 echo $test_query;
  if($result = $useri->query($test_query)){
   while($row = $useri->fetch_object($result)){
    echo $row->id;
 }
 $result->close();
}
$useri->close();

However I get no results... so, 2 questions:

a. what am I doing wrong? and

b. anyone recommend any good tutorials apart from the php manual for this stuff?

Thanks :)

所以我现在已经学习了大约3个月，现在正在使用非常古老的程序技术和不推荐的mysql扩展在我的代码中。所以是时候向前迈出一步，抛弃我的程序方法，进入面向对象/准备好的陈述...... p>

这是非常基本的，但我想每个人都必须有一天学习。我正试图从mysql数据库中获取检索和简单的数据集.. p>

到目前为止我有我的连接： p>

  $ useri =  new mysqli（'localhost'，'useri'，'xxx'，'yyy'）; 
if（mysqli_connect_errno（））{
 echo mysqli_connect_error（）; 
} 
  code>  pre> 
  
 我没有错误所以我认为这有效，我有我的查询： p> 
 
 
  $ test_query =“SELECT * FROM t”; 
 $ test_query =  $ useri-＆gt; real_escape_string（$ test_query）; 
 echo $ test_query; 
 if（$ result = $ useri-＆gt; query（$ test_query））{
 while（$ row = $ useri-＆gt; fetch_object（  $ result））{
 echo $ row-＆gt; id; 
} 
 $ result-＆gt; close（）; 
} 
 $ useri-＆gt; close（）; 
  code>  
 
 但是我得不到任何结果......所以，2个问题： p> 
 
 
 a。 我究竟做错了什么？ 和 P> 
 
 
湾 除了这个东西的php手册之外，还有人推荐任何好的教程吗？ p> 
 
 
谢谢：） p> 
  div>

答

This works for one of the table i have in my db:

$useri = new mysqli('localhost', 'useri', 'xxx','yyy');
if(mysqli_connect_errno()){
echo mysqli_connect_error();
    }

$test_query = "SELECT * FROM t";
$test_query = $useri->real_escape_string($test_query);
  if($result = $useri->query($test_query)){
    while ($row = $result->fetch_object()) { //only this is changed
    echo $row->id;
  }
 $result->close();
 }else{ //check for error if query was wrong
 echo $useri->error;
 }
 $useri->close();

答

make sure that you have a space after *
```
$test_query = "SELECT * FROM t";
```
check this tutorial

http://net.tutsplus.com/tutorials/php/php-database-access-are-you-doing-it-correctly/ http://net.tutsplus.com/tutorials/php/why-you-should-be-using-phps-pdo-for-database-access/

基本的PHP面向对象的MYSQL查询

相关推荐