How to read fetch PDO FETCH ASSOC

Question

I am trying to build a web application using PHP and I am using memcached for storing user data from the DB   For example lets say that I have this code     sql       SELECT   FROM users WHERE user id    user id    stmt      this- gt  db- gt prepare  sql    result    stmt- gt execute array   user id    gt   user id     user      stmt- gt fetch PDO  FETCH ASSOC     I am not really sure how to read the  user variable and get the data out of it  I will need to be able to read the email and password column   I was hoping that someone could explain to me how this works   Thanks

User · Answer

Design Pattern  table-data gateway      class Gateway       protected  connection   null       public function   construct                  this- gt connection   new PDO  mysql host localhost  dbname db users    root                   public function loadAll                  sql    SELECT   FROM users            rows    this- gt connection- gt query  sql            return  rows             public function loadById  id                 sql    SELECT   FROM users WHERE user id        int   id           result    this- gt connection- gt query  sql            return  result- gt fetch PDO  FETCH ASSOC              http   php net manual en pdostatement fetch php                                    Print all row with column  user id  only      gateway    new Gateway     users       gateway- gt loadAll      no   1  foreach   users as  key   gt   value        echo  no           key       gt       value  user id       lt br   gt         no           Print user id   1 with all column      user    gateway- gt loadById 1     no   1  foreach   user as  key   gt   value        echo  no           key       gt       value     lt br   gt         no           Print user id   1 with column  email and password       user    gateway- gt loadById 1    echo  user  email    echo  user  password

User · Answer

Method   user    stmt- gt fetch PDO  FETCH ASSOC     returns a dictionary  You can simply get email and password    email    user  email     password    user  password      Other method   users    stmt- gt fetchall PDO  FETCH ASSOC     returns a list of a dictionary

User · Answer

PDOStatement  fetch returns a row from the result set  The parameter PDO  FETCH ASSOC tells PDO to return the result as an associative array   The array keys will match your column names  If your table contains columns  email  and  password   the array will be structured like   Array        email    gt   youremail yourhost com       password    gt   yourpassword      To read data from the  email  column  do    user  email      and for  password     user  password

User · Answer

Loop through the array like any other Associative Array   while  data    datas- gt fetch  PDO  FETCH ASSOC           print  data  title     lt br gt         or   resultset    datas- gt fetchALL PDO  FETCH ASSOC    echo   lt pre gt    resultset   lt  pre gt

User · Answer

To read the result you can read it like a simple php array   For example  getting the name can be done like  user  name    and so on  The method fetch PDO  FETCH ASSOC  will only return 1 tuple tho  If you want to get all tuples  you can use fetchall PDO  FETCH ASSOC   You can go through the multidimensional array and get the values just the same

User · Answer

PDO FETCH ASSOC puts the results in an array where values are mapped to their field names   You can access the name field like this   user  name     I recommend using PDO  FETCH OBJ  It fetches fields in an object and you can access like this   user- gt name

[php] How to read fetch(PDO::FETCH_ASSOC);

Examples related to php

Examples related to pdo